Business Central Musings

I’m excited to announce the release of the eighth booklet in my MB-820 Exam Cram series: Tables and Table Extensions in Business Central!

Why This Topic Matters

Every piece of data in Microsoft Dynamics 365 Business Central lives in a table. From customer records to complex financial transactions, tables are the foundation of the entire ERP system. Understanding how to design, extend, and maintain tables is essential for any Business Central developer.

But tables in Business Central aren’t just database tables – they’re business objects with behavior, validation, and relationships built in. The AL language provides a powerful abstraction over SQL Server, giving developers control over data integrity through triggers, calculated fields through FlowFields, and performance optimization through carefully designed keys.

What’s Inside This Guide

This 50+ page comprehensive guide covers everything you need to know about tables for the MB-820 certification and real-world development:

Tables and Schema Design

• Creating tables with proper field definitions and properties
• Understanding field classes: Normal, FlowField, and FlowFilter
• Data types and when to use each one
• Implementing table triggers for business logic
• Data classification for GDPR compliance

Keys and Performance

• Designing effective primary keys
• Creating secondary keys for query optimization
• Clustered vs. non-clustered indexes
• New features like IncludedFields and ColumnStoreIndex
• Performance trade-offs and best practices

Field Groups

• DropDown field groups for lookup controls
• Brick field groups for tile views and Teams integration
• How field groups enhance user experience

Table Extensions

• Adding fields without modifying base code
• Understanding how extension tables work under the hood
• Key and field group additions
• Limitations you need to know

Retention Policies

• Managing database growth automatically
• The three retention policy interfaces
• Registering custom tables for retention
• Implementing custom deletion logic with archiving

Hands-On Learning

Theory is important, but practice makes perfect. This guide includes:

• 9 Practical Exercises covering all major topics
• 30 Exam-Style Practice Questions with detailed explanations
• Real-World Code Examples from Microsoft’s Base App and System Application

Based on Real Code

Unlike guides that only show theoretical examples, I analyzed actual Business Central source code to bring you patterns from:

• The Customer table (Table 18) with its comprehensive FlowFields and triggers
• The Item table (Table 27) showing proper enum usage and validation
• Service Customer table extension demonstrating FlowFields in extensions
• Subscription Billing extension showing minimal, effective field additions
• System Application retention policy interfaces and implementations

Companion Resources

This booklet is designed to complement my YouTube videos on these topics:

• Tables and Table Extensions in Business Central
• Retention Policies in Business Central

I also reference the retention policy customization examples from my GitHub repository created for Directions 2025.

Key Takeaways

After reading this guide, you’ll understand:

1. Table structure – The four sections of every table and how they work together
2. FlowFields – How calculated fields provide real-time aggregated data without storage
3. Keys – How to design indexes for optimal query performance
4. Extensions – How table extensions create separate tables joined by primary key
5. Retention – How to implement automatic data cleanup with custom logic

Get Your Copy

Ready to master tables in Business Central?

Limited time 20% off

Get the Book

What’s Next

This is the eighth booklet in my MB-820 Exam Cram series. The complete collection now includes:

1. Install and Upgrade Codeunits
2. BC Admin and Automation API
3. BC Performance Toolkit
4. BC Cloud Migration Tool
5. Creating New Companies
6. Outlook Integration
7. Teams Integration
8. Tables and Table Extensions (NEW)

Stay tuned for more guides covering additional MB-820 exam topics!

Questions?

Have questions about tables, extensions, or retention policies? Leave a comment below or reach out on LinkedIn. I’m always happy to discuss Business Central development topics.

---

Good luck with your MB-820 exam preparation!