View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.businesspartner


Contents

C_BPartner

This table contains the following columns:

Name Nullable Data Type Description


PO_PaymentTerm_ID Yes VARCHAR (32) The PO Payment Term indicates the payment term that will be used when this purchase order becomes an invoice.
SOCreditStatus Yes VARCHAR (60) For Documentation only
BPartner_Parent_ID Yes VARCHAR (32) The parent (organization) of the Business Partner for reporting purposes.
AD_Forced_Org_ID Yes VARCHAR (32)
SalesRep_ID Yes VARCHAR (32) Indicates the sales representative responsible for the transaction that the document specifies . A valid sales representative is a business partner marked as an employee and a sales representative.
ShowPriceInOrder No CHAR (1) When not checked prices are not shown (left blank) in the printed order document
Invoicegrouping Yes VARCHAR (60) 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)

FixMonthDay Yes DECIMAL (10,0) 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.
FixMonthDay2 Yes DECIMAL (10,0) 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.
Fixmonthday3 Yes DECIMAL (10,0) 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.
Isworker Yes CHAR (1)
Value No NVARCHAR (40) 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.

UPC Yes NVARCHAR (30) 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)
PO_Fixmonthday Yes DECIMAL (10,0) 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.
PO_Fixmonthday2 Yes DECIMAL (10,0) 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.
PO_Fixmonthday3 Yes DECIMAL (10,0) 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.
Name No NVARCHAR (60) Commercial Name of the Business Partner
SO_Bankaccount_ID Yes VARCHAR (32) Default Customer Bankaccount
PO_Bankaccount_ID Yes VARCHAR (32) Default Vendor Bank Account
Last_Days Yes DECIMAL (10,0) This field is used Copy Lines From in Order tab to specify the consumptions made in the last n days.
Invoice_Printformat Yes VARCHAR (60) You need to define a Print Format to print the document.
SO_Bp_Taxcategory_ID Yes VARCHAR (32) Bussines Partner Tax Category is a category defined for apply default taxes for sales transactions.
TaxID Yes VARCHAR (20) The Tax ID field identifies the legal Identification number of this Entity.
PO_BP_TaxCategory_ID Yes VARCHAR (32) PO Bussines Partner Tax Category is a category defined for apply default taxes for procurement transactions.
C_Salary_Category_ID Yes VARCHAR (32) Indicates a salary category
Fiscalcode Yes NVARCHAR (16)
Isofiscalcode Yes NVARCHAR (2)
C_BP_Group_ID No VARCHAR (32) A way of grouping business partners together for classification and reporting purposes. Provides a method of defining certain defaults to be used when opening new business partners.
IsCustomer No CHAR (1) 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.
IsVendor No CHAR (1) The Vendor checkbox indicates if this Business Partner is a Vendor. If it is selected, additional fields will display which further identify this vendor.
IsActive No CHAR (1) 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.

PO_C_Incoterms_ID Yes VARCHAR (32)
SO_C_Incoterms_ID Yes VARCHAR (32)
FIN_Paymentmethod_ID Yes VARCHAR (32)
PO_Paymentmethod_ID Yes VARCHAR (32)
FIN_Financial_Account_ID Yes VARCHAR (32) Financial account used to deposit / withdrawal money such as bank accounts or petty cash
PO_Financial_Account_ID Yes VARCHAR (32) Financial account used to deposit / withdrawal money such as bank accounts or petty cash
Customer_Blocking No CHAR (1) This flag allows to block the customer. By checking it, a new section will be shown called Business Partner Blocking with the possible blocking options.
Vendor_Blocking No CHAR (1) This flag allows to block the vendor. By checking it, a new section will be shown called Business Partner Blocking with the possible blocking options.
SO_Payment_Blocking No CHAR (1) This flag allows to block payment in in customer.
PO_Payment_Blocking No CHAR (1) This flag allows to block payment out in vendor.
SO_Invoice_Blocking No CHAR (1) This flag allows to block sales invoice in customer.
PO_Invoice_Blocking No CHAR (1) This flag allows to block purchase invoice in vendor.
SO_Order_Blocking No CHAR (1) This flag allows to block sales order in customer.
PO_Order_Blocking No CHAR (1) This flag allows to block purchase order in vendor.
SO_Goods_Blocking No CHAR (1) This flag allows to block goods shipment out in customer.
PO_Goods_Blocking No CHAR (1) This flag allows to block goods receipt in vendor.
Iscashvat No CHAR (1) Cash VAT tax rate
Update_Currency No CHAR (1)
BP_Currency_ID Yes VARCHAR (32) Indicates the currency to be used when processing this document.
DocumentCopies Yes DECIMAL (10,0) The Document Copies indicates the number of copies of each document that will be generated.
PaymentRule Yes VARCHAR (60) Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)
Rating Yes CHAR (1) The Rating is used to differentiate the importance
IsTaxExempt Yes CHAR (1) 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.
URL Yes NVARCHAR (120) The URL defines an online address for this element.
PO_PriceList_ID Yes VARCHAR (32) Identifies the price list used by a Vendor for products purchased by this organization.
IsSalesRep No CHAR (1) The Sales Rep checkbox indicates if this employee is also a sales representative.
IsEmployee No CHAR (1) The Employee checkbox indicates if this Business Partner is an Employee. If it is selected, additional fields will display which further identify this employee.
PaymentRulePO Yes VARCHAR (60) The Payment Rule indicates the method of purchase payment.
C_Greeting_ID Yes VARCHAR (32) The Greeting identifies the greeting to print on correspondence.
POReference Yes NVARCHAR (20) 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.
Name2 Yes NVARCHAR (60) Fiscal Name of the Business Partner.
IsDiscountPrinted Yes CHAR (1) The Discount Printed Checkbox indicates if the discount will be printed on the document.
ShareOfCustomer Yes DECIMAL (10,0) The Share indicates the percentage of this Business Partner's volume of the products supplied.
PotentialLifeTimeValue Yes DECIMAL The Potential Life Time Value is the anticipated revenue to be generated by this Business Partner.
AcqusitionCost Yes DECIMAL The Acquisition Cost identifies the cost associated with making this prospect a customer.
SO_CreditUsed No DECIMAL The Customer Balance indicates the total amount of open or unpaid invoices for this Business Partner.
SO_CreditLimit No DECIMAL The Credit Line Limit indicates the total amount allowed 'on account'. If this is exceeded a warning message will be generated.
FirstSale Yes TIMESTAMP (7) The First Sale Date identifies the date of the first sale to this Business Partner
IsProspect No CHAR (1) The Prospect checkbox indicates an entity that is an active prospect or customer.
C_InvoiceSchedule_ID Yes VARCHAR (32) The Invoice Schedule identifies the frequency used when generating invoices.
SO_Description Yes NVARCHAR (255) The Order Description identifies the standard description to use on orders for this Customer.
InvoiceRule Yes VARCHAR (60) The Invoice Rule defines how a Business Partner is invoiced and the frequency of invoicing.
AD_Language Yes VARCHAR (6) The Language identifies the language to use for display
IsSummary No CHAR (1) 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.
NAICS Yes CHAR (6) The NAICS/SIC identifies either of these codes that may be applicable to this Business Partner.
DeliveryRule Yes VARCHAR (60) 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.
NumberEmployees Yes DECIMAL (10,0) Indicates the number of employees for this Business Partner. This field displays only for Prospects.
DUNS Yes CHAR (11) Used for EDI - For details see www.dnb.com/dunsno/list.htm
ReferenceNo Yes NVARCHAR (40) The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
DeliveryViaRule Yes VARCHAR (60) The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
ActualLifeTimeValue Yes DECIMAL The Actual Life Time Value is the recorded revenue to be generated by this Business Partner.
C_PaymentTerm_ID Yes VARCHAR (32) Payment Terms identify the method and timing of payment for this transaction.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
C_BPartner_ID No VARCHAR (32) A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
SalesVolume Yes DECIMAL (10,0) The Sales Volume indicates the total volume of sales for a Business Partner.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
M_PriceList_ID Yes VARCHAR (32)

Price Lists are used to determine the pricing, margin and cost of items purchased or sold.

IsOneTime No CHAR (1)

Columns

PO Payment Terms


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

top


Credit Status


List values: C_BPartner SOCreditStatus

The allowed values for this list are:

top


Partner Parent



top


Forced Org


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

top


Sales Representative


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

top


Prices Shown in Order



top


Invoice Grouping



List values: Scheduled invoice grouping

The allowed values for this list are:

top


Maturity Date 1



top


Maturity Date 2



top


Maturity Date 3



top


Operator



top


Search Key



top


UPC/EAN



top


PO Maturity Date 1



top


PO Maturity Date 2



top


PO Maturity Date 3



top


Name


top


Transactional Bank Account


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

top


Bank Account


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

top


Consumption Days



top


Invoice_Printformat



List values: Print Format Invoice

The allowed values for this list are:

top


SO BP Tax Category


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

top


Tax ID



top


Tax Category


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

top


Salary Category


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

