View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BPartner V

Contents

C_BPartner_V

This table contains the following columns:

Name Nullable Data Type Description
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
C_BPartner_ID NVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Value NNVARCHAR2(40)A fast method for finding a particular record.
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
ReferenceNo YNVARCHAR2(40)The number for a specific reference.
SO_CreditAvailable YNUMBERAvailable Credit
SO_CreditLimit YNUMBERTotal outstanding invoice amounts allowed
SO_CreditUsed YNUMBERCurrent open balance
IsCustomer NCHAR(1)Indicates a business partner that is your customer, ie. that will be making purchases from you.
IsVendor NCHAR(1)A business partner who sells products or services.
Revenue YNUMBERRevenue
Contact YNVARCHAR2(60)null
Phone YNVARCHAR2(40)A telephone number for a specified business partner.
Postal YVARCHAR2(10)A identification code used to help get items to a specific location.
City YNVARCHAR2(60)A populated defined area located within a larger area such as a state, province, or country.
Email YNVARCHAR2(40)An email address for a specified business partner.

Columns

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Business Partner

Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top

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.

top

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.

top

Reference No.

The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.

top

Credit Available

Available Credit

top

Credit Limit

The Credit Line Limit indicates the total amount allowed 'on account'. If this is exceeded a warning message will be generated.

top

Credit Used

The Customer Balance indicates the total amount of open or unpaid invoices for this Business Partner.

top

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.

top

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.

top

Revenue

Revenue

top

Contact

top

Phone

The Phone field identifies a telephone number

top

Postal Code

The Postal Code field identifies the postal code for this entity's address.

top

City Name

The City identifies a unique City for this Country or Region.

top

Email

The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com).

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.common.businesspartner/C_BPartner_V"

This page has been accessed 1,597 times. This page was last modified on 15 April 2011, at 21:30. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.