Difference between revisions of "Table llx contratdet"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 26: Line 26:
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| tms
 +
| timestamp
 +
| NO
 +
|
 +
| CURRENT_TIMESTAMP
 +
|
 +
| last update date
 +
|-
 +
| fk_contrat
 +
| int(11)
 +
|
 +
|
 +
|
 +
|
 +
| ID of contrat ([[Table llx_contrat|llx_contrat]]->rowid)
 +
|-
 +
| fk_product
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of product ([[Table llx_product|llx_product]]->rowid)
 +
|-
 +
| statut
 +
| smallint(6)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| state
 +
|-
 +
| label
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| label of product
 +
|-
 +
| description
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| product or service description
 +
| fk_remise_except
 +
| int(11)
 +
|
 +
|
 +
| NULL
 +
|
 +
| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
 +
|-
 +
| date_commande
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date of order
 +
|-
 +
| date_ouverture_prevue
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| open service date
 +
|-
 +
| date_ouverture
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| client open service date
 +
|-
 +
| date_fin_validite
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| end service date
 +
|-
 +
| date_cloture
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| close service date
 +
|-
 +
| tva_tx
 +
| double(6,3)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| VAT taxes
 +
|-
 +
| qty
 +
| double
 +
|
 +
|
 +
|
 +
|
 +
| Quantity of product or service
 +
|-
 +
| remise_percent
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount percentage
 +
|-
 +
| subprice
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| unit price
 +
|-
 +
| price_ht
 +
| double
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| price excluding tax
 +
|-
 +
| remise
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
|
 +
| discount amount
 +
|-
 +
| total_ht
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| total excluding tax
 +
|-
 +
| total_tva
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| total tax
 +
|-
 +
| total_ttc
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| total with tax
 +
|-
 +
| info_bits
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| TVA NPR or not
 +
|-
 +
| fk_user_author
 +
| int(11)
 +
|
 +
|
 +
| 0 
 +
|
 +
| ID creator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_ouverture
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID activator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_cloture
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID closer user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| comentaire
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| comentary
 
|}
 
|}

Revision as of 14:37, 8 June 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

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
tms timestamp NO CURRENT_TIMESTAMP last update date
fk_contrat int(11) ID of contrat (llx_contrat->rowid)
fk_product int(11) YES NULL ID of product (llx_product->rowid)
statut smallint(6) YES 0 state
label text YES NULL label of product
description text YES NULL product or service description fk_remise_except int(11) NULL ID of discount (llx_societe_remise_except->rowid)
date_commande datetime YES NULL date of order
date_ouverture_prevue datetime YES NULL open service date
date_ouverture datetime YES NULL client open service date
date_fin_validite datetime YES NULL end service date
date_cloture datetime YES NULL close service date
tva_tx double(6,3) YES 0.00 VAT taxes
qty double Quantity of product or service
remise_percent double YES 0 discount percentage
subprice double(24,8) YES 0.00 unit price
price_ht double YES NULL price excluding tax
remise double YES 0 discount amount
total_ht double(24,8) YES 0.00 total excluding tax
total_tva double(24,8) YES 0.00 total tax
total_ttc double(24,8) YES 0.00 total with tax
info_bits int(11) YES 0 TVA NPR or not
fk_user_author int(11) 0 ID creator user (llx_user->rowid)
fk_user_ouverture int(11) YES NULL ID activator user (llx_user->rowid)
fk_user_cloture int(11) YES NULL ID closer user (llx_user->rowid)
comentaire text YES NULL comentary
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_contratdet&oldid=12554"