View erp.COMPIERE.RV_FACT_ACCT_PERIOD

 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
C_ACCTSCHEMA_ID number 10
C_ACCTSCHEMA C_ACCTSCHEMA_ID Implied Constraint
ACCOUNT_ID number 10
C_PERIOD_ID number 10  √  null
C_PERIOD C_PERIOD_ID Implied Constraint
GL_CATEGORY_ID number 10  √  null
GL_CATEGORY GL_CATEGORY_ID Implied Constraint
GL_BUDGET_ID number 10  √  null
GL_BUDGET GL_BUDGET_ID Implied Constraint
C_TAX_ID number 10  √  null
C_TAX C_TAX_ID Implied Constraint
M_LOCATOR_ID number 10  √  null
M_LOCATOR M_LOCATOR_ID Implied Constraint
POSTINGTYPE char 1
C_CURRENCY_ID number 10
C_CURRENCY C_CURRENCY_ID Implied Constraint
AMTSOURCEDR number 22  √  null
AMTSOURCECR number 22  √  null
AMTSOURCE number 22  √  null
AMTACCTDR number 22  √  null
AMTACCTCR number 22  √  null
AMTACCT number 22  √  null
RATE number 22  √  null
M_PRODUCT_ID number 10  √  null
M_PRODUCT M_PRODUCT_ID Implied Constraint
C_BPARTNER_ID number 10  √  null
C_BPARTNER C_BPARTNER_ID Implied Constraint
AD_ORGTRX_ID number 10  √  null
C_LOCFROM_ID number 10  √  null
C_LOCTO_ID number 10  √  null
C_SALESREGION_ID number 10  √  null
C_SALESREGION C_SALESREGION_ID Implied Constraint
C_PROJECT_ID number 10  √  null
C_PROJECT C_PROJECT_ID Implied Constraint
C_CAMPAIGN_ID number 10  √  null
C_CAMPAIGN C_CAMPAIGN_ID Implied Constraint
C_ACTIVITY_ID number 10  √  null
C_ACTIVITY C_ACTIVITY_ID Implied Constraint
USER1_ID number 10  √  null
USER2_ID number 10  √  null
A_ASSET_ID number 10  √  null
A_ASSET A_ASSET_ID Implied Constraint
View SQL:
SELECT AD_Client_ID, AD_Org_ID,
    C_AcctSchema_ID, Account_ID, C_Period_ID, 
    GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, 
    PostingType, C_Currency_ID,
    SUM(AmtSourceDr) AS AmtSourceDr, SUM(AmtSourceCr) AS AmtSourceCr, SUM(AmtSourceDr - AmtSourceCr) AS AmtSource,
    SUM(AmtAcctDr) AS AmtAcctDr, SUM(AmtAcctCr) AS AmtAcctCr, SUM(AmtAcctDr - AmtAcctCr) AS AmtAcct,
    CASE WHEN SUM(AmtSourceDr - AmtSourceCr) = 0 THEN 0 ELSE
        SUM(AmtAcctDr - AmtAcctCr) / SUM(AmtSourceDr - AmtSourceCr) END AS Rate,
    M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID, C_LocTo_ID, C_SalesRegion_ID,
    C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID
FROM Fact_Acct
GROUP BY AD_Client_ID, AD_Org_ID,
    C_AcctSchema_ID, Account_ID, C_Period_ID, 
    GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, 
    PostingType, C_Currency_ID,
    M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID, C_LocTo_ID, C_SalesRegion_ID,
    C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_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.