cof_rv_gencnab

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

documentid

numeric

√

null

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

documentno

varchar

√

null

ide_nnf

numeric

√

null

lbr_docfiscal_id

numeric

√

null

cof_payscheduleno

varchar

2147483647

√

null

c_invoicepayschedule_id

numeric

√

null

cof_titulo_nossonumero

varchar

√

null

date1

timestamp

29,6

√

null

date2

timestamptz

35,6

√

null

c_paymentterm_id

numeric

√

null

c_paymentterm.c_paymentterm_id

Implied Constraint

cof_occurrencename

varchar

√

null

cof_c_bankoccurrence_id

numeric

√

null

cof_c_bankoccurrence.cof_c_bankoccurrence_id

Implied Constraint

cof_c_bankintegration_id

numeric

√

null

cof_c_bankintegration.cof_c_bankintegration_id

Implied Constraint

total

numeric

√

null

c_doctypetarget_id

numeric

√

null

cof_c_custody_id

numeric

√

null

cof_c_custody.cof_c_custody_id

Implied Constraint

issotrx

bpchar

√

null

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

document

text

2147483647

√

null

cof_processed2

bpchar

√

null

cof_borderoname

varchar

√

null

cof_titulo_id

numeric

√

null

cof_titulo.cof_titulo_id

Implied Constraint

lbr_nfestatus

varchar

2147483647

√

null

orgname

varchar

√

null

bpname

varchar

120

√

null

paymenttermname

varchar

√

null

user1_id

numeric

√

null

user2_id

numeric

√

null

cof_isgeneratecnab

bpchar

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT un.documentid,
    un.c_bpartner_id,
    un.documentno,
    un.ide_nnf,
    un.lbr_docfiscal_id,
    un.cof_payscheduleno,
    un.c_invoicepayschedule_id,
    un.cof_titulo_nossonumero,
    un.date1,
    un.date2,
    un.c_paymentterm_id,
    un.cof_occurrencename,
    un.cof_c_bankoccurrence_id,
    un.cof_c_bankintegration_id,
    un.total,
    un.c_doctypetarget_id,
    un.cof_c_custody_id,
    un.issotrx,
    un.ad_client_id,
    un.ad_org_id,
    un.document,
    un.cof_processed2,
    un.cof_borderoname,
    un.cof_titulo_id,
    un.lbr_nfestatus,
    o.name AS orgname,
    bp.name AS bpname,
    pt.name AS paymenttermname,
    un.user1_id,
    un.user2_id,
    ct.cof_isgeneratecnab
   FROM (((((( SELECT opi.c_invoice_id AS documentid,
            opi.c_bpartner_id,
            opi.documentno,
            opi.ide_nnf,
            opi.lbr_docfiscal_id,
            opi.cof_payscheduleno,
            opi.c_invoicepayschedule_id,
            opi.cof_titulo_nossonumero,
            opi.dateinvoiced AS date1,
            opi.duedate AS date2,
            opi.c_paymentterm_id,
            opi.cof_occurrencename,
            opi.cof_c_bankoccurrence_id,
            opi.cof_c_bankintegration_id,
            opi.openamt AS total,
            opi.c_doctypetarget_id,
            opi.cof_c_custody_id,
            opi.issotrx,
            opi.ad_client_id,
            opi.ad_org_id,
            opi.cof_processed2,
            opi.cof_borderoname,
            opi.cof_titulo_id,
            opi.lbr_nfestatus,
            opi.docstatus,
            opi.ispaid,
            'FATURA'::text AS document,
            opi.user1_id,
            opi.user2_id
           FROM rv_openitem opi
          WHERE ((opi.paymentrule = 'P'::bpchar) AND (opi.ispaid = 'N'::bpchar))
        UNION
         SELECT co.c_order_id AS documentid,
            co.c_bpartner_id,
            co.documentno,
            NULL::numeric AS ide_nnf,
            NULL::numeric AS lbr_docfiscal_id,
            NULL::character varying AS cof_payscheduleno,
            NULL::numeric AS c_invoicepayschedule_id,
            titulo.cof_titulo_nossonumero,
            co.dateordered AS date1,
            co.dateordered AS date2,
            co.c_paymentterm_id,
            bo.name AS cof_occurrencename,
            titulo.cof_c_bankoccurrence_id,
            titulo.cof_c_bankintegration_id,
            co.grandtotal AS total,
            co.c_doctypetarget_id,
            co.cof_c_custody_id,
            co.issotrx,
            co.ad_client_id,
            co.ad_org_id,
            titulo.cof_processed2,
            titulo.cof_borderoname,
            titulo.cof_titulo_id,
            NULL::character varying AS lbr_nfestatus,
            co.docstatus,
            NULL::bpchar AS ispaid,
            'PEDIDO'::text AS document,
            co.user1_id,
            co.user2_id
           FROM ((c_order co
             LEFT JOIN cof_titulo titulo ON ((titulo.c_order_id = co.c_order_id)))
             LEFT JOIN cof_c_bankoccurrence bo ON ((bo.cof_c_bankoccurrence_id = titulo.cof_c_bankoccurrence_id)))) un
     JOIN ad_org o ON ((un.ad_org_id = o.ad_org_id)))
     JOIN c_bpartner bp ON ((un.c_bpartner_id = bp.c_bpartner_id)))
     JOIN c_paymentterm pt ON ((un.c_paymentterm_id = pt.c_paymentterm_id)))
     JOIN c_doctype dt ON ((un.c_doctypetarget_id = dt.c_doctype_id)))
     LEFT JOIN cof_c_custody ct ON ((ct.cof_c_custody_id = un.cof_c_custody_id)))
  WHERE ((un.issotrx = 'Y'::bpchar) AND ((un.document = 'PEDIDO'::text) OR (dt.docbasetype = 'ARI'::bpchar)) AND ((un.document = 'FATURA'::text) OR (ct.cof_gerarboletopedido = 'Y'::bpchar)) AND (un.docstatus = ANY (ARRAY['CO'::bpchar, 'CL'::bpchar, 'WP'::bpchar])));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views