You are here: Reference Guide > Table Structures > System Tables Overview

System Tables

The System tables store the data to manage user profiles (SY_UserProfile), search window defaults and filters (SY_Filters etc), numbering information for each transaction form type (SY_Numbers), system settings (SY_SysValues), pluglet information (SY_Pluglet), forms linking and numbering (SY_Forms), breakout code (SY_BreakoutScripts), desktop icon information (SY_DesktopShortcuts) and document linking (SY_DocumentLinks)

Copyright © 2012 Jiwa Financials. All rights reserved.

EM_Attachments

EM_Main

EM_TemplateAttachments

EM_Templates

RP_LabelNo

RP_PurchaseSchedule

IM_ImportQueue

SY_Branch

SY_BreakOutScripts

SY_ClusterServers

SY_Counters

SY_DesktopShortcuts

SY_DocumentLinks

SY_DocumentTypes

SY_ExportReports

SY_File

SY_FilterDefaults

SY_Filters

SY_FiltersTemp

SY_FormAccessControlObjects

SY_Forms

SY_FormSectionLinks

SY_FormSections

SY_MessageLinks

SY_NoteTypes

SY_NotificationMessages

SY_Numbers

SY_PeriodRollover

SY_Pluglet

SY_PlugletDeploymentScripts

SY_PlugletSupportFiles

SY_SavedReportRanges

SY_SearchColumns

SY_SearchFilters

SY_SearchQueries

SY_SearchTypes

SY_SearchUserSettings

SY_SearchUserSettingValues

SY_StoredProcedures

SY_Switches

SY_SwitchSectionLinks

SY_SwitchSections

SY_SysHistory

SY_SysValues

SY_SysValuesLog

SY_UpgradeLog

SY_UserProfile

SYS_Process