Partner Location
C_BPartner_Location
Identifies the (ship to) address for this Business Partner
Overview
| Table Name | C_BPartner_Location |
|---|---|
| Access Level | Client Only |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | C_BP_Location_Pricelist |
| Wiki | View on iDempiere Wiki |
Columns (40)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
BPLocationContactName |
String(255) | No | - | Define contact person, reference or responsible for this location/address |
BPLocationEntityName |
String(255) | No | - | Define Entity, (Company, Organisation) reference for this location/address |
C_BP_Location_Pricelist_ID |
Search(10) | No | NULL | Unique identifier of a Price List |
Comments |
Text(2000) | No | - | Comments or additional information |
C_ShippingRegion_ID |
Table Direct(22) | No | - | Shipping coverage region |
CustomerAddressID |
String(60) | No | - | - |
EMail |
String(60) | No | - | Electronic Mail Address |
InternalNote |
Text(2000) | No | - | - |
InvoicingNote |
Text(2000) | No | - | - |
IsPostalTo |
Yes-No(1) | Yes | N | Business Partner Postall Address |
IsPreserveCustomName |
Yes-No(1) | Yes | N | - |
M_DiscountSchema_ID |
Search(10) | No | - | Schema to calculate the trade discount percentage |
Mobile |
String(40) | No | - | Identifies a mobile number |
ReferenceNo |
String(250) | No | - | Your customer or vendor number at the Business Partner's site |
ResponsibleContact_ID |
Table(10) | No | - | Define contact person, supervisor or responsible for this location/address |
SalesRep_ID |
Table(10) | No | NULL | Sales Representative or Company Agent |
ShippingNote |
Text(2000) | No | - | - |
WMSNote |
Text(2000) | No | - | - |
Name |
String(120) | Yes | . | Alphanumeric identifier of the entity |
Phone |
String(40) | No | - | Identifies a telephone number |
Value |
String(40) | Yes | - | Search key for the record in the format required - must be unique |
C_Location_ID |
Location (Address)(22) | Yes | - | Location or Address |
AD_Client_ID |
Table Direct(22) | Yes | @AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @AD_Org_ID@ | Organizational entity within tenant |
C_BPartner_ID |
Search(22) | Yes | - | Identifies a Business Partner |
C_BPartner_Location_ID |
ID(22) | Yes | - | Identifies the (ship to) address for this Business Partner |
C_BPartner_Location_UU |
String(36) | No | - | - |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
C_SalesRegion_ID |
Table(22) | No | - | Sales coverage region |
Fax |
String(40) | No | - | Facsimile number |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsBillTo |
Yes-No(1) | Yes | N | Business Partner Invoice/Bill Address |
ISDN |
String(40) | No | - | ISDN or modem line |
IsPayFrom |
Yes-No(1) | Yes | N | Business Partner pays from that address and we'll send dunning letters there |
IsRemitTo |
Yes-No(1) | Yes | N | Business Partner payment address |
IsShipTo |
Yes-No(1) | Yes | N | Business Partner Shipment Address |
Phone2 |
String(40) | No | - | Identifies an alternate telephone number. |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
Foreign Keys
| Column | References | Description |
|---|---|---|
C_BP_Location_Pricelist_ID |
C_BP_Location_Pricelist.C_BP_Location_Pricelist_ID | Unique identifier of a Price List |
C_ShippingRegion_ID |
C_ShippingRegion.C_ShippingRegion_ID | Shipping coverage region |
M_DiscountSchema_ID |
M_DiscountSchema.M_DiscountSchema_ID | Schema to calculate the trade discount percentage |
ResponsibleContact_ID |
ResponsibleContact.ResponsibleContact_ID | Define contact person, supervisor or responsible for this location/address |
SalesRep_ID |
SalesRep.SalesRep_ID | Sales Representative or Company Agent |
C_Location_ID |
C_Location.C_Location_ID | Location or Address |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
C_BPartner_ID |
C_BPartner.C_BPartner_ID | Identifies a Business Partner |
C_SalesRegion_ID |
C_SalesRegion.C_SalesRegion_ID | Sales coverage region |
Generated on 2026-05-03T15:23:32.631491067Z