c_bpartner_location

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_bpartner_location_id numeric 10 null
a_asset.c_bpartner_location_id cbplocation_aasset R
a_asset_change.c_bpartner_location_id cbpartnerlocation_aassetchange R
a_asset_change.c_invoice_c_bpartnerloc_id cinvoicecbpartnerloc_aassetcha R
ad_user.c_bpartner_location_id cbplocation_aduser R
c_bp_relation.c_bpartner_location_id cbplocation_cbprelation R
c_bp_relation.c_bpartnerrelation_location_id cbplocation_cbprelationbp R
c_bp_shippingacct.c_bpartner_location_id cbpartnerlocation_cbpshippinga R
c_dunningrunentry.c_bpartner_location_id cbpartnerlocation_cdunningrune R
c_invoice.c_bpartner_location_id c_bplocation_cinvoice R
c_invoice.cof_payfrom_location_id cofpayfromlocation_cinvoice R
c_invoicebatchline.c_bpartner_location_id cbplocation_cinvoicebline R
c_order.bill_location_id cbplocationbill_corder R
c_order.c_bpartner_location_id cbpartnerlocation_corder R
c_order.cof_localizacaocomplementar_id coflocalizacaocomplementar_cor R
c_order.cof_payfrom_location_id cofpayfromlocation_corder R
c_order.cof_pnconcorrente_location_id cofpnconcorrentelocation_corde R
c_order.cof_pnlocationretira_id cofpnlocationretira_corder R
c_order.dropship_location_id dropshiplocation_corder R
c_order.pay_location_id cbplocationpay_corder R
c_orderline.c_bpartner_location_id cbpartnerlocation_soline R
c_project.c_bpartner_location_id cbplocation_cproject R
c_rfq.c_bpartner_location_id cbplocation_crfq R
c_rfq_topicsubscriber.c_bpartner_location_id cbpartnerloc_crfqtopicsubr R
c_rfqresponse.c_bpartner_location_id cbplocation_crfqresponse R
cof_activity.c_bpartner_location_id cbpartnerlocation_cofactivity R
cof_c_controlcheck.c_bpartner_location_id cbpartnerlocation_cofccontrolc R
cof_contract.c_location_id clocation_cofcontract R
cof_contract.cof_payfrom_location_id cofpayfromlocation_cofcontract R
cof_creditanalysis.c_bpartner_location_id cbpartnerlocation_cofcreditana R
cof_deliveryrestriction.c_bpartner_location_id cbpartnerlocation_cofdeliveryr R
cof_mdfe_reboque.c_bpartner_location_id cbpartnerlocation_cofmdfereboq R
cof_ordemservico.c_bpartner_location_id cbpartnerlocation_cofordemserv R
cof_packinglist_line.c_bpartner_location_id cbpartnerlocation_cofpackingli R
cof_preferenciaxml.bp_location_id bplocation_cofpreferenciaxml N
cof_retentionconfig.c_bpartner_location_id cbpartnerlocation_cofretention R
cof_titulo.c_bpartner_location_id cbpartnerlocation_coftitulo R
cte_cte.cte_bpdestinatarioloc_id ctebpdestinatarioloc_ctecte R
cte_cte.cte_bpexpedidorloc_id ctebpexpedidorloc_ctecte R
cte_cte.cte_bprecebedorloc_id ctebprecebedorloc_ctecte R
cte_cte.cte_bpremetenteloc_id ctebpremetenteloc_ctecte R
cte_cte.cte_bptomadorloc_id ctebptomadorloc_ctecte R
cte_cte.cte_emit_location_id cteemitlocation_ctecte R
cte_destinatario.c_bpartner_location_id cbpartnerlocation_ctedestinata R
cte_remetente.c_bpartner_location_id cbpartnerlocation_cteremetente R
dd_order.c_bpartner_location_id cbpartnerlocation_ddorder R
i_asset.c_bpartner_location_id cbpartnerlocation_iasset R
i_bpartner.c_bpartner_location_id cbpartnerlocation_ibpartner N
i_invoice.c_bpartner_location_id cbplocation_iinvoice N
i_order.billto_id cbpartnerlocbillto_iorder N
i_order.c_bpartner_location_id cbolocation_iorder N
lbr_docfiscal.cof_pnlocationretira_id cofpnlocationretira_lbrdocfisc R
lbr_taxdefinition.c_bpartner_location_id cbpartnerlocation_lbrtaxdefini R
m_distributionlistline.c_bpartner_location_id cbpartnerloc_mdistlistline R
m_distributionrun.c_bpartner_location_id cbplocation_mdistributionrun R
m_inout.c_bpartner_location_id vbplocation_minout R
m_inout.cof_localizacaocomplementar_id coflocalizacaocomplementar_min R
m_inout.dropship_location_id dropshiplocation_minout R
m_inout.returnlocation_id returnlocation_minout R
m_movement.c_bpartner_location_id cbpartnerlocation_mmovement R
m_package.c_bpartner_location_id cbpartnerlocation_mpackage R
m_package.holdaddress_id holdaddress_mpackage R
m_shippingtransaction.bill_location_id billlocation_mshippingtransact R
m_shippingtransaction.c_bpartner_location_id cbpartnerlocation_mshippingtra R
m_shippingtransaction.holdaddress_id holdaddress_mshippingtransacti R
m_shippingtransaction.returnlocation_id returnlocation_mshippingtransa R
t_distributionrundetail.c_bpartner_location_id cbpartnerlocation_tdrdetail C
ad_client_id numeric 10 null
ad_client.ad_client_id c_buspartner_locationclient R
ad_org_id numeric 10 null
ad_org.ad_org_id c_buspartner_locationorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
isbillto bpchar 1 'Y'::bpchar
isshipto bpchar 1 'Y'::bpchar
ispayfrom bpchar 1 'Y'::bpchar
isremitto bpchar 1 'Y'::bpchar
phone varchar 40 √ null
phone2 varchar 40 √ null
fax varchar 40 √ null
isdn varchar 40 √ null
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id csalesregion_bpartnerlocation N
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_cbplocation C
c_location_id numeric 10 √ null
c_location.c_location_id clocation_cbplocation R
c_bpartner_location_uu varchar 36 √ NULL::character varying
customeraddressid varchar 60 √ NULL::character varying
cof_shipper_id numeric 10 √ null
cof_m_shipregion_id numeric 10 √ NULL::numeric
cof_m_shipregion.cof_m_shipregion_id cofmshipregion_cbpartnerlocati R
cof_modfrete bpchar 1 √ '1'::bpchar
ispreservecustomname bpchar 1 'N'::bpchar
cof_sequenciaentrega numeric 10 √ '0'::numeric
cof_sequenciaentregacidade numeric 10 √ NULL::numeric
cof_sequenciaentregaregiao numeric 10 √ NULL::numeric
entrega_ie varchar 14 √ NULL::character varying
cof_art varchar 60 √ NULL::character varying
cof_codigocei varchar 60 √ NULL::character varying
cof_codigoobra varchar 60 √ NULL::character varying
iscof_automatico bpchar 1 'N'::bpchar
lbr_ie varchar 30 √ null
cof_isenderecocomplementar bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_bpartner_location_pkey Primary key Asc c_bpartner_location_id
c_bpartner_location_uu_idx Must be unique Asc c_bpartner_location_uu
c_bplocation_bpartner Performance Asc c_bpartner_id
c_bplocation_updated Performance Asc updated

Check Constraints

Constraint Name Constraint
c_bpartner_location_isshipto_check ((isshipto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_location_ispayfrom_check ((ispayfrom = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_location_isremitto_check ((isremitto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_location_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_location_isbillto_check ((isbillto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_location_iscof_automatico_check ((iscof_automatico = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_location_ispreservecustomname_check ((ispreservecustomname = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_bpartner_location_cof_isenderecocomplementar_check ((cof_isenderecocomplementar = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation