Dolibarr ERP CRM Wiki

Changes

Table llx product fournisseur price (view source)

Revision as of 08:31, 1 September 2009

847 bytes added ,  15 years ago
no edit summary
Line 3: Line 3:  
[[Category:Product]]
 
[[Category:Product]]
 
[[Category:Productos]]
 
[[Category:Productos]]
 +
[[Category:Fournisseur]]
 +
[[Category:Supplier]]
 +
[[Category:Proveedores]]
    
{{ListOfTables}}
 
{{ListOfTables}}
   −
= Contenu =
+
= Content/Contenu/Contenido =
 +
{{flag en}} Contains the price of products by each supplier.
    +
{{flag fr}} Contient des produits prix par chaque fournisseur.
 +
 +
{{flag sp}} Contiene los precios de los productos de cada proveedor.
    
= Structure =
 
= Structure =
Line 26: Line 33:  
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| datec
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| creation date
 +
|-
 +
| tms
 +
| timestamp
 +
| NO
 +
|
 +
| CURRENT_TIMESTAMP
 +
|
 +
| last update date
 +
|-
 +
| fk_product_fornisseur
 +
| int(11)
 +
| NO
 +
|
 +
| NULL
 +
|
 +
| ID of supplied product ([[Table llx_product_fournisseur|llx_product_fornisseur]]->rowid)
 +
|-
 +
| price
 +
| double(28,10)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| price
 +
|-
 +
| quantity
 +
| double
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| quantity of product
 +
|-
 +
| unitprice
 +
| double(28,10)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| price unitary
 +
|-
 +
| fk_user
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID last modifier user ([[Table llx_user|llx_user]]->rowid)
 
|}
 
|}
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/15605"