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

idempiere9.adempiere contains 716 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_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 textfields
ad_process_para isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
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_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_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 bpchar 1  √  'P'::bpchar Allow or disallow executing a process/report multiple times.
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_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_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_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 Client 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 email varchar 60  √  null Electronic Mail Address
ad_wf_node email 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_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 Client/Tenant for this installation.
ad_attachmentnote ad_client_id numeric 10 Client/Tenant for this installation.
ad_column ad_client_id numeric 10 Client/Tenant for this installation.
ad_find ad_client_id numeric 10 Client/Tenant for this installation.
ad_image ad_client_id numeric 10 Client/Tenant for this installation.
ad_message ad_client_id numeric 10 Client/Tenant for this installation.
ad_note ad_client_id numeric 10 Client/Tenant for this installation.
ad_process ad_client_id numeric 10 Client/Tenant for this installation.
ad_process_para ad_client_id numeric 10 Client/Tenant for this installation.
ad_table ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_activity ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_activityapprover ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_activityresult ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_block ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_eventaudit ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_nextcondition ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_node ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_node_para ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_node_trl ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_nodenext ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_process ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_processdata ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_responsible ad_client_id numeric 10 Client/Tenant for this installation.
ad_wizardprocess ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflow ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflow_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflow_trl ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflowprocessor ad_client_id numeric 10 Client/Tenant for this installation.
r_mailtext ad_client_id numeric 10 Client/Tenant for this installation.
r_mailtext_trl ad_client_id numeric 10 Client/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 client
ad_attachmentnote ad_org_id numeric 10 Organizational entity within client
ad_column ad_org_id numeric 10 Organizational entity within client
ad_find ad_org_id numeric 10 Organizational entity within client
ad_image ad_org_id numeric 10 Organizational entity within client
ad_message ad_org_id numeric 10 Organizational entity within client
ad_note ad_org_id numeric 10 Organizational entity within client
ad_process ad_org_id numeric 10 Organizational entity within client
ad_process_para ad_org_id numeric 10 Organizational entity within client
ad_table ad_org_id numeric 10 Organizational entity within client
ad_user ad_org_id numeric 10 Organizational entity within client
ad_wf_activity ad_org_id numeric 10 Organizational entity within client
ad_wf_activityapprover ad_org_id numeric 10 Organizational entity within client
ad_wf_activityresult ad_org_id numeric 10 Organizational entity within client
ad_wf_block ad_org_id numeric 10 Organizational entity within client
ad_wf_eventaudit ad_org_id numeric 10 Organizational entity within client
ad_wf_nextcondition ad_org_id numeric 10 Organizational entity within client
ad_wf_node ad_org_id numeric 10 Organizational entity within client
ad_wf_node_para ad_org_id numeric 10 Organizational entity within client
ad_wf_node_trl ad_org_id numeric 10 Organizational entity within client
ad_wf_nodenext ad_org_id numeric 10 Organizational entity within client
ad_wf_process ad_org_id numeric 10 Organizational entity within client
ad_wf_processdata ad_org_id numeric 10 Organizational entity within client
ad_wf_responsible ad_org_id numeric 10 Organizational entity within client
ad_wizardprocess ad_org_id numeric 10 Organizational entity within client
ad_workflow ad_org_id numeric 10 Organizational entity within client
ad_workflow_access ad_org_id numeric 10 Organizational entity within client
ad_workflow_trl ad_org_id numeric 10 Organizational entity within client
ad_workflowprocessor ad_org_id numeric 10 Organizational entity within client
r_mailtext ad_org_id numeric 10 Organizational entity within client
r_mailtext_trl ad_org_id numeric 10 Organizational entity within client
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_attachment record_id numeric 10 Direct internal record ID
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 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_user answer varchar 1024  √  NULL::character varying Answer
ad_user bpname varchar 60  √  NULL::character varying BP Name
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 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_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 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 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