Table llx contratdet: Difference between revisions

Jump to navigation Jump to search

Table llx contratdet (view source)

Revision as of 14:37, 8 June 2009

1,950 bytes added ,  17 years ago
→‎Structure
VisualWikitext
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/Special:MobileDiff/12554"

Navigation menu