c_order

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_order_id numeric 10 null
b_buyerfunds.c_order_id corder_bbuyersfunds R
b_sellerfunds.c_order_id corder_bsellerfunds R
c_allocationline.c_order_id corder_callocation R
c_dunning_line_v.c_invoice_c_order_id Implied Constraint R
c_dunning_line_v.c_payment_c_order_id Implied Constraint R
c_dunning_line_vt.c_invoice_c_order_id Implied Constraint R
c_dunning_line_vt.c_payment_c_order_id Implied Constraint R
c_invoice.c_order_id corder_cinvoice R
c_invoice.cof_ref_order_id cofreforder_cinvoice R
c_invoice_candidate_v.c_order_id Implied Constraint R
c_invoice_header_v.c_order_id Implied Constraint R
c_invoice_header_vt.c_order_id Implied Constraint R
c_invoice_v.c_order_id Implied Constraint R
c_invoice_v1.c_order_id Implied Constraint R
c_opportunity.c_order_id corder_copportunity R
c_order.link_order_id linkorder_corder R
c_order.quotationorder_id quotationorder_corder R
c_order.ref_order_id corder_ref R
c_order_header_v.c_order_id Implied Constraint R
c_order_header_vt.c_order_id Implied Constraint R
c_order_linetax_v.c_order_id Implied Constraint R
c_order_linetax_vt.c_order_id Implied Constraint R
c_orderlandedcost.c_order_id corder_corderlandedcost R
c_orderline.c_order_id corder_corderline R
c_orderpayschedule.c_order_id corder_corderpayschedule C
c_ordertax.c_order_id corder_cordertax C
c_payment.c_order_id corder_cpayment R
c_payment_v.c_order_id Implied Constraint R
c_paymenttransaction.c_order_id corder_cpaymenttransaction R
c_payselection_check_v.c_payment_c_order_id Implied Constraint R
c_payselection_check_vt.c_payment_c_order_id Implied Constraint R
c_pospayment.c_order_id corder_cpospayment R
c_project_details_v.c_order_id Implied Constraint R
c_project_details_vt.c_order_id Implied Constraint R
c_projectline.c_order_id corder_cprojectline R
c_projectline.c_orderpo_id corderpo_cprojectline R
c_projectphase.c_order_id corder_cprojectphase R
c_recurring.c_order_id corder_crecurring R
c_recurring_run.c_order_id corder_crecurringrun R
c_rfq.c_order_id corder_crfq R
c_rfqresponse.c_order_id corder_crfqresponse R
cof_c_invoice_candidate_v.c_order_id Implied Constraint R
cof_c_previsaoentregafutura.c_order_id corder_cofcprevisaoentregafutu R
cof_controleremessasind.c_order_id corder_cofcontroleremessasind R
cof_inoutline_candidate_v.c_order_id Implied Constraint R
cof_itemsubstituto.c_order_id corder_cofitemsubstituto R
cof_m_inout_candidate_v.c_order_id Implied Constraint R
cof_ordemservico.cof_orderproduto_id coforderproduto_cofordemservic N
cof_ordemservico.cof_orderservico_id coforderservico_cofordemservic N
cof_packinglist_line.c_order_id corder_cofpackinglistline R
cof_rps.c_order_id corder_cofrps R
cof_rv_detalheslistaembarque.c_order_id Implied Constraint R
cof_rv_detalhesproducao.c_order_id Implied Constraint R
cof_rv_docfiscal.c_order_id Implied Constraint R
cof_rv_faturamentoprodutomargem.c_order_id Implied Constraint R
cof_rv_infodevolucao.c_order_id Implied Constraint R
cof_rv_itenspago.c_order_id Implied Constraint R
cof_rv_mapa_pedido.c_order_id Implied Constraint R
cof_rv_oportunidadevenda.c_order_id Implied Constraint R
cof_rv_requestpartner.c_order_id Implied Constraint R
cof_rv_titulos.c_order_id Implied Constraint R
cof_titulo.c_order_id corder_coftitulo R
cof_tratamentopedido.c_order_id corder_coftratamentopedido R
dd_order.c_order_id corder_ddorder R
dd_order.ref_order_id reforder_ddorder R
dd_order_header_v.c_order_id Implied Constraint R
dd_order_header_vt.c_order_id Implied Constraint R
i_inout.c_order_id corder_iinout R
i_order.c_order_id corder_iorder N
lbr_docfiscal.c_order_id Implied Constraint R
m_inout.c_order_id corder_minout R
m_inout_candidate_v.c_order_id Implied Constraint R
m_inout_header_v.c_order_id Implied Constraint R
m_inout_header_vt.c_order_id Implied Constraint R
m_inoutconfirm_v.c_order_id Implied Constraint R
m_inoutconfirm_vt.c_order_id Implied Constraint R
m_rma.c_order_id corder_mrma R
m_shippingtransaction.c_order_id corder_mshippingtransaction R
pp_mrp.c_order_id corder_ppmrp R
r_request.c_order_id corder_rrequest R
r_request_v.c_order_id Implied Constraint R
r_requestaction.c_order_id corder_rrequestaction R
rv_allocation.c_order_id Implied Constraint R
rv_bpartneropen.c_order_id Implied Constraint R
rv_c_invoice.c_order_id Implied Constraint R
rv_c_invoicetax.c_order_id Implied Constraint R
rv_commissionrundetail.c_invoice_c_order_id Implied Constraint R
rv_commissionrundetail.c_order_c_order_id Implied Constraint R
rv_commissionrundetail.c_orderline_c_order_id Implied Constraint R
rv_dd_orderdetail.c_order_id Implied Constraint R
rv_inoutconfirm.c_order_id Implied Constraint R
rv_inoutdetails.c_order_id Implied Constraint R
rv_inoutlineconfirm.c_order_id Implied Constraint R
rv_invoicepayschedule.c_order_id Implied Constraint R
rv_openitem.c_order_id Implied Constraint R
rv_openitemtodate.c_order_id Implied Constraint R
rv_orderdetail.c_order_id Implied Constraint R
rv_payment.c_order_id Implied Constraint R
t_cashflow.c_order_id Implied Constraint R
t_invoicegl_v.c_order_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_corder R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
issotrx bpchar 1 'Y'::bpchar
documentno varchar 30 null
docstatus bpchar 2 null
docaction bpchar 2 null
processing bpchar 1 √ null
processed bpchar 1 'N'::bpchar
c_doctype_id numeric 10 null
c_doctype.c_doctype_id c_doctype_corder R
c_doctypetarget_id numeric 10 null
c_doctype.c_doctype_id cdoctypetarget_corder R
description varchar 500 √ null
isapproved bpchar 1 'N'::bpchar
iscreditapproved bpchar 1 'N'::bpchar
isdelivered bpchar 1 'N'::bpchar
isinvoiced bpchar 1 'N'::bpchar
isprinted bpchar 1 'N'::bpchar
istransferred bpchar 1 'N'::bpchar
isselected bpchar 1 'N'::bpchar
salesrep_id numeric 10 √ null
ad_user.ad_user_id aduser_sr_corder R
dateordered timestamp 29,6 null
datepromised timestamp 29,6 √ null
dateprinted timestamp 29,6 √ null
dateacct timestamp 29,6 null
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_corder R
c_bpartner_location_id numeric 10 null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_corder R
poreference varchar 20 √ null
isdiscountprinted bpchar 1 'Y'::bpchar
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_corder R
paymentrule bpchar 1 null
c_paymentterm_id numeric 10 null
c_paymentterm.c_paymentterm_id cpaymentterm_soheader R
invoicerule bpchar 1 null
deliveryrule bpchar 1 null
freightcostrule bpchar 1 null
freightamt numeric 0 √ 0
deliveryviarule bpchar 1 null
m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id mshipper_corder R
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_corder R
chargeamt numeric 0 √ 0
priorityrule bpchar 1 null
totallines numeric 0 0
grandtotal numeric 0 0
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id mwarehouse_corder R
m_pricelist_id numeric 10 null
m_pricelist.m_pricelist_id mpricelist_soheader R
istaxincluded bpchar 1 'N'::bpchar
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_corder R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_corder R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_corder R
posted bpchar 1 'N'::bpchar
c_payment_id numeric 10 √ null
c_payment.c_payment_id cpayment_corder R
c_cashline_id numeric 10 √ null
c_cashline.c_cashline_id ccashline_corder R
sendemail bpchar 1 'N'::bpchar
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_corder R
copyfrom bpchar 1 √ null
isselfservice bpchar 1 'N'::bpchar
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_corder R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser1_corder R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celemenrvalueuser2_corder R
c_conversiontype_id numeric 10 √ null
c_conversiontype.c_conversiontype_id cconversiontype_corder R
bill_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartnerbill_corder R
bill_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbplocationbill_corder R
bill_user_id numeric 10 √ null
ad_user.ad_user_id aduserbill_corder R
pay_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartnerpay_corder R
pay_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbplocationpay_corder R
ref_order_id numeric 10 √ null
c_order.c_order_id corder_ref R
isdropship bpchar 1 'N'::bpchar
volume numeric 0 √ null
weight numeric 0 √ null
ordertype varchar 510 √ null
c_pos_id numeric 10 √ null
c_pos.c_pos_id cpos_corder R
amounttendered numeric 22,2 √ null
amountrefunded numeric 22,2 √ null
link_order_id numeric 10 √ null
c_order.c_order_id linkorder_corder R
m_freightcategory_id numeric 10 √ NULL::numeric
m_freightcategory.m_freightcategory_id mfreightcategory_order R
dropship_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id dropshipbpartner_corder R
dropship_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id dropshiplocation_corder R
dropship_user_id numeric 10 √ null
ad_user.ad_user_id dropshipuser_corder R
promotioncode varchar 30 √ null
c_ordersource_id numeric 10 √ null
c_ordersource.c_ordersource_id c_order__c_orders_c_ordersou R
processedon numeric 0 √ null
ispayschedulevalid bpchar 1 'N'::bpchar
c_cashplanline_id numeric 10 √ NULL::numeric
c_cashplanline.c_cashplanline_id ccashplanline_corder R
c_order_uu varchar 36 √ NULL::character varying
shippingrateinquiry bpchar 1 √ NULL::bpchar
ispriviledgedrate bpchar 1 'N'::bpchar
c_opportunity_id numeric 10 √ NULL::numeric
c_opportunity.c_opportunity_id copportunity_corder R
lbr_transactiontype varchar 3 null
lbr_nfdescription varchar 255 √ null
proccreatepo bpchar 1 √ null
lbr_nfentrada varchar 25 √ null
cof_freightamt numeric 0 √ (0)::numeric
cof_otheramt numeric 0 √ (0)::numeric
cof_insuranceamt numeric 0 √ (0)::numeric
cof_modfrete bpchar 1 '1'::bpchar
cof_c_custody_id numeric 10 √ NULL::numeric
cof_c_custody.cof_c_custody_id cofccustody_corder R
cof_ismarkup bpchar 1 √ 'N'::bpchar
cof_markupaverage numeric 0 √ (0)::numeric
cof_markupreal numeric 0 √ (0)::numeric
quotationorder_id numeric 10 √ NULL::numeric
c_order.c_order_id quotationorder_corder R
cof_payfrom_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cofpayfromlocation_corder R
cof_isgeneratenftransp bpchar 1 √ 'N'::bpchar
cof_deliverynote varchar 255 √ NULL::character varying
cof_markupminimum numeric 0 √ (0)::numeric
cof_markupvariation numeric 0 √ (0)::numeric
cof_proratediscount bpchar 1 √ NULL::bpchar
cof_reason_closing_order_id numeric 10 √ null
cof_reason_closing_order.cof_reason_closing_order_id cofreasonclosingorder_corder R
cof_reason_close_observation text 2147483647 √ null
cof_estimatedtotalweight numeric 0 √ (0)::numeric
cof_m_shipregion_id numeric 10 √ NULL::numeric
cof_m_shipregion.cof_m_shipregion_id cofmshipregion_corder R
cof_tipoexportacao bpchar 1 √ NULL::bpchar
cof_ufsaidapais varchar 2 √ NULL::character varying
cof_xlocexporta varchar 60 √ NULL::character varying
cof_xlocdespacho varchar 60 √ NULL::character varying
cof_customercpf varchar 14 √ NULL::character varying
cof_processing2 bpchar 1 √ NULL::bpchar
cof_orgst_id numeric 10 √ NULL::numeric
cof_orgst.cof_orgst_id Implied Constraint R
cof_proctransmitnfe bpchar 1 √ NULL::bpchar
cof_isindustrialization bpchar 1 √ 'N'::bpchar
cof_createreceipt bpchar 1 √ NULL::bpchar
cof_c_planofinanceiro_id numeric 10 √ null
cof_c_planofinanceiro.cof_c_planofinanceiro_id cofcplanofinanceiro_corder R
cof_processing bpchar 1 √ NULL::bpchar
cof_exibiremrelatorios bpchar 1 √ 'Y'::bpchar
cof_criadopeloimportadorxml bpchar 1 √ 'N'::bpchar
infnfe_id varchar 44 √ NULL::character varying
cof_serienfentrada numeric 10 √ NULL::numeric
lbr_nfmodel varchar 2 √ NULL::character varying
pag_vtroco numeric 0 √ '0'::numeric
cof_situacaocomercial varchar 4 √ null
cof_fatorfinanceiro numeric 0 √ '0'::numeric
cof_contract_id numeric 10 √ NULL::numeric
cof_contract.cof_contract_id cofcontract_corder R
cof_paymentterm_id numeric 10 √ NULL::numeric
c_paymentterm.c_paymentterm_id cofpaymentterm_corder R
cof_digitador_id numeric 10 √ NULL::numeric
ad_user.ad_user_id cofdigitador_corder R
cof_bpespecialista_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofbpespecialista_corder R
cof_jurosmensal numeric 0 '0'::numeric
cof_tempomedio numeric 0 '0'::numeric
cof_processing3 bpchar 1 √ NULL::bpchar
cof_afterdelivery bpchar 1 √ NULL::bpchar
cof_nomeconsumidor varchar 255 √ NULL::character varying
cof_liberarentregafutura bpchar 1 'N'::bpchar
lbr_recalculatetax bpchar 1 √ 'N'::bpchar
cof_pnretira_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofpnretira_corder R
cof_pnlocationretira_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cofpnlocationretira_corder R
cof_tributacaodestino bpchar 1 'N'::bpchar
cof_valproposta timestamp 29,6 √ null
cof_isremessaindustrializacaoprestador bpchar 1 √ 'N'::bpchar
cof_isentradaindustrializacaoprestador bpchar 1 √ 'N'::bpchar
cof_pnconcorrente_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofpnconcorrente_corder R
cof_pnconcorrente_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cofpnconcorrentelocation_corde R

Indexes

Constraint Name Type Sort Column(s)
c_order_pkey Primary key Asc c_order_id
c_order_bpartner Performance Asc c_bpartner_id
c_order_documentno Must be unique Asc/Asc/Asc documentno + c_doctype_id + c_bpartner_id
c_order_processed Performance Asc/Asc processed + ad_client_id
c_order_uu_idx Must be unique Asc c_order_uu
idxc_order_proc_on Performance Asc/Asc/Asc/Asc posted + processed + processedon + ad_client_id

Check Constraints

Constraint Name Constraint
c_order_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_isentradaindustrializacaoprestador_check ((cof_isentradaindustrializacaoprestador = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_lbr_recalculatetax_check ((lbr_recalculatetax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_afterdelivery_check ((cof_afterdelivery = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_istransferred_check ((istransferred = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_exibiremrelatorios_check ((cof_exibiremrelatorios = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_isinvoiced_check ((isinvoiced = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_liberarentregafutura_check ((cof_liberarentregafutura = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_ispriviledgedrate_check ((ispriviledgedrate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_iscreditapproved_check ((iscreditapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_isindustrialization_check ((cof_isindustrialization = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_isdiscountprinted_check ((isdiscountprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_isgeneratenftransp_check ((cof_isgeneratenftransp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_isdelivered_check ((isdelivered = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_isremessaindustrializacaoprestador_check ((cof_isremessaindustrializacaoprestador = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_isselected_check ((isselected = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_criadopeloimportadorxml_check ((cof_criadopeloimportadorxml = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_ismarkup_check ((cof_ismarkup = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_ispayschedulevalid_check ((ispayschedulevalid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_istaxincluded_check ((istaxincluded = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_order_cof_tributacaodestino_check ((cof_tributacaodestino = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation