View erp.COMPIERE.C_PROJECT_DETAILS_VT

 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
AD_LANGUAGE varchar2 6
AD_LANGUAGE AD_LANGUAGE Implied Constraint
C_PROJECT_ID number 10
C_PROJECT C_PROJECT_ID Implied Constraint
C_PROJECTLINE_ID number 10
C_PROJECTLINE C_PROJECTLINE_ID Implied Constraint
LINE number 10
PLANNEDQTY number 22
PLANNEDPRICE number 22
PLANNEDAMT number 22
PLANNEDMARGINAMT number 22
COMMITTEDAMT number 22  √  null
M_PRODUCT_ID number 10  √  null
M_PRODUCT M_PRODUCT_ID Implied Constraint
NAME nvarchar2 510  √  null
DESCRIPTION nvarchar2 510  √  null
DOCUMENTNOTE nvarchar2 4000  √  null
UPC varchar2 30  √  null
SKU varchar2 30  √  null
PRODUCTVALUE nvarchar2 80  √  null
M_PRODUCT_CATEGORY_ID number 10  √  null
M_PRODUCT_CATEGORY M_PRODUCT_CATEGORY_ID Implied Constraint
INVOICEDAMT number 22
INVOICEDQTY number 22
COMMITTEDQTY number 22  √  null
View SQL:
SELECT pl.AD_Client_ID, pl.AD_Org_ID, pl.IsActive, pl.Created, pl.CreatedBy, pl.Updated, pl.UpdatedBy,
l.AD_Language,
    pj.C_Project_ID, pl.C_ProjectLine_ID,
    pl.Line, 
    pl.PlannedQty, pl.PlannedPrice, pl.PlannedAmt, pl.PlannedMarginAmt,
    pl.CommittedAmt,
    pl.M_Product_ID,
COALESCE(p.Name, pl.Description) AS Name, -- main line
CASE WHEN p.Name IS NOT NULL THEN pl.Description END AS Description, -- second line
p.DocumentNote, -- third line
    p.UPC, p.SKU, p.Value AS ProductValue,
    pl.M_Product_Category_ID,
    pl.InvoicedAmt, pl.InvoicedQty, pl.CommittedQty
FROM C_ProjectLine pl
  INNER JOIN C_Project pj ON (pl.C_Project_ID=pj.C_Project_ID)
  LEFT OUTER JOIN M_Product p ON (pl.M_Product_ID=p.M_Product_ID)
  INNER JOIN AD_Language l ON (l.IsSystemLanguage='Y')
WHERE pl.IsPrinted='Y'
  


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.