Dolibarr ERP CRM Wiki

Changes

Table llx contratdet (view source)

Revision as of 14:37, 8 June 2009

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