SchemaSpy Analysis of idempiere9.adempiere - ColumnsClient & Organization Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:46 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 547 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 Client/Tenant for this installation.
ad_clientinfo ad_client_id numeric 10 Client/Tenant for this installation.
ad_clientshare ad_client_id numeric 10 Client/Tenant for this installation.
ad_language ad_client_id numeric 10 Client/Tenant for this installation.
ad_org ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_v ad_client_id numeric 10  √  null
ad_orginfo ad_client_id numeric 10 Client/Tenant for this installation.
ad_orgtype ad_client_id numeric 10 Client/Tenant for this installation.
ad_preference ad_client_id numeric 10 Client/Tenant for this installation.
ad_printform ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_registration ad_client_id numeric 10 Client/Tenant for this installation.
ad_system ad_client_id numeric 10 Client/Tenant for this installation.
ad_table ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_country ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse ad_client_id numeric 10 Client/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 client/org entities
ad_clientshare ad_clientshare_uu varchar 36  √  NULL::character varying AD_ClientShare_UU
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 client
ad_clientinfo ad_org_id numeric 10 Organizational entity within client
ad_clientshare ad_org_id numeric 10 Organizational entity within client
ad_language ad_org_id numeric 10 Organizational entity within client
ad_org ad_org_id numeric 10 Organizational entity within client
ad_org_v ad_org_id numeric 10  √  null
ad_orginfo ad_org_id numeric 10 Organizational entity within client
ad_orgtype ad_org_id numeric 10 Organizational entity within client
ad_preference ad_org_id numeric 10 Organizational entity within client
ad_printform ad_org_id numeric 10 Organizational entity within client
ad_registration ad_org_id numeric 10 Organizational entity within client
ad_system ad_org_id numeric 10 Organizational entity within client
ad_table ad_org_id numeric 10 Organizational entity within client
ad_user ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_country ad_org_id numeric 10 Organizational entity within client
m_pricelist ad_org_id numeric 10 Organizational entity within client
m_warehouse ad_org_id numeric 10 Organizational entity within client
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 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 Client 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 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 email varchar 60  √  NULL::character varying Electronic Mail Address
ad_user email 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
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 isPresentForProduct
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_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 IsUseASP
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_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 ClientID 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 Client 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 255  √  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_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