top


Fiscalcode



top


Isofiscalcode



top


Business Partner Category


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

top


Customer



top


Vendor



top


Active



top


Incoterms ( PO )


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

top


Incoterms ( SO )


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

top


Payment Method


Foreign key column to FIN_PaymentMethod table, (column: Fin_Paymentmethod_ID) It has a validation "FIN_PaymentMethodsWithAccountIsReceiptControl", with the following code

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

AND fapm.isActive='Y' AND fapm.Payin_Allow = (SELECT CASE WHEN '@FIN_ISRECEIPT@'='Y' THEN 'Y' ELSE fapm.Payin_Allow END FROM DUAL) AND fapm.Payout_Allow = (SELECT CASE WHEN '@FIN_ISRECEIPT@'='N' THEN 'Y' ELSE fapm.Payout_Allow END FROM DUAL))

Callout: SE_PaymentMethod_FinAccount

This column has a callout associated. This callout filters the Financial Accounts for selected Payment Method. It is implemented by [1] Java Class.

top


PO Payment method


Foreign key column to FIN_PaymentMethod table, (column: Fin_Paymentmethod_ID) It has a validation "FIN_PaymentMethodsWithAccountIsReceiptControl", with the following code

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

AND fapm.isActive='Y' AND fapm.Payin_Allow = (SELECT CASE WHEN '@FIN_ISRECEIPT@'='Y' THEN 'Y' ELSE fapm.Payin_Allow END FROM DUAL) AND fapm.Payout_Allow = (SELECT CASE WHEN '@FIN_ISRECEIPT@'='N' THEN 'Y' ELSE fapm.Payout_Allow END FROM DUAL))

Callout: SE_PaymentMethod_FinAccount

This column has a callout associated. This callout filters the Financial Accounts for selected Payment Method. It is implemented by [2] Java Class.

top


Account


Foreign key column to FIN_Financial_Account table, (column: Fin_Financial_Account_ID) It has a validation "Financial Account - Customer", with the following code

Fin_Financial_Account_ID IN (SELECT Fin_Financial_Account_ID FROM Fin_Finacc_Paymentmethod WHERE Fin_Paymentmethod_ID=@Fin_Paymentmethod_ID@)

top


PO Financial Account


Foreign key column to FIN_Financial_Account table, (column: Fin_Financial_Account_ID) It has a validation "Financial Account - Vendor", with the following code

Fin_Financial_Account_ID IN (SELECT Fin_Financial_Account_ID FROM Fin_Finacc_Paymentmethod WHERE Fin_Paymentmethod_ID=@PO_Paymentmethod_ID@)

top


Customer Blocking



top


Vendor Blocking



top


Payment In



top


Payment Out



top


Sales Invoice



top


Purchase Invoice



top


Sales Order



top


Purchase Order



top


Goods Shipment



top


Goods Receipt



top


Cash VAT



top


Set New Currency



top


BP_Currency_ID


Foreign key column to C_Currency table, (column: C_Currency_ID)

top


Number of Copies



top


Form of Payment



List values: All_Payment Rule

The allowed values for this list are:

top


Valuation



top


Tax Exempt



top


URL



top


Purchase Pricelist


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

top


Is Sales Representative



top


Employee



top


PO Form of Payment



List values: All_Payment Rule

The allowed values for this list are:

top


Greeting


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

top


Order Reference



top


Name 2



top


Print Discount



top


Share



top


Expected Lifetime Revenue



top


Acquisition Cost



top


Credit Used



top


Credit Limit



top


Date of First Sale



top


Potential Customer



top


Invoice Schedule


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

top


Order Description



top


Invoice Terms



List values: C_Order InvoiceRule

The allowed values for this list are:

top


Language


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

top


Summary Level



top


NAICS/SIC



top


Delivery Terms



List values: C_Order DeliveryRule

The allowed values for this list are:

top


No. of Employees



top


D-U-N-S



top


Reference No.



top


Updated



top


Description



top


Delivery Method



List values: C_Order DeliveryViaRule

The allowed values for this list are:

top


Created By


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

top


Creation Date



top


Lifetime Revenue to Date



top


Payment Terms


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

top


Client


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

top


Business Partner



top


Volume of Sales



top


Updated By


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

top


Organization


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

Callout: SL_BP_Category_Default

This column has a callout associated.

It is implemented by [3] Java Class.

top


Price List


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

top


One Time Transaction



top


Other Info

Indices

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

top

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.common.businesspartner

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

This page has been accessed 3,019 times. This page was last modified on 1 December 2016, at 02:14. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.