Difference between revisions of "Table llx commande fournisseurdet"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 32: Line 32:
 
| technical index
 
| 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
 +
|}

Revision as of 17:09, 3 June 2009


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Contenu

Fr verysmall.png Contient le détail des lignes de commandes fournisseurs.

En verysmall.png Contains the details of provider orders lines.

Es verysmall.png Contiene los detalles de las líneas de los pedidos a proveedores.

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
fk_commande int(11) YES NULL ID of order (llx commande->rowid)
fk_product int(11) YES NULL ID of 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
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_commande_fournisseurdet&oldid=12467"