Back

Basic fields on the template lines

Introduction to fields and actions on templates
Video 3/6
Play
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An intermediate video requires some previous experience with Business Central, but it is still easily accessible to most people. Intermediate Watch the "basic" videos to take the tour of the main processes of Business Central. This is the basic, need-to-use functionality. The Basics This video includes functionality from the app "Global Master Data Sync" which is available at Microsoft AppSource. Click to visit AppSource. Global Master Data Sync

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Presenter: Dennis Schumacher, Sr. Business Central Cons.

The template lines in your synchronization setup rely on a handful of basic fields that control how data is mapped and validated. The key fields are FieldID, Field Caption, Validate, Comment, and Relation Table No.

The FieldID is the number of the field in the table, and the Field Caption is the name of that field. The Validate field decides whether the field is validated during synchronization. The Comment field lets you add a description. The Relation Table No. shows the number of a related table, which helps you decide if you need several templates added to the master company.

The basic fields on template lines

When you work with template lines, there are a few basic fields you need to understand. Each one plays a specific role in how the synchronization handles your data.

The first field is the FieldID. This is simply the number of the field in the table.

Next is the Field Caption, which is the caption, or name, of the field.

Controlling validation during synchronization

The Validate field determines whether the field should be validated during the synchronization. This gives you control over how strictly each field is checked when data is synchronized.

Adding comments and tracking related tables

The Comment field lets you specify a comment or description for the line. This is useful for keeping notes about what a particular line does or why it is set up the way it is.

Finally, the Relation Table No. specifies the number of the related table, if there are any related tables. This is handy when you need to find out whether you should have several templates added to the master company.

Q&A

What is the FieldID on a template line?

The FieldID is the number of the field in the table.

What does the Validate field do?

The Validate field determines whether the field should be validated during the synchronization.

What is the Relation Table No. used for?

The Relation Table No. specifies the number of the related table when there are related tables. It helps you decide whether you should add several templates to the master company.

662230861-l42X3-t9o5s-ENG21110822