Table idempiere11.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
c_invoice.c_bpartner_location_id c_bplocation_cinvoice R
c_invoicebatchline.c_bpartner_location_id cbplocation_cinvoicebline R
c_project.c_bpartner_location_id cbplocation_cproject 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
Identifies the (ship to) address for this Business Partner
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id c_buspartner_locationorg R
Organizational entity within tenant
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 16 rows at 2024-01-03 13:51 +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: