View almasdd.COMPIERE.RV_PROJECTCYCLE

 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
C_CYCLE_ID number 10
C_CYCLE C_CYCLE_ID Implied Constraint
CYCLENAME nvarchar2 120
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
C_CYCLESTEP_ID number 10
C_CYCLESTEP C_CYCLESTEP_ID Implied Constraint
CYCLESTEPNAME nvarchar2 120
SEQNO number 10
RELATIVEWEIGHT number 22
C_PHASE_ID number 10
C_PHASE C_PHASE_ID Implied Constraint
PROJECTPHASENAME nvarchar2 120
C_PROJECTTYPE_ID number 10
C_PROJECTTYPE C_PROJECTTYPE_ID Implied Constraint
PROJECTTYPENAME nvarchar2 120
PROJECTVALUE nvarchar2 80
PROJECTNAME nvarchar2 120
DESCRIPTION nvarchar2 510  √  null
NOTE nvarchar2 4000  √  null
C_BPARTNER_ID number 10  √  null
C_BPARTNER C_BPARTNER_ID Implied Constraint
C_BPARTNER_LOCATION_ID number 10  √  null
C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID Implied Constraint
AD_USER_ID number 10  √  null
AD_USER AD_USER_ID Implied Constraint
POREFERENCE nvarchar2 40  √  null
SALESREP_ID number 10  √  null
M_WAREHOUSE_ID number 10  √  null
M_WAREHOUSE M_WAREHOUSE_ID Implied Constraint
PROJECTCATEGORY char 1  √  null
DATECONTRACT date 7  √  null
DATEFINISH date 7  √  null
ISCOMMITMENT char 1
ISCOMMITCEILING char 1
COMMITTEDQTY number 22  √  null
COMMITTEDAMT number 22  √  null
PLANNEDQTY number 22  √  null
PLANNEDAMT number 22  √  null
PLANNEDMARGINAMT number 22  √  null
INVOICEDAMT number 22  √  null
INVOICEDQTY number 22  √  null
PROJECTBALANCEAMT number 22  √  null
View SQL:
SELECT p.AD_Client_ID, p.AD_Org_ID, p.IsActive, p.Created,p.CreatedBy, p.Updated,p.UpdatedBy,
    c.C_Cycle_ID, c.Name AS CycleName, c.C_Currency_ID,
    cs.C_CycleStep_ID, cs.Name AS CycleStepName, cs.SeqNo, cs.RelativeWeight,
    pp.C_Phase_ID, pp.Name AS ProjectPhaseName, 
    pt.C_ProjectType_ID, pt.Name AS ProjectTypeName,
    p.Value AS ProjectValue, p.Name AS ProjectName, p.Description, p.Note, 
    p.C_BPartner_ID, p.C_BPartner_Location_ID, p.AD_User_ID, p.POReference,
    p.SalesRep_ID, p.M_Warehouse_ID, p.ProjectCategory,
    p.DateContract, p.DateFinish,
    p.IsCommitment, p.IsCommitCeiling, 
    p.CommittedQty*cs.RelativeWeight AS CommittedQty,
    currencyConvert (p.CommittedAmt, p.C_Currency_ID, c.C_Currency_ID, getdate(),0, p.AD_Client_ID, p.AD_Org_ID)*cs.RelativeWeight AS CommittedAmt,
    p.PlannedQty*cs.RelativeWeight AS PlannedQty, 
    currencyConvert (p.PlannedAmt, p.C_Currency_ID, c.C_Currency_ID, getdate(),0, p.AD_Client_ID, p.AD_Org_ID)*cs.RelativeWeight AS PlannedAmt, 
    currencyConvert (p.PlannedMarginAmt, p.C_Currency_ID, c.C_Currency_ID, getdate(),0, p.AD_Client_ID, p.AD_Org_ID)*cs.RelativeWeight AS PlannedMarginAmt,
    currencyConvert (p.InvoicedAmt, p.C_Currency_ID, c.C_Currency_ID, getdate(),0, p.AD_Client_ID, p.AD_Org_ID)*cs.RelativeWeight AS InvoicedAmt, 
    p.InvoicedQty*cs.RelativeWeight AS InvoicedQty,
    currencyConvert (p.ProjectBalanceAmt, p.C_Currency_ID, c.C_Currency_ID, getdate(),0, p.AD_Client_ID, p.AD_Org_ID)*cs.RelativeWeight AS ProjectBalanceAmt
FROM C_Cycle c
  INNER JOIN C_CycleStep cs ON (c.C_Cycle_ID=cs.C_Cycle_ID)
  INNER JOIN C_CyclePhase cp ON (cs.C_CycleStep_ID=cp.C_CycleStep_ID)
  INNER JOIN C_Phase pp ON (cp.C_Phase_ID=pp.C_Phase_ID)
  INNER JOIN C_Project p ON (cp.C_Phase_ID=p.C_Phase_ID)
  INNER JOIN C_ProjectType pt ON (p.C_ProjectType_ID=pt.C_ProjectType_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.