View erp.COMPIERE.RV_PROJECTLINEISSUE

 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 22  √  null
AD_ORG_ID number 22  √  null
ISACTIVE char 1  √  null
CREATED date 7  √  null
CREATEDBY number 22  √  null
UPDATED date 7  √  null
UPDATEDBY number 22  √  null
C_PROJECT_ID number 22  √  null
M_PRODUCT_ID number 22  √  null
C_PROJECTLINE_ID number 22  √  null
LINE number 22  √  null
DESCRIPTION nvarchar2 510  √  null
PLANNEDQTY number 22  √  null
PLANNEDPRICE number 22  √  null
PLANNEDAMT number 22  √  null
PLANNEDMARGINAMT number 22  √  null
COMMITTEDQTY number 22  √  null
C_PROJECTISSUE_ID number 22  √  null
M_LOCATOR_ID number 22  √  null
MOVEMENTQTY number 22  √  null
MOVEMENTDATE date 7  √  null
ISSUELINE number 22  √  null
ISSUEDESCRIPTION nvarchar2 510  √  null
M_INOUTLINE_ID number 22  √  null
S_TIMEEXPENSELINE_ID number 22  √  null
C_ACCTSCHEMA_ID number 10  √  null
C_ACCTSCHEMA C_ACCTSCHEMA_ID Implied Constraint
ACCOUNT_ID number 10  √  null
AMTSOURCEDR number 22  √  null
AMTSOURCECR number 22  √  null
AMTACCTDR number 22  √  null
AMTACCTCR number 22  √  null
LINEMARGIN number 22  √  null
View SQL:
SELECT COALESCE(l.AD_Client_ID,i.AD_Client_ID) AS AD_Client_ID,COALESCE(l.AD_Org_ID,i.AD_Org_ID) AS AD_Org_ID,
    COALESCE(l.IsActive,i.IsActive) AS IsActive,
    COALESCE(l.Created,i.Created) AS Created,COALESCE(l.CreatedBy,i.CreatedBy) AS CreatedBy,
    COALESCE(l.Updated,i.Updated) AS Updated,COALESCE(l.UpdatedBy,i.UpdatedBy) AS UpdatedBy,
    COALESCE(l.C_Project_ID,i.C_Project_ID) AS C_Project_ID,
    COALESCE(l.M_Product_ID,i.M_Product_ID) AS M_Product_ID,
    --
    l.C_ProjectLine_ID, l.Line, l.Description, l.PlannedQty, l.PlannedPrice, l.PlannedAmt, 
    l.PlannedMarginAmt, l.CommittedQty,
    --
    i.C_ProjectIssue_ID, i.M_Locator_ID, i.MovementQty, i.MovementDate,
    i.Line AS IssueLine, i.Description AS IssueDescription,
    i.M_InOutLine_ID, i.S_TimeExpenseLine_ID,
    --
    fa.C_AcctSchema_ID, fa.Account_ID, 
    fa.AmtSourceDr, fa.AmtSourceCr, fa.AmtAcctDr, fa.AmtAcctCr,
    --
    l.PlannedAmt-fa.AmtSourceDr+fa.AmtSourceCr AS LineMargin
FROM C_ProjectLine l
    FULL JOIN C_ProjectIssue i ON (i.C_Project_ID=l.C_Project_ID AND i.C_ProjectIssue_ID=l.C_ProjectIssue_ID)
    LEFT OUTER JOIN Fact_Acct fa ON (fa.AD_Table_ID=623 AND fa.Record_ID=i.C_ProjectIssue_ID AND fa.M_Locator_ID IS NULL)


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.