How it works...

To add fields to existing base tables, you need to create a table extension object. When you do this, you define the table you are going to extend. Once this is done, you simply add your fields as you would any new table. You can add your own logic, properties, and more to your new fields.

When the application gets published, a new companion table will be created in the database to hold the new fields. The Business Central application maintains the link between the companion table and its parent automatically.