View almasdd.COMPIERE.RV_COSTDETAIL

 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_INOUTLINE_ID number 10  √  null
M_INOUTLINE M_INOUTLINE_ID Implied Constraint
C_INVOICELINE_ID number 10  √  null
C_INVOICELINE C_INVOICELINE_ID Implied Constraint
M_ATTRIBUTESETINSTANCE_ID number 10
M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID Implied Constraint
M_ATTRIBUTESET_ID number 10  √  null
M_ATTRIBUTESET M_ATTRIBUTESET_ID Implied Constraint
LOT nvarchar2 80  √  null
SERNO nvarchar2 80  √  null
C_ACCTSCHEMA_ID number 10
C_ACCTSCHEMA C_ACCTSCHEMA_ID Implied Constraint
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
AMT number 22
QTY number 22
DESCRIPTION nvarchar2 510  √  null
PROCESSED char 1
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_InOutLine_ID, c.C_InvoiceLine_ID,
    asi.M_AttributeSetInstance_ID, asi.M_AttributeSet_ID, asi.Lot, asi.SerNo,
    acct.C_AcctSchema_ID, acct.C_Currency_ID,
    c.Amt, c.Qty, c.Description, Processed
FROM M_CostDetail 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)
  INNER JOIN M_AttributeSetInstance asi ON (c.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_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.