| Table T_InventoryValue |
| PRIMARY KEY | ||
|
AD_PInstance_ID
NUMBER (10, 0) NOT NULL | AD_PInstance | |
|
M_Warehouse_ID
NUMBER (10, 0) NOT NULL | M_Warehouse | |
|
M_Product_ID
NUMBER (10, 0) NOT NULL | M_Product | |
|
AD_Client_ID
NUMBER (10, 0) NOT NULL | ||
|
AD_Org_ID
NUMBER (10, 0) NOT NULL | ||
|
M_PriceList_Version_ID
NUMBER (10, 0) | M_PriceList_Version | |
|
DateValue
DATE | ||
|
C_Currency_ID
NUMBER (10, 0) | C_Currency | |
|
QtyOnHand
NUMBER default: 0 | ||
|
PricePO
NUMBER default: 0 | ||
|
PriceList
NUMBER default: 0 | ||
|
PriceStd
NUMBER default: 0 | ||
|
PriceLimit
NUMBER default: 0 | ||
|
CostStandard
NUMBER default: 0 | ||
|
PricePOAmt
NUMBER default: 0 | ||
|
PriceListAmt
NUMBER default: 0 | ||
|
PriceStdAmt
NUMBER default: 0 | ||
|
PriceLimitAmt
NUMBER default: 0 | ||
|
CostStandardAmt
NUMBER default: 0 | ||
FOREIGN KEY ADPInstance_TInventoryValue: AD_PInstance_ID => AD_PInstance CCurrency_TInventoryValue: C_Currency_ID => C_Currency MPLVersion_TInventoryValue: M_PriceList_Version_ID => M_PriceList_Version MProduct_TInventoryValue: M_Product_ID => M_Product MWarehouse_TInventoryValue: M_Warehouse_ID => M_Warehouse | ||