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

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

Contents

C_BPartner

The Business Partner table defines any entity with whom an organization transacts. The entity could be a customer or/and a vendor or/and an employee.
Customer defines a Business Partner who is a customer of this organization. If the Customer check box is selected then the necessary fields will display.
Vendor defines a Business Partner that is a Vendor for this Organization. If the Vendor check box is selected the necessary fields will display.
Employee defines a Business Partner who is an Employee of this organization. If the Employee is also a Sales Representative then the check box should be selected.

This table contains the following columns:

Name Nullable Data Type Description
C_BPartner_ID NVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
Value NNVARCHAR2(40)A fast method for finding a particular record.
Name NNVARCHAR2(60)Alphanumeric identifier of the entity
Name2 YNVARCHAR2(60)Additional Name
Description YNVARCHAR2(255)A space to write additional related information.
IsSummary NCHAR(1)A means of grouping fields in order to view or hide additional information.
C_BP_Group_ID NVARCHAR2(32)A classification of business partners based on defined similarities.
IsOneTime NCHAR(1)null
IsProspect NCHAR(1)Indicates a Prospect or Customer
IsVendor NCHAR(1)A business partner who sells products or services.
IsCustomer NCHAR(1)Indicates a business partner that is your customer, ie. that will be making purchases from you.
IsEmployee NCHAR(1)A business partner who will be working for an organization.
IsSalesRep NCHAR(1)The person in charge of carry out an order.
ReferenceNo YNVARCHAR2(40)The number for a specific reference.
DUNS YCHAR(11)Dun & Bradstreet Number
URL YNVARCHAR2(120)An address which can be accessed via internet.
AD_Language YVARCHAR2(6)Language for this application
TaxID YVARCHAR2(20)The government defined unique number for assigning and paying taxes.
IsTaxExempt YCHAR(1)A condition stating that for a specific case, taxes must not be applied.
C_InvoiceSchedule_ID YVARCHAR2(32)Schedule for generating Invoices
Rating YCHAR(1)An estimation or appraisal with the goal of defining a value.
SalesVolume YNUMBER(10, 0)Total Volume of Sales
NumberEmployees YNUMBER(10, 0)Number of employees
NAICS YCHAR(6)Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
FirstSale YDATEDate of First Sale
AcqusitionCost YNUMBERThe cost of gaining the prospect as a customer
PotentialLifeTimeValue YNUMBERTotal Revenue expected
ActualLifeTimeValue YNUMBERActual Life Time Revenue
ShareOfCustomer YNUMBER(10, 0)Share of Customer's business as a percentage
PaymentRule YVARCHAR2(60)The method used for payment of this transaction.
SO_CreditLimit YNUMBERTotal outstanding invoice amounts allowed
SO_CreditUsed YNUMBERCurrent open balance
C_PaymentTerm_ID YVARCHAR2(32)The setup and timing defined to complete a specified payment.
M_PriceList_ID YVARCHAR2(32)A catalog of selected items with prices defined generally or for a specific partner.
IsDiscountPrinted YCHAR(1)An option to have any discount printed on the invoice.
SO_Description YNVARCHAR2(255)Description to be used on orders
POReference YNVARCHAR2(20)A reference or document order number as listed in business partner application.
PaymentRulePO YVARCHAR2(60)Purchase payment option
PO_PriceList_ID YVARCHAR2(32)Price List used by this Business Partner
PO_PaymentTerm_ID YVARCHAR2(32)Payment rules for a purchase order
DocumentCopies YNUMBER(10, 0)The number of copies of each document that will be printed.
C_Greeting_ID YVARCHAR2(32)A description, often abbreviated, of how to address a business partner.
InvoiceRule YVARCHAR2(60)Frequency and method of invoicing
DeliveryRule YVARCHAR2(60)A definition stating when a specific delivery will occur.
DeliveryViaRule YVARCHAR2(60)The desired means of getting requested goods to a business partner.
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
BPartner_Parent_ID YVARCHAR2(32)Business Partner Parent
SOCreditStatus YVARCHAR2(60)Sales Credit Status
AD_Forced_Org_ID YVARCHAR2(32)null
ShowPriceInOrder NCHAR(1)null
Invoicegrouping YVARCHAR2(60)null
FixMonthDay YNUMBER(10, 0)The day of the month that invoices are due. 3 maturity dates can be defined.
FixMonthDay2 YNUMBER(10, 0)The day of the month that invoices are due. 3 maturity dates can be defined.
Fixmonthday3 YNUMBER(10, 0)The day of the month that invoices are due. 3 maturity dates can be defined.
Isworker YCHAR(1)null
UPC YNVARCHAR2(30)A bar code with a number to identify a product.
C_Salary_Category_ID YVARCHAR2(32)A classification of salaries based on similar characteristics or attributes.
Invoice_Printformat YVARCHAR2(60)Print Format for printing Invoices
Last_Days YNUMBER(10, 0)Consumption Days
PO_Bankaccount_ID YVARCHAR2(32)Default Vendor Bank Account
PO_BP_TaxCategory_ID YVARCHAR2(32)Bussines Partner Tax Category as a Vendor
PO_Fixmonthday YNUMBER(10, 0)The day of the month that invoices are due. 3 maturity dates can be defined.
PO_Fixmonthday2 YNUMBER(10, 0)Day of the month of the due date
PO_Fixmonthday3 YNUMBER(10, 0)Day of the month of the due date
SO_Bankaccount_ID YVARCHAR2(32)Default Customer Bankaccount
SO_Bp_Taxcategory_ID YVARCHAR2(32)SO BP Tax Category
Fiscalcode YNVARCHAR2(16)Fiscal code
Isofiscalcode YNVARCHAR2(2)Iso fiscal code
PO_C_Incoterms_ID YVARCHAR2(32)null
SO_C_Incoterms_ID YVARCHAR2(32)null
FIN_Paymentmethod_ID YVARCHAR2(32)It is the method by which payment is expected to be made or received.
PO_Paymentmethod_ID YVARCHAR2(32)null
FIN_Financial_Account_ID YVARCHAR2(32)Financial account used to deposit / withdrawal money such as bank accounts or petty cash
PO_Financial_Account_ID YVARCHAR2(32)Financial account used to deposit / withdrawal money such as bank accounts or petty cash

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Non Unique

