View almasdd.COMPIERE.RV_PRODUCT_COSTING

 Generated by
SchemaSpy
Implied relationships Related columns Constraint names Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents
M_PRODUCT_ID number 10
M_PRODUCT M_PRODUCT_ID Implied Constraint
C_ACCTSCHEMA_ID number 10
C_ACCTSCHEMA C_ACCTSCHEMA_ID Implied Constraint
VALUE nvarchar2 80
NAME nvarchar2 120
M_PRODUCT_CATEGORY_ID number 10
M_PRODUCT_CATEGORY M_PRODUCT_CATEGORY_ID Implied Constraint
AD_CLIENT_ID number 10
AD_CLIENTINFO AD_CLIENT_ID Implied Constraint
AD_ORG_ID number 10
AD_ORGINFO AD_ORG_ID Implied Constraint
ISACTIVE char 1
CREATED date 7
CREATEDBY number 10
UPDATED date 7
UPDATEDBY number 10
CURRENTCOSTPRICE number 22
FUTURECOSTPRICE number 22
COSTSTANDARD number 22
COSTSTANDARDPOQTY number 22
COSTSTANDARDPOAMT number 22
COSTSTANDARDPODIFF number 22  √  null
COSTSTANDARDCUMQTY number 22
COSTSTANDARDCUMAMT number 22
COSTSTANDARDINVDIFF number 22  √  null
COSTAVERAGE number 22
COSTAVERAGECUMQTY number 22
COSTAVERAGECUMAMT number 22
TOTALINVQTY number 22
TOTALINVAMT number 22
TOTALINVCOST number 22  √  null
PRICELASTPO number 22
PRICELASTINV number 22
View SQL:
SELECT pc.M_Product_ID, pc.C_AcctSchema_ID, p.Value, p.Name, p.M_Product_Category_ID,
pc.AD_Client_ID, pc.AD_Org_ID, pc.IsActive, pc.Created,pc.CreatedBy,pc.Updated,pc.UpdatedBy,
pc.CurrentCostPrice,
-- Standard Costing
pc.FutureCostPrice, pc.CostStandard, 
pc.CostStandardPOQty, pc.CostStandardPOAmt, 
CASE WHEN pc.CostStandardPOQty=0 THEN 0 ELSE pc.CostStandardPOAmt/pc.CostStandardPOQty END AS CostStandardPODiff,
pc.CostStandardCumQty, pc.CostStandardCumAmt,
CASE WHEN pc.CostStandardCumQty=0 THEN 0 ELSE pc.CostStandardCumAmt/pc.CostStandardCumQty END AS CostStandardInvDiff,
-- Average Costing
pc.CostAverage,
pc.CostAverageCumQty, pc.CostAverageCumAmt,
pc.TotalInvQty, pc.TotalInvAmt,
CASE WHEN pc.TotalInvQty=0 THEN 0 ELSE pc.TotalInvAmt/pc.TotalInvQty END AS TotalInvCost,
-- LastPrice
pc.PriceLastPO, pc.PriceLastInv
FROM M_Product_Costing pc
  INNER JOIN M_Product p ON (pc.M_Product_ID=p.M_Product_ID)


SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.