Dolibarr ERP CRM Wiki

Changes

Table llx commande fournisseurdet (view source)

Revision as of 11:18, 25 July 2024

2,048 bytes added ,  8 months ago
m
no edit summary
Line 1: Line 1: −
[[Catégorie:Table SQL]]
+
[[Category:Table SQL]]
−
  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
+
[[Category:Fournisseur]]
−
  The documentation related to other tables is available on the tables list page: [[Liste des tables]]
+
[[Category:Supplier]]
 +
[[Category:Proveedores]]
   −
= Contenu =
+
{{ListOfTables}}
    +
= Content/Contenu/Contenido =
 +
 +
{{flag en}} Contains details of providers orders. This table is linked to [[Table llx_commande_fournisseur]]
 +
 +
{{flag fr}} Contient les détails des commandes fournisseurs, cette table est liée avec la [[Table llx_commande_fournisseur]]
 +
 +
{{flag sp}} Contiene los detalles de los pedidos a proveedores, esta tabla esta vinculada con [[Table llx_commande_fournisseur]]
    
= Structure =
 
= Structure =
 +
== Tables ==
 +
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 +
|style="background-color: #e9e9ef"| <b>Field</b>
 +
|style="background-color: #e9e9ef"| <b>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Null</b>
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Default</b>
 +
|style="background-color: #e9e9ef"| <b>Extra</b>
 +
|style="background-color: #e9e9ef"| <b>Description</b>
 +
|-
 +
| rowid
 +
| int(11)
 +
| NO
 +
| PRI
 +
|
 +
| auto_increment
 +
| technical index
 +
|-
 +
| fk_commande
 +
| int(11)
 +
| NO
 +
|
 +
|
 +
|
 +
| 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
 +
|
 +
| supplier ref. of product
 +
|-
 +
| label
 +
| varchar(255)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| label of product
 +
|-
 +
| description
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| product description
 +
|-
 +
| tva_tx
 +
| double(6,3)
 +
| YES
 +
|
 +
| 0.000
 +
|
 +
| VAT taxes
 +
|-
 +
| qty
 +
| real
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| Quantity of product
 +
|-
 +
| remise_percent
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount percentage
 +
|-
 +
| remise
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount amount
 +
|-
 +
| subprice
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00000000
 +
|
 +
| unit price before
 +
{{FieldTotalFields}}
 +
|-
 +
| 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
 +
|-
 +
{{FieldInfoBits}}
 +
}
 +
 +
== Keys ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Fields</b>
 +
|-
 +
| PRIMARY
 +
| PRIMARY
 +
| rowid
 +
|}&nbsp;
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/1601...60990"