View erp.COMPIERE.RV_FACT_ACCT_DAY

Generated by
SchemaSpy

Legend:

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	Nulls	Default
AD_CLIENT_ID	undefined	√	null
AD_ORG_ID	undefined	√	null
C_ACCTSCHEMA_ID	undefined	√	null
ACCOUNT_ID	undefined	√	null
DATEACCT	undefined	√	null
C_PERIOD_ID	undefined	√	null
GL_CATEGORY_ID	undefined	√	null
GL_BUDGET_ID	undefined	√	null
C_TAX_ID	undefined	√	null
M_LOCATOR_ID	undefined	√	null
POSTINGTYPE	undefined	√	null
C_CURRENCY_ID	undefined	√	null
AMTSOURCEDR	undefined	√	null
AMTSOURCECR	undefined	√	null
AMTSOURCE	undefined	√	null
AMTACCTDR	undefined	√	null
AMTACCTCR	undefined	√	null
AMTACCT	undefined	√	null
RATE	undefined	√	null
M_PRODUCT_ID	undefined	√	null
C_BPARTNER_ID	undefined	√	null
AD_ORGTRX_ID	undefined	√	null
C_LOCFROM_ID	undefined	√	null
C_LOCTO_ID	undefined	√	null
C_SALESREGION_ID	undefined	√	null
C_PROJECT_ID	undefined	√	null
C_CAMPAIGN_ID	undefined	√	null
C_ACTIVITY_ID	undefined	√	null
USER1_ID	undefined	√	null
USER2_ID	undefined	√	null
A_ASSET_ID	undefined	√	null

View SQL:

SELECT AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, Account_ID, firstOf(DateAcct, 'DD') AS DateAcct, 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, firstOf(DateAcct, 'DD'), 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

SELECT AD_Client_ID, AD_Org_ID,
    C_AcctSchema_ID, Account_ID, firstOf(DateAcct, 'DD') AS DateAcct, 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, firstOf(DateAcct, 'DD'), 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