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

idempiere9.adempiere contains 938 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_issue a_asset_id numeric 10  √  null Asset used internally or by customers
exp_processor account varchar 255  √  null Account
imp_processor account varchar 255  √  null Account
ad_alert ad_alert_uu varchar 36  √  NULL::character varying AD_Alert_UU
ad_alert ad_alertprocessor_id numeric 10  √  null Alert Processor/Server Parameter
ad_alertprocessor ad_alertprocessor_uu varchar 36  √  NULL::character varying AD_AlertProcessor_UU
ad_alertprocessorlog ad_alertprocessorlog_uu varchar 36  √  NULL::character varying AD_AlertProcessorLog_UU
ad_alertrecipient ad_alertrecipient_uu varchar 36  √  NULL::character varying AD_AlertRecipient_UU
ad_alertrule ad_alertrule_uu varchar 36  √  NULL::character varying AD_AlertRule_UU
ad_schedulerrecipient ad_authorizationaccount_id numeric 10  √  NULL::numeric Authorization Account
ad_note ad_broadcastmessage_id numeric 10  √  NULL::numeric Broadcast Message
ad_broadcastmessage ad_broadcastmessage_uu varchar 36  √  NULL::character varying AD_BroadcastMessage_UU
ad_pinstance ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_pinstance_para ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_client ad_client_uu varchar 36  √  NULL::character varying AD_Client_UU
ad_clientinfo ad_clientinfo_uu varchar 36  √  NULL::character varying AD_ClientInfo_UU
ad_process ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_workflow ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_process_para ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_process_para ad_fieldgroup_id numeric 10  √  NULL::numeric Logical grouping of fields
ad_issue ad_form_id numeric 10  √  null Special Form
ad_process ad_form_id numeric 10  √  null Special Form
ad_housekeeping ad_housekeeping_uu varchar 36  √  NULL::character varying AD_HouseKeeping_UU
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_issue ad_issue_uu varchar 36  √  NULL::character varying AD_Issue_UU
ad_client ad_language varchar 6  √  null Language for this entity
ad_pinstance ad_language_id numeric 10  √  NULL::numeric Language ID
ad_ldapprocessor ad_ldapprocessor_uu varchar 36  √  NULL::character varying AD_LdapProcessor_UU
ad_wf_process ad_message_id numeric 10  √  null System Message
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_pinstance ad_org_id numeric 10  √  null Organizational entity within client
ad_pinstance_para ad_org_id numeric 10  √  null Organizational entity within client
c_acctschema ad_orgonly_id numeric 10  √  null Create posting entries only for this organization
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_client ad_passwordrule_id numeric 10  √  NULL::numeric Password Policies
ad_pinstance_log ad_pinstance_log_uu varchar 36  √  NULL::character varying AD_PInstance_Log_UU
ad_pinstance_para ad_pinstance_para_uu varchar 36  √  NULL::character varying AD_PInstance_Para_UU
ad_pinstance ad_pinstance_uu varchar 36  √  NULL::character varying AD_PInstance_UU
ad_pinstance ad_printformat_id numeric 10  √  NULL::numeric Data Print Format
ad_process ad_printformat_id numeric 10  √  null Data Print Format
ad_scheduler ad_printformat_id numeric 10  √  NULL::numeric Data Print Format
ad_issue ad_process_id numeric 10  √  null Process or Report
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_process_para ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_client ad_replicationstrategy_id numeric 10  √  null Data Replication Strategy
ad_process ad_reportview_id numeric 10  √  null View used to generate this report
ad_alertrecipient ad_role_id numeric 10  √  null Responsibility Role
ad_broadcastmessage ad_role_id numeric 10  √  NULL::numeric Responsibility Role
ad_schedulerrecipient ad_role_id numeric 10  √  null Responsibility Role
ad_role ad_role_uu varchar 36  √  NULL::character varying AD_Role_UU
ad_schedule ad_schedule_uu varchar 36  √  NULL::character varying AD_Schedule_UU
ad_scheduler_para ad_scheduler_para_uu varchar 36  √  NULL::character varying AD_Scheduler_Para_UU
ad_scheduler ad_scheduler_uu varchar 36  √  NULL::character varying AD_Scheduler_UU
ad_schedulerlog ad_schedulerlog_uu varchar 36  √  NULL::character varying AD_SchedulerLog_UU
ad_schedulerrecipient ad_schedulerrecipient_uu varchar 36  √  NULL::character varying AD_SchedulerRecipient_UU
ad_clientinfo ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
ad_alertrule ad_table_id numeric 10  √  null Database Table information
ad_housekeeping ad_table_id numeric 10  √  null Database Table information
ad_note ad_table_id numeric 10  √  null Database Table information
ad_pinstance_log ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_scheduler ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_workflow ad_table_id numeric 10  √  null Database Table information
c_acctprocessor ad_table_id numeric 10  √  null Database Table information
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
ad_clientinfo ad_tree_activity_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_bpartner_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_campaign_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_role ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_clientinfo ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
ad_role ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
ad_clientinfo ad_tree_product_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_project_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_salesregion_id numeric 10  √  null Trees are used for (financial) reporting
ad_alertrecipient ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_broadcastmessage ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
ad_note ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_pinstance ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_schedulerrecipient 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_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
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_workflow ad_wf_node_id numeric 10  √  null Workflow Node (activity), step or process
ad_wf_process ad_wf_process_uu varchar 36  √  NULL::character varying AD_WF_Process_UU
ad_workflow ad_wf_responsible_id numeric 10  √  null Responsible for Workflow Execution
ad_issue ad_window_id numeric 10  √  null Data entry or display window
ad_table 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_workflow_uu varchar 36  √  NULL::character varying AD_Workflow_UU
ad_workflow ad_workflowprocessor_id numeric 10  √  null Workflow Processor Server
ad_workflowprocessor ad_workflowprocessor_uu varchar 36  √  NULL::character varying AD_WorkflowProcessor_UU
ad_workflowprocessorlog ad_workflowprocessorlog_uu varchar 36  √  NULL::character varying AD_WorkflowProcessorLog_UU
ad_workflowprocessor alertoverpriority numeric 10  √  null Send alert email when over priority
ad_process allowmultipleexecution bpchar 1  √  'P'::bpchar Allow or disallow executing a process/report multiple times.
ad_role amtapproval numeric 0  √  0 The approval amount limit for this role
ad_role amtapprovalaccum numeric 0  √  null The approval amount limit for this role accumulated on a period
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_housekeeping backupfolder varchar 255  √  null Backup Folder
ad_alertprocessorlog binarydata bytea 2147483647  √  null Binary Data
ad_schedulerlog binarydata bytea 2147483647  √  null Binary Data
ad_workflowprocessorlog binarydata bytea 2147483647  √  null Binary Data
c_acctprocessorlog binarydata bytea 2147483647  √  null Binary Data
r_requestprocessorlog binarydata bytea 2147483647  √  null Binary Data
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_user bp_location_id numeric 10  √  NULL::numeric Address of the Business Partner
ad_user bpname varchar 60  √  NULL::character varying BP Name
c_acctprocessor c_acctprocessor_uu varchar 36  √  NULL::character varying C_AcctProcessor_UU
c_acctprocessorlog c_acctprocessorlog_uu varchar 36  √  NULL::character varying C_AcctProcessorLog_UU
ad_clientinfo c_acctschema1_id numeric 10  √  null Primary rules for accounting
c_acctprocessor c_acctschema_id numeric 10  √  null Rules for accounting
c_acctschema c_acctschema_uu varchar 36  √  NULL::character varying C_AcctSchema_UU
ad_user 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_clientinfo c_bpartnercashtrx_id numeric 10  √  null Business Partner used for creating new Business Partners on the fly
ad_clientinfo c_calendar_id numeric 10  √  null Accounting Calendar Name
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
ad_clientinfo c_chargefreight_id numeric 10  √  NULL::numeric Charge for Freight
ad_role c_currency_id numeric 10  √  null The Currency for this record
ad_user c_greeting_id numeric 10  √  null Greeting to print on correspondence
ad_user c_job_id numeric 10  √  null Job Position
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
c_acctschema c_period_id numeric 10  √  null Period of the Calendar
ad_clientinfo c_uom_length_id numeric 10  √  null Standard Unit of Measure for Length
ad_clientinfo c_uom_time_id numeric 10  √  null Standard Unit of Measure for Time
ad_clientinfo c_uom_volume_id numeric 10  √  null Standard Unit of Measure for Volume
ad_clientinfo c_uom_weight_id numeric 10  √  null Standard Unit of Measure for Weight
ad_process classname varchar 255  √  null Java Classname
ad_issue comments varchar 2000  √  null Comments or additional information
ad_user comments varchar 2000  √  null Comments or additional information
ad_role connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
ad_user connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
ad_table copycolumnsfromtable varchar 1  √  null Copy Columns From Table
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
ad_process copyfromprocess bpchar 1  √  NULL::bpchar Copy settings from one report and process to another.
ad_pinstance createdby numeric 10  √  null User who created this records
ad_pinstance_para createdby numeric 10  √  null User who created this records
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
ad_schedule cronpattern varchar 255  √  NULL::character varying Cron pattern to define when the process should be invoked.
ad_scheduler cronpattern varchar 255  √  NULL::character varying Cron pattern to define when the process should be invoked.
ad_issue databaseinfo varchar 255  √  null Database Information
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
ad_alertprocessor datelastrun timestamp 29,6  √  null Date the process was last run.
ad_ldapprocessor datelastrun timestamp 29,6  √  null Date the process was last run.
ad_scheduler datelastrun timestamp 29,6  √  null Date the process was last run.
ad_workflowprocessor datelastrun timestamp 29,6  √  null Date the process was last run.
c_acctprocessor datelastrun timestamp 29,6  √  null Date the process was last run.
imp_processor datelastrun timestamp 29,6  √  null Date the process was last run.
r_requestprocessor datelastrun timestamp 29,6  √  null Date the process was last run.
ad_alertprocessor datenextrun timestamp 29,6  √  null Date the process will run next
ad_ldapprocessor datenextrun timestamp 29,6  √  null Date the process will run next
ad_scheduler datenextrun timestamp 29,6  √  null Date the process will run next
ad_workflowprocessor datenextrun timestamp 29,6  √  null Date the process will run next
c_acctprocessor datenextrun timestamp 29,6  √  null Date the process will run next
imp_processor datenextrun timestamp 29,6  √  null Date the process will run next
r_requestprocessor datenextrun timestamp 29,6  √  null Date the process will run next
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
ad_role daysapprovalaccum numeric 10  √  null The days approval indicates the days to take into account to verify the accumulated approval amount.
ad_issue dbaddress varchar 255  √  null JDBC URL of the database server
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_alert description varchar 255  √  null Optional short description of the record
ad_alertprocessor description varchar 255  √  null Optional short description of the record
ad_alertprocessorlog description varchar 255  √  null Optional short description of the record
ad_client description varchar 255  √  null Optional short description of the record
ad_housekeeping description varchar 255  √  null Optional short description of the record
ad_ldapprocessor 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_role description varchar 255  √  null Optional short description of the record
ad_schedule description varchar 225  √  NULL::character varying Optional short description of the record
ad_scheduler description varchar 255  √  null Optional short description of the record
ad_scheduler_para description varchar 255  √  null Optional short description of the record
ad_schedulerlog 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_workflow description varchar 255  √  null Optional short description of the record
ad_workflowprocessor description varchar 255  √  null Optional short description of the record
ad_workflowprocessorlog description varchar 255  √  null Optional short description of the record
c_acctprocessor description varchar 255  √  null Optional short description of the record
c_acctprocessorlog description varchar 255  √  null Optional short description of the record
c_acctschema description varchar 255  √  null Optional short description of the record
exp_processor description varchar 255  √  null Optional short description of the record
imp_processor description varchar 255  √  null Optional short description of the record
r_requestprocessor description varchar 255  √  null Optional short description of the record
r_requestprocessorlog 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_client documentdir varchar 60  √  null Directory for documents from the application server
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_user email varchar 60  √  null Electronic Mail Address
ad_client emailtest bpchar 1  √  null Test 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_alertrule errormsg varchar 2000  √  null Error Msg
ad_pinstance errormsg varchar 2000  √  null Error Msg
ad_issue errortrace varchar 2000  √  null System Error Trace
ad_process executiontype bpchar 1  √  NULL::bpchar Execution Type defines whether the report/process will always run in background or foreground.
exp_processor exp_processor_uu varchar 36  √  NULL::character varying EXP_Processor_UU
ad_broadcastmessage expiration timestamp 29,6  √  null Expire On
ad_broadcastmessage expired bpchar 1  √  'N'::bpchar Expired
ad_broadcastmessage expirenow bpchar 1  √  null Expire the broadcast message
ad_user fax varchar 40  √  null Facsimile number
ad_schedulerrecipient filename varchar 255  √  NULL::character varying Name of the local file or URL
ad_alertprocessor frequency numeric 10  √  null Frequency of events
ad_schedule frequency numeric 10  √  NULL::numeric Frequency of events
ad_scheduler frequency numeric 10  √  null Frequency of events
ad_workflowprocessor frequency numeric 10  √  null Frequency of events
c_acctprocessor frequency numeric 10  √  null Frequency of events
r_requestprocessor frequency numeric 10  √  (1)::numeric Frequency of events
ad_alertprocessor frequencytype bpchar 1  √  null Frequency of event
ad_schedule frequencytype bpchar 1  √  NULL::bpchar Frequency of event
ad_scheduler frequencytype bpchar 1  √  null Frequency of event
ad_workflowprocessor frequencytype bpchar 1  √  null Frequency of event
c_acctprocessor frequencytype bpchar 1  √  null Frequency of event
r_requestprocessor frequencytype bpchar 1  √  null Frequency of event
ad_clientinfo fy_startdate timestamp 29,6  √  null Financial Year Start Date
ad_alert help varchar 2000  √  null Comment or Hint
ad_housekeeping 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_workflow help text 2147483647  √  null Comment or Hint
exp_processor help varchar 2000  √  null Comment or Hint
imp_processor help varchar 2000  √  null Comment or Hint
exp_processor host varchar 255  √  null Host
imp_processor host varchar 255  √  null Host
imp_processor imp_processor_uu varchar 36  √  NULL::character varying IMP_Processor_UU
ad_table importtable bpchar 1  √  null Import Table Columns from Database
ad_workflowprocessor inactivityalertdays numeric 10  √  0 Send Alert when there is no activity after days (0= no alert)
ad_pinstance_para info varchar 4000  √  null Information
ad_pinstance_para info_to varchar 4000  √  null Info To
ad_role isaccessadvanced bpchar 1  √  'N'::bpchar Access Advanced
ad_pinstance isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_pinstance_para isactive bpchar 1  √  'Y'::bpchar The record is active in the system
c_acctschema isallownegativeposting bpchar 1  √  'Y'::bpchar Allow to post negative accounting values
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_process isdirectprint bpchar 1  √  'N'::bpchar Print without dialog
ad_housekeeping isexportxmlbackup bpchar 1  √  null Export XML Backup
ad_scheduler isignoreprocessingtime bpchar 1  √  'N'::bpchar Do not include processing time for the DateNextRun calculation
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
c_acctschema ispostifclearingequal bpchar 1  √  'Y'::bpchar This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
ad_broadcastmessage ispublished bpchar 1  √  'N'::bpchar The Topic is published and can be viewed
ad_issue isreproducible bpchar 1  √  'N'::bpchar Problem can re reproduced in Gardenworld
ad_pinstance isrunasjob bpchar 1  √  'N'::bpchar Run as Job
ad_housekeeping issaveinhistoric bpchar 1  √  null Save In Historic
ad_client isserveremail bpchar 1  √  null Send EMail from Server
ad_process isserverprocess bpchar 1  √  null Run this Process on Server only
ad_issue issuesource bpchar 1  √  null Issue Source
ad_pinstance issummary bpchar 1  √  NULL::bpchar This is a summary entity
ad_issue isvanillasystem bpchar 1  √  'N'::bpchar The system was NOT compiled from Source - i.e. standard distribution
ad_process jasperreport varchar 255  √  null Jasper Report
ad_issue javainfo varchar 255  √  null Java Version Info
ad_clientinfo keeplogdays numeric 10  √  null Number of days to keep the log entries
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
ad_housekeeping lastdeleted numeric 10  √  null Last Deleted
ad_user lastresult varchar 255  √  null Result of last contact
ad_housekeeping lastrun timestamp 29,6  √  null Last Run
ad_client ldapquery varchar 255  √  null
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
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_workflow limit numeric 10  √  null Maximum Duration in Duration Unit
ad_issue lineno numeric 10  √  0 Line No
ad_table loadseq numeric 10  √  null Sequence
ad_issue local_host varchar 120  √  null Local Host Info
ad_broadcastmessage logacknowledge bpchar 1  √  'N'::bpchar Want to Log the Acknowledgement of Message?
ad_issue loggername varchar 255  √  null Logger Name
ad_clientinfo logo_id numeric 10  √  NULL::numeric Logo
ad_clientinfo logoreport_id numeric 10  √  NULL::numeric Logo Report
ad_clientinfo logoweb_id numeric 10  √  NULL::numeric Logo Web
c_acctschema m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
ad_clientinfo m_productfreight_id numeric 10  √  null Product for Freight
ad_process_para mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_client modelvalidationclasses varchar 255  √  null List of data model validation classes separated by ;
ad_schedule monthday numeric 10  √  NULL::numeric Day of the month 1 to 28/29/30/31
ad_scheduler monthday numeric 10  √  null Day of the month 1 to 28/29/30/31
ad_workflow movingtime numeric 10  √  null Moving Time
ad_message msgtip varchar 2000  √  null Additional tip or help for this message
ad_pinstance name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
ad_broadcastmessage notification_client_id numeric 10  √  null Notification Client
ad_pinstance notificationtype varchar 2  √  NULL::character varying Type of Notifications
ad_issue operatingsysteminfo varchar 255  √  null Operating System Info
ad_alertrule otherclause varchar 2000  √  null Other SQL Clause
ad_workflow overlapunits numeric 0  √  null Overlap Units are number of units that must be completed before they are moved the next activity
ad_pinstance_log p_date timestamp 29,6  √  now() Process Parameter
ad_pinstance_para p_date timestamp 29,6  √  null Process Parameter
ad_pinstance_para p_date_to timestamp 29,6  √  null Process Parameter
ad_pinstance_log p_id numeric 10  √  null Process ID
ad_pinstance_log p_msg varchar 2000  √  null Process Message
ad_pinstance_log p_number numeric 0  √  null Process Parameter
ad_pinstance_para p_number numeric 0  √  null Process Parameter
ad_pinstance_para p_number_to numeric 0  √  null Process Parameter
ad_pinstance_para p_string varchar 4000  √  null Process Parameter
ad_pinstance_para p_string_to varchar 4000  √  null Process Parameter
ad_scheduler_para parameterdefault varchar 255  √  null Default value of the parameter
ad_pinstance_para parametername varchar 60  √  null Parameter Name
ad_scheduler_para parametertodefault varchar 255  √  NULL::character varying Default value of the to parameter
ad_user password varchar 1024  √  null Password of any length (case sensitive)
exp_processor passwordinfo varchar 255  √  null Password Info
imp_processor passwordinfo varchar 255  √  null Password Info
c_acctschema period_openfuture numeric 10  √  null Number of days to be able to post to a future date (based on system date)
c_acctschema period_openhistory numeric 10  √  null Number of days to be able to post in the past (based on system date)
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
ad_process_para placeholder varchar 255  √  NULL::character varying Placeholder
ad_process_para placeholder2 varchar 255  √  NULL::character varying Placeholder2
ad_table po_window_id numeric 10  √  null Purchase Order Window
exp_processor port numeric 10  √  null Port
imp_processor port numeric 10  √  null Port
ad_alertrule postprocessing varchar 2000  √  null Process SQL after executing the query
ad_alertrule preprocessing varchar 2000  √  null Process SQL before executing the query
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_broadcastmessage processed bpchar 1  √  'N'::bpchar The document has been processed
ad_note processed bpchar 1  √  'N'::bpchar The document has been processed
ad_alertprocessor processing bpchar 1  √  null Process Now
ad_housekeeping processing bpchar 1  √  null Process Now
ad_issue processing bpchar 1  √  null Process Now
ad_ldapprocessor processing bpchar 1  √  null Process Now
ad_note processing bpchar 1  √  null Process Now
ad_scheduler processing bpchar 1  √  null Process Now
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_user processing bpchar 1  √  null Process Now
ad_wf_process processing bpchar 1  √  null Process Now
ad_workflowprocessor processing bpchar 1  √  null Process Now
c_acctprocessor processing bpchar 1  √  null Process Now
c_acctschema processing bpchar 1  √  null Process Now
imp_processor processing bpchar 1  √  null Process Now
r_requestprocessor processing bpchar 1  √  null Process Now
ad_workflow processtype bpchar 2  √  null Process Type
ad_issue profileinfo varchar 255  √  null Information to help profiling the system for solving support issues
ad_broadcastmessage publish bpchar 1  √  NULL::bpchar Publish Broadcast Message
ad_workflow qtybatchsize numeric 0  √  (1)::numeric Qty Batch Size
ad_process_para query varchar 2000  √  NULL::character varying SQL
ad_workflow queuingtime numeric 10  √  null Queue time is the time a job waits at a work center before begin handled.
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
ad_issue r_issueknown_id numeric 10  √  null Known Issue
ad_issue r_issueproject_id numeric 10  √  null Implementation Projects
ad_issue r_issuesystem_id numeric 10  √  null System creating the issue
ad_issue r_issueuser_id numeric 10  √  null User who reported issues
ad_scheduler r_mailtext_id numeric 10  √  NULL::numeric Text templates for mailings
ad_issue r_request_id numeric 10  √  null Request from a Business Partner or Prospect
r_requestprocessor r_requestprocessor_uu varchar 36  √  NULL::character varying R_RequestProcessor_UU
r_requestprocessorlog r_requestprocessorlog_uu varchar 36  √  NULL::character varying R_RequestProcessorLog_UU
r_requestprocessor r_requesttype_id numeric 10  √  null Type of request (e.g. Inquiry, Complaint, ..)
ad_process_para readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_issue record_id numeric 10  √  null Direct internal record ID
ad_note record_id numeric 10  √  null Direct internal record ID
ad_pinstance_log record_id numeric 10  √  NULL::numeric Direct internal record ID
ad_scheduler record_id numeric 10  √  NULL::numeric Direct internal record ID
ad_alertprocessorlog reference varchar 60  √  null Reference for this record
ad_note reference varchar 255  √  null Reference for this record
ad_schedulerlog reference varchar 60  √  null Reference for this record
ad_workflowprocessorlog reference varchar 60  √  null Reference for this record
c_acctprocessorlog reference varchar 60  √  null Reference for this record
r_requestprocessorlog reference varchar 60  √  null Reference for this record
ad_issue releasetag varchar 60  √  null Release Tag
ad_workflowprocessor reminddays numeric 10  √  0 Days between sending Reminder Emails for a due or inactive Document
ad_issue remote_addr varchar 60  √  null Remote Address
ad_issue remote_host varchar 120  √  null Remote host Info
ad_scheduler reportoutputtype varchar 4  √  NULL::character varying Report Output Type
ad_pinstance reporttype varchar 5  √  NULL::character varying Report Type
ad_issue requestdocumentno varchar 30  √  null iDempiere Request Document No
ad_client requestemail varchar 60  √  null EMail address to send automated mails from or receive mails for automated processing (fully qualified)
ad_client requestfolder varchar 20  √  null EMail folder to process incoming emails; if empty INBOX is used
ad_client requestuser varchar 60  √  null User Name (ID) of the email owner
ad_client requestuserpw varchar 255  √  null Password of the user name (ID) for mail processing
ad_issue responsetext varchar 2000  √  null Request Response Text
ad_pinstance result numeric 10  √  null Result of the action taken
ad_role roletype varchar 2  √  NULL::character varying Role Type
ad_schedule runonlyonip varchar 60  √  NULL::character varying Run only on IP
ad_workflow s_resource_id numeric 10  √  null Resource
ad_user salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_schedule scheduletype bpchar 1  √  'F'::bpchar Type of schedule
ad_user securityquestion varchar 1024  √  null Security Question
ad_workflow setuptime numeric 10  √  null Setup time before starting Production
ad_process showhelp bpchar 1  √  'Y'::bpchar Show Help
ad_client smtphost varchar 60  √  null Hostname of Mail Server for SMTP and IMAP
ad_client smtpport numeric 10  √  NULL::numeric SMTP Port Number
ad_issue sourceclassname varchar 255  √  null Source Class Name
ad_issue sourcemethodname varchar 60  √  null Source Method Name
ad_issue stacktrace varchar 2000  √  null System Log Trace
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_issue statisticsinfo varchar 255  √  null Information to help profiling the system for solving support issues
ad_clientinfo storagearchive_id numeric 10  √  NULL::numeric Archive Store
ad_clientinfo storageimage_id numeric 10  √  NULL::numeric Storage provider for Image
ad_alertprocessorlog summary varchar 2000  √  null Textual summary of this request
ad_schedulerlog summary varchar 2000  √  null Textual summary of this request
ad_workflowprocessorlog summary varchar 2000  √  null Textual summary of this request
c_acctprocessorlog summary varchar 2000  √  null Textual summary of this request
r_requestprocessorlog summary varchar 2000  √  null Textual summary of this request
ad_role supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_issue supportemail varchar 60  √  null EMail address to send support information and updates to
ad_housekeeping tablename varchar 40  √  NULL::character varying Name of the table in the database
c_acctschema taxcorrectiontype bpchar 1  √  null Type of Tax Correction
ad_broadcastmessage testmessage bpchar 1  √  NULL::bpchar Test broadcast message
ad_alertprocessorlog textmsg varchar 2000  √  null Text Message
ad_note textmsg varchar 2000  √  null Text Message
ad_schedulerlog textmsg varchar 2000  √  null Text Message
ad_wf_process textmsg varchar 2000  √  null Text Message
ad_workflowprocessorlog textmsg varchar 2000  √  null Text Message
c_acctprocessorlog textmsg varchar 2000  √  null Text Message
r_requestprocessorlog textmsg varchar 2000  √  null Text Message
ad_user title varchar 40  √  null Name this entity is referred to as
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_client unixarchivepath varchar 255  √  null Unix Archive Path
ad_client unixattachmentpath varchar 255  √  null Unix Attachment Path
ad_pinstance_para updatedby numeric 10  √  null User who updated this records
ad_role userdiscount numeric 22,2  √  null UserDiscount
ad_user userpin varchar 20  √  null User PIN
ad_workflow validateworkflow bpchar 1  √  null Validate Workflow
ad_workflow validfrom timestamp 29,6  √  null Valid from including this date (first day)
ad_workflow validto timestamp 29,6  √  null Valid to including this date (last day)
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
ad_process_para valuemax varchar 20  √  null Maximum Value for a field
ad_process_para valuemin varchar 20  √  null Minimum Value for a field
ad_process_para vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_schedule weekday bpchar 1  √  NULL::bpchar Day of the Week
ad_scheduler weekday bpchar 1  √  null Day of the Week
ad_alertrule whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
ad_housekeeping whereclause varchar 255  √  null Fully qualified SQL WHERE clause
ad_client windowsarchivepath varchar 255  √  null Windows Archive Path
ad_client windowsattachmentpath varchar 255  √  null Windows Attachment Path
ad_process workflowvalue varchar 40  √  null Key of the Workflow to start
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_process accesslevel bpchar 1 Access Level required
ad_table accesslevel bpchar 1 Access Level required
ad_workflow accesslevel bpchar 1 Access Level required
ad_alert ad_alert_id numeric 10 iDempiere Alert
ad_alertrecipient ad_alert_id numeric 10 iDempiere Alert
ad_alertrule ad_alert_id numeric 10 iDempiere Alert
ad_alertprocessor ad_alertprocessor_id numeric 10 Alert Processor/Server Parameter
ad_alertprocessorlog ad_alertprocessor_id numeric 10 Alert Processor/Server Parameter
ad_alertprocessorlog ad_alertprocessorlog_id numeric 10 Result of the execution of the Alert Processor
ad_alertrecipient ad_alertrecipient_id numeric 10 Recipient of the Alert Notification
ad_alertrule ad_alertrule_id numeric 10 Definition of the alert element
ad_broadcastmessage ad_broadcastmessage_id numeric 10 NULL::numeric Broadcast Message
ad_alert ad_client_id numeric 10 Client/Tenant for this installation.
ad_alertprocessor ad_client_id numeric 10 Client/Tenant for this installation.
ad_alertprocessorlog ad_client_id numeric 10 Client/Tenant for this installation.
ad_alertrecipient ad_client_id numeric 10 Client/Tenant for this installation.
ad_alertrule ad_client_id numeric 10 Client/Tenant for this installation.
ad_broadcastmessage ad_client_id numeric 10 Client/Tenant for this installation.
ad_client ad_client_id numeric 10 Client/Tenant for this installation.
ad_clientinfo ad_client_id numeric 10 Client/Tenant for this installation.
ad_housekeeping ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
ad_issue ad_client_id numeric 10 Client/Tenant for this installation.
ad_ldapprocessor 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_role ad_client_id numeric 10 Client/Tenant for this installation.
ad_schedule ad_client_id numeric 10 Client/Tenant for this installation.
ad_scheduler ad_client_id numeric 10 Client/Tenant for this installation.
ad_scheduler_para ad_client_id numeric 10 Client/Tenant for this installation.
ad_schedulerlog ad_client_id numeric 10 Client/Tenant for this installation.
ad_schedulerrecipient 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_process ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflow ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflowprocessor ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflowprocessorlog ad_client_id numeric 10 Client/Tenant for this installation.
c_acctprocessor ad_client_id numeric 10 Client/Tenant for this installation.
c_acctprocessorlog ad_client_id numeric 10 Client/Tenant for this installation.
c_acctschema ad_client_id numeric 10 Client/Tenant for this installation.
exp_processor ad_client_id numeric 10 Client/Tenant for this installation.
imp_processor ad_client_id numeric 10 Client/Tenant for this installation.
r_requestprocessor ad_client_id numeric 10 Client/Tenant for this installation.
r_requestprocessorlog ad_client_id numeric 10 Client/Tenant for this installation.
ad_housekeeping ad_housekeeping_id numeric 10 House Keeping Configuration
ad_issue ad_issue_id numeric 10 Automatically created or manually entered System Issue
ad_ldapprocessor ad_ldapprocessor_id numeric 10 LDAP Server to authenticate and authorize external systems based on iDempiere
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_alert ad_org_id numeric 10 Organizational entity within client
ad_alertprocessor ad_org_id numeric 10 Organizational entity within client
ad_alertprocessorlog ad_org_id numeric 10 Organizational entity within client
ad_alertrecipient ad_org_id numeric 10 Organizational entity within client
ad_alertrule ad_org_id numeric 10 Organizational entity within client
ad_broadcastmessage ad_org_id numeric 10 Organizational entity within client
ad_client ad_org_id numeric 10 Organizational entity within client
ad_clientinfo ad_org_id numeric 10 Organizational entity within client
ad_housekeeping ad_org_id numeric 10 NULL::numeric Organizational entity within client
ad_issue ad_org_id numeric 10 Organizational entity within client
ad_ldapprocessor 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_role ad_org_id numeric 10 Organizational entity within client
ad_schedule ad_org_id numeric 10 Organizational entity within client
ad_scheduler ad_org_id numeric 10 Organizational entity within client
ad_scheduler_para ad_org_id numeric 10 Organizational entity within client
ad_schedulerlog ad_org_id numeric 10 Organizational entity within client
ad_schedulerrecipient 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_process ad_org_id numeric 10 Organizational entity within client
ad_workflow ad_org_id numeric 10 Organizational entity within client
ad_workflowprocessor ad_org_id numeric 10 Organizational entity within client
ad_workflowprocessorlog ad_org_id numeric 10 Organizational entity within client
c_acctprocessor ad_org_id numeric 10 Organizational entity within client
c_acctprocessorlog ad_org_id numeric 10 Organizational entity within client
c_acctschema ad_org_id numeric 10 Organizational entity within client
exp_processor ad_org_id numeric 10 Organizational entity within client
imp_processor ad_org_id numeric 10 Organizational entity within client
r_requestprocessor ad_org_id numeric 10 Organizational entity within client
r_requestprocessorlog ad_org_id numeric 10 Organizational entity within client
ad_pinstance ad_pinstance_id numeric 10 Instance of the process
ad_pinstance_log ad_pinstance_id numeric 10 Instance of the process
ad_pinstance_para ad_pinstance_id numeric 10 Instance of the process
ad_pinstance ad_process_id numeric 10 Process or Report
ad_process ad_process_id numeric 10 Process or Report
ad_process_para ad_process_id numeric 10 Process or Report
ad_scheduler ad_process_id numeric 10 Process or Report
ad_process_para ad_process_para_id numeric 10 Process Parameter
ad_scheduler_para ad_process_para_id numeric 10 Process Parameter
ad_process_para ad_reference_id numeric 10 System Reference and Validation
ad_role ad_role_id numeric 10 Responsibility Role
ad_alertprocessor ad_schedule_id numeric 10 NULL::numeric Schedule
ad_schedule ad_schedule_id numeric 10 NULL::numeric Schedule
ad_scheduler ad_schedule_id numeric 10 NULL::numeric Schedule
ad_workflowprocessor ad_schedule_id numeric 10 NULL::numeric Schedule
c_acctprocessor ad_schedule_id numeric 10 NULL::numeric Schedule
r_requestprocessor ad_schedule_id numeric 10 NULL::numeric Schedule
ad_scheduler ad_scheduler_id numeric 10 Schedule Processes
ad_scheduler_para ad_scheduler_id numeric 10 Schedule Processes
ad_schedulerlog ad_scheduler_id numeric 10 Schedule Processes
ad_schedulerrecipient ad_scheduler_id numeric 10 Schedule Processes
ad_schedulerlog ad_schedulerlog_id numeric 10 Result of the execution of the Scheduler
ad_schedulerrecipient ad_schedulerrecipient_id numeric 10 Recipient of the Scheduler Notification
ad_table ad_table_id numeric 10 Database Table information
ad_wf_process ad_table_id numeric 10 Database Table information
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_wf_process ad_wf_process_id numeric 10 Actual Workflow Process Instance
ad_wf_process ad_wf_responsible_id numeric 10 Responsible for Workflow Execution
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_workflowprocessor ad_workflowprocessor_id numeric 10 Workflow Processor Server
ad_workflowprocessorlog ad_workflowprocessor_id numeric 10 Workflow Processor Server
ad_workflowprocessorlog ad_workflowprocessorlog_id numeric 10 Result of the execution of the Workflow Processor
ad_alert alertmessage varchar 2000 Message of the Alert
ad_alert alertsubject varchar 255 Subject of the Alert
ad_role allow_info_account bpchar 1 'Y'::bpchar Allow Info Account
ad_role allow_info_asset bpchar 1 'Y'::bpchar Allow Info Asset
ad_role allow_info_bpartner bpchar 1 'Y'::bpchar Allow Info BPartner
ad_role allow_info_cashjournal bpchar 1 'N'::bpchar Allow Info CashJournal
ad_role allow_info_crp bpchar 1 'N'::bpchar Allow Info CRP
ad_role allow_info_inout bpchar 1 'Y'::bpchar Allow Info InOut
ad_role allow_info_invoice bpchar 1 'Y'::bpchar Allow Info Invoice
ad_role allow_info_mrp bpchar 1 'N'::bpchar Allow Info MRP
ad_role allow_info_order bpchar 1 'Y'::bpchar Allow Info Order
ad_role allow_info_payment bpchar 1 'Y'::bpchar Allow Info Payment
ad_role allow_info_product bpchar 1 'Y'::bpchar Allow Info Product
ad_role allow_info_resource bpchar 1 'Y'::bpchar Allow Info Resource
ad_role allow_info_schedule bpchar 1 'Y'::bpchar Allow Info Schedule
ad_workflow author varchar 20 'ComPiere'::character varying Author/Creator of the Entity
ad_client autoarchive bpchar 1 'N'::bpchar Enable and level of automatic Archive of documents
c_acctschema autoperiodcontrol bpchar 1 'N'::bpchar If selected, the periods are automatically opened and closed
ad_broadcastmessage broadcastfrequency varchar 60 NULL::character varying How Many Times Message Should be Broadcasted
ad_broadcastmessage broadcastmessage varchar 2000 Broadcast Message
ad_broadcastmessage broadcasttype varchar 32 NULL::character varying Type of Broadcast
c_acctprocessor c_acctprocessor_id numeric 10 Accounting Processor/Server Parameters
c_acctprocessorlog c_acctprocessor_id numeric 10 Accounting Processor/Server Parameters
c_acctprocessorlog c_acctprocessorlog_id numeric 10 Result of the execution of the Accounting Processor
c_acctschema c_acctschema_id numeric 10 Rules for accounting
c_acctschema c_currency_id numeric 10 The Currency for this record
ad_process_para columnname varchar 30 Name of the column in the database
c_acctschema commitmenttype bpchar 1 'N'::bpchar Create Commitment and/or Reservations for Budget Control
ad_role confirmqueryrecords numeric 10 0 Require Confirmation if more records will be returned by the query (If not defined 500)
ad_workflow cost numeric 0 Cost information
c_acctschema costinglevel bpchar 1 'C'::bpchar The lowest level to accumulate Costing Information
c_acctschema costingmethod bpchar 1 Indicates how Costs will be calculated
ad_alert created timestamp 29,6 now() Date this record was created
ad_alertprocessor created timestamp 29,6 now() Date this record was created
ad_alertprocessorlog created timestamp 29,6 now() Date this record was created
ad_alertrecipient created timestamp 29,6 now() Date this record was created
ad_alertrule created timestamp 29,6 now() Date this record was created
ad_broadcastmessage created timestamp 29,6 now() Date this record was created
ad_client created timestamp 29,6 now() Date this record was created
ad_clientinfo created timestamp 29,6 now() Date this record was created
ad_housekeeping created timestamp 29,6 statement_timestamp() Date this record was created
ad_issue created timestamp 29,6 now() Date this record was created
ad_ldapprocessor 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_pinstance created timestamp 29,6 now() Date this record was created
ad_pinstance_para created timestamp 29,6 statement_timestamp() Date this record was created
ad_process created timestamp 29,6 now() Date this record was created
ad_process_para created timestamp 29,6 now() Date this record was created
ad_role created timestamp 29,6 now() Date this record was created
ad_schedule created timestamp 29,6 statement_timestamp() Date this record was created
ad_scheduler created timestamp 29,6 now() Date this record was created
ad_scheduler_para created timestamp 29,6 now() Date this record was created
ad_schedulerlog created timestamp 29,6 now() Date this record was created
ad_schedulerrecipient 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_process created timestamp 29,6 now() Date this record was created
ad_workflow created timestamp 29,6 now() Date this record was created
ad_workflowprocessor created timestamp 29,6 now() Date this record was created
ad_workflowprocessorlog created timestamp 29,6 now() Date this record was created
c_acctprocessor created timestamp 29,6 now() Date this record was created
c_acctprocessorlog created timestamp 29,6 now() Date this record was created
c_acctschema created timestamp 29,6 now() Date this record was created
exp_processor created timestamp 29,6 statement_timestamp() Date this record was created
imp_processor created timestamp 29,6 statement_timestamp() Date this record was created
r_requestprocessor created timestamp 29,6 now() Date this record was created
r_requestprocessorlog created timestamp 29,6 now() Date this record was created
ad_alert createdby numeric 10 User who created this records
ad_alertprocessor createdby numeric 10 User who created this records
ad_alertprocessorlog createdby numeric 10 User who created this records
ad_alertrecipient createdby numeric 10 User who created this records
ad_alertrule createdby numeric 10 User who created this records
ad_broadcastmessage createdby numeric 10 User who created this records
ad_client createdby numeric 10 User who created this records
ad_clientinfo createdby numeric 10 User who created this records
ad_housekeeping createdby numeric 10 User who created this records
ad_issue createdby numeric 10 User who created this records
ad_ldapprocessor 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_role createdby numeric 10 User who created this records
ad_schedule createdby numeric 10 User who created this records
ad_scheduler createdby numeric 10 User who created this records
ad_scheduler_para createdby numeric 10 User who created this records
ad_schedulerlog createdby numeric 10 User who created this records
ad_schedulerrecipient 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_process createdby numeric 10 User who created this records
ad_workflow createdby numeric 10 User who created this records
ad_workflowprocessor createdby numeric 10 User who created this records
ad_workflowprocessorlog createdby numeric 10 User who created this records
c_acctprocessor createdby numeric 10 User who created this records
c_acctprocessorlog createdby numeric 10 User who created this records
c_acctschema createdby numeric 10 User who created this records
exp_processor createdby numeric 10 User who created this records
imp_processor createdby numeric 10 User who created this records
r_requestprocessor createdby numeric 10 User who created this records
r_requestprocessorlog createdby numeric 10 User who created this records
ad_workflow duration numeric 10 0 Normal Duration in Duration Unit
ad_alert enforceclientsecurity bpchar 1 'Y'::bpchar Send alerts to recipient only if the client security rules of the role allows
ad_alert enforcerolesecurity bpchar 1 'Y'::bpchar Send alerts to recipient only if the data security rules of the role allows
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_workflow entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
exp_processor exp_processor_id numeric 10 Export Processor
exp_processor exp_processor_type_id numeric 10 Export Processor Type
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
ad_process_para fieldlength numeric 10 Length of the column in the database
imp_processor frequency numeric 10 Frequency of events
imp_processor frequencytype bpchar 1 Frequency of event
ad_alertrule fromclause varchar 2000 SQL FROM clause
c_acctschema gaap bpchar 2 Generally Accepted Accounting Principles
c_acctschema hasalias bpchar 1 'Y'::bpchar Ability to select (partial) account combinations by an Alias
c_acctschema hascombination bpchar 1 'Y'::bpchar Combination of account elements are checked
imp_processor imp_processor_id numeric 10 Import Processor
imp_processor imp_processor_type_id numeric 10 Import Processor Type
r_requestprocessor inactivityalertdays numeric 10 0 Send Alert when there is no activity after days (0= no alert)
ad_role isaccessallorgs bpchar 1 'N'::bpchar Access all Organizations (no org access control) of the client
c_acctschema isaccrual bpchar 1 'Y'::bpchar Indicates if Accrual or Cash Based accounting will be used
ad_alert isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_alertprocessor isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_alertprocessorlog isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_alertrecipient isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_alertrule isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_broadcastmessage isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_client isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_clientinfo isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_housekeeping isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_issue isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_ldapprocessor 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_role isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_schedule isactive varchar 1 'Y'::character varying The record is active in the system
ad_scheduler isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_scheduler_para isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_schedulerlog isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_schedulerrecipient 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_process 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_workflowprocessor isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_workflowprocessorlog isactive bpchar 1 'Y'::bpchar The record is active in the system
c_acctprocessor isactive bpchar 1 'Y'::bpchar The record is active in the system
c_acctprocessorlog isactive bpchar 1 'Y'::bpchar The record is active in the system
c_acctschema isactive bpchar 1 'Y'::bpchar The record is active in the system
exp_processor isactive bpchar 1 'Y'::bpchar The record is active in the system
imp_processor isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestprocessor isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestprocessorlog isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar The selected mail template will be automatically inserted when creating an email
c_acctschema isadjustcogs bpchar 1 'N'::bpchar Adjust Cost of Good Sold
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_role iscanapproveowndoc bpchar 1 'Y'::bpchar Users with this role can approve their own documents
ad_role iscanexport bpchar 1 'Y'::bpchar Users with this role can export data
ad_role iscanreport bpchar 1 'Y'::bpchar Users with this role can create reports
ad_process_para iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
ad_role ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_clientinfo isconfirmondocclose bpchar 1 'N'::bpchar Show Confirmation On Document Action Close
ad_clientinfo isconfirmondocvoid bpchar 1 'N'::bpchar Show Confirmation On Document Action Void
ad_client iscostimmediate bpchar 1 'N'::bpchar Update Costs immediately for testing
ad_workflow isdefault bpchar 1 'N'::bpchar Default value
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
ad_role isdiscountallowedontotal bpchar 1 'N'::bpchar IsDiscountAllowedOnTotal
c_acctschema isdiscountcorrectstax bpchar 1 'N'::bpchar Correct the tax for payment discount and charges
ad_clientinfo isdiscountlineamt bpchar 1 'Y'::bpchar Payment Discount calculation does not include Taxes and Charges
ad_role isdiscountuptolimitprice bpchar 1 'N'::bpchar IsDiscountUptoLimitPrice
ad_process_para isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_alertprocessorlog iserror bpchar 1 'N'::bpchar An Error occurred in the execution
ad_schedulerlog iserror bpchar 1 'N'::bpchar An Error occurred in the execution
ad_workflowprocessorlog iserror bpchar 1 'N'::bpchar An Error occurred in the execution
c_acctprocessorlog iserror bpchar 1 'N'::bpchar An Error occurred in the execution
r_requestprocessorlog iserror bpchar 1 'N'::bpchar An Error occurred in the execution
ad_user isexpired bpchar 1 'N'::bpchar Expired
c_acctschema isexplicitcostadjustment bpchar 1 'N'::bpchar Post the cost adjustment explicitly
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
ad_table ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
ad_schedule isignoreprocessingtime bpchar 1 'N'::bpchar Do not include processing time for the DateNextRun calculation
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
ad_user islocked bpchar 1 'N'::bpchar Locked
ad_process_para ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_role ismanual bpchar 1 'Y'::bpchar This is a manual process
ad_role ismasterrole bpchar 1 'N'::bpchar A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_role ismenuautoexpand bpchar 1 'N'::bpchar If ticked, the menu is automatically expanded
ad_client ismultilingualdocument bpchar 1 'N'::bpchar Documents are Multi Lingual
ad_user isnoexpire bpchar 1 'N'::bpchar No Expire
ad_user isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
ad_role ispersonalaccess bpchar 1 'N'::bpchar Allow access to all personal records
ad_role ispersonallock bpchar 1 'N'::bpchar Allow users with role to lock access to personal records
ad_client ispostimmediate bpchar 1 'N'::bpchar Post the accounting immediately for testing (Deprecated)
c_acctschema ispostservices bpchar 1 'N'::bpchar Differentiate between Services and Product Receivable/Payables
ad_pinstance isprocessing bpchar 1 'N'::bpchar Processing
ad_process_para isrange bpchar 1 'N'::bpchar The parameter is a range of values
ad_process isreport bpchar 1 'Y'::bpchar Indicates a Report record
ad_user issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
ad_client issecuresmtp bpchar 1 'N'::bpchar Use SSL/TLS for SMTP
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
ad_role isshowacct bpchar 1 'Y'::bpchar Users with this role can see accounting information
ad_client issmtpauthorization bpchar 1 'N'::bpchar Your mail server requires Authentication
ad_issue issuesummary varchar 2000 Issue Summary
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_schedule issystemschedule bpchar 1 'N'::bpchar Schedule Just For System
c_acctschema istradediscountposted bpchar 1 'N'::bpchar Generate postings for trade discounts
ad_schedulerrecipient isupload bpchar 1 'N'::bpchar Upload
ad_client isuseasp bpchar 1 'N'::bpchar IsUseASP
ad_client isusebetafunctions bpchar 1 'N'::bpchar Enable the use of Beta Functionality
ad_role isuseuserorgaccess bpchar 1 'N'::bpchar Use Org Access defined by user instead of Role Org Access
ad_alert isvalid bpchar 1 'Y'::bpchar Element is valid
ad_alertrule isvalid bpchar 1 'Y'::bpchar Element is valid
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_alertprocessor keeplogdays numeric 10 Number of days to keep the log entries
ad_ldapprocessor keeplogdays numeric 10 0 Number of days to keep the log entries
ad_scheduler keeplogdays numeric 10 Number of days to keep the log entries
ad_workflowprocessor keeplogdays numeric 10 Number of days to keep the log entries
c_acctprocessor keeplogdays numeric 10 Number of days to keep the log entries
imp_processor keeplogdays numeric 10 (7)::numeric Number of days to keep the log entries
r_requestprocessor keeplogdays numeric 10 Number of days to keep the log entries
ad_ldapprocessor ldapport numeric 10 0 The port the server is listening
ad_pinstance_log log_id numeric 10 Log
ad_role maxqueryrecords numeric 10 0 If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
ad_client mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
ad_message msgtext varchar 2000 Textual Informational, Menu or Error Message
ad_message msgtype bpchar 1 Type of message (Informational, Menu or Error)
ad_alert name varchar 60 Alphanumeric identifier of the entity
ad_alertprocessor name varchar 60 Alphanumeric identifier of the entity
ad_alertrule name varchar 60 Alphanumeric identifier of the entity
ad_client name varchar 60 Alphanumeric identifier of the entity
ad_housekeeping name varchar 60 Alphanumeric identifier of the entity
ad_issue name varchar 60 Alphanumeric identifier of the entity
ad_ldapprocessor 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_role name varchar 60 Alphanumeric identifier of the entity
ad_schedule name varchar 60 NULL::character varying Alphanumeric identifier of the entity
ad_scheduler 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_workflow name varchar 60 Alphanumeric identifier of the entity
ad_workflowprocessor name varchar 60 Alphanumeric identifier of the entity
c_acctprocessor name varchar 60 Alphanumeric identifier of the entity
c_acctschema name varchar 60 Alphanumeric identifier of the entity
exp_processor name varchar 60 Alphanumeric identifier of the entity
imp_processor name varchar 60 Alphanumeric identifier of the entity
r_requestprocessor name varchar 60 Alphanumeric identifier of the entity
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
r_requestprocessor overduealertdays numeric 10 Send email alert after number of days due (0=no alerts)
r_requestprocessor overdueassigndays numeric 10 Escalation to superior after number of due days (0 = no)
ad_role overwritepricelimit bpchar 1 'N'::bpchar Overwrite Price Limit if the Price List enforces the Price Limit
ad_role preferencetype bpchar 1 'C'::bpchar Determines what preferences the user can set
ad_issue processed bpchar 1 'N'::bpchar The document has been processed
ad_wf_process processed bpchar 1 'N'::bpchar The document has been processed
ad_workflow publishstatus bpchar 1 Status of Publication
r_requestprocessor r_requestprocessor_id numeric 10 Processor for Requests
r_requestprocessorlog r_requestprocessor_id numeric 10 Processor for Requests
r_requestprocessorlog r_requestprocessorlog_id numeric 10 Result of the execution of the Request Processor
ad_pinstance record_id numeric 10 Direct internal record ID
ad_wf_process record_id numeric 10 Direct internal record ID
ad_issue releaseno varchar 10 '.'::character varying Internal Release Number
r_requestprocessor reminddays numeric 10 7 Days between sending Reminder Emails for a due or inactive Document
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_scheduler scheduletype bpchar 1 'F'::bpchar Type of schedule
ad_alertrule selectclause varchar 2000 SQL SELECT clause
c_acctschema separator bpchar 1 Element Separator
ad_pinstance_para seqno numeric 10 Method of ordering records; lowest number comes first
ad_process_para seqno numeric 10 Method of ordering records; lowest number comes first
ad_client storearchiveonfilesystem bpchar 1 'N'::bpchar Store Archive On File System
ad_client storeattachmentsonfilesystem bpchar 1 'N'::bpchar Store Attachments On File System
ad_alertprocessor supervisor_id numeric 10 Supervisor for this user/organization - used for escalation and approval
ad_ldapprocessor supervisor_id numeric 10 Supervisor for this user/organization - used for escalation and approval
ad_scheduler supervisor_id numeric 10 Supervisor for this user/organization - used for escalation and approval
ad_workflowprocessor supervisor_id numeric 10 Supervisor for this user/organization - used for escalation and approval
c_acctprocessor supervisor_id numeric 10 Supervisor for this user/organization - used for escalation and approval
r_requestprocessor supervisor_id numeric 10 Supervisor for this user/organization - used for escalation and approval
ad_issue systemstatus bpchar 1 Status of the system - Support priority depends on system status
ad_table tablename varchar 40 Name of the table in the database
ad_broadcastmessage target varchar 60 NULL::character varying Target client
ad_alert updated timestamp 29,6 now() Date this record was updated
ad_alertprocessor updated timestamp 29,6 now() Date this record was updated
ad_alertprocessorlog updated timestamp 29,6 now() Date this record was updated
ad_alertrecipient updated timestamp 29,6 now() Date this record was updated
ad_alertrule updated timestamp 29,6 now() Date this record was updated
ad_broadcastmessage updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_client updated timestamp 29,6 now() Date this record was updated
ad_clientinfo updated timestamp 29,6 now() Date this record was updated
ad_housekeeping updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_issue updated timestamp 29,6 now() Date this record was updated
ad_ldapprocessor 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_pinstance updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_pinstance_para updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_process updated timestamp 29,6 now() Date this record was updated
ad_process_para updated timestamp 29,6 now() Date this record was updated
ad_role updated timestamp 29,6 now() Date this record was updated
ad_schedule updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_scheduler updated timestamp 29,6 now() Date this record was updated
ad_scheduler_para updated timestamp 29,6 now() Date this record was updated
ad_schedulerlog updated timestamp 29,6 now() Date this record was updated
ad_schedulerrecipient 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_process updated timestamp 29,6 now() Date this record was updated
ad_workflow updated timestamp 29,6 now() Date this record was updated
ad_workflowprocessor updated timestamp 29,6 now() Date this record was updated
ad_workflowprocessorlog updated timestamp 29,6 now() Date this record was updated
c_acctprocessor updated timestamp 29,6 now() Date this record was updated
c_acctprocessorlog updated timestamp 29,6 now() Date this record was updated
c_acctschema updated timestamp 29,6 now() Date this record was updated
exp_processor updated timestamp 29,6 statement_timestamp() Date this record was updated
imp_processor updated timestamp 29,6 statement_timestamp() Date this record was updated
r_requestprocessor updated timestamp 29,6 now() Date this record was updated
r_requestprocessorlog updated timestamp 29,6 now() Date this record was updated
ad_alert updatedby numeric 10 User who updated this records
ad_alertprocessor updatedby numeric 10 User who updated this records
ad_alertprocessorlog updatedby numeric 10 User who updated this records
ad_alertrecipient updatedby numeric 10 User who updated this records
ad_alertrule updatedby numeric 10 User who updated this records
ad_broadcastmessage updatedby numeric 10 User who updated this records
ad_client updatedby numeric 10 User who updated this records
ad_clientinfo updatedby numeric 10 User who updated this records
ad_housekeeping updatedby numeric 10 User who updated this records
ad_issue updatedby numeric 10 User who updated this records
ad_ldapprocessor 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_pinstance 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_role updatedby numeric 10 User who updated this records
ad_schedule updatedby numeric 10 User who updated this records
ad_scheduler updatedby numeric 10 User who updated this records
ad_scheduler_para updatedby numeric 10 User who updated this records
ad_schedulerlog updatedby numeric 10 User who updated this records
ad_schedulerrecipient 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_process updatedby numeric 10 User who updated this records
ad_workflow updatedby numeric 10 User who updated this records
ad_workflowprocessor updatedby numeric 10 User who updated this records
ad_workflowprocessorlog updatedby numeric 10 User who updated this records
c_acctprocessor updatedby numeric 10 User who updated this records
c_acctprocessorlog updatedby numeric 10 User who updated this records
c_acctschema updatedby numeric 10 User who updated this records
exp_processor updatedby numeric 10 User who updated this records
imp_processor updatedby numeric 10 User who updated this records
r_requestprocessor updatedby numeric 10 User who updated this records
r_requestprocessorlog updatedby numeric 10 User who updated this records
ad_role userlevel bpchar 3 ' O'::bpchar System Client Organization
ad_issue username varchar 60 User Name
ad_client value varchar 40 Search key for the record in the format required - must be unique
ad_housekeeping 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_workflow value varchar 40 Search key for the record in the format required - must be unique
exp_processor value varchar 40 Search key for the record in the format required - must be unique
imp_processor value varchar 40 Search key for the record in the format required - must be unique
ad_issue version varchar 40 Version of the table definition
ad_workflow version numeric 10 0 Version of the table definition
ad_workflow waitingtime numeric 10 0 Workflow Simulation Waiting time
ad_wf_process wfstate bpchar 2 State of the execution of the workflow
ad_workflow workflowtype bpchar 1 'G'::bpchar Type of Workflow
ad_workflow workingtime numeric 10 0 Workflow Simulation Execution Time