28,939
edits
Changes
Table llx product fournisseur price (view source)
Revision as of 12:47, 10 August 2012
, 12 years ago→Table
Line 12:
Line 12:
| last update date
+
{{flag en}} Contains the price of products by each supplier.
{{flag en}} Contains the price of products by each supplier.
−{{flag fr}} Contient des produits prix par chaque fournisseur.
+{{flag fr}} Contient les prix des produits de chaque fournisseur.
{{flag sp}} Contiene los precios de los productos de cada proveedor.
{{flag sp}} Contiene los precios de los productos de cada proveedor.
= Structure =
= Structure =
−{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+== Table ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Type</b>
Line 28:
Line 29:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
Line 41:
Line 42:
|
|
| creation date
| creation date
+{{FieldTms}}
|-
|-
−| tms
+| fk_product
−| timestamp
+| int(11)
| NO
| NO
+| MUL
+| NULL
|
|
−| CURRENT_TIMESTAMP
+| ID of supplied product ([[Table llx_product|llx_product]]->rowid)
−|
−|-
|-
−| fk_product_fornisseur
+| fk_soc
| int(11)
| int(11)
| NO
| NO
+| MUL
+| NULL
|
|
+| ID of thirdparty ([[Table llx_societe|llx_societe]]->rowid)
+|-
+| ref_fourn
+| varchar(30)
+| NO
+| MUL
| NULL
| NULL
|
|
−| ID of supplied product ([[Table llx_product_fournisseur|llx_product_fornisseur]]->rowid)
+| Ref for supplier
+|-
+| fk_availability
+| int(11)
+| YES
+|
+|
+|
+| ID of availability ([[Table llx_c_availability|llx_c_availability]]->rowid)
|-
|-
| price
| price
−| double(28,10)
+| double(24,8)
| YES
| YES
|
|
−| 0
+| 0,00000000
|
|
| price
| price
Line 75:
Line 93:
|-
|-
| unitprice
| unitprice
−| double(28,10)
+| double(24,8)
| YES
| YES
|
|
−| 0
+| 0.00000000
|
|
| price unitary
| price unitary
+|-
+| tva_tx
+| double(6,3)
+| YES
+|
+| 0.00000000
+|
+| vat rate
|-
|-
| fk_user
| fk_user
| int(11)
| int(11)
| YES
| YES
−|
+| MUL
| NULL
| NULL
|
|
| ID last modifier user ([[Table llx_user|llx_user]]->rowid)
| ID last modifier user ([[Table llx_user|llx_user]]->rowid)
−|}
+|}
+== 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
+|-
+| idx_product_fournisseur_price_fk_user
+| MULTIPLE
+| fk_user
+|-
+| idx_product_fournisseur_price_fk_product
+| MULTIPLE
+| fk_product, entity
+|-
+| idx_product_fournisseur_price_fk_soc
+| MULTIPLE
+| fk_soc, entity
+|-
+| uk_product_fournisseur_price_ref
+| MULTIPLE
+| ref_fourn, fk_soc, quantity, entity
+|}