cof_rv_mapa_pedido

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

ad_user_id

numeric

√

null

bill_bpartner_id

numeric

√

null

bill_location_id

numeric

√

null

bill_user_id

numeric

√

null

c_activity_id

numeric

√

null

c_activity.c_activity_id

Implied Constraint

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

c_bpartner_location_id

numeric

√

null

c_bpartner_location.c_bpartner_location_id

Implied Constraint

c_campaign_id

numeric

√

null

c_campaign.c_campaign_id

Implied Constraint

c_doctypetarget_id

numeric

√

null

cof_bpespecialista_id

numeric

√

null

cof_c_custody_id

numeric

√

null

cof_c_custody.cof_c_custody_id

Implied Constraint

cof_contract_id

numeric

√

null

cof_contract.cof_contract_id

Implied Constraint

cof_c_planofinanceiro_id

numeric

√

null

cof_c_planofinanceiro.cof_c_planofinanceiro_id

Implied Constraint

cof_customercpf

varchar

√

null

cof_digitador_id

numeric

√

null

cof_estimatedtotalweight

numeric

√

null

cof_exibiremrelatorios

bpchar

√

null

cof_fatorfinanceiro

numeric

√

null

cof_freightamt

numeric

√

null

cof_insuranceamt

numeric

√

null

cof_jurosmensal

numeric

√

null

cof_markupaverage

numeric

√

null

cof_markupminimum

numeric

√

null

cof_markupreal

numeric

√

null

cof_markupvariation

numeric

√

null

cof_modfrete

bpchar

√

null

cof_m_shipregion_id

numeric

√

null

cof_m_shipregion.cof_m_shipregion_id

Implied Constraint

cof_nomeconsumidor

varchar

255

√

null

cof_orgst_id

numeric

√

null

cof_orgst.cof_orgst_id

Implied Constraint

cof_otheramt

numeric

√

null

cof_payfrom_location_id

numeric

√

null

cof_pnlocationretira_id

numeric

√

null

cof_pnretira_id

numeric

√

null

cof_reason_close_observation

text

2147483647

√

null

cof_reason_closing_order_id

numeric

√

null

cof_reason_closing_order.cof_reason_closing_order_id

Implied Constraint

cof_serienfentrada

numeric

√

null

cof_situacaocomercial

varchar

√

null

cof_tempomedio

numeric

√

null

cof_tipoexportacao

bpchar

√

null

cof_tributacaodestino

bpchar

√

null

cof_ufsaidapais

varchar

√

null

cof_xlocdespacho

varchar

√

null

cof_xlocexporta

varchar

√

null

c_opportunity_id

numeric

√

null

c_opportunity.c_opportunity_id

Implied Constraint

c_order_id

numeric

√

null

c_order.c_order_id

Implied Constraint

c_ordersource_id

numeric

√

null

c_ordersource.c_ordersource_id

Implied Constraint

c_payment_id

numeric

√

null

c_payment.c_payment_id

Implied Constraint

c_paymentterm_id

numeric

√

null

c_paymentterm.c_paymentterm_id

Implied Constraint

c_project_id

numeric

√

null

c_project.c_project_id

Implied Constraint

createdby

numeric

√

null

created

timestamp

29,6

√

null

dateacct

timestamp

29,6

√

null

dateordered

timestamp

29,6

√

null

datepromised

timestamp

29,6

√

null

deliveryrule

bpchar

√

null

deliveryviarule

bpchar

√

null

description

varchar

500

√

null

docstatus

bpchar

√

null

documentno

varchar

√

null

grandtotal

numeric

√

null

infnfe_id

varchar

√

null

invoicerule

bpchar

√

null

isactive

bpchar

√

null

isapproved

bpchar

√

null

isprinted

bpchar

√

null

issotrx

bpchar

√

null

lbr_nfdescription

varchar

255

√

null

lbr_nfentrada

varchar

√

null

lbr_nfmodel

varchar

√

null

lbr_transactiontype

varchar

√

null

m_freightcategory_id

numeric

√

null

m_freightcategory.m_freightcategory_id

Implied Constraint

m_pricelist_id

numeric

√

null

m_pricelist.m_pricelist_id

Implied Constraint

m_shipper_id

numeric

√

null

m_shipper.m_shipper_id

Implied Constraint

m_warehouse_id

numeric

√

null

m_warehouse.m_warehouse_id

Implied Constraint

pay_bpartner_id

numeric

√

null

pay_location_id

numeric

√

null

paymentrule

bpchar

√

null

poreference

varchar

√

null

priorityrule

bpchar

√

null

quotationorder_id

numeric

√

null

salesrep_id

numeric

√

null

totallines

numeric

√

null

updated

timestamp

29,6

√

null

updatedby

numeric

√

null

user1_id

numeric

√

null

user2_id

numeric

√

null

volume

numeric

√

null

weight

numeric

√

null

c_bp_group_id

numeric

√

null

c_bp_group.c_bp_group_id

Implied Constraint

cof_tipoparceiro_id

numeric

√

null

