SchemaSpy Analysis of idempiere11.adempiere - ColumnsClient & Organization | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:47 +0100 |
| |||||
|
idempiere11.adempiere contains 556 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
ad_table | accesslevel | bpchar | 1 | Access Level required | |||
c_bpartner | acqusitioncost | numeric | 0 | √ | 0 | The cost of gaining the prospect as a customer | |
c_bpartner | actuallifetimevalue | numeric | 0 | √ | 0 | Actual Life Time Revenue | |
ad_client | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_clientinfo | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_clientshare | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_language | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_org | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_org_v | ad_client_id | numeric | 10 | √ | null | ||
ad_orginfo | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_orgtype | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_preference | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_printform | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
ad_registration | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_system | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_table | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_user | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_country | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_pricelist | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_warehouse | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_client | ad_client_uu | varchar | 36 | √ | NULL::character varying | AD_Client_UU | |
ad_clientinfo | ad_clientinfo_uu | varchar | 36 | √ | NULL::character varying | AD_ClientInfo_UU | |
ad_clientshare | ad_clientshare_id | numeric | 10 | Force (not) sharing of tenant/org entities | |||
ad_clientshare | ad_clientshare_uu | varchar | 36 | √ | NULL::character varying | AD_ClientShare_UU | |
ad_preference | ad_form_id | numeric | 10 | √ | NULL::numeric | Special Form | |
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
ad_preference | ad_infowindow_id | numeric | 10 | √ | NULL::numeric | Info and search/select Window | |
ad_client | ad_language | varchar | 6 | √ | null | Language for this entity | |
ad_language | ad_language | varchar | 6 | Language for this entity | |||
c_bpartner | ad_language | varchar | 6 | √ | null | Language for this entity | |
c_country | ad_language | varchar | 6 | √ | null | Language for this entity | |
ad_language | ad_language_id | numeric | 10 | Language ID | |||
ad_language | ad_language_uu | varchar | 36 | √ | NULL::character varying | AD_Language_UU | |
ad_client | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_clientinfo | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_clientshare | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_language | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_org | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_org_v | ad_org_id | numeric | 10 | √ | null | ||
ad_orginfo | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_orgtype | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_preference | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_printform | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_registration | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_system | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_table | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_user | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_country | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_pricelist | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_warehouse | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_org | ad_org_uu | varchar | 36 | √ | NULL::character varying | AD_Org_UU | |
c_bpartner | ad_orgbp_id | numeric | 10 | √ | null | The Business Partner is another Organization for explicit Inter-Org transactions | |
ad_orginfo | ad_orginfo_uu | varchar | 36 | √ | NULL::character varying | AD_OrgInfo_UU | |
ad_user | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
ad_org_v | ad_orgtype_id | numeric | 10 | √ | null | ||
ad_orginfo | ad_orgtype_id | numeric | 10 | √ | null | Organization Type | |
ad_orgtype | ad_orgtype_id | numeric | 10 | Organization Type | |||
ad_orgtype | ad_orgtype_uu | varchar | 36 | √ | NULL::character varying | AD_OrgType_UU | |
ad_client | ad_passwordrule_id | numeric | 10 | √ | NULL::numeric | Password Policies | |
ad_preference | ad_preference_id | numeric | 10 | Personal Value Preference | |||
ad_preference | ad_preference_uu | varchar | 36 | √ | NULL::character varying | AD_Preference_UU | |
ad_orgtype | ad_printcolor_id | numeric | 10 | √ | null | Color used for printing and display | |
ad_printform | ad_printform_id | numeric | 10 | Form | |||
ad_printform | ad_printform_uu | varchar | 36 | √ | NULL::character varying | AD_PrintForm_UU | |
ad_language | ad_printpaper_id | numeric | 10 | √ | NULL::numeric | Printer paper definition | |
ad_preference | ad_process_id | numeric | 10 | √ | NULL::numeric | Process or Report | |
ad_registration | ad_registration_id | numeric | 10 | System Registration | |||
ad_registration | ad_registration_uu | varchar | 36 | √ | NULL::character varying | AD_Registration_UU | |
ad_client | ad_replicationstrategy_id | numeric | 10 | √ | null | Data Replication Strategy | |
ad_org | ad_replicationstrategy_id | numeric | 0 | √ | null | Data Replication Strategy | |
ad_clientinfo | ad_storageprovider_id | numeric | 10 | √ | NULL::numeric | Storage Provider | |
ad_registration | ad_system_id | numeric | 10 | System Definition | |||
ad_system | ad_system_id | numeric | 10 | System Definition | |||
ad_system | ad_system_uu | varchar | 36 | √ | NULL::character varying | AD_System_UU | |
ad_clientshare | ad_table_id | numeric | 10 | Database Table information | |||
ad_table | ad_table_id | numeric | 10 | Database Table information | |||
ad_table | ad_table_uu | varchar | 36 | √ | NULL::character varying | AD_Table_UU | |
ad_clientinfo | ad_tree_activity_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_bpartner_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_campaign_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_menu_id | numeric | 10 | √ | null | Tree of the menu | |
ad_clientinfo | ad_tree_org_id | numeric | 10 | √ | null | Trees are used for (financial) reporting and security access (via role) | |
ad_clientinfo | ad_tree_product_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_project_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_salesregion_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_preference | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
ad_user | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
ad_table | ad_val_rule_id | numeric | 10 | √ | null | Dynamic Validation Rule | |
ad_preference | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
ad_table | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
c_country | allowcitiesoutoflist | bpchar | 1 | √ | 'Y'::bpchar | A flag to allow cities, currently not in the list, to be entered | |
ad_user | answer | varchar | 1024 | √ | NULL::character varying | Answer | |
ad_preference | attribute | varchar | 60 | Attribute | |||
ad_client | authenticationtype | varchar | 10 | 'AAS'::character varying | Authentication Type | ||
ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | Authentication Type | |
ad_client | autoarchive | bpchar | 1 | 'N'::bpchar | Enable and level of automatic Archive of documents | ||
m_pricelist | basepricelist_id | numeric | 10 | √ | null | Pricelist to be used, if product not found on this pricelist | |
ad_user | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
ad_user | bp_location_id | numeric | 10 | √ | NULL::numeric | Address of the Business Partner | |
c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | Business Partner Parent | |
ad_user | bpname | varchar | 60 | √ | NULL::character varying | BP Name | |
ad_clientinfo | c_acctschema1_id | numeric | 10 | √ | null | Primary rules for accounting | |
c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
ad_org_v | c_bpartner_id | numeric | 10 | √ | null | ||
ad_user | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_bpartner | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
ad_user | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_UU | |
ad_clientinfo | c_bpartnercashtrx_id | numeric | 10 | √ | null | Business Partner used for creating new Business Partners on the fly | |
ad_clientinfo | c_calendar_id | numeric | 10 | √ | null | Accounting Calendar Name | |
ad_orginfo | c_calendar_id | numeric | 10 | √ | null | Accounting Calendar Name | |
ad_user | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
ad_clientinfo | c_chargefreight_id | numeric | 10 | √ | NULL::numeric | Charge for Freight | |
c_country | c_country_id | numeric | 10 | Country | |||
c_country | c_country_uu | varchar | 36 | √ | NULL::character varying | C_Country_UU | |
ad_registration | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
c_country | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
m_pricelist | c_currency_id | numeric | 10 | The Currency for this record | |||
c_bpartner | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
ad_user | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
c_bpartner | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | Schedule for generating Invoices | |
ad_user | c_job_id | numeric | 10 | √ | null | Job Position | |
ad_org_v | c_location_id | numeric | 10 | √ | null | ||
ad_orginfo | c_location_id | numeric | 10 | √ | null | Location or Address | |
ad_registration | c_location_id | numeric | 10 | √ | null | Location or Address | |
ad_user | c_location_id | numeric | 10 | √ | NULL::numeric | Location or Address | |
m_warehouse | c_location_id | numeric | 10 | Location or Address | |||
c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
ad_clientinfo | c_uom_length_id | numeric | 10 | √ | null | Standard Unit of Measure for Length | |
ad_clientinfo | c_uom_time_id | numeric | 10 | √ | null | Standard Unit of Measure for Time | |
ad_clientinfo | c_uom_volume_id | numeric | 10 | √ | null | Standard Unit of Measure for Volume | |
ad_clientinfo | c_uom_weight_id | numeric | 10 | √ | null | Standard Unit of Measure for Weight | |
c_country | capturesequence | varchar | 60 | √ | null | Capture Sequence | |
ad_user | comments | varchar | 2000 | √ | null | Comments or additional information | |
ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
ad_table | copycolumnsfromtable | varchar | 1 | √ | null | Copy Columns From Table | |
ad_table | copycomponentsfromview | bpchar | 1 | √ | NULL::bpchar | Copy Components From View | |
ad_language | countrycode | bpchar | 2 | √ | null | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html | |
c_country | countrycode | bpchar | 2 | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html | |||
ad_client | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_clientinfo | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_clientshare | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_language | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_org | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_org_v | created | timestamp | 29,6 | √ | null | ||
ad_orginfo | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_orgtype | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_preference | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_printform | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_registration | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_system | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_table | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_user | created | timestamp | 29,6 | now() | Date this record was created | ||
c_bpartner | created | timestamp | 29,6 | now() | Date this record was created | ||
c_country | created | timestamp | 29,6 | now() | Date this record was created | ||
m_pricelist | created | timestamp | 29,6 | now() | Date this record was created | ||
m_warehouse | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_client | createdby | numeric | 10 | User who created this records | |||
ad_clientinfo | createdby | numeric | 10 | User who created this records | |||
ad_clientshare | createdby | numeric | 10 | User who created this records | |||
ad_language | createdby | numeric | 10 | User who created this records | |||
ad_org | createdby | numeric | 10 | User who created this records | |||
ad_org_v | createdby | numeric | 10 | √ | null | ||
ad_orginfo | createdby | numeric | 10 | User who created this records | |||
ad_orgtype | createdby | numeric | 10 | User who created this records | |||
ad_preference | createdby | numeric | 10 | User who created this records | |||
ad_printform | createdby | numeric | 10 | User who created this records | |||
ad_registration | createdby | numeric | 10 | User who created this records | |||
ad_system | createdby | numeric | 10 | User who created this records | |||
ad_table | createdby | numeric | 10 | User who created this records | |||
ad_user | createdby | numeric | 10 | User who created this records | |||
c_bpartner | createdby | numeric | 10 | User who created this records | |||
c_country | createdby | numeric | 10 | User who created this records | |||
m_pricelist | createdby | numeric | 10 | User who created this records | |||
m_warehouse | createdby | numeric | 10 | User who created this records | |||
ad_table | createpartition | bpchar | 1 | √ | NULL::bpchar | Process which create or update table partitions based on the table and column records | |
ad_table | createwindowfromtable | bpchar | 1 | √ | NULL::bpchar | Create Window From Table | |
c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
ad_system | customprefix | varchar | 60 | √ | null | Prefix for Custom entities | |
ad_table | databaseviewdrop | bpchar | 1 | √ | NULL::bpchar | Drop view | |
ad_user | dateaccountlocked | timestamp | 29,6 | √ | null | Date Account Locked | |
ad_user | datelastlogin | timestamp | 29,6 | √ | null | Date Last Login | |
ad_user | datepasswordchanged | timestamp | 29,6 | √ | null | Date Password Changed | |
ad_language | datepattern | varchar | 20 | √ | null | Java Date Pattern | |
ad_system | dbaddress | varchar | 255 | √ | null | JDBC URL of the database server | |
ad_system | dbinstance | varchar | 60 | √ | null | Database Name | |
c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
ad_client | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_clientshare | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_org | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_org_v | description | varchar | 255 | √ | null | ||
ad_orgtype | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_printform | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_registration | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_system | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_table | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_user | description | varchar | 255 | √ | null | Optional short description of the record | |
c_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
c_country | description | varchar | 255 | √ | null | Optional short description of the record | |
m_pricelist | description | varchar | 255 | √ | null | Optional short description of the record | |
m_warehouse | description | varchar | 255 | √ | null | Optional short description of the record | |
c_country | displaysequence | varchar | 20 | Format for printing this Address | |||
c_country | displaysequencelocal | varchar | 20 | √ | null | Format for printing this Address locally | |
ad_printform | distrib_order_mailtext_id | numeric | 10 | √ | null | Email text used for sending Distribution Order | |
ad_printform | distrib_order_printformat_id | numeric | 10 | √ | null | Print Format for printing Distribution Order | |
c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
ad_client | documentdir | varchar | 60 | √ | null | Directory for documents from the application server | |
ad_orginfo | dropship_warehouse_id | numeric | 10 | √ | null | The (logical) warehouse to use for recording drop ship receipts and shipments. | |
c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
ad_org_v | duns | varchar | 11 | √ | null | ||
ad_orginfo | duns | varchar | 11 | Dun & Bradstreet Number | |||
c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
ad_orginfo | varchar | 60 | √ | NULL::character varying | Electronic Mail Address | ||
ad_user | varchar | 60 | √ | null | Electronic Mail Address | ||
ad_client | emailtest | bpchar | 1 | √ | null | Test EMail | |
ad_user | emailuser | varchar | 60 | √ | null | User Name (ID) in the Mail System | |
ad_user | emailuserpw | varchar | 255 | √ | null | Password of your email user id | |
ad_user | emailverify | varchar | 40 | √ | null | Verification information of EMail Address | |
ad_user | emailverifydate | timestamp | 29,6 | √ | null | Date Email was verified | |
ad_system | encryptionkey | varchar | 255 | √ | null | Encryption Class used for securing data content | |
m_pricelist | enforcepricelimit | bpchar | 1 | 'N'::bpchar | Do not allow prices below the limit price | ||
ad_table | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
c_country | expressionbankaccountno | varchar | 20 | √ | null | Format of the Bank Account | |
c_country | expressionbankroutingno | varchar | 20 | √ | null | Format of the Bank Routing Number | |
c_country | expressionphone | varchar | 20 | √ | null | Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
c_country | expressionpostal | varchar | 20 | √ | null | Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
c_country | expressionpostal_add | varchar | 20 | √ | null | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
ad_user | failedlogincount | numeric | 10 | (0)::numeric | Failed Login Count | ||
ad_orginfo | fax | varchar | 40 | √ | NULL::character varying | Facsimile number | |
ad_user | fax | varchar | 40 | √ | null | Facsimile number | |
c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
ad_clientinfo | fy_startdate | timestamp | 29,6 | √ | null | Financial Year Start Date | |
c_country | haspostal_add | bpchar | 1 | 'N'::bpchar | Has Additional Postal Code | ||
c_country | hasregion | bpchar | 1 | 'N'::bpchar | Country contains Regions | ||
ad_table | help | varchar | 2000 | √ | null | Comment or Hint | |
ad_system | idrangeend | numeric | 0 | √ | null | End if the ID Range used | |
ad_system | idrangestart | numeric | 0 | √ | null | Start of the ID Range used | |
ad_table | importtable | bpchar | 1 | √ | null | Import Table Columns from Database | |
ad_registration | industryinfo | varchar | 255 | √ | null | Information of the industry (e.g. professional service, distribution of furnitures, ..) | |
ad_system | info | varchar | 255 | √ | null | Information | |
ad_printform | invoice_mailtext_id | numeric | 10 | √ | null | Email text used for sending invoices | |
ad_printform | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | 1099 Vendor | ||
ad_client | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_clientinfo | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_clientshare | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_language | isactive | bpchar | 1 | 'N'::bpchar | The record is active in the system | ||
ad_org | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_org_v | isactive | bpchar | 1 | √ | null | ||
ad_orginfo | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_orgtype | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_preference | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_printform | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_registration | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_system | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_table | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_user | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_bpartner | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_country | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_pricelist | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_warehouse | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_user | isaddmailtextautomatically | bpchar | 1 | 'N'::bpchar | The selected mail template will be automatically inserted when creating an email | ||
c_country | isaddresslineslocalreverse | bpchar | 1 | 'N'::bpchar | Print Local Address in reverse Order | ||
c_country | isaddresslinesreverse | bpchar | 1 | 'N'::bpchar | Print Address in reverse Order | ||
ad_registration | isallowpublish | bpchar | 1 | 'Y'::bpchar | You allow to publish the information, not just statistical summary info | ||
ad_registration | isallowstatistics | bpchar | 1 | 'Y'::bpchar | Maintain general statistics | ||
ad_system | isallowstatistics | bpchar | 1 | 'Y'::bpchar | Maintain general statistics | ||
ad_system | isautoerrorreport | bpchar | 1 | 'Y'::bpchar | Automatically report Errors | ||
ad_language | isbaselanguage | bpchar | 1 | 'N'::bpchar | The system information is maintained in this language | ||
ad_user | isbillto | bpchar | 1 | 'N'::bpchar | Business Partner Invoice/Bill Address | ||
ad_table | iscentrallymaintained | bpchar | 1 | √ | 'Y'::bpchar | Information maintained in System Element table | |
ad_table | ischangelog | bpchar | 1 | 'N'::bpchar | Maintain a log of changes | ||
ad_clientinfo | isconfirmondocclose | bpchar | 1 | 'N'::bpchar | Show Confirmation On Document Action Close | ||
ad_clientinfo | isconfirmondocvoid | bpchar | 1 | 'N'::bpchar | Show Confirmation On Document Action Void | ||
ad_client | iscostimmediate | bpchar | 1 | 'N'::bpchar | Update Costs immediately for testing | ||
c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | Indicates if this Business Partner is a Customer | ||
ad_language | isdecimalpoint | bpchar | 1 | √ | null | The number notation has a decimal point (no decimal comma) | |
m_pricelist | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
ad_table | isdeleteable | bpchar | 1 | 'Y'::bpchar | Indicates if records can be deleted from the database | ||
m_warehouse | isdisallownegativeinv | bpchar | 1 | 'N'::bpchar | Negative Inventory is not allowed in this warehouse | ||
ad_clientinfo | isdiscountlineamt | bpchar | 1 | 'Y'::bpchar | Payment Discount calculation does not include Taxes and Charges | ||
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is an employee | ||
ad_user | isexpired | bpchar | 1 | 'N'::bpchar | Expired | ||
ad_system | isfailonbuilddiffer | bpchar | 1 | 'N'::bpchar | Fail if Build Differ | ||
ad_system | isfailonmissingmodelvalidator | bpchar | 1 | 'Y'::bpchar | Fail on Missing Model Validator | ||
ad_user | isfullbpaccess | bpchar | 1 | 'Y'::bpchar | The user/contact has full access to Business Partner information and resources | ||
ad_table | ishighvolume | bpchar | 1 | 'N'::bpchar | Use Search instead of Pick list | ||
ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | Defined if any User Contact will be used for Calculate Payroll | ||
ad_registration | isinproduction | bpchar | 1 | 'N'::bpchar | The system is in production | ||
m_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | Movement is in transit | |
ad_system | isjustmigrated | bpchar | 1 | √ | 'N'::bpchar | Value set by Migration for post-Migration tasks. | |
ad_user | islocked | bpchar | 1 | 'N'::bpchar | Locked | ||
ad_language | isloginlocale | bpchar | 1 | √ | 'N'::bpchar | Login Locale | |
m_pricelist | ismandatory | bpchar | 1 | √ | 'N'::bpchar | Data entry is required in this column | |
c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | Indicate role of this Business partner as Manufacturer | |
ad_user | ismenuautoexpand | bpchar | 1 | √ | null | If ticked, the menu is automatically expanded | |
ad_client | ismultilingualdocument | bpchar | 1 | 'N'::bpchar | Documents are Multi Lingual | ||
ad_user | isnoexpire | bpchar | 1 | 'N'::bpchar | No Expire | ||
ad_user | isnopasswordreset | bpchar | 1 | 'N'::bpchar | No Password Reset | ||
c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | One time transaction | ||
ad_table | ispartition | bpchar | 1 | 'N'::bpchar | This is a partitioned table | ||
c_country | ispostcodelookup | bpchar | 1 | 'N'::bpchar | Does this country have a post code web service | ||
ad_client | ispostimmediate | bpchar | 1 | 'N'::bpchar | Post the accounting immediately for testing (Deprecated) | ||
c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on purchases | ||
m_pricelist | ispresentforproduct | bpchar | 1 | √ | 'N'::bpchar | Is Present For Product | |
c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
ad_registration | isregistered | bpchar | 1 | 'N'::bpchar | The application is registered. | ||
ad_user | issaleslead | bpchar | 1 | 'N'::bpchar | This contact is a sales lead | ||
c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | Indicates if the business partner is a sales representative or company agent | ||
ad_client | issecuresmtp | bpchar | 1 | 'N'::bpchar | Use SSL/TLS for SMTP | ||
ad_table | issecurityenabled | bpchar | 1 | 'N'::bpchar | If security is enabled, user access to data can be restricted via Roles | ||
ad_client | isserveremail | bpchar | 1 | √ | null | Send EMail from Server | |
ad_user | isshipto | bpchar | 1 | 'N'::bpchar | Business Partner Shipment Address | ||
ad_table | isshowindrilloptions | bpchar | 1 | √ | 'Y'::bpchar | This parameter enables the table to be displayed in Drill Assistant - Table tab | |
ad_client | issmtpauthorization | bpchar | 1 | 'N'::bpchar | Your mail server requires Authentication | ||
m_pricelist | issopricelist | bpchar | 1 | 'Y'::bpchar | This is a Sales Price List | ||
ad_org | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
ad_org_v | issummary | bpchar | 1 | √ | null | ||
c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
ad_user | issupportuser | bpchar | 1 | 'N'::bpchar | Support User | ||
ad_language | issystemlanguage | bpchar | 1 | 'N'::bpchar | The screens, etc. are maintained in this Language | ||
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
m_pricelist | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
ad_client | isuseasp | bpchar | 1 | 'N'::bpchar | Is Use ASP | ||
ad_client | isusebetafunctions | bpchar | 1 | 'N'::bpchar | Enable the use of Beta Functionality | ||
c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is a Vendor | ||
ad_user | isvendorlead | bpchar | 1 | 'N'::bpchar | This contact is a vendor lead | ||
ad_table | isview | bpchar | 1 | 'N'::bpchar | This is a view | ||
ad_clientinfo | keeplogdays | numeric | 10 | √ | null | Number of days to keep the log entries | |
ad_language | languageiso | bpchar | 2 | √ | null | Lower-case two-letter ISO-3166 code - http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt | |
ad_system | lastbuildinfo | varchar | 255 | √ | null | Last Build Info | |
ad_user | lastcontact | timestamp | 29,6 | √ | null | Date this individual was last contacted | |
ad_system | lastmigrationscriptapplied | varchar | 255 | √ | NULL::character varying | Register of the filename for the last migration script applied on this database | |
ad_user | lastresult | varchar | 255 | √ | null | Result of last contact | |
ad_system | ldapdomain | varchar | 255 | √ | null | Directory service domain name - e.g. idempiere.org | |
ad_system | ldaphost | varchar | 60 | √ | null | Connection String to LDAP server starting with ldap:// | |
ad_client | ldapquery | varchar | 255 | √ | null | ||
ad_user | ldapuser | varchar | 60 | √ | null | User Name used for authorization via LDAP (directory) services | |
ad_user | leadsource | varchar | 10 | √ | NULL::character varying | The source of this lead/opportunity | |
ad_user | leadsourcedescription | varchar | 255 | √ | NULL::character varying | Additional information on the source of this lead/opportunity | |
ad_user | leadstatus | varchar | 10 | √ | NULL::character varying | The status of this lead/opportunity in the sales cycle | |
ad_user | leadstatusdescription | varchar | 255 | √ | NULL::character varying | Additional information on the status of this lead/opportunity | |
ad_table | loadseq | numeric | 10 | √ | null | Sequence | |
ad_client | loginprefix | varchar | 40 | √ | NULL::character varying | Login Prefix | |
ad_clientinfo | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
ad_orginfo | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
ad_clientinfo | logoreport_id | numeric | 10 | √ | NULL::numeric | Logo Report | |
ad_clientinfo | logoweb_id | numeric | 10 | √ | NULL::numeric | Logo Web | |
c_country | lookupclassname | varchar | 255 | √ | null | The class name of the postcode lookup plugin | |
c_country | lookupclientid | varchar | 50 | √ | null | The Client ID or Login submitted to the Lookup URL | |
c_country | lookuppassword | varchar | 50 | √ | null | The password submitted to the Lookup URL | |
c_country | lookupurl | varchar | 100 | √ | null | The URL of the web service that the plugin connects to in order to retrieve postcode data | |
c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
c_bpartner | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
m_pricelist | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
m_pricelist | m_pricelist_uu | varchar | 36 | √ | NULL::character varying | M_PriceList_UU | |
ad_clientinfo | m_productfreight_id | numeric | 10 | √ | null | Product for Freight | |
m_warehouse | m_reservelocator_id | numeric | 10 | √ | NULL::numeric | Reservation Locator (just for reporting purposes) | |
ad_org_v | m_warehouse_id | numeric | 10 | √ | null | ||
ad_orginfo | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
m_warehouse | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
m_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | M_Warehouse_UU | |
m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | Optional Warehouse to replenish from | |
ad_printform | manuf_order_mailtext_id | numeric | 10 | √ | null | Email text used for sending Manufacturing Order | |
ad_printform | manuf_order_printformat_id | numeric | 10 | √ | null | Print Format for printing Manufacturing Order | |
c_country | mediasize | varchar | 40 | √ | null | Java Media Size | |
ad_client | mmpolicy | bpchar | 1 | 'F'::bpchar | Material Movement Policy | ||
ad_client | modelvalidationclasses | varchar | 255 | √ | null | List of data model validation classes separated by ; | |
c_bpartner | naics | varchar | 6 | √ | null | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | |
ad_client | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_clientshare | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_language | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_org | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_org_v | name | varchar | 60 | √ | null | ||
ad_orgtype | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_printform | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_system | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_table | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_user | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_bpartner | name | varchar | 120 | Alphanumeric identifier of the entity | |||
c_country | name | varchar | 60 | Alphanumeric identifier of the entity | |||
m_pricelist | name | varchar | 60 | Alphanumeric identifier of the entity | |||
m_warehouse | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
ad_system | noprocessors | numeric | 10 | √ | null | Number of Database Processors | |
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
ad_registration | numberemployees | numeric | 10 | √ | 0 | Number of employees | |
c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
ad_system | oldname | varchar | 60 | √ | null | Old Name | |
ad_printform | order_mailtext_id | numeric | 10 | √ | null | Email text used for sending order acknowledgements or quotations | |
ad_printform | order_printformat_id | numeric | 10 | √ | null | Print Format for Orders, Quotes, Offers | |
ad_orginfo | pa_goal_id | numeric | 10 | √ | null | ||
ad_org_v | parent_org_id | numeric | 10 | √ | null | ||
ad_orginfo | parent_org_id | numeric | 10 | √ | null | Parent (superior) Organization | |
ad_system | password | varchar | 20 | √ | null | Password of any length (case sensitive) | |
ad_user | password | varchar | 1024 | √ | null | Password of any length (case sensitive) | |
c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
ad_orginfo | phone | varchar | 40 | √ | NULL::character varying | Identifies a telephone number | |
ad_user | phone | varchar | 40 | √ | null | Identifies a telephone number | |
ad_orginfo | phone2 | varchar | 40 | √ | NULL::character varying | Identifies an alternate telephone number. | |
ad_user | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
c_country | placeholderaddress1 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 1 | |
c_country | placeholderaddress2 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 2 | |
c_country | placeholderaddress3 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 3 | |
c_country | placeholderaddress4 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 4 | |
c_country | placeholderaddress5 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 5 | |
c_country | placeholdercity | varchar | 255 | √ | NULL::character varying | Placeholder for city | |
c_country | placeholdercomments | varchar | 255 | √ | NULL::character varying | Placeholder for comments | |
c_country | placeholderpostal | varchar | 255 | √ | NULL::character varying | Placeholder for postal | |
c_country | placeholderpostal_add | varchar | 255 | √ | NULL::character varying | Placeholder for additional zip | |
ad_registration | platforminfo | varchar | 255 | √ | null | Information about Server and Tenant Platform | |
c_bpartner | po_discountschema_id | numeric | 10 | √ | null | Schema to calculate the purchase trade discount percentage | |
c_bpartner | po_paymentterm_id | numeric | 10 | √ | null | Payment rules for a purchase order | |
c_bpartner | po_pricelist_id | numeric | 10 | √ | null | Price List used by this Business Partner | |
ad_table | po_window_id | numeric | 10 | √ | null | Purchase Order Window | |
c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
ad_preference | preferencefor | bpchar | 1 | 'W'::bpchar | Type of preference, it can window, info window or parameter process | ||
m_pricelist | priceprecision | numeric | 10 | 2 | Precision (number of decimals) for the Price | ||
ad_language | printname | varchar | 60 | NULL::character varying | The label text to be printed on a document or correspondence. | ||
ad_language | processing | bpchar | 1 | √ | null | Process Now | |
ad_registration | processing | bpchar | 1 | √ | null | Process Now | |
ad_system | processing | bpchar | 1 | √ | null | Process Now | |
ad_table | processing | bpchar | 1 | √ | NULL::bpchar | Process Now | |
ad_user | processing | bpchar | 1 | √ | null | Process Now | |
ad_system | profileinfo | varchar | 4000 | √ | null | Information to help profiling the system for solving support issues | |
ad_printform | project_mailtext_id | numeric | 10 | √ | null | Standard text for Project EMails | |
ad_printform | project_printformat_id | numeric | 10 | √ | null | Standard Project Print Format | |
ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | Default mail template | |
c_bpartner | rating | bpchar | 1 | √ | null | Classification or Importance | |
ad_orginfo | receiptfootermsg | varchar | 1023 | √ | null | This message will be displayed at the bottom of a receipt when doing a sales or purchase | |
ad_registration | record_id | numeric | 10 | √ | null | Direct internal record ID | |
ad_system | record_id | numeric | 10 | √ | null | Direct internal record ID | |
c_bpartner | referenceno | varchar | 40 | √ | null | Your customer or vendor number at the Business Partner's site | |
c_country | regionname | varchar | 60 | √ | null | Name of the Region | |
ad_system | releaseno | varchar | 10 | √ | null | Internal Release Number | |
ad_printform | remittance_mailtext_id | numeric | 10 | √ | null | Email text used for sending payment remittances | |
ad_printform | remittance_printformat_id | numeric | 10 | √ | null | Print Format for separate Remittances | |
ad_registration | remote_addr | varchar | 60 | √ | null | Remote Address | |
ad_registration | remote_host | varchar | 120 | √ | null | Remote host Info | |
m_warehouse | replenishmentclass | varchar | 60 | √ | null | Custom class to calculate Quantity to Order | |
ad_system | replicationtype | bpchar | 1 | 'L'::bpchar | Type of Data Replication | ||
ad_table | replicationtype | bpchar | 1 | 'L'::bpchar | Type of Data Replication | ||
ad_client | requestemail | varchar | 60 | √ | null | EMail address to send automated mails from or receive mails for automated processing (fully qualified) | |
ad_client | requestfolder | varchar | 20 | √ | null | EMail folder to process incoming emails; if empty INBOX is used | |
ad_client | requestuser | varchar | 60 | √ | null | User Name (ID) of the email owner | |
ad_client | requestuserpw | varchar | 255 | √ | null | Password of the user name (ID) for mail processing | |
ad_user | salesrep_id | numeric | 10 | √ | NULL::numeric | Sales Representative or Company Agent | |
c_bpartner | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
ad_registration | salesvolume | numeric | 10 | √ | 0 | Total Volume of Sales in Thousands of Currency | |
c_bpartner | salesvolume | numeric | 10 | √ | null | Total Volume of Sales in Thousands of Currency | |
ad_user | salt | varchar | 16 | √ | NULL::character varying | Random data added to improve password hash effectiveness | |
ad_user | securityquestion | varchar | 1024 | √ | null | Security Question | |
c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
m_warehouse | separator | bpchar | 1 | Element Separator | |||
c_bpartner | shareofcustomer | numeric | 10 | √ | null | Share of Customer's business as a percentage | |
ad_clientshare | sharetype | bpchar | 1 | Type of sharing | |||
c_bpartner | shelflifeminpct | numeric | 10 | √ | null | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |
ad_printform | shipment_mailtext_id | numeric | 10 | √ | null | Email text used for sending delivery notes | |
ad_printform | shipment_printformat_id | numeric | 10 | √ | null | Print Format for Shipments, Receipts, Pick Lists | |
ad_client | smtphost | varchar | 60 | √ | null | Hostname of Mail Server for SMTP and IMAP | |
ad_client | smtpport | numeric | 10 | √ | NULL::numeric | SMTP Port Number | |
c_bpartner | so_creditlimit | numeric | 0 | √ | 0 | Total outstanding invoice amounts allowed | |
c_bpartner | so_creditused | numeric | 0 | √ | 0 | Current open balance | |
c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
ad_registration | startproductiondate | timestamp | 29,6 | √ | null | The day you started the implementation (if implementing) - or production (went life) with iDempiere | |
ad_system | statisticsinfo | varchar | 60 | √ | null | Information to help profiling the system for solving support issues | |
ad_clientinfo | storagearchive_id | numeric | 10 | √ | NULL::numeric | Archive Store | |
ad_clientinfo | storageimage_id | numeric | 10 | √ | NULL::numeric | Storage provider for Image | |
ad_client | storearchiveonfilesystem | bpchar | 1 | 'N'::bpchar | Store Archive On File System | ||
ad_client | storeattachmentsonfilesystem | bpchar | 1 | 'N'::bpchar | Store Attachments On File System | ||
ad_system | summary | varchar | 255 | √ | null | Textual summary of this request | |
ad_org_v | supervisor_id | numeric | 10 | √ | null | ||
ad_orginfo | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
ad_user | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
ad_system | supportemail | varchar | 60 | √ | null | EMail address to send support information and updates to | |
ad_system | supportexpdate | timestamp | 29,6 | √ | null | Date when the iDempiere support expires | |
ad_system | supportunits | numeric | 10 | √ | null | Number of Internal Users for iDempiere Support | |
ad_system | systemstatus | bpchar | 1 | 'E'::bpchar | Status of the system - Support priority depends on system status | ||
ad_table | tablename | varchar | 40 | Name of the table in the database | |||
ad_org_v | taxid | varchar | 20 | √ | null | ||
ad_orginfo | taxid | varchar | 20 | Tax Identification | |||
c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
ad_language | timepattern | varchar | 20 | √ | null | Java Time Pattern | |
ad_clientinfo | timezone | varchar | 60 | √ | NULL::character varying | Time zone name | |
ad_orginfo | timezone | varchar | 60 | √ | NULL::character varying | Time zone name | |
ad_user | title | varchar | 40 | √ | null | Name this entity is referred to as | |
c_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
ad_orginfo | transferbank_id | numeric | 0 | √ | null | Bank account depending on currency will be used from this bank for doing transfers | |
ad_orginfo | transfercashbook_id | numeric | 0 | √ | null | CashBook for transfers | |
ad_client | unixarchivepath | varchar | 255 | √ | null | Unix Archive Path | |
ad_client | unixattachmentpath | varchar | 255 | √ | null | Unix Attachment Path | |
ad_client | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_clientinfo | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_clientshare | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_language | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_org | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_org_v | updated | timestamp | 29,6 | √ | null | ||
ad_orginfo | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_orgtype | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_preference | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_printform | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_registration | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_system | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_table | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_user | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_bpartner | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_country | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_pricelist | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_warehouse | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_client | updatedby | numeric | 10 | User who updated this records | |||
ad_clientinfo | updatedby | numeric | 10 | User who updated this records | |||
ad_clientshare | updatedby | numeric | 10 | User who updated this records | |||
ad_language | updatedby | numeric | 10 | User who updated this records | |||
ad_org | updatedby | numeric | 10 | User who updated this records | |||
ad_org_v | updatedby | numeric | 10 | √ | null | ||
ad_orginfo | updatedby | numeric | 10 | User who updated this records | |||
ad_orgtype | updatedby | numeric | 10 | User who updated this records | |||
ad_preference | updatedby | numeric | 10 | User who updated this records | |||
ad_printform | updatedby | numeric | 10 | User who updated this records | |||
ad_registration | updatedby | numeric | 10 | User who updated this records | |||
ad_system | updatedby | numeric | 10 | User who updated this records | |||
ad_table | updatedby | numeric | 10 | User who updated this records | |||
ad_user | updatedby | numeric | 10 | User who updated this records | |||
c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
c_country | updatedby | numeric | 10 | User who updated this records | |||
m_pricelist | updatedby | numeric | 10 | User who updated this records | |||
m_warehouse | updatedby | numeric | 10 | User who updated this records | |||
c_bpartner | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
ad_system | username | varchar | 60 | User Name | |||
ad_user | userpin | varchar | 20 | √ | null | User PIN | |
ad_client | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_org | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_org_v | value | varchar | 40 | √ | null | ||
ad_preference | value | varchar | 60 | Search key for the record in the format required - must be unique | |||
ad_user | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
c_bpartner | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
m_warehouse | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_system | version | varchar | 20 | √ | null | Version of the table definition | |
ad_client | windowsarchivepath | varchar | 255 | √ | null | Windows Archive Path | |
ad_client | windowsattachmentpath | varchar | 255 | √ | null | Windows Attachment Path |