Source fields in import scenarios
For more information: Manage import scenarios (SM206025).
You can use the following as source fields:
- The fields defined in the data provider
- The fields of a Visma Net window, from which we can take the value that already exists in the system or the default value
- Any combination of the fields defined in the data provider, the fields of a Visma Net window, constants, and functions
Relationships between source fields and target objects and fields
Source data includes a set of master records, such as customer account records. Each master record has a set of fields that are mapped to the fields of the summary object and related objects. For customer accounts, these fields can include Customer number and Email. There may be only one value of such field for each summary object or related object.
A master record can have a set of detail lines that are mapped to the fields of detail objects. For example, a customer account can have multiple contact details. There may be many detail lines for each detail object. Therefore, for these detail lines to be imported to Visma Net, external data should include the identifier of the master record for each detail line. That is, each detail line should have the key fields of the summary object specified.
For example, suppose that you have a customer account with two contact details. In this case, the external data that you are going to import to Visma Net should include two records, one record with the customer number and contact information for each contact detail. Such records should include a key field that the system uses to distinguish lines that belong to different records.