Tiedostomuoto
- Siirtotiedosto on puolipisteellä erotettua tekstimuotoista dataa. Rivinvaihto on line feed (
LF). Merkistökoodaus on UTF-8. Tiedostolla ei ole otsikkoriviä.
Rajaukset
- Työntekijät työntekijänumerolla 0 eivät tule osaksi aineistoa.
- Toimii vain integraation sääntöjoukkojen kanssa.
Aineston tietueet
| Column | Description | Integration query field | Format | Notes |
|---|---|---|---|---|
| A | Personnel number | Set automatically, cannot be overridden | number | Maximum length: 6 characters |
| B | Ps-ID | PopulusPsId | number | Maximum length: 8 characters. Populated from PopulusPsId |
| C | Salary type | SalaryCode | number | Salary code, for example "1000". Maximum length: 4 characters. |
| D | Start date | StartDateTime (format conversion handled automatically) | date | Format: YYYYMMDD. Row start date |
| E | End date |
EndDateTime (format conversion handled automatically) |
date | Format: YYYYMMDD. Row end date |
| F | Amount | Amount | decimal | Period . acts as decimal separator, accuracy 2 decimals. Maximum length: 8 characters |
| G | Unit price | UnitPrice | decimal | Period . acts as decimal separator, accuracy 2 decimals. Populated from UnitPrice. Maximum length: 8 characters |
| H | Total price | TotalPrice | decimal | Period . acts as decimal separator, accuracy 2 decimals. Populated from TotalPrice. Maximum length: 8 characters |
| I | Account | PopulusAccount | string | Populated from PopulusAccount. Maximum length: 8 characters |
| J | Cost centre | UserCostGroup | string | Populated from user cost group. Maximum length: 10 characters |
| K | Order | PopulusOrder | number | Populated from PopulusOrder. Maximum length: 12 characters |
| L | VAT | PopulusVat | string | Populated from PopulusVat. Maximum length: 2 characters |
| M | Additional identifier | PopulusAdditionalIdentifier | string | Populated from PopulusAdditionalIdentifier. Maximum length: 15 characters |