On the Import Definition card page, the Constant Values can be configured. These lines are used to import data that is not (directly) available in the import message.
Here constant values and functions can be used to set field values.
|Specifies the table number. Only constant values with tables used in the definition lines will be processed.
|Specifies the table caption for the table.
|Specifies the field number to process.
|Specifies the field caption for the field.
|Specifies a constant value to use as the (initial) field value.
|Counts the number of functions used for the constant value line. Click on the number to see the function list.
| Specifies when the constant value should be processed.
Only used for fields not part of the primary key. The following values are available:
|Before/After Line No.
|Specifies before or after which line no. the field should be processed. Only used with Processing Policy options Before Field and After Field.
|Before/After Field Caption
|Specifies the field caption for the Before/After Line No. field.
|Specifies if the field should be validated. This will execute the OnValidate() trigger in the table object for the field.
|Specifies if the OnInsert() or OnModify() trigger should be executed for the table object when updating the field value.
| Specifies the action to take for a field when detecting an existing record to update. The following values are available:
Need more help with this?