ERP/2.50/Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BPartner
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.
- Name:BusinessPartner
- Classname:BusinessPartner
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_BPartner_ID | N | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
Value | N | NVARCHAR2(40) | A fast method for finding a particular record. |
Name | N | NVARCHAR2(60) | Alphanumeric identifier of the entity |
Name2 | Y | NVARCHAR2(60) | Additional Name |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
IsSummary | N | CHAR(1) | A means of grouping fields in order to view or hide additional information. |
C_BP_Group_ID | N | VARCHAR2(32) | A classification of business partners based on defined similarities. |
IsOneTime | N | CHAR(1) | null |
IsProspect | N | CHAR(1) | Indicates a Prospect or Customer |
IsVendor | N | CHAR(1) | A business partner who sells products or services. |
IsCustomer | N | CHAR(1) | Indicates a business partner that is your customer, ie. that will be making purchases from you. |
IsEmployee | N | CHAR(1) | A business partner who will be working for an organization. |
IsSalesRep | N | CHAR(1) | The person in charge of carry out an order. |
ReferenceNo | Y | NVARCHAR2(40) | The number for a specific reference. |
DUNS | Y | CHAR(11) | Dun & Bradstreet Number |
URL | Y | NVARCHAR2(120) | An address which can be accessed via internet. |
AD_Language | Y | VARCHAR2(6) | Language for this application |
TaxID | Y | VARCHAR2(20) | The government defined unique number for assigning and paying taxes. |
IsTaxExempt | Y | CHAR(1) | A condition stating that for a specific case, taxes must not be applied. |
C_InvoiceSchedule_ID | Y | VARCHAR2(32) | Schedule for generating Invoices |
Rating | Y | CHAR(1) | An estimation or appraisal with the goal of defining a value. |
SalesVolume | Y | NUMBER(10, 0) | Total Volume of Sales |
NumberEmployees | Y | NUMBER(10, 0) | Number of employees |
NAICS | Y | CHAR(6) | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html |
FirstSale | Y | DATE | Date of First Sale |
AcqusitionCost | Y | NUMBER | The cost of gaining the prospect as a customer |
PotentialLifeTimeValue | Y | NUMBER | Total Revenue expected |
ActualLifeTimeValue | Y | NUMBER | Actual Life Time Revenue |
ShareOfCustomer | Y | NUMBER(10, 0) | Share of Customer's business as a percentage |
PaymentRule | Y | VARCHAR2(60) | The method used for payment of this transaction. |
SO_CreditLimit | Y | NUMBER | Total outstanding invoice amounts allowed |
SO_CreditUsed | Y | NUMBER | Current open balance |
C_PaymentTerm_ID | Y | VARCHAR2(32) | The setup and timing defined to complete a specified payment. |
M_PriceList_ID | Y | VARCHAR2(32) | A catalog of selected items with prices defined generally or for a specific partner. |
IsDiscountPrinted | Y | CHAR(1) | An option to have any discount printed on the invoice. |
SO_Description | Y | NVARCHAR2(255) | Description to be used on orders |
POReference | Y | NVARCHAR2(20) | A reference or document order number as listed in business partner application. |
PaymentRulePO | Y | VARCHAR2(60) | Purchase payment option |
PO_PriceList_ID | Y | VARCHAR2(32) | Price List used by this Business Partner |
PO_PaymentTerm_ID | Y | VARCHAR2(32) | Payment rules for a purchase order |
DocumentCopies | Y | NUMBER(10, 0) | The number of copies of each document that will be printed. |
C_Greeting_ID | Y | VARCHAR2(32) | A description, often abbreviated, of how to address a business partner. |
InvoiceRule | Y | VARCHAR2(60) | Frequency and method of invoicing |
DeliveryRule | Y | VARCHAR2(60) | A definition stating when a specific delivery will occur. |
DeliveryViaRule | Y | VARCHAR2(60) | The desired means of getting requested goods to a business partner. |
SalesRep_ID | Y | VARCHAR2(32) | The person in charge of a document. |
BPartner_Parent_ID | Y | VARCHAR2(32) | Business Partner Parent |
SOCreditStatus | Y | VARCHAR2(60) | Sales Credit Status |
AD_Forced_Org_ID | Y | VARCHAR2(32) | null |
ShowPriceInOrder | N | CHAR(1) | null |
Invoicegrouping | Y | VARCHAR2(60) | null |
FixMonthDay | Y | NUMBER(10, 0) | The day of the month that invoices are due. 3 maturity dates can be defined. |
FixMonthDay2 | Y | NUMBER(10, 0) | The day of the month that invoices are due. 3 maturity dates can be defined. |
Fixmonthday3 | Y | NUMBER(10, 0) | The day of the month that invoices are due. 3 maturity dates can be defined. |
Isworker | Y | CHAR(1) | null |
UPC | Y | NVARCHAR2(30) | A bar code with a number to identify a product. |
C_Salary_Category_ID | Y | VARCHAR2(32) | A classification of salaries based on similar characteristics or attributes. |
Invoice_Printformat | Y | VARCHAR2(60) | Print Format for printing Invoices |
Last_Days | Y | NUMBER(10, 0) | Consumption Days |
PO_Bankaccount_ID | Y | VARCHAR2(32) | Default Vendor Bank Account |
PO_BP_TaxCategory_ID | Y | VARCHAR2(32) | Bussines Partner Tax Category as a Vendor |
PO_Fixmonthday | Y | NUMBER(10, 0) | The day of the month that invoices are due. 3 maturity dates can be defined. |
PO_Fixmonthday2 | Y | NUMBER(10, 0) | Day of the month of the due date |
PO_Fixmonthday3 | Y | NUMBER(10, 0) | Day of the month of the due date |
SO_Bankaccount_ID | Y | VARCHAR2(32) | Default Customer Bankaccount |
SO_Bp_Taxcategory_ID | Y | VARCHAR2(32) | SO BP Tax Category |
Fiscalcode | Y | NVARCHAR2(16) | Fiscal code |
Isofiscalcode | Y | NVARCHAR2(2) | Iso fiscal code |
PO_C_Incoterms_ID | Y | VARCHAR2(32) | null |
SO_C_Incoterms_ID | Y | VARCHAR2(32) | null |
FIN_Paymentmethod_ID | Y | VARCHAR2(32) | It is the method by which payment is expected to be made or received. |
PO_Paymentmethod_ID | Y | VARCHAR2(32) | null |
FIN_Financial_Account_ID | Y | VARCHAR2(32) | Financial account used to deposit / withdrawal money such as bank accounts or petty cash |
PO_Financial_Account_ID | Y | VARCHAR2(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:
- C_BPARTNER_INVOICERULE_CHK: ((INVOICERULE) <> 'S') OR (C_INVOICESCHEDULE_ID IS NOT NULL)
- C_BPARTNER_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- C_BPARTNER_ISCUSTOMER_CHK: ISCUSTOMER IN ('Y', 'N')
- C_BPARTNER_ISDISCOUNTPRINT_CHK: ISDISCOUNTPRINTED IN ('Y', 'N')
- C_BPARTNER_ISEMPLOYEE_CHK: ISEMPLOYEE IN ('Y', 'N')
- C_BPARTNER_ISONETIME_CHK: ISONETIME IN ('Y', 'N')
- C_BPARTNER_ISPROSPECT_CHK: ISPROSPECT IN ('Y', 'N')
- C_BPARTNER_ISSALESREP_CHK: ISSALESREP IN ('Y', 'N')
- C_BPARTNER_ISSUMMARY_CHK: ISSUMMARY IN ('Y', 'N')
- C_BPARTNER_ISTAXEXEMPT_CHK: ISTAXEXEMPT IN ('Y', 'N')
- C_BPARTNER_ISVENDOR_CHK: ISVENDOR IN ('Y', 'N')
- C_BPARTNER_SHOWPRICEINORDE_CHK: SHOWPRICEINORDER IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Non Unique
- C_BPARTNER_NAME
Unique
- C_BPARTNER_KEY
- C_BPARTNER_VALUE
Columns
Business Partner
A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
- Physical column name: C_BPartner_ID
- Property Name: id
- Reference: ID
- Default value: @C_BPartner_ID@
Client
- Physical column name: AD_Client_ID
- Property Name: client
- 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
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
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.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_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
- Property Name: searchKey
- Reference: String
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.
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Name 2
- Physical column name: Name2
- Property Name: name2
- Reference: String
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
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.
- Physical column name: IsSummary
- Property Name: summaryLevel
- Reference: YesNo
Business Partner Category
- Physical column name: C_BP_Group_ID
- Property Name: businessPartnerCategory
- Reference: TableDir
Foreign key column to C_BP_Group table, (column: C_BP_Group_ID)
One Time Transaction
- Physical column name: IsOneTime
- Property Name: oneTimeTransaction
- Reference: YesNo
Potential Customer
The Prospect checkbox indicates an entity that is an active prospect or customer.
- Physical column name: IsProspect
- Property Name: potentialCustomer
- 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
- Property Name: vendor
- Reference: YesNo
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
- Property Name: customer
- Reference: YesNo
- Default value: Y
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.
- Physical column name: IsEmployee
- Property Name: employee
- Reference: YesNo
Is Sales Representative
The Sales Rep checkbox indicates if this employee is also a sales representative.
- Physical column name: IsSalesRep
- Property Name: isSalesRepresentative
- Reference: YesNo
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
- Property Name: referenceNo
- Reference: String
D-U-N-S
Used for EDI - For details see www.dnb.com/dunsno/list.htm
- Physical column name: DUNS
- Property Name: dUNS
- Reference: String
URL
The URL defines an online address for this element.
- Physical column name: URL
- Property Name: uRL
- Reference: Link
Language
The Language identifies the language to use for display
- Physical column name: AD_Language
- Property Name: language
- Reference: Table
Foreign key column to AD_Language table, (column: AD_Language_ID)
Reference Table AD_Language
Tax ID
The Tax ID field identifies the legal Identification number of this Entity.
- Physical column name: TaxID
- Property Name: taxID
- Reference: String
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.
- Physical column name: IsTaxExempt
- Property Name: taxExempt
- Reference: YesNo
Invoice Schedule
- Physical column name: C_InvoiceSchedule_ID
- Property Name: invoiceSchedule
- Reference: TableDir
Foreign key column to C_InvoiceSchedule table, (column: C_InvoiceSchedule_ID)
Valuation
The Rating is used to differentiate the importance
- Physical column name: Rating
- Property Name: valuation
- Reference: String
Volume of Sales
The Sales Volume indicates the total volume of sales for a Business Partner.
- Physical column name: SalesVolume
- Property Name: volumeOfSales
- Reference: Amount
No. of Employees
Indicates the number of employees for this Business Partner. This field displays only for Prospects.
- Physical column name: NumberEmployees
- Property Name: noOfEmployees
- Reference: Integer
NAICS/SIC
The NAICS/SIC identifies either of these codes that may be applicable to this Business Partner.
- Physical column name: NAICS
- Property Name: nAICSSIC
- Reference: String
Date of First Sale
The First Sale Date identifies the date of the first sale to this Business Partner
- Physical column name: FirstSale
- Property Name: dateOfFirstSale
- Reference: Date
Acquisition Cost
The Acquisition Cost identifies the cost associated with making this prospect a customer.
- Physical column name: AcqusitionCost
- Property Name: acquisitionCost
- Reference: Amount
Expected Lifetime Revenue
The Potential Life Time Value is the anticipated revenue to be generated by this Business Partner.
- Physical column name: PotentialLifeTimeValue
- Property Name: expectedLifetimeRevenue
- Reference: Amount
Lifetime Revenue to Date
The Actual Life Time Value is the recorded revenue to be generated by this Business Partner.
- Physical column name: ActualLifeTimeValue
- Property Name: lifetimeRevenueToDate
- Reference: Amount
The Share indicates the percentage of this Business Partner's volume of the products supplied.
- Physical column name: ShareOfCustomer
- Property Name: share
- Reference: Integer
Form of Payment
Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)
- Physical column name: PaymentRule
- Property Name: formOfPayment
- Reference: List
List values: All_Payment Rule
The allowed values for this list are:
- 1 (Wire Transfer): Wire Transfer
- 2 (Check): Check
- 3 (Promissory Note): Promissory Note
- 4 (Money Order)
- 5 (Bank Deposit)
- B (Cash): Cash payments that generate an automatic accounting line.
- C (Cash on Delivery): Cash on Delivery
- K (Credit Card)
- P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
- R (Bank Remittance)
- T (Transfer (ACH))
- W (Withholding)
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
- Property Name: 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
- Property Name: creditUsed
- Reference: Amount
Payment Terms
- Physical column name: C_PaymentTerm_ID
- Property Name: paymentTerms
- Reference: TableDir
Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)
Price List
- Physical column name: M_PriceList_ID
- Property Name: priceList
- Reference: Table
Foreign key column to M_PriceList table, (column: M_PriceList_ID)
Reference Table M_PriceListForSale With the following where clause:
M_PRICELIST.ISSOPRICELIST='Y'
Print Discount
The Discount Printed Checkbox indicates if the discount will be printed on the document.
- Physical column name: IsDiscountPrinted
- Property Name: printDiscount
- Reference: YesNo
Order Description
The Order Description identifies the standard description to use on orders for this Customer.
- Physical column name: SO_Description
- Property Name: orderDescription
- Reference: String
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.
- Physical column name: POReference
- Property Name: orderReference
- Reference: String
Payment Rule
The Payment Rule indicates the method of purchase payment.
- Physical column name: PaymentRulePO
- Property Name: pOFormOfPayment
- Reference: List
List values: All_Payment Rule
The allowed values for this list are:
- 1 (Wire Transfer): Wire Transfer
- 2 (Check): Check
- 3 (Promissory Note): Promissory Note
- 4 (Money Order)
- 5 (Bank Deposit)
- B (Cash): Cash payments that generate an automatic accounting line.
- C (Cash on Delivery): Cash on Delivery
- K (Credit Card)
- P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
- R (Bank Remittance)
- T (Transfer (ACH))
- W (Withholding)
Purchase Pricelist
Identifies the price list used by a Vendor for products purchased by this organization.
- Physical column name: PO_PriceList_ID
- Property Name: purchasePricelist
- Reference: Table
Foreign key column to M_PriceList table, (column: M_PriceList_ID)
Reference Table M_PriceListForPurchase With the following where clause:
M_PRICELIST.ISSOPRICELIST='N'
PO Payment Term
The PO Payment Term indicates the payment term that will be used when this purchase order becomes an invoice.
- Physical column name: PO_PaymentTerm_ID
- Property Name: pOPaymentTerms
- Reference: Table
Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)
Reference Table C_PaymentTerm
Number of Copies
The Document Copies indicates the number of copies of each document that will be generated.
- Physical column name: DocumentCopies
- Property Name: numberOfCopies
- Reference: Integer
Greeting
- Physical column name: C_Greeting_ID
- Property Name: greeting
- Reference: TableDir
Foreign key column to C_Greeting table, (column: C_Greeting_ID)
Invoice Terms
The Invoice Rule defines how a Business Partner is invoiced and the frequency of invoicing.
- Physical column name: InvoiceRule
- Property Name: invoiceTerms
- Reference: List
- Default value: I
List values: C_Order InvoiceRule
The allowed values for this list are:
- D (After Delivery): Invoice per Delivery
- I (Immediate): Immediate Invoice
- N (Do Not Invoice): Order should not be invoiced trough Process Invoice
- O (After Order Delivered): Invoice for every order
- S (Customer Schedule After Delivery): Invoice per Customer Invoice Schedule
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.
- Physical column name: DeliveryRule
- Property Name: deliveryTerms
- Reference: List
List values: C_Order DeliveryRule
The allowed values for this list are:
- A (Availability): As soon as an item becomes available
- L (Complete Line): As soon as all items of a line become available
- O (Complete Order): As soon as all items of an order are available
- R (After Receipt): After receipt of cash
Delivery Method
The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.
- Physical column name: DeliveryViaRule
- Property Name: deliveryMethod
- Reference: List
List values: C_Order DeliveryViaRule
The allowed values for this list are:
- D (Delivery)
- P (Pickup)
- S (Shipper)
Sales Representative
- Physical column name: SalesRep_ID
- Property Name: salesRepresentative
- Reference: Table
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'
Partner Parent
The parent (organization) of the Business Partner for reporting purposes.
- Physical column name: BPartner_Parent_ID
- Property Name: partnerParent
- Reference: ID
Credit Status
For Documentation only
- Physical column name: SOCreditStatus
- Property Name: creditStatus
- Reference: List
List values: C_BPartner SOCreditStatus
The allowed values for this list are:
- H (Credit Hold)
- O (Credit OK)
- S (Credit Stop)
- W (Credit Watch)
- X (No Credit Check)
Forced org
- Physical column name: AD_Forced_Org_ID
- Property Name: forcedOrg
- Reference: Table
Foreign key column to AD_Org table, (column: AD_Org_ID)
Reference Table AD_Org (all)
Prices Shown in Order
When not checked prices are not shown (left blank) in the printed order document
- Physical column name: ShowPriceInOrder
- Property Name: pricesShownInOrder
- Reference: YesNo
- Default value: Y
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)
- Physical column name: Invoicegrouping
- Property Name: invoiceGrouping
- Reference: List
- Default value: 000000000000000
List values: Scheduled invoice grouping
The allowed values for this list are:
- 000000000000000 (By customer): Totally grouped
- 000000000010000 (By project): Break into different invoices if the project is different
- 000010000000000 (By ship location): Break into different invoices if the ship location is different
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.
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.
- Physical column name: FixMonthDay
- Property Name: maturityDate1
- Reference: Integer
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.
- Physical column name: FixMonthDay2
- Property Name: maturityDate2
- Reference: Integer
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.
- Physical column name: Fixmonthday3
- Property Name: maturityDate3
- Reference: Integer
Operator
- Physical column name: Isworker
- Property Name: operator
- Reference: YesNo
- Default value: N
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)
- Physical column name: UPC
- Property Name: uPCEAN
- Reference: String
Current Salary Category
Indicates current salary category of the employee
- Physical column name: C_Salary_Category_ID
- Property Name: salaryCategory
- Reference: TableDir
Foreign key column to C_Salary_Category table, (column: C_Salary_Category_ID)
Invoice_Printformat
You need to define a Print Format to print the document.
- Physical column name: Invoice_Printformat
- Property Name: invoicePrintformat
- Reference: List
List values: Print Format Invoice
The allowed values for this list are:
- 1 (Detail)
- 2 (Total)
- 3 (Product detail): Product detail
Consumption Days
This field is used Copy Lines From in Order tab to specify the consumptions made in the last n days.
- Physical column name: Last_Days
- Property Name: consumptionDays
- Reference: Integer
Bank Account
- Physical column name: PO_Bankaccount_ID
- Property Name: bankAccount
- Reference: Table
Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)
Reference Table C_BankAccount
Tax Category
- Physical column name: PO_BP_TaxCategory_ID
- Property Name: taxCategory
- Reference: Table
Foreign key column to C_BP_TaxCategory table, (column: C_BP_TaxCategory_ID)
Reference Table C_BP_TaxCategory
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.
- Physical column name: PO_Fixmonthday
- Property Name: pOMaturityDate1
- Reference: Integer
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.
- Physical column name: PO_Fixmonthday2
- Property Name: pOMaturityDate2
- Reference: Integer
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.
- Physical column name: PO_Fixmonthday3
- Property Name: pOMaturityDate3
- Reference: Integer
Transactional Bank Account
- Physical column name: SO_Bankaccount_ID
- Property Name: transactionalBankAccount
- Reference: Table
Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)
Reference Table C_BankAccount
SO BP Tax Category
- Physical column name: SO_Bp_Taxcategory_ID
- Property Name: sOBPTaxCategory
- Reference: Table
Foreign key column to C_BP_TaxCategory table, (column: C_BP_TaxCategory_ID)
Reference Table C_BP_TaxCategory
Fiscalcode
- Physical column name: Fiscalcode
- Property Name: fiscalcode
- Reference: String
Isofiscalcode
- Physical column name: Isofiscalcode
- Property Name: isofiscalcode
- Reference: String
Incoterms ( PO )
- Physical column name: PO_C_Incoterms_ID
- Property Name: incotermsPO
- Reference: Table
Foreign key column to C_Incoterms table, (column: C_Incoterms_ID)
Reference Table C_Incoterms : C_Incoterms.
Incoterms ( SO )
- Physical column name: SO_C_Incoterms_ID
- Property Name: incotermsSO
- Reference: Table
Foreign key column to C_Incoterms table, (column: C_Incoterms_ID)
Reference Table C_Incoterms : C_Incoterms.
Payment Method
- Physical column name: FIN_Paymentmethod_ID
- Property Name: paymentMethod
- Reference: Table
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.
PO Payment method
- Physical column name: PO_Paymentmethod_ID
- Property Name: pOPaymentMethod
- Reference: Table
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.
Account
- Physical column name: FIN_Financial_Account_ID
- Property Name: account
- Reference: Table
Foreign key column to FIN_Financial_Account table, (column: Fin_Financial_Account_ID)
Reference Table FIN_Financial_Account
PO Financial Account
- Physical column name: PO_Financial_Account_ID
- Property Name: pOFinancialAccount
- Reference: Table
Foreign key column to FIN_Financial_Account table, (column: Fin_Financial_Account_ID)
Reference Table FIN_Financial_Account
Related tables
Tables that link this table:
- ADUser.Business Partner
- ActiveProposalV.Business Partner
- ApprovedVendor.Business Partner
- BPartnerV.Business Partner
- Bank.Business Partner
- BusinessPartner.Sales Representative
- BusinessPartnerDiscount.Business Partner
- BusinessPartnerProductTemplate.Business Partner
- ClientInformation.Template B.Partner
- DataImportBankStatement.Business Partner
- DataImportBusinessPartner.Business Partner
- DataImportGLJournal.Business Partner
- DataImportInvoice.Business Partner
- DataImportOrder.Business Partner
- DataImportProduct.Business Partner
- ExternalPOS.Business Partner
- FIN_BankStatementLine.Business Partner
- FIN_Financial_Account.Business Partner
- FIN_Payment.Business Partner
- FIN_Payment_Detail_V.Business Partner
- FIN_Payment_Prop_Detail_V.Business Partner
- FIN_Payment_Proposal.Business Partner
- FinancialMgmtAccountingCombination.Business Partner
- FinancialMgmtAccountingFact.Business Partner
- FinancialMgmtAsset.Business Partner
- FinancialMgmtBudgetLine.Business Partner
- FinancialMgmtDebtPayment.Business Partner
- FinancialMgmtDebtPaymentCancelV.Business Partner
- FinancialMgmtDebtPaymentGenerateV.Business Partner
- FinancialMgmtTaxPayment.Business Partner
- FinancialMgmtWithholding.Beneficiary
- InOutHeaderV.Business Partner
- Invoice.Business Partner
- InvoiceCustomerProdQtr.Business Partner
- InvoiceCustomerVendQtr.Business Partner
- InvoiceCustomerVendQtr.Vendor
- InvoiceHeaderV.Business Partner
- InvoiceLineV2.Business Partner
- InvoiceV2.Business Partner
- InvoiceVendorMonth.Business Partner
- MRPProductionRun.Business Partner
- MRPPurchasingRun.Business Partner
- MRPPurchasingRun.Vendor
- MRPPurchasingRunLine.Business Partner
- MRPSalesForecast.Business Partner
- ManufacturingMaintenanceWorker.Business Partner
- ManufacturingWorkEffortEmployee.Business Partner
- MaterialMgmtShipmentInOut.Business Partner
- Order.Business Partner
- Order.Drop Ship Partner
- OrderHeaderV.Business Partner
- OrderLine.Business Partner
- OrderOpen.Business Partner
- OrganizationInformation.Business Partner
- PricingAdjustmentBusinessPartner.Business Partner
- PricingPriceListSchemeLine.Business Partner
- PricingVolumeDiscountBusinessPartner.Business Partner
- ProcurementRequisition.Business Partner
- ProcurementRequisitionLine.Business Partner
- Product.Business Partner
- ProductCustomer.Business Partner
- Project.Business Partner
- Project.Person in Charge
- ProjectHeaderV.Business Partner
- ProjectProposal.Business Partner
- ProjectVendor.Business Partner
- Request.Business Partner
- RequestionAction.Business Partner
- SalesCommission.Business Partner
- SalesCommissionLine.Business Partner
- Test.Business Partner
- TimeAndExpenseSheet.Business Partner
- TimeAndExpenseSheetLine.Business Partner
- TimeAndExpenseSheetLineV.Charged Business Partner
- TransactionV.Business Partner
- WarehousePeriodInvoiced.Business Partner
- WarehouseShipper.Business Partner