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

idempiere9.adempiere contains 482 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_field ad_client_id numeric 10 Client/Tenant for this installation.
ad_field ad_column_id numeric 10  √  null Column in the table
ad_field ad_field_id numeric 10 Field on a database table
ad_field ad_field_uu varchar 36  √  NULL::character varying AD_Field_UU
ad_field ad_fieldgroup_id numeric 10  √  null Logical grouping of fields
ad_field ad_fieldstyle_id numeric 10  √  NULL::numeric Field CSS Style
ad_field ad_labelstyle_id numeric 10  √  NULL::numeric Label CSS Style
ad_field ad_org_id numeric 10 Organizational entity within client
ad_field ad_reference_id numeric 10  √  null System Reference and Validation
ad_field ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_field ad_tab_id numeric 10 Tab within a Window
ad_field ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_field ad_val_rule_lookup_id numeric 10  √  NULL::numeric Override Dynamic Validation Rule for Lookup Window
ad_field columnspan numeric 10  √  (1)::numeric Number of column for a box of field
ad_field columnsql varchar 4000  √  null Virtual Column (r/o)
ad_field created timestamp 29,6 now() Date this record was created
ad_field createdby numeric 10 User who created this records
ad_field defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_field description varchar 255  √  null Optional short description of the record
ad_field displaylength numeric 10  √  null Length of the display in characters
ad_field displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_field entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_field help varchar 2000  √  null Comment or Hint
ad_field included_tab_id numeric 10  √  null Included Tab in this Tab (Master Detail)
ad_field infofactoryclass varchar 255  √  null Fully qualified class name that implements the InfoFactory interface
ad_field isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_field isadvancedfield bpchar 1  √  'N'::bpchar Advanced Field
ad_field isallowcopy bpchar 1  √  NULL::bpchar Determine if a column must be copied when pushing the button to copy record
ad_field isalwaysupdateable bpchar 1  √  NULL::bpchar The column is always updateable, even if the record is not active or processed
ad_field iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
ad_field isdefaultfocus bpchar 1 'N'::bpchar Default Focus
ad_field isdisplayed bpchar 1 'Y'::bpchar Determines, if this field is displayed
ad_field isdisplayedgrid bpchar 1  √  'Y'::bpchar Show in Grid
ad_field isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_field isfieldonly bpchar 1 'N'::bpchar Label is not displayed
ad_field isheading bpchar 1 'N'::bpchar Field without Column - Only label is displayed
ad_field ismandatory bpchar 1  √  null Data entry is required in this column
ad_field isquickentry bpchar 1 'N'::bpchar Quick Entry
ad_field isquickform bpchar 1 'N'::bpchar Display in Quick Form
ad_field isreadonly bpchar 1 'N'::bpchar Field is read only
ad_field issameline bpchar 1 'N'::bpchar Displayed on same line as previous field
ad_field isselectioncolumn bpchar 1  √  NULL::bpchar Is this column used for finding rows in windows
ad_field istoolbarbutton bpchar 1  √  null Show the button on the toolbar, the window, or both
ad_field isupdateable bpchar 1  √  NULL::bpchar Determines, if the field can be updated
ad_field mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_field name varchar 60 Alphanumeric identifier of the entity
ad_field numlines numeric 10  √  (1)::numeric Number of lines for a field
ad_field obscuretype bpchar 3  √  null Type of obscuring the data (limiting the display)
ad_field placeholder varchar 255  √  NULL::character varying Placeholder
ad_field readonlylogic varchar 2000  √  NULL::character varying Logic to determine if field is read only (applies only when field is read-write)
ad_field seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_field seqnogrid numeric 10  √  NULL::numeric Grid Sequence No
ad_field sortno numeric 10  √  null Determines in what order the records are displayed
ad_field updated timestamp 29,6 now() Date this record was updated
ad_field updatedby numeric 10 User who updated this records
ad_field vformat varchar 255  √  NULL::character varying Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_field xposition numeric 10  √  (1)::numeric Absolute X (horizontal) position in 1/72 of an inch
ad_form accesslevel bpchar 1 Access Level required
ad_form ad_client_id numeric 10 Client/Tenant for this installation.
ad_form ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_form ad_form_id numeric 10 Special Form
ad_form ad_form_uu varchar 36  √  NULL::character varying AD_Form_UU
ad_form ad_org_id numeric 10 Organizational entity within client
ad_form classname varchar 60  √  null Java Classname
ad_form created timestamp 29,6 now() Date this record was created
ad_form createdby numeric 10 User who created this records
ad_form description varchar 255  √  null Optional short description of the record
ad_form entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_form help varchar 2000  √  null Comment or Hint
ad_form isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_form isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_form jspurl varchar 120  √  null Web URL of the jsp function
ad_form name varchar 60 Alphanumeric identifier of the entity
ad_form updated timestamp 29,6 now() Date this record was updated
ad_form updatedby numeric 10 User who updated this records
ad_process accesslevel bpchar 1 Access Level required
ad_process ad_client_id numeric 10 Client/Tenant for this installation.
ad_process ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_process ad_form_id numeric 10  √  null Special Form
ad_process ad_org_id numeric 10 Organizational entity within client
ad_process ad_printformat_id numeric 10  √  null Data Print Format
ad_process ad_process_id numeric 10 Process or Report
ad_process ad_process_uu varchar 36  √  NULL::character varying AD_Process_UU
ad_process ad_reportview_id numeric 10  √  null View used to generate this report
ad_process ad_workflow_id numeric 10  √  null Workflow or combination of tasks
ad_process allowmultipleexecution bpchar 1  √  'P'::bpchar Allow or disallow executing a process/report multiple times.
ad_process classname varchar 255  √  null Java Classname
ad_process copyfromprocess bpchar 1  √  NULL::bpchar Copy settings from one report and process to another.
ad_process created timestamp 29,6 now() Date this record was created
ad_process createdby numeric 10 User who created this records
ad_process description varchar 255  √  null Optional short description of the record
ad_process entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process executiontype bpchar 1  √  NULL::bpchar Execution Type defines whether the report/process will always run in background or foreground.
ad_process help varchar 2000  √  null Comment or Hint
ad_process isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_process isdirectprint bpchar 1  √  'N'::bpchar Print without dialog
ad_process isreport bpchar 1 'Y'::bpchar Indicates a Report record
ad_process isserverprocess bpchar 1  √  null Run this Process on Server only
ad_process jasperreport varchar 255  √  null Jasper Report
ad_process name varchar 60 Alphanumeric identifier of the entity
ad_process procedurename varchar 60  √  null Name of the Database Procedure
ad_process showhelp bpchar 1  √  'Y'::bpchar Show Help
ad_process statistic_count numeric 10  √  null Internal statistics how often the entity was used
ad_process statistic_seconds numeric 0  √  null Internal statistics how many seconds a process took
ad_process updated timestamp 29,6 now() Date this record was updated
ad_process updatedby numeric 10 User who updated this records
ad_process value varchar 40 Search key for the record in the format required - must be unique
ad_process workflowvalue varchar 40  √  null Key of the Workflow to start
ad_process_para ad_client_id numeric 10 Client/Tenant for this installation.
ad_process_para ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_process_para ad_fieldgroup_id numeric 10  √  NULL::numeric Logical grouping of fields
ad_process_para ad_org_id numeric 10 Organizational entity within client
ad_process_para ad_process_id numeric 10 Process or Report
ad_process_para ad_process_para_id numeric 10 Process Parameter
ad_process_para ad_process_para_uu varchar 36  √  NULL::character varying AD_Process_Para_UU
ad_process_para ad_reference_id numeric 10 System Reference and Validation
ad_process_para ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_process_para ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_process_para columnname varchar 30 Name of the column in the database
ad_process_para created timestamp 29,6 now() Date this record was created
ad_process_para createdby numeric 10 User who created this records
ad_process_para defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_process_para defaultvalue2 varchar 2000  √  null Default value hierarchy, separated by ;
ad_process_para description varchar 255  √  null Optional short description of the record
ad_process_para displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_process_para entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process_para fieldlength numeric 10 Length of the column in the database
ad_process_para help varchar 2000  √  null Comment or Hint
ad_process_para isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process_para isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
ad_process_para iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
ad_process_para isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_process_para ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_process_para isrange bpchar 1 'N'::bpchar The parameter is a range of values
ad_process_para mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_process_para name varchar 60 Alphanumeric identifier of the entity
ad_process_para placeholder varchar 255  √  NULL::character varying Placeholder
ad_process_para placeholder2 varchar 255  √  NULL::character varying Placeholder2
ad_process_para query varchar 2000  √  NULL::character varying SQL
ad_process_para readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_process_para seqno numeric 10 Method of ordering records; lowest number comes first
ad_process_para updated timestamp 29,6 now() Date this record was updated
ad_process_para updatedby numeric 10 User who updated this records
ad_process_para valuemax varchar 20  √  null Maximum Value for a field
ad_process_para valuemin varchar 20  √  null Minimum Value for a field
ad_process_para vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_ref_list ad_client_id numeric 10 Client/Tenant for this installation.
ad_ref_list ad_org_id numeric 10 Organizational entity within client
ad_ref_list ad_ref_list_id numeric 10 Reference List based on Table
ad_ref_list ad_ref_list_uu varchar 36  √  NULL::character varying AD_Ref_List_UU
ad_ref_list ad_reference_id numeric 10 System Reference and Validation
ad_ref_list created timestamp 29,6 now() Date this record was created
ad_ref_list createdby numeric 10 User who created this records
ad_ref_list description varchar 255  √  null Optional short description of the record
ad_ref_list entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_ref_list isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_ref_list name varchar 60 Alphanumeric identifier of the entity
ad_ref_list updated timestamp 29,6 now() Date this record was updated
ad_ref_list updatedby numeric 10 User who updated this records
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_ref_list value varchar 60 Search key for the record in the format required - must be unique
ad_tab ad_client_id numeric 10 Client/Tenant for this installation.
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_tab ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_tab ad_image_id numeric 10  √  null Image or Icon
ad_tab ad_org_id numeric 10 Organizational entity within client
ad_tab ad_process_id numeric 10  √  null Process or Report
ad_tab ad_tab_id numeric 10 Tab within a Window
ad_tab ad_tab_uu varchar 36  √  NULL::character varying AD_Tab_UU
ad_tab ad_table_id numeric 10 Database Table information
ad_tab ad_tabtype varchar 40  √  NULL::character varying Defines Tab Type
ad_tab ad_window_id numeric 10 Data entry or display window
ad_tab commitwarning varchar 2000  √  null Warning displayed when saving
ad_tab created timestamp 29,6 now() Date this record was created
ad_tab createdby numeric 10 User who created this records
ad_tab description varchar 255  √  null Optional short description of the record
ad_tab displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_tab entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_tab hastree bpchar 1 'N'::bpchar Window has Tree Graph
ad_tab help varchar 2000  √  null Comment or Hint
ad_tab importfields bpchar 1  √  null Create Fields from Table Columns
ad_tab included_tab_id numeric 10  √  null Included Tab in this Tab (Master Detail)
ad_tab isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_tab isadvancedtab bpchar 1 'N'::bpchar This Tab contains advanced Functionality
ad_tab isallowadvancedlookup bpchar 1  √  'Y'::bpchar Allow Advanced Lookup
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_tab islookuponlyselection bpchar 1  √  'N'::bpchar When defined to true Lookup panel will display only selection columns. Default to false.
ad_tab isreadonly bpchar 1 'N'::bpchar Field is read only
ad_tab issinglerow bpchar 1 'Y'::bpchar Default for toggle between Single- and Multi-Row (Grid) Layout
ad_tab issorttab bpchar 1 'N'::bpchar The Tab determines the Order
ad_tab istranslationtab bpchar 1 'N'::bpchar This Tab contains translation information
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_tab name varchar 60 Alphanumeric identifier of the entity
ad_tab orderbyclause varchar 2000  √  null Fully qualified ORDER BY clause
ad_tab parent_column_id numeric 10  √  NULL::numeric The link column on the parent tab.
ad_tab processing bpchar 1  √  null Process Now
ad_tab readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_tab seqno numeric 10 Method of ordering records; lowest number comes first
ad_tab tablevel numeric 10 Hierarchical Tab Level (0 = top)
ad_tab treedisplayedon bpchar 1 'B'::bpchar The tree can be displayed on master tab, detail tab or both
ad_tab updated timestamp 29,6 now() Date this record was updated
ad_tab updatedby numeric 10 User who updated this records
ad_tab whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
ad_tab_customization ad_client_id numeric 10 Client/Tenant for this installation.
ad_tab_customization ad_org_id numeric 10 Organizational entity within client
ad_tab_customization ad_tab_customization_id numeric 10 NULL::numeric Tab Customization
ad_tab_customization ad_tab_customization_uu varchar 36  √  NULL::character varying AD_Tab_Customization_UU
ad_tab_customization ad_tab_id numeric 10  √  NULL::numeric Tab within a Window
ad_tab_customization ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_tab_customization created timestamp 29,6 statement_timestamp() Date this record was created
ad_tab_customization createdby numeric 10 User who created this records
ad_tab_customization custom varchar 2000 Custom
ad_tab_customization isactive bpchar 1 The record is active in the system
ad_tab_customization isautohideemptycolumn bpchar 1  √  NULL::bpchar Auto Hide Empty Column
ad_tab_customization isdisplayedgrid bpchar 1  √  NULL::bpchar Show in Grid
ad_tab_customization isquickform bpchar 1  √  'N'::bpchar Display in Quick Form
ad_tab_customization updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_tab_customization updatedby numeric 10 User who updated this records
ad_task accesslevel bpchar 1 Access Level required
ad_task ad_client_id numeric 10 Client/Tenant for this installation.
ad_task ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_task ad_org_id numeric 10 Organizational entity within client
ad_task ad_task_id numeric 10 Operation System Task
ad_task ad_task_uu varchar 36  √  NULL::character varying AD_Task_UU
ad_task created timestamp 29,6 now() Date this record was created
ad_task createdby numeric 10 User who created this records
ad_task description varchar 255  √  null Optional short description of the record
ad_task entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_task help varchar 2000  √  null Comment or Hint
ad_task isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_task isserverprocess bpchar 1  √  'N'::bpchar Run this Process on Server only
ad_task name varchar 60 Alphanumeric identifier of the entity
ad_task os_command varchar 2000 Operating System Command
ad_task updated timestamp 29,6 now() Date this record was updated
ad_task updatedby numeric 10 User who updated this records
ad_window ad_client_id numeric 10 Client/Tenant for this installation.
ad_window ad_color_id numeric 10  √  null Color for backgrounds or indicators
ad_window ad_image_id numeric 10  √  null Image or Icon
ad_window ad_org_id numeric 10 Organizational entity within client
ad_window ad_window_id numeric 10 Data entry or display window
ad_window ad_window_uu varchar 36  √  NULL::character varying AD_Window_UU
ad_window created timestamp 29,6 now() Date this record was created
ad_window createdby numeric 10 User who created this records
ad_window description varchar 255  √  null Optional short description of the record
ad_window entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_window help varchar 2000  √  null Comment or Hint
ad_window isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_window isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_window isdefault bpchar 1 'N'::bpchar Default value
ad_window issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
ad_window name varchar 60 Alphanumeric identifier of the entity
ad_window predefinedcontextvariables varchar 4000  √  NULL::character varying Predefined context variables to inject when opening a menu entry or a window
ad_window processing bpchar 1  √  null Process Now
ad_window titlelogic varchar 255  √  NULL::character varying The result determines the title to be displayed for this window
ad_window updated timestamp 29,6 now() Date this record was updated
ad_window updatedby numeric 10 User who updated this records
ad_window windowtype bpchar 1  √  null Type or classification of a Window
ad_window winheight numeric 10  √  null Window Height
ad_window winwidth numeric 10  √  null Window Width
ad_workflow accesslevel bpchar 1 Access Level required
ad_workflow ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflow ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_workflow ad_org_id numeric 10 Organizational entity within client
ad_workflow ad_table_id numeric 10  √  null Database Table information
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_workflow ad_workflow_id numeric 10 Workflow or combination of tasks
ad_workflow ad_workflow_uu varchar 36  √  NULL::character varying AD_Workflow_UU
ad_workflow ad_workflowprocessor_id numeric 10  √  null Workflow Processor Server
ad_workflow author varchar 20 'ComPiere'::character varying Author/Creator of the Entity
ad_workflow cost numeric 0 Cost information
ad_workflow created timestamp 29,6 now() Date this record was created
ad_workflow createdby numeric 10 User who created this records
ad_workflow description varchar 255  √  null Optional short description of the record
ad_workflow documentno varchar 30  √  null Document sequence number of the document
ad_workflow docvaluelogic varchar 2000  √  null Logic to determine Workflow Start - If true, a workflow process is started for the document
ad_workflow duration numeric 10 0 Normal Duration in Duration Unit
ad_workflow durationunit bpchar 1  √  null Unit of Duration
ad_workflow entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_workflow help text 2147483647  √  null Comment or Hint
ad_workflow isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_workflow isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_workflow isdefault bpchar 1 'N'::bpchar Default value
ad_workflow isvalid bpchar 1 'N'::bpchar Element is valid
ad_workflow limit numeric 10  √  null Maximum Duration in Duration Unit
ad_workflow movingtime numeric 10  √  null Moving Time
ad_workflow name varchar 60 Alphanumeric identifier of the entity
ad_workflow overlapunits numeric 0  √  null Overlap Units are number of units that must be completed before they are moved the next activity
ad_workflow priority numeric 10  √  null Indicates if this request is of a high, medium or low priority.
ad_workflow processtype bpchar 2  √  null Process Type
ad_workflow publishstatus bpchar 1 Status of Publication
ad_workflow qtybatchsize numeric 0  √  (1)::numeric Qty Batch Size
ad_workflow queuingtime numeric 10  √  null Queue time is the time a job waits at a work center before begin handled.
ad_workflow s_resource_id numeric 10  √  null Resource
ad_workflow setuptime numeric 10  √  null Setup time before starting Production
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_workflow updated timestamp 29,6 now() Date this record was updated
ad_workflow updatedby numeric 10 User who updated this records
ad_workflow validateworkflow bpchar 1  √  null Validate Workflow
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_workflow value varchar 40 Search key for the record in the format required - must be unique
ad_workflow version numeric 10 0 Version of the table definition
ad_workflow waitingtime numeric 10 0 Workflow Simulation Waiting time
ad_workflow workflowtype bpchar 1 'G'::bpchar Type of Workflow
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
asp_clientexception ad_client_id numeric 10 Client/Tenant for this installation.
asp_clientexception ad_field_id numeric 10  √  null Field on a database table
asp_clientexception ad_form_id numeric 10  √  null Special Form
asp_clientexception ad_org_id numeric 10 0 Organizational entity within client
asp_clientexception ad_process_id numeric 10  √  null Process or Report
asp_clientexception ad_process_para_id numeric 10  √  null Process Parameter
asp_clientexception ad_tab_id numeric 10  √  null Tab within a Window
asp_clientexception ad_task_id numeric 10  √  null Operation System Task
asp_clientexception ad_wf_node_id numeric 10  √  null Workflow Node (activity), step or process
asp_clientexception ad_window_id numeric 10  √  null Data entry or display window
asp_clientexception ad_workflow_id numeric 10  √  null Workflow or combination of tasks
asp_clientexception asp_clientexception_id numeric 10 Client Exception
asp_clientexception asp_clientexception_uu varchar 36  √  NULL::character varying ASP_ClientException_UU
asp_clientexception asp_status bpchar 1 'U'::bpchar ASP Status
asp_clientexception created timestamp 29,6 statement_timestamp() Date this record was created
asp_clientexception createdby numeric 10 User who created this records
asp_clientexception isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_clientexception updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_clientexception updatedby numeric 10 User who updated this records
asp_clientlevel ad_client_id numeric 10 Client/Tenant for this installation.
asp_clientlevel ad_org_id numeric 10 0 Organizational entity within client
asp_clientlevel asp_clientlevel_id numeric 10 Client Level
asp_clientlevel asp_clientlevel_uu varchar 36  √  NULL::character varying ASP_ClientLevel_UU
asp_clientlevel asp_level_id numeric 10 ASP Level
asp_clientlevel asp_module_id numeric 10 ASP Module
asp_clientlevel created timestamp 29,6 statement_timestamp() Date this record was created
asp_clientlevel createdby numeric 10 User who created this records
asp_clientlevel help varchar 2000  √  null Comment or Hint
asp_clientlevel isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_clientlevel updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_clientlevel updatedby numeric 10 User who updated this records
asp_field ad_client_id numeric 10 Client/Tenant for this installation.
asp_field ad_field_id numeric 10 Field on a database table
asp_field ad_org_id numeric 10 Organizational entity within client
asp_field asp_field_id numeric 10 ASP Field
asp_field asp_field_uu varchar 36  √  NULL::character varying ASP_Field_UU
asp_field asp_status bpchar 1 'U'::bpchar ASP Status
asp_field asp_tab_id numeric 10  √  null ASP Tab
asp_field created timestamp 29,6 statement_timestamp() Date this record was created
asp_field createdby numeric 10 User who created this records
asp_field isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_field updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_field updatedby numeric 10 User who updated this records
asp_form ad_client_id numeric 10 Client/Tenant for this installation.
asp_form ad_form_id numeric 10 Special Form
asp_form ad_org_id numeric 10 Organizational entity within client
asp_form asp_form_id numeric 10 ASP Form
asp_form asp_form_uu varchar 36  √  NULL::character varying ASP_Form_UU
asp_form asp_level_id numeric 10 ASP Level
asp_form asp_status bpchar 1 'U'::bpchar ASP Status
asp_form created timestamp 29,6 statement_timestamp() Date this record was created
asp_form createdby numeric 10 User who created this records
asp_form isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_form updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_form updatedby numeric 10 User who updated this records
asp_level ad_client_id numeric 10 Client/Tenant for this installation.
asp_level ad_org_id numeric 10 Organizational entity within client
asp_level asp_level_id numeric 10 ASP Level
asp_level asp_level_uu varchar 36  √  NULL::character varying ASP_Level_UU
asp_level asp_module_id numeric 10 ASP Module
asp_level created timestamp 29,6 statement_timestamp() Date this record was created
asp_level createdby numeric 10 User who created this records
asp_level description varchar 255  √  null Optional short description of the record
asp_level help varchar 2000  √  null Comment or Hint
asp_level isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_level name varchar 60 Alphanumeric identifier of the entity
asp_level processing bpchar 1  √  null Process Now
asp_level updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_level updatedby numeric 10 User who updated this records
asp_level value varchar 40 Search key for the record in the format required - must be unique
asp_module ad_client_id numeric 10 Client/Tenant for this installation.
asp_module ad_org_id numeric 10 Organizational entity within client
asp_module asp_module_id numeric 10 ASP Module
asp_module asp_module_uu varchar 36  √  NULL::character varying ASP_Module_UU
asp_module created timestamp 29,6 statement_timestamp() Date this record was created
asp_module createdby numeric 10 User who created this records
asp_module description varchar 255  √  null Optional short description of the record
asp_module help varchar 2000  √  null Comment or Hint
asp_module isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_module name varchar 60 Alphanumeric identifier of the entity
asp_module updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_module updatedby numeric 10 User who updated this records
asp_module value varchar 40 Search key for the record in the format required - must be unique
asp_process ad_client_id numeric 10 Client/Tenant for this installation.
asp_process ad_org_id numeric 10 Organizational entity within client
asp_process ad_process_id numeric 10 Process or Report
asp_process asp_level_id numeric 10 ASP Level
asp_process asp_process_id numeric 10 ASP Process
asp_process asp_process_uu varchar 36  √  NULL::character varying ASP_Process_UU
asp_process asp_status bpchar 1 'U'::bpchar ASP Status
asp_process created timestamp 29,6 statement_timestamp() Date this record was created
asp_process createdby numeric 10 User who created this records
asp_process isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_process updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_process updatedby numeric 10 User who updated this records
asp_process_para ad_client_id numeric 10 Client/Tenant for this installation.
asp_process_para ad_org_id numeric 10 Organizational entity within client
asp_process_para ad_process_para_id numeric 10 Process Parameter
asp_process_para asp_process_id numeric 10  √  null ASP Process
asp_process_para asp_process_para_id numeric 10 ASP Process Parameter
asp_process_para asp_process_para_uu varchar 36  √  NULL::character varying ASP_Process_Para_UU
asp_process_para asp_status bpchar 1 'U'::bpchar ASP Status
asp_process_para created timestamp 29,6 statement_timestamp() Date this record was created
asp_process_para createdby numeric 10 User who created this records
asp_process_para isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_process_para updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_process_para updatedby numeric 10 User who updated this records
asp_ref_list ad_client_id numeric 10 Client/Tenant for this installation.
asp_ref_list ad_org_id numeric 10 Organizational entity within client
asp_ref_list ad_ref_list_id numeric 10 Reference List based on Table
asp_ref_list ad_reference_id numeric 10 System Reference and Validation
asp_ref_list asp_level_id numeric 10 ASP Level
asp_ref_list asp_ref_list_id numeric 10 ASP_Ref_List
asp_ref_list asp_ref_list_uu varchar 36  √  NULL::character varying ASP_Ref_List_UU
asp_ref_list asp_status bpchar 1  √  'U'::bpchar ASP Status
asp_ref_list created timestamp 29,6 statement_timestamp() Date this record was created
asp_ref_list createdby numeric 10 User who created this records
asp_ref_list isactive bpchar 1  √  'Y'::bpchar The record is active in the system
asp_ref_list updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_ref_list updatedby numeric 10 User who updated this records
asp_tab ad_client_id numeric 10 Client/Tenant for this installation.
asp_tab ad_org_id numeric 10 Organizational entity within client
asp_tab ad_tab_id numeric 10 Tab within a Window
asp_tab allfields bpchar 1  √  'Y'::bpchar AllFields
asp_tab asp_status bpchar 1 'U'::bpchar ASP Status
asp_tab asp_tab_id numeric 10 ASP Tab
asp_tab asp_tab_uu varchar 36  √  NULL::character varying ASP_Tab_UU
asp_tab asp_window_id numeric 10  √  null ASP Window
asp_tab created timestamp 29,6 statement_timestamp() Date this record was created
asp_tab createdby numeric 10 User who created this records
asp_tab isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_tab processing bpchar 1  √  null Process Now
asp_tab updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_tab updatedby numeric 10 User who updated this records
asp_task ad_client_id numeric 10 Client/Tenant for this installation.
asp_task ad_org_id numeric 10 Organizational entity within client
asp_task ad_task_id numeric 10 Operation System Task
asp_task asp_level_id numeric 10 ASP Level
asp_task asp_status bpchar 1 'U'::bpchar ASP Status
asp_task asp_task_id numeric 10 ASP Task
asp_task asp_task_uu varchar 36  √  NULL::character varying ASP_Task_UU
asp_task created timestamp 29,6 statement_timestamp() Date this record was created
asp_task createdby numeric 10 User who created this records
asp_task isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_task updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_task updatedby numeric 10 User who updated this records
asp_window ad_client_id numeric 10 Client/Tenant for this installation.
asp_window ad_org_id numeric 10 Organizational entity within client
asp_window ad_window_id numeric 10 Data entry or display window
asp_window asp_level_id numeric 10 ASP Level
asp_window asp_status bpchar 1 'U'::bpchar ASP Status
asp_window asp_window_id numeric 10 ASP Window
asp_window asp_window_uu varchar 36  √  NULL::character varying ASP_Window_UU
asp_window created timestamp 29,6 statement_timestamp() Date this record was created
asp_window createdby numeric 10 User who created this records
asp_window isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_window updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_window updatedby numeric 10 User who updated this records
asp_workflow ad_client_id numeric 10 Client/Tenant for this installation.
asp_workflow ad_org_id numeric 10 Organizational entity within client
asp_workflow ad_workflow_id numeric 10 Workflow or combination of tasks
asp_workflow asp_level_id numeric 10 ASP Level
asp_workflow asp_status bpchar 1 'U'::bpchar ASP Status
asp_workflow asp_workflow_id numeric 10 ASP Workflow
asp_workflow asp_workflow_uu varchar 36  √  NULL::character varying ASP_Workflow_UU
asp_workflow created timestamp 29,6 statement_timestamp() Date this record was created
asp_workflow createdby numeric 10 User who created this records
asp_workflow isactive bpchar 1 'Y'::bpchar The record is active in the system
asp_workflow updated timestamp 29,6 statement_timestamp() Date this record was updated
asp_workflow updatedby numeric 10 User who updated this records