Difference between revisions of "Table llx paiement"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 30: Line 30:
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| fk_facture
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of invoice ([[Table llx_facture|llx_facture]]->rowid)
 +
|-
 +
| datec
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| creation date
 +
|-
 +
| tms
 +
| timestamp
 +
| YES
 +
|
 +
| CURRENT_TIMESTAMP
 +
|
 +
| last update date
 +
|-
 +
| datep
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| payment date
 +
|-
 +
| amount
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| amount of payment
 +
|-
 +
| fk_payment
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID type of payment ([[Table llx_c_paiement|llx_c_paiement]]->id)
 +
|-
 +
| num_payment
 +
| varchar(50)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| number of payment
 +
|-
 +
| note
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| comentary
 +
|-
 +
| fk_bank
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| ID of bank to pay ([[Table llx_bank_account|llx_bank_account]]->rowid)
 +
|-
 +
| fk_user_creat
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_modif
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of last modifier user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| statut
 +
| smallint(6)
 +
| NO
 +
|
 +
| 0
 +
|
 +
| status of payment (0 or 1: 1=not deletable)
 +
|-
 +
| fk_export_compta
 +
| int(11)
 +
| NO
 +
|
 +
| 0
 +
|
 +
| ID of accountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid, 0 not exported)
 
|}
 
|}

Revision as of 07:52, 11 August 2009


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Contenu

Fr verysmall.png Contient les paiements relatifs aux factures clients. La relation entre une facture client et le paiement correspondant se trouve dans la Table llx_paiement_facture

En verysmall.png Contains the payments made for client invoices. The relation between a client invoice and the corresponding payment is in Table llx_paiement_facture

Es verysmall.png Contiene los pagos relativos a las facturas a clientes. La relación entre una factura a cliente y el pago correspondiente se en cuentra en Table llx_paiement_facture

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
fk_facture int(11) YES NULL ID of invoice (llx_facture->rowid)
datec datetime YES NULL creation date
tms timestamp YES CURRENT_TIMESTAMP last update date
datep datetime YES NULL payment date
amount real YES 0 amount of payment
fk_payment int(11) YES NULL 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) YES 0 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)
statut smallint(6) NO 0 status of payment (0 or 1: 1=not deletable)
fk_export_compta int(11) NO 0 ID of accountacy export (llx_export_compta->rowid, 0 not exported)
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_paiement&oldid=14868"