Unique

top

Columns

Business Partner

A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.

top

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

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_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

The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.

top

Name 2

top

Description

A description is limited to 255 characters.

top

Summary Level

A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values.

top

Business Partner Category

Foreign key column to C_BP_Group table, (column: C_BP_Group_ID)

top

One Time Transaction

top

Potential Customer

The Prospect checkbox indicates an entity that is an active prospect or 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

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

Employee

The Employee checkbox indicates if this Business Partner is an Employee. If it is selected, additional fields will display which further identify this employee.

top

Is Sales Representative

The Sales Rep checkbox indicates if this employee is also a sales representative.

top

Reference No.

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

top

D-U-N-S

Used for EDI - For details see www.dnb.com/dunsno/list.htm

top

URL

The URL defines an online address for this element.

top

Language

The Language identifies the language to use for display

Foreign key column to AD_Language table, (column: AD_Language_ID)


Reference Table AD_Language

top

Tax ID

The Tax ID field identifies the legal Identification number of this Entity.

top

Tax Exempt

If a business partner is exempt from tax, the exempt tax rate is used. For this, you need to set up a tax rate with a 0% rate and indicate that this is your tax exempt rate. This is required for tax reporting, so that you can track tax exempt transactions.

top

Invoice Schedule

Foreign key column to C_InvoiceSchedule table, (column: C_InvoiceSchedule_ID)

top

Valuation

The Rating is used to differentiate the importance

top

Volume of Sales

The Sales Volume indicates the total volume of sales for a Business Partner.

top

No. of Employees

Indicates the number of employees for this Business Partner. This field displays only for Prospects.

top

NAICS/SIC

The NAICS/SIC identifies either of these codes that may be applicable to this Business Partner.

top

Date of First Sale

The First Sale Date identifies the date of the first sale to this Business Partner

top

Acquisition Cost

The Acquisition Cost identifies the cost associated with making this prospect a customer.

top

Expected Lifetime Revenue

The Potential Life Time Value is the anticipated revenue to be generated by this Business Partner.

top

