rv_fact_acct_day

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

c_acctschema_id

numeric

√

null

account_id

numeric

√

null

dateacct

date

√

null

c_period_id

numeric

√

null

c_period.c_period_id

Implied Constraint

gl_category_id

numeric

√

null

gl_category.gl_category_id

Implied Constraint

gl_budget_id

numeric

√

null

gl_budget.gl_budget_id

Implied Constraint

c_tax_id

numeric

√

null

c_tax.c_tax_id

Implied Constraint

m_locator_id

numeric

√

null

m_locator.m_locator_id

Implied Constraint

postingtype

bpchar

√

null

c_currency_id

numeric

√

null

c_currency.c_currency_id

Implied Constraint

amtsourcedr

numeric

√

null

amtsourcecr

numeric

√

null

amtsource

numeric

√

null

amtacctdr

numeric

√

null

amtacctcr

numeric

√

null

amtacct

numeric

√

null

rate

numeric

√

null

m_product_id

numeric

√

null

m_product.m_product_id

Implied Constraint

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

ad_orgtrx_id

numeric

√

null

c_locfrom_id

numeric

√

null

c_locto_id

numeric

√

null

c_salesregion_id

numeric

√

null

c_salesregion.c_salesregion_id

Implied Constraint

c_project_id

numeric

√

null

c_project.c_project_id

Implied Constraint

c_campaign_id

numeric

√

null

c_campaign.c_campaign_id

Implied Constraint

c_activity_id

numeric

√

null

c_activity.c_activity_id

Implied Constraint

user1_id

numeric

√

null

user2_id

numeric

√

null

a_asset_id

numeric

√

null

a_asset.a_asset_id

Implied Constraint

accountvalue

varchar

√

null

cof_user1value

varchar

√

null

cof_user1name

varchar

120

√

null

cof_user2value

varchar

√

null

cof_user2name

varchar

120

√

null

cof_parentacctvalue

varchar

√

null

cof_parentacctname

varchar

120

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT fact_acct.ad_client_id,
    fact_acct.ad_org_id,
    fact_acct.c_acctschema_id,
    fact_acct.account_id,
    firstof((fact_acct.dateacct)::timestamp with time zone, 'DD'::character varying) AS dateacct,
    fact_acct.c_period_id,
    fact_acct.gl_category_id,
    fact_acct.gl_budget_id,
    fact_acct.c_tax_id,
    fact_acct.m_locator_id,
    fact_acct.postingtype,
    fact_acct.c_currency_id,
    sum(fact_acct.amtsourcedr) AS amtsourcedr,
    sum(fact_acct.amtsourcecr) AS amtsourcecr,
    sum((fact_acct.amtsourcedr - fact_acct.amtsourcecr)) AS amtsource,
    sum(fact_acct.amtacctdr) AS amtacctdr,
    sum(fact_acct.amtacctcr) AS amtacctcr,
    sum((fact_acct.amtacctdr - fact_acct.amtacctcr)) AS amtacct,
        CASE
            WHEN (sum((fact_acct.amtsourcedr - fact_acct.amtsourcecr)) = (0)::numeric) THEN (0)::numeric
            ELSE (sum((fact_acct.amtacctdr - fact_acct.amtacctcr)) / sum((fact_acct.amtsourcedr - fact_acct.amtsourcecr)))
        END AS rate,
    fact_acct.m_product_id,
    fact_acct.c_bpartner_id,
    fact_acct.ad_orgtrx_id,
    fact_acct.c_locfrom_id,
    fact_acct.c_locto_id,
    fact_acct.c_salesregion_id,
    fact_acct.c_project_id,
    fact_acct.c_campaign_id,
    fact_acct.c_activity_id,
    fact_acct.user1_id,
    fact_acct.user2_id,
    fact_acct.a_asset_id,
    ev.value AS accountvalue,
    ev1.value AS cof_user1value,
    ev1.name AS cof_user1name,
    ev2.value AS cof_user2value,
    ev2.name AS cof_user2name,
    evparent.value AS cof_parentacctvalue,
    evparent.name AS cof_parentacctname
   FROM (((((fact_acct
     JOIN c_elementvalue ev ON ((fact_acct.account_id = ev.c_elementvalue_id)))
     LEFT JOIN ad_treenode n ON ((ev.c_elementvalue_id = n.node_id)))
     LEFT JOIN c_elementvalue evparent ON ((n.parent_id = evparent.c_elementvalue_id)))
     JOIN c_elementvalue ev1 ON ((fact_acct.user1_id = ev1.c_elementvalue_id)))
     JOIN c_elementvalue ev2 ON ((fact_acct.user2_id = ev2.c_elementvalue_id)))
  GROUP BY fact_acct.ad_client_id, fact_acct.ad_org_id, fact_acct.c_acctschema_id, fact_acct.account_id, (firstof((fact_acct.dateacct)::timestamp with time zone, 'DD'::character varying)), fact_acct.c_period_id, fact_acct.gl_category_id, fact_acct.gl_budget_id, fact_acct.c_tax_id, fact_acct.m_locator_id, fact_acct.postingtype, fact_acct.c_currency_id, fact_acct.m_product_id, fact_acct.c_bpartner_id, fact_acct.ad_orgtrx_id, fact_acct.c_locfrom_id, fact_acct.c_locto_id, fact_acct.c_salesregion_id, fact_acct.c_project_id, fact_acct.c_campaign_id, fact_acct.c_activity_id, fact_acct.user1_id, fact_acct.user2_id, fact_acct.a_asset_id, ev.value, ev1.value, ev1.name, ev2.value, ev2.name, evparent.value, evparent.name;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views