cof_rv_openiteminterest

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

issotrx

bpchar

√

null

salesrep_id

numeric

√

null

c_bpartner_value

varchar

√

null

c_bpartner_name

varchar

120

√

null

phone

varchar

√

null

c_order_documentno

varchar

√

null

ide_nnf

varchar

√

null

invoice_documentno

varchar

√

null

cof_payscheduleno

varchar

√

null

openamt

numeric

√

null

cof_totalopenbalance

numeric

√

null

dateinvoiced

timestamp

29,6

√

null

duedate

timestamptz

35,6

√

null

c_invoice_grandtotal

numeric

√

null

cof_c_custody_id

numeric

√

null

cof_c_custody.cof_c_custody_id

Implied Constraint

bank_name

varchar

√

null

cof_titulo_numdoc

varchar

√

null

cof_borderoname

varchar

√

null

cof_c_bankoccurrence_id

numeric

√

null

cof_c_bankoccurrence.cof_c_bankoccurrence_id

Implied Constraint

c_activity_id

numeric

√

null

c_activity.c_activity_id

Implied Constraint

daysdue

int4

√

null

cof_interestrate

numeric

√

null

c_bp_group_id

numeric

√

null

c_bp_group.c_bp_group_id

Implied Constraint

user1_id

numeric

√

null

user2_id

numeric

√

null

c_bpartner_location_id

numeric

√

null

c_bpartner_location.c_bpartner_location_id

Implied Constraint

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

cof_payfrom_location_id

numeric

√

null

c_doctype_id

numeric

√

null

c_doctype.c_doctype_id

Implied Constraint

cof_checkallocateamt

numeric

√

null

cof_tipoparceiro_id

numeric

√

null

cof_tipoparceiro.cof_tipoparceiro_id

Implied Constraint

cof_classeparceiro_id

numeric

√

null

cof_classeparceiro.cof_classeparceiro_id

Implied Constraint

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT i.ad_client_id,
    i.ad_org_id,
    i.issotrx,
    i.salesrep_id,
    bp.value AS c_bpartner_value,
    bp.name AS c_bpartner_name,
    ( SELECT c_bpartner_location.phone
           FROM c_bpartner_location
          WHERE ((c_bpartner_location.c_bpartner_id = bp.c_bpartner_id) AND (c_bpartner_location.ispayfrom = 'Y'::bpchar))
         LIMIT 1) AS phone,
    o.documentno AS c_order_documentno,
    nf.documentno AS ide_nnf,
    i.documentno AS invoice_documentno,
    ips.cof_payscheduleno,
    (invoiceopen(i.c_invoice_id, i.c_invoicepayschedule_id) * i.multiplierap) AS openamt,
    ((((invoiceopen(i.c_invoice_id, i.c_invoicepayschedule_id) * i.multiplierap) * (((bp.cof_interestrate * (12)::numeric) / (360)::numeric) / (100)::numeric)) * (((now())::date - (i.duedate)::date))::numeric) + (invoiceopen(i.c_invoice_id, i.c_invoicepayschedule_id) * i.multiplierap)) AS cof_totalopenbalance,
    i.dateinvoiced,
    i.duedate,
    (i.grandtotal * i.multiplierap) AS c_invoice_grandtotal,
    c.cof_c_custody_id,
    bk.name AS bank_name,
    b.cof_titulo_numdoc,
    b.cof_borderoname,
    bo.cof_c_bankoccurrence_id,
    a.c_activity_id,
    ((now())::date - (i.duedate)::date) AS daysdue,
    bp.cof_interestrate,
    bp.c_bp_group_id,
    ci.user1_id,
    ci.user2_id,
    i.c_bpartner_location_id,
    i.c_bpartner_id,
    ci.cof_payfrom_location_id,
    i.c_doctype_id,
    cof_getcheckallocateamt(i.c_invoice_id, COALESCE(ips.c_invoicepayschedule_id, (0)::numeric)) AS cof_checkallocateamt,
    bp.cof_tipoparceiro_id,
    bp.cof_classeparceiro_id
   FROM (((((((((((c_invoice_v i
     JOIN c_bpartner bp ON ((i.c_bpartner_id = bp.c_bpartner_id)))
     LEFT JOIN lbr_docfiscal nf ON (((i.c_invoice_id = nf.c_invoice_id) AND ((nf.lbr_nfestatus)::text = '100'::text))))
     LEFT JOIN cof_titulo b ON (((i.c_invoice_id = b.c_invoice_id) AND (COALESCE(b.c_invoicepayschedule_id, (0)::numeric) = COALESCE(i.c_invoicepayschedule_id, (0)::numeric)) AND (b.isvalid = 'Y'::bpchar))))
     LEFT JOIN c_bank bk ON ((b.c_bank_id = bk.c_bank_id)))
     LEFT JOIN c_order o ON ((i.c_order_id = o.c_order_id)))
     LEFT JOIN c_invoicepayschedule ips ON ((i.c_invoicepayschedule_id = ips.c_invoicepayschedule_id)))
     JOIN c_invoice ci ON ((i.c_invoice_id = ci.c_invoice_id)))
     LEFT JOIN cof_c_custody c ON ((COALESCE(ips.cof_c_custody_id, ci.cof_c_custody_id) = c.cof_c_custody_id)))
     LEFT JOIN c_paymentterm pt ON ((i.c_paymentterm_id = pt.c_paymentterm_id)))
     LEFT JOIN cof_c_bankoccurrence bo ON ((b.cof_c_bankoccurrence_id = bo.cof_c_bankoccurrence_id)))
     LEFT JOIN c_activity a ON ((ci.c_activity_id = a.c_activity_id)))
  WHERE ((invoiceopen(i.c_invoice_id, ips.c_invoicepayschedule_id) <> (0)::numeric) AND (i.ispayschedulevalid = 'Y'::bpchar) AND (i.docstatus = ANY (ARRAY['CO'::bpchar, 'CL'::bpchar])) AND (ips.isvalid = 'Y'::bpchar));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views