Table idempiere9.adempiere.t_inventoryvalue
T_InventoryValue

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_pinstance_id numeric 10
ad_pinstance.ad_pinstance_id adpinstance_tinventoryvalue C
Instance of the process
m_warehouse_id numeric 10
m_warehouse.m_warehouse_id mwarehouse_tinventoryvalue C
Storage Warehouse and Service Point
m_product_id numeric 10
m_product.m_product_id mproduct_tinventoryvalue C
Product, Service, Item
m_attributesetinstance_id numeric 10
m_attributesetinstance.m_attributesetinstance_id masi_tinventoryvalue C
Product Attribute Set Instance
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
m_pricelist_version_id numeric 10  √  null
m_pricelist_version.m_pricelist_version_id mplversion_tinventoryvalue C
Identifies a unique instance of a Price List
datevalue timestamp 29,6  √  null Date of valuation
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_tinventoryvalue C
The Currency for this record
qtyonhand numeric 0  √  0 On Hand Quantity
pricepo numeric 0  √  0 Price based on a purchase order
pricelist numeric 0  √  0 List Price
pricestd numeric 0  √  0 Standard Price
pricelimit numeric 0  √  0 Lowest price for a product
coststandard numeric 0  √  0 Standard Costs
cost numeric 0  √  0 Cost information
pricepoamt numeric 0  √  0 Valuation with PO Price
pricelistamt numeric 0  √  0 Valuation with List Price
pricestdamt numeric 0  √  0 Valuation with standard price
pricelimitamt numeric 0  √  0 Value with limit price
coststandardamt numeric 0  √  0 Value in Standard Costs
costamt numeric 0  √  0 Value with Cost
m_costelement_id numeric 10  √  null
m_costelement.m_costelement_id mcostelement_tinventoryvalue C
Product Cost Element
t_inventoryvalue_uu varchar 36  √  NULL::character varying T_InventoryValue_UU

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_pinstance_id + m_warehouse_id + m_product_id + m_attributesetinstance_id Primary key Asc/Asc/Asc/Asc t_inventoryvalue_pkey
t_inventoryvalue_uu Must be unique Asc t_inventoryvalue_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.