View erp.COMPIERE.RV_COST

 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
CREATED date 7
CREATEDBY number 10
UPDATED date 7
UPDATEDBY number 10
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
M_COSTELEMENT_ID number 10
M_COSTELEMENT M_COSTELEMENT_ID Implied Constraint
COSTELEMENTTYPE char 1
COSTINGMETHOD char 1  √  null
ISCALCULATED char 1
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
FUTURECOSTPRICE number 22  √  null
DESCRIPTION nvarchar2 510  √  null
View SQL:
SELECT  c.AD_Client_ID, c.AD_Org_ID, c.IsActive, c.Created,c.CreatedBy,c.Updated,c.UpdatedBy,
    p.M_Product_ID, p.Value, p.Name, p.UPC, p.IsBOM, p.ProductType, p.M_Product_Category_ID,
    c.M_CostType_ID, 
    ce.M_CostElement_ID, ce.CostElementType, ce.CostingMethod, ce.IsCalculated, 
    acct.C_AcctSchema_ID, acct.C_Currency_ID,
    c.CurrentCostPrice, c.FutureCostPrice, c.Description
FROM M_Cost c
  INNER JOIN M_Product p ON (c.M_Product_ID=p.M_Product_ID)
  INNER JOIN M_CostElement ce ON (c.M_CostElement_ID=ce.M_CostElement_ID)
  INNER JOIN C_AcctSchema acct ON (c.C_AcctSchema_ID=acct.C_AcctSchema_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.