ManPageW BusinessPartner
Contents
Business Partner
Type: Window - Window ID= 123
Help: The Business Partner window allows you do define any party with whom you transact. This includes customers, vendors and employees. Prior to entering or importing products, you must define your vendors. Prior to generating Orders you must define your customers. This window holds all information about your business partner and the values entered will be used to generate all document transactions
Business Partner
Type: Tab - Tab ID= 220
Help: The Business Partner Tab defines any Entity with whom an organization transacts.
Technical Data Table Name : C_BPartner
- Client
Type: Field - Field ID= 2123
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2125
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Search Key
Type: Field - Field ID= 2156
Help: A search key allows you a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
Technical Data Column Name : Value DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Employee
Type: Field - Field ID= 9627
Help: The Employee checkbox indicates if this Business Partner is an Employee. If it is selected, additional fields will display which further identify this employee.
Technical Data Column Name : IsEmployee DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Greeting
Type: Field - Field ID= 3261
Help: The Greeting identifies the greeting to print on correspondence.
Technical Data Column Name : C_Greeting_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Name
Type: Field - Field ID= 2145
Help: 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.
Technical Data Column Name : Name DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Name 2
Type: Field - Field ID= 3228
Help:
Technical Data Column Name : Name2 DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Description
Type: Field - Field ID= 2133
Help: A description is limited to 255 characters.
Technical Data Column Name : Description DB Type : NVARCHAR2(255) Adempiere Type: String = 10
- Active
Type: Field - Field ID= 2136
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Summary Level
Type: Field - Field ID= 2141
Help: 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.
Technical Data Column Name : IsSummary DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Credit Status
Type: Field - Field ID= 8238
Help: Credit Management is inactive if Credit Status is No Credit Check, Credit Stop or if the Credit Limit is 0. If active, the status is set automatically set to Credit Hold, if the Total Open Balance (including Vendor activities) is higher then the Credit Limit. It is set to Credit Watch, if above 90% of the Credit Limit and Credit OK otherwise.
Technical Data Column Name : SOCreditStatus DB Type : CHAR(1) Adempiere Type: List = 17
- Open Balance
Type: Field - Field ID= 10592
Help: The Total Open Balance Amount is the calculated open item amount for Customer and Vendor activity. If the Balance is below zero, we owe the Business Partner. The amout is used for Credit Management. Invoices and Payment Allocations determine the Open Balance (i.e. not Orders or Payments).
Technical Data Column Name : TotalOpenBalance DB Type : NUMBER Adempiere Type: Amount = 12
- Tax ID
Type: Field - Field ID= 2155
Help: The Tax ID field identifies the legal Identification number of this Entity.
Technical Data Column Name : TaxID DB Type : VARCHAR2 Adempiere Type: String = 10
- Tax exempt
Type: Field - Field ID= 2160
Help: 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.
Technical Data Column Name : IsTaxExempt DB Type : CHAR(1) Adempiere Type: YesNo = 20
- D-U-N-S
Type: Field - Field ID= 2132
Help: Used for EDI - For details see www.dnb.com/dunsno/list.htm
Technical Data Column Name : DUNS DB Type : CHAR(11) Adempiere Type: String = 10
- Reference No
Type: Field - Field ID= 2149
Help: The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.
Technical Data Column Name : ReferenceNo DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- NAICS/SIC
Type: Field - Field ID= 2144
Help: The NAICS/SIC identifies either of these codes that may be applicable to this Business Partner.
Technical Data Column Name : NAICS DB Type : CHAR(6) Adempiere Type: String = 10
- Rating
Type: Field - Field ID= 2162
Help: The Rating is used to differentiate the importance
Technical Data Column Name : Rating DB Type : CHAR(1) Adempiere Type: String = 10
- Business Partner Group
Type: Field - Field ID= 3955
Help: The Business Partner Group provides a method of defining defaults to be used for individual Business Partners.
Technical Data Column Name : C_BP_Group_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Language
Type: Field - Field ID= 2124
Help: The Language identifies the language to use for display and formatting documents. It requires, that on Client level, Multi-Lingual documents are selected and that you have created/loaded the language.
Technical Data Column Name : AD_Language DB Type : VARCHAR2 Adempiere Type: Table = 18
- URL
Type: Field - Field ID= 2164
Help: The URL defines an fully qualified web address like http://www.compiere.org
Technical Data Column Name : URL DB Type : NVARCHAR2(120) Adempiere Type: String = 10
- Prospect
Type: Field - Field ID= 2139
Help: The Prospect checkbox indicates an entity that is an active prospect.
Technical Data Column Name : IsProspect DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Link Organization
Type: Field - Field ID= 9620
Help: If the Business Partner is another Organization, select the Organization or set to empty to create a new Organization. You link a Business Partner to an Organization to create explicit Documents for Inter-Org transaction. If you create a new Organization, you may supply a Organization Type. If you select a Role, the access to the new Organization is limited to that role, otherwise all (non manual) roles of the Client will have access to the new Organization.
Technical Data Column Name : AD_OrgBP_ID DB Type : NUMBER(10) Adempiere Type: Button = 28
- Potential Life Time Value
Type: Field - Field ID= 2148
Help: The Potential Life Time Value is the anticipated revenue in primary accounting currency to be generated by the Business Partner.
Technical Data Column Name : PotentialLifeTimeValue DB Type : NUMBER Adempiere Type: Amount = 12
- Actual Life Time Value
Type: Field - Field ID= 2128
Help: The Actual Life Time Value is the recorded revenue in primary accounting currency generated by the Business Partner.
Technical Data Column Name : ActualLifeTimeValue DB Type : NUMBER Adempiere Type: Amount = 12
- Acquisition Cost
Type: Field - Field ID= 2127
Help: The Acquisition Cost identifies the cost associated with making this prospect a customer.
Technical Data Column Name : AcqusitionCost DB Type : NUMBER Adempiere Type: Unknown (37)
- Employees
Type: Field - Field ID= 2146
Help: Indicates the number of employees for this Business Partner. This field displays only for Prospects.
Technical Data Column Name : NumberEmployees DB Type : NUMBER(10) Adempiere Type: Integer = 11
- Share
Type: Field - Field ID= 2154
Help: The Share indicates the percentage of this Business Partner's volume of the products supplied.
Technical Data Column Name : ShareOfCustomer DB Type : NUMBER(10) Adempiere Type: Integer = 11
- Sales Volume in 1.000
Type: Field - Field ID= 2153
Help: The Sales Volume indicates the total volume of sales for a Business Partner.
Technical Data Column Name : SalesVolume DB Type : NUMBER(10) Adempiere Type: Integer = 11
- First Sale
Type: Field - Field ID= 2135
Help: The First Sale Date identifies the date of the first sale to this Business Partner
Technical Data Column Name : FirstSale DB Type : DATE Adempiere Type: Date = 15
Customer
Type: Tab - Tab ID= 223
Help: The Customer Tab defines a Business Partner who is a customer of this organization. If the Customer check box is selected then the necessary fields will display.
Technical Data Table Name : C_BPartner
- Client
Type: Field - Field ID= 2400
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2402
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Search Key
Type: Field - Field ID= 2433
Help: A search key allows you a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
Technical Data Column Name : Value DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Name
Type: Field - Field ID= 2422
Help: 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.
Technical Data Column Name : Name DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Active
Type: Field - Field ID= 7621
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Customer
Type: Field - Field ID= 2568
Help: The Customer checkbox indicates if this Business Partner is a customer. If it is select additional fields will display which further define this customer.
Technical Data Column Name : IsCustomer DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Document Copies
Type: Field - Field ID= 2435
Help: The Document Copies indicates the number of copies of each document that will be generated.
Technical Data Column Name : DocumentCopies DB Type : NUMBER(10) Adempiere Type: Integer = 11
- Invoice Rule
Type: Field - Field ID= 3522
Help: The Invoice Rule defines how a Business Partner is invoiced and the frequency of invoicing.
Technical Data Column Name : InvoiceRule DB Type : CHAR(1) Adempiere Type: List = 17
- Invoice Schedule
Type: Field - Field ID= 2429
Help: The Invoice Schedule identifies the frequency used when generating invoices.
Technical Data Column Name : C_InvoiceSchedule_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Delivery Rule
Type: Field - Field ID= 3523
Help: 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.
Technical Data Column Name : DeliveryRule DB Type : CHAR(1) Adempiere Type: List = 17
- Delivery Via
Type: Field - Field ID= 3526
Help: The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.
Technical Data Column Name : DeliveryViaRule DB Type : CHAR(1) Adempiere Type: List = 17
- Price List
Type: Field - Field ID= 2420
Help: Price Lists are used to determine the pricing, margin and cost of items purchased or sold.
Technical Data Column Name : M_PriceList_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Discount Schema
Type: Field - Field ID= 5282
Help: After calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price.
Technical Data Column Name : M_DiscountSchema_ID DB Type : NUMBER(10) Adempiere Type: Table = 18
- Flat Discount %
Type: Field - Field ID= 10471
Help:
Technical Data Column Name : FlatDiscount DB Type : NUMBER Adempiere Type: Number = 22
- Payment Rule
Type: Field - Field ID= 3114
Help: The Payment Rule indicates the method of invoice payment.
Technical Data Column Name : PaymentRule DB Type : CHAR(1) Adempiere Type: List = 17
- Payment Term
Type: Field - Field ID= 2408
Help: Payment Terms identify the method and timing of payment.
Technical Data Column Name : C_PaymentTerm_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Sales Representative
Type: Field - Field ID= 3524
Help: The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user.
Technical Data Column Name : SalesRep_ID DB Type : NUMBER(10) Adempiere Type: Table = 18
- Dunning
Type: Field - Field ID= 2434
Help: The Dunning indicates the rules and method of dunning for past due payments.
Technical Data Column Name : C_Dunning_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Order Reference
Type: Field - Field ID= 3229
Help: The business partner order reference is the order reference for this specific transaction; Often Purchase Order numbers are given to print on Invoices for easier reference. A standard number can be defined in the Business Partner (Customer) window.
Technical Data Column Name : POReference DB Type : NVARCHAR2(20) Adempiere Type: String = 10
- Discount Printed
Type: Field - Field ID= 3276
Help: The Discount Printed Checkbox indicates if the discount will be printed on the document.
Technical Data Column Name : IsDiscountPrinted DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Order Description
Type: Field - Field ID= 3275
Help: The Order Description identifies the standard description to use on orders for this Customer.
Technical Data Column Name : SO_Description DB Type : NVARCHAR2(255) Adempiere Type: String = 10
- Invoice Print Format
Type: Field - Field ID= 7362
Help: You need to define a Print Format to print the document.
Technical Data Column Name : Invoice_PrintFormat_ID DB Type : NUMBER(10) Adempiere Type: Table = 18
- Min Shelf Life %
Type: Field - Field ID= 8373
Help: Miminum Shelf Life of products with Guarantee Date instance. If > 0 you cannot select products with a shelf life ((Guarantee Date-Today) / Guarantee Days) less than the minum shelf life, unless you select "Show All"
Technical Data Column Name : ShelfLifeMinPct DB Type : NUMBER(10) Adempiere Type: Integer = 11
- Credit Limit
Type: Field - Field ID= 2427
Help: The Credit Limit indicates the total amount allowed 'on account' in primary accounting currency. If the Credit Limit is 0, no ckeck is performed. Credit Management is based on the Total Open Amount, which includes Vendor activities.
Technical Data Column Name : SO_CreditLimit DB Type : NUMBER Adempiere Type: Amount = 12
- Credit Used
Type: Field - Field ID= 2428
Help: The Credit Used indicates the total amount of open or unpaid invoices in primary accounting currency for the Business Partner. Credit Management is based on the Total Open Amount, which includes Vendor activities.
Technical Data Column Name : SO_CreditUsed DB Type : NUMBER Adempiere Type: Amount = 12
Customer Accounting
Type: Tab - Tab ID= 212
Help: The Customer Accounting Tab defines the default accounts to use when this business partner is referenced on an accounts receivable transaction.
Technical Data Table Name : C_BP_Customer_Acct
- Client
Type: Field - Field ID= 1478
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2073
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Business Partner
Type: Field - Field ID= 1595
Help: A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson
Technical Data Column Name : C_BPartner_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Accounting Schema
Type: Field - Field ID= 1477
Help: An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar
Technical Data Column Name : C_AcctSchema_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Active
Type: Field - Field ID= 1479
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Customer Receivables
Type: Field - Field ID= 2610
Help: The Customer Receivables Accounts indicates the account to be used for recording transaction for customers receivables.
Technical Data Column Name : C_Receivable_Acct DB Type : NUMBER(10) Adempiere Type: Account = 25
- Receivable Services
Type: Field - Field ID= 12354
Help: Account to post services related Accounts Receivables if you want to differentiate between Services and Product related revenue. This account is only used, if posting to service accounts is enabled in the accounting schema.
Technical Data Column Name : C_Receivable_Services_Acct DB Type : NUMBER(10) Adempiere Type: Account = 25
- Customer Prepayment
Type: Field - Field ID= 2609
Help: The Customer Prepayment account indicates the account to be used for recording prepayments from a customer.
Technical Data Column Name : C_Prepayment_Acct DB Type : NUMBER(10) Adempiere Type: Account = 25
Vendor
Type: Tab - Tab ID= 224
Help: The Vendor Tab defines a Business Partner that is a Vendor for this Organization. If the Vendor check box is selected the necessary fields will display.
Technical Data Table Name : C_BPartner
- Client
Type: Field - Field ID= 2442
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2444
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Search Key
Type: Field - Field ID= 2475
Help: A search key allows you a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
Technical Data Column Name : Value DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Name
Type: Field - Field ID= 2464
Help: 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.
Technical Data Column Name : Name DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Active
Type: Field - Field ID= 7622
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Vendor
Type: Field - Field ID= 2567
Help: The Vendor checkbox indicates if this Business Partner is a Vendor. If it is selected, additional fields will display which further identify this vendor.
Technical Data Column Name : IsVendor DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Sales Representative
Type: Field - Field ID= 8344
Help: The Sales Rep checkbox indicates if this business partner is a sales representative. A sales representative may also be an emplyee, but does not need to be.
Technical Data Column Name : IsSalesRep DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Payment Rule
Type: Field - Field ID= 2480
Help: The Payment Rule indicates the method of purchase payment.
Technical Data Column Name : PaymentRulePO DB Type : CHAR(1) Adempiere Type: List = 17
- PO Payment Term
Type: Field - Field ID= 4622
Help: The PO Payment Term indicates the payment term that will be used when this purchase order becomes an invoice.
Technical Data Column Name : PO_PaymentTerm_ID DB Type : NUMBER(10) Adempiere Type: Table = 18
- Purchase Pricelist
Type: Field - Field ID= 2466
Help: Identifies the price list used by a Vendor for products purchased by this organization.
Technical Data Column Name : PO_PriceList_ID DB Type : NUMBER(10) Adempiere Type: Table = 18
- PO Discount Schema
Type: Field - Field ID= 5283
Help:
Technical Data Column Name : PO_DiscountSchema_ID DB Type : NUMBER(10) Adempiere Type: Table = 18
Vendor Accounting
Type: Tab - Tab ID= 213
Help: The Vendor Accounting Tab defines the default accounts to use when this business partner is referenced in an accounts payable transaction.
Technical Data Table Name : C_BP_Vendor_Acct
- Client
Type: Field - Field ID= 1485
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2065
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Business Partner
Type: Field - Field ID= 1596
Help: A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson
Technical Data Column Name : C_BPartner_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Accounting Schema
Type: Field - Field ID= 1484
Help: An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar
Technical Data Column Name : C_AcctSchema_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Active
Type: Field - Field ID= 1486
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Vendor Liability
Type: Field - Field ID= 2601
Help: The Vendor Liability account indicates the account used for recording transactions for vendor liabilities
Technical Data Column Name : V_Liability_Acct DB Type : NUMBER(10) Adempiere Type: Account = 25
- Vendor Service Liability
Type: Field - Field ID= 2602
Help: The Vendor Service Liability account indicates the account to use for recording service liabilities. It is used if you need to distinguish between Liability for products and services. This account is only used, if posting to service accounts is enabled in the accounting schema.
Technical Data Column Name : V_Liability_Services_Acct DB Type : NUMBER(10) Adempiere Type: Account = 25
- Vendor Prepayment
Type: Field - Field ID= 2603
Help: The Vendor Prepayment Account indicates the account used to record prepayments from a vendor.
Technical Data Column Name : V_Prepayment_Acct DB Type : NUMBER(10) Adempiere Type: Account = 25
Employee
Type: Tab - Tab ID= 225
Help: The Employee Tab 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.
Technical Data Table Name : C_BPartner
- Client
Type: Field - Field ID= 2484
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2486
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Search Key
Type: Field - Field ID= 2517
Help: A search key allows you a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).
Technical Data Column Name : Value DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Name
Type: Field - Field ID= 2506
Help: 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.
Technical Data Column Name : Name DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Active
Type: Field - Field ID= 7623
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Employee
Type: Field - Field ID= 2499
Help: The Employee checkbox indicates if this Business Partner is an Employee. If it is selected, additional fields will display which further identify this employee.
Technical Data Column Name : IsEmployee DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Sales Representative
Type: Field - Field ID= 2501
Help: The Sales Rep checkbox indicates if this business partner is a sales representative. A sales representative may also be an emplyee, but does not need to be.
Technical Data Column Name : IsSalesRep DB Type : CHAR(1) Adempiere Type: YesNo = 20
Employee Accounting
Type: Tab - Tab ID= 214
Help: The Employee Accounting Tab defines the default accounts to use when this business partner is referenced on a expense reimbursement.
Technical Data Table Name : C_BP_Employee_Acct
- Client
Type: Field - Field ID= 1494
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2074
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Business Partner
Type: Field - Field ID= 1597
Help: A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson
Technical Data Column Name : C_BPartner_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Accounting Schema
Type: Field - Field ID= 1492
Help: An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar
Technical Data Column Name : C_AcctSchema_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Active
Type: Field - Field ID= 1495
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Employee Expense
Type: Field - Field ID= 2611
Help: The Employee Expense Account identifies the account to use for recording expenses for this employee.
Technical Data Column Name : E_Expense_Acct DB Type : NUMBER(10) Adempiere Type: Account = 25
- Employee Prepayment
Type: Field - Field ID= 2612
Help: The Employee Prepayment Account identifies the account to use for recording expense advances made to this employee.
Technical Data Column Name : E_Prepayment_Acct DB Type : NUMBER(10) Adempiere Type: Account = 25
Bank Account
Type: Tab - Tab ID= 226
Help: The Define Bank Account Tab defines the banking information for this business partner. This data is used for processing payments and remittances.
Technical Data Table Name : C_BP_BankAccount
- Client
Type: Field - Field ID= 2198
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2199
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Business Partner
Type: Field - Field ID= 2202
Help: A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson
Technical Data Column Name : C_BPartner_ID DB Type : NUMBER(10) Adempiere Type: Search = 30
- User/Contact
Type: Field - Field ID= 4105
Help: The User identifies a unique user in the system. This could be an internal user or a business partner contact
Technical Data Column Name : AD_User_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Active
Type: Field - Field ID= 2203
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- ACH
Type: Field - Field ID= 4111
Help: The ACH checkbox indicates if this Bank Account accepts ACH transactions.
Technical Data Column Name : IsACH DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Bank Account Type
Type: Field - Field ID= 4104
Help: The Bank Account Type field indicates the type of account (savings, checking etc) this account is defined as.
Technical Data Column Name : BankAccountType DB Type : CHAR(1) Adempiere Type: List = 17
- Routing No
Type: Field - Field ID= 2204
Help: The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions.
Technical Data Column Name : RoutingNo DB Type : NVARCHAR2(20) Adempiere Type: String = 10
- Bank
Type: Field - Field ID= 2200
Help: The Bank is a unique identifier of a Bank for this Organization or for a Business Partner with whom this Organization transacts.
Technical Data Column Name : C_Bank_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Account No
Type: Field - Field ID= 2197
Help: The Account Number indicates the Number assigned to this bank account.
Technical Data Column Name : AccountNo DB Type : NVARCHAR2(20) Adempiere Type: String = 10
- Credit Card
Type: Field - Field ID= 4109
Help: The Credit Card drop down list box is used for selecting the type of Credit Card presented for payment.
Technical Data Column Name : CreditCardType DB Type : CHAR(1) Adempiere Type: List = 17
- Number
Type: Field - Field ID= 4108
Help: The Credit Card number indicates the number on the credit card, without blanks or spaces.
Technical Data Column Name : CreditCardNumber DB Type : NVARCHAR2(20) Adempiere Type: String = 10
- Verification Code
Type: Field - Field ID= 4110
Help: The Credit Card Verification indicates the verification code on the credit card (AMEX 4 digits on front; MC,Visa 3 digits back)
Technical Data Column Name : CreditCardVV DB Type : VARCHAR2 Adempiere Type: String = 10
- Exp. Month
Type: Field - Field ID= 4106
Help: The Expiry Month indicates the expiry month for this credit card.
Technical Data Column Name : CreditCardExpMM DB Type : NUMBER(10) Adempiere Type: Integer = 11
- Exp. Year
Type: Field - Field ID= 4107
Help: The Expiry Year indicates the expiry year for this credit card.
Technical Data Column Name : CreditCardExpYY DB Type : NUMBER(10) Adempiere Type: Integer = 11
- Account Name
Type: Field - Field ID= 4100
Help: The Name of the Credit Card or Account holder.
Technical Data Column Name : A_Name DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Account Street
Type: Field - Field ID= 4102
Help: The Street Address of the Credit Card or Account holder.
Technical Data Column Name : A_Street DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Account City
Type: Field - Field ID= 4096
Help: The Account City indicates the City of the Credit Card or Account holder
Technical Data Column Name : A_City DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Account Zip/Postal
Type: Field - Field ID= 4103
Help: The Zip Code of the Credit Card or Account Holder.
Technical Data Column Name : A_Zip DB Type : NVARCHAR2(20) Adempiere Type: String = 10
- Account State
Type: Field - Field ID= 4101
Help: The State of the Credit Card or Account holder
Technical Data Column Name : A_State DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Account Country
Type: Field - Field ID= 6298
Help: Account Country Name
Technical Data Column Name : A_Country DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Driver License
Type: Field - Field ID= 4098
Help: The Driver's License being used as identification.
Technical Data Column Name : A_Ident_DL DB Type : NVARCHAR2(20) Adempiere Type: String = 10
- Social Security No
Type: Field - Field ID= 4099
Help: The Social Security number being used as identification.
Technical Data Column Name : A_Ident_SSN DB Type : NVARCHAR2(20) Adempiere Type: String = 10
- Account EMail
Type: Field - Field ID= 4097
Help: The EMail Address indicates the EMail address off the Credit Card or Account holder.
Technical Data Column Name : A_EMail DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Address verified
Type: Field - Field ID= 4112
Help: The Address Verified indicates if the address has been verified by the Credit Card Company.
Technical Data Column Name : R_AvsAddr DB Type : CHAR(1) Adempiere Type: List = 17
- Zip verified
Type: Field - Field ID= 4113
Help: The Zip Verified indicates if the zip code has been verified by the Credit Card Company.
Technical Data Column Name : R_AvsZip DB Type : CHAR(1) Adempiere Type: List = 17
Location
Type: Tab - Tab ID= 222
Help: The Location Tab defines the physical location of a business partner. A business partner may have multiple location records.
Technical Data Table Name : C_BPartner_Location
- Client
Type: Field - Field ID= 2181
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2182
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Business Partner
Type: Field - Field ID= 2183
Help: A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson
Technical Data Column Name : C_BPartner_ID DB Type : NUMBER(10) Adempiere Type: Search = 30
- Name
Type: Field - Field ID= 2190
Help: 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.
Technical Data Column Name : Name DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Active
Type: Field - Field ID= 2189
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Address
Type: Field - Field ID= 2185
Help: The Location / Address field defines the location of an entity.
Technical Data Column Name : C_Location_ID DB Type : NUMBER(10) Adempiere Type: Location = 21
- Phone
Type: Field - Field ID= 2191
Help: The Phone field identifies a telephone number
Technical Data Column Name : Phone DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- 2nd Phone
Type: Field - Field ID= 2192
Help: The 2nd Phone field identifies an alternate telephone number.
Technical Data Column Name : Phone2 DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Fax
Type: Field - Field ID= 2187
Help: The Fax identifies a facsimile number for this Business Partner or Location
Technical Data Column Name : Fax DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- ISDN
Type: Field - Field ID= 2188
Help: The ISDN identifies a ISDN or Modem line number.
Technical Data Column Name : ISDN DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Ship Address
Type: Field - Field ID= 2196
Help: If the Ship Address is selected, the location is used to ship goods to a customer or receive goods from a vendor.
Technical Data Column Name : IsShipTo DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Invoice Address
Type: Field - Field ID= 2193
Help: If the Invoice Address is selected, the location is used to send invoices to a customer or receive invoices from a vendor.
Technical Data Column Name : IsBillTo DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Pay-From Address
Type: Field - Field ID= 2194
Help: If the Pay-From Address is selected, this location is the address the Business Partner pays from and where dunning letters will be sent to.
Technical Data Column Name : IsPayFrom DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Remit-To Address
Type: Field - Field ID= 2195
Help: If the Remit-To Address is selected, the location is used to send payments to the vendor.
Technical Data Column Name : IsRemitTo DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Sales Region
Type: Field - Field ID= 2186
Help: The Sales Region indicates a specific area of sales coverage.
Technical Data Column Name : C_SalesRegion_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
Contact (User)
Type: Tab - Tab ID= 496
Help: The User identifies a unique user in the system. This could be an internal user or a business partner contact
Technical Data Table Name : AD_User
- Client
Type: Field - Field ID= 7014
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 7016
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Business Partner
Type: Field - Field ID= 7005
Help: A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson
Technical Data Column Name : C_BPartner_ID DB Type : NUMBER(10) Adempiere Type: Search = 30
- Name
Type: Field - Field ID= 7010
Help: 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.
Technical Data Column Name : Name DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Description
Type: Field - Field ID= 7011
Help: A description is limited to 255 characters.
Technical Data Column Name : Description DB Type : NVARCHAR2(255) Adempiere Type: String = 10
- Comments
Type: Field - Field ID= 7029
Help: The Comments field allows for free form entry of additional information.
Technical Data Column Name : Comments DB Type : NVARCHAR2(2000) Adempiere Type: Text = 14
- Active
Type: Field - Field ID= 7012
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- EMail Address
Type: Field - Field ID= 7017
Help: The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). The Email Address is used to access the self service application functionality from the web.
Technical Data Column Name : EMail DB Type : NVARCHAR2(60) Adempiere Type: String = 10
- Password
Type: Field - Field ID= 7013
Help: The Password for this User. Passwords are required to identify authorized users. For Compiere Users, you can change the password via the Process "Reset Password".
Technical Data Column Name : Password DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Greeting
Type: Field - Field ID= 7020
Help: The Greeting identifies the greeting to print on correspondence.
Technical Data Column Name : C_Greeting_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Partner Location
Type: Field - Field ID= 7023
Help: The Partner address indicates the location of a Business Partner
Technical Data Column Name : C_BPartner_Location_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Title
Type: Field - Field ID= 7028
Help: The Title indicates the name that an entity is referred to as.
Technical Data Column Name : Title DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Birthday
Type: Field - Field ID= 7022
Help: Birthday or Anniversary day
Technical Data Column Name : Birthday DB Type : DATE Adempiere Type: Date = 15
- Phone
Type: Field - Field ID= 7024
Help: The Phone field identifies a telephone number
Technical Data Column Name : Phone DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- 2nd Phone
Type: Field - Field ID= 7021
Help: The 2nd Phone field identifies an alternate telephone number.
Technical Data Column Name : Phone2 DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Fax
Type: Field - Field ID= 7025
Help: The Fax identifies a facsimile number for this Business Partner or Location
Technical Data Column Name : Fax DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Notification Type
Type: Field - Field ID= 11681
Help: Emails or Notification sent out for Request Updates, etc.
Technical Data Column Name : NotificationType DB Type : CHAR(1) Adempiere Type: List = 17
- Position
Type: Field - Field ID= 12321
Help:
Technical Data Column Name : C_Job_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Full BP Access
Type: Field - Field ID= 12320
Help: If selected, the user has full access to the Business Partner (BP) information (Business Documents like Orders, Invoices - Requests) or resources (Assets, Downloads). If you deselet it, the user has no access rights unless, you explicitly grant it in tab "BP Access"
Technical Data Column Name : IsFullBPAccess DB Type : CHAR(1) Adempiere Type: YesNo = 20
- EMail Verify
Type: Field - Field ID= 11526
Help:
Technical Data Column Name : EMailVerifyDate DB Type : DATE Adempiere Type: DateTime = 16
- Verification Info
Type: Field - Field ID= 8255
Help: The field contains additional information how the EMail Address has been verified
Technical Data Column Name : EMailVerify DB Type : NVARCHAR2(40) Adempiere Type: String = 10
- Last Contact
Type: Field - Field ID= 7027
Help: The Last Contact indicates the date that this Business Partner Contact was last contacted.
Technical Data Column Name : LastContact DB Type : DATE Adempiere Type: Date = 15
- Last Result
Type: Field - Field ID= 7026
Help: The Last Result identifies the result of the last contact made.
Technical Data Column Name : LastResult DB Type : NVARCHAR2(255) Adempiere Type: String = 10
BP Access
Type: Tab - Tab ID= 756
Help: If on User level, "Full BP Access" is NOT selected, you need to give access explicitly here.
Technical Data Table Name : AD_UserBPAccess
- Client
Type: Field - Field ID= 12235
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 12237
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- User/Contact
Type: Field - Field ID= 12240
Help: The User identifies a unique user in the system. This could be an internal user or a business partner contact
Technical Data Column Name : AD_User_ID DB Type : NUMBER(10) Adempiere Type: Search = 30
- Active
Type: Field - Field ID= 12233
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Access Type
Type: Field - Field ID= 12234
Help: If on User level, "Full BP Access" is NOT selected, give access explicitly
Technical Data Column Name : BPAccessType DB Type : CHAR(1) Adempiere Type: List = 17
- Request Type
Type: Field - Field ID= 12238
Help: Request Types are used for processing and categorizing requests. Options are Account Inquiry, Warranty Issue, etc.
Technical Data Column Name : R_RequestType_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
Interest Area
Type: Tab - Tab ID= 439
Help: Interest Area can be used for Marketing Campaigns
Technical Data Table Name : R_ContactInterest
- Client
Type: Field - Field ID= 5874
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 5876
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- User/Contact
Type: Field - Field ID= 5875
Help: The User identifies a unique user in the system. This could be an internal user or a business partner contact
Technical Data Column Name : AD_User_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Interest Area
Type: Field - Field ID= 5879
Help: Interest Areas reflect interest in a topic by a contact. Interest areas can be used for marketing campaigns.
Technical Data Column Name : R_InterestArea_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Active
Type: Field - Field ID= 5878
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Subscribe Date
Type: Field - Field ID= 5880
Help: Date the contact subscribe the interest area
Technical Data Column Name : SubscribeDate DB Type : DATE Adempiere Type: Date = 15
- Opt-out Date
Type: Field - Field ID= 5877
Help: If the field has a date, the customer opted out (unsubscribed) and cannot receive mails for the Interest Area
Technical Data Column Name : OptOutDate DB Type : DATE Adempiere Type: Date = 15
Withholding
Type: Tab - Tab ID= 229
Help: The Withholding Tab defines any withholding information for this business partner.
Technical Data Table Name : C_BP_Withholding
- Client
Type: Field - Field ID= 2223
Help: A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client.
Technical Data Column Name : AD_Client_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Organization
Type: Field - Field ID= 2224
Help: An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
Technical Data Column Name : AD_Org_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Business Partner
Type: Field - Field ID= 2225
Help: A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson
Technical Data Column Name : C_BPartner_ID DB Type : NUMBER(10) Adempiere Type: Search = 30
- Withholding
Type: Field - Field ID= 2226
Help: The Withholding indicates the type of withholding to be calculated.
Technical Data Column Name : C_Withholding_ID DB Type : NUMBER(10) Adempiere Type: TableDir = 19
- Active
Type: Field - Field ID= 2228
Help: 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 reports. There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.
Technical Data Column Name : IsActive DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Mandatory Withholding
Type: Field - Field ID= 2229
Help: The Mandatory Withholding checkbox indicates that monies must be withheld from this employee.
Technical Data Column Name : IsMandatoryWithholding DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Temporary exempt
Type: Field - Field ID= 2230
Help: The Temporary Exempt checkbox indicates that for a limited time, taxes will not be withheld for this employee.
Technical Data Column Name : IsTemporaryExempt DB Type : CHAR(1) Adempiere Type: YesNo = 20
- Exempt reason
Type: Field - Field ID= 2227
Help: The Exempt Reason indicates the reason that monies are not withheld from this employee.
Technical Data Column Name : ExemptReason DB Type : NVARCHAR2(20) Adempiere Type: String = 10