Difference between revisions of "Table llx paiementcharge"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
Line 5: Line 5:
 
{{ListOfTables}}
 
{{ListOfTables}}
  
−
= Contenu =
 
  
 +
= Content/Contenu/Contenido =
 +
{{flag en}} Contains the payments made for taxes and social contributions.
 +
 +
{{flag fr}} Contient les paiements relatifs aux taxes et charges sociales.
 +
 +
{{flag sp}} Contiene los pagos relativos a los impuestos y cargas sociales.
  
 
= Structure =
 
= Structure =
Line 25: Line 30:
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| fk_charge
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of contribution ([[Table llx_chargesociales|llx_chargesociales]]->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_typepayment
 +
| 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)
 
|}
 
|}

Revision as of 08:19, 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


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

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
fk_charge int(11) YES NULL ID of contribution (llx_chargesociales->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_typepayment 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)
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_paiementcharge&oldid=14873"