cof_rv_resumoplanofinanceiro

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

cof_identifier

text

2147483647

√

null

cof_type

text

2147483647

√

null

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

issotrx

bpchar

√

null

value

varchar

√

null

name

varchar

√

null

description

varchar

255

√

null

accounttype

bpchar

√

null

cof_c_planofinanceiro_id

numeric

√

null

cof_c_planofinanceiro_parent_id

numeric

√

null

c_doctypetarget_id

numeric

√

null

ano

float8

17,17

√

null

jan

numeric

√

null

fev

numeric

√

null

mar

numeric

√

null

abr

numeric

√

null

mai

numeric

√

null

jun

numeric

√

null

jul

numeric

√

null

ago

numeric

√

null

set

numeric

√

null

out

numeric

√

null

nov

numeric

√

null

dez

numeric

√

null

total

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT ((((('FA'::text || i.ad_client_id) || i.ad_org_id) || (i.issotrx)::text) || i.cof_c_planofinanceiro_id) || date_part('year'::text, i.dateinvoiced)) AS cof_identifier,
    'FA'::text AS cof_type,
    i.ad_client_id,
    i.ad_org_id,
    i.issotrx,
    pf.value,
    pf.name,
    pf.description,
    pf.accounttype,
    i.cof_c_planofinanceiro_id,
    ( SELECT tn.parent_id
           FROM (ad_treenode tn
             LEFT JOIN ad_tree t ON ((tn.ad_tree_id = t.ad_tree_id)))
          WHERE ((tn.node_id = i.cof_c_planofinanceiro_id) AND (t.ad_table_id = (1500570)::numeric))) AS cof_c_planofinanceiro_parent_id,
    i.c_doctypetarget_id,
    date_part('year'::text, i.dateinvoiced) AS ano,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '1'::double precision)), (0)::numeric) AS jan,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '2'::double precision)), (0)::numeric) AS fev,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '3'::double precision)), (0)::numeric) AS mar,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '4'::double precision)), (0)::numeric) AS abr,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '5'::double precision)), (0)::numeric) AS mai,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '6'::double precision)), (0)::numeric) AS jun,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '7'::double precision)), (0)::numeric) AS jul,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '8'::double precision)), (0)::numeric) AS ago,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '9'::double precision)), (0)::numeric) AS set,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '10'::double precision)), (0)::numeric) AS "out",
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '11'::double precision)), (0)::numeric) AS nov,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)) FILTER (WHERE (date_part('month'::text, i.dateinvoiced) = '12'::double precision)), (0)::numeric) AS dez,
    COALESCE(sum((i.grandtotal * (i.multiplier)::numeric)), (0)::numeric) AS total
   FROM (rv_c_invoice i
     LEFT JOIN cof_c_planofinanceiro pf ON ((i.cof_c_planofinanceiro_id = pf.cof_c_planofinanceiro_id)))
  WHERE (i.cof_c_planofinanceiro_id IS NOT NULL)
  GROUP BY ((((('FA'::text || i.ad_client_id) || i.ad_org_id) || (i.issotrx)::text) || i.cof_c_planofinanceiro_id) || date_part('year'::text, i.dateinvoiced)), i.ad_client_id, i.ad_org_id, 'FA'::text, i.issotrx, pf.value, pf.name, pf.description, pf.accounttype, i.cof_c_planofinanceiro_id, ( SELECT tn.parent_id
           FROM (ad_treenode tn
             LEFT JOIN ad_tree t ON ((tn.ad_tree_id = t.ad_tree_id)))
          WHERE ((tn.node_id = i.cof_c_planofinanceiro_id) AND (t.ad_table_id = (1500570)::numeric))), i.c_doctypetarget_id, (date_part('year'::text, i.dateinvoiced))
UNION ALL
 SELECT ((((('PO'::text || p.ad_client_id) || p.ad_org_id) || (p.isreceipt)::text) || p.cof_c_planofinanceiro_id) || date_part('year'::text, p.datetrx)) AS cof_identifier,
    'PO'::text AS cof_type,
    p.ad_client_id,
    p.ad_org_id,
    p.isreceipt AS issotrx,
    pf.value,
    pf.name,
    pf.description,
    pf.accounttype,
    p.cof_c_planofinanceiro_id,
    ( SELECT tn.parent_id
           FROM (ad_treenode tn
             LEFT JOIN ad_tree t ON ((tn.ad_tree_id = t.ad_tree_id)))
          WHERE ((tn.node_id = p.cof_c_planofinanceiro_id) AND (t.ad_table_id = (1500570)::numeric))) AS cof_c_planofinanceiro_parent_id,
    p.c_doctype_id AS c_doctypetarget_id,
    date_part('year'::text, p.datetrx) AS ano,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '1'::double precision)), (0)::numeric) AS jan,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '2'::double precision)), (0)::numeric) AS fev,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '3'::double precision)), (0)::numeric) AS mar,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '4'::double precision)), (0)::numeric) AS abr,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '5'::double precision)), (0)::numeric) AS mai,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '6'::double precision)), (0)::numeric) AS jun,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '7'::double precision)), (0)::numeric) AS jul,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '8'::double precision)), (0)::numeric) AS ago,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '9'::double precision)), (0)::numeric) AS set,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '10'::double precision)), (0)::numeric) AS "out",
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '11'::double precision)), (0)::numeric) AS nov,
    COALESCE(sum(p.payamt) FILTER (WHERE (date_part('month'::text, p.datetrx) = '12'::double precision)), (0)::numeric) AS dez,
    COALESCE(sum(p.payamt), (0)::numeric) AS total
   FROM (rv_payment p
     LEFT JOIN cof_c_planofinanceiro pf ON ((p.cof_c_planofinanceiro_id = pf.cof_c_planofinanceiro_id)))
  WHERE (p.cof_c_planofinanceiro_id IS NOT NULL)
  GROUP BY ((((('PO'::text || p.ad_client_id) || p.ad_org_id) || (p.isreceipt)::text) || p.cof_c_planofinanceiro_id) || date_part('year'::text, p.datetrx)), p.ad_client_id, p.ad_org_id, 'PO'::text, p.isreceipt, pf.value, pf.name, pf.description, pf.accounttype, p.cof_c_planofinanceiro_id, ( SELECT tn.parent_id
           FROM (ad_treenode tn
             LEFT JOIN ad_tree t ON ((tn.ad_tree_id = t.ad_tree_id)))
          WHERE ((tn.node_id = p.cof_c_planofinanceiro_id) AND (t.ad_table_id = (1500570)::numeric))), p.c_doctype_id, (date_part('year'::text, p.datetrx));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views