Fivaldi palkka-aineisto, CSV – Nepton

Tiedostomuoto

Siirtotiedosto on puolipisteella erotettua tekstimuotoista dataa. Rivinvaihto on CR & LF. Merkistökoodaus on UTF-8.

Column	Field	Integration rule field	Format	Notes
A	Erä	FivaldiBatchIdentifier	string	Can be overridden with FivaldiBatchIdentifier .
B	Salary date	SalaryRenderingDate	date	DD.MM.YYYY.
C	Employee number	Set automatically, cannot be overridden	string	If integration ID is empty, employee number will be used.
D	Salary Code	SalaryCode	integer
E	Amount	Amount	decimal	Comma as decimal separator. Two decimals are always exported.
F	SK1	ProjectCode1	date	Project code 1. Note that if only 1 project is set up with '/' separator it will be split to other project codes.
G	SK2	ProjectCode2	date	Project code 2
H	SK3	ProjectCode3	string	Project code 3
I	SK4	ProjectCode4	string	Project code 4
J	Kerroin		string	Always empty
K	Hinta		string	Always empty
L	Kulutili		string	Always empty
M	Selite	Comment	string
N	Päivitystapa			Always sent as 1