28,939
edits
Changes
Table llx product fournisseur price (view source)
Revision as of 12:47, 10 August 2012
, 12 years ago→Table
Line 42:
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_soc
+| int(11)
+| NO
+| MUL
+| NULL
|
|
−| last update date
+| ID of thirdparty ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
−| fk_product_fornisseur
+| ref_fourn
−| int(11)
+| varchar(30)
| NO
| NO
| MUL
| MUL
| NULL
| NULL
|
|
−| ID of supplied product ([[Table llx_product_fournisseur|llx_product_fornisseur]]->rowid)
+| Ref for supplier
|-
|-
| fk_availability
| fk_availability
| int(11)
| int(11)
−| NO
+| YES
|
|
|
|
Line 90:
Line 99:
|
|
| price unitary
| price unitary
+|-
+| tva_tx
+| double(6,3)
+| YES
+|
+| 0.00000000
+|
+| vat rate
|-
|-
| fk_user
| fk_user
Line 114:
Line 131:
| fk_user
| fk_user
|-
|-
−| idx_product_fournisseur_price_fk_product_fournisseur
+| 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
| MULTIPLE
−| fk_product_fournisseur
+| ref_fourn, fk_soc, quantity, entity
|}
|}