Apicosoft

ERP iScala Database Structure

iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
sca_AddFeature sca_AddFeature0000
sca_CalGetNextDate sca_CalGetNextDate sca_CalGetNextDate0000
sca_CheckAttachmentsExist CheckAttachmentsExist sca_CheckAttachmentsExist0000
sca_CompanyCopy sca_CompanyCopy sca_CompanyCopy0000
sca_CreateCollationDictionary Creates and fills ScaCollationDictionary table sca_CreateCollationDictionary0000
sca_CreateCollationUpperMapping Creates and fills ScaCollationUpperMapping table. sca_CreateCollationUpperMapping0000
sca_CreateIndexes sca_CreateIndexes sca_CreateIndexes0000
sca_DeleteAttachment DeleteAttachment sca_DeleteAttachment0000
sca_DeleteCompanyBase sca_DeleteCompanyBase0000
sca_DeleteFeature sca_DeleteFeature0000
sca_DeleteFinYear sca_DeleteFinYear0000
sca_DeleteTempObjects Deletes logon session-specific tables and views sca_DeleteTempObjects0000
sca_EditCompanyDimension sca_EditCompanyDimension0000
sca_GetAllAttachments GetAllAttachments sca_GetAllAttachments0000
sca_GetAttachmentByID GetAttachmentByID sca_GetAttachmentByID0000
sca_GetAttachmentData sca_GetAttachmentData sca_GetAttachmentData0000
sca_GetAttachmentsEx GetAttachments using Collation sca_GetAttachmentsEx0000
sca_GetCompanyDimensions sca_GetCompanyDimensions0000
sca_GetCompanyDimensionsDescr sca_GetCompanyDimensionsDescr0000
sca_GetCompanyFYears sca_GetCompanyFYears0000
sca_GetCompanyProperty sca_GetCompanyProperty sca_GetCompanyProperty0000
sca_GetCompanyYearProperty sca_GetCompanyYearProperty sca_GetCompanyYearProperty0000
sca_GetTimePart sca_GetTimePart sca_GetTimePart0000
SCA_IND_COLUMNS SCALA Indexes SCA_IND_COLUMNS0000
sca_IndexRebuild nnn sca_IndexRebuild0000
sca_PutCompanyProperty sca_PutCompanyProperty sca_PutCompanyProperty0000
sca_PutCompanyYearProperty sca_PutCompanyYearProperty sca_PutCompanyYearProperty0000
sca_RemoveCompanyDimension sca_RemoveCompanyDimension0000
sca_SetAttachment SetAttachment sca_SetAttachment0000
sca_SetAttachmentCheckStatus SetAttachmentCheckStatus sca_SetAttachmentCheckStatus0000
sca_SetAttachmentData SetAttachmentData sca_SetAttachmentData0000
SCA_TAB_COLUMNS SCALA Columns SCA_TAB_COLUMNS0000
sca_TableDataCopy sca_TableDataCopy sca_TableDataCopy0000
ScaAttachments ScaAttachments0000
ScaCompanies Companies ScaCompanies0000
ScaCompanyAuditColumns Audit settings for columns ScaCompanyAuditColumns0000
ScaCompanyAuditSettings Company Audit Settings ScaCompanyAuditSettings0000
ScaCompanyAuditTables Audit settings for tables in the company ScaCompanyAuditTables0000
ScaCompanyFeature Company Features ScaCompanyFeature0000
ScaCompanyNews Company News ScaCompanyNews0000
ScaCompanyProperty Company Properties ScaCompanyProperty0000
ScaCompanySegment Accounting Dimension Definition ScaCompanySegment0000
ScaCompanySegmentDescr Accounting Dimension Names ScaCompanySegmentDescr0000
ScaCompanyYear Company Years ScaCompanyYear0000
ScaCompanyYearProperties Company Year Properties ScaCompanyYearProperties0000
ScaDBVersion Current DB version ScaDBVersion0000
ScaE4SEClosedTrans ScaE4SEClosedTrans0000
ScaIndexRebuildLog Index Rebuild Log ScaIndexRebuildLog0000
ScaUserDBConnection UserDB Connections ScaUserDBConnection0000
SOBJ ForMA SOBJ0000
SOBJMAVIEW ForMAView SOBJMAVIEW0000
System-CK_ScaAllDBObjects_Names System-CK_ScaAllDBObjects_Names0000
System-CK_ScaAllDBObjects_RefObjectID System-CK_ScaAllDBObjects_RefObjectID0000
System-CK_ScaAllDBObjects_SupportsAudit System-CK_ScaAllDBObjects_SupportsAudit0000
System-CK_ScaLifeCycleTables_Direction System-CK_ScaLifeCycleTables_Direction0000
System-CK_ScaLifeCycleTables_TableType System-CK_ScaLifeCycleTables_TableType0000
System-CK_ScaLifeCycleTables_TurnOn System-CK_ScaLifeCycleTables_TurnOn0000
System-DF_ScaActions_Reauthentication System-DF_ScaActions_Reauthentication0000
System-DF_ScaActions_Type System-DF_ScaActions_Type0000
System-DF_ScaAllDBObjects_SupportsAudit System-DF_ScaAllDBObjects_SupportsAudit0000
System-DF_ScaColumns_SupportsAudit System-DF_ScaColumns_SupportsAudit0000
System-DF_ScaCustomerPlugInCompanies_IsAllYear System-DF_ScaCustomerPlugInCompanies_IsAllYear0000
System-DF_ScaCustomerPlugIns_IsAllCompany System-DF_ScaCustomerPlugIns_IsAllCompany0000
System-DF_ScaCustomerPlugIns_IsEnabled System-DF_ScaCustomerPlugIns_IsEnabled0000
System-DF_ScaDBObjects_SupportsAudit System-DF_ScaDBObjects_SupportsAudit0000
System-DF_ScaDESServers_FailCount System-DF_ScaDESServers_FailCount0000
System-DF_ScaJobRequests_RaisedTime System-DF_ScaJobRequests_RaisedTime0000
System-DF_ScaJobRequestsHistory System-DF_ScaJobRequestsHistory0000
System-DF_ScaLifeCycle_TableType System-DF_ScaLifeCycle_TableType0000
System-DF_ScaLifeCycle_TurnOn System-DF_ScaLifeCycle_TurnOn0000
System-DF_ScaMenus_OrderID System-DF_ScaMenus_OrderID0000
System-DF_ScaWebServices_Cfg System-DF_ScaWebServices_Cfg0000
System-DF_WFRequestQueue_NewWorkflow System-DF_WFRequestQueue_NewWorkflow0000
System-DF_WFRequestStatus_Status System-DF_WFRequestStatus_Status0000
System-sca_AddCompany CompanyName parameter's length should be 255 System-sca_AddCompany0000
System-sca_AddEntryTypeBinding System-sca_AddEntryTypeBinding0000
System-sca_AddInstallationHistory System-sca_AddInstallationHistory0000
System-sca_AddJoinConditions System-sca_AddJoinConditions0000
System-sca_AddOrgnode System-sca_AddOrgnode0000
System-sca_AddQueryColHeader System-sca_AddQueryColHeader0000
System-sca_AddQueryColumns System-sca_AddQueryColumns0000
System-sca_AddQueryConditions System-sca_AddQueryConditions0000
System-sca_AddQueryDescription System-sca_AddQueryDescription0000
System-sca_AddQueryParamNames System-sca_AddQueryParamNames0000
System-sca_AddQueryParams System-sca_AddQueryParams0000
System-sca_AddQueryTableExclusions System-sca_AddQueryTableExclusions0000
System-sca_AddQueryTables System-sca_AddQueryTables0000
System-sca_AddRole System-sca_AddRole0000
System-sca_AddTaskAssignment System-sca_AddTaskAssignment0000
System-sca_AddUserQuery System-sca_AddUserQuery0000
System-sca_AddVbaProject System-sca_AddVbaProject0000
System-sca_AssignExistingTask System-sca_AssignExistingTask0000
System-sca_AssignNewTask System-sca_AssignNewTask0000
System-sca_ChangeVbaProjectStatus System-sca_ChangeVbaProjectStatus0000
System-sca_CheckAlias System-sca_CheckAlias0000
System-sca_CheckAttachmentGroupBound Checks existance of attachment group bindings for the list of querySetIDs System-sca_CheckAttachmentGroupBound0000
System-sca_CheckTaskSrvObjects System-sca_CheckTaskSrvObjects0000
System-sca_CheckUser System-sca_CheckUser0000
System-sca_CloseTask System-sca_CloseTask0000
System-sca_CompletedTaskCleanup System-sca_CompletedTaskCleanup0000
System-sca_CompleteTask System-sca_CompleteTask0000
System-sca_CreateScriptedObject Generates creation script based on scripted object definition substituting company and year masks System-sca_CreateScriptedObject0000
System-sca_CreateTable System-sca_CreateTable0000
System-sca_CreateTableIndexes System-sca_CreateTableIndexes0000
System-sca_CreateTextScript System-sca_CreateTextScript0000
System-sca_DeleteAssignedTask task's attributes are deleted before task deletion System-sca_DeleteAssignedTask0000
System-sca_DeleteAttachmentGroup DeleteAttachmentGroup System-sca_DeleteAttachmentGroup0000
System-sca_DeleteCompany System-sca_DeleteCompany0000
System-sca_DeleteCompletedTask task's attributes are archived and deleted before task deletion System-sca_DeleteCompletedTask0000
System-sca_DeleteEntryTypeBinding System-sca_DeleteEntryTypeBinding0000
System-sca_DeleteFinYear Deletes the specified financial year from the specified company System-sca_DeleteFinYear0000
System-sca_DeleteOrgnode System-sca_DeleteOrgnode0000
System-sca_DeletePlugin Delete Customer Business Object Plugin System-sca_DeletePlugin0000
System-sca_DeletePluginCompanyYears Delete Customer Business Object Plugin Company/Year Info System-sca_DeletePluginCompanyYears0000
System-sca_DeleteProject System-sca_DeleteProject0000
System-sca_DeleteQuery Deletes query by their id specified System-sca_DeleteQuery0000
System-sca_DeleteQueryColumns System-sca_DeleteQueryColumns0000
System-sca_DeleteQueryParams System-sca_DeleteQueryParams0000
System-sca_DeleteQueryTableExclusions System-sca_DeleteQueryTableExclusions0000
System-sca_DeleteQueryTables System-sca_DeleteQueryTables0000
System-sca_DeleteRole System-sca_DeleteRole0000
System-sca_DeleteUser System-sca_DeleteUser0000
System-sca_DeleteUserMenu System-sca_DeleteUserMenu0000
System-sca_DeleteVbaProject System-sca_DeleteVbaProject0000
System-sca_DependentObjectsList System-sca_DependentObjectsList0000
System-sca_DESMessageActions_AddItem System-sca_DESMessageActions_AddItem0000
System-sca_DESMessageActions_Delete System-sca_DESMessageActions_Delete0000
System-sca_DESMessageActions_DeleteOne System-sca_DESMessageActions_DeleteOne0000
System-sca_DESMessageActions_Select System-sca_DESMessageActions_Select0000
System-sca_DESMessageActions_UpdateOne System-sca_DESMessageActions_UpdateOne0000
System-sca_DESMessageMap_Delete System-sca_DESMessageMap_Delete0000
System-sca_DESMessageMap_Insert System-sca_DESMessageMap_Insert0000
System-sca_DESMessageMap_Select System-sca_DESMessageMap_Select0000
System-sca_DESMessageMap_Select2 System-sca_DESMessageMap_Select20000
System-sca_DESMessageMap_SelectByKey System-sca_DESMessageMap_SelectByKey0000
System-sca_DESMessageMap_SelectMsg System-sca_DESMessageMap_SelectMsg0000
System-sca_DESMessageMap_SelectSnd System-sca_DESMessageMap_SelectSnd0000
System-sca_DESMessageMap_Update System-sca_DESMessageMap_Update0000
System-sca_DESMessageSenderNames_Delete System-sca_DESMessageSenderNames_Delete0000
System-sca_DESMessageSenderNames_InsertName System-sca_DESMessageSenderNames_InsertName0000
System-sca_DESMessageSenderNames_Select System-sca_DESMessageSenderNames_Select0000
System-sca_DESMessageSenderNames_UpdateName System-sca_DESMessageSenderNames_UpdateName0000
System-sca_DESMessageSenderSubNames_AddItem System-sca_DESMessageSenderSubNames_AddItem0000
System-sca_DESMessageSenderSubNames_Delete System-sca_DESMessageSenderSubNames_Delete0000
System-sca_DESMessageSenderSubNames_DeleteOne System-sca_DESMessageSenderSubNames_DeleteOne0000
System-sca_DESMessageSenderSubNames_Select System-sca_DESMessageSenderSubNames_Select0000
System-sca_DESMessageSenderSubNames_UpdateOne System-sca_DESMessageSenderSubNames_UpdateOne0000
System-sca_DESMessageTypes_Delete System-sca_DESMessageTypes_Delete0000
System-sca_DESMessageTypes_InsertName System-sca_DESMessageTypes_InsertName0000
System-sca_DESMessageTypes_Select System-sca_DESMessageTypes_Select0000
System-sca_DESMessageTypes_UpdateName System-sca_DESMessageTypes_UpdateName0000
System-sca_DESMessageTypesActions_PrepareForMap System-sca_DESMessageTypesActions_PrepareForMap0000
System-sca_DropObjectScript System-sca_DropObjectScript0000
System-sca_DTChangeProcessContext System-sca_DTChangeProcessContext0000
System-sca_DTDeleteProcessFromArchive Deletes document tracking processes from archive tables System-sca_DTDeleteProcessFromArchive0000
System-sca_DTDeleteProcessFromWorkingTables System-sca_DTDeleteProcessFromWorkingTables0000
System-sca_DTDeleteSearchResultView System-sca_DTDeleteSearchResultView0000
System-sca_DTGetProcessAsTree Get trace as tree System-sca_DTGetProcessAsTree0000
System-sca_DTGetProcessFromArchAsTree Get archived trace as tree System-sca_DTGetProcessFromArchAsTree0000
System-sca_DTMoveProcessToArchive The procedure moves the records from working tables to archive tables System-sca_DTMoveProcessToArchive0000
System-sca_DTSaveSearchResultView System-sca_DTSaveSearchResultView0000
System-sca_EventAdmin_MoveBusinessEventToHistory System-sca_EventAdmin_MoveBusinessEventToHistory0000
System-sca_EventAdmin_SelectEventToBeProceededImpersonateUser System-sca_EventAdmin_SelectEventToBeProceededImpersonateUser0000
System-sca_EventAdmin_SelectEventToBeProceededNotImpersonateUser Returns business events waiting to be processed System-sca_EventAdmin_SelectEventToBeProceededNotImpersonateUser0000
System-sca_EventAdmin_UpdateState System-sca_EventAdmin_UpdateState0000
System-sca_FnGetObjectNamesList Builds real object names from specified one using years and company codes substitution System-sca_FnGetObjectNamesList0000
System-sca_FnGetOrgnodeParents Returns orgnode parents System-sca_FnGetOrgnodeParents0000
System-sca_FnGetSecurityItemParents Returns parent of security item System-sca_FnGetSecurityItemParents0000
System-sca_FuncReportUnwindAddonsAndPermissions Effective Functionality report preparation System-sca_FuncReportUnwindAddonsAndPermissions0000
System-sca_GetActionsMenu System-sca_GetActionsMenu0000
System-sca_GetAllFieldAssociations System-sca_GetAllFieldAssociations0000
System-sca_GetAllLangUserMenu System-sca_GetAllLangUserMenu0000
System-sca_GetAllQueryDescriptions System-sca_GetAllQueryDescriptions0000
System-sca_GetAllUserPermissions sca_GetAllUserPermissions System-sca_GetAllUserPermissions0000
System-sca_GetAssignedTaskGroups System-sca_GetAssignedTaskGroups0000
System-sca_GetAssignedTaskUsers System-sca_GetAssignedTaskUsers0000
System-sca_GetBizParameter Provides lists of Business Documents, Business Event Objects and associated Actions System-sca_GetBizParameter0000
System-sca_GetBusinessLinks Gets business links for specified table System-sca_GetBusinessLinks0000
System-sca_GetColHeaders System-sca_GetColHeaders0000
System-sca_GetColHeadersByQueryID System-sca_GetColHeadersByQueryID0000
System-sca_GetColumnType sca_GetColumnType System-sca_GetColumnType0000
System-sca_GetCompany System-sca_GetCompany0000
System-sca_GetCompanyFYears System-sca_GetCompanyFYears0000
System-sca_GetCompanyList System-sca_GetCompanyList0000
System-sca_GetCompletedTasksGroups System-sca_GetCompletedTasksGroups0000
System-sca_GetCompletedTasksUsers System-sca_GetCompletedTasksUsers0000
System-sca_GetConstraintsScript System-sca_GetConstraintsScript0000
System-sca_GetCorrelationParams System-sca_GetCorrelationParams0000
System-sca_GetCreateTableScript Returns script for table creation System-sca_GetCreateTableScript0000
System-sca_GetEntryTypeBindings System-sca_GetEntryTypeBindings0000
System-sca_GetFeatureList Retrieves the list of database features System-sca_GetFeatureList0000
System-sca_GetFuncReport Get Effective Functionality Report for user in company/year based on specified menu System-sca_GetFuncReport0000
System-sca_GetGroupPath System-sca_GetGroupPath0000
System-sca_GetInstallationProperty Retrieves specified installation property optionally applying specified default System-sca_GetInstallationProperty0000
System-sca_GetJoinConditionsByQueryID System-sca_GetJoinConditionsByQueryID0000
System-sca_GetJoinConditionsByTableID System-sca_GetJoinConditionsByTableID0000
System-sca_GetLastInstallationHistory System-sca_GetLastInstallationHistory0000
System-sca_GetMenuList Returns list of all defined menus System-sca_GetMenuList0000
System-sca_GetObjectName System-sca_GetObjectName0000
System-sca_GetObjectNamesList System-sca_GetObjectNamesList0000
System-sca_GetObjectsByFeature System-sca_GetObjectsByFeature0000
System-sca_GetObjectScript System-sca_GetObjectScript0000
System-sca_GetObjectsDependsOn System-sca_GetObjectsDependsOn0000
System-sca_GetObjectsList System-sca_GetObjectsList0000
System-sca_GetOrgnodeChildren System-sca_GetOrgnodeChildren0000
System-sca_GetOrgnodeItemPath System-sca_GetOrgnodeItemPath0000
System-sca_GetOrgnodeList System-sca_GetOrgnodeList0000
System-sca_GetOrgnodesForSecurityItem sca_GetOrgnodesForSecurityItem System-sca_GetOrgnodesForSecurityItem0000
System-sca_GetOrgnodesForSecurityItemEx sca_GetOrgnodesForSecurityItemEx System-sca_GetOrgnodesForSecurityItemEx0000
System-sca_GetOrgnodesSpecialTypes Returns Advanced Payroll Orgnodes types (based on check special permissions set) System-sca_GetOrgnodesSpecialTypes0000
System-sca_GetOrgnodeUserList sca_GetOrgnodeUserList System-sca_GetOrgnodeUserList0000
System-sca_GetPluginCcYy Return Customer Business Object Plugin Company/Year Info in one string System-sca_GetPluginCcYy0000
System-sca_GetPluginCompanyYears Return Companies with Years subscribed on Customer Plugin System-sca_GetPluginCompanyYears0000
System-sca_GetPluginInterfaces Return Plugin Interface Info System-sca_GetPluginInterfaces0000
System-sca_GetPluginProgId Return Customer Business Object Plugin ProgId System-sca_GetPluginProgId0000
System-sca_GetPlugins Return Customer Plugin Info System-sca_GetPlugins0000
System-sca_GetQuery System-sca_GetQuery0000
System-sca_GetQueryColumnsByQueryID System-sca_GetQueryColumnsByQueryID0000
System-sca_GetQueryConditionsByClause System-sca_GetQueryConditionsByClause0000
System-sca_GetQueryConditionsByQueryID System-sca_GetQueryConditionsByQueryID0000
System-sca_GetQueryIdByName System-sca_GetQueryIdByName0000
System-sca_GetQueryList Returns queries according to language code hierarchy and filtring System-sca_GetQueryList0000
System-sca_GetQueryParamNames System-sca_GetQueryParamNames0000
System-sca_GetQueryParamsByQueryID System-sca_GetQueryParamsByQueryID0000
System-sca_GetQueryParamsInfoByQueryID System-sca_GetQueryParamsInfoByQueryID0000
System-sca_GetQueryTableExclusions System-sca_GetQueryTableExclusions0000
System-sca_GetQueryTablesByQueryID System-sca_GetQueryTablesByQueryID0000
System-sca_GetReturnedColumn System-sca_GetReturnedColumn0000
System-sca_GetRole System-sca_GetRole0000
System-sca_GetRoleMenuList Returns list of the menus defined for the roles, assigned to cuurent user, company, year and vertical language dimension System-sca_GetRoleMenuList0000
System-sca_GetRolesForSecurityItemEx sca_GetRolesForSecurityItemEx System-sca_GetRolesForSecurityItemEx0000
System-sca_GetRolesForUserSecurityItemEx Returns all roles where User has rights for SecurityItem or SecurityItem set as available if User is not defined System-sca_GetRolesForUserSecurityItemEx0000
System-sca_GetSecItemParents System-sca_GetSecItemParents0000
System-sca_GetSecurityItemList System-sca_GetSecurityItemList0000
System-sca_GetTableColumns System-sca_GetTableColumns0000
System-sca_GetTableColumnsInfo Provides column information from data dictionary System-sca_GetTableColumnsInfo0000
System-sca_GetUDDBLifeCycle returns tables involved in UDDB life-cycle System-sca_GetUDDBLifeCycle0000
System-sca_GetUserCompanyProperties System-sca_GetUserCompanyProperties0000
System-sca_GetUserCompYearMenuList Retrieves accessible menu list in specified companies and years for specified users System-sca_GetUserCompYearMenuList0000
System-sca_GetUserExlusiveRoles sca_GetUserExlusiveRoles System-sca_GetUserExlusiveRoles0000
System-sca_GetUserInfoEx Accept the list of user filters and returns user properties System-sca_GetUserInfoEx0000
System-sca_GetUserList System-sca_GetUserList0000
System-sca_GetUserMenu System-sca_GetUserMenu0000
System-sca_GetUserOrgnodes sca_GetUserOrgnodes System-sca_GetUserOrgnodes0000
System-sca_GetUserOrgnodesWebPA sca_GetUserOrgnodesWebPA System-sca_GetUserOrgnodesWebPA0000
System-sca_GetUserOrgnodesWebPACompanyYear sca_GetUserOrgnodesWebPACompanyYear System-sca_GetUserOrgnodesWebPACompanyYear0000
System-sca_GetUserPermissions sca_GetUserPermissions System-sca_GetUserPermissions0000
System-sca_GetUserPermissionsByRoleID sca_GetUserPermissionsByRoleID System-sca_GetUserPermissionsByRoleID0000
System-sca_GetUserProperties System-sca_GetUserProperties0000
System-sca_GetUsersSpecialTypes Returns Advanced Payroll Users types (based on check special permissions set) System-sca_GetUsersSpecialTypes0000
System-sca_GetVbaProject Get VBA project(s) with content System-sca_GetVbaProject0000
System-sca_IsMemberOf System-sca_IsMemberOf0000
System-sca_IsMemberOfOrgnode System-sca_IsMemberOfOrgnode0000
System-sca_IsQueryLinkApplicableByRoles Checks for applicability of the validation link to users roles System-sca_IsQueryLinkApplicableByRoles0000
System-sca_ListVbaProjects Get all VBA projects without content System-sca_ListVbaProjects0000
System-sca_LogEvent sca_LogEvent System-sca_LogEvent0000
System-sca_MergeDescriptions System-sca_MergeDescriptions0000
System-sca_PrepareForFunctionalityReport Effective Functionality report preparation System-sca_PrepareForFunctionalityReport0000
System-sca_PrepareUserCompYearMenuList Prepares accessible menu list in specified companies and years for specified users System-sca_PrepareUserCompYearMenuList0000
System-sca_PutBOPlugin Add or Update Customer Business Objects Plugin System-sca_PutBOPlugin0000
System-sca_PutBOPluginComPlusProperty Save Customer Business Object Plugin COM+ Settings System-sca_PutBOPluginComPlusProperty0000
System-sca_PutInstallationProperty System-sca_PutInstallationProperty0000
System-sca_PutPluginCompanyYears Update Customer Business Object Plugin Company/Year Info System-sca_PutPluginCompanyYears0000
System-sca_QueryFieldLinkRemove Removes query link by its link ID System-sca_QueryFieldLinkRemove0000
System-sca_QueryFieldLinkSave Saves the query link System-sca_QueryFieldLinkSave0000
System-sca_QueryFieldLinksDeleteAllForQuery Removes all query links related to query System-sca_QueryFieldLinksDeleteAllForQuery0000
System-sca_QueryFieldLinksDeleteAllForUser Removes all query links related to user System-sca_QueryFieldLinksDeleteAllForUser0000
System-sca_QueryFieldLinksGetList Returns query links according to filter System-sca_QueryFieldLinksGetList0000
System-sca_QueryFieldLinkUpdateActivationSequence Updates activation sequence for the link. System-sca_QueryFieldLinkUpdateActivationSequence0000
System-sca_QueryLinkValidationRolesGetList Returns all validation roles for a link System-sca_QueryLinkValidationRolesGetList0000
System-sca_QueryLinkValidationRolesRemove Removes all validation roles for a link System-sca_QueryLinkValidationRolesRemove0000
System-sca_QueryLinkValidationRolesSave Creates/updates a query link role binding System-sca_QueryLinkValidationRolesSave0000
System-sca_QueryParameterMappingsGetList Returns parameters list for a query link System-sca_QueryParameterMappingsGetList0000
System-sca_QueryParameterMappingsRemove Removes parameters list for a query link System-sca_QueryParameterMappingsRemove0000
System-sca_QueryParameterMappingsSave Creates/updates parameter mapping for the query link System-sca_QueryParameterMappingsSave0000
System-sca_RemoveFieldAssociations System-sca_RemoveFieldAssociations0000
System-sca_Repository_AddDependency System-sca_Repository_AddDependency0000
System-sca_Repository_AddResource System-sca_Repository_AddResource0000
System-sca_Repository_DeleteResource System-sca_Repository_DeleteResource0000
System-sca_Repository_FindResource System-sca_Repository_FindResource0000
System-sca_Repository_GetDependencyList System-sca_Repository_GetDependencyList0000
System-sca_Repository_GetLanguagesForBody System-sca_Repository_GetLanguagesForBody0000
System-sca_Repository_GetResourceBody System-sca_Repository_GetResourceBody0000
System-sca_Repository_GetResourceInfo System-sca_Repository_GetResourceInfo0000
System-sca_Repository_GetResourceList System-sca_Repository_GetResourceList0000
System-sca_Repository_ResetDependencyList System-sca_Repository_ResetDependencyList0000
System-sca_Repository_SetResourceBody System-sca_Repository_SetResourceBody0000
System-sca_RESTDeleteOperation Delete REST Operation System-sca_RESTDeleteOperation0000
System-sca_RESTDeleteReference Delete REST Reference System-sca_RESTDeleteReference0000
System-sca_RESTDeleteResource Delete REST Resource System-sca_RESTDeleteResource0000
System-sca_RESTDeleteResourceGroup Delete REST Resource Group System-sca_RESTDeleteResourceGroup0000
System-sca_RESTUpdateOperation Update REST Operation System-sca_RESTUpdateOperation0000
System-sca_RESTUpdateResource Update REST Resource System-sca_RESTUpdateResource0000
System-sca_RootCompanyCopy System-sca_RootCompanyCopy0000
System-sca_SelectActiveTask System-sca_SelectActiveTask0000
System-sca_SelectTasksForClosing System-sca_SelectTasksForClosing0000
System-sca_SetAttachmentGroup SetAttachmentGroup System-sca_SetAttachmentGroup0000
System-sca_SetAttachmentGroupBinding SetAttachmentGroupBinding System-sca_SetAttachmentGroupBinding0000
System-sca_SetFieldAssociation System-sca_SetFieldAssociation0000
System-sca_SetMenuLangDescr Saves menu or action name for the specified language System-sca_SetMenuLangDescr0000
System-sca_SetPassword System-sca_SetPassword0000
System-sca_SetUserDBConnection System-sca_SetUserDBConnection0000
System-sca_SynchronizationLogClean System-sca_SynchronizationLogClean0000
System-sca_UDDBColumnsAdd System-sca_UDDBColumnsAdd0000
System-sca_UDDBColumnsDelete System-sca_UDDBColumnsDelete0000
System-sca_UDDBColumnsEdit System-sca_UDDBColumnsEdit0000
System-sca_UDDBCopy System-sca_UDDBCopy0000
System-sca_UDDBDictCreate System-sca_UDDBDictCreate0000
System-sca_UDDBDictEdit System-sca_UDDBDictEdit0000
System-sca_UDDBDictRemove System-sca_UDDBDictRemove0000
System-sca_UDDBExpand System-sca_UDDBExpand0000
System-sca_UDDBLinkColumnsAdd System-sca_UDDBLinkColumnsAdd0000
System-sca_UDDBLTCreate System-sca_UDDBLTCreate0000
System-sca_UDDBSchemaExport System-sca_UDDBSchemaExport0000
System-sca_UDDBSerNoUpd System-sca_UDDBSerNoUpd0000
System-sca_UDDBTransferRemove System-sca_UDDBTransferRemove0000
System-sca_UpdateQueryParams update query params System-sca_UpdateQueryParams0000
System-sca_UpdateVbaProject System-sca_UpdateVbaProject0000
System-sca_UsersCopy System-sca_UsersCopy0000
System-sca_ValidateCollation ValidateCollation System-sca_ValidateCollation0000
System-ScaAccessibleFunctionalityReportAddons System-ScaAccessibleFunctionalityReportAddons0000
System-ScaActionDescr System-ScaActionDescr0000
System-ScaActions System-ScaActions0000
System-ScaActionTypes System-ScaActionTypes0000
System-ScaAllDBObjects System-ScaAllDBObjects0000
System-ScaAssignedTasks System-ScaAssignedTasks0000
System-ScaAssignedTasksAttributes ScaAssignedTasksAttributes System-ScaAssignedTasksAttributes0000
System-ScaAssignedTasksGroups System-ScaAssignedTasksGroups0000
System-ScaAssignedTasksUsers System-ScaAssignedTasksUsers0000
System-ScaAttachmentGroupBindings System-ScaAttachmentGroupBindings0000
System-ScaAttachmentGroups System-ScaAttachmentGroups0000
System-ScaBackupRestorePlugins System-ScaBackupRestorePlugins0000
System-ScaBAValuesDerivationRule System-ScaBAValuesDerivationRule0000
System-ScaBusinessAttribute System-ScaBusinessAttribute0000
System-ScaBusinessAttributeName System-ScaBusinessAttributeName0000
System-ScaBusinessEventActions System-ScaBusinessEventActions0000
System-ScaBusinessEventArchive System-ScaBusinessEventArchive0000
System-ScaBusinessEventClasses System-ScaBusinessEventClasses0000
System-ScaBusinessEventHistory System-ScaBusinessEventHistory0000
System-ScaBusinessEventLinks System-ScaBusinessEventLinks0000
System-ScaBusinessEventObjects System-ScaBusinessEventObjects0000
System-ScaBusinessEvents System-ScaBusinessEvents0000
System-ScaBusinessEventSchedules System-ScaBusinessEventSchedules0000
System-ScaColumnNames System-ScaColumnNames0000
System-ScaColumns System-ScaColumns0000
System-ScaCompanies System-ScaCompanies0000
System-ScaCompanyPropertyType System-ScaCompanyPropertyType0000
System-ScaCompanyYear System-ScaCompanyYear0000
System-ScaCompanyYearPropertyType System-ScaCompanyYearPropertyType0000
System-ScaCompletedTasks System-ScaCompletedTasks0000
System-ScaCompletedTasksAttributes ScaCompletedTasksAttributes System-ScaCompletedTasksAttributes0000
System-ScaCompletedTasksGroups System-ScaCompletedTasksGroups0000
System-ScaCompletedTasksUsers System-ScaCompletedTasksUsers0000
System-ScaCorpAssignedTemplates System-ScaCorpAssignedTemplates0000
System-ScaCorpAssignments System-ScaCorpAssignments0000
System-ScaCorpCerts System-ScaCorpCerts0000
System-ScaCorpGroups System-ScaCorpGroups0000
System-ScaCorpImpCerts System-ScaCorpImpCerts0000
System-ScaCorpImpExpParams System-ScaCorpImpExpParams0000
System-ScaCorpParameters System-ScaCorpParameters0000
System-ScaCorpTemplateItems System-ScaCorpTemplateItems0000
System-ScaCorpTemplates System-ScaCorpTemplates0000
System-ScaCorrelation System-ScaCorrelation0000
System-ScaCustomerPlugInCompanies System-ScaCustomerPlugInCompanies0000
System-ScaCustomerPlugInComPlusProps System-ScaCustomerPlugInComPlusProps0000
System-ScaCustomerPlugIns System-ScaCustomerPlugIns0000
System-ScaCustomerPlugInYears System-ScaCustomerPlugInYears0000
System-ScaDatabases System-ScaDatabases0000
System-ScaDataTypeNames System-ScaDataTypeNames0000
System-ScaDataTypes System-ScaDataTypes0000
System-ScaDBLinkDetails System-ScaDBLinkDetails0000
System-ScaDBObjectLinks System-ScaDBObjectLinks0000
System-ScaDBObjectNames System-ScaDBObjectNames0000
System-ScaDBObjects System-ScaDBObjects0000
System-ScaDBSubsets System-ScaDBSubsets0000
System-ScaDBSubsetTables System-ScaDBSubsetTables0000
System-ScaDBVersion System-ScaDBVersion0000
System-ScaDESFolders System-ScaDESFolders0000
System-ScaDESMessageActions System-ScaDESMessageActions0000
System-ScaDESMessageMap System-ScaDESMessageMap0000
System-ScaDESMessageSenderNames System-ScaDESMessageSenderNames0000
System-ScaDESMessageSenderSubNames System-ScaDESMessageSenderSubNames0000
System-ScaDESMessageTypes System-ScaDESMessageTypes0000
System-ScaDESPlugInInstances System-ScaDESPlugInInstances0000
System-ScaDESPlugInRegs System-ScaDESPlugInRegs0000
System-ScaDESPlugIns System-ScaDESPlugIns0000
System-ScaDESPlugInTypes System-ScaDESPlugInTypes0000
System-ScaDESProperties System-ScaDESProperties0000
System-ScaDESServers System-ScaDESServers0000
System-ScaDocumentRepresentation System-ScaDocumentRepresentation0000
System-ScaDocuments System-ScaDocuments0000
System-ScaDocumentType System-ScaDocumentType0000
System-ScaDocumentTypeDerivationRule System-ScaDocumentTypeDerivationRule0000
System-ScaDocumentTypeName System-ScaDocumentTypeName0000
System-ScaEntryArchive System-ScaEntryArchive0000
System-ScaEntryDocument System-ScaEntryDocument0000
System-ScaEntryTypeBindings System-ScaEntryTypeBindings0000
System-ScaFeatureNames System-ScaFeatureNames0000
System-ScaFeatureObject System-ScaFeatureObject0000
System-ScaFeatures System-ScaFeatures0000
System-ScaFieldAssociations System-ScaFieldAssociations0000
System-ScaFieldLinkSettingData System-ScaFieldLinkSettingData0000
System-ScaFKeyColumns System-ScaFKeyColumns0000
System-ScaFlagType System-ScaFlagType0000
System-ScaForeignKeys System-ScaForeignKeys0000
System-ScaFormDescr System-ScaFormDescr0000
System-ScaFormParametersBinding System-ScaFormParametersBinding0000
System-ScaForms System-ScaForms0000
System-ScaIndexColumns System-ScaIndexColumns0000
System-ScaIndexes System-ScaIndexes0000
System-ScaInstallationHistory System-ScaInstallationHistory0000
System-ScaInstallationProperties System-ScaInstallationProperties0000
System-ScaInstallationPropertyType System-ScaInstallationPropertyType0000
System-ScaInstalledProjects System-ScaInstalledProjects0000
System-ScaIntegrationPlugins System-ScaIntegrationPlugins0000
System-ScaJobDisabledCompanies Stores company codes for companies where job request processing is disabled System-ScaJobDisabledCompanies0000
System-ScaJobHandlerTypes Contains the list of supported job handler types System-ScaJobHandlerTypes0000
System-ScaJobRequests Stores the queue of job requests to be processed System-ScaJobRequests0000
System-ScaJobRequestsHistory Stores processed job requests System-ScaJobRequestsHistory0000
System-ScaJobSchedules Stores the schedules of the scheduled jobs System-ScaJobSchedules0000
System-ScaJobServers Stores descriptions of the servers assigned for job processing System-ScaJobServers0000
System-ScaJobStatuses Contains the list of possible statuses of queued and processed job requests System-ScaJobStatuses0000
System-ScaJobTypes Contains the list of registered job handlers System-ScaJobTypes0000
System-ScaJoinConditions System-ScaJoinConditions0000
System-ScaLifeCycleTables Contains UDDB tables involved in life-cycle System-ScaLifeCycleTables0000
System-ScaLogArchive System-ScaLogArchive0000
System-ScaLogMessage System-ScaLogMessage0000
System-ScaMenuAssignments System-ScaMenuAssignments0000
System-ScaMenuDescr System-ScaMenuDescr0000
System-ScaMenuList System-ScaMenuList0000
System-ScaMenus System-ScaMenus0000
System-ScaObjectTypeNames System-ScaObjectTypeNames0000
System-ScaObjectTypes System-ScaObjectTypes0000
System-ScaOrganigram System-ScaOrganigram0000
System-ScaOrgnodeNames ScaOrgnodeNames System-ScaOrgnodeNames0000
System-ScaParamNames System-ScaParamNames0000
System-ScaPersistedSubWFCalls System-ScaPersistedSubWFCalls0000
System-ScaPersistentLocks System-ScaPersistentLocks0000
System-ScaPlugInInterfaces System-ScaPlugInInterfaces0000
System-ScaQueries System-ScaQueries0000
System-ScaQueryColHeader System-ScaQueryColHeader0000
System-ScaQueryColumns System-ScaQueryColumns0000
System-ScaQueryConditions System-ScaQueryConditions0000
System-ScaQueryDescr System-ScaQueryDescr0000
System-ScaQueryFieldFormLinks System-ScaQueryFieldFormLinks0000
System-ScaQueryFieldLinks System-ScaQueryFieldLinks0000
System-ScaQueryParams System-ScaQueryParams0000
System-ScaQueryTableExclusions System-ScaQueryTableExclusions0000
System-ScaQueryTables System-ScaQueryTables0000
System-ScaReportFormatGroupLinks System-ScaReportFormatGroupLinks0000
System-ScaReportFormatGroups System-ScaReportFormatGroups0000
System-ScaReportFormats System-ScaReportFormats0000
System-ScaRepositoryResourceBodies System-ScaRepositoryResourceBodies0000
System-ScaRepositoryResourceDependencies System-ScaRepositoryResourceDependencies0000
System-ScaRepositoryResources System-ScaRepositoryResources0000
System-ScaRepositoryVersion System-ScaRepositoryVersion0000
System-ScaRestOperations Rest Operations System-ScaRestOperations0000
System-ScaRestReferences Rest References System-ScaRestReferences0000
System-ScaRestResourceGroups REST groups System-ScaRestResourceGroups0000
System-ScaRestResources Rest Resources System-ScaRestResources0000
System-ScaRoleNames ScaRoleNames System-ScaRoleNames0000
System-ScaRolePermissions System-ScaRolePermissions0000
System-ScaRoles System-ScaRoles0000
System-ScaRoleToOrgnode System-ScaRoleToOrgnode0000
System-ScaRoleValidation System-ScaRoleValidation0000
System-ScaScheduledJobBindings Stores associations of scheduled job with company and year System-ScaScheduledJobBindings0000
System-ScaScheduledJobs Stores definitions of scheduled jobs System-ScaScheduledJobs0000
System-ScaScripts System-ScaScripts0000
System-ScaSearchResultView System-ScaSearchResultView0000
System-ScaSecurityItems System-ScaSecurityItems0000
System-ScaSeededTableRecords System-ScaSeededTableRecords0000
System-ScaSeededTables System-ScaSeededTables0000
System-ScaSynchronizationLog System-ScaSynchronizationLog0000
System-ScaSynchronizationStatus System-ScaSynchronizationStatus0000
System-ScaSynchronizationTypes System-ScaSynchronizationTypes0000
System-ScaSystemServices System-ScaSystemServices0000
System-ScaTaskAttributes ScaTaskAttributes System-ScaTaskAttributes0000
System-ScaTasksArchive System-ScaTasksArchive0000
System-ScaTasksArchiveAttributes archive of task attributes System-ScaTasksArchiveAttributes0000
System-ScaTasksArchiveGroups System-ScaTasksArchiveGroups0000
System-ScaTasksArchiveUsers System-ScaTasksArchiveUsers0000
System-ScaTrace System-ScaTrace0000
System-ScaTraceArch System-ScaTraceArch0000
System-ScaTracedInterfacialDocument System-ScaTracedInterfacialDocument0000
System-ScaTracedInterfacialDocumentArch System-ScaTracedInterfacialDocumentArch0000
System-ScaTracedTask System-ScaTracedTask0000
System-ScaTracedTaskArch System-ScaTracedTaskArch0000
System-ScaTrackArchive System-ScaTrackArchive0000
System-ScaTrackDocument System-ScaTrackDocument0000
System-ScaUDTableLayout System-ScaUDTableLayout0000
System-ScaUserCompanyProperties System-ScaUserCompanyProperties0000
System-ScaUserCompanyPropertyType System-ScaUserCompanyPropertyType0000
System-ScaUserProfileEntries System-ScaUserProfileEntries0000
System-ScaUserProfileEntryDesc System-ScaUserProfileEntryDesc0000
System-ScaUserProfileItems System-ScaUserProfileItems0000
System-ScaUserProfileItemTypes System-ScaUserProfileItemTypes0000
System-ScaUserPropertiesType System-ScaUserPropertiesType0000
System-ScaUserProperty System-ScaUserProperty0000
System-ScaUsers System-ScaUsers0000
System-ScaUserToOrgnode System-ScaUserToOrgnode0000
System-ScaUserType System-ScaUserType0000
System-ScaValueType System-ScaValueType0000
System-ScaVbaProjects System-ScaVbaProjects0000
System-ScaWebServices System-ScaWebServices0000
System-ScaWorkerNodeAssignments Assignments of servers hosting iScala application objects System-ScaWorkerNodeAssignments0000
System-ScaWorkerNodes Windows servers hosting iScala application objects System-ScaWorkerNodes0000
System-WFProcessingInstances System-WFProcessingInstances0000
System-WFRequestQueue System-WFRequestQueue0000
System-WFRequestStatus System-WFRequestStatus0000

Fields
PK Table Name Description Type Length Precision Note
System-ScaJobStatuses HistoryStatus HistoryStatus TINYINT 1 0 0 History Status The flag indicating whether this is the status for queued of archived job requests
1 System-ScaJobStatuses ID JobStatusID INT 4 0 0 Job Status ID ID of the job status
System-ScaJobStatuses Name Name VARCHAR 255 255 0 Status Name Textual status name