36
edits
Changes
→Tables SQL: Add underscore in table name and add table llx_product_batch
Line 24:
Line 24:
* [[Table llx product fournisseur price|llx product fournisseur price]] Contains prices proposed by suppliers for a product+
= Tables SQL =
= Tables SQL =
* [[Table llx_product|llx_product]] Contains products and services
* [[Table llx_product|llx_product]] Contains products and services
−* [[Table llx product fournisseur|llx product fournisseur]] Contains links between products and suppliers
+* [[Table llx_product_fournisseur_price|llx_product_fournisseur_price]] Contains prices proposed by suppliers for a product
−* [[Table llx_product_fournisseur_price_log|llx_product_fournisseur_price_log]] Contains historic of change for supplierss prices
−* [[Table llx product fournisseur price log|llx product fournisseur price log]] Contains historic of change for supplierss prices
+* [[Table llx_product_price|llx_product_price]] Contains prices for different levels of customers.
−* [[Table llx product price|llx product price]] Contains prices for different levels of customers.
+* [[Table llx_product_stock|llx_product_stock]] Contains stocks of a product
−* [[Table_llx_product_stock|llx_product_stock]] Contains stocks of a product
+* [[Table llx_product_batch|llx_product_batch]] Contains details of eat-by date / sell-by date / batch number for produtc