Field and column priority
In the documentation of the specific file types, each field (column) has a defined priority as described in the following table.
|
Priority level |
Description |
|---|---|
|
Required |
The column and the value must be present. If the column is missing, then the file cannot be parsed. If the column is present but the field is empty, then the specific record will be rejected. (In some cases, depending on the import behavior, this can also cause a failure of the entire import job.) |
|
Recommended |
The column and/or the field can be omitted, but providing the value is highly recommended. In some cases, the logic depends on the value. The system can function without it, but some algorithms may not run (or produce improper results) without the value. |
|
Optional |
The column or field is completely optional. Fields marked as optional are usually used only for presentation (to be shown in the UI). |
|
Ignored |
The field is either deprecated or recently introduced and is not required or processed by the system. No validation exists for these fields. |
|
Resettable |
This is an additional property which cannot stand alone but can be combined with recommended and optional priorities. It is used to indicate the deletion of values of specific fields in the database. A resettable field can have three different kind of values:
|