Dolibarr ERP CRM Wiki

Changes

Table llx paiement (view source)

Revision as of 07:52, 11 August 2009

1,147 bytes added ,  15 years ago
→‎Structure
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)
 
|}
 
|}
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/14868"