cof_tipoparceiro.cof_tipoparceiro_id

Implied Constraint

cof_classeparceiro_id

numeric

√

null

cof_classeparceiro.cof_classeparceiro_id

Implied Constraint

cof_vendedorinterno_id

numeric

√

null

valorfaturado

numeric

√

null

valorentregue

numeric

√

null

valorafaturar

numeric

√

null

valoraentregar

numeric

√

null

valorrecebido

numeric

√

null

valorareceber

numeric

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT co.ad_client_id,
    co.ad_org_id,
    co.ad_user_id,
    co.bill_bpartner_id,
    co.bill_location_id,
    co.bill_user_id,
    co.c_activity_id,
    co.c_bpartner_id,
    co.c_bpartner_location_id,
    co.c_campaign_id,
    co.c_doctypetarget_id,
    co.cof_bpespecialista_id,
    co.cof_c_custody_id,
    co.cof_contract_id,
    co.cof_c_planofinanceiro_id,
    co.cof_customercpf,
    co.cof_digitador_id,
    co.cof_estimatedtotalweight,
    co.cof_exibiremrelatorios,
    co.cof_fatorfinanceiro,
    co.cof_freightamt,
    co.cof_insuranceamt,
    co.cof_jurosmensal,
    co.cof_markupaverage,
    co.cof_markupminimum,
    co.cof_markupreal,
    co.cof_markupvariation,
    co.cof_modfrete,
    co.cof_m_shipregion_id,
    co.cof_nomeconsumidor,
    co.cof_orgst_id,
    co.cof_otheramt,
    co.cof_payfrom_location_id,
    co.cof_pnlocationretira_id,
    co.cof_pnretira_id,
    co.cof_reason_close_observation,
    co.cof_reason_closing_order_id,
    co.cof_serienfentrada,
    co.cof_situacaocomercial,
    co.cof_tempomedio,
    co.cof_tipoexportacao,
    co.cof_tributacaodestino,
    co.cof_ufsaidapais,
    co.cof_xlocdespacho,
    co.cof_xlocexporta,
    co.c_opportunity_id,
    co.c_order_id,
    co.c_ordersource_id,
    co.c_payment_id,
    co.c_paymentterm_id,
    co.c_project_id,
    co.createdby,
    co.created,
    co.dateacct,
    co.dateordered,
    co.datepromised,
    co.deliveryrule,
    co.deliveryviarule,
    co.description,
    co.docstatus,
    co.documentno,
    co.grandtotal,
    co.infnfe_id,
    co.invoicerule,
    co.isactive,
    co.isapproved,
    co.isprinted,
    co.issotrx,
    co.lbr_nfdescription,
    co.lbr_nfentrada,
    co.lbr_nfmodel,
    co.lbr_transactiontype,
    co.m_freightcategory_id,
    co.m_pricelist_id,
    co.m_shipper_id,
    co.m_warehouse_id,
    co.pay_bpartner_id,
    co.pay_location_id,
    co.paymentrule,
    co.poreference,
    co.priorityrule,
    co.quotationorder_id,
    co.salesrep_id,
    co.totallines,
    co.updated,
    co.updatedby,
    co.user1_id,
    co.user2_id,
    co.volume,
    co.weight,
    bp.c_bp_group_id,
    bp.cof_tipoparceiro_id,
    bp.cof_classeparceiro_id,
    bp.cof_vendedorinterno_id,
    trunc(sum(((((((col.linenetamt + col.cof_otheramt) + col.freightamt) + col.cof_insuranceamt) + ( SELECT
                CASE
                    WHEN (sum(tl.lbr_taxamt) IS NULL) THEN (0)::numeric
                    ELSE sum(tl.lbr_taxamt)
                END AS sum
           FROM lbr_taxline tl
          WHERE ((tl.lbr_tax_id = col.lbr_tax_id) AND (tl.istaxincluded = 'N'::bpchar)))) / col.qtyentered) * col.qtyinvoiced)), 2) AS valorfaturado,
    trunc(sum(((((((col.linenetamt + col.cof_otheramt) + col.freightamt) + col.cof_insuranceamt) + ( SELECT
                CASE
                    WHEN (sum(tl.lbr_taxamt) IS NULL) THEN (0)::numeric
                    ELSE sum(tl.lbr_taxamt)
                END AS sum
           FROM lbr_taxline tl
          WHERE ((tl.lbr_tax_id = col.lbr_tax_id) AND (tl.istaxincluded = 'N'::bpchar)))) / col.qtyentered) * col.qtydelivered)), 2) AS valorentregue,
    trunc(sum(((((((col.linenetamt + col.cof_otheramt) + col.freightamt) + col.cof_insuranceamt) + ( SELECT
                CASE
                    WHEN (sum(tl.lbr_taxamt) IS NULL) THEN (0)::numeric
                    ELSE sum(tl.lbr_taxamt)
                END AS sum
           FROM lbr_taxline tl
          WHERE ((tl.lbr_tax_id = col.lbr_tax_id) AND (tl.istaxincluded = 'N'::bpchar)))) / col.qtyentered) * (col.qtyentered - col.qtyinvoiced))), 2) AS valorafaturar,
    trunc(sum(((((((col.linenetamt + col.cof_otheramt) + col.freightamt) + col.cof_insuranceamt) + ( SELECT
                CASE
                    WHEN (sum(tl.lbr_taxamt) IS NULL) THEN (0)::numeric
                    ELSE sum(tl.lbr_taxamt)
                END AS sum
           FROM lbr_taxline tl
          WHERE ((tl.lbr_tax_id = col.lbr_tax_id) AND (tl.istaxincluded = 'N'::bpchar)))) / col.qtyentered) * col.qtyreserved)), 2) AS valoraentregar,
    trunc((sum(((((((col.linenetamt + col.cof_otheramt) + col.freightamt) + col.cof_insuranceamt) + ( SELECT
                CASE
                    WHEN (sum(tl.lbr_taxamt) IS NULL) THEN (0)::numeric
                    ELSE sum(tl.lbr_taxamt)
                END AS sum
           FROM lbr_taxline tl
          WHERE ((tl.lbr_tax_id = col.lbr_tax_id) AND (tl.istaxincluded = 'N'::bpchar)))) / col.qtyentered) * col.qtyinvoiced)) - ( SELECT
                CASE
                    WHEN (sum(invoiceopen(inv.c_invoice_id, (0)::numeric)) IS NULL) THEN (0)::numeric
                    ELSE sum(invoiceopen(inv.c_invoice_id, (0)::numeric))
                END AS sum
           FROM c_invoice inv
          WHERE ((inv.c_order_id = co.c_order_id) AND ((inv.docstatus = 'CO'::bpchar) OR (inv.docstatus = 'CL'::bpchar))))), 2) AS valorrecebido,
    trunc(( SELECT
                CASE
                    WHEN (sum(invoiceopen(inv.c_invoice_id, (0)::numeric)) IS NULL) THEN (0)::numeric
                    ELSE sum(invoiceopen(inv.c_invoice_id, (0)::numeric))
                END AS sum
           FROM c_invoice inv
          WHERE ((inv.c_order_id = co.c_order_id) AND ((inv.docstatus = 'CO'::bpchar) OR (inv.docstatus = 'CL'::bpchar)))), 2) AS valorareceber
   FROM ((c_order co
     LEFT JOIN c_orderline col ON ((col.c_order_id = co.c_order_id)))
     LEFT JOIN c_bpartner bp ON ((bp.c_bpartner_id = co.c_bpartner_id)))
  WHERE (col.qtyentered > (0)::numeric)
  GROUP BY co.ad_client_id, co.ad_org_id, co.ad_user_id, co.bill_bpartner_id, co.bill_location_id, co.bill_user_id, co.c_activity_id, co.c_bpartner_id, co.c_bpartner_location_id, co.c_campaign_id, co.c_doctypetarget_id, co.cof_bpespecialista_id, co.cof_c_custody_id, co.cof_contract_id, co.cof_c_planofinanceiro_id, co.cof_customercpf, co.cof_digitador_id, co.cof_estimatedtotalweight, co.cof_exibiremrelatorios, co.cof_fatorfinanceiro, co.cof_freightamt, co.cof_insuranceamt, co.cof_jurosmensal, co.cof_markupaverage, co.cof_markupminimum, co.cof_markupreal, co.cof_markupvariation, co.cof_modfrete, co.cof_m_shipregion_id, co.cof_nomeconsumidor, co.cof_orgst_id, co.cof_otheramt, co.cof_payfrom_location_id, co.cof_pnlocationretira_id, co.cof_pnretira_id, co.cof_reason_close_observation, co.cof_reason_closing_order_id, co.cof_serienfentrada, co.cof_situacaocomercial, co.cof_tempomedio, co.cof_tipoexportacao, co.cof_tributacaodestino, co.cof_ufsaidapais, co.cof_xlocdespacho, co.cof_xlocexporta, co.c_opportunity_id, co.c_order_id, co.c_ordersource_id, co.c_payment_id, co.c_paymentterm_id, co.c_project_id, co.createdby, co.created, co.dateacct, co.dateordered, co.datepromised, co.deliveryrule, co.deliveryviarule, co.description, co.docstatus, co.documentno, co.grandtotal, co.infnfe_id, co.invoicerule, co.isactive, co.isapproved, co.isprinted, co.issotrx, co.lbr_nfdescription, co.lbr_nfentrada, co.lbr_nfmodel, co.lbr_transactiontype, co.m_freightcategory_id, co.m_pricelist_id, co.m_shipper_id, co.m_warehouse_id, co.pay_bpartner_id, co.pay_location_id, co.paymentrule, co.poreference, co.priorityrule, co.quotationorder_id, co.salesrep_id, co.totallines, co.updated, co.updatedby, co.user1_id, co.user2_id, co.volume, co.weight, bp.c_bp_group_id, bp.cof_tipoparceiro_id, bp.cof_classeparceiro_id, bp.cof_vendedorinterno_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views