Lifetime Revenue to Date

The Actual Life Time Value is the recorded revenue to be generated by this Business Partner.

top

Share

The Share indicates the percentage of this Business Partner's volume of the products supplied.

top

Form of Payment

Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)

List values: All_Payment Rule

The allowed values for this list are:

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

Payment Terms

Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)

top

Price List

Foreign key column to M_PriceList table, (column: M_PriceList_ID)


Reference Table M_PriceListForSale With the following where clause:

 
M_PRICELIST.ISSOPRICELIST='Y'


top

Print Discount

The Discount Printed Checkbox indicates if the discount will be printed on the document.

top

Order Description

The Order Description identifies the standard description to use on orders for this Customer.

top

Order Reference

This can be used to input a reference for this specific transaction. For example, a Purchase Order number can be input on a Sales Order for easier reference.

top

Payment Rule

The Payment Rule indicates the method of purchase payment.

List values: All_Payment Rule

The allowed values for this list are:

top

Purchase Pricelist

Identifies the price list used by a Vendor for products purchased by this organization.

Foreign key column to M_PriceList table, (column: M_PriceList_ID)


Reference Table M_PriceListForPurchase With the following where clause:

 
M_PRICELIST.ISSOPRICELIST='N'


top

PO Payment Term

The PO Payment Term indicates the payment term that will be used when this purchase order becomes an invoice.

Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)


Reference Table C_PaymentTerm

top

Number of Copies

The Document Copies indicates the number of copies of each document that will be generated.

top

Greeting

Foreign key column to C_Greeting table, (column: C_Greeting_ID)

top

Invoice Terms

The Invoice Rule defines how a Business Partner is invoiced and the frequency of invoicing.

List values: C_Order InvoiceRule

The allowed values for this list are:

top

Delivery Terms

The Delivery Rule indicates when an order should be delivered. For example should the order be delivered when the entire order is complete, when a line is complete or as the products become available.

List values: C_Order DeliveryRule

The allowed values for this list are:

top

Delivery Method

The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.

List values: C_Order DeliveryViaRule

The allowed values for this list are:

top

Sales Representative

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


Reference Table C_BPartner SalesRep : SalesRep_ID is synonym of AD_User_ID. With the following where clause:

 
C_BPartner.IsSalesRep='Y'


top

Partner Parent

The parent (organization) of the Business Partner for reporting purposes.

top

Credit Status

For Documentation only

List values: C_BPartner SOCreditStatus

The allowed values for this list are:

top

Forced org

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


Reference Table AD_Org (all)

top

Prices Shown in Order

When not checked prices are not shown (left blank) in the printed order document

top

Invoice Grouping

For scheduled invoicing, break into different invoices if the related values are different. The value is used as a binary code with 15 digits:
1.-Order organization (AD_Org_ID)
2.-Order (C_Order_ID)
3.-Shipment (M_InOut_ID)
4.-Invoice location (BillTo_ID)
5.-Ship location (C_BPartner_Location_ID)
6.-Sales representative (SalesRep_ID)
7.-Payment rule (PaymentRule)
8.-Payment term (C_PaymentTerm_ID)
9.-Currency (C_Currency_ID)
10.-Campaign (C_Campaign_ID)
11.-Project (C_Project_ID)
12.-Activity (C_Activity_ID)
13.-Transaction organization (AD_OrgTrx_ID)
14.-User defined 1 (User1)
15.-User defined 2 (User2)

For example, if you want to create different invoices for each ship location for a customer, use the value "By ship location" (000010000000000)

List values: Scheduled invoice grouping

The allowed values for this list are:

Finally, the grouping by Order Organization has a special behavior since it has functional limitations. If there are Orders with different Organizations, it is possible to group them into one Invoice only when the user manually sets the Organization of the Invoice.

This happens in the Generate Invoices process, as the user manually sets the Organization of the Invoice.

However, in the Create Invoices From Orders process it is impossible to group the Orders into one Invoice if the Organizations are different. In this case, there will be at least as many Invoices created as different Organizations are defined for the selected Orders.

top

Maturity Date 1

The Fix Month Day indicates the day of the month that invoices are due. This field is displayed only when the fixed due date checkbox is selected. 3 different fix month days can be defined.

