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
ad_user.c_bpartner_location_id cbplocation_aduser R
c_bp_shippingacct.c_bpartner_location_id cbpartnerlocation_cbpshippinga 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
m_distributionlistline.c_bpartner_location_id cbpartnerloc_mdistlistline R
m_distributionrun.c_bpartner_location_id cbplocation_mdistributionrun 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 Client/Tenant for this installation.
ad_org_id numeric 10 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 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 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:52 +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

Close relationships  within of separation: