SchemaSpy Analysis of idempiere11.adempiere - ColumnsWorkflow | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:57 +0100 |
| |||||
|
idempiere11.adempiere contains 732 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
ad_workflow | author | varchar | 20 | 'ComPiere'::character varying | Author/Creator of the Entity | ||
ad_process_para | daterangeoption | bpchar | 1 | 'D'::bpchar | Options, how the date editor will be displayed. | ||
ad_column | 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_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_table | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_wf_nextcondition | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_wf_node_para | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_wf_nodenext | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_wf_responsible | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_workflow | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_workflow | workflowtype | bpchar | 1 | 'G'::bpchar | Type of Workflow | ||
ad_table | replicationtype | bpchar | 1 | 'L'::bpchar | Type of Data Replication | ||
ad_column | fkconstrainttype | bpchar | 1 | √ | 'N'::bpchar | Constraint Type | |
ad_process | isdirectprint | bpchar | 1 | √ | 'N'::bpchar | Print without dialog | |
ad_column | ishtml | bpchar | 1 | √ | 'N'::bpchar | Text has HTML tags | |
ad_wf_node | ismilestone | bpchar | 1 | √ | 'N'::bpchar | Is Milestone | |
ad_wf_node | issubcontracting | bpchar | 1 | √ | 'N'::bpchar | Is Subcontracting | |
ad_column | issyncdatabase | bpchar | 1 | √ | 'N'::bpchar | Change database table definition when changing dictionary definition | |
ad_note | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
ad_user | isaddmailtextautomatically | bpchar | 1 | 'N'::bpchar | The selected mail template will be automatically inserted when creating an email | ||
ad_column | isalwaysupdateable | bpchar | 1 | 'N'::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 text fields | ||
ad_process_para | isautocomplete | bpchar | 1 | 'N'::bpchar | Automatic completion for text fields | ||
ad_process | isbetafunctionality | bpchar | 1 | 'N'::bpchar | This functionality is considered Beta | ||
ad_workflow | isbetafunctionality | bpchar | 1 | 'N'::bpchar | This functionality is considered Beta | ||
ad_user | isbillto | bpchar | 1 | 'N'::bpchar | Business Partner Invoice/Bill Address | ||
ad_table | ischangelog | bpchar | 1 | 'N'::bpchar | Maintain a log of changes | ||
ad_workflow | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
ad_column | isencrypted | bpchar | 1 | 'N'::bpchar | Display or Storage is encrypted | ||
ad_process_para | isencrypted | bpchar | 1 | 'N'::bpchar | Display or Storage is encrypted | ||
ad_user | isexpired | bpchar | 1 | 'N'::bpchar | Expired | ||
ad_table | ishighvolume | bpchar | 1 | 'N'::bpchar | Use Search instead of Pick list | ||
r_mailtext | ishtml | bpchar | 1 | 'N'::bpchar | Text has HTML tags | ||
ad_column | isidentifier | bpchar | 1 | 'N'::bpchar | This column is part of the record identifier | ||
ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | Defined if any User Contact will be used for Calculate Payroll | ||
ad_column | iskey | bpchar | 1 | 'N'::bpchar | This column is the key in this table | ||
ad_user | islocked | bpchar | 1 | 'N'::bpchar | Locked | ||
ad_column | 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_user | isnoexpire | bpchar | 1 | 'N'::bpchar | No Expire | ||
ad_user | isnopasswordreset | bpchar | 1 | 'N'::bpchar | No Password Reset | ||
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_table | ispartition | bpchar | 1 | 'N'::bpchar | This is a partitioned table | ||
ad_column | ispartitionkey | bpchar | 1 | 'N'::bpchar | This is a partition key | ||
ad_process_para | isrange | bpchar | 1 | 'N'::bpchar | The parameter is a range of values | ||
ad_user | issaleslead | bpchar | 1 | 'N'::bpchar | This contact is a sales lead | ||
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_user | isshipto | bpchar | 1 | 'N'::bpchar | Business Partner Shipment Address | ||
ad_process_para | isshownegatebutton | bpchar | 1 | 'N'::bpchar | Show Negate Button for Chosen Multiple editors | ||
ad_wf_nodenext | isstduserworkflow | bpchar | 1 | 'N'::bpchar | Standard Manual User Approval Workflow | ||
ad_user | issupportuser | bpchar | 1 | 'N'::bpchar | Support User | ||
ad_column | istranslated | bpchar | 1 | 'N'::bpchar | This column is translated | ||
ad_wf_node_trl | istranslated | bpchar | 1 | 'N'::bpchar | This column is translated | ||
ad_workflow_trl | istranslated | bpchar | 1 | 'N'::bpchar | This column is translated | ||
r_mailtext_trl | istranslated | bpchar | 1 | 'N'::bpchar | This column is translated | ||
ad_workflow | isvalid | bpchar | 1 | 'N'::bpchar | Element is valid | ||
ad_user | isvendorlead | bpchar | 1 | 'N'::bpchar | This contact is a vendor lead | ||
ad_table | isview | bpchar | 1 | 'N'::bpchar | This is a view | ||
ad_wf_activity | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
ad_wf_process | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
ad_process | allowmultipleexecution | varchar | 2 | 'P'::character varying | Allow or disallow executing a process/report multiple times concurrently | ||
ad_image | entitytype | varchar | 40 | 'U'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_wf_node | entitytype | varchar | 40 | 'U'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
ad_column | isallowlogging | bpchar | 1 | √ | 'Y'::bpchar | Determine if a column must be recorded into the change log | |
ad_table | iscentrallymaintained | bpchar | 1 | √ | 'Y'::bpchar | Information maintained in System Element table | |
ad_table | isshowindrilloptions | bpchar | 1 | √ | 'Y'::bpchar | This parameter enables the table to be displayed in Drill Assistant - Table tab | |
ad_process | showhelp | bpchar | 1 | √ | 'Y'::bpchar | Show Help | |
ad_attachment | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_attachmentnote | 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_find | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_image | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_message | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_note | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_process | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_process_para | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_table | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_user | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_activity | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_activityapprover | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_activityresult | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_block | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_eventaudit | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_nextcondition | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_node | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_node_para | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_node_trl | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_nodenext | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_process | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_processdata | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wf_responsible | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_wizardprocess | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_workflow | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_workflow_access | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_workflow_trl | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_workflowprocessor | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
r_mailtext | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
r_mailtext_trl | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_column | isallowcopy | bpchar | 1 | 'Y'::bpchar | Determine if a column must be copied when pushing the button to copy record | ||
ad_wf_node | isattacheddocumenttoemail | bpchar | 1 | 'Y'::bpchar | Attached document to Email | ||
ad_process_para | iscentrallymaintained | bpchar | 1 | 'Y'::bpchar | Information maintained in System Element table | ||
ad_wf_node | iscentrallymaintained | bpchar | 1 | 'Y'::bpchar | Information maintained in System Element table | ||
ad_table | isdeleteable | bpchar | 1 | 'Y'::bpchar | Indicates if records can be deleted from the database | ||
ad_user | isfullbpaccess | bpchar | 1 | 'Y'::bpchar | The user/contact has full access to Business Partner information and resources | ||
ad_workflow_access | isreadwrite | bpchar | 1 | 'Y'::bpchar | Field is read / write | ||
ad_process | isreport | bpchar | 1 | 'Y'::bpchar | Indicates a Report record | ||
ad_column | istoolbarbutton | bpchar | 1 | 'Y'::bpchar | Show the button on the toolbar, the window, or both | ||
ad_column | isupdateable | bpchar | 1 | 'Y'::bpchar | Determines, if the field can be updated | ||
ad_wf_node | unitscycles | numeric | 0 | √ | (0)::numeric | 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_user | failedlogincount | numeric | 10 | (0)::numeric | Failed Login Count | ||
ad_workflow | qtybatchsize | numeric | 0 | √ | (1)::numeric | Qty Batch Size | |
ad_wf_node | 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 | |
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 | |
ad_workflowprocessor | inactivityalertdays | numeric | 10 | √ | 0 | Send Alert when there is no activity after days (0= no alert) | |
ad_workflowprocessor | reminddays | numeric | 10 | √ | 0 | Days between sending Reminder Emails for a due or inactive Document | |
ad_wf_node | cost | numeric | 0 | 0 | Cost information | ||
ad_wf_node | duration | numeric | 10 | 0 | Normal Duration in Duration Unit | ||
ad_workflow | duration | numeric | 10 | 0 | Normal Duration in Duration Unit | ||
ad_wf_node | limit | numeric | 10 | 0 | Maximum Duration in Duration Unit | ||
ad_workflow | version | numeric | 10 | 0 | Version of the table definition | ||
ad_wf_node | waitingtime | numeric | 10 | 0 | Workflow Simulation Waiting time | ||
ad_workflow | waitingtime | numeric | 10 | 0 | Workflow Simulation Waiting time | ||
ad_workflow | workingtime | numeric | 10 | 0 | Workflow Simulation Execution Time | ||
ad_wf_node | xposition | numeric | 10 | 0 | Absolute X (horizontal) position in 1/72 of an inch | ||
ad_wf_node | yposition | numeric | 10 | 0 | Absolute Y (vertical) position in 1/72 of an inch | ||
ad_attachment | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_attachmentnote | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_column | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_find | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_image | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_message | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_note | created | timestamp | 29,6 | now() | 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_table | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_user | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_activity | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_activityresult | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_block | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_eventaudit | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_nextcondition | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_node | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_node_para | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_node_trl | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_nodenext | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_process | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_processdata | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_wf_responsible | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_workflow | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_workflow_access | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_workflow_trl | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_workflowprocessor | created | timestamp | 29,6 | now() | Date this record was created | ||
r_mailtext | created | timestamp | 29,6 | now() | Date this record was created | ||
r_mailtext_trl | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_attachment | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_attachmentnote | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_column | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_find | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_image | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_message | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_note | updated | timestamp | 29,6 | now() | 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_table | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_user | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_activity | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_activityresult | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_block | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_eventaudit | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_nextcondition | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_node | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_node_para | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_node_trl | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_nodenext | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_process | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_processdata | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_responsible | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_workflow | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_workflow_access | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_workflow_trl | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_workflowprocessor | updated | timestamp | 29,6 | now() | Date this record was updated | ||
r_mailtext | updated | timestamp | 29,6 | now() | Date this record was updated | ||
r_mailtext_trl | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_wf_nextcondition | ad_column_id | numeric | 10 | √ | null | Column in the table | |
ad_wf_node | ad_column_id | numeric | 10 | √ | null | Column in the table | |
ad_column | 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_process | ad_form_id | numeric | 10 | √ | null | Special Form | |
ad_wf_node | ad_form_id | numeric | 10 | √ | null | Special Form | |
ad_wf_node | ad_image_id | numeric | 10 | √ | null | Image or Icon | |
ad_column | ad_infowindow_id | numeric | 10 | √ | null | Info and search/select Window | |
ad_wf_activity | ad_message_id | numeric | 10 | √ | null | System Message | |
ad_wf_process | ad_message_id | numeric | 10 | √ | null | System Message | |
ad_user | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
ad_process | ad_printformat_id | numeric | 10 | √ | null | Data Print Format | |
ad_column | ad_process_id | numeric | 10 | √ | null | Process or Report | |
ad_wf_node | ad_process_id | numeric | 10 | √ | null | Process or Report | |
ad_wf_node_para | ad_process_para_id | numeric | 10 | √ | null | Process Parameter | |
ad_column | ad_reference_value_id | numeric | 10 | √ | null | 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_process | ad_reportview_id | numeric | 10 | √ | null | View used to generate this report | |
ad_wf_responsible | ad_role_id | numeric | 10 | √ | null | Responsibility Role | |
ad_note | ad_table_id | numeric | 10 | √ | null | Database Table information | |
ad_workflow | ad_table_id | numeric | 10 | √ | null | Database Table information | |
ad_wf_node | ad_task_id | numeric | 10 | √ | null | Operation System Task | |
ad_note | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
ad_wf_activity | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
ad_wf_eventaudit | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
ad_wf_process | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
ad_wf_responsible | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
ad_column | ad_val_rule_id | numeric | 10 | √ | null | 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_note | ad_wf_activity_id | numeric | 10 | √ | null | Workflow Activity | |
ad_wf_node | ad_wf_block_id | numeric | 10 | √ | null | Workflow Transaction Execution Block | |
ad_workflow | ad_wf_node_id | numeric | 10 | √ | null | Workflow Node (activity), step or process | |
ad_wf_activity | ad_wf_responsible_id | numeric | 10 | √ | null | Responsible for Workflow Execution | |
ad_wf_node | ad_wf_responsible_id | numeric | 10 | √ | null | Responsible for Workflow Execution | |
ad_workflow | ad_wf_responsible_id | numeric | 10 | √ | null | Responsible for Workflow Execution | |
ad_table | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
ad_wf_node | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
ad_process | ad_workflow_id | numeric | 10 | √ | null | Workflow or combination of tasks | |
ad_workflow | ad_workflowprocessor_id | numeric | 10 | √ | null | Workflow Processor Server | |
ad_workflowprocessor | alertoverpriority | numeric | 10 | √ | null | Send alert email when over priority | |
ad_wf_eventaudit | attributename | varchar | 60 | √ | null | Name of the Attribute | |
ad_wf_node | attributename | varchar | 60 | √ | null | Name of the Attribute | |
ad_wf_node_para | attributename | varchar | 60 | √ | null | Name of the Attribute | |
ad_wf_activityresult | attributevalue | varchar | 2000 | √ | null | Value of the Attribute | |
ad_wf_node | attributevalue | varchar | 60 | √ | null | Value of the Attribute | |
ad_wf_node_para | attributevalue | varchar | 60 | √ | null | Value of the Attribute | |
ad_wf_processdata | attributevalue | varchar | 60 | √ | null | Value of the Attribute | |
ad_attachment | binarydata | bytea | 2147483647 | √ | null | Binary Data | |
ad_image | binarydata | bytea | 2147483647 | √ | null | Binary Data | |
ad_user | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
ad_user | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
ad_wf_node | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
ad_user | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
ad_user | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
ad_user | c_job_id | numeric | 10 | √ | null | Job Position | |
ad_column | callout | varchar | 255 | √ | null | Fully qualified class names and method - separated by semicolons | |
ad_process | classname | varchar | 255 | √ | null | Java Classname | |
ad_column | columnsql | varchar | 4000 | √ | null | Virtual Column (r/o) | |
ad_user | comments | varchar | 2000 | √ | null | Comments or additional information | |
ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
ad_table | copycolumnsfromtable | varchar | 1 | √ | null | Copy Columns From Table | |
ad_user | dateaccountlocked | timestamp | 29,6 | √ | null | Date Account Locked | |
ad_wf_activity | datelastalert | timestamp | 29,6 | √ | null | Date when last alert were sent | |
ad_user | datelastlogin | timestamp | 29,6 | √ | null | Date Last Login | |
ad_workflowprocessor | datelastrun | timestamp | 29,6 | √ | null | Date the process was last run. | |
ad_workflowprocessor | datenextrun | timestamp | 29,6 | √ | null | Date the process will run next | |
ad_user | datepasswordchanged | timestamp | 29,6 | √ | null | Date Password Changed | |
ad_column | defaultvalue | varchar | 2000 | √ | null | Default value hierarchy, separated by ; | |
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_column | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_image | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_note | 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_table | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_user | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_wf_activityresult | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_wf_block | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_wf_eventaudit | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_wf_node | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_wf_node_para | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_wf_node_trl | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_wf_nodenext | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_wf_responsible | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_workflow | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_workflow_trl | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_workflowprocessor | 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_wf_node | docaction | bpchar | 2 | √ | null | The targeted status of the document | |
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 | durationunit | bpchar | 1 | √ | null | Unit of Duration | |
ad_wf_node | dynprioritychange | numeric | 0 | √ | null | Change of priority when Activity is suspended waiting for user | |
ad_wf_activity | dynprioritystart | numeric | 10 | √ | null | Starting priority before changed dynamically | |
ad_wf_node | dynpriorityunit | bpchar | 1 | √ | null | Change of priority when Activity is suspended waiting for user | |
ad_user | varchar | 60 | √ | null | Electronic Mail Address | ||
ad_wf_node | varchar | 60 | √ | null | Electronic Mail Address | ||
ad_wf_node | emailrecipient | bpchar | 1 | √ | null | Recipient of the EMail | |
ad_user | emailuser | varchar | 60 | √ | null | User Name (ID) in the Mail System | |
ad_user | emailuserpw | varchar | 255 | √ | null | Password of your email user id | |
ad_user | emailverify | varchar | 40 | √ | null | Verification information of EMail Address | |
ad_user | emailverifydate | timestamp | 29,6 | √ | null | Date Email was verified | |
ad_wf_activity | endwaittime | timestamp | 29,6 | √ | null | End of sleep time | |
ad_user | fax | varchar | 40 | √ | null | Facsimile number | |
ad_column | fieldlength | numeric | 10 | √ | null | Length of the column in the database | |
ad_wf_node | finishmode | bpchar | 1 | √ | null | Workflow Activity Finish Mode | |
ad_column | formatpattern | varchar | 22 | √ | null | The pattern used to format a number or date. | |
ad_workflowprocessor | frequency | numeric | 10 | √ | null | Frequency of events | |
ad_workflowprocessor | frequencytype | bpchar | 1 | √ | null | Frequency of event | |
ad_column | 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_table | help | varchar | 2000 | √ | null | Comment or Hint | |
ad_wf_activityresult | help | varchar | 2000 | √ | null | Comment or Hint | |
ad_wf_node | help | text | 2147483647 | √ | null | Comment or Hint | |
ad_wf_node_trl | help | text | 2147483647 | √ | null | Comment or Hint | |
ad_workflow | help | text | 2147483647 | √ | null | Comment or Hint | |
ad_workflow_trl | help | text | 2147483647 | √ | null | Comment or Hint | |
ad_image | imageurl | varchar | 120 | √ | null | URL of image | |
ad_table | importtable | bpchar | 1 | √ | null | Import Table Columns from Database | |
ad_column | infofactoryclass | varchar | 255 | √ | null | Fully qualified class name that implements the InfoFactory interface | |
ad_user | ismenuautoexpand | bpchar | 1 | √ | null | If ticked, the menu is automatically expanded | |
ad_process | isserverprocess | bpchar | 1 | √ | null | Run this Process on Server only | |
ad_process | jasperreport | varchar | 255 | √ | null | Jasper Report | |
ad_user | lastcontact | timestamp | 29,6 | √ | null | Date this individual was last contacted | |
ad_user | lastresult | varchar | 255 | √ | null | Result of last contact | |
ad_user | ldapuser | varchar | 60 | √ | null | User Name used for authorization via LDAP (directory) services | |
ad_workflow | limit | numeric | 10 | √ | null | Maximum Duration in Duration Unit | |
ad_table | loadseq | numeric | 10 | √ | null | Sequence | |
r_mailtext | mailheader | varchar | 2000 | √ | null | Mail Header (Subject) | |
r_mailtext_trl | mailheader | varchar | 2000 | √ | null | Mail Header (Subject) | |
r_mailtext | mailtext2 | varchar | 2000 | √ | null | Optional second text part used for Mail message | |
r_mailtext_trl | mailtext2 | varchar | 2000 | √ | null | Optional second text part used for Mail message | |
r_mailtext | mailtext3 | varchar | 2000 | √ | null | Optional third text part used for Mail message | |
r_mailtext_trl | mailtext3 | varchar | 2000 | √ | null | Optional third text part used for Mail message | |
ad_column | mandatorylogic | varchar | 2000 | √ | null | Mandatory Logic | |
ad_wf_node | movingtime | numeric | 10 | √ | null | Moving Time | |
ad_workflow | movingtime | numeric | 10 | √ | null | Moving Time | |
ad_message | msgtip | varchar | 2000 | √ | null | Additional tip or help for this message | |
ad_wf_eventaudit | newvalue | varchar | 2000 | √ | null | New field value | |
ad_wf_eventaudit | oldvalue | varchar | 2000 | √ | null | The old file data | |
ad_wf_node | overlapunits | numeric | 10 | √ | null | Overlap Units are number of units that must be completed before they are moved the next activity | |
ad_workflow | overlapunits | numeric | 0 | √ | null | Overlap Units are number of units that must be completed before they are moved the next activity | |
ad_user | password | varchar | 1024 | √ | null | Password of any length (case sensitive) | |
ad_user | phone | varchar | 40 | √ | null | Identifies a telephone number | |
ad_user | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
ad_table | po_window_id | numeric | 10 | √ | null | Purchase Order Window | |
ad_wf_activity | priority | numeric | 10 | √ | null | Indicates if this request is of a high, medium or low priority. | |
ad_wf_node | priority | numeric | 10 | √ | null | Indicates if this request is of a high, medium or low priority. | |
ad_wf_process | priority | numeric | 10 | √ | null | Indicates if this request is of a high, medium or low priority. | |
ad_workflow | priority | numeric | 10 | √ | null | Indicates if this request is of a high, medium or low priority. | |
ad_process | procedurename | varchar | 60 | √ | null | Name of the Database Procedure | |
ad_note | processing | bpchar | 1 | √ | null | Process Now | |
ad_user | processing | bpchar | 1 | √ | null | Process Now | |
ad_wf_activity | processing | bpchar | 1 | √ | null | Process Now | |
ad_wf_process | processing | bpchar | 1 | √ | null | Process Now | |
ad_workflowprocessor | processing | bpchar | 1 | √ | null | Process Now | |
ad_workflow | processtype | bpchar | 2 | √ | null | Process Type | |
ad_wf_node | queuingtime | numeric | 10 | √ | null | Queue time is the time a job waits at a work center before begin handled. | |
ad_workflow | queuingtime | numeric | 10 | √ | null | Queue time is the time a job waits at a work center before begin handled. | |
ad_wf_node | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
ad_column | readonlylogic | varchar | 2000 | √ | null | 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_attachment | record_id | numeric | 10 | √ | null | Direct internal record ID | |
ad_note | record_id | numeric | 10 | √ | null | Direct internal record ID | |
ad_note | reference | varchar | 255 | √ | null | Reference for this record | |
ad_wf_node | s_resource_id | numeric | 10 | √ | null | Resource | |
ad_workflow | s_resource_id | numeric | 10 | √ | null | Resource | |
ad_user | securityquestion | varchar | 1024 | √ | null | Security Question | |
ad_column | seqno | numeric | 10 | √ | null | Method of ordering records; lowest number comes first | |
ad_wf_node | setuptime | numeric | 10 | √ | null | Setup time before starting Production | |
ad_workflow | setuptime | numeric | 10 | √ | null | Setup time before starting Production | |
ad_wf_node | startmode | bpchar | 1 | √ | null | Workflow Activity Start Mode | |
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_wf_node | subflowexecution | bpchar | 1 | √ | null | Mode how the sub-workflow is executed | |
ad_user | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
ad_attachment | textmsg | varchar | 2000 | √ | null | Text Message | |
ad_note | textmsg | varchar | 2000 | √ | null | Text Message | |
ad_wf_activity | textmsg | varchar | 2000 | √ | null | Text Message | |
ad_wf_eventaudit | textmsg | varchar | 2000 | √ | null | Text Message | |
ad_wf_process | textmsg | varchar | 2000 | √ | null | Text Message | |
ad_user | title | varchar | 40 | √ | null | Name this entity is referred to as | |
ad_wf_nodenext | transitioncode | varchar | 2000 | √ | null | Code resulting in TRUE of FALSE | |
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_user | userpin | varchar | 20 | √ | null | User PIN | |
ad_workflow | validateworkflow | bpchar | 1 | √ | null | Validate Workflow | |
ad_wf_node | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
ad_workflow | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
ad_wf_node | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
ad_workflow | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
ad_user | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
ad_find | value2 | varchar | 40 | √ | null | Value To | |
ad_wf_nextcondition | value2 | varchar | 40 | √ | null | Value To | |
ad_column | valuemax | varchar | 20 | √ | null | Maximum Value for a field | |
ad_process_para | valuemax | varchar | 20 | √ | null | Maximum 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_column | vformat | varchar | 255 | √ | null | 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_wf_node | waittime | numeric | 10 | √ | null | Time in minutes to wait (sleep) | |
ad_wf_node | workflow_id | numeric | 10 | √ | null | Workflow or tasks | |
ad_process | workflowvalue | varchar | 40 | √ | null | Key of the Workflow to start | |
ad_wf_node | workingtime | numeric | 10 | √ | null | Workflow Simulation Execution Time | |
ad_process | accesslevel | bpchar | 1 | Access Level required | |||
ad_table | accesslevel | bpchar | 1 | Access Level required | |||
ad_workflow | accesslevel | bpchar | 1 | Access Level required | |||
ad_wf_node | action | bpchar | 1 | Indicates the Action to be performed | |||
ad_attachment | ad_attachment_id | numeric | 10 | Attachment for the document | |||
ad_attachmentnote | ad_attachment_id | numeric | 10 | Attachment for the document | |||
ad_attachmentnote | ad_attachmentnote_id | numeric | 10 | Personal Attachment Note | |||
ad_attachment | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_attachmentnote | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_column | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_find | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_image | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_message | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_note | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_process | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_process_para | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_table | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_user | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_activity | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_activityapprover | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_activityresult | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_block | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_eventaudit | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_nextcondition | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_node | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_node_para | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_node_trl | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_nodenext | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_process | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_processdata | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_responsible | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wizardprocess | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_workflow | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_workflow_access | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_workflow_trl | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_workflowprocessor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_mailtext | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_mailtext_trl | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_column | ad_column_id | numeric | 10 | Column in the table | |||
ad_find | ad_column_id | numeric | 10 | Column in the table | |||
ad_find | ad_find_id | numeric | 10 | Find | |||
ad_image | ad_image_id | numeric | 10 | Image or Icon | |||
ad_wf_node_trl | ad_language | varchar | 6 | Language for this entity | |||
ad_workflow_trl | ad_language | varchar | 6 | Language for this entity | |||
r_mailtext_trl | ad_language | varchar | 6 | Language for this entity | |||
ad_message | ad_message_id | numeric | 10 | System Message | |||
ad_note | ad_message_id | numeric | 10 | System Message | |||
ad_note | ad_note_id | numeric | 10 | System Notice | |||
ad_attachment | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_attachmentnote | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_column | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_find | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_image | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_message | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_note | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_process | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_process_para | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_table | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_user | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_activity | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_activityapprover | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_activityresult | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_block | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_eventaudit | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_nextcondition | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_node | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_node_para | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_node_trl | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_nodenext | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_process | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_processdata | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_responsible | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wizardprocess | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_workflow | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_workflow_access | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_workflow_trl | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_workflowprocessor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_mailtext | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_mailtext_trl | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_process | ad_process_id | numeric | 10 | Process or Report | |||
ad_process_para | ad_process_id | numeric | 10 | Process or Report | |||
ad_process_para | ad_process_para_id | numeric | 10 | Process Parameter | |||
ad_column | ad_reference_id | numeric | 10 | System Reference and Validation | |||
ad_process_para | ad_reference_id | numeric | 10 | System Reference and Validation | |||
ad_workflow_access | ad_role_id | numeric | 10 | Responsibility Role | |||
ad_attachment | ad_table_id | numeric | 10 | Database Table information | |||
ad_column | ad_table_id | numeric | 10 | Database Table information | |||
ad_table | ad_table_id | numeric | 10 | Database Table information | |||
ad_wf_activity | ad_table_id | numeric | 10 | Database Table information | |||
ad_wf_eventaudit | ad_table_id | numeric | 10 | Database Table information | |||
ad_wf_process | ad_table_id | numeric | 10 | Database Table information | |||
ad_attachmentnote | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_user | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_wf_activityapprover | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_wf_activity | ad_wf_activity_id | numeric | 10 | Workflow Activity | |||
ad_wf_activityapprover | ad_wf_activity_id | numeric | 10 | Workflow Activity | |||
ad_wf_activityresult | ad_wf_activity_id | numeric | 10 | Workflow Activity | |||
ad_wf_activityapprover | ad_wf_activityapprover_id | numeric | 10 | Workflow Activity Approver | |||
ad_wf_activityresult | ad_wf_activityresult_id | numeric | 10 | Result of the Workflow Process Activity | |||
ad_wf_block | ad_wf_block_id | numeric | 10 | Workflow Transaction Execution Block | |||
ad_wf_eventaudit | ad_wf_eventaudit_id | numeric | 10 | Workflow Process Activity Event Audit Information | |||
ad_wf_nodenext | ad_wf_next_id | numeric | 10 | Next Node in workflow | |||
ad_wf_nextcondition | ad_wf_nextcondition_id | numeric | 10 | Workflow Node Transition Condition | |||
ad_wf_activity | ad_wf_node_id | numeric | 10 | Workflow Node (activity), step or process | |||
ad_wf_eventaudit | ad_wf_node_id | numeric | 10 | Workflow Node (activity), step or process | |||
ad_wf_node | ad_wf_node_id | numeric | 10 | Workflow Node (activity), step or process | |||
ad_wf_node_para | ad_wf_node_id | numeric | 10 | Workflow Node (activity), step or process | |||
ad_wf_node_trl | ad_wf_node_id | numeric | 10 | Workflow Node (activity), step or process | |||
ad_wf_nodenext | ad_wf_node_id | numeric | 10 | Workflow Node (activity), step or process | |||
ad_wizardprocess | ad_wf_node_id | numeric | 10 | Workflow Node (activity), step or process | |||
ad_wf_node_para | ad_wf_node_para_id | numeric | 10 | Workflow Node Execution Parameter | |||
ad_wf_nextcondition | ad_wf_nodenext_id | numeric | 10 | Workflow Node Transition | |||
ad_wf_nodenext | ad_wf_nodenext_id | numeric | 10 | Workflow Node Transition | |||
ad_wf_activity | ad_wf_process_id | numeric | 10 | Actual Workflow Process Instance | |||
ad_wf_eventaudit | ad_wf_process_id | numeric | 10 | Actual Workflow Process Instance | |||
ad_wf_process | ad_wf_process_id | numeric | 10 | Actual Workflow Process Instance | |||
ad_wf_processdata | ad_wf_process_id | numeric | 10 | Actual Workflow Process Instance | |||
ad_wf_processdata | ad_wf_processdata_id | numeric | 10 | Workflow Process Context | |||
ad_wf_eventaudit | ad_wf_responsible_id | numeric | 10 | Responsible for Workflow Execution | |||
ad_wf_process | ad_wf_responsible_id | numeric | 10 | Responsible for Workflow Execution | |||
ad_wf_responsible | ad_wf_responsible_id | numeric | 10 | Responsible for Workflow Execution | |||
ad_wizardprocess | ad_wizardprocess_id | numeric | 10 | Wizard Process | |||
ad_wf_activity | ad_workflow_id | numeric | 10 | Workflow or combination of tasks | |||
ad_wf_block | ad_workflow_id | numeric | 10 | Workflow or combination of tasks | |||
ad_wf_node | ad_workflow_id | numeric | 10 | Workflow or combination of tasks | |||
ad_wf_process | ad_workflow_id | numeric | 10 | Workflow or combination of tasks | |||
ad_workflow | ad_workflow_id | numeric | 10 | Workflow or combination of tasks | |||
ad_workflow_access | ad_workflow_id | numeric | 10 | Workflow or combination of tasks | |||
ad_workflow_trl | ad_workflow_id | numeric | 10 | Workflow or combination of tasks | |||
ad_workflowprocessor | ad_workflowprocessor_id | numeric | 10 | Workflow Processor Server | |||
ad_find | andor | bpchar | 1 | Logical operation: AND or OR | |||
ad_wf_nextcondition | andor | bpchar | 1 | Logical operation: AND or OR | |||
ad_wf_activityresult | attributename | varchar | 60 | Name of the Attribute | |||
ad_wf_processdata | attributename | varchar | 60 | Name of the Attribute | |||
ad_column | columnname | varchar | 30 | Name of the column in the database | |||
ad_process_para | columnname | varchar | 30 | Name of the column in the database | |||
ad_workflow | cost | numeric | 0 | Cost information | |||
ad_attachment | createdby | numeric | 10 | User who created this records | |||
ad_attachmentnote | createdby | numeric | 10 | User who created this records | |||
ad_column | createdby | numeric | 10 | User who created this records | |||
ad_find | createdby | numeric | 10 | User who created this records | |||
ad_image | createdby | numeric | 10 | User who created this records | |||
ad_message | createdby | numeric | 10 | User who created this records | |||
ad_note | 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_table | createdby | numeric | 10 | User who created this records | |||
ad_user | createdby | numeric | 10 | User who created this records | |||
ad_wf_activity | createdby | numeric | 10 | User who created this records | |||
ad_wf_activityapprover | createdby | numeric | 10 | User who created this records | |||
ad_wf_activityresult | createdby | numeric | 10 | User who created this records | |||
ad_wf_block | createdby | numeric | 10 | User who created this records | |||
ad_wf_eventaudit | createdby | numeric | 10 | User who created this records | |||
ad_wf_nextcondition | createdby | numeric | 10 | User who created this records | |||
ad_wf_node | createdby | numeric | 10 | User who created this records | |||
ad_wf_node_para | createdby | numeric | 10 | User who created this records | |||
ad_wf_node_trl | createdby | numeric | 10 | User who created this records | |||
ad_wf_nodenext | createdby | numeric | 10 | User who created this records | |||
ad_wf_process | createdby | numeric | 10 | User who created this records | |||
ad_wf_processdata | createdby | numeric | 10 | User who created this records | |||
ad_wf_responsible | createdby | numeric | 10 | User who created this records | |||
ad_wizardprocess | createdby | numeric | 10 | User who created this records | |||
ad_workflow | createdby | numeric | 10 | User who created this records | |||
ad_workflow_access | createdby | numeric | 10 | User who created this records | |||
ad_workflow_trl | createdby | numeric | 10 | User who created this records | |||
ad_workflowprocessor | createdby | numeric | 10 | User who created this records | |||
r_mailtext | createdby | numeric | 10 | User who created this records | |||
r_mailtext_trl | createdby | numeric | 10 | User who created this records | |||
ad_wf_eventaudit | elapsedtimems | numeric | 0 | Elapsed Time in milli seconds | |||
ad_wf_eventaudit | eventtype | bpchar | 2 | Type of Event | |||
ad_process_para | fieldlength | numeric | 10 | Length of the column in the database | |||
ad_find | find_id | numeric | 0 | Find | |||
ad_wf_node | joinelement | bpchar | 1 | Semantics for multiple incoming Transitions | |||
ad_workflowprocessor | keeplogdays | numeric | 10 | Number of days to keep the log entries | |||
r_mailtext | mailtext | text | 2147483647 | Text used for Mail message | |||
r_mailtext_trl | mailtext | text | 2147483647 | Text used for Mail message | |||
ad_message | msgtext | varchar | 2000 | Textual Informational, Menu or Error Message | |||
ad_message | msgtype | bpchar | 1 | Type of message (Informational, Menu or Error) | |||
ad_column | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_image | 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_table | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_user | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_wf_block | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_wf_node | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_wf_node_trl | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_wf_responsible | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_workflow | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_workflow_trl | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_workflowprocessor | name | varchar | 60 | Alphanumeric identifier of the entity | |||
r_mailtext | name | varchar | 60 | Alphanumeric identifier of the entity | |||
r_mailtext_trl | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_find | operation | bpchar | 2 | Compare Operation | |||
ad_wf_nextcondition | operation | bpchar | 2 | Compare Operation | |||
ad_workflow | publishstatus | bpchar | 1 | Status of Publication | |||
r_mailtext | r_mailtext_id | numeric | 10 | Text templates for mailings | |||
r_mailtext_trl | r_mailtext_id | numeric | 10 | Text templates for mailings | |||
ad_wf_activity | record_id | numeric | 10 | Direct internal record ID | |||
ad_wf_eventaudit | record_id | numeric | 10 | Direct internal record ID | |||
ad_wf_process | record_id | numeric | 10 | Direct internal record ID | |||
ad_wf_responsible | responsibletype | bpchar | 1 | Type of the Responsibility for a workflow | |||
ad_process_para | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
ad_wf_nextcondition | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
ad_wf_nodenext | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
ad_wf_node | splitelement | bpchar | 1 | Semantics for multiple outgoing Transitions | |||
ad_workflowprocessor | supervisor_id | numeric | 10 | Supervisor for this user/organization - used for escalation and approval | |||
ad_table | tablename | varchar | 40 | Name of the table in the database | |||
ad_attachmentnote | textmsg | varchar | 2000 | Text Message | |||
ad_attachment | title | varchar | 60 | Name this entity is referred to as | |||
ad_attachmentnote | title | varchar | 60 | Name this entity is referred to as | |||
ad_attachment | updatedby | numeric | 10 | User who updated this records | |||
ad_attachmentnote | updatedby | numeric | 10 | User who updated this records | |||
ad_column | updatedby | numeric | 10 | User who updated this records | |||
ad_find | updatedby | numeric | 10 | User who updated this records | |||
ad_image | updatedby | numeric | 10 | User who updated this records | |||
ad_message | updatedby | numeric | 10 | User who updated this records | |||
ad_note | 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_table | updatedby | numeric | 10 | User who updated this records | |||
ad_user | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_activity | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_activityapprover | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_activityresult | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_block | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_eventaudit | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_nextcondition | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_node | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_node_para | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_node_trl | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_nodenext | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_process | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_processdata | updatedby | numeric | 10 | User who updated this records | |||
ad_wf_responsible | updatedby | numeric | 10 | User who updated this records | |||
ad_wizardprocess | updatedby | numeric | 10 | User who updated this records | |||
ad_workflow | updatedby | numeric | 10 | User who updated this records | |||
ad_workflow_access | updatedby | numeric | 10 | User who updated this records | |||
ad_workflow_trl | updatedby | numeric | 10 | User who updated this records | |||
ad_workflowprocessor | updatedby | numeric | 10 | User who updated this records | |||
r_mailtext | updatedby | numeric | 10 | User who updated this records | |||
r_mailtext_trl | updatedby | numeric | 10 | User who updated this records | |||
ad_find | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_message | value | varchar | 255 | Search key for the record in the format required - must be unique | |||
ad_process | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_wf_nextcondition | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_wf_node | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_workflow | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_column | version | numeric | 0 | Version of the table definition | |||
ad_wf_activity | wfstate | bpchar | 2 | State of the execution of the workflow | |||
ad_wf_eventaudit | wfstate | bpchar | 2 | State of the execution of the workflow | |||
ad_wf_process | wfstate | bpchar | 2 | State of the execution of the workflow | |||
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 | createpartition | bpchar | 1 | √ | NULL::bpchar | Process which create or update table partitions based on the table and column records | |
ad_table | createwindowfromtable | bpchar | 1 | √ | NULL::bpchar | Create Window From Table | |
ad_table | databaseviewdrop | bpchar | 1 | √ | NULL::bpchar | Drop view | |
ad_process | executiontype | bpchar | 1 | √ | NULL::bpchar | Execution Type defines whether the report/process will always run in background or foreground. | |
ad_table | processing | bpchar | 1 | √ | NULL::bpchar | Process Now | |
ad_wizardprocess | wizardstatus | bpchar | 1 | √ | NULL::bpchar | Wizard Status | |
ad_attachment | ad_attachment_uu | varchar | 36 | √ | NULL::character varying | AD_Attachment_UU | |
ad_attachmentnote | ad_attachmentnote_uu | varchar | 36 | √ | NULL::character varying | AD_AttachmentNote_UU | |
ad_column | ad_column_uu | varchar | 36 | √ | NULL::character varying | AD_Column_UU | |
ad_find | ad_find_uu | varchar | 36 | √ | NULL::character varying | AD_Find_UU | |
ad_image | ad_image_uu | varchar | 36 | √ | NULL::character varying | AD_Image_UU | |
ad_message | ad_message_uu | varchar | 36 | √ | NULL::character varying | AD_Message_UU | |
ad_note | ad_note_uu | varchar | 36 | √ | NULL::character varying | AD_Note_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_table | ad_table_uu | varchar | 36 | √ | NULL::character varying | AD_Table_UU | |
ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
ad_wf_activity | ad_wf_activity_uu | varchar | 36 | √ | NULL::character varying | AD_WF_Activity_UU | |
ad_wf_activityapprover | ad_wf_activityapprover_uu | varchar | 36 | √ | NULL::character varying | AD_WF_ActivityApprover_UU | |
ad_wf_activityresult | ad_wf_activityresult_uu | varchar | 36 | √ | NULL::character varying | AD_WF_ActivityResult_UU | |
ad_wf_block | ad_wf_block_uu | varchar | 36 | √ | NULL::character varying | AD_WF_Block_UU | |
ad_wf_eventaudit | ad_wf_eventaudit_uu | varchar | 36 | √ | NULL::character varying | AD_WF_EventAudit_UU | |
ad_wf_nextcondition | ad_wf_nextcondition_uu | varchar | 36 | √ | NULL::character varying | AD_WF_NextCondition_UU | |
ad_wf_node_para | ad_wf_node_para_uu | varchar | 36 | √ | NULL::character varying | AD_WF_Node_Para_UU | |
ad_wf_node_trl | ad_wf_node_trl_uu | varchar | 36 | √ | NULL::character varying | AD_WF_Node_Trl_UU | |
ad_wf_node | ad_wf_node_uu | varchar | 36 | √ | NULL::character varying | AD_WF_Node_UU | |
ad_wf_nodenext | ad_wf_nodenext_uu | varchar | 36 | √ | NULL::character varying | AD_WF_NodeNext_UU | |
ad_wf_process | ad_wf_process_uu | varchar | 36 | √ | NULL::character varying | AD_WF_Process_UU | |
ad_wf_processdata | ad_wf_processdata_uu | varchar | 36 | √ | NULL::character varying | AD_WF_ProcessData_UU | |
ad_wf_responsible | ad_wf_responsible_uu | varchar | 36 | √ | NULL::character varying | AD_WF_Responsible_UU | |
ad_wizardprocess | ad_wizardprocess_uu | varchar | 36 | √ | NULL::character varying | AD_WizardProcess_UU | |
ad_workflow_access | ad_workflow_access_uu | varchar | 36 | √ | NULL::character varying | AD_Workflow_Access_UU | |
ad_workflow_trl | ad_workflow_trl_uu | varchar | 36 | √ | NULL::character varying | AD_Workflow_Trl_UU | |
ad_workflow | ad_workflow_uu | varchar | 36 | √ | NULL::character varying | AD_Workflow_UU | |
ad_workflowprocessor | ad_workflowprocessor_uu | varchar | 36 | √ | NULL::character varying | AD_WorkflowProcessor_UU | |
ad_column | alwaysupdatablelogic | varchar | 2000 | √ | NULL::character varying | Logic to determine if field is Updatable irrespective if record's active status or processed status. This logic Applicable only if Always Updatable is N. | |
ad_user | answer | varchar | 1024 | √ | NULL::character varying | Answer | |
ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | Authentication Type | |
ad_user | bpname | varchar | 60 | √ | NULL::character varying | BP Name | |
ad_process | filenamepattern | varchar | 255 | √ | NULL::character varying | File Name Pattern | |
ad_column | fkconstraintname | varchar | 30 | √ | NULL::character varying | Constraint Name | |
ad_user | leadsource | varchar | 10 | √ | NULL::character varying | The source of this lead/opportunity | |
ad_user | leadsourcedescription | varchar | 255 | √ | NULL::character varying | Additional information on the source of this lead/opportunity | |
ad_user | leadstatus | varchar | 10 | √ | NULL::character varying | The status of this lead/opportunity in the sales cycle | |
ad_user | leadstatusdescription | varchar | 255 | √ | NULL::character varying | Additional information on the status of this lead/opportunity | |
ad_process_para | mandatorylogic | varchar | 2000 | √ | NULL::character varying | Mandatory Logic | |
ad_wizardprocess | note | varchar | 2000 | √ | NULL::character varying | Optional additional user defined information | |
ad_column | partitioningmethod | varchar | 2 | √ | NULL::character varying | Indicates how the Table is partitioned | |
ad_column | placeholder | varchar | 255 | √ | NULL::character varying | Placeholder | |
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 | |
r_mailtext_trl | r_mailtext_trl_uu | varchar | 36 | √ | NULL::character varying | R_MailText_Trl_UU | |
r_mailtext | r_mailtext_uu | varchar | 36 | √ | NULL::character varying | R_MailText_UU | |
ad_column | rangepartitioninterval | varchar | 30 | √ | NULL::character varying | Indicates the interval used in a range partitioning | |
ad_attachment | record_uu | varchar | 36 | √ | NULL::character varying | Record UUID | |
ad_user | salt | varchar | 16 | √ | NULL::character varying | Random data added to improve password hash effectiveness | |
ad_wf_nextcondition | sqlstatement | varchar | 4000 | √ | NULL::character varying | SQL Expression/Statement | |
ad_note | ad_broadcastmessage_id | numeric | 10 | √ | NULL::numeric | Broadcast Message | |
ad_column | ad_chart_id | numeric | 10 | √ | NULL::numeric | Chart | |
ad_process | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | Context Help | |
ad_wf_node | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | Context Help | |
ad_workflow | ad_ctxhelp_id | numeric | 10 | √ | NULL::numeric | Context Help | |
ad_process_para | ad_fieldgroup_id | numeric | 10 | √ | NULL::numeric | Logical grouping of fields | |
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
ad_wf_node | ad_infowindow_id | numeric | 10 | √ | NULL::numeric | Info and search/select Window | |
ad_attachment | ad_storageprovider_id | numeric | 10 | √ | NULL::numeric | Storage Provider | |
ad_image | ad_storageprovider_id | numeric | 10 | √ | NULL::numeric | Storage Provider | |
ad_wizardprocess | ad_user_id | numeric | 10 | √ | NULL::numeric | User within the system - Internal or Business Partner Contact | |
ad_column | ad_val_rule_lookup_id | numeric | 10 | √ | NULL::numeric | Override Dynamic Validation Rule for Lookup Window | |
ad_user | bp_location_id | numeric | 10 | √ | NULL::numeric | Address of the Business Partner | |
ad_user | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
ad_user | c_location_id | numeric | 10 | √ | NULL::numeric | Location or Address | |
ad_column | fkconstraintmsg_id | numeric | 10 | √ | NULL::numeric | Constraint Message | |
ad_column | pa_dashboardcontent_id | numeric | 10 | √ | NULL::numeric | Dashboard Content | |
ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | Default mail template | |
ad_user | salesrep_id | numeric | 10 | √ | NULL::numeric | Sales Representative or Company Agent | |
ad_column | seqnopartition | numeric | 10 | √ | NULL::numeric | Indicates the order of partition keys | |
ad_column | seqnoselection | numeric | 10 | √ | NULL::numeric | Selection Column Sequence | |
ad_workflowprocessor | ad_schedule_id | numeric | 10 | NULL::numeric | Schedule | ||
ad_wf_activityapprover | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
ad_wizardprocess | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
ad_wf_activityapprover | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
ad_wizardprocess | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated |