ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BPartner Location
C_BPartner_Location
The Location defines the physical location of a business partner. A business partner may have multiple location records.
- Name:BusinessPartnerLocation
- Classname:Location
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_BPartner_Location_ID | N | VARCHAR2(32) | The location of the selected business partner. |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
IsBillTo | N | CHAR(1) | Indicates that this address is the Invoice to Address |
IsShipTo | N | CHAR(1) | Business Partner address to ship goods to |
IsPayFrom | N | CHAR(1) | Business Partner pays from that address and we'll send dunning letters there |
IsRemitTo | N | CHAR(1) | Address we send payments to |
Phone | Y | NVARCHAR2(40) | A telephone number for a specified business partner. |
Phone2 | Y | NVARCHAR2(40) | A second contact telephone number for a business partner. |
Fax | Y | NVARCHAR2(40) | A fax number for a specified business partner. |
C_SalesRegion_ID | Y | VARCHAR2(32) | A defined section of the world where sales efforts will be focused. |
C_BPartner_ID | N | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
C_Location_ID | Y | VARCHAR2(32) | A specific place or residence. |
IsTaxLocation | N | CHAR(1) | null |
UPC | Y | NVARCHAR2(30) | A bar code with a number to identify a product. |
Other Info
Check constraints
These are the check constraints for this table:
- C_BPARTNER_LOCATION_ISACTI_CHK: ISACTIVE IN ('Y', 'N')
- C_BPARTNER_LOCATION_ISBILL_CHK: ISBILLTO IN ('Y', 'N')
- C_BPARTNER_LOCATION_ISPAYF_CHK: ISPAYFROM IN ('Y', 'N')
- C_BPARTNER_LOCATION_ISREMI_CHK: ISREMITTO IN ('Y', 'N')
- C_BPARTNER_LOCATION_ISSHIP_CHK: ISSHIPTO IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Non Unique
- C_BPLOCATION_BPARTNER
- C_BPLOCATION_UPDATED
Unique
- C_BPARTNER_LOCATION_KEY
Columns
Partner Address
The Partner address indicates the location of a Business Partner
- Physical column name: C_BPartner_Location_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Active
There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Name
A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
- Physical column name: Name
- Property Name: name
- Reference: String
- Default value: .
- This column is part of the table's identifier
Invoice to Address
The Invoice to Address checkbox indicates if this location is the Invoice to Address for this Business Partner
- Physical column name: IsBillTo
- Property Name: invoiceToAddress
- Reference: YesNo
- Default value: Y
Ship to Address
The Ship to Address checkbox indicates if this location is the address to use when shipping orders to this Business Partner.
- Physical column name: IsShipTo
- Property Name: shipToAddress
- Reference: YesNo
- Default value: Y
Pay from Address
The Pay From Address checkbox indicates if this location is the address the Business Partner pays from.
- Physical column name: IsPayFrom
- Property Name: payFromAddress
- Reference: YesNo
- Default value: Y
Remit to Address
The Remit to Address checkbox indicates if this location is the address to which we should send payments to this Business Partner.
- Physical column name: IsRemitTo
- Property Name: remitToAddress
- Reference: YesNo
- Default value: Y
Phone
The Phone field identifies a telephone number
- Physical column name: Phone
- Property Name: phone
- Reference: String
Alternative Phone
The 2nd Phone field identifies an alternate telephone number.
- Physical column name: Phone2
- Property Name: alternativePhone
- Reference: String
Fax
The Fax identifies a facsimile number for this Business Partner or Location
- Physical column name: Fax
- Property Name: fax
- Reference: String
Sales Region
- Physical column name: C_SalesRegion_ID
- Property Name: salesRegion
- Reference: TableDir
Foreign key column to C_SalesRegion table, (column: C_SalesRegion_ID)
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
- This column is a child for a buisiness object (is Parent)
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Location / Address
- Physical column name: C_Location_ID
- Property Name: locationAddress
- Reference: Search
Foreign key column to C_Location table, (column: C_Location_ID)
Tax Location
This fieldindicates that this location is a fiscal address. Fiscal addresses are shown in all documents.
- Physical column name: IsTaxLocation
- Property Name: taxLocation
- Reference: YesNo
- Default value: N
UPC/EAN
Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode)
- Physical column name: UPC
- Property Name: uPCEAN
- Reference: String
Related tables
Tables that link this table:
- ADUser.Partner Address
- ActiveProposalV.Partner Address
- DataImportBusinessPartner.Partner Address
- DataImportInvoice.Partner Address
- DataImportOrder.Invoice Address
- DataImportOrder.Partner Address
- FinancialMgmtAsset.Partner Address
- Invoice.Partner Address
- InvoiceV2.Partner Address
- MaterialMgmtShipmentInOut.Delivery Location
- MaterialMgmtShipmentInOut.Partner Address
- Order.Delivery Location
- Order.Drop Ship Location
- Order.Invoice Address
- Order.Partner Address
- OrderLine.Partner Address
- OrderOpen.Partner Address
- Project.Invoice Address
- Project.Partner Address
- ProjectProposal.Partner Address