GP Tables

System

34 tables in this module

System tables store company-wide settings, user security, batch processing, and cross-module configuration. SY tables are shared across all modules and contain critical master data like company setup and user preferences.

Table Description
ACTIVITY User Activity
ALERT3RD Alert Messages Third Party
ALERTAZ Alert Messages Australia/New Zealand
ALERTCA Alert Messages Canada
ALERTUK Alert Messages United Kingdom
GPS_SQL_Error_Codes GPS_SQL_Error_Codes
IC40100 Intercompany Account Setup
MESSAGES MESSAGES
ORG00100 ORG Relation Master
ORG10000 ORG Relation Report View
ORG40000 ORG Level Setup
ORG40100 ORG Entity Setup
SE000401 Account Rollups Account Period Detail
SE00400 Account Rollups Account Detail
STN41100 Named Printers Options Master
STN41200 Named Printers Assign Master
STN41250 Named Printers Assign Mode
STN41300 Named Printers Settings Master
STN41350 Named Printers Users Master
SY003001 Account Definition Header
SY00302 Account Definition
SY00800 Batch Activity
SY00801 Resource Activity
SY01301 Process Group Cleanup Information
SY01400 Users Master
SY01402 System User Defaults
SY01403 User Tasks
SY01404 Custom Reminders Setup
SY01405 User-Specific Dex.ini Settings
SY01450 Scheduled Backup Master
SY01500 Company Master
SY01501 Company Images Master
SY06000 Vendor EFT Information
SY07255 List Action Status Line