SchemaSpy Analysis of idempiere11.adempiere - ColumnsServer | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:55 +0100 |
| |||||
|
idempiere11.adempiere contains 956 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
ad_role | amtapproval | numeric | 0 | √ | 0 | The approval amount limit for this role | |
ad_role | amtapprovalaccum | numeric | 0 | √ | null | The approval amount limit for this role accumulated on a period | |
ad_workflow | cost | numeric | 0 | Cost information | |||
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_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_workflow | qtybatchsize | numeric | 0 | √ | (1)::numeric | Qty Batch Size | |
ad_process | statistic_seconds | numeric | 0 | √ | null | Internal statistics how many seconds a process took | |
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_process | accesslevel | bpchar | 1 | Access Level required | |||
ad_table | accesslevel | bpchar | 1 | Access Level required | |||
ad_workflow | accesslevel | bpchar | 1 | Access Level required | |||
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 Cash Journal | ||
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_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 | ||
c_acctschema | commitmenttype | bpchar | 1 | 'N'::bpchar | Create Commitment and/or Reservations for Budget Control | ||
ad_role | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
ad_table | copycolumnsfromtable | varchar | 1 | √ | null | Copy Columns From Table | |
ad_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. | |
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_table | createpartition | bpchar | 1 | √ | NULL::bpchar | Process which create or update table partitions based on the table and column records | |
ad_table | createwindowfromtable | bpchar | 1 | √ | NULL::bpchar | Create Window From Table | |
ad_table | databaseviewdrop | bpchar | 1 | √ | NULL::bpchar | Drop view | |
ad_process_para | daterangeoption | bpchar | 1 | 'D'::bpchar | Options, how the date editor will be displayed. | ||
ad_workflow | durationunit | bpchar | 1 | √ | null | Unit of Duration | |
ad_client | emailtest | bpchar | 1 | √ | null | Test EMail | |
ad_alert | enforceclientsecurity | bpchar | 1 | 'Y'::bpchar | Send alerts to recipient only if the tenant 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_process | executiontype | bpchar | 1 | √ | NULL::bpchar | Execution Type defines whether the report/process will always run in background or foreground. | |
ad_broadcastmessage | expired | bpchar | 1 | √ | 'N'::bpchar | Expired | |
ad_broadcastmessage | expirenow | bpchar | 1 | √ | null | Expire the broadcast message | |
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 | |
imp_processor | frequencytype | bpchar | 1 | Frequency of event | |||
r_requestprocessor | frequencytype | bpchar | 1 | √ | null | Frequency of event | |
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 | ||
ad_table | importtable | bpchar | 1 | √ | null | Import Table Columns from Database | |
ad_role | isaccessadvanced | bpchar | 1 | √ | 'N'::bpchar | Access Advanced | |
ad_role | isaccessallorgs | bpchar | 1 | 'N'::bpchar | Access all Organizations (no org access control) of the tenant | ||
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_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 | |
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 | ||
c_acctschema | isallownegativeposting | bpchar | 1 | √ | 'Y'::bpchar | Allow to post negative accounting values | |
ad_process_para | isautocomplete | bpchar | 1 | 'N'::bpchar | Automatic completion for text fields | ||
ad_process | isbetafunctionality | bpchar | 1 | 'N'::bpchar | This functionality is considered Beta | ||
ad_workflow | isbetafunctionality | bpchar | 1 | 'N'::bpchar | This functionality is considered Beta | ||
ad_user | isbillto | bpchar | 1 | 'N'::bpchar | Business Partner Invoice/Bill Address | ||
ad_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_table | iscentrallymaintained | bpchar | 1 | √ | 'Y'::bpchar | Information maintained in System Element table | |
ad_role | ischangelog | bpchar | 1 | 'N'::bpchar | Maintain a log of changes | ||
ad_table | ischangelog | bpchar | 1 | 'N'::bpchar | Maintain a log of changes | ||
ad_role | isclientadministrator | bpchar | 1 | 'N'::bpchar | This role is a tenant administrator | ||
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_process | isdirectprint | bpchar | 1 | √ | 'N'::bpchar | Print without dialog | |
ad_role | isdiscountallowedontotal | bpchar | 1 | 'N'::bpchar | Is Discount Allowed On Total | ||
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 | Is Discount Up to Limit Price | ||
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_housekeeping | isexportxmlbackup | bpchar | 1 | √ | null | Export XML Backup | |
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_scheduler | 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_user | ismenuautoexpand | bpchar | 1 | √ | null | 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_pinstance_para | isnotclause | bpchar | 1 | 'N'::bpchar | Indicates if a chosen multiple component value must be negate | ||
ad_table | ispartition | bpchar | 1 | 'N'::bpchar | This is a partitioned table | ||
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 | ||
c_acctschema | ispostifclearingequal | bpchar | 1 | √ | 'Y'::bpchar | This flag controls if Adempiere must post when clearing (transit) and final accounts are the same | |
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_broadcastmessage | ispublished | bpchar | 1 | √ | 'N'::bpchar | The Topic is published and can be viewed | |
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_issue | isreproducible | bpchar | 1 | √ | 'N'::bpchar | Problem can re reproduced in Gardenworld | |
ad_pinstance | isrunasjob | bpchar | 1 | √ | 'N'::bpchar | Run as Job | |
ad_user | issaleslead | bpchar | 1 | 'N'::bpchar | This contact is a sales lead | ||
ad_housekeeping | issaveinhistoric | bpchar | 1 | √ | null | Save In Historic | |
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_client | isserveremail | bpchar | 1 | √ | null | Send EMail from Server | |
ad_process | isserverprocess | bpchar | 1 | √ | null | Run this Process on Server only | |
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_table | isshowindrilloptions | bpchar | 1 | √ | 'Y'::bpchar | This parameter enables the table to be displayed in Drill Assistant - Table tab | |
ad_process_para | isshownegatebutton | bpchar | 1 | 'N'::bpchar | Show Negate Button for Chosen Multiple editors | ||
ad_client | issmtpauthorization | bpchar | 1 | 'N'::bpchar | Your mail server requires Authentication | ||
ad_issue | issuesource | bpchar | 1 | √ | null | Issue Source | |
ad_pinstance | issummary | bpchar | 1 | √ | NULL::bpchar | This is a summary entity | |
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 | Is Use ASP | ||
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_issue | isvanillasystem | bpchar | 1 | √ | 'N'::bpchar | The system was NOT compiled from Source - i.e. standard distribution | |
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_broadcastmessage | logacknowledge | bpchar | 1 | √ | 'N'::bpchar | Want to Log the Acknowledgment of Message? | |
ad_client | mmpolicy | bpchar | 1 | 'F'::bpchar | Material Movement Policy | ||
ad_message | msgtype | bpchar | 1 | Type of message (Informational, Menu or Error) | |||
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
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_broadcastmessage | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
ad_issue | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
ad_note | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
ad_wf_process | 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_broadcastmessage | publish | bpchar | 1 | √ | NULL::bpchar | Publish Broadcast Message | |
ad_workflow | publishstatus | bpchar | 1 | Status of Publication | |||
ad_table | replicationtype | bpchar | 1 | 'L'::bpchar | Type of Data Replication | ||
ad_schedule | scheduletype | bpchar | 1 | √ | 'F'::bpchar | Type of schedule | |
ad_scheduler | scheduletype | bpchar | 1 | 'F'::bpchar | Type of schedule | ||
c_acctschema | separator | bpchar | 1 | Element Separator | |||
ad_process | showhelp | bpchar | 1 | √ | 'Y'::bpchar | Show Help | |
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_issue | systemstatus | bpchar | 1 | Status of the system - Support priority depends on system status | |||
c_acctschema | taxcorrectiontype | bpchar | 1 | √ | null | Type of Tax Correction | |
ad_broadcastmessage | testmessage | bpchar | 1 | √ | NULL::bpchar | Test broadcast message | |
ad_workflow | validateworkflow | bpchar | 1 | √ | null | Validate Workflow | |
ad_schedule | weekday | bpchar | 1 | √ | NULL::bpchar | Day of the Week | |
ad_scheduler | weekday | bpchar | 1 | √ | null | Day of the Week | |
ad_workflow | workflowtype | bpchar | 1 | 'G'::bpchar | Type of Workflow | ||
ad_process | allowmultipleexecution | varchar | 2 | 'P'::character varying | Allow or disallow executing a process/report multiple times concurrently | ||
c_acctschema | gaap | bpchar | 2 | Generally Accepted Accounting Principles | |||
ad_pinstance | notificationtype | varchar | 2 | √ | NULL::character varying | Type of Notifications | |
ad_workflow | processtype | bpchar | 2 | √ | null | Process Type | |
ad_role | roletype | varchar | 2 | √ | NULL::character varying | Role Type | |
ad_wf_process | wfstate | bpchar | 2 | State of the execution of the workflow | |||
ad_pinstance_log | pinstancelogtype | varchar | 3 | √ | 'R'::character varying | Process Audit Log Type | |
ad_role | userlevel | bpchar | 3 | ' O'::bpchar | System Tenant Organization | ||
ad_scheduler | reportoutputtype | varchar | 4 | √ | NULL::character varying | Report Output Type | |
ad_pinstance | reporttype | varchar | 5 | √ | NULL::character varying | Report Type | |
ad_client | ad_language | varchar | 6 | √ | null | Language for this entity | |
ad_issue | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
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_alert | ad_alertprocessor_id | numeric | 10 | √ | null | Alert Processor/Server Parameter | |
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_schedulerrecipient | ad_authorizationaccount_id | numeric | 10 | √ | NULL::numeric | Authorization Account | |
ad_broadcastmessage | ad_broadcastmessage_id | numeric | 10 | NULL::numeric | Broadcast Message | ||
ad_note | ad_broadcastmessage_id | numeric | 10 | √ | NULL::numeric | Broadcast Message | |
ad_alert | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_alertprocessor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_alertprocessorlog | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_alertrecipient | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_alertrule | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_broadcastmessage | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_client | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_clientinfo | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_housekeeping | ad_client_id | numeric | 10 | NULL::numeric | Tenant for this installation. | ||
ad_issue | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_ldapprocessor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_message | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_note | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_pinstance | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
ad_pinstance_para | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
ad_process | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_process_para | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_role | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_schedule | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_scheduler | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_scheduler_para | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_schedulerlog | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_schedulerrecipient | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_table | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_user | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_wf_process | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_workflow | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_workflowprocessor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_workflowprocessorlog | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_acctprocessor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_acctprocessorlog | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_acctschema | ad_client_id | numeric | 10 | Tenant for this installation. | |||
exp_processor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
imp_processor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_requestprocessor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_requestprocessorlog | ad_client_id | numeric | 10 | Tenant for this installation. | |||
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_id | numeric | 10 | House Keeping Configuration | |||
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
ad_issue | ad_issue_id | numeric | 10 | Automatically created or manually entered System Issue | |||
ad_pinstance | ad_language_id | numeric | 10 | √ | NULL::numeric | Language ID | |
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_wf_process | ad_message_id | numeric | 10 | √ | null | System Message | |
ad_note | ad_note_id | numeric | 10 | System Notice | |||
ad_alert | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_alertprocessor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_alertprocessorlog | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_alertrecipient | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_alertrule | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_broadcastmessage | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_client | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_clientinfo | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_housekeeping | ad_org_id | numeric | 10 | NULL::numeric | Organizational entity within tenant | ||
ad_issue | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_ldapprocessor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_message | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_note | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_pinstance | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
ad_pinstance_para | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
ad_process | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_process_para | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_role | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_schedule | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_scheduler | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_scheduler_para | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_schedulerlog | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_schedulerrecipient | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_table | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_user | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_wf_process | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_workflow | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_workflowprocessor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_workflowprocessorlog | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_acctprocessor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_acctprocessorlog | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_acctschema | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
exp_processor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
imp_processor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_requestprocessor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_requestprocessorlog | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
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 | 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_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_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_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_role | ad_role_id | numeric | 10 | Responsibility Role | |||
ad_schedulerrecipient | ad_role_id | numeric | 10 | √ | null | 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_pinstance | ad_session_id | numeric | 10 | √ | NULL::numeric | User Session Online or Web | |
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 | ad_table_id | numeric | 10 | √ | NULL::numeric | 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_table | ad_table_id | numeric | 10 | Database Table information | |||
ad_wf_process | ad_table_id | numeric | 10 | 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_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_user | ad_user_id | numeric | 10 | 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_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_id | numeric | 10 | Actual Workflow Process Instance | |||
ad_wf_process | ad_wf_responsible_id | numeric | 10 | Responsible for Workflow Execution | |||
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_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 | ad_workflowprocessor_id | numeric | 10 | √ | null | Workflow Processor Server | |
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_workflowprocessor | alertoverpriority | numeric | 10 | √ | null | Send alert email when over priority | |
ad_client | authenticationtype | varchar | 10 | 'AAS'::character varying | Authentication Type | ||
ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | Authentication Type | |
ad_user | bp_location_id | numeric | 10 | √ | NULL::numeric | Address of the Business Partner | |
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 | |||
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_id | numeric | 10 | Rules for accounting | |||
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 | |
c_acctschema | c_currency_id | numeric | 10 | 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_role | confirmqueryrecords | numeric | 10 | 0 | Require Confirmation if more records will be returned by the query (If not defined 500) | ||
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_pinstance | createdby | numeric | 10 | √ | null | User who created this records | |
ad_pinstance_para | createdby | numeric | 10 | √ | null | 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_role | daysapprovalaccum | numeric | 10 | √ | null | The days approval indicates the days to take into account to verify the accumulated approval amount. | |
ad_workflow | duration | numeric | 10 | 0 | Normal Duration in Duration Unit | ||
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 | |||
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 | |
imp_processor | frequency | numeric | 10 | Frequency of events | |||
r_requestprocessor | frequency | numeric | 10 | √ | (1)::numeric | Frequency of events | |
imp_processor | imp_processor_id | numeric | 10 | Import Processor | |||
imp_processor | imp_processor_type_id | numeric | 10 | Import Processor Type | |||
ad_workflowprocessor | inactivityalertdays | numeric | 10 | √ | 0 | Send Alert when there is no activity after days (0= no alert) | |
r_requestprocessor | inactivityalertdays | numeric | 10 | 0 | Send Alert when there is no activity after days (0= no alert) | ||
ad_alertprocessor | keeplogdays | numeric | 10 | Number of days to keep the log entries | |||
ad_clientinfo | keeplogdays | numeric | 10 | √ | null | 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_housekeeping | lastdeleted | numeric | 10 | √ | null | Last Deleted | |
ad_ldapprocessor | ldapport | numeric | 10 | 0 | The port the server is listening | ||
ad_user | leadsource | varchar | 10 | √ | NULL::character varying | 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_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_pinstance_log | log_id | numeric | 10 | Log | |||
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_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_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_broadcastmessage | notification_client_id | numeric | 10 | √ | null | Notification Tenant | |
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_pinstance_log | p_id | numeric | 10 | √ | null | Process ID | |
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_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_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_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_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 | |||
r_requestprocessor | r_requesttype_id | numeric | 10 | √ | null | Type of request (e.g. Inquiry, Complaint, ..) | |
ad_issue | record_id | numeric | 10 | √ | null | Direct internal record ID | |
ad_note | record_id | numeric | 10 | √ | null | Direct internal record ID | |
ad_pinstance | record_id | numeric | 10 | 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_wf_process | record_id | numeric | 10 | Direct internal record ID | |||
ad_issue | releaseno | varchar | 10 | '.'::character varying | Internal Release Number | ||
ad_workflowprocessor | reminddays | numeric | 10 | √ | 0 | Days between sending Reminder Emails for a due or inactive Document | |
r_requestprocessor | reminddays | numeric | 10 | 7 | Days between sending Reminder Emails for a due or inactive Document | ||
ad_pinstance | result | numeric | 10 | √ | null | Result of the action taken | |
ad_workflow | s_resource_id | numeric | 10 | √ | null | Resource | |
ad_user | salesrep_id | numeric | 10 | √ | NULL::numeric | Sales Representative or Company Agent | |
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_workflow | setuptime | numeric | 10 | √ | null | Setup time before starting Production | |
ad_client | smtpport | numeric | 10 | √ | NULL::numeric | SMTP Port Number | |
ad_process | statistic_count | numeric | 10 | √ | null | Internal statistics how often the entity was used | |
ad_clientinfo | storagearchive_id | numeric | 10 | √ | NULL::numeric | Archive Store | |
ad_clientinfo | storageimage_id | numeric | 10 | √ | NULL::numeric | Storage provider for Image | |
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_role | supervisor_id | numeric | 10 | √ | null | 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_user | supervisor_id | numeric | 10 | √ | null | 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_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_pinstance_para | updatedby | numeric | 10 | √ | null | 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_workflow | version | numeric | 10 | 0 | Version of the table definition | ||
ad_workflow | waitingtime | numeric | 10 | 0 | Workflow Simulation Waiting time | ||
ad_workflow | workingtime | numeric | 10 | 0 | Workflow Simulation Execution Time | ||
ad_workflow | yield | numeric | 10 | √ | (100)::numeric | The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent | |
ad_user | salt | varchar | 16 | √ | NULL::character varying | Random data added to improve password hash effectiveness | |
ad_workflow | author | varchar | 20 | 'ComPiere'::character varying | Author/Creator of the Entity | ||
ad_client | requestfolder | varchar | 20 | √ | null | EMail folder to process incoming emails; if empty INBOX is used | |
ad_user | userpin | varchar | 20 | √ | null | User PIN | |
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_role | userdiscount | numeric | 22,2 | √ | null | User Discount | |
ad_user | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
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_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_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_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_user | emailverifydate | timestamp | 29,6 | √ | null | Date Email was verified | |
ad_broadcastmessage | expiration | timestamp | 29,6 | √ | null | Expire On | |
ad_clientinfo | fy_startdate | timestamp | 29,6 | √ | null | Financial Year Start Date | |
ad_user | lastcontact | timestamp | 29,6 | √ | null | Date this individual was last contacted | |
ad_housekeeping | lastrun | timestamp | 29,6 | √ | null | Last Run | |
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_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_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_process_para | columnname | varchar | 30 | Name of the column in the database | |||
ad_workflow | documentno | varchar | 30 | √ | null | Document sequence number of the document | |
ad_issue | requestdocumentno | varchar | 30 | √ | null | iDempiere Request Document No | |
ad_broadcastmessage | broadcasttype | varchar | 32 | NULL::character varying | Type of Broadcast | ||
ad_scheduler | datelastrun | timestamptz | 35,6 | √ | null | Date the process was last run. | |
ad_scheduler | datenextrun | timestamptz | 35,6 | √ | null | Date the process will run next | |
ad_alert | ad_alert_uu | varchar | 36 | √ | NULL::character varying | AD_Alert_UU | |
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_broadcastmessage | ad_broadcastmessage_uu | varchar | 36 | √ | NULL::character varying | AD_BroadcastMessage_UU | |
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_housekeeping | ad_housekeeping_uu | varchar | 36 | √ | NULL::character varying | AD_HouseKeeping_UU | |
ad_issue | ad_issue_uu | varchar | 36 | √ | NULL::character varying | AD_Issue_UU | |
ad_ldapprocessor | ad_ldapprocessor_uu | varchar | 36 | √ | NULL::character varying | AD_LdapProcessor_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_pinstance_log | ad_pinstance_log_uu | varchar | 36 | √ | null | 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_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_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_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_process | ad_wf_process_uu | varchar | 36 | √ | NULL::character varying | AD_WF_Process_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_workflowprocessorlog | ad_workflowprocessorlog_uu | varchar | 36 | √ | NULL::character varying | AD_WorkflowProcessorLog_UU | |
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 | |
c_acctschema | c_acctschema_uu | varchar | 36 | √ | NULL::character varying | C_AcctSchema_UU | |
exp_processor | exp_processor_uu | varchar | 36 | √ | NULL::character varying | EXP_Processor_UU | |
imp_processor | imp_processor_uu | varchar | 36 | √ | NULL::character varying | IMP_Processor_UU | |
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 | |
ad_pinstance | record_uu | varchar | 36 | √ | NULL::character varying | Record UUID | |
ad_user | emailverify | varchar | 40 | √ | null | Verification information of EMail Address | |
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 | ||
ad_user | fax | varchar | 40 | √ | null | Facsimile number | |
ad_client | loginprefix | varchar | 40 | √ | NULL::character varying | Login Prefix | |
ad_user | phone | varchar | 40 | √ | null | Identifies a telephone number | |
ad_user | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
ad_housekeeping | tablename | varchar | 40 | √ | NULL::character varying | Name of the table in the database | |
ad_table | tablename | varchar | 40 | Name of the table in the database | |||
ad_user | title | varchar | 40 | √ | null | Name this entity is referred to as | |
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_process | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_user | value | varchar | 40 | √ | null | 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_process | workflowvalue | varchar | 40 | √ | null | Key of the Workflow to start | |
ad_user | bpname | varchar | 60 | √ | NULL::character varying | BP Name | |
ad_broadcastmessage | broadcastfrequency | varchar | 60 | NULL::character varying | How Many Times Message Should be Broadcasted | ||
ad_client | documentdir | varchar | 60 | √ | null | Directory for documents from the application server | |
ad_user | varchar | 60 | √ | null | Electronic Mail Address | ||
ad_user | emailuser | varchar | 60 | √ | null | User Name (ID) in the Mail System | |
ad_user | ldapuser | varchar | 60 | √ | null | User Name used for authorization via LDAP (directory) services | |
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_pinstance | name | varchar | 60 | √ | NULL::character varying | 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_pinstance_para | parametername | varchar | 60 | √ | null | Parameter Name | |
ad_process | procedurename | varchar | 60 | √ | null | Name of the Database Procedure | |
ad_alertprocessorlog | reference | varchar | 60 | √ | 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_issue | remote_addr | varchar | 60 | √ | null | Remote Address | |
ad_client | requestemail | varchar | 60 | √ | null | EMail address to send automated mails from or receive mails for automated processing (fully qualified) | |
ad_client | requestuser | varchar | 60 | √ | null | User Name (ID) of the email owner | |
ad_schedule | runonlyonip | varchar | 60 | √ | NULL::character varying | Run only on IP | |
ad_client | smtphost | varchar | 60 | √ | null | Hostname of Mail Server for SMTP and IMAP | |
ad_issue | sourcemethodname | varchar | 60 | √ | null | Source Method Name | |
ad_issue | supportemail | varchar | 60 | √ | null | EMail address to send support information and updates to | |
ad_broadcastmessage | target | varchar | 60 | NULL::character varying | Target tenant | ||
ad_clientinfo | timezone | varchar | 60 | √ | NULL::character varying | Time zone name | |
ad_broadcastmessage | title | varchar | 60 | √ | NULL::character varying | Name this entity is referred to as | |
ad_issue | username | varchar | 60 | User Name | |||
ad_issue | local_host | varchar | 120 | √ | null | Local Host Info | |
ad_issue | remote_host | varchar | 120 | √ | null | Remote host Info | |
ad_schedule | description | varchar | 225 | √ | NULL::character varying | Optional short description of the record | |
exp_processor | account | varchar | 255 | √ | null | Account | |
imp_processor | account | varchar | 255 | √ | null | Account | |
ad_alert | alertsubject | varchar | 255 | Subject of the Alert | |||
ad_housekeeping | backupfolder | varchar | 255 | √ | null | Backup Folder | |
ad_process | classname | varchar | 255 | √ | null | Java Classname | |
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_issue | dbaddress | varchar | 255 | √ | null | JDBC URL of the database server | |
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_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_user | emailuserpw | varchar | 255 | √ | null | Password of your email user id | |
ad_schedulerrecipient | filename | varchar | 255 | √ | NULL::character varying | Name of the local file or URL | |
ad_process | filenamepattern | varchar | 255 | √ | NULL::character varying | File Name Pattern | |
exp_processor | host | varchar | 255 | √ | null | Host | |
imp_processor | host | varchar | 255 | √ | null | Host | |
ad_process | jasperreport | varchar | 255 | √ | null | Jasper Report | |
ad_issue | javainfo | varchar | 255 | √ | null | Java Version Info | |
ad_user | lastresult | varchar | 255 | √ | null | Result of last contact | |
ad_client | ldapquery | varchar | 255 | √ | null | ||
ad_user | leadsourcedescription | varchar | 255 | √ | NULL::character varying | Additional information on the source of this lead/opportunity | |
ad_user | leadstatusdescription | varchar | 255 | √ | NULL::character varying | Additional information on the status of this lead/opportunity | |
ad_issue | loggername | varchar | 255 | √ | null | Logger Name | |
ad_client | modelvalidationclasses | varchar | 255 | √ | null | List of data model validation classes separated by ; | |
ad_issue | operatingsysteminfo | varchar | 255 | √ | null | Operating System Info | |
ad_scheduler_para | parameterdefault | varchar | 255 | √ | null | Default value of the parameter | |
ad_scheduler_para | parametertodefault | varchar | 255 | √ | NULL::character varying | Default value of the to parameter | |
exp_processor | passwordinfo | varchar | 255 | √ | null | Password Info | |
imp_processor | passwordinfo | varchar | 255 | √ | null | Password Info | |
ad_process_para | placeholder | varchar | 255 | √ | NULL::character varying | Placeholder | |
ad_process_para | placeholder2 | varchar | 255 | √ | NULL::character varying | Placeholder2 | |
ad_note | reference | varchar | 255 | √ | null | Reference for this record | |
ad_client | requestuserpw | varchar | 255 | √ | null | Password of the user name (ID) for mail processing | |
ad_issue | sourceclassname | varchar | 255 | √ | null | Source Class Name | |
ad_issue | statisticsinfo | varchar | 255 | √ | null | Information to help profiling the system for solving support issues | |
ad_client | unixarchivepath | varchar | 255 | √ | null | Unix Archive Path | |
ad_client | unixattachmentpath | varchar | 255 | √ | null | Unix Attachment Path | |
ad_message | value | varchar | 255 | Search key for the record in the format required - must be unique | |||
ad_process_para | vformat | varchar | 255 | √ | null | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
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_user | answer | varchar | 1024 | √ | NULL::character varying | Answer | |
ad_user | password | varchar | 1024 | √ | null | Password of any length (case sensitive) | |
ad_user | securityquestion | varchar | 1024 | √ | null | Security Question | |
ad_alert | alertmessage | varchar | 2000 | Message of the Alert | |||
ad_issue | comments | varchar | 2000 | √ | null | Comments or additional information | |
ad_user | comments | varchar | 2000 | √ | null | Comments or additional information | |
ad_process_para | defaultvalue | varchar | 2000 | √ | null | Default value hierarchy, separated by ; | |
ad_process_para | defaultvalue2 | varchar | 2000 | √ | null | Default value hierarchy, separated by ; | |
ad_process_para | displaylogic | varchar | 2000 | √ | null | If the Field is displayed, the result determines if the field is actually displayed | |
ad_workflow | docvaluelogic | varchar | 2000 | √ | null | Logic to determine Workflow Start - If true, a workflow process is started for the document | |
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_alertrule | fromclause | varchar | 2000 | SQL FROM clause | |||
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 | |
exp_processor | help | varchar | 2000 | √ | null | Comment or Hint | |
imp_processor | help | varchar | 2000 | √ | null | Comment or Hint | |
ad_issue | issuesummary | varchar | 2000 | Issue Summary | |||
ad_process_para | mandatorylogic | varchar | 2000 | √ | NULL::character varying | Mandatory Logic | |
ad_message | msgtext | varchar | 2000 | Textual Informational, Menu or Error Message | |||
ad_message | msgtip | varchar | 2000 | √ | null | Additional tip or help for this message | |
ad_alertrule | otherclause | varchar | 2000 | √ | null | Other SQL Clause | |
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_process_para | query | varchar | 2000 | √ | NULL::character varying | SQL | |
ad_process_para | readonlylogic | varchar | 2000 | √ | null | Logic to determine if field is read only (applies only when field is read-write) | |
ad_issue | responsetext | varchar | 2000 | √ | null | Request Response Text | |
ad_alertrule | selectclause | varchar | 2000 | SQL SELECT clause | |||
ad_issue | stacktrace | varchar | 2000 | √ | null | System Log Trace | |
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_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_alertrule | whereclause | varchar | 2000 | √ | null | Fully qualified SQL WHERE clause | |
ad_pinstance_para | info | varchar | 4000 | √ | null | Information | |
ad_pinstance_para | info_to | varchar | 4000 | √ | null | Info To | |
ad_pinstance_log | p_msg | varchar | 4000 | √ | null | Process Message | |
ad_pinstance_para | p_string | varchar | 4000 | √ | null | Process Parameter | |
ad_pinstance_para | p_string_to | varchar | 4000 | √ | null | Process Parameter | |
ad_role | predefinedcontextvariables | varchar | 4000 | √ | NULL::character varying | Predefined context variables to inject when opening a menu entry or a window | |
ad_issue | profileinfo | varchar | 4000 | √ | null | Information to help profiling the system for solving support issues | |
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_broadcastmessage | broadcastmessage | text | 2147483647 | Broadcast Message | |||
ad_workflow | help | text | 2147483647 | √ | null | Comment or Hint |