top

Maturity Date 2

The Fix Month Day indicates the day of the month that invoices are due. This field is displayed only when the fixed due date checkbox is selected. 3 different fix month days can be defined.

top

Maturity Date 3

The Fix Month Day indicates the day of the month that invoices are due. This field is displayed only when the fixed due date checkbox is selected. 3 different fix month days can be defined.

top

Operator

top

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)

top

Current Salary Category

Indicates current salary category of the employee

Foreign key column to C_Salary_Category table, (column: C_Salary_Category_ID)

top

Invoice_Printformat

You need to define a Print Format to print the document.

List values: Print Format Invoice

The allowed values for this list are:

top

Consumption Days

This field is used Copy Lines From in Order tab to specify the consumptions made in the last n days.

top

Bank Account

Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)


Reference Table C_BankAccount

top

Tax Category

Foreign key column to C_BP_TaxCategory table, (column: C_BP_TaxCategory_ID)


Reference Table C_BP_TaxCategory

top

PO Maturity Date 1

The Fix Month Day for Purchases indicates the day of the month that invoices are due. This field only displays if the fixed due date checkbox is selected. 3 different Fix Month Days can be defined.

top

PO Maturity Date 2

The Fix Month Day for Purchases indicates the day of the month that invoices are due. This field only displays if the fixed due date checkbox is selected. 3 different Fix Month Days can be defined.

top

PO Maturity Date 3

The Fix Month Day for Purchases indicates the day of the month that invoices are due. This field only displays if the fixed due date checkbox is selected. 3 different Fix Month Days can be defined.

top

Transactional Bank Account

Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)


Reference Table C_BankAccount

top

SO BP Tax Category

Foreign key column to C_BP_TaxCategory table, (column: C_BP_TaxCategory_ID)


Reference Table C_BP_TaxCategory

top

Fiscalcode

top

Isofiscalcode

top

Incoterms ( PO )

Foreign key column to C_Incoterms table, (column: C_Incoterms_ID)


Reference Table C_Incoterms : C_Incoterms.

top

Incoterms ( SO )

Foreign key column to C_Incoterms table, (column: C_Incoterms_ID)


Reference Table C_Incoterms : C_Incoterms.

top

Payment Method

Foreign key column to FIN_PaymentMethod table, (column: Fin_Paymentmethod_ID)


Reference Table FIN_PaymentMethod


Validation Rule FIN_PaymentMethodsWithAccount: Filters only the payment methods that belong to a financial account. With the following code:

 
EXISTS (SELECT 1 FROM FIN_FinAcc_PaymentMethod fapm WHERE FIN_PaymentMethod.FIN_PaymentMethod_ID=fapm.FIN_PaymentMethod_ID)

Callout: SE_PaymentMethod_FinAccount

This element is linked to a callout.

This callout filters the Financial Accounts for selected Payment Method.

It is implemented by org.openbravo.erpCommon.ad_callouts.SE_PaymentMethod_FinAccount Java class.

top

PO Payment method

Foreign key column to FIN_PaymentMethod table, (column: Fin_Paymentmethod_ID)


Reference Table FIN_PaymentMethod


Validation Rule FIN_PaymentMethodsWithAccount: Filters only the payment methods that belong to a financial account. With the following code:

 
EXISTS (SELECT 1 FROM FIN_FinAcc_PaymentMethod fapm WHERE FIN_PaymentMethod.FIN_PaymentMethod_ID=fapm.FIN_PaymentMethod_ID)

Callout: SE_PaymentMethod_FinAccount

This element is linked to a callout.

This callout filters the Financial Accounts for selected Payment Method.

It is implemented by org.openbravo.erpCommon.ad_callouts.SE_PaymentMethod_FinAccount Java class.

top

Account

Foreign key column to FIN_Financial_Account table, (column: Fin_Financial_Account_ID)


Reference Table FIN_Financial_Account

top

PO Financial Account

Foreign key column to FIN_Financial_Account table, (column: Fin_Financial_Account_ID)


Reference Table FIN_Financial_Account

top

Related tables

Tables that link this table:

top

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

This page has been accessed 17,206 times. This page was last modified on 19 April 2018, at 10:39. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.