Table llx contratdet

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 details of contrats. This table is linked to Table llx_contrat

Fr verysmall.png Contient les détails des contrats, cette table est liée avec la Table llx_contrat

Es verysmall.png Contiene los detalles de los contratos, esta tabla está vinculada con Table llx_contrat

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
tms timestamp NO Current date Date of last modification. See page Field Tms.
fk_contrat int(11) NO MUL ID of contrat (llx_contrat->rowid)
fk_product int(11) YES MUL 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) YES NULL ID of discount (llx_societe_remise_except->rowid)
date_commande datetime YES NULL date of order
date_ouverture_prevue datetime YES MUL NULL open service date
date_ouverture datetime YES MUL NULL client open service date
date_fin_validite datetime YES MUL NULL end service date
date_cloture datetime YES NULL close service date
tva_tx double(6,3) YES 0.000 VAT taxes
qty real NO Quantity of product or service
remise_percent real YES 0 discount percentage
subprice double(24,8) YES 0.00000000 unit price
price_ht real YES NULL price excluding tax
remise real YES 0 discount amount
total_ht double(24,8) YES NULL total excluding taxes
total_tva double(24,8) YES NULL total tax
total_localtax1 double(24,8) YES NULL total local tax 1
total_localtax2 double(24,8) YES NULL total local tax 2
total_ttc double(24,8) YES NULL Total including discount and taxes (vat + localtax1 + localtax2)
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)
commentaire text YES NULL comment

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
idx_contratdet_fk_contrat MULTIPLE fk_contrat
idx_contratdet_fk_product MULTIPLE fk_product
idx_contratdet_date_ouverture_prevue MULTIPLE date_ouverture_prevue
idx_contratdet_date_ouverture MULTIPLE date_ouverture
idx_contratdet_date_fin_validite MULTIPLE date_fin_validite