Dynamics GP to Business Central - System & Company Tables

 

One of the most critical areas in this transition is the translation of System tables and Company tables from Dynamics GP into their Business Central equivalents.

System tables in GP store global configurations—such as users, security, and report settings—while Company tables contain business-specific data per company database.

SYSTEM TABLES

GP Table	Description	BC Table	Business Central Equivalent
System Tables
ACTIVITY	User Activity	2000000110	BC logs user sessions in User Session
SY003001/02	Account Definition Header/Detail		Use G/L Account Category and Account Schedules
SY00800	Batch Activity		Environments > Manage Sessions
SY00801	Resource Activity		See above
SY01400	Users Master	2000000120	User– BC uses Azure AD or Microsoft 365 identities
SY01402	System User Defaults	2000000120	User Setup
SY01403	User Tasks (Reminders)		Job Queue Entry, Notifications, and User Tasks
SY01404	Customer Reminder Setup	292 296 292	Reminder Header Reminder Line Reminder Terms
SY01500	Company Master	2000000006 79	Company Company Information
SY01990, SY07130	Shortcut Bar, Navigation Bar		Not used – replaced by Role Center personalization
SY60100	User Access	2000000053	User Card > Permission Sets Access Control table
Security Tables
SY09000	Task master	2000000005	Permission
SY09100	Role master	2000000006	Permission Set
SY09200	Alternate form/report ID	n/a	Not used in BC (no modified reports concept)
SY10500	Role assignment	2000000053	User Permission Set
SY10550, SY10600, SY10700	Task assignments	2000000081	Part of User Group Permissions
SY10800	Alternate/Modified Report Assignment	n/a	Not applicable – no Report Modifier in BC
Email Tables
SY04900–SY04915	Email Options, Setup, History		Email Scenario, Email Message, and SMTP Setup
SY04900 – Email Options	Email Setup in BC
SY04901 – Email Messages	Email Message (Table 890)
SY04903 – Series Documents	Mapped via Report Selections by Module
SY04910–15 – Email History, Temp	Not stored persistently like GP; email logs available in Job Queue/Error Log
Document Attach Tables
CO40100	Document Attachment Setup		Document Attachment Setup
CO00101–105	Document Master, Reference, Properties, Status		Use Document Attachment (Table 1173), Record Link (Table 2000000068)
Safe Pay Setup Tables
ME123515–519	Safe Pay Config and Transactions	270	Bank Account > Positive Pay Export

COMPANY TABLES

GP Table	GP Description	BC Table	Business Central Equivalent
CO00101	Document Attachment Master	1173 113	Document Attachment Incoming Document Attachment
CO00102	Document Attachment Reference	2000000068	Record Link
SY00500	Batch Master	232 237 5620 5634	Gen. Journal Batch Job Journal Batch FA Journal Batch Insurance Journal Batch
SY00600	Location/Address Master	14 5609 10013 222	Location for inventory FA Location Vendor Location Ship-to Address per customer/vendor
SY01100	Company Posting Account Master	93 94 98 208 252 277 325 5606 5813	Vendor Posting Group Inventory Posting Group General Ledger Setup Job Posting Group General Posting Setup Bank Account Posting Group VAT Posting Setup FA Posting Group Inventory Posting Setup
SY01200	Internet Addresses	n/a	Contact, Email, and Communication Details in Customer/Vendor Card
SY01401	User Defaults	91	User Setup (Table 91)
SY02200	Posting Journal Destinations	n/a	Controlled via Report Selections + General Journal Template settings
SY02300	Posting Settings	98 311 312 313 325	General Ledger Setup Sales & Receivables Setup Purchases & Payables Setup Inventory Setup VAT Posting Setup
SY03000	Shipping Methods Master	10	Shipment Method
SY03100	Credit Card Master	289	Payment Method + Payment Terms
SY03300	Payment Terms Master	3	Payment Terms
SY03900	Record Notes Master	2000000068	Note field in many BC entities or Record Link
SY04200	Comment Master	37	Comment Line (Sales Line Table 37)
SY06000	Address EFT Master	270 288	EFT settings are stored in Bank Account or Vendor Bank Account
SY40100	Period Setup	50	Accounting Period
SY40101	Period Header	50	Same as above – Accounting Period stores fiscal year structure
TX00101 TX00102 TX00201	Tax Schedule Header Master Tax Schedule Master Tax Detail Master	316 318 319 320 321 322 325 326	Tax Area Translation Tax Area Tax Area Line Tax Jurisdiction Tax Group Tax Detail VAT Posting Setup Tax Setup
TX30000	Tax History	254	Posted via VAT Entry