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

idempiere9.adempiere contains 917 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
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_org ad_replicationstrategy_id numeric 0  √  null Data Replication Strategy
ad_role amtapproval numeric 0  √  0 The approval amount limit for this role
ad_role amtapprovalaccum numeric 0  √  null The approval amount limit for this role accumulated on a period
ad_workflow cost numeric 0 Cost information
ad_authorizationaccount expireinseconds numeric 0  √  null Expire in Seconds
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
ad_workflow overlapunits numeric 0  √  null Overlap Units are number of units that must be completed before they are moved the next activity
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
ad_workflow qtybatchsize numeric 0  √  (1)::numeric Qty Batch Size
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
ad_process statistic_seconds numeric 0  √  null Internal statistics how many seconds a process took
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
ad_workflow unitscycles numeric 0  √  null The Units by Cycles are defined for process type Flow Repetitive Dedicated and indicated the product to be manufactured on a production line for duration unit.
ad_column version numeric 0 Version of the table definition
ad_form accesslevel bpchar 1 Access Level required
ad_process accesslevel bpchar 1 Access Level required
ad_table accesslevel bpchar 1 Access Level required
ad_task accesslevel bpchar 1 Access Level required
ad_workflow accesslevel bpchar 1 Access Level required
ad_table_access accesstyperule bpchar 1 'G'::bpchar The type of access for this rule
ad_toolbarbuttonrestrict action bpchar 1 Indicates the Action to be performed
ad_role allow_info_account bpchar 1 'Y'::bpchar Allow Info Account
ad_role allow_info_asset bpchar 1 'Y'::bpchar Allow Info Asset
ad_role allow_info_bpartner bpchar 1 'Y'::bpchar Allow Info BPartner
ad_role allow_info_cashjournal bpchar 1 'N'::bpchar Allow Info CashJournal
ad_role allow_info_crp bpchar 1 'N'::bpchar Allow Info CRP
ad_role allow_info_inout bpchar 1 'Y'::bpchar Allow Info InOut
ad_role allow_info_invoice bpchar 1 'Y'::bpchar Allow Info Invoice
ad_role allow_info_mrp bpchar 1 'N'::bpchar Allow Info MRP
ad_role allow_info_order bpchar 1 'Y'::bpchar Allow Info Order
ad_role allow_info_payment bpchar 1 'Y'::bpchar Allow Info Payment
ad_role allow_info_product bpchar 1 'Y'::bpchar Allow Info Product
ad_role allow_info_resource bpchar 1 'Y'::bpchar Allow Info Resource
ad_role allow_info_schedule bpchar 1 'Y'::bpchar Allow Info Schedule
ad_process allowmultipleexecution bpchar 1  √  'P'::bpchar Allow or disallow executing a process/report multiple times.
ad_role connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
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_process copyfromprocess bpchar 1  √  NULL::bpchar Copy settings from one report and process to another.
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
ad_workflow durationunit bpchar 1  √  null Unit of Duration
ad_changelog eventchangelog bpchar 1  √  null Type of Event in Change Log
ad_process executiontype bpchar 1  √  NULL::bpchar Execution Type defines whether the report/process will always run in background or foreground.
ad_column fkconstrainttype bpchar 1  √  'N'::bpchar Constraint Type
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
ad_table importtable bpchar 1  √  null Import Table Columns from Database
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
ad_role isaccessadvanced bpchar 1  √  'N'::bpchar Access Advanced
ad_role isaccessallorgs bpchar 1 'N'::bpchar Access all Organizations (no org access control) of the client
ad_authorizationaccount isaccessrevoked bpchar 1 'N'::bpchar Access Revoked
ad_attachment isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_authorizationaccount isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_authorizationcredential isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_authorizationprovider isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_authorizationscopeprov isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_changelog isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_column isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_column_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_document_action_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_form isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_form_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_importtemplateaccess isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_infowindow_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_ldapaccess isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_ldapprocessorlog isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_org isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_password_history isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_passwordrule isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_private_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_record_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_role isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_role_included isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_role_orgaccess isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_session 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_table_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_task isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_task_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_toolbarbuttonrestrict isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_tree 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
ad_user_orgaccess isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user_roles isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_window isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_window_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_workflow 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
mfa_method isactive bpchar 1 'Y'::bpchar The record is active in the system
mfa_registereddevice isactive bpchar 1 'Y'::bpchar The record is active in the system
mfa_registration isactive bpchar 1 'Y'::bpchar The record is active in the system
mfa_rule isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_dashboardcontent_access 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
ad_tree isallnodes bpchar 1 'Y'::bpchar All Nodes are included (Complete Tree)
ad_column isallowcopy bpchar 1 'Y'::bpchar Determine if a column must be copied when pushing the button to copy record
ad_importtemplateaccess isallowinsert bpchar 1  √  'Y'::bpchar Allow Insert
ad_column isallowlogging bpchar 1  √  'Y'::bpchar Determine if a column must be recorded into the change log
ad_importtemplateaccess isallowmerge bpchar 1  √  'Y'::bpchar Allow Merge
ad_importtemplateaccess isallowupdate bpchar 1  √  'Y'::bpchar Allow Update
ad_column isalwaysupdateable bpchar 1 'N'::bpchar The column is always updateable, even if the record is not active or processed
ad_authorizationaccount isauthorized bpchar 1 'N'::bpchar Authorized
ad_column isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
ad_form isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_process isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_window isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_workflow isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_user isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
ad_role iscanapproveowndoc bpchar 1 'Y'::bpchar Users with this role can approve their own documents
ad_role iscanexport bpchar 1 'Y'::bpchar Users with this role can export data
ad_table_access iscanexport bpchar 1 'Y'::bpchar Users with this role can export data
ad_role iscanreport bpchar 1 'Y'::bpchar Users with this role can create reports
ad_table_access iscanreport bpchar 1 'Y'::bpchar Users with this role can create reports
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_role ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
ad_changelog iscustomization bpchar 1 'N'::bpchar The change is a customization of the data dictionary and can be applied after Migration
ad_tree isdefault bpchar 1 'N'::bpchar Default value
ad_window isdefault bpchar 1 'N'::bpchar Default value
ad_workflow isdefault bpchar 1 'N'::bpchar Default value
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
ad_record_access isdependententities bpchar 1 'N'::bpchar Also check access in dependent entities
ad_passwordrule isdictmatchbackwards bpchar 1  √  'N'::bpchar Match dictionary words backwards
ad_process isdirectprint bpchar 1  √  'N'::bpchar Print without dialog
ad_role isdiscountallowedontotal bpchar 1 'N'::bpchar IsDiscountAllowedOnTotal
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
ad_role isdiscountuptolimitprice bpchar 1 'N'::bpchar IsDiscountUptoLimitPrice
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
ad_column isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_ldapaccess iserror bpchar 1 'N'::bpchar An Error occurred in the execution
ad_ldapprocessorlog iserror bpchar 1 'N'::bpchar An Error occurred in the execution
ad_column_access isexclude bpchar 1 'Y'::bpchar Exclude access to the data - if not selected Include access to the data
ad_record_access isexclude bpchar 1 'Y'::bpchar Exclude access to the data - if not selected Include access to the data
ad_table_access isexclude bpchar 1 'Y'::bpchar Exclude access to the data - if not selected Include access to the data
ad_toolbarbuttonrestrict isexclude bpchar 1 'Y'::bpchar Exclude access to the data - if not selected Include access to the data
ad_user isexpired bpchar 1 'N'::bpchar Expired
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_column ishtml bpchar 1  √  'N'::bpchar Text has HTML tags
ad_column isidentifier bpchar 1 'N'::bpchar This column is part of the record identifier
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
ad_column iskey bpchar 1 'N'::bpchar This column is the key in this table
ad_tree isloadallnodesimmediately bpchar 1 'Y'::bpchar If checked, all nodes are loaded before tree is displayed
ad_user islocked bpchar 1 'N'::bpchar Locked
ad_column ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_role ismanual bpchar 1 'Y'::bpchar This is a manual process
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
ad_role ismasterrole bpchar 1 'N'::bpchar A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_role ismenuautoexpand bpchar 1 'N'::bpchar If ticked, the menu is automatically expanded
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
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_column isparent bpchar 1 'N'::bpchar This column is a link to the parent table (e.g. header from lines) - incl. Association key columns
ad_role ispersonalaccess bpchar 1 'N'::bpchar Allow access to all personal records
ad_role ispersonallock bpchar 1 'N'::bpchar Allow users with role to lock access to personal records
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
ad_column_access isreadonly bpchar 1 'N'::bpchar Field is read only
ad_record_access isreadonly bpchar 1 'N'::bpchar Field is read only
ad_role_orgaccess isreadonly bpchar 1 'N'::bpchar Field is read only
ad_table_access isreadonly bpchar 1 'N'::bpchar Field is read only
ad_user_orgaccess isreadonly bpchar 1 'N'::bpchar Field is read only
ad_form_access isreadwrite bpchar 1 'Y'::bpchar Field is read / write
ad_process_access isreadwrite bpchar 1 'Y'::bpchar Field is read / write
ad_task_access isreadwrite bpchar 1 'Y'::bpchar Field is read / write
ad_window_access isreadwrite bpchar 1 'Y'::bpchar Field is read / write
ad_process isreport bpchar 1 'Y'::bpchar Indicates a Report record
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_column issecure bpchar 1 'N'::bpchar Defines whether content must be treated as secure
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
ad_column isselectioncolumn bpchar 1 'N'::bpchar Is this column used for finding rows in windows
ad_process isserverprocess bpchar 1  √  null Run this Process on Server only
ad_task isserverprocess bpchar 1  √  'N'::bpchar Run this Process on Server only
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
ad_role isshowacct bpchar 1 'Y'::bpchar Users with this role can see accounting information
ad_window issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
ad_org issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_column issyncdatabase bpchar 1  √  'N'::bpchar Change database table definition when changing dictionary definition
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
ad_column istoolbarbutton bpchar 1 'Y'::bpchar Show the button on the toolbar, the window, or both
ad_column istranslated bpchar 1 'N'::bpchar This column is translated
ad_tree istreedrivenbyvalue bpchar 1 'N'::bpchar Driven by Search Key
ad_column isupdateable bpchar 1 'Y'::bpchar Determines, if the field can be updated
mfa_registration isusermfapreferred bpchar 1 'N'::bpchar Preferred
ad_passwordrule isusernamerule bpchar 1  √  'N'::bpchar Validate the password doesn't contain user name (ignore case and match backwards)
ad_role isuseuserorgaccess bpchar 1 'N'::bpchar Use Org Access defined by user instead of Role Org Access
ad_passwordrule isusingdictionary bpchar 1  √  'N'::bpchar Using Dictionary
ad_workflow isvalid bpchar 1 'N'::bpchar Element is valid
mfa_registration isvalid bpchar 1 'N'::bpchar Element is valid
ad_tree isvaluedisplayed bpchar 1 'N'::bpchar Displays Value column with the Display column
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_passwordrule iswhitespace bpchar 1  √  'N'::bpchar Whitespace validation
mfa_method mfatimeprovider bpchar 1  √  NULL::bpchar Time Provider
mfa_method mfatype bpchar 1  √  NULL::bpchar Multi-factor authentication type (Something you Know/Have/Are, Location)
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
ad_role overwritepricelimit bpchar 1 'N'::bpchar Overwrite Price Limit if the Price List enforces the Price Limit
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
ad_role preferencetype bpchar 1 'C'::bpchar Determines what preferences the user can set
ad_session processed bpchar 1 'N'::bpchar The document has been processed
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_tree processing bpchar 1  √  null Process Now
ad_user processing bpchar 1  √  null Process Now
ad_window processing bpchar 1  √  null Process Now
ad_workflow publishstatus bpchar 1 Status of Publication
c_bpartner rating bpchar 1  √  null Classification or Importance
ad_changelog redo bpchar 1  √  null Redo
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
ad_process showhelp bpchar 1  √  'Y'::bpchar Show Help
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
ad_changelog undo bpchar 1  √  null Undo
ad_workflow validateworkflow bpchar 1  √  null Validate Workflow
ad_window windowtype bpchar 1  √  null Type or classification of a Window
ad_workflow workflowtype bpchar 1 'G'::bpchar Type of Workflow
ad_workflow processtype bpchar 2  √  null Process Type
ad_role roletype varchar 2  √  NULL::character varying Role Type
ad_tree treetype bpchar 2 Element this tree is built on (i.e Product, Business Partner)
ad_role userlevel bpchar 3 ' O'::bpchar System Client Organization
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_attachment ad_attachment_id numeric 10 Attachment for the document
ad_authorizationaccount ad_authorizationaccount_id numeric 10 Authorization Account
ad_authorizationaccount ad_authorizationcredential_id numeric 10  √  NULL::numeric Authorization Credential
ad_authorizationcredential ad_authorizationcredential_id numeric 10 Authorization Credential
ad_authorizationcredential ad_authorizationprovider_id numeric 10 Authorization Provider
ad_authorizationprovider ad_authorizationprovider_id numeric 10 Authorization Provider
ad_authorizationscopeprov ad_authorizationprovider_id numeric 10  √  NULL::numeric Authorization Provider
ad_authorizationaccount ad_authorizationscope varchar 10  √  NULL::character varying Authorization Scope
ad_authorizationscopeprov ad_authorizationscope varchar 10 NULL::character varying Authorization Scope
ad_authorizationscopeprov ad_authorizationscopeprov_id numeric 10 Authorization Scope Provider
ad_authorizationprovider ad_authorizationtype varchar 10 Authorization Type
ad_changelog ad_changelog_id numeric 10 Log of data changes
ad_column ad_chart_id numeric 10  √  NULL::numeric Chart
ad_attachment ad_client_id numeric 10 Client/Tenant for this installation.
ad_authorizationaccount ad_client_id numeric 10 Client/Tenant for this installation.
ad_authorizationcredential ad_client_id numeric 10 Client/Tenant for this installation.
ad_authorizationprovider ad_client_id numeric 10 Client/Tenant for this installation.
ad_authorizationscopeprov ad_client_id numeric 10 Client/Tenant for this installation.
ad_changelog ad_client_id numeric 10 Client/Tenant for this installation.
ad_column ad_client_id numeric 10 Client/Tenant for this installation.
ad_column_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_document_action_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_form ad_client_id numeric 10 Client/Tenant for this installation.
ad_form_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_importtemplateaccess ad_client_id numeric 10  √  NULL::numeric Client/Tenant for this installation.
ad_infowindow_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_ldapaccess ad_client_id numeric 10 Client/Tenant for this installation.
ad_ldapprocessorlog ad_client_id numeric 10 Client/Tenant for this installation.
ad_org ad_client_id numeric 10 Client/Tenant for this installation.
ad_password_history ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
ad_passwordrule ad_client_id numeric 10 Client/Tenant for this installation.
ad_private_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_process ad_client_id numeric 10 Client/Tenant for this installation.
ad_process_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_record_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_role ad_client_id numeric 10 Client/Tenant for this installation.
ad_role_included ad_client_id numeric 10 Client/Tenant for this installation.
ad_role_orgaccess ad_client_id numeric 10 Client/Tenant for this installation.
ad_session ad_client_id numeric 10 Client/Tenant for this installation.
ad_table ad_client_id numeric 10 Client/Tenant for this installation.
ad_table_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_task ad_client_id numeric 10 Client/Tenant for this installation.
ad_task_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_toolbarbuttonrestrict ad_client_id numeric 10 Client/Tenant for this installation.
ad_tree ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_client_id numeric 10 Client/Tenant for this installation.
ad_user_orgaccess ad_client_id numeric 10 Client/Tenant for this installation.
ad_user_roles ad_client_id numeric 10 Client/Tenant for this installation.
ad_window ad_client_id numeric 10 Client/Tenant for this installation.
ad_window_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflow ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
mfa_method ad_client_id numeric 10 Client/Tenant for this installation.
mfa_registereddevice ad_client_id numeric 10 Client/Tenant for this installation.
mfa_registration ad_client_id numeric 10 Client/Tenant for this installation.
mfa_rule ad_client_id numeric 10 Client/Tenant for this installation.
pa_dashboardcontent_access ad_client_id numeric 10  √  NULL::numeric Client/Tenant for this installation.
ad_window ad_color_id numeric 10  √  null Color for backgrounds or indicators
ad_changelog ad_column_id numeric 10 Column in the table
ad_column ad_column_id numeric 10 Column in the table
ad_column_access ad_column_id numeric 10 Column in the table
ad_form ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_process ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_task ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_workflow ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_column ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_form ad_form_id numeric 10 Special Form
ad_form_access ad_form_id numeric 10 Special Form
ad_process ad_form_id numeric 10  √  null Special Form
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_window ad_image_id numeric 10  √  null Image or Icon
ad_importtemplateaccess ad_importtemplate_id numeric 10  √  NULL::numeric Import Template
ad_importtemplateaccess ad_importtemplateaccess_id numeric 10 Import Template Access
ad_infowindow_access ad_infowindow_id numeric 10 Info and search/select Window
ad_ldapaccess ad_ldapaccess_id numeric 10 Ldap Access Log
ad_ldapaccess ad_ldapprocessor_id numeric 10 LDAP Server to authenticate and authorize external systems based on iDempiere
ad_ldapprocessorlog ad_ldapprocessor_id numeric 10 LDAP Server to authenticate and authorize external systems based on iDempiere
ad_ldapprocessorlog ad_ldapprocessorlog_id numeric 10 LDAP Server Log
ad_attachment ad_org_id numeric 10 Organizational entity within client
ad_authorizationaccount ad_org_id numeric 10 Organizational entity within client
ad_authorizationcredential ad_org_id numeric 10 Organizational entity within client
ad_authorizationprovider ad_org_id numeric 10 Organizational entity within client
ad_authorizationscopeprov ad_org_id numeric 10 Organizational entity within client
ad_changelog ad_org_id numeric 10 Organizational entity within client
ad_column ad_org_id numeric 10 Organizational entity within client
ad_column_access ad_org_id numeric 10 Organizational entity within client
ad_document_action_access ad_org_id numeric 10 Organizational entity within client
ad_form ad_org_id numeric 10 Organizational entity within client
ad_form_access ad_org_id numeric 10 Organizational entity within client
ad_importtemplateaccess ad_org_id numeric 10  √  NULL::numeric Organizational entity within client
ad_infowindow_access ad_org_id numeric 10 Organizational entity within client
ad_ldapaccess ad_org_id numeric 10 Organizational entity within client
ad_ldapprocessorlog ad_org_id numeric 10 Organizational entity within client
ad_org ad_org_id numeric 10 Organizational entity within client
ad_password_history ad_org_id numeric 10 NULL::numeric Organizational entity within client
ad_passwordrule ad_org_id numeric 10 Organizational entity within client
ad_private_access ad_org_id numeric 10 Organizational entity within client
ad_process ad_org_id numeric 10 Organizational entity within client
ad_process_access ad_org_id numeric 10 Organizational entity within client
ad_record_access ad_org_id numeric 10 Organizational entity within client
ad_role ad_org_id numeric 10 Organizational entity within client
ad_role_included ad_org_id numeric 10 Organizational entity within client
ad_role_orgaccess ad_org_id numeric 10 Organizational entity within client
ad_session ad_org_id numeric 10 Organizational entity within client
ad_table ad_org_id numeric 10 Organizational entity within client
ad_table_access ad_org_id numeric 10 Organizational entity within client
ad_task ad_org_id numeric 10 Organizational entity within client
ad_task_access ad_org_id numeric 10 Organizational entity within client
ad_toolbarbuttonrestrict ad_org_id numeric 10 Organizational entity within client
ad_tree ad_org_id numeric 10 Organizational entity within client
ad_user ad_org_id numeric 10 Organizational entity within client
ad_user_orgaccess ad_org_id numeric 10 Organizational entity within client
ad_user_roles ad_org_id numeric 10 Organizational entity within client
ad_window ad_org_id numeric 10 Organizational entity within client
ad_window_access ad_org_id numeric 10 Organizational entity within client
ad_workflow ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
mfa_method ad_org_id numeric 10 Organizational entity within client
mfa_registereddevice ad_org_id numeric 10 Organizational entity within client
mfa_registration ad_org_id numeric 10 Organizational entity within client
mfa_rule ad_org_id numeric 10 Organizational entity within client
pa_dashboardcontent_access ad_org_id numeric 10  √  NULL::numeric Organizational entity within client
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_password_history ad_password_history_id numeric 10 NULL::numeric Password History ID
ad_passwordrule ad_passwordrule_id numeric 10 Password Policies
ad_process ad_printformat_id numeric 10  √  null Data Print Format
ad_column ad_process_id numeric 10  √  null Process or Report
ad_process ad_process_id numeric 10 Process or Report
ad_process_access ad_process_id numeric 10 Process or Report
ad_toolbarbuttonrestrict ad_process_id numeric 10  √  NULL::numeric Process or Report
ad_document_action_access ad_ref_list_id numeric 10 Reference List based on Table
ad_column ad_reference_id numeric 10 System Reference and Validation
ad_column ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_process ad_reportview_id numeric 10  √  null View used to generate this report
ad_column_access ad_role_id numeric 10 Responsibility Role
ad_document_action_access ad_role_id numeric 10 Responsibility Role
ad_form_access ad_role_id numeric 10 Responsibility Role
ad_importtemplateaccess ad_role_id numeric 10  √  NULL::numeric Responsibility Role
ad_infowindow_access ad_role_id numeric 10 Responsibility Role
ad_process_access ad_role_id numeric 10 Responsibility Role
ad_record_access ad_role_id numeric 10 Responsibility Role
ad_role ad_role_id numeric 10 Responsibility Role
ad_role_included ad_role_id numeric 10 Responsibility Role
ad_role_orgaccess ad_role_id numeric 10 Responsibility Role
ad_session ad_role_id numeric 10  √  null Responsibility Role
ad_table_access ad_role_id numeric 10 Responsibility Role
ad_task_access ad_role_id numeric 10 Responsibility Role
ad_toolbarbuttonrestrict ad_role_id numeric 10  √  null Responsibility Role
ad_user_roles ad_role_id numeric 10 Responsibility Role
ad_window_access ad_role_id numeric 10 Responsibility Role
pa_dashboardcontent_access ad_role_id numeric 10  √  NULL::numeric Responsibility Role
ad_changelog ad_session_id numeric 10 User Session Online or Web
ad_session ad_session_id numeric 10 User Session Online or Web
ad_attachment ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
ad_toolbarbuttonrestrict ad_tab_id numeric 10  √  NULL::numeric Tab within a Window
ad_attachment ad_table_id numeric 10 Database Table information
ad_changelog ad_table_id numeric 10 Database Table information
ad_column ad_table_id numeric 10 Database Table information
ad_column_access ad_table_id numeric 10  √  null Database Table information
ad_private_access ad_table_id numeric 10 Database Table information
ad_record_access ad_table_id numeric 10 Database Table information
ad_table ad_table_id numeric 10 Database Table information
ad_table_access ad_table_id numeric 10 Database Table information
ad_tree ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_workflow ad_table_id numeric 10  √  null Database Table information
ad_task ad_task_id numeric 10 Operation System Task
ad_task_access ad_task_id numeric 10 Operation System Task
ad_toolbarbuttonrestrict ad_toolbarbutton_id numeric 10  √  NULL::numeric ToolBar Button
ad_toolbarbuttonrestrict ad_toolbarbuttonrestrict_id numeric 10 ToolBar Button Restrict
ad_tree ad_tree_id numeric 10 Identifies a Tree
ad_role ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_role ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
ad_authorizationaccount ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
ad_ldapaccess ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_password_history ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
ad_private_access ad_user_id numeric 10 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_orgaccess ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_user_roles ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
mfa_registereddevice ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
mfa_registration ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
pa_dashboardcontent_access ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
ad_column ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_column ad_val_rule_lookup_id numeric 10  √  NULL::numeric Override Dynamic Validation Rule for Lookup Window
ad_workflow ad_wf_node_id numeric 10  √  null Workflow Node (activity), step or process
ad_workflow ad_wf_responsible_id numeric 10  √  null Responsible for Workflow Execution
ad_table ad_window_id numeric 10  √  null Data entry or display window
ad_toolbarbuttonrestrict ad_window_id numeric 10  √  NULL::numeric Data entry or display window
ad_window ad_window_id numeric 10 Data entry or display window
ad_window_access ad_window_id numeric 10 Data entry or display window
ad_process ad_workflow_id numeric 10  √  null Workflow or combination of tasks
ad_workflow ad_workflow_id numeric 10 Workflow or combination of tasks
ad_workflow ad_workflowprocessor_id numeric 10  √  null Workflow Processor Server
ad_passwordrule alphabeticalcharacter numeric 10  √  NULL::numeric Require at least # alphabetical in passwords
ad_passwordrule alphabeticalsequence numeric 10  √  NULL::numeric Lenght of alphabetical sequence to validate
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
c_bpartner c_bp_group_id numeric 10 Business Partner Group
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
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
ad_role c_currency_id numeric 10  √  null The Currency for this record
ad_document_action_access c_doctype_id numeric 10 Document type or rules
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_user c_location_id numeric 10  √  NULL::numeric 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_role confirmqueryrecords numeric 10 0 Require Confirmation if more records will be returned by the query (If not defined 500)
ad_attachment createdby numeric 10 User who created this records
ad_authorizationaccount createdby numeric 10 User who created this records
ad_authorizationcredential createdby numeric 10 User who created this records
ad_authorizationprovider createdby numeric 10 User who created this records
ad_authorizationscopeprov createdby numeric 10 User who created this records
ad_changelog createdby numeric 10 User who created this records
ad_column createdby numeric 10 User who created this records
ad_column_access createdby numeric 10 User who created this records
ad_document_action_access createdby numeric 10 User who created this records
ad_form createdby numeric 10 User who created this records
ad_form_access createdby numeric 10 User who created this records
ad_importtemplateaccess createdby numeric 10  √  NULL::numeric User who created this records
ad_infowindow_access createdby numeric 10 User who created this records
ad_ldapaccess createdby numeric 10 User who created this records
ad_ldapprocessorlog createdby numeric 10 User who created this records
ad_org createdby numeric 10 User who created this records
ad_password_history createdby numeric 10 NULL::numeric User who created this records
ad_passwordrule createdby numeric 10 User who created this records
ad_private_access createdby numeric 10 User who created this records
ad_process createdby numeric 10 User who created this records
ad_process_access createdby numeric 10 User who created this records
ad_record_access createdby numeric 10 User who created this records
ad_role createdby numeric 10 User who created this records
ad_role_included createdby numeric 10 User who created this records
ad_role_orgaccess createdby numeric 10 User who created this records
ad_session createdby numeric 10 User who created this records
ad_table createdby numeric 10 User who created this records
ad_table_access createdby numeric 10 User who created this records
ad_task createdby numeric 10 User who created this records
ad_task_access createdby numeric 10 User who created this records
ad_toolbarbuttonrestrict createdby numeric 10 User who created this records
ad_tree createdby numeric 10 User who created this records
ad_user createdby numeric 10 User who created this records
ad_user_orgaccess createdby numeric 10 User who created this records
ad_user_roles createdby numeric 10 User who created this records
ad_window createdby numeric 10 User who created this records
ad_window_access createdby numeric 10 User who created this records
ad_workflow createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
mfa_method createdby numeric 10 User who created this records
mfa_registereddevice createdby numeric 10 User who created this records
mfa_registration createdby numeric 10 User who created this records
mfa_rule createdby numeric 10 User who created this records
pa_dashboardcontent_access createdby numeric 10  √  NULL::numeric User who created this records
ad_passwordrule days_reuse_password numeric 10  √  NULL::numeric Define number of day can reuser password
ad_role daysapprovalaccum numeric 10  √  null The days approval indicates the days to take into account to verify the accumulated approval amount.
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
ad_passwordrule digitcharacter numeric 10  √  NULL::numeric Require at least # digit in passwords
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
ad_workflow duration numeric 10 0 Normal Duration in Duration Unit
mfa_method expireinminutes numeric 10  √  NULL::numeric Expire in Minutes
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
mfa_registration failedlogincount numeric 10  √  NULL::numeric Failed Login Count
ad_column fieldlength numeric 10  √  null Length of the column in the database
ad_role_included included_role_id numeric 10 Included Role
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
ad_user leadsource varchar 10  √  NULL::character varying 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_workflow limit numeric 10  √  null Maximum Duration in Duration Unit
ad_table loadseq numeric 10  √  null Sequence
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
ad_passwordrule lowercasecharacter numeric 10  √  NULL::numeric Require at least # lower case char
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
ad_passwordrule maxlength numeric 10  √  NULL::numeric Maximum Length of Data
ad_role maxqueryrecords numeric 10 0 If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
mfa_method mfa_elementprm_id numeric 10  √  NULL::numeric Parameter Element
mfa_method mfa_method_id numeric 10 Multi-factor Authentication Method
mfa_registration mfa_method_id numeric 10 Multi-factor Authentication Method
mfa_rule mfa_method_id numeric 10 Multi-factor Authentication Method
mfa_registereddevice mfa_registereddevice_id numeric 10 MFA Registered Device
mfa_registration mfa_registration_id numeric 10 MFA Registration
mfa_rule mfa_rule_id numeric 10 Multi-factor Authentication Rule
mfa_method mfaallowedtimediscrepancy numeric 10  √  NULL::numeric Allowed Time Period Discrepancy
ad_passwordrule minlength numeric 10  √  NULL::numeric Minimum Length
ad_workflow movingtime numeric 10  √  null Moving Time
ad_passwordrule nonalphanumericcharacter numeric 10  √  NULL::numeric Require at least # non-alphanumeric char
c_bpartner numberemployees numeric 10  √  null Number of employees
ad_passwordrule numericalsequence numeric 10  √  NULL::numeric Length of numerical sequence to validate
pa_dashboardcontent_access pa_dashboardcontent_access_id numeric 10 PA_DashboardContent_Access_ID
ad_column pa_dashboardcontent_id numeric 10  √  NULL::numeric Dashboard Content
pa_dashboardcontent_access pa_dashboardcontent_id numeric 10  √  NULL::numeric Dashboard Content
ad_tree parent_column_id numeric 10  √  NULL::numeric The link column on the parent tab.
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
ad_workflow priority numeric 10  √  null Indicates if this request is of a high, medium or low priority.
ad_workflow queuingtime numeric 10  √  null Queue time is the time a job waits at a work center before begin handled.
ad_passwordrule qwertysequence numeric 10  √  NULL::numeric Lenght of QWERTY sequences to validate
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
ad_ldapaccess r_interestarea_id numeric 10  √  null Interest Area or Topic
mfa_method r_mailtext_id numeric 10  √  NULL::numeric Text templates for mailings
ad_attachment record_id numeric 10 Direct internal record ID
ad_changelog record_id numeric 10 Direct internal record ID
ad_private_access record_id numeric 10 Direct internal record ID
ad_record_access record_id numeric 10 Direct internal record ID
ad_passwordrule repeatcharacterregex numeric 10  √  NULL::numeric Length of repeated characters to validate
ad_workflow s_resource_id numeric 10  √  null Resource
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
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
ad_column seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_role_included seqno numeric 10 Method of ordering records; lowest number comes first
ad_column seqnoselection numeric 10  √  NULL::numeric Selection Column Sequence
ad_workflow setuptime numeric 10  √  null Setup time before starting Production
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
ad_process statistic_count numeric 10  √  null Internal statistics how often the entity was used
ad_role 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_attachment updatedby numeric 10 User who updated this records
ad_authorizationaccount updatedby numeric 10 User who updated this records
ad_authorizationcredential updatedby numeric 10 User who updated this records
ad_authorizationprovider updatedby numeric 10 User who updated this records
ad_authorizationscopeprov updatedby numeric 10 User who updated this records
ad_changelog updatedby numeric 10 User who updated this records
ad_column updatedby numeric 10 User who updated this records
ad_column_access updatedby numeric 10 User who updated this records
ad_document_action_access updatedby numeric 10 User who updated this records
ad_form updatedby numeric 10 User who updated this records
ad_form_access updatedby numeric 10 User who updated this records
ad_importtemplateaccess updatedby numeric 10  √  NULL::numeric User who updated this records
ad_infowindow_access updatedby numeric 10 User who updated this records
ad_ldapaccess updatedby numeric 10 User who updated this records
ad_ldapprocessorlog updatedby numeric 10 User who updated this records
ad_org updatedby numeric 10 User who updated this records
ad_password_history updatedby numeric 10 NULL::numeric User who updated this records
ad_passwordrule updatedby numeric 10  √  NULL::numeric User who updated this records
ad_private_access updatedby numeric 10 User who updated this records
ad_process updatedby numeric 10 User who updated this records
ad_process_access updatedby numeric 10 User who updated this records
ad_record_access updatedby numeric 10 User who updated this records
ad_role updatedby numeric 10 User who updated this records
ad_role_included updatedby numeric 10 User who updated this records
ad_role_orgaccess updatedby numeric 10 User who updated this records
ad_session updatedby numeric 10 User who updated this records
ad_table updatedby numeric 10 User who updated this records
ad_table_access updatedby numeric 10 User who updated this records
ad_task updatedby numeric 10 User who updated this records
ad_task_access updatedby numeric 10 User who updated this records
ad_toolbarbuttonrestrict updatedby numeric 10 User who updated this records
ad_tree updatedby numeric 10 User who updated this records
ad_user updatedby numeric 10 User who updated this records
ad_user_orgaccess updatedby numeric 10 User who updated this records
ad_user_roles updatedby numeric 10 User who updated this records
ad_window updatedby numeric 10 User who updated this records
ad_window_access updatedby numeric 10 User who updated this records
ad_workflow updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
mfa_method updatedby numeric 10 User who updated this records
mfa_registereddevice updatedby numeric 10 User who updated this records
mfa_registration updatedby numeric 10 User who updated this records
mfa_rule updatedby numeric 10 User who updated this records
pa_dashboardcontent_access updatedby numeric 10  √  NULL::numeric User who updated this records
ad_passwordrule uppercasecharacter numeric 10  √  NULL::numeric Require at least # upper case char
ad_workflow version numeric 10 0 Version of the table definition
ad_workflow waitingtime numeric 10 0 Workflow Simulation Waiting time
ad_window winheight numeric 10  √  null Window Height
ad_window winwidth numeric 10  √  null Window Width
ad_workflow workingtime numeric 10 0 Workflow Simulation Execution Time
ad_workflow yield numeric 10  √  (100)::numeric The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
ad_password_history salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_workflow author varchar 20 'ComPiere'::character varying Author/Creator of the Entity
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner taxid varchar 20  √  null Tax Identification
ad_user userpin varchar 20  √  null User PIN
ad_column valuemax varchar 20  √  null Maximum Value for a field
ad_column valuemin varchar 20  √  null Minimum Value for a field
ad_column formatpattern varchar 22  √  null The pattern used to format a number or date.
ad_role userdiscount numeric 22,2  √  null UserDiscount
ad_authorizationaccount accesstokentimestamp timestamp 29,6  √  null Access Token Timestamp
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_attachment created timestamp 29,6 now() Date this record was created
ad_authorizationaccount created timestamp 29,6 statement_timestamp() Date this record was created
ad_authorizationcredential created timestamp 29,6 statement_timestamp() Date this record was created
ad_authorizationprovider created timestamp 29,6 statement_timestamp() Date this record was created
ad_authorizationscopeprov created timestamp 29,6 statement_timestamp() Date this record was created
ad_changelog created timestamp 29,6 now() Date this record was created
ad_column created timestamp 29,6 now() Date this record was created
ad_column_access created timestamp 29,6 now() Date this record was created
ad_document_action_access created timestamp 29,6 now() Date this record was created
ad_form created timestamp 29,6 now() Date this record was created
ad_form_access created timestamp 29,6 now() Date this record was created
ad_importtemplateaccess created timestamp 29,6 statement_timestamp() Date this record was created
ad_infowindow_access created timestamp 29,6 statement_timestamp() Date this record was created
ad_ldapaccess created timestamp 29,6 now() Date this record was created
ad_ldapprocessorlog created timestamp 29,6 now() Date this record was created
ad_org created timestamp 29,6 now() Date this record was created
ad_password_history created timestamp 29,6 statement_timestamp() Date this record was created
ad_passwordrule created timestamp 29,6 statement_timestamp() Date this record was created
ad_private_access created timestamp 29,6 now() Date this record was created
ad_process created timestamp 29,6 now() Date this record was created
ad_process_access created timestamp 29,6 now() Date this record was created
ad_record_access created timestamp 29,6 now() Date this record was created
ad_role created timestamp 29,6 now() Date this record was created
ad_role_included created timestamp 29,6 statement_timestamp() Date this record was created
ad_role_orgaccess created timestamp 29,6 now() Date this record was created
ad_session created timestamp 29,6 now() Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
ad_table_access created timestamp 29,6 now() Date this record was created
ad_task created timestamp 29,6 now() Date this record was created
ad_task_access created timestamp 29,6 now() Date this record was created
ad_toolbarbuttonrestrict created timestamp 29,6 statement_timestamp() Date this record was created
ad_tree created timestamp 29,6 now() Date this record was created
ad_user created timestamp 29,6 now() Date this record was created
ad_user_orgaccess created timestamp 29,6 now() Date this record was created
ad_user_roles created timestamp 29,6 now() Date this record was created
ad_window created timestamp 29,6 now() Date this record was created
ad_window_access created timestamp 29,6 now() Date this record was created
ad_workflow created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
mfa_method created timestamp 29,6 statement_timestamp() Date this record was created
mfa_registereddevice created timestamp 29,6 statement_timestamp() Date this record was created
mfa_registration created timestamp 29,6 statement_timestamp() Date this record was created
mfa_rule created timestamp 29,6 statement_timestamp() Date this record was created
pa_dashboardcontent_access created timestamp 29,6 statement_timestamp() Date this record was created
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
ad_password_history datepasswordchanged timestamp 29,6  √  null Date Password Changed
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
mfa_registereddevice expiration timestamp 29,6  √  null Expire On
mfa_registration expiration timestamp 29,6  √  null Expire On
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
mfa_registration lastfailure timestamp 29,6  √  null Last Failure
mfa_registration lastsuccess timestamp 29,6  √  null Last Success
ad_session logindate timestamp 29,6  √  null Login date
mfa_registration mfaunregisteredat timestamp 29,6  √  null Unregistered at
mfa_registration mfavalidatedat timestamp 29,6  √  null Validated at
ad_attachment updated timestamp 29,6 now() Date this record was updated
ad_authorizationaccount updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_authorizationcredential updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_authorizationprovider updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_authorizationscopeprov updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_changelog updated timestamp 29,6 now() Date this record was updated
ad_column updated timestamp 29,6 now() Date this record was updated
ad_column_access updated timestamp 29,6 now() Date this record was updated
ad_document_action_access updated timestamp 29,6 now() Date this record was updated
ad_form updated timestamp 29,6 now() Date this record was updated
ad_form_access updated timestamp 29,6 now() Date this record was updated
ad_importtemplateaccess updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_infowindow_access updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_ldapaccess updated timestamp 29,6 now() Date this record was updated
ad_ldapprocessorlog updated timestamp 29,6 now() Date this record was updated
ad_org updated timestamp 29,6 now() Date this record was updated
ad_password_history updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_passwordrule updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_private_access updated timestamp 29,6 now() Date this record was updated
ad_process updated timestamp 29,6 now() Date this record was updated
ad_process_access updated timestamp 29,6 now() Date this record was updated
ad_record_access updated timestamp 29,6 now() Date this record was updated
ad_role updated timestamp 29,6 now() Date this record was updated
ad_role_included updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_role_orgaccess updated timestamp 29,6 now() Date this record was updated
ad_session updated timestamp 29,6 now() Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
ad_table_access updated timestamp 29,6 now() Date this record was updated
ad_task updated timestamp 29,6 now() Date this record was updated
ad_task_access updated timestamp 29,6 now() Date this record was updated
ad_toolbarbuttonrestrict updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_tree updated timestamp 29,6 now() Date this record was updated
ad_user updated timestamp 29,6 now() Date this record was updated
ad_user_orgaccess updated timestamp 29,6 now() Date this record was updated
ad_user_roles updated timestamp 29,6 now() Date this record was updated
ad_window updated timestamp 29,6 now() Date this record was updated
ad_window_access updated timestamp 29,6 now() Date this record was updated
ad_workflow updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
mfa_method updated timestamp 29,6 statement_timestamp() Date this record was updated
mfa_registereddevice updated timestamp 29,6 statement_timestamp() Date this record was updated
mfa_registration updated timestamp 29,6 statement_timestamp() Date this record was updated
mfa_rule updated timestamp 29,6 statement_timestamp() Date this record was updated
pa_dashboardcontent_access updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_workflow validfrom timestamp 29,6  √  null Valid from including this date (first day)
ad_workflow validto timestamp 29,6  √  null Valid to including this date (last day)
ad_column columnname varchar 30 Name of the column in the database
ad_workflow documentno varchar 30  √  null Document sequence number of the document
ad_column fkconstraintname varchar 30  √  NULL::character varying Constraint Name
ad_attachment ad_attachment_uu varchar 36  √  NULL::character varying AD_Attachment_UU
ad_authorizationaccount ad_authorizationaccount_uu varchar 36  √  NULL::character varying AD_AuthorizationAccount_UU
ad_authorizationcredential ad_authorizationcredential_uu varchar 36  √  NULL::character varying AD_AuthorizationCredential_UU
ad_authorizationprovider ad_authorizationprovider_uu varchar 36  √  NULL::character varying AD_AuthorizationProvider_UU
ad_authorizationscopeprov ad_authorizationscopeprov_uu varchar 36  √  NULL::character varying AD_AuthorizationScopeProv_UU
ad_changelog ad_changelog_uu varchar 36  √  NULL::character varying AD_ChangeLog_UU
ad_column_access ad_column_access_uu varchar 36  √  NULL::character varying AD_Column_Access_UU
ad_column ad_column_uu varchar 36  √  NULL::character varying AD_Column_UU
ad_document_action_access ad_document_action_access_uu varchar 36  √  NULL::character varying AD_Document_Action_Access_UU
ad_form_access ad_form_access_uu varchar 36  √  NULL::character varying AD_Form_Access_UU
ad_form ad_form_uu varchar 36  √  NULL::character varying AD_Form_UU
ad_importtemplateaccess ad_importtemplateaccess_uu varchar 36  √  NULL::character varying AD_ImportTemplateAccess_UU
ad_infowindow_access ad_infowindow_access_uu varchar 36  √  NULL::character varying AD_InfoWindow_Access_UU
ad_ldapaccess ad_ldapaccess_uu varchar 36  √  NULL::character varying AD_LdapAccess_UU
ad_ldapprocessorlog ad_ldapprocessorlog_uu varchar 36  √  NULL::character varying AD_LdapProcessorLog_UU
ad_org ad_org_uu varchar 36  √  NULL::character varying AD_Org_UU
ad_password_history ad_password_history_uu varchar 36  √  NULL::character varying AD_Password_History_UU
ad_passwordrule ad_passwordrule_uu varchar 36  √  NULL::character varying AD_PasswordRule_UU
ad_private_access ad_private_access_uu varchar 36  √  NULL::character varying AD_Private_Access_UU
ad_process_access ad_process_access_uu varchar 36  √  NULL::character varying AD_Process_Access_UU
ad_process ad_process_uu varchar 36  √  NULL::character varying AD_Process_UU
ad_record_access ad_record_access_uu varchar 36  √  NULL::character varying AD_Record_Access_UU
ad_role_included ad_role_included_uu varchar 36  √  NULL::character varying AD_Role_Included_UU
ad_role_orgaccess ad_role_orgaccess_uu varchar 36  √  NULL::character varying AD_Role_OrgAccess_UU
ad_role ad_role_uu varchar 36  √  NULL::character varying AD_Role_UU
ad_session ad_session_uu varchar 36  √  NULL::character varying AD_Session_UU
ad_table_access ad_table_access_uu varchar 36  √  NULL::character varying AD_Table_Access_UU
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
ad_task_access ad_task_access_uu varchar 36  √  NULL::character varying AD_Task_Access_UU
ad_task ad_task_uu varchar 36  √  NULL::character varying AD_Task_UU
ad_toolbarbuttonrestrict ad_toolbarbuttonrestrict_uu varchar 36  √  NULL::character varying AD_ToolBarButtonRestrict_UU
ad_tree ad_tree_uu varchar 36  √  NULL::character varying AD_Tree_UU
ad_user_orgaccess ad_user_orgaccess_uu varchar 36  √  NULL::character varying AD_User_OrgAccess_UU
ad_user_roles ad_user_roles_uu varchar 36  √  NULL::character varying AD_User_Roles_UU
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
ad_window_access ad_window_access_uu varchar 36  √  NULL::character varying AD_Window_Access_UU
ad_window ad_window_uu varchar 36  √  NULL::character varying AD_Window_UU
ad_workflow ad_workflow_uu varchar 36  √  NULL::character varying AD_Workflow_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
mfa_method mfa_method_uu varchar 36  √  NULL::character varying MFA_Method_UU
mfa_registereddevice mfa_registereddevice_uu varchar 36  √  NULL::character varying MFA_RegisteredDevice_UU
mfa_registration mfa_registration_uu varchar 36  √  NULL::character varying MFA_Registration_UU
mfa_rule mfa_rule_uu varchar 36  √  NULL::character varying MFA_Rule_UU
pa_dashboardcontent_access pa_dashboardcontent_access_uu varchar 36  √  NULL::character varying PA_DashboardContent_Access_UU
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_column entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_form entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_task entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_window entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_workflow entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_user fax varchar 40  √  null Facsimile number
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
ad_table tablename varchar 40 Name of the table in the database
ad_user title varchar 40  √  null Name this entity is referred to as
ad_org value varchar 40 Search key for the record in the format required - must be unique
ad_process value varchar 40 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
ad_workflow value varchar 40 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
ad_session websession varchar 40  √  null Web Session ID
ad_process workflowvalue varchar 40  √  null Key of the Workflow to start
ad_user bpname varchar 60  √  NULL::character varying BP Name
ad_form classname varchar 60  √  null Java Classname
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
ad_user email varchar 60  √  null Electronic Mail Address
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
mfa_method method varchar 60 Method
ad_authorizationcredential name varchar 60 Alphanumeric identifier of the entity
ad_authorizationprovider name varchar 60 Alphanumeric identifier of the entity
ad_column name varchar 60 Alphanumeric identifier of the entity
ad_form name varchar 60 Alphanumeric identifier of the entity
ad_org name varchar 60 Alphanumeric identifier of the entity
ad_passwordrule name varchar 60 NULL::character varying Alphanumeric identifier of the entity
ad_process name varchar 60 Alphanumeric identifier of the entity
ad_role name varchar 60 Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
ad_task name varchar 60 Alphanumeric identifier of the entity
ad_tree name varchar 60 Alphanumeric identifier of the entity
ad_user name varchar 60 Alphanumeric identifier of the entity
ad_window name varchar 60 Alphanumeric identifier of the entity
ad_workflow name varchar 60 Alphanumeric identifier of the entity
mfa_method name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
ad_process procedurename varchar 60  √  null Name of the Database Procedure
ad_ldapprocessorlog reference varchar 60  √  null Reference for this record
ad_session remote_addr varchar 60  √  null Remote Address
ad_attachment title varchar 60 Name this entity is referred to as
ad_session servername varchar 80  √  NULL::character varying Server Name
ad_form jspurl varchar 120  √  null Web URL of the jsp function
c_bpartner name varchar 120 Alphanumeric identifier of the entity
ad_session remote_host varchar 120  √  null Remote host Info
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_authorizationaccount email varchar 200  √  NULL::character varying Electronic Mail Address
ad_authorizationaccount ad_authorizationscopes varchar 255  √  NULL::character varying Authorization Scopes
ad_column callout varchar 255  √  null Fully qualified class names and method - separated by semicolons
ad_process classname varchar 255  √  null Java Classname
ad_authorizationprovider description varchar 255  √  NULL::character varying Optional short description of the record
ad_changelog description varchar 255  √  null Optional short description of the record
ad_column description varchar 255  √  null Optional short description of the record
ad_form description varchar 255  √  null Optional short description of the record
ad_ldapaccess description varchar 255  √  null Optional short description of the record
ad_ldapprocessorlog description varchar 255  √  null Optional short description of the record
ad_org description varchar 255  √  null Optional short description of the record
ad_process description varchar 255  √  null Optional short description of the record
ad_role description varchar 255  √  null Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
ad_task description varchar 255  √  null Optional short description of the record
ad_tree description varchar 255  √  null Optional short description of the record
ad_user description varchar 255  √  null Optional short description of the record
ad_window description varchar 255  √  null Optional short description of the record
ad_workflow description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
mfa_method description varchar 255  √  NULL::character varying Optional short description of the record
ad_user emailuserpw varchar 255  √  null Password of your email user id
ad_column infofactoryclass varchar 255  √  null Fully qualified class name that implements the InfoFactory interface
ad_process jasperreport varchar 255  √  null Jasper Report
ad_user lastresult varchar 255  √  null Result of last contact
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
mfa_method mfatimeserver varchar 255  √  NULL::character varying Time Server
ad_passwordrule pathdictionary varchar 255  √  NULL::character varying Path Dictionary
ad_column placeholder varchar 255  √  NULL::character varying Placeholder
c_bpartner so_description varchar 255  √  null Description to be used on orders
ad_window titlelogic varchar 255  √  NULL::character varying The result determines the title to be displayed for this window
ad_column vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
mfa_registration name varchar 1000  √  NULL::character varying Alphanumeric identifier of the entity
ad_changelog trxname varchar 1000  √  null Name of the transaction
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_password_history password varchar 1024  √  NULL::character varying Password of any length (case sensitive)
ad_user password varchar 1024  √  null Password of any length (case sensitive)
ad_user securityquestion varchar 1024  √  null Security Question
ad_authorizationcredential ad_authorizationscopelist varchar 2000 NULL::character varying Scope List
ad_authorizationcredential authorizationclientid varchar 2000 NULL::character varying Authorization client-id
ad_authorizationcredential authorizationclientsecret varchar 2000 NULL::character varying Authorization client-secret
ad_authorizationprovider authorizationendpoint varchar 2000 NULL::character varying Authorization Endpoint
ad_authorizationcredential authorizationredirecturl varchar 2000 NULL::character varying Authorization Redirect URL
ad_user comments varchar 2000  √  null Comments or additional information
ad_column defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_session description varchar 2000  √  null Optional short description of the record
ad_workflow docvaluelogic varchar 2000  √  null Logic to determine Workflow Start - If true, a workflow process is started for the document
ad_authorizationaccount help varchar 2000  √  NULL::character varying Comment or Hint
ad_authorizationcredential help varchar 2000  √  NULL::character varying Comment or Hint
ad_authorizationprovider help varchar 2000  √  NULL::character varying Comment or Hint
ad_column help varchar 2000  √  null Comment or Hint
ad_form help varchar 2000  √  null Comment or Hint
ad_process help varchar 2000  √  null Comment or Hint
ad_table help varchar 2000  √  null Comment or Hint
ad_task help varchar 2000  √  null Comment or Hint
ad_window help varchar 2000  √  null Comment or Hint
mfa_method help varchar 2000  √  NULL::character varying Comment or Hint
mfa_registereddevice help varchar 2000  √  NULL::character varying Comment or Hint
mfa_registration help varchar 2000  √  NULL::character varying Comment or Hint
mfa_rule help varchar 2000  √  NULL::character varying Comment or Hint
ad_column mandatorylogic varchar 2000  √  null Mandatory Logic
mfa_registereddevice mfadeviceidentifier varchar 2000 Multi-factor Authentication Device Identifier
mfa_method mfaissuer varchar 2000  √  NULL::character varying Issuer
mfa_registration mfalastsecret varchar 2000  √  NULL::character varying Last MFA Secret
mfa_registration mfasecret varchar 2000  √  NULL::character varying Multi-factor Authentication Secret
ad_changelog newvalue varchar 2000  √  null New field value
ad_changelog oldvalue varchar 2000  √  null The old file data
ad_task os_command varchar 2000 Operating System Command
mfa_registration parametervalue varchar 2000  √  NULL::character varying Parameter Value
ad_column readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_authorizationprovider revokeendpoint varchar 2000  √  NULL::character varying Revoke Endpoint
ad_authorizationscopeprov scopeurl varchar 2000 NULL::character varying Scope URL
ad_ldapaccess summary varchar 2000  √  null Textual summary of this request
ad_ldapprocessorlog summary varchar 2000  √  null Textual summary of this request
ad_attachment textmsg varchar 2000  √  null Text Message
ad_ldapprocessorlog textmsg varchar 2000  √  null Text Message
ad_authorizationprovider tokenendpoint varchar 2000 NULL::character varying Token Endpoint
ad_authorizationaccount accesstoken varchar 4000  √  null Access Token
ad_column columnsql varchar 4000  √  null Virtual Column (r/o)
ad_window predefinedcontextvariables varchar 4000  √  NULL::character varying Predefined context variables to inject when opening a menu entry or a window
ad_authorizationaccount refreshtoken varchar 4000  √  null Refresh Token
ad_attachment binarydata bytea 2147483647  √  null Binary Data
ad_ldapprocessorlog binarydata bytea 2147483647  √  null Binary Data
ad_workflow help text 2147483647  √  null Comment or Hint