28,967
edits
Changes
m
→Table
Line 34:
Line 34:
|-+| 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
| info_bits+| int(11)
−| YES
−|
−| 0
−|
−| TVA NPR or not
−|-
| special_code+| int(10)
−| YES
−|
−| 0
−| UNSIGNED
−| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
| 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}}
−|-
|-
| product_type
| product_type
Line 160:
Line 145:
| end date if service
| end date if service
|-
|-
−{{FieldInfoBits}}
−| 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)
|-
|-
−{{FieldSpecialCode}}
−|-
|-
| rang
| rang