View erp.COMPIERE.RV_COSTSUMMARY

 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
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
CREATEDBY number 22  √  null
CREATED date 8  √  null
UPDATEDBY number 22  √  null
UPDATED date 8  √  null
M_PRODUCT_ID number 10
M_PRODUCT M_PRODUCT_ID Implied Constraint
VALUE nvarchar2 80
NAME nvarchar2 120
UPC varchar2 30  √  null
ISBOM char 1
PRODUCTTYPE char 1
M_PRODUCT_CATEGORY_ID number 10
M_PRODUCT_CATEGORY M_PRODUCT_CATEGORY_ID Implied Constraint
M_COSTTYPE_ID number 10
M_COSTTYPE M_COSTTYPE_ID Implied Constraint
C_ACCTSCHEMA_ID number 10
C_ACCTSCHEMA C_ACCTSCHEMA_ID Implied Constraint
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
CURRENTCOSTPRICE number 22  √  null
FUTURECOSTPRICE number 22  √  null
View SQL:
SELECT  c.AD_Client_ID, c.AD_Org_ID, c.IsActive, 0 AS CreatedBy,SysDate AS Created,0 AS UpdatedBy,SysDate AS Updated,
    p.M_Product_ID, p.Value, p.Name, p.UPC, p.IsBOM, p.ProductType, p.M_Product_Category_ID,
    c.M_CostType_ID, 
    acct.C_AcctSchema_ID, acct.C_Currency_ID,
    SUM(c.CurrentCostPrice) AS CurrentCostPrice, SUM(c.FutureCostPrice) AS FutureCostPrice
FROM M_Cost c
  INNER JOIN M_Product p ON (c.M_Product_ID=p.M_Product_ID)
  INNER JOIN C_AcctSchema acct ON (c.C_AcctSchema_ID=acct.C_AcctSchema_ID)
WHERE acct.M_CostType_ID=c.M_CostType_ID
GROUP BY c.AD_Client_ID, c.AD_Org_ID, c.IsActive, 
    p.M_Product_ID, p.Value, p.Name, p.UPC, p.IsBOM, p.ProductType, p.M_Product_Category_ID,
    c.M_CostType_ID, acct.C_AcctSchema_ID, acct.C_Currency_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.