www.element4solution.com

Package e4s.db.systabledef

This package contains definitions for system database tables.

See:
          Description

Interface Summary
E4Permission_Intf This interface enables simple permissions (E4Permission) to be combined with an OR operator or and AND operator, meaning that either one or all permissions must be set valid.
 

Class Summary
E4ClientLogo Data access for E4ClientLogo: Image (Company Logo) for Client.
E4CompanyGroup Data access for E4CompanyGroup: Company Group.
E4CompanyId Data access for E4CompanyId created: 20041222 105414 modified: 20070104 212859
E4CompanyUserId Data access for E4CompanyUserId: User login name, unique identification for the user in the login process.
E4DecimalSign Data access for E4DecimalSign: Definition for Decimal Sign, related to Client/User.
E4DefaultTables Retrieve data for some system tables.
E4FreeFieldDisplayMode Data access for E4FreeFieldDisplayMode.
E4Gender Data access for E4Gender created: 20081123 162357 modified: 20081123 162432
E4HintID Data access for E4HintID.
E4Image Data access for E4Image: General Image type.
E4OverviewGroup Data access for E4OverviewGroup: Overview ID.
E4Permission Data access for E4Permission.
E4PermissionAnd Special case for an permission: this object holds one ore many simple permissions that must all be valid.
E4PermissionOr Special case for an permission: this object holds one ore many simple permissions that might either be valid.
E4TranslationDataID Data access for E4TranslationDataID: Identification for an data translation item in table T_E4S_TRANS_DATA.
T_E4S_CLIENT_Mod SQL modifications for T_E4S_CLIENT: This table hold the core client information, which is the fundament for all subsequent client distinctions.
T_E4S_CLIENT_Obj Data access object for T_E4S_CLIENT created: 20041111 042740 modified: 20071103 125915 This table hold the core client information, which is the fundament for all subsequent client distinctions.
T_E4S_CLIENT_Sel SQL select for T_E4S_CLIENT: This table hold the core client information, which is the fundament for all subsequent client distinctions.
T_E4S_CLIENT_Sel.T_E4S_CLIENT_And Filter to be used as AND condition.
T_E4S_CLIENT_Sel.T_E4S_CLIENT_Or Filter to be used as OR condition.
T_E4S_CLIENT_VAL_Mod SQL modifications for T_E4S_CLIENT_VAL: General system values associated by a client, equal for all users or sessions of that client.
T_E4S_CLIENT_VAL_Obj Data access object for T_E4S_CLIENT_VAL created: 20050702 163540 modified: 20071103 125941 General system values associated by a client, equal for all users or sessions of that client.
T_E4S_CLIENT_VAL_Sel SQL select for T_E4S_CLIENT_VAL: General system values associated by a client, equal for all users or sessions of that client.
T_E4S_CLIENT_VAL_Sel.T_E4S_CLIENT_VAL_And Filter to be used as AND condition.
T_E4S_CLIENT_VAL_Sel.T_E4S_CLIENT_VAL_Or Filter to be used as OR condition.
T_E4S_COMPANY_GROUP_Mod SQL modifications for T_E4S_COMPANY_GROUP: Structure above the T_E4S_COMPANY: Classification of the company group (client dependent).
T_E4S_COMPANY_GROUP_Obj Data access object for T_E4S_COMPANY_GROUP created: 20041222 110156 modified: 20081119 095929 Structure above the T_E4S_COMPANY: Classification of the company group (client dependent)
T_E4S_COMPANY_GROUP_Sel SQL select for T_E4S_COMPANY_GROUP: Structure above the T_E4S_COMPANY: Classification of the company group (client dependent).
T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_And Filter to be used as AND condition.
T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_Or Filter to be used as OR condition.
T_E4S_COMPANY_Mod SQL modifications for T_E4S_COMPANY: Hold Information about companies, users are related to companies.
T_E4S_COMPANY_Obj Data access object for T_E4S_COMPANY created: 20041222 105625 modified: 20071108 105117 Hold Information about companies, users are related to companies.
T_E4S_COMPANY_Sel SQL select for T_E4S_COMPANY: Hold Information about companies, users are related to companies.
T_E4S_COMPANY_Sel.T_E4S_COMPANY_And Filter to be used as AND condition.
T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or Filter to be used as OR condition.
T_E4S_COMPANY_USER_Mod SQL modifications for T_E4S_COMPANY_USER: Users related to companies, here you will find login information of users and personal settings such as date formats.
T_E4S_COMPANY_USER_Obj Data access object for T_E4S_COMPANY_USER created: 20041222 110445 modified: 20081113 152745 Users related to companies, here you will find login information of users and personal settings such as date formats.
T_E4S_COMPANY_USER_Sel SQL select for T_E4S_COMPANY_USER: Users related to companies, here you will find login information of users and personal settings such as date formats.
T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_And Filter to be used as AND condition.
T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or Filter to be used as OR condition.
T_E4S_COMPANY_Vec Vector to hold access objects for T_E4S_COMPANY created: 20041222 105625 modified: 20071108 105117 Hold Information about companies, users are related to companies.
T_E4S_FREEFIELD_DEF_Mod SQL modifications for T_E4S_FREEFIELD_DEF: Definitions for free fields associated by client/database-table.
T_E4S_FREEFIELD_DEF_Obj Data access object for T_E4S_FREEFIELD_DEF created: 20050627 103040 modified: 20081128 154850 Definitions for free fields associated by client/database-table.
T_E4S_FREEFIELD_DEF_Sel SQL select for T_E4S_FREEFIELD_DEF: Definitions for free fields associated by client/database-table.
T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_And Filter to be used as AND condition.
T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or Filter to be used as OR condition.
T_E4S_FREEFIELD_DEF_Vec Vector to hold access objects for T_E4S_FREEFIELD_DEF created: 20050627 103040 modified: 20081128 154850 Definitions for free fields associated by client/database-table.
T_E4S_FREEFIELD_VAL_Mod SQL modifications for T_E4S_FREEFIELD_VAL: Values of free fields.
T_E4S_FREEFIELD_VAL_Obj Data access object for T_E4S_FREEFIELD_VAL created: 20050627 103740 modified: 20100318 114441 Values of free fields
T_E4S_FREEFIELD_VAL_Sel SQL select for T_E4S_FREEFIELD_VAL: Values of free fields.
T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_And Filter to be used as AND condition.
T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or Filter to be used as OR condition.
T_E4S_HINT_Mod SQL modifications for T_E4S_HINT: A hint is a text that will be displayed once for each user.
T_E4S_HINT_Obj Data access object for T_E4S_HINT created: 20090121 153203 modified: 20090121 192318 A hint is a text that will be displayed once for each user.
T_E4S_HINT_READ_Mod SQL modifications for T_E4S_HINT_READ: Contains information about users having allready read a hint.
T_E4S_HINT_READ_Obj Data access object for T_E4S_HINT_READ created: 20090121 153552 modified: 20090121 192433 Contains information about users having allready read a hint
T_E4S_HINT_READ_Sel SQL select for T_E4S_HINT_READ: Contains information about users having allready read a hint.
T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_And Filter to be used as AND condition.
T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_Or Filter to be used as OR condition.
T_E4S_HINT_Sel SQL select for T_E4S_HINT: A hint is a text that will be displayed once for each user.
T_E4S_HINT_Sel.T_E4S_HINT_And Filter to be used as AND condition.
T_E4S_HINT_Sel.T_E4S_HINT_Or Filter to be used as OR condition.
T_E4S_LOGIN_HISTORY_Mod SQL modifications for T_E4S_LOGIN_HISTORY: Login History.
T_E4S_LOGIN_HISTORY_Obj Data access object for T_E4S_LOGIN_HISTORY created: 20050408 025943 modified: 20080211 135626 Login History.
T_E4S_LOGIN_HISTORY_Sel SQL select for T_E4S_LOGIN_HISTORY: Login History.
T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_And Filter to be used as AND condition.
T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_Or Filter to be used as OR condition.
T_E4S_MAIL_SENT_Mod SQL modifications for T_E4S_MAIL_SENT: Logging of sent eMails by the E4S mail implementation.
T_E4S_MAIL_SENT_Obj Data access object for T_E4S_MAIL_SENT created: 20051005 115548 modified: 20071103 130220 Logging of sent eMails by the E4S mail implementation.
T_E4S_MAIL_SENT_Sel SQL select for T_E4S_MAIL_SENT: Logging of sent eMails by the E4S mail implementation.
T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_And Filter to be used as AND condition.
T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or Filter to be used as OR condition.
T_E4S_OVERVIEW_Mod SQL modifications for T_E4S_OVERVIEW: Overview - includes information about the project and functionality.
T_E4S_OVERVIEW_Obj Data access object for T_E4S_OVERVIEW created: 20050214 013049 modified: 20080318 185617 Overview - includes information about the project and functionality
T_E4S_OVERVIEW_Sel SQL select for T_E4S_OVERVIEW: Overview - includes information about the project and functionality.
T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_And Filter to be used as AND condition.
T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_Or Filter to be used as OR condition.
T_E4S_PERMISSION_COMPANY_Mod SQL modifications for T_E4S_PERMISSION_COMPANY: Permission on Company level.
T_E4S_PERMISSION_COMPANY_Obj Data access object for T_E4S_PERMISSION_COMPANY created: 20050616 100706 modified: 20071103 125622 Permission on Company level.
T_E4S_PERMISSION_COMPANY_Sel SQL select for T_E4S_PERMISSION_COMPANY: Permission on Company level.
T_E4S_PERMISSION_COMPANY_Sel.T_E4S_PERMISSION_COMPANY_And Filter to be used as AND condition.
T_E4S_PERMISSION_COMPANY_Sel.T_E4S_PERMISSION_COMPANY_Or Filter to be used as OR condition.
T_E4S_PERMISSION_GROUP_Mod SQL modifications for T_E4S_PERMISSION_GROUP: Permission on Group level.
T_E4S_PERMISSION_GROUP_Obj Data access object for T_E4S_PERMISSION_GROUP created: 20050616 100526 modified: 20071103 125436 Permission on Group level.
T_E4S_PERMISSION_GROUP_Sel SQL select for T_E4S_PERMISSION_GROUP: Permission on Group level.
T_E4S_PERMISSION_GROUP_Sel.T_E4S_PERMISSION_GROUP_And Filter to be used as AND condition.
T_E4S_PERMISSION_GROUP_Sel.T_E4S_PERMISSION_GROUP_Or Filter to be used as OR condition.
T_E4S_PERMISSION_USER_Mod SQL modifications for T_E4S_PERMISSION_USER: Permission on User level.
T_E4S_PERMISSION_USER_Obj Data access object for T_E4S_PERMISSION_USER created: 20050616 100303 modified: 20071103 125505 Permission on User level.
T_E4S_PERMISSION_USER_Sel SQL select for T_E4S_PERMISSION_USER: Permission on User level.
T_E4S_PERMISSION_USER_Sel.T_E4S_PERMISSION_USER_And Filter to be used as AND condition.
T_E4S_PERMISSION_USER_Sel.T_E4S_PERMISSION_USER_Or Filter to be used as OR condition.
T_E4S_QUERY_CLIENTS_Mod SQL modifications for T_E4S_QUERY_CLIENTS.
T_E4S_QUERY_CLIENTS_Obj Data access object for T_E4S_QUERY_CLIENTS created: 20071109 125856 modified: 20071109 130042
T_E4S_QUERY_CLIENTS_Sel SQL select for T_E4S_QUERY_CLIENTS.
T_E4S_QUERY_CLIENTS_Sel.T_E4S_QUERY_CLIENTS_And Filter to be used as AND condition.
T_E4S_QUERY_CLIENTS_Sel.T_E4S_QUERY_CLIENTS_Or Filter to be used as OR condition.
T_E4S_QUERY_Mod SQL modifications for T_E4S_QUERY: Predefines a SQL statement that can be used as dynamic user query/report.
T_E4S_QUERY_Obj Data access object for T_E4S_QUERY created: 20060328 142853 modified: 20071109 130448 Predefines a SQL statement that can be used as dynamic user query/report.
T_E4S_QUERY_PARAMS_Mod SQL modifications for T_E4S_QUERY_PARAMS: Saves query parameters for the user.
T_E4S_QUERY_PARAMS_Obj Data access object for T_E4S_QUERY_PARAMS created: 20060329 091105 modified: 20070104 161036 Saves query parameters for the user
T_E4S_QUERY_PARAMS_Sel SQL select for T_E4S_QUERY_PARAMS: Saves query parameters for the user.
T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_And Filter to be used as AND condition.
T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_Or Filter to be used as OR condition.
T_E4S_QUERY_Sel SQL select for T_E4S_QUERY: Predefines a SQL statement that can be used as dynamic user query/report.
T_E4S_QUERY_Sel.T_E4S_QUERY_And Filter to be used as AND condition.
T_E4S_QUERY_Sel.T_E4S_QUERY_Or Filter to be used as OR condition.
T_E4S_TRANS_APP_Mod SQL modifications for T_E4S_TRANS_APP: Application translations (this are all user interface text elements that are used within your application).
T_E4S_TRANS_APP_Obj Data access object for T_E4S_TRANS_APP created: 20050218 115525 modified: 20071103 125846 Application translations (this are all user interface text elements that are used within your application).
T_E4S_TRANS_APP_Sel SQL select for T_E4S_TRANS_APP: Application translations (this are all user interface text elements that are used within your application).
T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_And Filter to be used as AND condition.
T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_Or Filter to be used as OR condition.
T_E4S_TRANS_DATA_Mod SQL modifications for T_E4S_TRANS_DATA: Translations for data related items (such as designations, ...).
T_E4S_TRANS_DATA_Obj Data access object for T_E4S_TRANS_DATA created: 20060416 094849 modified: 20070104 161055 Translations for data related items (such as designations, ...)
T_E4S_TRANS_DATA_Sel SQL select for T_E4S_TRANS_DATA: Translations for data related items (such as designations, ...).
T_E4S_TRANS_DATA_Sel.T_E4S_TRANS_DATA_And Filter to be used as AND condition.
T_E4S_TRANS_DATA_Sel.T_E4S_TRANS_DATA_Or Filter to be used as OR condition.
T_E4S_TRANS_SYS_Mod SQL modifications for T_E4S_TRANS_SYS: System translations (this are all user interface text elements that are used within E4S but not in an application).
T_E4S_TRANS_SYS_Obj Data access object for T_E4S_TRANS_SYS created: 20050218 115326 modified: 20071103 125801 System translations (this are all user interface text elements that are used within E4S but not in an application).
T_E4S_TRANS_SYS_Sel SQL select for T_E4S_TRANS_SYS: System translations (this are all user interface text elements that are used within E4S but not in an application).
T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_And Filter to be used as AND condition.
T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_Or Filter to be used as OR condition.
T_E4S_USER_VAL_Mod SQL modifications for T_E4S_USER_VAL: Stores values related to the user.
T_E4S_USER_VAL_Obj Data access object for T_E4S_USER_VAL created: 20051228 115016 modified: 20070104 163941 Stores values related to the user
T_E4S_USER_VAL_Sel SQL select for T_E4S_USER_VAL: Stores values related to the user.
T_E4S_USER_VAL_Sel.T_E4S_USER_VAL_And Filter to be used as AND condition.
T_E4S_USER_VAL_Sel.T_E4S_USER_VAL_Or Filter to be used as OR condition.
V_E4S_USERS_Sel SQL select for V_E4S_USERS.
 

Exception Summary
E4PermissionException Exception type for permissions.
 

Package e4s.db.systabledef Description

This package contains definitions for system database tables.


www.element4solution.com