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