Dolibarr ERP CRM Wiki

Changes

Table llx propaldet (view source)

Revision as of 07:22, 3 September 2009

1,712 bytes added ,  15 years ago
→‎Structure
Line 30: Line 30:  
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| fk_propal
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of order ([[Table llx_propal|llx_propal]]->rowid)
 +
|-
 +
| fk_product
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of product ([[Table llx_product|llx_product]]->rowid)
 +
|-
 +
| 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)
 +
|-
 +
| tva_tx
 +
| double(6,3)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| VAT taxes
 +
|-
 +
| qty
 +
| double
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| Quantity of product or service
 +
|-
 +
| remise_percent
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount percentage
 +
|-
 +
| remise
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount amount (obsolete)
 +
|-
 +
| price
 +
| double
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| final price (obsolete)
 +
|-
 +
| subprice
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| price before discount
 +
|-
 +
| 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
 +
|-
 +
| product_type
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| type of prodcut
 +
|-
 +
| date_start
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| start date if service
 +
|-
 +
| date_end
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| end date if service
 +
|-
 +
| info_bits
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| TVA NPR or not
 +
|-
 +
| pa_ht
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| purchase price HT
 +
|-
 +
| marge_tx
 +
| double(6,3)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| margin (margin on purchase price)
 +
|-
 +
| marque_tx
 +
| double(6,3)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| mark rate (margin on selling price)
 +
|-
 +
| special_code
 +
| tinyint(4)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
 +
|-
 +
| rang
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| order view
 
|}
 
|}
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/15635"