...
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| CONTACT_NR | Text 20 | The field CONTACT_NR is mandatory for all OPERATION that is not INSERT. | Contact number. If your contact numbers have leading zeros, they must also be given, as they will be kept; the contact number is stored as a text. To be able to import existing contact numbers, the sequence for contact numbers must be adapted to generate numbers high than the highest imported contact number so that new contacts do not get an existing value. This is to be handled outside the import file. |
| TITLE | Text 200 | Data will be imported if value is defined. Complete list for a specific institution can be found in screen Institution context → Initialization → List of Values → Individual Title. Standard values are: MR, MRS, MISS, MR_AND_MRS, UNDEFINED. | |
| LETTER_SALUTATION | Text 200 | If value is empty, these fields will be interpolated from the TITLE field, according to the language of the individual. Ex: if TITLE = 'MR' → ADDR_SALUTATION = 'Dear Sir' → LETTER_SALUTATION = 'Mr'. | |
| ADDR_SALUTATION | Text 200 | ||
| FUNCTION | Text | The function of the contact (Head of operations, Chairman, ...) | |
| REMARK | Text | Free remark. Adding two pipes « |
...