cof_rv_contaspagarplanocaixa

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

cof_tipolancamento

text

2147483647

√

null

documentno

varchar

√

null

cof_tipodocumento

varchar

2147483647

√

null

name

varchar

120

√

null

duedate

timestamptz

35,6

√

null

grandtotal

numeric

√

null

openamt

numeric

√

null

issotrx

bpchar

√

null

ad_org_id

numeric

√

null

cof_nota

text

2147483647

√

null

cof_payscheduleno

text

2147483647

√

null

description

varchar

2147483647

√

null

ad_client_id

numeric

√

null

cof_namecashplanline

varchar

2147483647

√

null

c_bpartner_id

numeric

√

null

m_product_id

numeric

√

null

c_charge_id

numeric

√

null

c_project_id

numeric

√

null

c_activity_id

numeric

√

null

user1_id

numeric

√

null

user2_id

numeric

√

null

cof_c_planofinanceiro_id

numeric

√

null

cof_c_custody_id

numeric

√

null

lbr_docfiscal_id

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT 'Real'::text AS cof_tipolancamento,
    op.documentno,
    doc.printname AS cof_tipodocumento,
    bp.name,
    op.duedate,
    COALESCE(op.grandtotal, (0)::numeric) AS grandtotal,
    COALESCE(op.openamt, (0)::numeric) AS openamt,
    op.issotrx,
    op.ad_org_id,
    ((op.ide_nnf || ' / '::text) || op.ide_serie) AS cof_nota,
    (((op.cof_payscheduleno)::text || ' / '::text) || ( SELECT count(*) AS count
           FROM c_invoicepayschedule
          WHERE (c_invoicepayschedule.c_invoice_id = op.c_invoice_id))) AS cof_payscheduleno,
    op.description,
    op.ad_client_id,
    NULL::character varying AS cof_namecashplanline,
    op.c_bpartner_id,
    NULL::numeric AS m_product_id,
    op.c_charge_id,
    op.c_project_id,
    op.c_activity_id,
    op.user1_id,
    op.user2_id,
    op.cof_c_planofinanceiro_id,
    op.cof_c_custody_id,
    op.lbr_docfiscal_id
   FROM ((rv_openitem op
     LEFT JOIN c_doctype doc ON ((op.c_doctype_id = doc.c_doctype_id)))
     LEFT JOIN c_bpartner bp ON ((op.c_bpartner_id = bp.c_bpartner_id)))
UNION
 SELECT 'Previsto'::text AS cof_tipolancamento,
    cp.documentno,
        CASE
            WHEN (cp.cashflowtype = 'F'::bpchar) THEN 'Financeiro'::text
            WHEN (cp.cashflowtype = 'I'::bpchar) THEN 'Investimento'::text
            WHEN (cp.cashflowtype = 'O'::bpchar) THEN 'Operacional'::text
            ELSE NULL::text
        END AS cof_tipodocumento,
    bp.name,
    cpl.datetrx AS duedate,
    ((COALESCE(cpl.linetotalamt, (0)::numeric) * cpl.probability) / (100)::numeric) AS grandtotal,
    COALESCE(cpl.linetotalamt, (0)::numeric) AS openamt,
    cp.issotrx,
    cp.ad_org_id,
    ((df.ide_nnf || ' / '::text) || df.ide_serie) AS cof_nota,
    ''::text AS cof_payscheduleno,
    COALESCE(cpl.description, i.description) AS description,
    cp.ad_client_id,
    cpl.name AS cof_namecashplanline,
    cpl.c_bpartner_id,
    cpl.m_product_id,
    cpl.c_charge_id,
    cpl.c_project_id,
    cpl.c_activity_id,
    cpl.user1_id,
    cpl.user2_id,
    i.cof_c_planofinanceiro_id,
    i.cof_c_custody_id,
    i.lbr_docfiscal_id
   FROM ((((c_cashplan cp
     LEFT JOIN c_cashplanline cpl ON ((cp.c_cashplan_id = cpl.c_cashplan_id)))
     LEFT JOIN c_invoice i ON (((i.c_cashplanline_id = cpl.c_cashplanline_id) AND (i.docstatus <> ALL (ARRAY['RE'::bpchar, 'VO'::bpchar])))))
     LEFT JOIN c_bpartner bp ON ((cp.c_bpartner_id = bp.c_bpartner_id)))
     LEFT JOIN lbr_docfiscal df ON ((df.lbr_docfiscal_id = i.lbr_docfiscal_id)))
  WHERE (i.c_invoice_id IS NULL);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views