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

idempiere9.adempiere contains 1102 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
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_process statistic_seconds numeric 0  √  null Internal statistics how many seconds a process took
ad_attribute_value v_number numeric 0  √  null Number
ad_column version numeric 0 Version of the table definition
ad_process accesslevel bpchar 1 Access Level required
ad_rule accesslevel bpchar 1  √  null Access Level required
ad_table accesslevel bpchar 1 Access Level required
ad_toolbarbutton action bpchar 1 'W'::bpchar 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_sysconfig configurationlevel bpchar 1  √  'S'::bpchar Configuration Level for this parameter
ad_role 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
ad_searchdefinition datatype varchar 1 Type of data
ad_viewcolumn dbdatatype bpchar 1  √  NULL::bpchar Database Data Type
ad_rule eventtype bpchar 1  √  null Type of Event
ad_process executiontype bpchar 1  √  NULL::bpchar Execution Type defines whether the report/process will always run in background or foreground.
ad_fieldgroup fieldgrouptype bpchar 1  √  null Field Group Type
ad_column fkconstrainttype bpchar 1  √  'N'::bpchar Constraint Type
ad_tab hastree bpchar 1 'N'::bpchar Window has Tree Graph
ad_tab importfields bpchar 1  √  null Create Fields from Table Columns
ad_table importtable bpchar 1  √  null Import Table Columns from Database
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_attribute 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_element isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_field isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_fieldgroup isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_indexcolumn isactive bpchar 1 The record is active in the system
ad_infocolumn isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_infoprocess isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_inforelated isactive bpchar 1 The record is active in the system
ad_infowindow 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_message isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_modelvalidator isactive bpchar 1 The record is active in the system
ad_process isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process_para isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_ref_list isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_ref_table isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_reference isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_relationtype 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_rule isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_searchdefinition isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_statusline isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_statuslineusedin isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_style isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_styleline isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_sysconfig isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_tab isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_tab_customization isactive bpchar 1 The record is active in the system
ad_table isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table_scriptvalidator isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_tableindex isactive bpchar 1 The record is active in the system
ad_toolbarbutton isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userdef_field isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userdef_info isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userdef_info_column isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userdef_info_related isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userdef_proc isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userdef_proc_parameter isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userdef_tab isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userdef_win isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_val_rule isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_viewcolumn isactive bpchar 1 The record is active in the system
ad_viewcomponent isactive bpchar 1 The record is active in the system
ad_window isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_zoomcondition isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_toolbarbutton isaddseparator bpchar 1 'N'::bpchar Add Separator
ad_toolbarbutton isadvancedbutton bpchar 1 'N'::bpchar This Button contains advanced Functionality
ad_field isadvancedfield bpchar 1  √  'N'::bpchar Advanced Field
ad_tab isadvancedtab bpchar 1 'N'::bpchar This Tab contains advanced Functionality
ad_tab isallowadvancedlookup bpchar 1  √  'Y'::bpchar Allow Advanced Lookup
ad_userdef_tab isallowadvancedlookup bpchar 1  √  NULL::bpchar Allow Advanced Lookup
ad_column isallowcopy bpchar 1 'Y'::bpchar Determine if a column must be copied when pushing the button to copy record
ad_field isallowcopy bpchar 1  √  NULL::bpchar Determine if a column must be copied when pushing the button to copy record
ad_column isallowlogging bpchar 1  √  'Y'::bpchar Determine if a column must be recorded into the change log
ad_column isalwaysupdateable bpchar 1 'N'::bpchar The column is always updateable, even if the record is not active or processed
ad_field isalwaysupdateable bpchar 1  √  NULL::bpchar The column is always updateable, even if the record is not active or processed
ad_userdef_field isalwaysupdateable bpchar 1  √  NULL::bpchar The column is always updateable, even if the record is not active or processed
ad_column isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
ad_infocolumn isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
ad_process_para isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
ad_userdef_field isautocomplete bpchar 1  √  NULL::bpchar Automatic completion for textfields
ad_userdef_info_column isautocomplete bpchar 1  √  NULL::bpchar Automatic completion for textfields
ad_tab_customization isautohideemptycolumn bpchar 1  √  NULL::bpchar Auto Hide Empty Column
ad_language isbaselanguage bpchar 1 'N'::bpchar The system information is maintained in this language
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_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_role iscanreport bpchar 1 'Y'::bpchar Users with this role can create reports
ad_field iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
ad_infocolumn iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
ad_process_para iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
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
ad_fieldgroup iscollapsedbydefault bpchar 1  √  'N'::bpchar Flag to set the initial state of collapsible field group.
ad_tableindex iscreateconstraint bpchar 1 'N'::bpchar Create Constraint
ad_toolbarbutton iscustomization bpchar 1 'N'::bpchar The change is a customization of the data dictionary and can be applied after Migration
ad_language isdecimalpoint bpchar 1  √  null The number notation has a decimal point (no decimal comma)
ad_infowindow isdefault bpchar 1 'N'::bpchar Default value
ad_searchdefinition isdefault bpchar 1 'N'::bpchar Default value
ad_userdef_win isdefault bpchar 1 'N'::bpchar Default value
ad_window isdefault bpchar 1 'N'::bpchar Default value
ad_field isdefaultfocus bpchar 1 'N'::bpchar Default Focus
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
ad_relationtype isdirected bpchar 1 'N'::bpchar Tells whether one "sees" the other end of the relation from each end or just from the source
ad_process isdirectprint bpchar 1  √  'N'::bpchar Print without dialog
ad_role isdiscountallowedontotal bpchar 1 'N'::bpchar IsDiscountAllowedOnTotal
ad_role isdiscountuptolimitprice bpchar 1 'N'::bpchar IsDiscountUptoLimitPrice
ad_field isdisplayed bpchar 1 'Y'::bpchar Determines, if this field is displayed
ad_infocolumn isdisplayed bpchar 1 'Y'::bpchar Determines, if this field is displayed
ad_userdef_field isdisplayed bpchar 1  √  null Determines, if this field is displayed
ad_userdef_info_column isdisplayed bpchar 1  √  NULL::bpchar Determines, if this field is displayed
ad_userdef_proc_parameter isdisplayed bpchar 1  √  null Determines, if this field is displayed
ad_field isdisplayedgrid bpchar 1  √  'Y'::bpchar Show in Grid
ad_tab_customization isdisplayedgrid bpchar 1  √  NULL::bpchar Show in Grid
ad_userdef_field isdisplayedgrid bpchar 1  √  NULL::bpchar Show in Grid
ad_infowindow isdistinct bpchar 1 'N'::bpchar Select Distinct
ad_attribute isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_column isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_field isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_process_para isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_attribute isfieldonly bpchar 1 'N'::bpchar Label is not displayed
ad_field isfieldonly bpchar 1 'N'::bpchar Label is not displayed
ad_attribute isheading bpchar 1 'N'::bpchar Field without Column - Only label is displayed
ad_field isheading bpchar 1 'N'::bpchar Field without Column - Only label is displayed
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_infocolumn isidentifier bpchar 1 'N'::bpchar This column is part of the record identifier
ad_tab isinfotab bpchar 1  √  'N'::bpchar This Tab contains accounting information
ad_tab isinsertrecord bpchar 1 'Y'::bpchar The user can insert a new Record
ad_column iskey bpchar 1 'N'::bpchar This column is the key in this table
ad_infocolumn iskey bpchar 1  √  NULL::bpchar This column is the key in this table
ad_tableindex iskey bpchar 1 'N'::bpchar This column is the key in this table
ad_infowindow isloadpagenum bpchar 1  √  'Y'::bpchar When load data for info window, also load number of paging
ad_language isloginlocale bpchar 1  √  'N'::bpchar Login Locale
ad_tab islookuponlyselection bpchar 1  √  'N'::bpchar When defined to true Lookup panel will display only selection columns. Default to false.
ad_userdef_tab islookuponlyselection bpchar 1  √  NULL::bpchar When defined to true Lookup panel will display only selection columns. Default to false.
ad_attribute ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_column ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_field ismandatory bpchar 1  √  null Data entry is required in this column
ad_infocolumn ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_process_para ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_userdef_field ismandatory bpchar 1  √  NULL::bpchar Data entry is required in this column
ad_userdef_info_column ismandatory bpchar 1  √  NULL::bpchar Data entry is required in this column
ad_userdef_proc_parameter ismandatory bpchar 1  √  NULL::bpchar Data entry is required in this column
ad_role ismanual bpchar 1 'Y'::bpchar This is a manual process
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_userdef_tab ismultirowonly bpchar 1 'N'::bpchar This applies to Multi-Row view only
ad_reference isorderbyvalue bpchar 1  √  'N'::bpchar Order list using the value column instead of the name column
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
ad_infocolumn isquerycriteria bpchar 1 'N'::bpchar The column is also used as a query criteria
ad_userdef_info_column isquerycriteria bpchar 1  √  NULL::bpchar The column is also used as a query criteria
ad_field isquickentry bpchar 1 'N'::bpchar Quick Entry
ad_field isquickform bpchar 1 'N'::bpchar Display in Quick Form
ad_tab_customization isquickform bpchar 1  √  'N'::bpchar Display in Quick Form
ad_process_para isrange bpchar 1 'N'::bpchar The parameter is a range of values
ad_userdef_proc_parameter isrange bpchar 1  √  NULL::bpchar The parameter is a range of values
ad_attribute isreadonly bpchar 1 'N'::bpchar Field is read only
ad_field isreadonly bpchar 1 'N'::bpchar Field is read only
ad_infocolumn isreadonly bpchar 1 'Y'::bpchar Field is read only
ad_tab isreadonly bpchar 1 'N'::bpchar Field is read only
ad_userdef_field isreadonly bpchar 1  √  null Field is read only
ad_userdef_info_column isreadonly bpchar 1  √  NULL::bpchar Field is read only
ad_userdef_tab isreadonly bpchar 1  √  null Field is read only
ad_userdef_win isreadonly bpchar 1 'N'::bpchar Field is read only
ad_process isreport bpchar 1 'Y'::bpchar Indicates a Report record
ad_attribute issameline bpchar 1 'N'::bpchar Displayed on same line as previous field
ad_field issameline bpchar 1 'N'::bpchar Displayed on same line as previous field
ad_userdef_field issameline bpchar 1  √  null Displayed on same line as previous field
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_field isselectioncolumn bpchar 1  √  NULL::bpchar Is this column used for finding rows in windows
ad_process isserverprocess bpchar 1  √  null Run this Process on Server only
ad_role isshowacct bpchar 1 'Y'::bpchar Users with this role can see accounting information
ad_infowindow isshowindashboard bpchar 1 'Y'::bpchar Show the dashlet in the dashboard
ad_userdef_info isshowindashboard bpchar 1  √  NULL::bpchar Show the dashlet in the dashboard
ad_toolbarbutton isshowmore bpchar 1  √  'N'::bpchar Group in show more
ad_tab issinglerow bpchar 1 'Y'::bpchar Default for toggle between Single- and Multi-Row (Grid) Layout
ad_userdef_tab issinglerow bpchar 1  √  null Default for toggle between Single- and Multi-Row (Grid) Layout
ad_tab issorttab bpchar 1 'N'::bpchar The Tab determines the Order
ad_window issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
ad_statuslineusedin isstatusline bpchar 1 'Y'::bpchar Defines if this record refers to a status line or to a help widget
ad_column issyncdatabase bpchar 1  √  'N'::bpchar Change database table definition when changing dictionary definition
ad_language issystemlanguage bpchar 1 'N'::bpchar The screens, etc. are maintained in this Language
ad_column istoolbarbutton bpchar 1 'Y'::bpchar Show the button on the toolbar, the window, or both
ad_field istoolbarbutton bpchar 1  √  null Show the button on the toolbar, the window, or both
ad_userdef_field istoolbarbutton bpchar 1  √  null Show the button on the toolbar, the window, or both
ad_column istranslated bpchar 1 'N'::bpchar This column is translated
ad_tab istranslationtab bpchar 1 'N'::bpchar This Tab contains translation information
ad_viewcomponent isunionall bpchar 1 'N'::bpchar The component view is UNION ALL
ad_tableindex isunique bpchar 1 'N'::bpchar Unique
ad_attribute isupdateable bpchar 1 'Y'::bpchar Determines, if the field can be updated
ad_column isupdateable bpchar 1 'Y'::bpchar Determines, if the field can be updated
ad_field isupdateable bpchar 1  √  NULL::bpchar Determines, if the field can be updated
ad_userdef_field isupdateable bpchar 1  √  null Determines, if the field can be updated
ad_userdef_proc isuserupdateable bpchar 1  √  NULL::bpchar The field can be updated by the user
ad_userdef_win isuserupdateable bpchar 1 'Y'::bpchar The field can be updated by the user
ad_role isuseuserorgaccess bpchar 1 'N'::bpchar Use Org Access defined by user instead of Role Org Access
ad_infowindow isvalid bpchar 1 'N'::bpchar Element is valid
ad_ref_table isvaluedisplayed bpchar 1 'N'::bpchar Displays Value column with the Display column
ad_table isview bpchar 1 'N'::bpchar This is a view
ad_message msgtype bpchar 1 Type of message (Informational, Menu or Error)
ad_role overwritepricelimit bpchar 1 'N'::bpchar Overwrite Price Limit if the Price List enforces the Price Limit
ad_role preferencetype bpchar 1 'C'::bpchar Determines what preferences the user can set
ad_infowindow processing bpchar 1  √  null Process Now
ad_language processing bpchar 1  √  null Process Now
ad_tab processing bpchar 1  √  null Process Now
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_tableindex processing bpchar 1  √  NULL::bpchar Process Now
ad_window processing bpchar 1  √  null Process Now
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_rule ruletype bpchar 1  √  null Rule Type
ad_searchdefinition searchtype varchar 1 Which kind of search is used (Query or Table)
ad_process showhelp bpchar 1  √  'Y'::bpchar Show Help
ad_tableindex tableindexdrop bpchar 1  √  NULL::bpchar Drop table index
ad_tab treedisplayedon bpchar 1 'B'::bpchar The tree can be displayed on master tab, detail tab or both
ad_relationtype type bpchar 1 'I'::bpchar Type of Validation (SQL, Java Script, Java Language)
ad_val_rule type bpchar 1  √  null Type of Validation (SQL, Java Script, Java Language)
ad_reference validationtype bpchar 1 Different method of validating data
ad_window windowtype bpchar 1  √  null Type or classification of a Window
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
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_role roletype varchar 2  √  NULL::character varying Role Type
ad_field obscuretype bpchar 3  √  null Type of obscuring the data (limiting the display)
ad_role userlevel bpchar 3 ' O'::bpchar System Client Organization
ad_table_scriptvalidator eventmodelvalidator varchar 4 Event Model Validator
ad_language ad_language varchar 6 Language for this entity
ad_userdef_info ad_language varchar 6  √  NULL::character varying Language for this entity
ad_userdef_proc ad_language varchar 6  √  NULL::character varying Language for this entity
ad_userdef_win ad_language varchar 6  √  null Language for this entity
ad_searchdefinition transactioncode varchar 8  √  null The transaction code represents the search definition
ad_attribute ad_attribute_id numeric 10 System Attribute
ad_attribute_value ad_attribute_id numeric 10 System Attribute
ad_column ad_chart_id numeric 10  √  NULL::numeric Chart
ad_attribute ad_client_id numeric 10 Client/Tenant for this installation.
ad_column ad_client_id numeric 10 Client/Tenant for this installation.
ad_element ad_client_id numeric 10 Client/Tenant for this installation.
ad_field ad_client_id numeric 10 Client/Tenant for this installation.
ad_fieldgroup ad_client_id numeric 10 Client/Tenant for this installation.
ad_indexcolumn ad_client_id numeric 10 Client/Tenant for this installation.
ad_infocolumn ad_client_id numeric 10 Client/Tenant for this installation.
ad_infoprocess ad_client_id numeric 10 Client/Tenant for this installation.
ad_inforelated ad_client_id numeric 10 Client/Tenant for this installation.
ad_infowindow ad_client_id numeric 10 Client/Tenant for this installation.
ad_language ad_client_id numeric 10 Client/Tenant for this installation.
ad_message ad_client_id numeric 10 Client/Tenant for this installation.
ad_modelvalidator ad_client_id numeric 10 0 Client/Tenant for this installation.
ad_process ad_client_id numeric 10 Client/Tenant for this installation.
ad_process_para ad_client_id numeric 10 Client/Tenant for this installation.
ad_ref_list ad_client_id numeric 10 Client/Tenant for this installation.
ad_ref_table ad_client_id numeric 10 Client/Tenant for this installation.
ad_reference ad_client_id numeric 10 Client/Tenant for this installation.
ad_relationtype ad_client_id numeric 10 Client/Tenant for this installation.
ad_role ad_client_id numeric 10 Client/Tenant for this installation.
ad_rule ad_client_id numeric 10 Client/Tenant for this installation.
ad_searchdefinition ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
ad_statusline ad_client_id numeric 10 Client/Tenant for this installation.
ad_statuslineusedin ad_client_id numeric 10 Client/Tenant for this installation.
ad_style ad_client_id numeric 10 Client/Tenant for this installation.
ad_styleline ad_client_id numeric 10 Client/Tenant for this installation.
ad_sysconfig ad_client_id numeric 10 Client/Tenant for this installation.
ad_tab ad_client_id numeric 10 Client/Tenant for this installation.
ad_tab_customization ad_client_id numeric 10 Client/Tenant for this installation.
ad_table ad_client_id numeric 10 Client/Tenant for this installation.
ad_table_scriptvalidator ad_client_id numeric 10 Client/Tenant for this installation.
ad_tableindex ad_client_id numeric 10 Client/Tenant for this installation.
ad_toolbarbutton ad_client_id numeric 10 Client/Tenant for this installation.
ad_userdef_field ad_client_id numeric 10 Client/Tenant for this installation.
ad_userdef_info ad_client_id numeric 10 Client/Tenant for this installation.
ad_userdef_info_column ad_client_id numeric 10 Client/Tenant for this installation.
ad_userdef_info_related ad_client_id numeric 10 Client/Tenant for this installation.
ad_userdef_proc ad_client_id numeric 10 Client/Tenant for this installation.
ad_userdef_proc_parameter ad_client_id numeric 10 Client/Tenant for this installation.
ad_userdef_tab ad_client_id numeric 10 Client/Tenant for this installation.
ad_userdef_win ad_client_id numeric 10 Client/Tenant for this installation.
ad_val_rule ad_client_id numeric 10 Client/Tenant for this installation.
ad_viewcolumn ad_client_id numeric 10 Client/Tenant for this installation.
ad_viewcomponent ad_client_id numeric 10 Client/Tenant for this installation.
ad_window ad_client_id numeric 10 Client/Tenant for this installation.
ad_zoomcondition ad_client_id numeric 10 Client/Tenant for this installation.
ad_window ad_color_id numeric 10  √  null Color for backgrounds or indicators
ad_column ad_column_id numeric 10 Column in the table
ad_field ad_column_id numeric 10  √  null Column in the table
ad_indexcolumn ad_column_id numeric 10  √  null Column in the table
ad_searchdefinition ad_column_id numeric 10  √  null Column in the table
ad_tab ad_column_id numeric 10  √  null Column in the table
ad_tab ad_columnsortorder_id numeric 10  √  null Column determining the order
ad_tab ad_columnsortyesno_id numeric 10  √  null Column determining if a Table Column is included in Ordering
ad_infowindow ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_process ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_tab ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_ref_table ad_display numeric 10 Column that will display
ad_column ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_element ad_element_id numeric 10 System Element enables the central maintenance of column description and help.
ad_infocolumn ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_process_para ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_reference ad_element_id numeric 10  √  NULL::numeric System Element enables the central maintenance of column description and help.
ad_field ad_field_id numeric 10 Field on a database table
ad_userdef_field ad_field_id numeric 10 Field on a database table
ad_field ad_fieldgroup_id numeric 10  √  null Logical grouping of fields
ad_fieldgroup ad_fieldgroup_id numeric 10 Logical grouping of fields
ad_process_para ad_fieldgroup_id numeric 10  √  NULL::numeric Logical grouping of fields
ad_userdef_field ad_fieldgroup_id numeric 10  √  NULL::numeric Logical grouping of fields
ad_userdef_proc_parameter ad_fieldgroup_id numeric 10  √  NULL::numeric Logical grouping of fields
ad_field ad_fieldstyle_id numeric 10  √  NULL::numeric Field CSS Style
ad_infocolumn ad_fieldstyle_id numeric 10  √  NULL::numeric Field CSS Style
ad_userdef_field ad_fieldstyle_id numeric 10  √  NULL::numeric Field CSS Style
ad_userdef_info_column ad_fieldstyle_id numeric 10  √  NULL::numeric Field CSS Style
ad_process ad_form_id numeric 10  √  null Special Form
ad_tab ad_image_id numeric 10  √  null Image or Icon
ad_window ad_image_id numeric 10  √  null Image or Icon
ad_indexcolumn ad_indexcolumn_id numeric 10 Table Index Column
ad_infocolumn ad_infocolumn_id numeric 10 Info Window Column
ad_infoprocess ad_infocolumn_id numeric 10  √  null Info Window Column
ad_userdef_info_column ad_infocolumn_id numeric 10 Info Window Column
ad_infoprocess ad_infoprocess_id numeric 10 Info Process
ad_inforelated ad_inforelated_id numeric 10 InfoRelated
ad_userdef_info_related ad_inforelated_id numeric 10 InfoRelated
ad_infocolumn ad_infowindow_id numeric 10 Info and search/select Window
ad_infoprocess ad_infowindow_id numeric 10  √  NULL::numeric Info and search/select Window
ad_inforelated ad_infowindow_id numeric 10 Info and search/select Window
ad_infowindow ad_infowindow_id numeric 10 Info and search/select Window
ad_ref_table ad_infowindow_id numeric 10  √  NULL::numeric Info and search/select Window
ad_userdef_info ad_infowindow_id numeric 10 Info and search/select Window
ad_ref_table ad_key numeric 10 Unique identifier of a record
ad_field ad_labelstyle_id numeric 10  √  NULL::numeric Label CSS Style
ad_userdef_field ad_labelstyle_id numeric 10  √  NULL::numeric Label CSS Style
ad_language ad_language_id numeric 10 Language ID
ad_message ad_message_id numeric 10 System Message
ad_statusline ad_message_id numeric 10 System Message
ad_tableindex ad_message_id numeric 10  √  NULL::numeric System Message
ad_modelvalidator ad_modelvalidator_id numeric 10 Model Validator
ad_attribute ad_org_id numeric 10 Organizational entity within client
ad_column ad_org_id numeric 10 Organizational entity within client
ad_element ad_org_id numeric 10 Organizational entity within client
ad_field ad_org_id numeric 10 Organizational entity within client
ad_fieldgroup ad_org_id numeric 10 Organizational entity within client
ad_indexcolumn ad_org_id numeric 10 Organizational entity within client
ad_infocolumn ad_org_id numeric 10 Organizational entity within client
ad_infoprocess ad_org_id numeric 10 Organizational entity within client
ad_inforelated ad_org_id numeric 10 Organizational entity within client
ad_infowindow ad_org_id numeric 10 Organizational entity within client
ad_language ad_org_id numeric 10 Organizational entity within client
ad_message ad_org_id numeric 10 Organizational entity within client
ad_modelvalidator ad_org_id numeric 10 0 Organizational entity within client
ad_process ad_org_id numeric 10 Organizational entity within client
ad_process_para ad_org_id numeric 10 Organizational entity within client
ad_ref_list ad_org_id numeric 10 Organizational entity within client
ad_ref_table ad_org_id numeric 10 Organizational entity within client
ad_reference ad_org_id numeric 10 Organizational entity within client
ad_relationtype ad_org_id numeric 10 Organizational entity within client
ad_role ad_org_id numeric 10 Organizational entity within client
ad_rule ad_org_id numeric 10 Organizational entity within client
ad_searchdefinition ad_org_id numeric 10 NULL::numeric Organizational entity within client
ad_statusline ad_org_id numeric 10 Organizational entity within client
ad_statuslineusedin ad_org_id numeric 10 Organizational entity within client
ad_style ad_org_id numeric 10 Organizational entity within client
ad_styleline ad_org_id numeric 10 Organizational entity within client
ad_sysconfig ad_org_id numeric 10 Organizational entity within client
ad_tab ad_org_id numeric 10 Organizational entity within client
ad_tab_customization ad_org_id numeric 10 Organizational entity within client
ad_table ad_org_id numeric 10 Organizational entity within client
ad_table_scriptvalidator ad_org_id numeric 10 Organizational entity within client
ad_tableindex ad_org_id numeric 10 Organizational entity within client
ad_toolbarbutton ad_org_id numeric 10 Organizational entity within client
ad_userdef_field ad_org_id numeric 10 Organizational entity within client
ad_userdef_info ad_org_id numeric 10 Organizational entity within client
ad_userdef_info_column ad_org_id numeric 10 Organizational entity within client
ad_userdef_info_related ad_org_id numeric 10 Organizational entity within client
ad_userdef_proc ad_org_id numeric 10 Organizational entity within client
ad_userdef_proc_parameter ad_org_id numeric 10 Organizational entity within client
ad_userdef_tab ad_org_id numeric 10 Organizational entity within client
ad_userdef_win ad_org_id numeric 10 Organizational entity within client
ad_val_rule ad_org_id numeric 10 Organizational entity within client
ad_viewcolumn ad_org_id numeric 10 Organizational entity within client
ad_viewcomponent ad_org_id numeric 10 Organizational entity within client
ad_window ad_org_id numeric 10 Organizational entity within client
ad_zoomcondition ad_org_id numeric 10 Organizational entity within client
ad_process ad_printformat_id numeric 10  √  null Data Print Format
ad_language ad_printpaper_id numeric 10  √  NULL::numeric Printer paper definition
ad_column ad_process_id numeric 10  √  null Process or Report
ad_infoprocess ad_process_id numeric 10 Process or Report
ad_infowindow ad_process_id numeric 10  √  NULL::numeric Process or Report
ad_process ad_process_id numeric 10 Process or Report
ad_process_para ad_process_id numeric 10 Process or Report
ad_tab ad_process_id numeric 10  √  null Process or Report
ad_toolbarbutton ad_process_id numeric 10  √  NULL::numeric Process or Report
ad_userdef_proc ad_process_id numeric 10 Process or Report
ad_userdef_tab ad_process_id numeric 10  √  NULL::numeric Process or Report
ad_process_para ad_process_para_id numeric 10 Process Parameter
ad_userdef_proc_parameter ad_process_para_id numeric 10 Process Parameter
ad_ref_list ad_ref_list_id numeric 10 Reference List based on Table
ad_attribute ad_reference_id numeric 10 System Reference and Validation
ad_column ad_reference_id numeric 10 System Reference and Validation
ad_field ad_reference_id numeric 10  √  null System Reference and Validation
ad_infocolumn ad_reference_id numeric 10 System Reference and Validation
ad_process_para ad_reference_id numeric 10 System Reference and Validation
ad_ref_list ad_reference_id numeric 10 System Reference and Validation
ad_ref_table ad_reference_id numeric 10 System Reference and Validation
ad_reference ad_reference_id numeric 10 System Reference and Validation
ad_userdef_field ad_reference_id numeric 10  √  NULL::numeric System Reference and Validation
ad_userdef_info_column ad_reference_id numeric 10  √  NULL::numeric System Reference and Validation
ad_userdef_proc_parameter ad_reference_id numeric 10  √  NULL::numeric System Reference and Validation
ad_relationtype ad_reference_source_id numeric 10  √  NULL::numeric Source Reference
ad_relationtype ad_reference_target_id numeric 10  √  NULL::numeric Target Reference
ad_attribute ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_column ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_field ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_infocolumn ad_reference_value_id numeric 10  √  NULL::numeric Required to specify, if data type is Table or List
ad_process_para ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_userdef_field ad_reference_value_id numeric 10  √  NULL::numeric Required to specify, if data type is Table or List
ad_userdef_info_column ad_reference_value_id numeric 10  √  NULL::numeric Required to specify, if data type is Table or List
ad_userdef_proc_parameter ad_reference_value_id numeric 10  √  NULL::numeric Required to specify, if data type is Table or List
ad_relationtype ad_relationtype_id numeric 10 Relation Type
ad_process ad_reportview_id numeric 10  √  null View used to generate this report
ad_role ad_role_id numeric 10 Responsibility Role
ad_userdef_info ad_role_id numeric 10  √  NULL::numeric Responsibility Role
ad_userdef_proc ad_role_id numeric 10  √  NULL::numeric Responsibility Role
ad_userdef_win ad_role_id numeric 10  √  null Responsibility Role
ad_rule ad_rule_id numeric 10 Rule
ad_table_scriptvalidator ad_rule_id numeric 10 Rule
ad_searchdefinition ad_searchdefinition_id numeric 10 Search Definition
ad_statusline ad_statusline_id numeric 10 Status Line
ad_statuslineusedin ad_statusline_id numeric 10 Status Line
ad_statuslineusedin ad_statuslineusedin_id numeric 10 AD_StatusLineUsedIn
ad_style ad_style_id numeric 10 CSS style for field and label
ad_styleline ad_style_id numeric 10 CSS style for field and label
ad_styleline ad_styleline_id numeric 10 CSS Style Line
ad_sysconfig ad_sysconfig_id numeric 10 System Configurator
ad_tab_customization ad_tab_customization_id numeric 10 NULL::numeric Tab Customization
ad_field ad_tab_id numeric 10 Tab within a Window
ad_statuslineusedin ad_tab_id numeric 10  √  NULL::numeric Tab within a Window
ad_tab ad_tab_id numeric 10 Tab within a Window
ad_tab_customization ad_tab_id numeric 10  √  NULL::numeric Tab within a Window
ad_toolbarbutton ad_tab_id numeric 10  √  NULL::numeric Tab within a Window
ad_userdef_tab ad_tab_id numeric 10 Tab within a Window
ad_attribute ad_table_id numeric 10 Database Table information
ad_column ad_table_id numeric 10 Database Table information
ad_infowindow ad_table_id numeric 10 Database Table information
ad_ref_table ad_table_id numeric 10 Database Table information
ad_searchdefinition ad_table_id numeric 10 Database Table information
ad_statuslineusedin ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_tab ad_table_id numeric 10 Database Table information
ad_table ad_table_id numeric 10 Database Table information
ad_table_scriptvalidator ad_table_id numeric 10 Database Table information
ad_tableindex ad_table_id numeric 10 Database Table information
ad_viewcomponent ad_table_id numeric 10 Database Table information
ad_zoomcondition ad_table_id numeric 10 Database Table information
ad_table_scriptvalidator ad_table_scriptvalidator_id numeric 10 Table Script Validator
ad_indexcolumn ad_tableindex_id numeric 10 Table Index
ad_tableindex ad_tableindex_id numeric 10 Table Index
ad_toolbarbutton ad_toolbarbutton_id numeric 10 ToolBar Button
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_tab_customization ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_userdef_info ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
ad_userdef_proc ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
ad_userdef_win ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_userdef_field ad_userdef_field_id numeric 10 User defined Field
ad_userdef_info_column ad_userdef_info_column_id numeric 10 User defined Info Column
ad_userdef_info ad_userdef_info_id numeric 10 User defined Info Window
ad_userdef_info_column ad_userdef_info_id numeric 10 User defined Info Window
ad_userdef_info_related ad_userdef_info_id numeric 10 User defined Info Window
ad_userdef_info_related ad_userdef_info_related_id numeric 10 User defined Info Related
ad_userdef_proc ad_userdef_proc_id numeric 10 Primary Key : User defined Process
ad_userdef_proc_parameter ad_userdef_proc_id numeric 10 Primary Key : User defined Process
ad_userdef_proc_parameter ad_userdef_proc_parameter_id numeric 10 Primary Key : User defined Process Parameter
ad_userdef_field ad_userdef_tab_id numeric 10 User defined Tab
ad_userdef_tab ad_userdef_tab_id numeric 10 User defined Tab
ad_userdef_tab ad_userdef_win_id numeric 10 User defined Window
ad_userdef_win ad_userdef_win_id numeric 10 User defined Window
ad_attribute ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_column ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_field ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_infocolumn ad_val_rule_id numeric 10  √  NULL::numeric Dynamic Validation Rule
ad_process_para ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_userdef_field ad_val_rule_id numeric 10  √  NULL::numeric Dynamic Validation Rule
ad_userdef_info_column ad_val_rule_id numeric 10  √  NULL::numeric Dynamic Validation Rule
ad_userdef_proc_parameter ad_val_rule_id numeric 10  √  NULL::numeric Dynamic Validation Rule
ad_val_rule ad_val_rule_id numeric 10 Dynamic Validation Rule
ad_column ad_val_rule_lookup_id numeric 10  √  NULL::numeric Override Dynamic Validation Rule for Lookup Window
ad_field ad_val_rule_lookup_id numeric 10  √  NULL::numeric Override Dynamic Validation Rule for Lookup Window
ad_userdef_field ad_val_rule_lookup_id numeric 10  √  NULL::numeric Override Dynamic Validation Rule for Lookup Window
ad_viewcolumn ad_viewcolumn_id numeric 10 Database View Column
ad_viewcolumn ad_viewcomponent_id numeric 10 Database View Component
ad_viewcomponent ad_viewcomponent_id numeric 10 Database View Component
ad_ref_table ad_window_id numeric 10  √  null Data entry or display window
ad_searchdefinition ad_window_id numeric 10 Data entry or display window
ad_statuslineusedin ad_window_id numeric 10  √  NULL::numeric Data entry or display window
ad_tab ad_window_id numeric 10 Data entry or display window
ad_table ad_window_id numeric 10  √  null Data entry or display window
ad_userdef_win ad_window_id numeric 10 Data entry or display window
ad_window ad_window_id numeric 10 Data entry or display window
ad_zoomcondition ad_window_id numeric 10  √  NULL::numeric Data entry or display window
ad_process ad_workflow_id numeric 10  √  null Workflow or combination of tasks
ad_zoomcondition ad_zoomcondition_id numeric 10 Zoom condition
ad_role c_currency_id numeric 10  √  null The Currency for this record
ad_field columnspan numeric 10  √  (1)::numeric Number of column for a box of field
ad_userdef_field columnspan numeric 10  √  NULL::numeric Number of column for a box of field
ad_role confirmqueryrecords numeric 10 0 Require Confirmation if more records will be returned by the query (If not defined 500)
ad_attribute createdby numeric 10 User who created this records
ad_column createdby numeric 10 User who created this records
ad_element createdby numeric 10 User who created this records
ad_field createdby numeric 10 User who created this records
ad_fieldgroup createdby numeric 10 User who created this records
ad_indexcolumn createdby numeric 10 User who created this records
ad_infocolumn createdby numeric 10 User who created this records
ad_infoprocess createdby numeric 10 User who created this records
ad_inforelated createdby numeric 10 User who created this records
ad_infowindow createdby numeric 10 User who created this records
ad_language createdby numeric 10 User who created this records
ad_message createdby numeric 10 User who created this records
ad_modelvalidator createdby numeric 10 User who created this records
ad_process createdby numeric 10 User who created this records
ad_process_para createdby numeric 10 User who created this records
ad_ref_list createdby numeric 10 User who created this records
ad_ref_table createdby numeric 10 User who created this records
ad_reference createdby numeric 10 User who created this records
ad_relationtype createdby numeric 10 User who created this records
ad_role createdby numeric 10 User who created this records
ad_rule createdby numeric 10 User who created this records
ad_searchdefinition createdby numeric 10  √  null User who created this records
ad_statusline createdby numeric 10 User who created this records
ad_statuslineusedin createdby numeric 10 User who created this records
ad_style createdby numeric 10 User who created this records
ad_styleline createdby numeric 10 User who created this records
ad_sysconfig createdby numeric 10 User who created this records
ad_tab createdby numeric 10 User who created this records
ad_tab_customization createdby numeric 10 User who created this records
ad_table createdby numeric 10 User who created this records
ad_table_scriptvalidator createdby numeric 10 User who created this records
ad_tableindex createdby numeric 10 User who created this records
ad_toolbarbutton createdby numeric 10 User who created this records
ad_userdef_field createdby numeric 10 User who created this records
ad_userdef_info createdby numeric 10 User who created this records
ad_userdef_info_column createdby numeric 10 User who created this records
ad_userdef_info_related createdby numeric 10 User who created this records
ad_userdef_proc createdby numeric 10 User who created this records
ad_userdef_proc_parameter createdby numeric 10 User who created this records
ad_userdef_tab createdby numeric 10 User who created this records
ad_userdef_win createdby numeric 10 User who created this records
ad_val_rule createdby numeric 10 User who created this records
ad_viewcolumn createdby numeric 10 User who created this records
ad_viewcomponent createdby numeric 10 User who created this records
ad_window createdby numeric 10 User who created this records
ad_zoomcondition createdby numeric 10 User who created this records
ad_role daysapprovalaccum numeric 10  √  null The days approval indicates the days to take into account to verify the accumulated approval amount.
ad_attribute displaylength numeric 10  √  null Length of the display in characters
ad_field displaylength numeric 10  √  null Length of the display in characters
ad_userdef_field displaylength numeric 10 0 Length of the display in characters
ad_attribute fieldlength numeric 10  √  null Length of the column in the database
ad_column fieldlength numeric 10  √  null Length of the column in the database
ad_process_para fieldlength numeric 10 Length of the column in the database
ad_field included_tab_id numeric 10  √  null Included Tab in this Tab (Master Detail)
ad_tab included_tab_id numeric 10  √  null Included Tab in this Tab (Master Detail)
ad_toolbarbutton keystroke_keycode numeric 10  √  NULL::numeric KeyCode for shortcuts
ad_toolbarbutton keystroke_modifiers numeric 10  √  NULL::numeric Keystroke Modifiers for shortcuts
ad_infoprocess layouttype varchar 10 'B'::character varying Layout type of info process
ad_styleline line numeric 10 Unique line for this document
ad_table loadseq numeric 10  √  null Sequence
ad_infowindow maxqueryrecords numeric 10 (0)::numeric If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
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
ad_tab maxqueryrecords numeric 10  √  '0'::numeric If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
ad_field numlines numeric 10  √  (1)::numeric Number of lines for a field
ad_userdef_field numlines numeric 10  √  NULL::numeric Number of lines for a field
ad_column pa_dashboardcontent_id numeric 10  √  NULL::numeric Dashboard Content
ad_userdef_field pa_dashboardcontent_id numeric 10  √  NULL::numeric Dashboard Content
ad_infowindow pagingsize numeric 10 '0'::numeric Paging Size
ad_tab parent_column_id numeric 10  √  NULL::numeric The link column on the parent tab.
ad_inforelated parentrelatedcolumn_id numeric 10  √  NULL::numeric column in parent info window, link with column in this relate info
ad_searchdefinition po_window_id numeric 10  √  null Purchase Order Window
ad_table po_window_id numeric 10  √  null Purchase Order Window
ad_infocolumn queryoperator varchar 10  √  NULL::character varying Operator for database query
ad_userdef_info_column queryoperator varchar 10  √  NULL::character varying Operator for database query
ad_attribute_value record_id numeric 10 Direct internal record ID
ad_viewcomponent referenced_table_id numeric 10  √  NULL::numeric Referenced Table
ad_inforelated relatedcolumn_id numeric 10 (0)::numeric Related Info Column
ad_inforelated relatedinfo_id numeric 10 (0)::numeric Related Info Window
ad_attribute seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_column seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_field seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_indexcolumn seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_infocolumn seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_infoprocess seqno numeric 10 Method of ordering records; lowest number comes first
ad_inforelated seqno numeric 10 Method of ordering records; lowest number comes first
ad_infowindow seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_modelvalidator seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_process_para seqno numeric 10 Method of ordering records; lowest number comes first
ad_statuslineusedin seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_tab seqno numeric 10 Method of ordering records; lowest number comes first
ad_table_scriptvalidator seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_toolbarbutton seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_userdef_field seqno numeric 10 (0)::numeric Method of ordering records; lowest number comes first
ad_userdef_info seqno numeric 10 '0'::numeric Method of ordering records; lowest number comes first
ad_userdef_info_column seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_userdef_info_related seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_userdef_proc_parameter seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_userdef_tab seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_viewcolumn seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_viewcomponent seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_zoomcondition seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_field seqnogrid numeric 10  √  NULL::numeric Grid Sequence No
ad_userdef_field seqnogrid numeric 10 '0'::numeric Grid Sequence No
ad_column seqnoselection numeric 10  √  NULL::numeric Selection Column Sequence
ad_infocolumn seqnoselection numeric 10  √  (0)::numeric Selection Column Sequence
ad_userdef_info_column seqnoselection numeric 10  √  '0'::numeric Selection Column Sequence
ad_field sortno numeric 10  √  null Determines in what order the records are displayed
ad_userdef_field sortno numeric 10 0 Determines in what order the records are displayed
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_tab tablevel numeric 10 Hierarchical Tab Level (0 = top)
ad_attribute updatedby numeric 10 User who updated this records
ad_column updatedby numeric 10 User who updated this records
ad_element updatedby numeric 10 User who updated this records
ad_field updatedby numeric 10 User who updated this records
ad_fieldgroup updatedby numeric 10 User who updated this records
ad_indexcolumn updatedby numeric 10 User who updated this records
ad_infocolumn updatedby numeric 10 User who updated this records
ad_infoprocess updatedby numeric 10 User who updated this records
ad_inforelated updatedby numeric 10 User who updated this records
ad_infowindow updatedby numeric 10 User who updated this records
ad_language updatedby numeric 10 User who updated this records
ad_message updatedby numeric 10 User who updated this records
ad_modelvalidator updatedby numeric 10 User who updated this records
ad_process updatedby numeric 10 User who updated this records
ad_process_para updatedby numeric 10 User who updated this records
ad_ref_list updatedby numeric 10 User who updated this records
ad_ref_table updatedby numeric 10 User who updated this records
ad_reference updatedby numeric 10 User who updated this records
ad_relationtype updatedby numeric 10 User who updated this records
ad_role updatedby numeric 10 User who updated this records
ad_rule updatedby numeric 10 User who updated this records
ad_searchdefinition updatedby numeric 10 User who updated this records
ad_statusline updatedby numeric 10 User who updated this records
ad_statuslineusedin updatedby numeric 10 User who updated this records
ad_style updatedby numeric 10 User who updated this records
ad_styleline updatedby numeric 10 User who updated this records
ad_sysconfig updatedby numeric 10 User who updated this records
ad_tab updatedby numeric 10 User who updated this records
ad_tab_customization updatedby numeric 10 User who updated this records
ad_table updatedby numeric 10 User who updated this records
ad_table_scriptvalidator updatedby numeric 10 User who updated this records
ad_tableindex updatedby numeric 10 User who updated this records
ad_toolbarbutton updatedby numeric 10 User who updated this records
ad_userdef_field updatedby numeric 10 User who updated this records
ad_userdef_info updatedby numeric 10 User who updated this records
ad_userdef_info_column updatedby numeric 10 User who updated this records
ad_userdef_info_related updatedby numeric 10 User who updated this records
ad_userdef_proc updatedby numeric 10 User who updated this records
ad_userdef_proc_parameter updatedby numeric 10 User who updated this records
ad_userdef_tab updatedby numeric 10 User who updated this records
ad_userdef_win updatedby numeric 10 User who updated this records
ad_val_rule updatedby numeric 10 User who updated this records
ad_viewcolumn updatedby numeric 10 User who updated this records
ad_viewcomponent updatedby numeric 10 User who updated this records
ad_window updatedby numeric 10 User who updated this records
ad_zoomcondition updatedby numeric 10 User who updated this records
ad_window winheight numeric 10  √  null Window Height
ad_window winwidth numeric 10  √  null Window Width
ad_field xposition numeric 10  √  (1)::numeric Absolute X (horizontal) position in 1/72 of an inch
ad_userdef_field xposition numeric 10  √  NULL::numeric Absolute X (horizontal) position in 1/72 of an inch
ad_language datepattern varchar 20  √  null Java Date Pattern
ad_language timepattern varchar 20  √  null Java Time Pattern
ad_attribute valuemax varchar 20  √  null Maximum Value for a field
ad_column valuemax varchar 20  √  null Maximum Value for a field
ad_process_para valuemax varchar 20  √  null Maximum Value for a field
ad_userdef_proc_parameter valuemax varchar 20  √  NULL::character varying Maximum Value for a field
ad_attribute valuemin varchar 20  √  null Minimum Value for a field
ad_column valuemin varchar 20  √  null Minimum Value for a field
ad_process_para valuemin varchar 20  √  null Minimum Value for a field
ad_userdef_proc_parameter valuemin varchar 20  √  NULL::character varying 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_attribute created timestamp 29,6 now() Date this record was created
ad_column created timestamp 29,6 now() Date this record was created
ad_element created timestamp 29,6 statement_timestamp() Date this record was created
ad_field created timestamp 29,6 now() Date this record was created
ad_fieldgroup created timestamp 29,6 now() Date this record was created
ad_indexcolumn created timestamp 29,6 statement_timestamp() Date this record was created
ad_infocolumn created timestamp 29,6 now() Date this record was created
ad_infoprocess created timestamp 29,6 statement_timestamp() Date this record was created
ad_inforelated created timestamp 29,6 Date this record was created
ad_infowindow created timestamp 29,6 now() Date this record was created
ad_language created timestamp 29,6 now() Date this record was created
ad_message created timestamp 29,6 now() Date this record was created
ad_modelvalidator created timestamp 29,6 statement_timestamp() Date this record was created
ad_process created timestamp 29,6 now() Date this record was created
ad_process_para created timestamp 29,6 now() Date this record was created
ad_ref_list created timestamp 29,6 now() Date this record was created
ad_ref_table created timestamp 29,6 now() Date this record was created
ad_reference created timestamp 29,6 now() Date this record was created
ad_relationtype created timestamp 29,6 statement_timestamp() Date this record was created
ad_role created timestamp 29,6 now() Date this record was created
ad_rule created timestamp 29,6 statement_timestamp() Date this record was created
ad_searchdefinition created timestamp 29,6 statement_timestamp() Date this record was created
ad_statusline created timestamp 29,6 Date this record was created
ad_statuslineusedin created timestamp 29,6 Date this record was created
ad_style created timestamp 29,6  √  statement_timestamp() Date this record was created
ad_styleline created timestamp 29,6 statement_timestamp() Date this record was created
ad_sysconfig created timestamp 29,6 statement_timestamp() Date this record was created
ad_tab created timestamp 29,6 now() Date this record was created
ad_tab_customization created timestamp 29,6 statement_timestamp() Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
ad_table_scriptvalidator created timestamp 29,6 statement_timestamp() Date this record was created
ad_tableindex created timestamp 29,6 statement_timestamp() Date this record was created
ad_toolbarbutton created timestamp 29,6 statement_timestamp() Date this record was created
ad_userdef_field created timestamp 29,6 now() Date this record was created
ad_userdef_info created timestamp 29,6 statement_timestamp() Date this record was created
ad_userdef_info_column created timestamp 29,6 statement_timestamp() Date this record was created
ad_userdef_info_related created timestamp 29,6 statement_timestamp() Date this record was created
ad_userdef_proc created timestamp 29,6 Date this record was created
ad_userdef_proc_parameter created timestamp 29,6 Date this record was created
ad_userdef_tab created timestamp 29,6 now() Date this record was created
ad_userdef_win created timestamp 29,6 now() Date this record was created
ad_val_rule created timestamp 29,6 now() Date this record was created
ad_viewcolumn created timestamp 29,6 statement_timestamp() Date this record was created
ad_viewcomponent created timestamp 29,6 statement_timestamp() Date this record was created
ad_window created timestamp 29,6 now() Date this record was created
ad_zoomcondition created timestamp 29,6 statement_timestamp() Date this record was created
ad_attribute updated timestamp 29,6 now() Date this record was updated
ad_column updated timestamp 29,6 now() Date this record was updated
ad_element updated timestamp 29,6 now() Date this record was updated
ad_field updated timestamp 29,6 now() Date this record was updated
ad_fieldgroup updated timestamp 29,6 now() Date this record was updated
ad_indexcolumn updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_infocolumn updated timestamp 29,6 now() Date this record was updated
ad_infoprocess updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_inforelated updated timestamp 29,6 Date this record was updated
ad_infowindow updated timestamp 29,6 now() Date this record was updated
ad_language updated timestamp 29,6 now() Date this record was updated
ad_message updated timestamp 29,6 now() Date this record was updated
ad_modelvalidator updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_process updated timestamp 29,6 now() Date this record was updated
ad_process_para updated timestamp 29,6 now() Date this record was updated
ad_ref_list updated timestamp 29,6 now() Date this record was updated
ad_ref_table updated timestamp 29,6 now() Date this record was updated
ad_reference updated timestamp 29,6 now() Date this record was updated
ad_relationtype updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_role updated timestamp 29,6 now() Date this record was updated
ad_rule updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_searchdefinition updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_statusline updated timestamp 29,6 Date this record was updated
ad_statuslineusedin updated timestamp 29,6 Date this record was updated
ad_style updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_styleline updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_sysconfig updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_tab updated timestamp 29,6 now() Date this record was updated
ad_tab_customization updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
ad_table_scriptvalidator updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_tableindex updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_toolbarbutton updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_userdef_field updated timestamp 29,6 now() Date this record was updated
ad_userdef_info updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_userdef_info_column updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_userdef_info_related updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_userdef_proc updated timestamp 29,6 Date this record was updated
ad_userdef_proc_parameter updated timestamp 29,6 Date this record was updated
ad_userdef_tab updated timestamp 29,6 now() Date this record was updated
ad_userdef_win updated timestamp 29,6 now() Date this record was updated
ad_val_rule updated timestamp 29,6 now() Date this record was updated
ad_viewcolumn updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_viewcomponent updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_window updated timestamp 29,6 now() Date this record was updated
ad_zoomcondition updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_attribute_value v_date timestamp 29,6  √  null Date
ad_ref_list validfrom timestamp 29,6  √  null Valid from including this date (first day)
ad_ref_list 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_element columnname varchar 30 Name of the column in the database
ad_infocolumn columnname varchar 30 Name of the column in the database
ad_process_para columnname varchar 30 Name of the column in the database
ad_viewcolumn columnname varchar 30 NULL::character varying Name of the column in the database
ad_column fkconstraintname varchar 30  √  NULL::character varying Constraint Name
ad_attribute ad_attribute_uu varchar 36  √  NULL::character varying AD_Attribute_UU
ad_attribute_value ad_attribute_value_uu varchar 36  √  NULL::character varying AD_Attribute_Value_UU
ad_column ad_column_uu varchar 36  √  NULL::character varying AD_Column_UU
ad_element ad_element_uu varchar 36  √  NULL::character varying AD_Element_UU
ad_field ad_field_uu varchar 36  √  NULL::character varying AD_Field_UU
ad_fieldgroup ad_fieldgroup_uu varchar 36  √  NULL::character varying AD_FieldGroup_UU
ad_indexcolumn ad_indexcolumn_uu varchar 36  √  NULL::character varying AD_IndexColumn_UU
ad_infocolumn ad_infocolumn_uu varchar 36  √  NULL::character varying AD_InfoColumn_UU
ad_infoprocess ad_infoprocess_uu varchar 36 AD_InfoProcess_UU
ad_inforelated ad_inforelated_uu varchar 36  √  NULL::character varying AD_InfoRelated_UU
ad_infowindow ad_infowindow_uu varchar 36  √  NULL::character varying AD_InfoWindow_UU
ad_language ad_language_uu varchar 36  √  NULL::character varying AD_Language_UU
ad_message ad_message_uu varchar 36  √  NULL::character varying AD_Message_UU
ad_modelvalidator ad_modelvalidator_uu varchar 36  √  NULL::character varying AD_ModelValidator_UU
ad_process_para ad_process_para_uu varchar 36  √  NULL::character varying AD_Process_Para_UU
ad_process ad_process_uu varchar 36  √  NULL::character varying AD_Process_UU
ad_ref_list ad_ref_list_uu varchar 36  √  NULL::character varying AD_Ref_List_UU
ad_ref_table ad_ref_table_uu varchar 36  √  NULL::character varying AD_Ref_Table_UU
ad_reference ad_reference_uu varchar 36  √  NULL::character varying AD_Reference_UU
ad_relationtype ad_relationtype_uu varchar 36  √  NULL::character varying AD_RelationType_UU
ad_role ad_role_uu varchar 36  √  NULL::character varying AD_Role_UU
ad_rule ad_rule_uu varchar 36  √  NULL::character varying AD_Rule_UU
ad_searchdefinition ad_searchdefinition_uu varchar 36  √  NULL::character varying AD_SearchDefinition_UU
ad_statusline ad_statusline_uu varchar 36  √  NULL::character varying AD_StatusLine_UU
ad_statuslineusedin ad_statuslineusedin_uu varchar 36  √  NULL::character varying AD_StatusLineUsedIn_UU
ad_style ad_style_uu varchar 36 CSS Style for field and label
ad_styleline ad_styleline_uu varchar 36 CSS Style Line
ad_sysconfig ad_sysconfig_uu varchar 36  √  NULL::character varying AD_SysConfig_UU
ad_tab_customization ad_tab_customization_uu varchar 36  √  NULL::character varying AD_Tab_Customization_UU
ad_tab ad_tab_uu varchar 36  √  NULL::character varying AD_Tab_UU
ad_table_scriptvalidator ad_table_scriptvalidator_uu varchar 36  √  NULL::character varying AD_Table_ScriptValidator_UU
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
ad_tableindex ad_tableindex_uu varchar 36  √  NULL::character varying AD_TableIndex_UU
ad_toolbarbutton ad_toolbarbutton_uu varchar 36  √  NULL::character varying AD_ToolBarButton_UU
ad_userdef_field ad_userdef_field_uu varchar 36  √  NULL::character varying AD_UserDef_Field_UU
ad_userdef_info_column ad_userdef_info_column_uu varchar 36  √  NULL::character varying AD_UserDef_Info_Column_UU
ad_userdef_info_related ad_userdef_info_related_uu varchar 36  √  NULL::character varying AD_UserDef_Info_Related_UU
ad_userdef_info ad_userdef_info_uu varchar 36  √  NULL::character varying AD_UserDef_Info_UU
ad_userdef_proc_parameter ad_userdef_proc_parameter_uu varchar 36  √  NULL::character varying AD_UserDef_Proc_Parameter_UU
ad_userdef_proc ad_userdef_proc_uu varchar 36  √  NULL::character varying AD_UserDef_Proc_UU
ad_userdef_tab ad_userdef_tab_uu varchar 36  √  NULL::character varying AD_UserDef_Tab_UU
ad_userdef_win ad_userdef_win_uu varchar 36  √  NULL::character varying AD_UserDef_Win_UU
ad_val_rule ad_val_rule_uu varchar 36  √  NULL::character varying AD_Val_Rule_UU
ad_viewcolumn ad_viewcolumn_uu varchar 36  √  NULL::character varying AD_ViewColumn_UU
ad_viewcomponent ad_viewcomponent_uu varchar 36  √  NULL::character varying AD_ViewComponent_UU
ad_window ad_window_uu varchar 36  √  NULL::character varying AD_Window_UU
ad_zoomcondition ad_zoomcondition_uu varchar 36  √  NULL::character varying AD_ZoomCondition_UU
ad_tab ad_tabtype varchar 40  √  NULL::character varying Defines Tab Type
ad_column entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_element entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_field entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_fieldgroup entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_indexcolumn entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_infocolumn entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_infoprocess entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_inforelated entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_infowindow entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_message entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_modelvalidator entitytype varchar 40 Dictionary Entity Type; Determines ownership and synchronization
ad_process entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process_para entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_ref_list entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_ref_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_reference entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_relationtype entitytype varchar 40  √  'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_rule entitytype varchar 40  √  'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_searchdefinition entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_statusline entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_statuslineusedin entitytype varchar 40  √  'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_style entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_styleline entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_sysconfig entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_tab 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_tableindex entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_toolbarbutton entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_val_rule entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_viewcolumn entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_viewcomponent entitytype varchar 40 'U'::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_zoomcondition entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table tablename varchar 40 Name of the table in the database
ad_process value varchar 40 Search key for the record in the format required - must be unique
ad_rule value varchar 40 Search key for the record in the format required - must be unique
ad_reference vformat varchar 40  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_userdef_proc_parameter vformat varchar 40  √  NULL::character varying Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_process workflowvalue varchar 40  √  null Key of the Workflow to start
ad_sysconfig name varchar 50 Alphanumeric identifier of the entity
ad_tableindex name varchar 50 Alphanumeric identifier of the entity
ad_viewcomponent name varchar 50 Alphanumeric identifier of the entity
ad_relationtype role_source varchar 50  √  null If set, this role will be used as label for the zoom destination instead of the destinations's window name
ad_relationtype role_target varchar 50  √  null If set, this role will be used as label for the zoom destination instead of the destinations's window name
ad_toolbarbutton actionname varchar 60  √  NULL::character varying Action name on the toolbar
ad_attribute callout varchar 60  √  null Fully qualified class names and method - separated by semicolons
ad_attribute name varchar 60 Alphanumeric identifier of the entity
ad_column name varchar 60 Alphanumeric identifier of the entity
ad_element name varchar 60 Alphanumeric identifier of the entity
ad_field name varchar 60 Alphanumeric identifier of the entity
ad_fieldgroup name varchar 60 Alphanumeric identifier of the entity
ad_infocolumn name varchar 60 Alphanumeric identifier of the entity
ad_inforelated name varchar 60 Alphanumeric identifier of the entity
ad_infowindow name varchar 60 Alphanumeric identifier of the entity
ad_language name varchar 60 Alphanumeric identifier of the entity
ad_modelvalidator name varchar 60 Alphanumeric identifier of the entity
ad_process name varchar 60 Alphanumeric identifier of the entity
ad_process_para name varchar 60 Alphanumeric identifier of the entity
ad_ref_list name varchar 60 Alphanumeric identifier of the entity
ad_reference name varchar 60 Alphanumeric identifier of the entity
ad_relationtype name varchar 60 Alphanumeric identifier of the entity
ad_role name varchar 60 Alphanumeric identifier of the entity
ad_rule name varchar 60 Alphanumeric identifier of the entity
ad_searchdefinition name varchar 60  √  null Alphanumeric identifier of the entity
ad_statusline name varchar 60 Alphanumeric identifier of the entity
ad_style name varchar 60 Alphanumeric identifier of the entity
ad_tab name varchar 60 Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
ad_toolbarbutton name varchar 60 Alphanumeric identifier of the entity
ad_userdef_field name varchar 60  √  null Alphanumeric identifier of the entity
ad_userdef_info name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
ad_userdef_info_column name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
ad_userdef_info_related name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
ad_userdef_proc name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
ad_userdef_proc_parameter name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
ad_userdef_tab name varchar 60  √  null Alphanumeric identifier of the entity
ad_userdef_win name varchar 60  √  null Alphanumeric identifier of the entity
ad_val_rule name varchar 60 Alphanumeric identifier of the entity
ad_window name varchar 60 Alphanumeric identifier of the entity
ad_zoomcondition name varchar 60 Alphanumeric identifier of the entity
ad_element po_name varchar 60  √  null Name on PO Screens
ad_element po_printname varchar 60  √  null Print name on PO Screens/Reports
ad_element printname varchar 60 The label text to be printed on a document or correspondence.
ad_language printname varchar 60 NULL::character varying The label text to be printed on a document or correspondence.
ad_process procedurename varchar 60  √  null Name of the Database Procedure
ad_styleline theme varchar 60  √  NULL::character varying Theme name
ad_ref_list value varchar 60 Search key for the record in the format required - must be unique
ad_attribute vformat varchar 60  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_infoprocess imageurl varchar 120  √  NULL::character varying URL of image
ad_infowindow imageurl varchar 120  √  NULL::character varying URL of image
ad_userdef_info imageurl varchar 120  √  NULL::character varying URL of image
ad_toolbarbutton actionclassname varchar 255  √  NULL::character varying The service component name that implements the interface for toolbar actions
ad_column callout varchar 255  √  null Fully qualified class names and method - separated by semicolons
ad_process classname varchar 255  √  null Java Classname
ad_toolbarbutton classname varchar 255  √  null Java Classname
ad_indexcolumn columnsql varchar 255  √  NULL::character varying Virtual Column (r/o)
ad_toolbarbutton componentname varchar 255 Component Name
ad_attribute description varchar 255  √  null Optional short description of the record
ad_column description varchar 255  √  null Optional short description of the record
ad_element description varchar 255  √  null Optional short description of the record
ad_field description varchar 255  √  null Optional short description of the record
ad_infocolumn description varchar 255  √  null Optional short description of the record
ad_inforelated description varchar 255  √  NULL::character varying Optional short description of the record
ad_infowindow description varchar 255  √  null Optional short description of the record
ad_modelvalidator description varchar 255  √  null Optional short description of the record
ad_process description varchar 255  √  null Optional short description of the record
ad_process_para description varchar 255  √  null Optional short description of the record
ad_ref_list description varchar 255  √  null Optional short description of the record
ad_reference description varchar 255  √  null Optional short description of the record
ad_relationtype description varchar 255  √  NULL::character varying Optional short description of the record
ad_role description varchar 255  √  null Optional short description of the record
ad_rule description varchar 255  √  null Optional short description of the record
ad_searchdefinition description varchar 255  √  null Optional short description of the record
ad_style description varchar 255  √  NULL::character varying Optional short description of the record
ad_sysconfig description varchar 255  √  null Optional short description of the record
ad_tab description varchar 255  √  null Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
ad_tableindex description varchar 255  √  NULL::character varying Optional short description of the record
ad_userdef_field description varchar 255  √  null Optional short description of the record
ad_userdef_info description varchar 255  √  NULL::character varying Optional short description of the record
ad_userdef_info_column description varchar 255  √  NULL::character varying Optional short description of the record
ad_userdef_info_related description varchar 255  √  NULL::character varying Optional short description of the record
ad_userdef_proc description varchar 255  √  NULL::character varying Optional short description of the record
ad_userdef_proc_parameter description varchar 255  √  NULL::character varying Optional short description of the record
ad_userdef_tab description varchar 255  √  null Optional short description of the record
ad_userdef_win description varchar 255  √  null Optional short description of the record
ad_val_rule description varchar 255  √  null Optional short description of the record
ad_viewcolumn description varchar 255  √  NULL::character varying Optional short description of the record
ad_viewcomponent description varchar 255  √  NULL::character varying Optional short description of the record
ad_window description varchar 255  √  null Optional short description of the record
ad_zoomcondition description varchar 255  √  NULL::character varying Optional short description of the record
ad_column infofactoryclass varchar 255  √  null Fully qualified class name that implements the InfoFactory interface
ad_field infofactoryclass varchar 255  √  null Fully qualified class name that implements the InfoFactory interface
ad_process jasperreport varchar 255  √  null Jasper Report
ad_modelvalidator modelvalidationclass varchar 255 Model Validation Class
ad_column placeholder varchar 255  √  NULL::character varying Placeholder
ad_element placeholder varchar 255  √  NULL::character varying Placeholder
ad_field placeholder varchar 255  √  NULL::character varying Placeholder
ad_infocolumn placeholder varchar 255  √  NULL::character varying Placeholder
ad_process_para placeholder varchar 255  √  NULL::character varying Placeholder
ad_userdef_field placeholder varchar 255  √  NULL::character varying Placeholder
ad_userdef_info_column placeholder varchar 255  √  NULL::character varying Placeholder
ad_userdef_proc_parameter placeholder varchar 255  √  NULL::character varying Placeholder
ad_process_para placeholder2 varchar 255  √  NULL::character varying Placeholder2
ad_userdef_proc_parameter placeholder2 varchar 255  √  NULL::character varying Placeholder2
ad_element po_description varchar 255  √  null Description in PO Screens
ad_infocolumn queryfunction varchar 255  √  NULL::character varying Database function for query
ad_window titlelogic varchar 255  √  NULL::character varying The result determines the title to be displayed for this window
ad_message value varchar 255 Search key for the record in the format required - must be unique
ad_column vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_field vformat varchar 255  √  NULL::character varying Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_process_para vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_userdef_field vformat varchar 255  √  NULL::character varying Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_val_rule code varchar 2000  √  null Validation Code
ad_viewcolumn columnsql varchar 2000  √  null Virtual Column (r/o)
ad_tab commitwarning varchar 2000  √  null Warning displayed when saving
ad_tab_customization custom varchar 2000 Custom
ad_attribute defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_column defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_field defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_infocolumn defaultvalue varchar 2000  √  NULL::character varying Default value hierarchy, separated by ;
ad_process_para defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_userdef_field defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_userdef_info_column defaultvalue varchar 2000  √  NULL::character varying Default value hierarchy, separated by ;
ad_userdef_proc_parameter defaultvalue varchar 2000  √  NULL::character varying Default value hierarchy, separated by ;
ad_process_para defaultvalue2 varchar 2000  √  null Default value hierarchy, separated by ;
ad_userdef_proc_parameter defaultvalue2 varchar 2000  √  NULL::character varying Default value hierarchy, separated by ;
ad_attribute displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_field displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_infocolumn displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_infoprocess displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_inforelated displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_process_para displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_styleline displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_tab displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_toolbarbutton displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_field displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_info_column displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_info_related displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_proc_parameter displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_tab displaylogic varchar 2000  √  NULL::character varying If the Field is displayed, the result determines if the field is actually displayed
ad_infowindow fromclause varchar 2000 SQL FROM clause
ad_viewcomponent fromclause varchar 2000 NULL::character varying SQL FROM clause
ad_attribute help varchar 2000  √  null Comment or Hint
ad_column help varchar 2000  √  null Comment or Hint
ad_element help varchar 2000  √  null Comment or Hint
ad_field help varchar 2000  √  null Comment or Hint
ad_infocolumn help varchar 2000  √  null Comment or Hint
ad_inforelated help varchar 2000  √  NULL::character varying Comment or Hint
ad_infowindow help varchar 2000  √  null Comment or Hint
ad_modelvalidator help varchar 2000  √  null Comment or Hint
ad_process help varchar 2000  √  null Comment or Hint
ad_process_para help varchar 2000  √  null Comment or Hint
ad_reference help varchar 2000  √  null Comment or Hint
ad_rule help varchar 2000  √  null Comment or Hint
ad_tab help varchar 2000  √  null Comment or Hint
ad_table help varchar 2000  √  null Comment or Hint
ad_tableindex help varchar 2000  √  NULL::character varying Comment or Hint
ad_userdef_field help varchar 2000  √  null Comment or Hint
ad_userdef_info help varchar 2000  √  NULL::character varying Comment or Hint
ad_userdef_info_column help varchar 2000  √  NULL::character varying Comment or Hint
ad_userdef_info_related help varchar 2000  √  NULL::character varying Comment or Hint
ad_userdef_proc help varchar 2000  √  NULL::character varying Comment or Hint
ad_userdef_proc_parameter help varchar 2000  √  NULL::character varying Comment or Hint
ad_userdef_tab help varchar 2000  √  null Comment or Hint
ad_userdef_win help varchar 2000  √  null Comment or Hint
ad_viewcolumn help varchar 2000  √  NULL::character varying Comment or Hint
ad_viewcomponent help varchar 2000  √  NULL::character varying Comment or Hint
ad_window help varchar 2000  √  null Comment or Hint
ad_styleline inlinestyle varchar 2000 CSS Inline Style
ad_infocolumn inputfieldvalidation varchar 2000  √  NULL::character varying Input field validaton query
ad_userdef_info_column inputfieldvalidation varchar 2000  √  NULL::character varying Input field validaton query
ad_column mandatorylogic varchar 2000  √  null Mandatory Logic
ad_field mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_process_para mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_userdef_field mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_userdef_proc_parameter mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_message msgtext varchar 2000 Textual Informational, Menu or Error Message
ad_message msgtip varchar 2000  √  null Additional tip or help for this message
ad_infowindow orderbyclause varchar 2000  √  NULL::character varying Fully qualified ORDER BY clause
ad_ref_table orderbyclause varchar 2000  √  null Fully qualified ORDER BY clause
ad_tab orderbyclause varchar 2000  √  null Fully qualified ORDER BY clause
ad_userdef_tab orderbyclause varchar 2000  √  NULL::character varying Fully qualified ORDER BY clause
ad_infowindow otherclause varchar 2000  √  null Other SQL Clause
ad_viewcomponent otherclause varchar 2000  √  NULL::character varying Other SQL Clause
ad_element po_help varchar 2000  √  null Help for PO Screens
ad_process_para query varchar 2000  √  NULL::character varying SQL
ad_searchdefinition query varchar 2000  √  null SQL
ad_userdef_info_column queryfunction varchar 2000  √  NULL::character varying Database function for query
ad_column readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_field readonlylogic varchar 2000  √  NULL::character varying Logic to determine if field is read only (applies only when field is read-write)
ad_process_para readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_tab readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_userdef_field readonlylogic varchar 2000  √  NULL::character varying Logic to determine if field is read only (applies only when field is read-write)
ad_userdef_proc_parameter readonlylogic varchar 2000  √  NULL::character varying Logic to determine if field is read only (applies only when field is read-write)
ad_userdef_tab readonlylogic varchar 2000  √  NULL::character varying Logic to determine if field is read only (applies only when field is read-write)
ad_infocolumn selectclause varchar 2000 SQL SELECT clause
ad_statusline sqlstatement varchar 2000 SQL Expression/Statement
ad_attribute_value v_string varchar 2000  √  null String
ad_infowindow whereclause varchar 2000  √  NULL::character varying Fully qualified SQL WHERE clause
ad_ref_table whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
ad_tab whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
ad_userdef_tab whereclause varchar 2000  √  NULL::character varying Fully qualified SQL WHERE clause
ad_viewcomponent whereclause varchar 2000  √  NULL::character varying Fully qualified SQL WHERE clause
ad_zoomcondition whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
ad_zoomcondition zoomlogic varchar 2000  √  NULL::character varying the result determines if the zoom condition is applied
ad_column columnsql varchar 4000  √  null Virtual Column (r/o)
ad_field 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_rule script varchar 4000  √  null Dynamic Java Language Script to calculate result
ad_sysconfig value varchar 4000 Search key for the record in the format required - must be unique