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 |