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.
