Table llx commande fournisseurdet: Difference between revisions

Table llx commande fournisseurdet (view source)

1,161 bytes added , 17 years ago

4,395

edits

@@ Line 32: / Line 32: @@
 | technical index
 |-
+| fk_commande
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of order ([[Table llx commande|llx commande]]->rowid)
+|-
+| fk_product
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of product ([[Table llx_product|llx_product]]->rowid)
+|-
+| ref
+| varchar(50)
+| YES
+|
+| NULL
+|
+| ref. of product
+|-
+| label
+| varchar(255)
+| YES
+|
+| NULL
+|
+| label of product
+|-
+| description
+| text
+| YES
+|
+| NULL
+|
+| product description
+|-
+| tva_tx
+| double(6,3)
+| YES
+|
+| NULL
+|
+| VAT taxes
+|-
+| qty
+| double
+| YES
+|
+| NULL
+|
+| Quantity of product
+|-
+| remise_percent
+| double
+| YES
+|
+| 0
+|
+| discount percentage
+|-
+| remise
+| double
+| YES
+|
+| 0
+|
+| discount amount
+|-
+| subprice
+| double(24,8)
+| YES
+|
+| 0.00
+|
+| unit price before
+|-
+| 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 product
+|-
+| 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
+|}