ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BPartner
C_BPartner
- Name:C_BPartner
- Classname:BusinessPartner
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
- 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)
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@)
Acquisition Cost
- Physical column name: AcqusitionCost
- Property Name: acquisitionCost
- Reference: Amount
- Default value: 0
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
BP_Currency_ID
- Physical column name: BP_Currency_ID
- Property Name: currency
- Reference: Table
Foreign key column to C_Currency table, (column: C_Currency_ID)
Bank Account
- Physical column name: PO_Bankaccount_ID
- Property Name: bankAccount
- Reference: Table
Foreign key column to C_BankAccount table, (column: C_BankAccount_ID)
Birth Day
- Physical column name: Birthday
- Property Name: birthDay
- Reference: Date
Birth Place
- Physical column name: Birthplace
- Property Name: birthPlace
- Reference: String
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: id
- Reference: ID
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)
Business Partner Type
- Physical column name: business_partner_type
- Property Name: businessPartnerType
- Reference: List
List values: Business_Partner_Type
The allowed values for this list are:
- FC (Final consumer)
- CO (Company)
- PR (Professional)
- PS (Public Sector)
Cash VAT
- Physical column name: Iscashvat
- Property Name: cashVAT
- Reference: YesNo
- Default value: N
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Consumption Days
- Physical column name: Last_Days
- Property Name: consumptionDays
- Reference: Integer
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Credit Limit
- Physical column name: SO_CreditLimit
- Property Name: creditLimit
- Reference: Amount
- Default value: 0
Credit Status
- Physical column name: SOCreditStatus
- Property Name: creditStatus
- Reference: List
- Default value: O
List values: C_BPartner SOCreditStatus
The allowed values for this list are:
- S (Credit Stop)
- H (Credit Hold)
- W (Credit Watch)
- X (No Credit Check)
- O (Credit OK)
Credit Used
- Physical column name: SO_CreditUsed
- Property Name: creditUsed
- Reference: Amount
- Default value: 0
Customer
- Physical column name: IsCustomer
- Property Name: customer
- Reference: YesNo
- Default value: Y
Customer Blocking
- Physical column name: Customer_Blocking
- Property Name: customerBlocking
- Reference: YesNo
- Default value: N
D-U-N-S
- Physical column name: DUNS
- Property Name: dUNS
- Reference: String
Date of First Sale
- Physical column name: FirstSale
- Property Name: dateOfFirstSale
- Reference: Date
Delivery Method
- Physical column name: DeliveryViaRule
- Property Name: deliveryMethod
- Reference: List
List values: C_Order DeliveryViaRule
The allowed values for this list are:
- P (Pickup)
- D (Delivery)
- S (Shipper)
Delivery Terms
- Physical column name: DeliveryRule
- Property Name: deliveryTerms
- Reference: List
List values: C_Order DeliveryRule
The allowed values for this list are:
- R (After Receipt): After receipt of cash
- 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
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Employee
- Physical column name: IsEmployee
- Property Name: employee
- Reference: YesNo
- Default value: N
Expected Lifetime Revenue
- Physical column name: PotentialLifeTimeValue
- Property Name: expectedLifetimeRevenue
- Reference: Amount
- Default value: 0
Fiscalcode
- Physical column name: Fiscalcode
- Property Name: fiscalcode
- Reference: String
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)
Form of Payment
- Physical column name: PaymentRule
- Property Name: formOfPayment
- Reference: List
List values: All_Payment Rule
The allowed values for this list are:
- B (Cash): Cash payments that generate an automatic accounting line.
- K (Credit Card)
- T (Transfer (ACH))
- P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
- 1 (Wire Transfer): Wire Transfer
- 2 (Check): Check
- 3 (Promissory Note): Promissory Note
- C (Cash on Delivery): Cash on Delivery
- 4 (Money Order)
- 5 (Bank Deposit)
- R (Bank Remittance)
- W (Withholding)
Goods Receipt
- Physical column name: PO_Goods_Blocking
- Property Name: goodsReceipt
- Reference: YesNo
- Default value: N
Goods Shipment
- Physical column name: SO_Goods_Blocking
- Property Name: goodsShipment
- Reference: YesNo
- Default value: Y
Greeting
- Physical column name: C_Greeting_ID
- Property Name: greeting
- Reference: TableDir
Foreign key column to C_Greeting table, (column: C_Greeting_ID)
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)
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)
Invoice Grouping
- Physical column name: Invoicegrouping
- Property Name: invoiceGrouping
- Reference: List
List values: Scheduled invoice grouping
The allowed values for this list are:
- 000000000000000 (By customer): Totally grouped
- 000010000000000 (By ship location): Break into different invoices if the ship location is different
- 000000000010000 (By project): Break into different invoices if the project is different
Invoice Schedule
- Physical column name: C_InvoiceSchedule_ID
- Property Name: invoiceSchedule
- Reference: TableDir
Foreign key column to C_InvoiceSchedule table, (column: C_InvoiceSchedule_ID)
Invoice Terms
- Physical column name: InvoiceRule
- Property Name: invoiceTerms
- Reference: List
List values: C_Order InvoiceRule
The allowed values for this list are:
- O (After Order Delivered): Invoice for every order
- D (After Delivery): Invoice per Delivery
- S (Customer Schedule After Delivery): Invoice per Customer Invoice Schedule
- I (Immediate): Immediate Invoice
- N (Do Not Invoice): Order should not be invoiced trough Process Invoice
Invoice_Printformat
- Physical column name: Invoice_Printformat
- Property Name: invoicePrintformat
- Reference: List
List values: Print Format Invoice
The allowed values for this list are:
- 2 (Total)
- 1 (Detail)
- 3 (Product detail): Product detail
Is Sales Representative
- Physical column name: IsSalesRep
- Property Name: isSalesRepresentative
- Reference: YesNo
- Default value: N
Isofiscalcode
- Physical column name: Isofiscalcode
- Property Name: isofiscalcode
- Reference: String
Language
- Physical column name: AD_Language
- Property Name: language
- Reference: Table
Foreign key column to AD_Language table, (column: AD_Language)
Lifetime Revenue to Date
- Physical column name: ActualLifeTimeValue
- Property Name: lifetimeRevenueToDate
- Reference: Amount
- Default value: 0
Maturity Date 1
- Physical column name: FixMonthDay
- Property Name: maturityDate1
- Reference: Integer
Maturity Date 2
- Physical column name: FixMonthDay2
- Property Name: maturityDate2
- Reference: Integer
Maturity Date 3
- Physical column name: Fixmonthday3
- Property Name: maturityDate3
- Reference: Integer
NAICS/SIC
- Physical column name: NAICS
- Property Name: nAICSSIC
- Reference: String
Name
- 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
No. of Employees
- Physical column name: NumberEmployees
- Property Name: noOfEmployees
- Reference: Integer
Number of Copies
- Physical column name: DocumentCopies
- Property Name: numberOfCopies
- Reference: Integer
One Time Transaction
- Physical column name: IsOneTime
- Property Name: oneTimeTransaction
- Reference: YesNo
- Default value: N
Operator
- Physical column name: Isworker
- Property Name: operator
- Reference: YesNo
- Default value: N
Order Description
- Physical column name: SO_Description
- Property Name: orderDescription
- Reference: String
Order Reference
- Physical column name: POReference
- Property Name: orderReference
- Reference: String
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
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.
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)
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@)
PO Form of Payment
- Physical column name: PaymentRulePO
- Property Name: pOFormOfPayment
- Reference: List
List values: All_Payment Rule
The allowed values for this list are:
- B (Cash): Cash payments that generate an automatic accounting line.
- K (Credit Card)
- T (Transfer (ACH))
- P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
- 1 (Wire Transfer): Wire Transfer
- 2 (Check): Check
- 3 (Promissory Note): Promissory Note
- C (Cash on Delivery): Cash on Delivery
- 4 (Money Order)
- 5 (Bank Deposit)
- R (Bank Remittance)
- W (Withholding)
PO Maturity Date 1
- Physical column name: PO_Fixmonthday
- Property Name: pOMaturityDate1
- Reference: Integer
PO Maturity Date 2
- Physical column name: PO_Fixmonthday2
- Property Name: pOMaturityDate2
- Reference: Integer
PO Maturity Date 3
- Physical column name: PO_Fixmonthday3
- Property Name: pOMaturityDate3
- Reference: Integer
PO Payment Terms
- Physical column name: PO_PaymentTerm_ID
- Property Name: pOPaymentTerms
- Reference: Table
Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)
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)
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.
Partner Parent
- Physical column name: BPartner_Parent_ID
- Property Name: partnerParent
- Reference: ID
Payment In
- Physical column name: SO_Payment_Blocking
- Property Name: paymentIn
- Reference: YesNo
- Default value: N
Payment Method
- Physical column name: FIN_Paymentmethod_ID
- Property Name: paymentMethod
- Reference: Table
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.
Payment Out
- Physical column name: PO_Payment_Blocking
- Property Name: paymentOut
- Reference: YesNo
- Default value: Y
Payment Terms
- Physical column name: C_PaymentTerm_ID
- Property Name: paymentTerms
- Reference: TableDir
Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)
Potential Customer
- Physical column name: IsProspect
- Property Name: potentialCustomer
- Reference: YesNo
- Default value: Y
Price List
- Physical column name: M_PriceList_ID
- Property Name: priceList
- Reference: Table
Foreign key column to M_PriceList table, (column: M_PriceList_ID)
Prices Shown in Order
- Physical column name: ShowPriceInOrder
- Property Name: pricesShownInOrder
- Reference: YesNo
- Default value: Y
Print Discount
- Physical column name: IsDiscountPrinted
- Property Name: printDiscount
- Reference: YesNo
- Default value: Y
Purchase Invoice
- Physical column name: PO_Invoice_Blocking
- Property Name: purchaseInvoice
- Reference: YesNo
- Default value: Y
Purchase Order
- Physical column name: PO_Order_Blocking
- Property Name: purchaseOrder
- Reference: YesNo
- Default value: Y
Purchase Pricelist
- Physical column name: PO_PriceList_ID
- Property Name: purchasePricelist
- Reference: Table
Foreign key column to M_PriceList table, (column: M_PriceList_ID)
Reference No.
- Physical column name: ReferenceNo
- Property Name: referenceNo
- Reference: String
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)
Salary Category
- 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)
Sales Invoice
- Physical column name: SO_Invoice_Blocking
- Property Name: salesInvoice
- Reference: YesNo
- Default value: Y
Sales Order
- Physical column name: SO_Order_Blocking
- Property Name: salesOrder
- Reference: YesNo
- Default value: Y
Sales Representative
- Physical column name: SalesRep_ID
- Property Name: salesRepresentative
- Reference: Table
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Search Key
- Physical column name: Value
- Property Name: searchKey
- Reference: String
Set New Currency
- Physical column name: Update_Currency
- Property Name: setNewCurrency
- Reference: Button
- Default value: N
- Physical column name: ShareOfCustomer
- Property Name: share
- Reference: Integer
Summary Level
- Physical column name: IsSummary
- Property Name: summaryLevel
- Reference: YesNo
- Default value: N
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)
Tax Exempt
- Physical column name: IsTaxExempt
- Property Name: taxExempt
- Reference: YesNo
- Default value: N
Tax ID
- Physical column name: TaxID
- Property Name: taxID
- Reference: String
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)
UPC/EAN
- Physical column name: UPC
- Property Name: uPCEAN
- Reference: String
URL
- Physical column name: URL
- Property Name: uRL
- Reference: Link
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Valuation
- Physical column name: Rating
- Property Name: valuation
- Reference: String
Vendor
- Physical column name: IsVendor
- Property Name: vendor
- Reference: YesNo
- Default value: N
Vendor Blocking
- Physical column name: Vendor_Blocking
- Property Name: vendorBlocking
- Reference: YesNo
- Default value: N
Volume of Sales
- Physical column name: SalesVolume
- Property Name: volumeOfSales
- Reference: Amount
isCustomerConsent
- Physical column name: Is_Customer_Consent
- Property Name: isCustomerConsent
- Reference: YesNo
- Default value: N
isCustomerConsentPapFormat
- Physical column name: Is_Customer_Consent_PapFormat
- Property Name: isCustomerConsentPapFormat
- Reference: YesNo
- Default value: N
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- C_BPARTNER_NAME_ID Not Unique. Columns:
- NAME
- C_BPARTNER_ID
- C_BPARTNER_NAME_TRGM Not Unique. Columns:
- functionBasedColumn
- C_BPARTNER_REFNO_ID Not Unique. Columns:
- REFERENCENO
- C_BPARTNER_ID
- C_BPARTNER_SALESREP_ID Not Unique. Columns:
- ISSALESREP
- C_BPARTNER_ID
- C_BPARTNER_VALUE_ID Not Unique. Columns:
- VALUE
- C_BPARTNER_ID
- C_BPARTNER_VALUE_TRGM Not Unique. Columns:
- functionBasedColumn
Check Constraints
These are the check constraints for this table:
- C_BPARTNER_CBLOCKING_CHK: CUSTOMER_BLOCKING IN ('Y', 'N')
- C_BPARTNER_CONSENT_CHK: IS_CUSTOMER_CONSENT IN ('Y', 'N')
- C_BPARTNER_CUSBLOCKING_CHK: CUSTOMER_BLOCKING = 'N' OR SO_ORDER_BLOCKING = 'Y' OR SO_GOODS_BLOCKING = 'Y' OR SO_INVOICE_BLOCKING = 'Y' OR SO_PAYMENT_BLOCKING = 'Y'
- C_BPARTNER_INVOICERULE_CHK: INVOICERULE <> 'S' OR C_INVOICESCHEDULE_ID IS NOT NULL
- C_BPARTNER_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- C_BPARTNER_ISCASHVAT_CH: ISCASHVAT IN ('Y', 'N')
- C_BPARTNER_ISCONSENTPAPER_CHK: IS_CUSTOMER_CONSENT_PAPFORMAT 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_PGBLOCKING_CHK: PO_GOODS_BLOCKING IN ('Y', 'N')
- C_BPARTNER_PIBLOCKING_CHK: PO_INVOICE_BLOCKING IN ('Y', 'N')
- C_BPARTNER_POBLOCKING_CHK: PO_ORDER_BLOCKING IN ('Y', 'N')
- C_BPARTNER_PPBLOCKING_CHK: PO_PAYMENT_BLOCKING IN ('Y', 'N')
- C_BPARTNER_SGBLOCKING_CHK: SO_GOODS_BLOCKING IN ('Y', 'N')
- C_BPARTNER_SHOWPRICEINORDE_CHK: SHOWPRICEINORDER IN ('Y', 'N')
- C_BPARTNER_SIBLOCKING_CHK: SO_INVOICE_BLOCKING IN ('Y', 'N')
- C_BPARTNER_SOBLOCKING_CHK: SO_ORDER_BLOCKING IN ('Y', 'N')
- C_BPARTNER_SPBLOCKING_CHK: SO_PAYMENT_BLOCKING IN ('Y', 'N')
- C_BPARTNER_VBLOCKING_CHK: VENDOR_BLOCKING IN ('Y', 'N')
- C_BPARTNER_VENBLOCKING_CHK: VENDOR_BLOCKING = 'N' OR PO_ORDER_BLOCKING = 'Y' OR PO_GOODS_BLOCKING = 'Y' OR PO_INVOICE_BLOCKING = 'Y' OR PO_PAYMENT_BLOCKING = 'Y'