Table llx paiementcharge

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅:Table SQL


Content/Contenu/Contenido

En verysmall.png Contains the payments made for taxes and social contributions.

Fr verysmall.png Contient les paiements relatifs aux taxes et charges sociales.

Es verysmall.png Contiene los pagos relativos a los impuestos y cargas sociales.

Structure

Table

Version 1.1 2009/10/07

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
fk_charge int(11) YES NULL ID of contribution (llx_chargesociales->rowid)
datec datetime YES NULL creation date
tms timestamp NO Current date Date of last modification. See page Field Tms.
datep datetime YES NULL payment date
amount real YES 0 amount of payment
fk_typepayment int(11) NO ID type of payment (llx_c_paiement->id)
num_payment varchar(50) YES NULL number of payment
note text YES NULL comentary
fk_bank int(11) NO ID of bank to pay (llx_bank_account->rowid)
fk_user_creat int(11) YES NULL ID of creator user (llx_user->rowid)
fk_user_modif int(11) YES NULL ID of last modifier user (llx_user->rowid)

 

Keys

Version 1.1 2009/10/07

Key Type Fields
PRIMARY PRIMARY rowid