Table idempiere9.adempiere.c_bpartner_location
Identifies the (ship to) address for this Business Partner

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_bpartner_location_id numeric 10
a_asset.c_bpartner_location_id cbplocation_aasset R
a_asset_change.c_bpartner_location_id cbpartnerlocation_aassetchange 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_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.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
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
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.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
Identifies the (ship to) address for this Business Partner
ad_client_id numeric 10
ad_client.ad_client_id c_buspartner_locationclient R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id c_buspartner_locationorg R
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
isbillto bpchar 1 'Y'::bpchar Business Partner Invoice/Bill Address
isshipto bpchar 1 'Y'::bpchar Business Partner Shipment Address
ispayfrom bpchar 1 'Y'::bpchar Business Partner pays from that address and we'll send dunning letters there
isremitto bpchar 1 'Y'::bpchar Business Partner payment address
phone varchar 40  √  null Identifies a telephone number
phone2 varchar 40  √  null Identifies an alternate telephone number.
fax varchar 40  √  null Facsimile number
isdn varchar 40  √  null ISDN or modem line
c_salesregion_id numeric 10  √  null
c_salesregion.c_salesregion_id csalesregion_bpartnerlocation N
Sales coverage region
c_bpartner_id numeric 10
c_bpartner.c_bpartner_id cbpartner_cbplocation C
Identifies a Business Partner
c_location_id numeric 10  √  null
c_location.c_location_id clocation_cbplocation R
Location or Address
c_bpartner_location_uu varchar 36  √  NULL::character varying C_BPartner_Location_UU
customeraddressid varchar 60  √  NULL::character varying Customer Address ID
ispreservecustomname bpchar 1 'N'::bpchar Preserve custom name

Table contained 13 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.