c_bpartner

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_bpartner_id numeric 10 null
a_asset.c_bpartner_id cbpartner_aasset R
a_asset.c_bpartnersr_id cbpartnersr_aasset R
a_asset.lease_bpartner_id leasebpartner_aasset R
a_asset_change.c_bpartner_id cbpartner_aassetchange R
a_asset_change.c_invoice_c_bpartner_id cinvoicecbpartner_aassetchange R
a_asset_info_fin.c_bpartner_id cbpartner_aassetinfofin R
a_registration.c_bpartner_id cbpartner_aregistration R
ad_archive.c_bpartner_id cbpartner_adarchive R
ad_clientinfo.c_bpartnercashtrx_id cbpartnercashtrx_adclientinfo R
ad_org_v.c_bpartner_id Implied Constraint R
ad_user.c_bpartner_id cbpartner_aduser C
ad_wf_node.c_bpartner_id cbpartner_adwfnode R
c_acctschema_element.c_bpartner_id cbuspartner_caschemaelement R
c_allocationline.c_bpartner_id cbpartner_callocationline R
c_bankstatementline.c_bpartner_id cbpartner_cbankstatementline R
c_banktransfer.from_c_bpartner_id fromcbpartner_cbanktransfer R
c_banktransfer.to_c_bpartner_id tocbpartner_cbanktransfer R
c_bp_bankaccount.c_bpartner_id cbpartner_cbpbankaccount C
c_bp_customer_acct.c_bpartner_id cbuspartner_cbpcustomer_acct C
c_bp_edi.c_bpartner_id c_bpartner_cbpedi R
c_bp_employee_acct.c_bpartner_id cbuspartner_c_bpemployeeacct C
c_bp_relation.c_bpartner_id cbpartner_cbprelation R
c_bp_relation.c_bpartnerrelation_id cbpartner_cbprelationbp R
c_bp_shippingacct.c_bpartner_id cbpartner_cbpshippingacct R
c_bp_vendor_acct.c_bpartner_id c_buspartner_c_bp_vendor_acct C
c_bp_withholding.c_bpartner_id cbpartner_cbpwithholding C
c_bpartner.bpartner_parent_id cbpartner_cpbartnerparent R
c_bpartner_location.c_bpartner_id cbpartner_cbplocation C
c_bpartner_product.c_bpartner_id cbpartner_cbpproduct C
c_cashplan.c_bpartner_id cbpartner_ccashplan R
c_cashplanline.c_bpartner_id cbpartner_ccashplanline R
c_charge.c_bpartner_id cbpartner_ccharge R
c_commission.c_bpartner_id cbpartner_ccommission R
c_commissionline.c_bpartner_id cbpartner_ccommissionline R
c_dunning_header_v.ad_user_c_bpartner_id Implied Constraint R
c_dunning_header_v.c_bpartner_id Implied Constraint R
c_dunning_header_v.salesrep_c_bpartner_id Implied Constraint R
c_dunning_header_vt.ad_user_c_bpartner_id Implied Constraint R
c_dunning_header_vt.c_bpartner_id Implied Constraint R
c_dunning_header_vt.salesrep_c_bpartner_id Implied Constraint R
c_dunning_line_v.c_invoice_c_bpartner_id Implied Constraint R
c_dunning_line_v.c_payment_c_bpartner_id Implied Constraint R
c_dunning_line_vt.c_invoice_c_bpartner_id Implied Constraint R
c_dunning_line_vt.c_payment_c_bpartner_id Implied Constraint R
c_dunningrunentry.c_bpartner_id cbpartner_cdunningrunentry R
c_invoice.c_bpartner_id cbpartner_cinvoice R
c_invoice.cof_bpespecialista_id cofbpespecialista_cinvoice R
c_invoice_candidate_v.c_bpartner_id Implied Constraint R
c_invoice_createfrom_v.c_bpartner_id Implied Constraint R
c_invoice_header_v.ad_user_c_bpartner_id Implied Constraint R
c_invoice_header_v.bp_location_c_bpartner_id Implied Constraint R
c_invoice_header_v.c_bpartner_id Implied Constraint R
c_invoice_header_v.salesrep_c_bpartner_id Implied Constraint R
c_invoice_header_vt.ad_user_c_bpartner_id Implied Constraint R
c_invoice_header_vt.bp_location_c_bpartner_id Implied Constraint R
c_invoice_header_vt.c_bpartner_id Implied Constraint R
c_invoice_header_vt.salesrep_c_bpartner_id Implied Constraint R
c_invoice_v.c_bpartner_id Implied Constraint R
c_invoice_v1.c_bpartner_id Implied Constraint R
c_invoicebatchline.c_bpartner_id cbpartner_cinvoicebatchline R
c_invoiceline_v.c_bpartner_id Implied Constraint R
c_opportunity.c_bpartner_id cbpartner_copportunity R
c_order.bill_bpartner_id cbpartnerbill_corder R
c_order.c_bpartner_id cbpartner_corder R
c_order.cof_bpespecialista_id cofbpespecialista_corder R
c_order.cof_pnconcorrente_id cofpnconcorrente_corder R
c_order.cof_pnretira_id cofpnretira_corder R
c_order.dropship_bpartner_id dropshipbpartner_corder R
c_order.pay_bpartner_id cbpartnerpay_corder R
c_order_header_v.ad_user_c_bpartner_id Implied Constraint R
c_order_header_v.bill_bp_location_c_bpartner_id Implied Constraint R
c_order_header_v.bill_user_c_bpartner_id Implied Constraint R
c_order_header_v.bp_location_c_bpartner_id Implied Constraint R
c_order_header_v.c_bpartner_id Implied Constraint R
c_order_header_v.cof_cob_location_c_bpartner_id Implied Constraint R
c_order_header_v.salesrep_c_bpartner_id Implied Constraint R
c_order_header_vt.ad_user_c_bpartner_id Implied Constraint R
c_order_header_vt.bill_bp_location_c_bpartner_id Implied Constraint R
c_order_header_vt.bill_user_c_bpartner_id Implied Constraint R
c_order_header_vt.bp_location_c_bpartner_id Implied Constraint R
c_order_header_vt.c_bpartner_id Implied Constraint R
c_order_header_vt.cof_cob_location_c_bpartner_id Implied Constraint R
c_order_header_vt.salesrep_c_bpartner_id Implied Constraint R
c_orderline.c_bpartner_id cbpartner_soline R
c_payment.c_bpartner_id cbpartner_cpayment R
c_payment_v.c_bpartner_id Implied Constraint R
c_paymenttransaction.c_bpartner_id cbpartner_cpaymenttransaction R
c_payselection_check_v.c_bpartner_id Implied Constraint R
c_payselection_check_v.c_payment_c_bpartner_id Implied Constraint R
c_payselection_check_vt.c_bpartner_id Implied Constraint R
c_payselection_check_vt.c_payment_c_bpartner_id Implied Constraint R
c_payselection_remittance_v.c_bpartner_id Implied Constraint R
c_payselection_remittance_vt.c_bpartner_id Implied Constraint R
c_payselectioncheck.c_bpartner_id cbpartner_cpayselectioncheck R
c_pos.c_bpartnercashtrx_id cbpartnercashtrx_cpos R
c_project.c_bpartner_id cbpartner_cproject R
c_project.c_bpartnersr_id cbpartnersr_cproject R
c_project_details_v.c_bpartner_id Implied Constraint R
c_project_details_vt.c_bpartner_id Implied Constraint R
c_project_header_v.ad_user_c_bpartner_id Implied Constraint R
c_project_header_v.c_bp_location_c_bpartner_id Implied Constraint R
c_project_header_v.c_bpartner_id Implied Constraint R
c_project_header_v.salesrep_c_bpartner_id Implied Constraint R
c_project_header_vt.ad_user_c_bpartner_id Implied Constraint R
c_project_header_vt.c_bp_location_c_bpartner_id Implied Constraint R
c_project_header_vt.c_bpartner_id Implied Constraint R
c_project_header_vt.salesrep_c_bpartner_id Implied Constraint R
c_rfq.c_bpartner_id cbpartner_crfq R
c_rfq_topicsubscriber.c_bpartner_id cbpartner_crfqtopicsubr R
c_rfqresponse.c_bpartner_id cbpartner_crfqresponse R
c_rfqresponse_v.c_bpartner_id Implied Constraint R
c_rfqresponse_vt.c_bpartner_id Implied Constraint R
c_subscription.c_bpartner_id cbpartner_csubscription R
c_taxdeclarationline.c_bpartner_id cbpartner_ctaxdeclline R
c_taxdefinition.c_bpartner_id cbpartner_ctaxdefinition R
c_validcombination.c_bpartner_id cbpartner_vc R
c_withholding.beneficiary benefici_cwithholding R
cof_activity.c_bpartner_id cbpartner_cofactivity R
cof_autorizadosxml.c_bpartner_id cbpartner_cofautorizadosxml R
cof_c_acct_ignoreelement.c_bpartner_id cbpartner_cofcacctignoreelemen R
cof_c_cardnetwork.c_bpartner_id cbpartner_cofccardnetwork R
cof_c_controlcheck.c_bpartner_id cbpartner_cofccontrolcheck R
cof_c_controlcheck.cof_bpartner_id cofbpartner_cofccontrolcheck R
cof_c_dossier.c_bpartner_id cbpartner_cofcdossier R
cof_c_invoice_candidate_v.c_bpartner_id Implied Constraint R
cof_c_markup.c_bpartner_id cbpartner_cofcmarkup R
cof_c_taxdetermination_fact.c_bpartner_id cbpartner_cofctaxdeterminationfact R
cof_c_taxdetermination_line.c_bpartner_id cbpartner_cofctaxdeterminationline R
cof_chamadapbx.c_bpartner_id cbpartner_cofchamadapbx R
cof_contract.c_bpartner_id cbpartner_cofcontract R
cof_contractgroup.c_bpartner_id cof_contractgroup_c_bpartner_id R
cof_contractparticipantes.c_bpartner_id cbpartner_cofcontractparticipa R
cof_controleremessasind.c_bpartner_id cbpartner_cofcontroleremessasi R
cof_creditanalysis.c_bpartner_id cbpartner_cofcreditanalysis R
cof_deliveryrestriction.c_bpartner_id cbpartner_cofdeliveryrestricti R
cof_driver.c_bpartner_id cbpartner_cofdriver R
cof_dunningdetails_v.c_bpartner_id Implied Constraint R
cof_inoutline_candidate_v.c_bpartner_id Implied Constraint R
cof_m_inout_candidate_v.c_bpartner_id Implied Constraint R
cof_mdfe.emit_bpartner_id emitbpartner_cofmdfe R
cof_metarepresentante.c_bpartner_id cbpartner_cofmetarepresentante R
cof_orcamentoconfig.c_bpartner_id cbpartner_coforcamentoconfig R
cof_ordemservico.c_bpartner_id cbpartner_cofordemservico R
cof_ordemservico.cof_bpinternal_id cofbpinternal_cofordemservico R
cof_osapontamentos.cof_bpoperador_id cofbpoperador_cofosapontamento R
cof_packinglist_line.c_bpartner_id cbpartner_cofpackinglistline R
cof_parceirosadicionais.c_bpartner_id cbpartner_cofparceirosadiciona R
cof_participant.c_bpartner_id Implied Constraint R
cof_pneu_manutencao.c_bpartner_id cbpartner_cofpneumanutencao R
cof_pneu_marca.c_bpartner_id cbpartner_cofpneumarca R
cof_positividaderepresentante.c_bpartner_id cbpartner_cofpositividaderepre R
cof_pp_planomestreprodline.c_bpartner_id cbpartner_cofppplanomestreprod R
cof_preferenciaxml.c_bpartner_id cbpartner_cofpreferenciaxml N
cof_retentionconfig.c_bpartner_id cbpartner_cofretentionconfig R
cof_rps.dest_bpartner_id destbpartner_cofrps R
cof_rv_atualizacoes_solicitacao.c_bpartner_id Implied Constraint R
cof_rv_checkallocate.c_bpartner_id Implied Constraint R
cof_rv_commission_composition_detail.c_bpartner_id Implied Constraint R
cof_rv_confimpostos.c_bpartner_id Implied Constraint R
cof_rv_contract.c_bpartner_id Implied Constraint R
cof_rv_controlcheck.c_bpartner_id Implied Constraint R
cof_rv_detalheplanomestre.c_bpartner_id Implied Constraint R
cof_rv_detalheslistaembarque.c_bpartner_id Implied Constraint R
cof_rv_detalheslocalizacao.c_bpartner_id Implied Constraint R
cof_rv_detalhesmovimentocusto.c_bpartner_id Implied Constraint R
cof_rv_detalhesordemservico.c_bpartner_id Implied Constraint R
cof_rv_detalhesordemservicoapontamento.c_bpartner_id Implied Constraint R
cof_rv_detalhesproducao.c_bpartner_id Implied Constraint R
cof_rv_faturamentoprodutomargem.c_bpartner_id Implied Constraint R
cof_rv_gencnab.c_bpartner_id Implied Constraint R
cof_rv_infodevolucao.c_bpartner_id Implied Constraint R
cof_rv_itenspago.c_bpartner_id Implied Constraint R
cof_rv_lead.c_bpartner_id Implied Constraint R
cof_rv_mapa_pedido.c_bpartner_id Implied Constraint R
cof_rv_openiteminterest.c_bpartner_id Implied Constraint R
cof_rv_oportunidadevenda.c_bpartner_id Implied Constraint R
cof_rv_ordemservico.c_bpartner_id Implied Constraint R
cof_rv_requestpartner.c_bpartner_id Implied Constraint R
cof_rv_titulos.c_bpartner_id Implied Constraint R
cof_titulo.c_bpartner_id cbpartner_coftitulo R
cof_v_positividaderepresentante.c_bpartner_id Implied Constraint R
dd_order.c_bpartner_id cbpartner_ddorder R
dd_order_header_v.c_bpartner_id Implied Constraint R
dd_order_header_vt.c_bpartner_id Implied Constraint R
fact_acct.c_bpartner_id c_buspartner_fact_acct R
fact_acct_balance.c_bpartner_id Implied Constraint R
fact_acct_summary.c_bpartner_id cbpartner_factacctsummary R
gl_distribution.c_bpartner_id cbpartner_gldist R
gl_distributionline.c_bpartner_id cbpartner_gldistline R
gl_journalgeneratorline.c_bpartner_id cbpartner_qssjournalgeneratorl R
gl_journalline.c_bpartner_id cbpartner_gljournalline R
gl_journalline_acct_v.c_bpartner_id Implied Constraint R
hr_attribute.c_bpartner_id cbpartner_hrattribute R
hr_contract.c_bpartner_id cbpartner_hrcontract R
hr_employee.c_bpartner_id cbpartner_hremployee R
hr_movement.c_bpartner_id cbpartner_hrmovement R
hr_process.c_bpartner_id cbpartner_hrprocess R
i_asset.c_bpartner_id cbpartner_iasset R
i_bankstatement.c_bpartner_id cbpartner_ibankstatement N
i_bpartner.c_bpartner_id cbpartner_ibpartner N
i_fajournal.c_bpartner_id cbpartner_ifajournal R
i_fixedasset.c_bpartnersr_id cbpartnersr_ifixedasset R
i_gljournal.c_bpartner_id cbpartner_igljournal N
i_hr_movement.c_bpartner_id cbpartner_ihrmovement R
i_inout.c_bpartner_id Implied Constraint R
i_invoice.c_bpartner_id cbpartner_iinvoice N
i_movement.c_bpartner_id cbpartner_imovement R
i_order.c_bpartner_id cbpartner_iorder N
i_payment.c_bpartner_id cbpartner_ipayment N
i_pricelist.c_bpartner_id cbpartner_ipricelist R
i_product.c_bpartner_id cbpartner_iproduct N
i_productplanning.c_bpartner_id cbpartner_iproductplanning R
lbr_di.c_bpartner_id Implied Constraint R
lbr_di.cof_importer_bpartner_id cofimporterbpartner_lbrdi R
lbr_di.cof_legalrepresent_bpartner_id coflegalrepresentbpartner_lbrd R
lbr_di.cof_purchaser_bpartner_id cofpurchaserbpartner_lbrdi R
lbr_docfiscal.cof_pnretira_id cofpnretira_lbrdocfiscal R
lbr_docfiscal_autxml.c_bpartner_id cbpartner_lbrdocfiscalautxml R
lbr_issmatrix.c_bpartner_id cbpartner_lbrissmatrix R
lbr_taxdefinition.c_bpartner_id Implied Constraint R
m_bp_price.c_bpartner_id cbpartner_mbpprice R
m_discountschemaline.c_bpartner_id cbpartner_mdiscountsline R
m_distributionlistline.c_bpartner_id cbpartner_mdistlistline R
m_distributionrun.c_bpartner_id cbpartner_mdistributionrun R
m_inout.c_bpartner_id cbpartner_minout R
m_inout.dropship_bpartner_id dropshipbpartner_minout R
m_inout.returnbpartner_id returnbpartner_minout R
m_inout_candidate_v.c_bpartner_id Implied Constraint R
m_inout_createfrom_v.c_bpartner_id Implied Constraint R
m_inout_header_v.ad_user_c_bpartner_id Implied Constraint R
m_inout_header_v.c_bp_location_c_bpartner_id Implied Constraint R
m_inout_header_v.c_bpartner_id Implied Constraint R
m_inout_header_vt.ad_user_c_bpartner_id Implied Constraint R
m_inout_header_vt.c_bp_location_c_bpartner_id Implied Constraint R
m_inout_header_vt.c_bpartner_id Implied Constraint R
m_inoutconfirm_v.c_bpartner_id Implied Constraint R
m_inoutconfirm_vt.c_bpartner_id Implied Constraint R
m_locator.c_bpartner_id Implied Constraint R
m_movement.c_bpartner_id cbpartner_mmovement R
m_movement_candidate_v.c_bpartner_id Implied Constraint R
m_product_po.c_bpartner_id c_buspartner_m_product_po R
m_production.c_bpartner_id cbpartner_mproduction R
m_production.cof_pncontratante_id cofpncontratante_mproduction R
m_productpricevendorbreak.c_bpartner_id cbpartner_mproductpricevendorb R
m_promotionprecondition.c_bpartner_id cbpartner_mpromotionpreconditi R
m_requisitionline.c_bpartner_id cbpartner_mrequisitionline R
m_rma.c_bpartner_id cbpartner_mrma R
m_rma_createfrom_v.c_bpartner_id Implied Constraint R
m_shipper.c_bpartner_id cbpartner_mshipper R
m_shippingtransaction.c_bpartner_id cbpartner_mshippingtransaction R
m_shippingtransaction.returnbpartner_id returnbpartner_mshippingtransa R
pa_goalrestriction.c_bpartner_id cbpartner_pagoalrestriction R
pa_reportcolumn.c_bpartner_id cbpartner_pareportcolumn R
pa_reportsource.c_bpartner_id cbpartner_pareportsource R
pa_sla_goal.c_bpartner_id cbpartner_paslagoal R
pp_mrp.c_bpartner_id cbpartner_ppmrp R
pp_order_node.c_bpartner_id cbpartner_ppordernode R
pp_order_node_v.c_bpartner_id Implied Constraint R
pp_order_node_vt.c_bpartner_id Implied Constraint R
r_request.c_bpartner_id c_bpartner_rrequest R
r_request_v.c_bpartner_id Implied Constraint R
r_requestaction.c_bpartner_id cbpartner_rrequestaction R
rv_allocation.c_bpartner_id Implied Constraint R
rv_asset_customer.c_bpartner_id Implied Constraint R
rv_asset_delivery.c_bpartner_id Implied Constraint R
rv_asset_summonth.c_bpartner_id Implied Constraint R
rv_bpartner.ad_user_c_bpartner_id Implied Constraint R
rv_bpartner.c_bp_location_c_bpartner_id Implied Constraint R
rv_bpartner.c_bpartner_id Implied Constraint R
rv_bpartneropen.c_bpartner_id Implied Constraint R
rv_c_invoice.c_bp_location_c_bpartner_id Implied Constraint R
rv_c_invoice.c_bpartner_id Implied Constraint R
rv_c_invoice_customerprodqtr.c_bpartner_id Implied Constraint R
rv_c_invoice_customervendqtr.c_bpartner_id Implied Constraint R
rv_c_invoice_day.c_bpartner_id Implied Constraint R
rv_c_invoice_month.c_bpartner_id Implied Constraint R
rv_c_invoice_productmonth.c_bpartner_id Implied Constraint R
rv_c_invoice_prodweek.c_bpartner_id Implied Constraint R
rv_c_invoice_vendormonth.c_bpartner_id Implied Constraint R
rv_c_invoice_week.c_bpartner_id Implied Constraint R
rv_c_invoiceline.c_bpartner_id Implied Constraint R
rv_c_invoicetax.c_bpartner_id Implied Constraint R
rv_c_rfq_unanswered.c_bpartner_id Implied Constraint R
rv_c_rfqresponse.c_bpartner_id Implied Constraint R
rv_click_month.c_bpartner_id Implied Constraint R
rv_commissionrundetail.c_bpartner_id Implied Constraint R
rv_commissionrundetail.c_orderline_c_bpartner_id Implied Constraint R
rv_dd_orderdetail.c_bpartner_id Implied Constraint R
rv_fact_acct.c_bpartner_id Implied Constraint R
rv_fact_acct_day.c_bpartner_id Implied Constraint R
rv_fact_acct_period.c_bpartner_id Implied Constraint R
rv_inoutconfirm.c_bpartner_id Implied Constraint R
rv_inoutdetails.c_bpartner_id Implied Constraint R
rv_inoutlineconfirm.c_bpartner_id Implied Constraint R
rv_invoicepayschedule.c_bpartner_id Implied Constraint R
rv_m_transaction.c_bpartner_id Implied Constraint R
rv_openitem.c_bpartner_id Implied Constraint R
rv_openitemtodate.c_bpartner_id Implied Constraint R
rv_orderdetail.c_bpartner_id Implied Constraint R
rv_orderdetail.c_order_c_bpartner_id Implied Constraint R
rv_payment.c_bpartner_id Implied Constraint R
rv_pp_order_workflow.c_bpartner_id Implied Constraint R
rv_projectcycle.c_bpartner_id Implied Constraint R
rv_t_1099extract.c_bpartner_id Implied Constraint R
s_timeexpense.c_bpartner_id cbpartner_stimeexpense R
s_timeexpenseline.c_bpartner_id cbpartner_stimeexpenseline R
t_1099extract.c_bpartner_id Implied Constraint R
t_aging.c_bpartner_id cbpartner_taging C
t_bankregister.c_bpartner_id Implied Constraint R
t_cashflow.c_bpartner_id Implied Constraint R
t_cof_fluxoplanofinanceiro.c_bpartner_id cbpartner_tcoffluxoplanofinanc R
t_distributionrundetail.c_bpartner_id cbpartner_tdrdetail C
t_invoicegl_v.c_bpartner_id Implied Constraint R
t_invoicegl_v.fact_acct_c_bpartner_id Implied Constraint R
t_itensnaovendidosaclientes.c_bpartner_id cbpartner_titensnaovendidosacl R
t_replenish.c_bpartner_id Implied Constraint R
t_rv_reconciliation.c_bpartner_id Implied Constraint R
t_trialbalance.c_bpartner_id Implied Constraint R
test.c_bpartner_id Implied Constraint R
u_posterminal.c_cashbpartner_id ccashbpartner_uposterminal R
u_posterminal.c_templatebpartner_id ctemplatebpartner_uposterminal R
w_advertisement.c_bpartner_id cbpartner_wadvertisement R
w_basket.c_bpartner_id cbpartner_wbasket R
w_clickcount.c_bpartner_id cbpartner_wclickcount R
w_countercount.c_bpartner_id cbpartner_wcountercount R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cbpartner R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cbpartner R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 40 null
name varchar 120 null
name2 varchar 60 √ null
description varchar 255 √ null
issummary bpchar 1 'N'::bpchar
c_bp_group_id numeric 10 null
c_bp_group.c_bp_group_id cbpgroup_cbpartner R
isonetime bpchar 1 'N'::bpchar
isprospect bpchar 1 'N'::bpchar
isvendor bpchar 1 'N'::bpchar
iscustomer bpchar 1 'Y'::bpchar
isemployee bpchar 1 'N'::bpchar
issalesrep bpchar 1 'N'::bpchar
referenceno varchar 40 √ null
duns varchar 11 √ null
url varchar 120 √ null
ad_language varchar 6 √ null
ad_language.ad_language ad_language_c_buspartner R
taxid varchar 20 √ null
istaxexempt bpchar 1 √ 'N'::bpchar
c_invoiceschedule_id numeric 10 √ null
c_invoiceschedule.c_invoiceschedule_id cinvoiceschedule_cbpartner R
rating bpchar 1 √ null
salesvolume numeric 10 √ null
numberemployees numeric 10 √ null
naics varchar 6 √ null
firstsale timestamp 29,6 √ null
acqusitioncost numeric 0 √ 0
potentiallifetimevalue numeric 0 √ 0
actuallifetimevalue numeric 0 √ 0
shareofcustomer numeric 10 √ null
paymentrule bpchar 1 √ null
so_creditlimit numeric 0 '0'::numeric
so_creditused numeric 0 √ 0
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id cpaymentterm_cbpartner R
m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id mpricelist_cbpartner N
m_discountschema_id numeric 10 √ null
m_discountschema.m_discountschema_id mdiscounts_cbpartner R
c_dunning_id numeric 10 √ null
c_dunning.c_dunning_id cdunning_cbpartner R
isdiscountprinted bpchar 1 √ 'Y'::bpchar
so_description varchar 255 √ null
poreference varchar 20 √ null
paymentrulepo bpchar 1 √ null
po_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id mpricelistpo_cbuspartner N
po_discountschema_id numeric 10 √ null
m_discountschema.m_discountschema_id mdiscountspo_cbpartner R
po_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id cpopaymentterm_cbpartner R
documentcopies numeric 10 √ null
c_greeting_id numeric 10 √ null
c_greeting.c_greeting_id cgreeting_cbpartner R
invoicerule bpchar 1 √ null
deliveryrule bpchar 1 √ null
freightcostrule bpchar 1 √ null
deliveryviarule bpchar 1 √ null
salesrep_id numeric 10 √ null
ad_user.ad_user_id adusersalesrep_cbpartner N
sendemail bpchar 1 'N'::bpchar
bpartner_parent_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_cpbartnerparent R
invoice_printformat_id numeric 10 √ null
ad_printformat.ad_printformat_id adprintformatinv_cbpartner R
socreditstatus bpchar 1 √ 'O'::bpchar
shelflifeminpct numeric 10 √ null
ad_orgbp_id numeric 10 √ null
ad_org.ad_org_id adorg_cbpartnerorg R
flatdiscount numeric 0 √ null
totalopenbalance numeric 0 √ null
dunninggrace timestamp 29,6 √ null
c_taxgroup_id numeric 10 √ null
c_taxgroup.c_taxgroup_id ctaxgroup_cbpartner R
logo_id numeric 10 √ NULL::numeric
ad_image.ad_image_id logo_cbpartner R
ispotaxexempt bpchar 1 'N'::bpchar
ismanufacturer bpchar 1 √ 'N'::bpchar
c_bpartner_uu varchar 36 √ NULL::character varying
customerprofileid varchar 60 √ NULL::character varying
default1099box_id numeric 10 √ NULL::numeric
c_1099box.c_1099box_id default1099box_cbpartner R
is1099vendor bpchar 1 'N'::bpchar
lbr_bptypebr varchar 2 √ null
lbr_cnpj varchar 18 √ null
lbr_cpf varchar 14 √ null
lbr_rg varchar 30 √ null
lbr_ccm varchar 30 √ null
lbr_suframa varchar 30 √ null
lbr_ie varchar 30 √ null
lbr_bptypebrisvalid bpchar 1 'N'::bpchar
lbr_customercategory_id numeric 10 √ null
lbr_vendorcategory_id numeric 10 √ null
lbr_fiscalgroup_customer_id numeric 10 √ null
lbr_fiscalgroup_vendor_id numeric 10 √ null
lbr_nfdescription varchar 255 √ null
lbr_hassubstitution bpchar 1 'N'::bpchar
lbr_transactiontype bpchar 3 √ null
lbr_nfmodel varchar 2 √ NULL::character varying
cof_isbillingblocked bpchar 1 √ 'N'::bpchar
cof_admissiondate timestamp 29,6 √ null
cof_terminationdate timestamp 29,6 √ null
cof_comments varchar 255 √ NULL::character varying
cof_shipper_id numeric 10 √ null
cof_taxregimecode bpchar 1 √ NULL::bpchar
cof_indie bpchar 1 √ '2'::bpchar
cof_taxincentive varchar 3 √ NULL::character varying
cof_c_custody_id numeric 10 √ NULL::numeric
cof_c_custody.cof_c_custody_id cofccustody_cbpartner R
cof_registerrevision timestamp 29,6 √ null
cof_doctypepurchase_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cofdoctypepurchase_cbpartner R
cof_doctypesale_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cofdoctypesale_cbpartner R
lbr_cnae varchar 10 √ NULL::character varying
cof_interestrate numeric 0 √ (0)::numeric
cof_taxincentiveicms numeric 0 √ '0'::numeric
cof_taxincentivepis numeric 0 √ '0'::numeric
cof_taxincentivecofins numeric 0 √ '0'::numeric
cof_situacaocomercial varchar 4 'PA'::character varying
cof_limitecreditochequeproprio numeric 0 '0'::numeric
cof_limitecreditochequeterceiro numeric 0 '0'::numeric
cof_limitecreditoboleto numeric 0 '0'::numeric
cof_limiteoutros numeric 0 '0'::numeric
cof_grupofornecedor_id numeric 10 √ null
cof_grupofornecedor.cof_grupofornecedor_id cofgrupofornecedor_cbpartner R
cof_permiteitemsubstituto bpchar 1 √ 'N'::bpchar
cof_vendedorinterno_id numeric 10 √ NULL::numeric
ad_user.ad_user_id cofvendedorinterno_cbpartner R
cof_jurosmensal numeric 0 √ null
cof_score numeric 10 √ '0'::numeric
cof_tipoparceiro_id numeric 10 √ null
cof_tipoparceiro.cof_tipoparceiro_id coftipoparceiro_cbpartner R
cof_classeparceiro_id numeric 10 √ null
cof_classeparceiro.cof_classeparceiro_id cofclasseparceiro_cbpartner R
cof_ismultiplainscricao bpchar 1 √ 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_bpartner_pkey Primary key Asc c_bpartner_id
c_bpartner_bporg Performance Asc ad_orgbp_id
c_bpartner_name Performance Asc name
c_bpartner_uu_idx Must be unique Asc c_bpartner_uu
c_bpartner_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

Constraint Name Constraint
c_bpartner_issummary_check ((issummary = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_istaxexempt_check ((istaxexempt = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_isvendor_check ((isvendor = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_cof_ismultiplainscricao_check ((cof_ismultiplainscricao = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_isemployee_check ((isemployee = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_cof_permiteitemsubstituto_check ((cof_permiteitemsubstituto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_isonetime_check ((isonetime = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_iscustomer_check ((iscustomer = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_ispotaxexempt_check ((ispotaxexempt = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_is1099vendor_check ((is1099vendor = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_isdiscountprinted_check ((isdiscountprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_lbr_hassubstitution_check ((lbr_hassubstitution = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_ismanufacturer_check ((ismanufacturer = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_cof_isbillingblocked_check ((cof_isbillingblocked = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_isprospect_check ((isprospect = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_issalesrep_check ((issalesrep = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation