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

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


FIN_Financial_Account_ID Yes VARCHAR (32) Financial account used to deposit / withdrawal money such as bank accounts or petty cash
AcqusitionCost Yes DECIMAL The Acquisition Cost identifies the cost associated with making this prospect a customer.
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.

BP_Currency_ID Yes VARCHAR (32) Indicates the currency to be used when processing this document.
PO_Bankaccount_ID Yes VARCHAR (32) Default Vendor Bank Account
Birthday Yes TIMESTAMP (7) Birthdate or Anniversary day
Birthplace Yes VARCHAR (60)
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.
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.
business_partner_type Yes VARCHAR (60) A classification of business partners based on its type, that can either be among others, either a final consumer, or an organization, or a professional or a public sector institution.
Iscashvat No CHAR (1) Cash VAT tax rate
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
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.
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.
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.
SOCreditStatus Yes VARCHAR (60) For Documentation only
SO_CreditUsed No DECIMAL The Customer Balance indicates the total amount of open or unpaid invoices for this Business Partner.
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.
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.
DUNS Yes CHAR (11) Used for EDI - For details see www.dnb.com/dunsno/list.htm
FirstSale Yes TIMESTAMP (7) The First Sale Date identifies the date of the first sale to this Business Partner
DeliveryViaRule Yes VARCHAR (60) The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.
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.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
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.
PotentialLifeTimeValue Yes DECIMAL The Potential Life Time Value is the anticipated revenue to be generated by this Business Partner.
Fiscalcode Yes NVARCHAR (16)
AD_Forced_Org_ID Yes VARCHAR (32)
PaymentRule Yes VARCHAR (60) Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)
PO_Goods_Blocking No CHAR (1) This flag allows to block goods receipt in vendor.
SO_Goods_Blocking No CHAR (1) This flag allows to block goods shipment out in customer.
C_Greeting_ID Yes VARCHAR (32) The Greeting identifies the greeting to print on correspondence.
PO_C_Incoterms_ID Yes VARCHAR (32)
SO_C_Incoterms_ID Yes VARCHAR (32)
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)

C_InvoiceSchedule_ID Yes VARCHAR (32) The Invoice Schedule identifies the frequency used when generating invoices.
InvoiceRule Yes VARCHAR (60) The Invoice Rule defines how a Business Partner is invoiced and the frequency of invoicing.
Invoice_Printformat Yes VARCHAR (60) You need to define a Print Format to print the document.
IsSalesRep No CHAR (1) The Sales Rep checkbox indicates if this employee is also a sales representative.
Isofiscalcode Yes NVARCHAR (2)
AD_Language Yes VARCHAR (6) The Language identifies the language to use for display
ActualLifeTimeValue Yes DECIMAL The Actual Life Time Value is the recorded revenue to be generated by this Business Partner.
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.
NAICS Yes CHAR (6) The NAICS/SIC identifies either of these codes that may be applicable to this Business Partner.
Name No NVARCHAR (60) Commercial Name of the Business Partner
Name2 Yes NVARCHAR (60) Fiscal Name of the Business Partner.
NumberEmployees Yes DECIMAL (10,0) Indicates the number of employees for this Business Partner. This field displays only for Prospects.
DocumentCopies Yes DECIMAL (10,0) The Document Copies indicates the number of copies of each document that will be generated.
IsOneTime No CHAR (1)
Isworker Yes CHAR (1)
SO_Description Yes NVARCHAR (255) The Order Description identifies the standard description to use on orders for this Customer.
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.
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.
PO_Financial_Account_ID Yes VARCHAR (32) Financial account used to deposit / withdrawal money such as bank accounts or petty cash
PaymentRulePO Yes VARCHAR (60) The Payment Rule indicates the method of purchase payment.
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.
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.
PO_Paymentmethod_ID Yes VARCHAR (32)
BPartner_Parent_ID Yes VARCHAR (32) The parent (organization) of the Business Partner for reporting purposes.
SO_Payment_Blocking No CHAR (1) This flag allows to block payment in in customer.
FIN_Paymentmethod_ID Yes VARCHAR (32)
PO_Payment_Blocking No CHAR (1) This flag allows to block payment out in vendor.
C_PaymentTerm_ID Yes VARCHAR (32) Payment Terms identify the method and timing of payment for this transaction.
IsProspect No CHAR (1) The Prospect checkbox indicates an entity that is an active prospect or customer.
M_PriceList_ID Yes VARCHAR (32)

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

