File format
The transfer file is text-based data separated by semicolons. Line breaks are CR & LF. Character encoding is UTF-8.
Limits
Employees with an employee number of 0 are not included in the data.
Data records
| Column | Field | Integration query field | Format | Notes |
|---|---|---|---|---|
| A | Personnel number | Set automatically, cannot be overridden | number | Mandatory, maximum length 8 |
| B | Social security number | Set automatically | string | Can be overridden with eFinaSocialSecurityNumber. Maximum length 11 |
| C | Salary code | SalaryCode | number | Mandatory, maximum length 3 |
| D | Amount | Amount | decimal | Comma (,) as decimal separator. Maximum length 9 |
| E | Unit price | UnitPrice | decimal | Comma (,) as decimal separator. Maximum length 9. Can be overridden with UnitPrice |
| F | Total price | TotalPrice | decimal | Comma (,) as decimal separator. Maximum length 9. Can be overridden with TotalPrice |
| G | Comment | Comment | string | Maximum length 58 (automatically limited in file) |
| H | Project Code 1 | ProjectCode1 | number | Maximum length 6. Populated from ProjectCode1 |
| I | Project Code 2 | ProjectCode2 | number | Maximum length 6. Populated from ProjectCode2 |
| J | Project Code 3 | ProjectCode3 | number | Maximum length 6. Populated from ProjectCode3 |
| K | Employee Name | eFinaEmployeeName | string | Person's first and last name. Can be overridden with eFinaEmployeeName |
| L | Project Code 4 | ProjectCode4 | number | Maximum length 6. Populated from ProjectCode4 |
| M | Project Code 5 | ProjectCode5 | number | Maximum length 6. Populated from ProjectCode5 |
| N | Project Code 6 | ProjectCode6 | number | Maximum length 6. Populated from ProjectCode6 |