Table llx commandedet: Difference between revisions

m
Tag: 2017 source edit
 
(7 intermediate revisions by 2 users not shown)
Line 34: Line 34:
| fk_commande  
| fk_commande  
| int(11)  
| int(11)  
| YES
| NO
| MUL
| MUL
| NULL
|  
|  
|  
| ID of order ([[Table llx commande|llx commande]]->rowid)
| ID of order ([[Table llx commande|llx commande]]->rowid)
|-  
|-  
| fk_parent_line
| int(11)
| YES
|
| NULL
|
| Since ?
|-
| fk_product
| fk_product
| int(11)
| int(11)
Line 111: Line 119:
|  
|  
| price before discount
| price before discount
|-
{{FieldTotalFields}}
| total_ht
| double(24,8)
| YES
|
| 0.00000000
|
| total excluding tax
|-
| total_tva
| double(24,8)
| YES
|
| 0.00000000
|
| total tax
|-
| total_ttc
| double(24,8)
| YES
|
| 0.00000000
|
| total with tax
|-
|-
| product_type
| product_type
Line 160: Line 145:
| end date if service
| end date if service
|-
|-
| info_bits
{{FieldInfoBits}}
| int(11)
| YES
|
| 0
|
| TVA NPR or not
|-
| marge_tx
| marge_tx
| double(6,3)
| double(6,3)
Line 184: Line 162:
| mark rate (margin on selling price)
| mark rate (margin on selling price)
|-
|-
| special_code
{{FieldSpecialCode}}
| int(10)
| YES
|
| 0
| UNSIGNED
| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
|-
|-
| rang
| rang
Line 200: Line 172:
| order view
| order view
|-
|-
| import_key
{{FieldImportKey}}
| varchar(14)
| YES
|
| NULL
|
| import key
|} 
|}