ShowPriceInOrder No CHAR (1) When not checked prices are not shown (left blank) in the printed order document
IsDiscountPrinted Yes CHAR (1) The Discount Printed Checkbox indicates if the discount will be printed on the document.
PO_Invoice_Blocking No CHAR (1) This flag allows to block purchase invoice in vendor.
PO_Order_Blocking No CHAR (1) This flag allows to block purchase order in vendor.
PO_PriceList_ID Yes VARCHAR (32) Identifies the price list used by a Vendor for products purchased by this organization.
ReferenceNo Yes NVARCHAR (40) The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.
SO_Bp_Taxcategory_ID Yes VARCHAR (32) Bussines Partner Tax Category is a category defined for apply default taxes for sales transactions.
C_Salary_Category_ID Yes VARCHAR (32) Indicates a salary category
SO_Invoice_Blocking No CHAR (1) This flag allows to block sales invoice in customer.
SO_Order_Blocking No CHAR (1) This flag allows to block sales order in customer.
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.
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.

Update_Currency No CHAR (1)
ShareOfCustomer Yes DECIMAL (10,0) The Share indicates the percentage of this Business Partner's volume of the products supplied.
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.
PO_BP_TaxCategory_ID Yes VARCHAR (32) PO Bussines Partner Tax Category is a category defined for apply default taxes for procurement transactions.
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.
TaxID Yes VARCHAR (20) The Tax ID field identifies the legal Identification number of this Entity.
SO_Bankaccount_ID Yes VARCHAR (32) Default Customer Bankaccount
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)
URL Yes NVARCHAR (120) The URL defines an online address for this element.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
Rating Yes CHAR (1) The Rating is used to differentiate the importance
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.
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.
SalesVolume Yes DECIMAL (10,0) The Sales Volume indicates the total volume of sales for a Business Partner.
Is_Customer_Consent Yes CHAR (1) This check describes if the Customer consents to process their personal information
Is_Customer_Consent_PapFormat No CHAR (1) This check describes if the Customer consents to send their information in paper format

Columns

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


Acquisition Cost



top


Active



top


BP_Currency_ID


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

top


Bank Account


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

top


Birth Day



top


Birth Place



top


Business Partner



top


Business Partner Category


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

top


Business Partner Type



List values: Business_Partner_Type

The allowed values for this list are:

top


Cash VAT



top


Client


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

top


Consumption Days



top


Created By


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

top


Creation Date



top


Credit Limit



top


Credit Status


List values: C_BPartner SOCreditStatus

The allowed values for this list are:

top


Credit Used



top


Customer



top


Customer Blocking



top


D-U-N-S



top


Date of First Sale



top


Delivery Method



List values: C_Order DeliveryViaRule

The allowed values for this list are:

top


Delivery Terms



List values: C_Order DeliveryRule

The allowed values for this list are:

top


Description



top


Employee



top


Expected Lifetime Revenue



top


Fiscalcode



top


Forced Org


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

top


Form of Payment



List values: All_Payment Rule

The allowed values for this list are:

top


Goods Receipt



top


Goods Shipment



top


Greeting


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

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


Invoice Grouping



List values: Scheduled invoice grouping

The allowed values for this list are:

top


Invoice Schedule


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

top


Invoice Terms



List values: C_Order InvoiceRule

The allowed values for this list are:

top


Invoice_Printformat



List values: Print Format Invoice

The allowed values for this list are:

top


Is Sales Representative



top


Isofiscalcode



top


Language


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

top


Lifetime Revenue to Date



top


Maturity Date 1



top


Maturity Date 2



top


Maturity Date 3



top


NAICS/SIC



top


Name


top


Name 2



top


No. of Employees



top


Number of Copies



top


One Time Transaction



top


Operator



top


Order Description



top


Order Reference



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 [1] Java Class.

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


PO Form of Payment



List values: All_Payment Rule

The allowed values for this list are:

top


PO Maturity Date 1



top


PO Maturity Date 2



top


PO Maturity Date 3



top


PO Payment Terms


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

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


Partner Parent



top


Payment In



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 [3] Java Class.

top


Payment Out



top


Payment Terms


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

top


Potential Customer



top


Price List


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

top


Prices Shown in Order



top


Print Discount



top


Purchase Invoice



top


Purchase Order



top


Purchase Pricelist


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

top


Reference No.



top


SO BP 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


Sales Invoice



top


Sales Order



top


Sales Representative


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

top


Search Key



top


Set New Currency



top


Share



top


Summary Level



top


Tax Category


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

top


Tax Exempt



top


Tax ID



top


Transactional Bank Account


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

top


UPC/EAN



top


URL



top


Updated



top


Updated By


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

top


Valuation



top


Vendor



top


Vendor Blocking



top


Volume of Sales



top


isCustomerConsent



top


isCustomerConsentPapFormat



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 10,797 times. This page was last modified on 28 August 2023, at 01:58. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.