ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BPartner V
Contents |
C_BPartner_V
- Name:BPartnerV
- Classname:BusinessPartnerV
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
| AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
| C_BPartner_ID | N | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
| Value | N | NVARCHAR2(40) | A fast method for finding a particular record. |
| Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
| ReferenceNo | Y | NVARCHAR2(40) | The number for a specific reference. |
| SO_CreditAvailable | Y | NUMBER | Available Credit |
| SO_CreditLimit | Y | NUMBER | Total outstanding invoice amounts allowed |
| SO_CreditUsed | Y | NUMBER | Current open balance |
| IsCustomer | N | CHAR(1) | Indicates a business partner that is your customer, ie. that will be making purchases from you. |
| IsVendor | N | CHAR(1) | A business partner who sells products or services. |
| Revenue | Y | NUMBER | Revenue |
| Contact | Y | NVARCHAR2(60) | null |
| Phone | Y | NVARCHAR2(40) | A telephone number for a specified business partner. |
| Postal | Y | VARCHAR2(10) | A identification code used to help get items to a specific location. |
| City | Y | NVARCHAR2(60) | A populated defined area located within a larger area such as a state, province, or country. |
| Y | NVARCHAR2(40) | An email address for a specified business partner. |
Columns
Client
- Physical column name: AD_Client_ID
- 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
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Business Partner
- Physical column name: C_BPartner_ID
- Reference: Search
- This column is part of the table's identifier
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Search Key
A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).
Usually, company's internal identifiers for various records (products, customers, etc) are stored here.
- Physical column name: Value
- Reference: String
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
- Reference: String
Reference No.
The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.
- Physical column name: ReferenceNo
- Reference: String
Credit Available
Available Credit
- Physical column name: SO_CreditAvailable
- Reference: Amount
Credit Limit
The Credit Line Limit indicates the total amount allowed 'on account'. If this is exceeded a warning message will be generated.
- Physical column name: SO_CreditLimit
- Reference: Amount
Credit Used
The Customer Balance indicates the total amount of open or unpaid invoices for this Business Partner.
- Physical column name: SO_CreditUsed
- Reference: Amount
Customer
Indicates a business partner that is your customer, ie. that will be making purchases from you. If selected, additional fields will display further details that need to be entered for a customer.
- Physical column name: IsCustomer
- Reference: YesNo
Vendor
The Vendor checkbox indicates if this Business Partner is a Vendor. If it is selected, additional fields will display which further identify this vendor.
- Physical column name: IsVendor
- Reference: YesNo
Revenue
Revenue
- Physical column name: Revenue
- Reference: Amount
Contact
- Physical column name: Contact
- Reference: String
Phone
The Phone field identifies a telephone number
- Physical column name: Phone
- Reference: String
Postal Code
The Postal Code field identifies the postal code for this entity's address.
- Physical column name: Postal
- Reference: String
City Name
The City identifies a unique City for this Country or Region.
- Physical column name: City
- Reference: String
The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com).
- Physical column name: Email
- Reference: String