Klik her for PDF vejledning
1. Description
Type
K – Key, data entries in key fields are mandatory
N – Numeric
X – Alphanumeric, characters
% – The field may be deleted/left blank
D – Date field, DDMMYYYY
M – Mandatory, values MUST be entered at time of creation
Å – Year, the year 2000 and later
File name
The file name will not be ‘checked’ which means that you can decide what the name of the file
should be.
However, a file name can only be loaded into the salary system once. The maximum number of
characters allowed is 20 and these characters may a combination of numbers and letters.
File format
In MultiLøn, you can load a file from an external system. The file must be in csv-format
(separated by semicolons and in Windows code page 1252 ANSI )
and should have a preset layout. In a csv-file, the following characters
are not allowed in data; ’,’ (comma) ’;’ (semicolon) ” (quotation marks) as these are used as
separators. MultiLøn Erhverv includes the following separator characters; ’,’(comma) of ’;’
(semicolon).
The decimal point is denoted by ’.’ (full stop).
Sorting
The ordering of the records is of no importance. During loading, the salary system performs the
sorting.
Data check
Data check is carried out using the same rules that govern manual entries.
2. Loading files into MultiLøn Erhverv
The employer must have signed up for ’Service 7’ to be able to load the files into Visma Løn.
How to load files into MultiLøn Erhverv:
Click ’Lønadministration (Salary administration) / Overførsel (Transfer)/ Decentral registrering (Decentralized recording)’
Load the file, then click ’Indlæs’ (Load)
Navigate to the file and click ’OK’
Then a job is started and displayed under ’Vis job’ (View job). After completion of the job, click ’Hent aktuelt’ (Get current)
Then click ’Åbn’ (Open)
Double click the file displayed, then click ’Åbn’ (Open)
On the screen, you will see ’Kvittering for decentral registrering’ (Acknowledgement for decentralized recording). The report includes details about the number of lines which are ’Modtaget’ (Received), ’Indlæst’ (Loaded) and ’Afvist’ (Rejected), respectively.
The received and loaded lines are located on the relevant screens in the salary system.
The rejected lines will be displayed in the ’Kvittering for decentral registrering’ (Acknowledgement for decentralized recording) report; for the rejected lines, the report includes details regarding employee numbers and failures/causes.
Case
Below, you see the structure of a csv file, including all formats and the separator character is ’;’
(semicolon):
18;1;MLE-05-AFDE;300;HR
18;1;MLE-10-UDBE;Kbh;København
18;;MLE-15-REST;1100;01082008;;;T3;;;120;60
18;;MLE-15-REST;1100;01082008;;;F3;165
18;;MLE-15-REST;1100;01082008;;;F4;;175
18;1;MLE-25-MEDA;3;3001609992;;Jensen;Gurli;Skogen 12;SE-45678
Malmø;0;;01082008;gj@hotmail.dk;SE;000100;H;01082008
18;1;MLE-25-MEDA;4;2602639991;;Olsen;Thomas;Sorte vænget 22;;2750;;15082008;;;000015;B;15082008
18;1;MLE-30-ANSF;3;01082008;;;;1001;HR konsulent;130.00;;F1;300;;;1010244230
18;1;MLE-30-ANSF;4;15082008;;;;3001;Lager;0;;T1;100;Kbh;;1010244230
18;1;MLE-30-ANSF;10086;01082008;;3;31082008
18;1;MLE-35-REGK;3;01082009;;1234;9481247
18;1;MLE-35-REGK;4;15082008;;1222;3185784375
18;1;MLE-40-LONA;3;01082008;;9900;;;;20000
18;1;MLE-40-LONA;3;01082008;;6200;;;;;5;;;10;;;;;;;2003
18;1;MLE-40-LONA;3;01082008;;9011;;120
18;1;MLE-40-LONA;3;01082008;;1303;;5;120
18;1;MLE-40-LONA;3;01082008;;3000;;;;6500
18;1;MLE-40-LONA;3;01082008;31122008;3010
18;1;MLE-40-LONA;4;15082008;;6003;;;;;3.7;;;7.4;2;;;;;;2115;;;;1
18;1;MLE-40-LONA;4;15082008;;6410;;;;500;;;;;;;;;2345;6544533
18;1;MLE-40-LONA;4;15082008;;1100;;165
18;1;MLE-40-LONA;4;15082008;;9905;;;;170
18;1;MLE-40-LONA;4;15082008;;9906;;;;15
18;1;MLE-45-ERIN;3;01082008;1;Jubilæum 2018
18;1;MLE-50-ANSO;3;300;412110;;01082008
18;1;MLE-50-ANSO;3;800;4;;01082008
18;1;MLE-50-ANSO;3;600;99999;30.00;01082008
18;1;MLE-55-FRAV;10078;12082008;13082008;40;Ferie i august;2
18;1;MLE-55-FRAV;987;14082008;14082008;18;Dagpenge;7.5;125
18;1;MLE-55-FRAV;992;02012008;02012008;40;;;;9
18;1;MLE-60-EIND;3;10;0;01082008
18;1;MLE-60-EIND;3;11;0;01082008
18;1;MLE-60-EIND;4;66;0;15082008;;5000
18;1;MLE-65-GREK;1;01082008;H
18;1;MLE-65-GREK;2;15082008;H
3. MLE-05-AFDE (Department)
You can create and modify departments by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), and AFDELING (DEPARTMENT)
The following fields may be modified by using Decentralized recording:
DESCRIPTION
Case
18;1;MLE-05-AFDE;300;HR
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-05-AFDE
4
D
Afdeling (Department)
6
X K
AFDELINGSNR (DEPARTMENT NO.)
5
E
Description
30
X
AFDELING TEKST (DEPARTMENT TEXT)
To indicate deletion of ’beskrivelse’ (description), enter ’%’ into the field.
4. MLE-10-UDBE (Subsection)
You can create and modify subsections by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), and UDBETALINGSSTED (SUBSECTION)
The following fields can be modified by using Decentralized recording.
DESCRIPTION
Case
18;1;MLE-10-UDBE;Kbh;København
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (customer relation)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER RELATION NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
EMPLOYER NO.
3
C
Identifikation (Identification)
11
X K
MLE-10-UDBE
Record ID
4
D
Udbetalingssted (Subsection)
6
X K
SUBSECTION ID
5
E
Description
30
X
For deletion of ’beskrivelse’ (description), enter ’%’ into the field.
5. MLE-15-REST (Result steps)
You can create and modify result steps by using Decentralized recording.
The result table may/should be accounted for on an accruals basis by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), IDENTIFIKATION (IDENTIFICATION), RESULTATTABEL
(RESULT TABLE) , FRADATO (FROM DATE), and LØNGRUPPE (SALARY GROUP)
You can change the following fields by using Decentralized recording:
SATS BAGUD (RATE IN ARREAR), SATS FORUD (RATE IN ADVANCE), SATS TIMELØN
(RATE – HOURLY WAGE), and SATS 14 DAGS LØN (RATE – SALARY FOR 2 WEEKS)
You can change the following fields by using Decentralized recording if you have a salary scale agreement:
RYKTYPE1, RYKTYPE2, RYKTYPE3, RYKNØGLE1, RYKNØGLE2, RYKNØGLE3
Note: If the entire result step for a salary group should be deleted, then enter ’%’ into all rate
fields (fields 14-17).
Case
18;;MLE-15-REST;1100;01082008;;;T3;;;120;60
18;;MLE-15-REST;1100;01082008;;;F3;165
18;;MLE-15-REST;1100;01082008;;;F4;;175
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Blank field
0
X
Blank
3
C
Identifikation (Identification)
11
X K
MLE-15-REST
Record ID
4
D
Resultattabel (Result table)
6
X K
The result table number e.g. ’1100’
5
E
Fradato (From date)
8
D K
RESULTATTABEL STARTDATO (RESULT TABLE START DATE). Format: DDMMYYYY
6
F
Tildato (To date)
8
D
RESULTATTABEL SLUTDATO (RESULT TABLE END DATE). Format: DDMMYYYY
7
G
Betegnelse (Designation)
30
X
For deletion of ’betegnelse’ (designation), enter ’%’ into the field.
8
H
Ryktype1
6
X
Blank
LØNRAM
LØNTRN
LØNGRP
ST.KAT
AFDELI
UDBSTD
Usually left blank. If salary scale agreement, the field holds promotion code 1.
9
I
Ryktype1
6
X
Blank
LØNRAM
LØNTRN
LØNGRP
ST.KAT
AFDELI
UDBSTD
Usually left blank. If salary scale agreement, the field holds promotion code 2.
10
J
Ryktype1
6
X
Blank
LØNRAM
LØNTRN
LØNGRP
ST.KAT
AFDELI
UDBSTD
Usually left blank. If salary scale agreement, the field holds promotion code 3
11
K
Løngruppe
(Salary group)
6
X M
E.g. F1 or TT. If salary scale agreement, the field is connected to Ryktype1.
12
L
Ryknøgle2
6
X
Blank
Usually left blank. If salary scale agreement, the field is connected to Ryktype2
13
M
Ryknøgle2
6
X
Blank
Usually left blank. If salary scale agreement, the field is connected to Ryktype3.
14
N
Sats bagud (Rate in arrear)
10
N
Format: -9999999.99 – 9999999.99. For deletion of ’sats bagud’ (Rate in arrear), enter ’%’ into the field.
15
O
Sats forud (Rate in advance)
10
N
Format: -9999999.99 – 9999999.99. For deletion of ’sats forud’ (rate in advance), enter ’%’ into the field.
16
P
Sats timeløn (Rate – hourly wage)
10
N
Format: -9999999.99 – 9999999.99. For deletion of ’sats timeløn’ (hourly wage), enter ’%’ into the field.
17
Q
Sats 14 dags løn (Rate – salary for 2 weeks)
10
N
Format: -9999999.99 – 9999999.99. For deletion of ’sats 14 dags løn’ (rate – salary for 2 weeks), enter ’%’ into the field.
6. MLE-25-MEDA (Employee)
Employees may be created and modified by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), and MEDARBEJDER (EMPLOYEE)
You can change the following fields by using Decentralized recording:
CPRNR (CIVIL REG. NO.), CVRNR (CVR NUMBER), FORNAVN (FIRST NAME), EFTERNAVN
(LAST NAME), ADRESSE1 (ADDRESS1), ADRESSE2 (ADDRESS2), POSTNR (POSTAL
CODE), FØRSTANSAT (FIRST TIME EMPLOYMENT), E-MAIL (E-MAIL), SKATTELANDEKODE (TAX COUNTRY CODE), ANCIENNITET (LENGTH OF EMPLOYEE’S EMPLOYMENT), SKATTELANDEKODE (TAX COUNTRY CODE), EBOKS (E-BOX), INITIALER (INITIALS), NEMKONTO and LØNANCIENNITET.
Case
18;1;MLE-25-MEDA;3;3001609992;;Jensen;Gurli;Skogen 12;;SE-45678;
Malmø;01082008;gj@hotmail.dk;SE;000100;H;01082008
18;1;MLE-25-MEDA;4;2602639991;;Olsen;Thomas;Sorte vænget 22;;2750;;15082008;;;000015;B;15082008
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-25-MEDA
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
CPR-nr.
(Civil reg. no.)
10
N M
A Modulus 11 check is performed on the field. Fictitious civil reg. numbers xxxxxx-9991 or xxxxxx-9992 are valid. Value x must include a valid date. Format XXXXXXXXXX
6
F
CVR-nr.
(CVR no.)
8
N (M)
A Modulus 11 check is performed on the field. The field is populated with zero if the civil reg. no. is provided. The field is only populated if the value provided for the civil reg. no. is zero. Format: XXXXXXXX
7
G
Last name
30
X M
8
H
First name
30
X M
9
I
Address 1
30
X M
10
J
Address 2
30
X
For deletion of ’Address 2’ enter ’%’ into the field.
11
K
Postnummer dansk eller udl. (Postal code – Danish or foreign)
9
X M
Danish postal code validation if country code is not provided or provided with ’DK’. Otherwise no check.
12
L
Udl. Postdistrikt (Foreign postal code)
30
X(M)
blank
Should be entered if the employee has a foreign address. Is deleted automatically if the country code is changed to ’DK’.
13
M
Først ansat (first time employment)
8
D M
Format: DDMMYYYY
14
N
E-mail
50
X
For deletion of ’e-mail’ enter ’%’ into the field.
15
O
Landekode (Country code)
2
X M
If the employee has a foreign address a value should always be provided for this field.
16
P
Anciennitet (Seniority)
6
N
Format: YYMMDD. The length of the employee’s employment in number of years months and days. For deletion of ’anciennitet’ (seniority) enter ’%’ into the field.
17
Q
Rekvirer skattekorttype (Requst tax card type)
1
X
H = Hovedkort (taxrate and deduction card)
B = Bikort (secondary taxcard)
Blank = intet kort (no card)
A tax card can only be requested when creating a new employee. If an existing employee having a new salary number is created in the salary system the field must be ’Blank’ and you need to make a ’Genrekvirering af skattekort’ (new tax card request).
18
R
Request date
8
D
The effective date of the e-tax card. Format: DDMMYYYY
19
S
eBoks
3
X
Ja / Nej
JA/NEJ (YES/NO) to eBoks must be indicated.
20
T
Initials
10
X
Initials of employees.
21
U
Nemkonto
3
X
Ja / Nej
JA/NEJ (YES/NO) to Nemkonto must be indicated.
22
V
Lønanciennitet
8
X
The employee’s Seniority date. Format: DDMMYYYY
7. MLE-30-ANSF (Conditions of employment)
Conditions of employment can med created, modified and be accounted for on an accruals basis
by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), and FRADATO (FROM DATE)
You can modify the following fields by using Decentralized recording:
FRADATO (FROM DATE), FRATRÆDELSESDATO (RESIGNATION DATE),
FRATRÆDELSESKODE (RESIGNATION CODE), AFDELINGSNR (DEPARTMENT NO.,
UDBETALINGSSTEDNR (PAYER NO.),LØNGRUPPENR (SALARY GROUP NO.),
STILLINGSKATEGORI (POSITION CATEGORY), ANSÆTTELSESBETEGNELSE (EMPLOYMENT DESIGNATION), NORMTID (STANDARD PERIOD), AFV.FORENINGSKODE (AFV. ASSOCIATION CODE), AFV.PNR, OPTIONAL 1-6, LØNRAMME, LØNTRIN, RYKKODE1, RYKKODE2, RYKKODE3, NÆSTERYKDATO1, NÆSTERYKDATO2, NÆSTERYKDATO3. AUTORYK1,AUTORYK2, AUTORYK3, ARBEJDSDAGE PR.UGE.
Case
18;1;MLE-30-ANSF;3;01082008;;;;1001;HR konsulent;130.00;;F1;300;;;1010244230
18;1;MLE-30-ANSF;4;15082008;;;;3001;Lager;0;;T1;100;Kbh;;1010244230
18;1;MLE-30-ANSF;10086;01082008;;3;31082008
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-30-ANSF
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
Fradato (From date)
8
D K
Format: DDMMYYYY
"Fradato (From date) should NOT contain any data when only Fratrædelseskode (Resignation Code) and Fratrædelsesdato (Resignation Date) are used in the record."
6
F
Tiltrædelsesdato (Commencement date)
8
D
Is not applied.
7
G
Fratrædelseskode (Resignation code)
2
N
Mandatory in case of resignation. When populating this field the From date field MUST also be populated with the term date from the salary system. In case of reemployment enter ’%’ into the field. For deletion of ’fratrædelseskode’ (resignation code) enter ’%’ into the field.
8
H
Fratrædelsesdato (Resignation date)
8
D
Mandatory in case of resignation. When populating this field the From date field MUST also be populated with the term date from the salary system. Format: DDMMYYYY
9
I
Stillingskategori (Position category)
4
N M
E.g. monthly or hourly paid employee.
10
J
Ansættelsesbetegnelse (Employment designation)
30
X
For deletion of ’ansættelsesbetegnelse’ (employment designation) enter ’%’ into the field.
11
K
Normtid medarbejder (Standard time per month)
6
N
Format: 999.99. For deletion of ’normtid medarbejder’ (standard time – employee) enter ’%’ into the field.
12
L
Normtid overenskomst (Standard time - agreement)
6
N
If not 160.33 this is provided at time of creation.
Format: 999.99
13
M
Løngruppe (Salary group)
6
X M
The letter should be with initial cap e.g. ’T1’ or ’F2’.
14
N
Afdeling (Department)
6
X
Case sensitive. For deletion of ’afdeling’ (department) enter ’%’ into the field.
15
O
Udbetalingssted (Subsection)
6
X
Case sensitive. For deletion of subsection enter ’%’ into the field.
16
P
Afv. Foreningskode (Association code)
5
N
For deletion of ’afv. foreningskode' (association code) enter ’%’ into the field.
17
Q
Afv. Pnr.
10
X
Modulus check of field contents. For deletion of ’afv Pnr.’ enter ’%’ into the field.
18
R
Afv. kontoplan (Chart of accounts)
2
X
Check of existence of loaded chart of accounts. For deletion of Chart of accounts enter ’%’ into the field.
19
S
Valgfri1 (Optional1)
10
X
For deletion of Optional1 enter ’%’ into the field.
20
T
Valgfri2 (Optional2)
10
X
For deletion of Optional2 enter ’%’ into thefield.
21
U
Valgfri3 (Optional3)
10
X
For deletion of Optional3 enter ’%’ into the field.
22
V
Valgfri4 (Optional4)
10
X
For deletion of Optional4 enter ’%’ into the field.
23
W
Valgfri5 (Optional5)
10
X
For deletion of Optional5 enter ’%’ into the field.
24
X
Valgfri6 (Optional6)
10
X
For deletion of Optional6 enter ’%’ into the field.
25
Y
Lønramme
6
X
Usually left blank. If salary scale agreement, the field may hold pay scale.
26
Z
Løntrin
6
X
Usually left blank. If salary scale agreement, the field may hold pay scale point.
27
AA
Rykkode1
6
X
Usually left blank. If salary scale agreement, the field may hold promotion code 1.
28
AB
Rykkode2
6
X
Usually left blank. If salary scale agreement, the field may hold promotion code 2.
29
AC
Rykkode3
6
X
Usually left blank. If salary scale agreement, the field may hold promotion code 3.
30
AD
Næsterykdato1
8
D
Blank
DDMMYYYY
Usually left blank. If salary scale agreement, the field can hold the date for first shift of pay scale point according to Rykkode1
31
AE
Næsterykdato2
8
D
Blank
DDMMYYYY
Usually left blank. If salary scale agreement, the field can hold the date for first shift of pay scale point according to Rykkod2
32
AF
Næsterykdato13
8
D
Blank
DDMMYYYY
Usually left blank. If salary scale agreement, the field can hold the date for first shift of pay scale point according to Rykkode3
33
AG
Autoryk1
1
X
Usually left blank. If salary scale agreement, the field may hold Ja/Nej for automatic promotion.
34
AH
Autoryk2
1
X
Usually left blank. If salary scale agreement, the field may hold Ja/Nej for automatic promotion.
35
AI
Autoryk3
1
X
Usually left blank. If salary scale agreement, the field may hold Ja/Nej for automatic promotion.
36
AJ
Arbejdsdage pr. uge
1
N
Antallet af arbejdsdage pr. uge.
Anvendes ved aftale om
AJ
Arbejdsdage pr. uge
1
N
Number of work days per week,
Only feasible for companies in the financial trade.
8. MLE-35-REGK (Registration and account numbers)
Registration and account numbers can be created and be accounted for on an accruals basis by
using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), and STARTDATO (START DATE)
You can change the following fields by using Decentralized recording:
KONTONUMMER (ACCOUNT NUMBER), REGISTRERINGSNUMMER (REGISTRATION
NUMBER), STARTDATO (START DATE) and SLUTDATO (END DATE)
Case
18;1;MLE-35-REGK;3;01082009;;1234;9481247
18;1;MLE-35-REGK;4;15082008;;1222;3185784375
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-35-REGK
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
Startdato
(Start date)
8
D K
Format: DDMMYYYY
6
F
Slutdato
(End date)
8
D
Format: DDMMYYYY
7
G
Registreringsnr. (Registration number)
4
N M
8
H
Kontonummer (Accountnumber)
10
X M
9. MLE-40-LONA (Individual rates, fixed salary types and variable salary types)
Fixed salary types can be created by using Decentralized recording.
Fixed salary types can be created, modified and be accounted for on an accruals basis by using
Decentralized recording.
Individual rates can be created, modified and be accounted for on an accruals basis by using
Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), LØNARTNR (SALARY TYPE NUMBER),
and STARTDATO (START DATE)
You can modify the following fields by using Decentralized recording:
TILDATO (TO DATE) (End date), BETEGNELSE (DESIGNATION), ENHEDER (UNITS), SATS
(RATE); BELØB (AMOUNT), PCT. (PERCENT), PENS.FIRMABELØB (COMPANY
CONTRIBUTION AMOUNT FOR PENSION), PENS.FIRMA % (COMPANY CONTRIBUTION
PENSION %), PENSIONSGRUNDLAG (PENSION BASE), KONTONUMMER (ACCOUNT
NUMBER), REGISTRERINGSNUMMER (REGISTRATION NUMBER), MODTAGERSAFDELING
(RECIPIENT DEPARTMENT), MODTAGERSAFTALENR (RECIPIENT AGREEMENT
NUMBER), AFSENDERKUNDENR (SENDER CUSTOMER NO.), AFREGNINGSTYPENR
(PAYMENT TYPE NO.), OVERENSKOMSTKODE (AGREEMENT CODE), KONTOPLANFELT 1-6 (CHART OF ACCOUNTS FIELD1-6), AFREGNES VIA, FREKVENS, NÆSTE GANG, SLETTEMARKERING
In the document ’Lønarts felt beskrivelse til decentral registrering’ (Salary type description for decentralised recording), you can see the fields to be populated in connection with each salary type.
Note: Using decentralised loading, the following salary types must be replaced by new salary
types: (se table below) 400, 401, 600, 605, 606, 865, 4280, 4410, and 4412.
Note: Decentralised loading is NOT possible when using the following salary types:
450, 7802, 8392, 8725, and 8755.
Case
18;1;MLE-40-LONA;3;01082008;;9900;;;;20000
18;1;MLE-40-LONA;3;01082008;;6200;;;;;5;;;10;;;;;;;2003
18;1;MLE-40-LONA;3;01082008;;9011;;120
18;1;MLE-40-LONA;3;01082008;;1303;;5;120
18;1;MLE-40-LONA;3;01082008;;3000;;;;6500
18;1;MLE-40-LONA;3;01082008;31122008;3010
18;1;MLE-40-LONA;4;15082008;;6003;;;;;3.7;;;7.4;2;;;;;;2115;;;;1
18;1;MLE-40-LONA;4;15082008;;6410;;;;500;;;;;;;;;2345;6544533
18;1;MLE-40-LONA;4;15082008;;1100;;165
18;1;MLE-40-LONA;4;15082008;;9905;;;;170
18;1;MLE-40-LONA;4;15082008;;9906;;;;15
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-40-LONA
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
Fradato (From date)
8
D K
Format: DDMMYYYY
6
F
Tildato (To date)
8
D
Format: DDMMYYYY
7
G
Lønart (Salary type)
6
N K
8
H
Betegnelse (Designation)
30
X
9
I
Enheder (Units)
11
N
Unit types: Hours, days, km. Format: -9999999.99 – 9999999.99
10
J
Sats (Rate)
11
N
Format: -9999999.99 – 9999999.99
11
K
Beløb (Amount)
11
N
Format: -9999999.99 – 9999999.99
12
L
Pct. (Percent)
11
N
Pension egen % (Own pension contribution). Format: -9999999.99 – 9999999.99
13
M
Reducer ej (Do not reduce)
1
N
1 or 2
Default is blank = 0
14
N
Pens. Firmabeløb (Company pension contribution)
11
N
Format: -9999999.99 – 9999999.99
15
O
Pens. firma % (Company pension contribution %)
11
N
Format: -9999999.99 – 9999999.99
16
P
Pensionsgrundlag (Pension base)
1
N
1/2/3/4/5/6/10/11
Refer to description in the salary type catalogue
17
Q
Saldo (Balance)
11
N
Format: -9999999.99 – 9999999.99
18
R
Årstal (Year)
4
Å
Format: YYYY
19
S
Inputværdi
(Input value)
10
X
The value should equal the look up step. Refer to Guide til Værdi bestemt løn (Guide to value induced salary).
20
T
Reg.nr. (Reg. no.)
4
N
Applied in case of pensions
21
U
Kontonummer (Account number)
10
X
Applied in case of pensions
22
V
Afregningstype (Transaction code)
6
N
Applied in case of pensions
23
W
Modtagersafdeling (Recipient department)
5
X
Applied in case of pensions
24
X
Modtagersaftalenr (Recipient agreement no.)
8
X
Applied in case of pensions
25
Y
Afsenderkundenr (Sender customer no.)
15
X
Applied in case of pensions
26
Z
Overenskomstkode (Agreement code)
5
X
Applied in case of pensions
27
AA
Kontoplanfelt1 (Chart of accounts field)
20
X
*See note
Applied for input allocation
28
AB
Kontoplanfelt2 (Chart of accounts field)
20
X
*See note
Applied for input allocation
29
AC
Kontoplanfelt3 (Chart of accounts field)
20
X
*See note
Applied for input allocation
30
AD
Kontoplanfelt4 (Chart of accounts field)
20
X
*See note
Applied for input allocation
31
AE
Kontoplanfelt5 (Chart of accounts field)
20
X
*See note
Applied for input allocation
32
AF
Kontoplanfelt6 (Chart of accounts field)
20
X
*See note
Applied for input allocation
33
AG
Afregnes via
2
X
Default Blank or the value BC
Usually left blank. Only feasible for companies in the financial trade.
34
AH
Frekvens (Frequency)
2
N
Usually left blank. Only feasible for companies in the financial trade.
Applies only to fixed salary types.
35
AI
Næste gang
(Next payment/ withdrawal)
8
D
Blank
DDMMYYYY
Usually left blank. Only feasible for companies in the financial trade.
Applies only to fixed salary types.
36
AJ
Sletmarkering
1
N
9 = Delete fixed salary type
Startdate must correspond to the startdate for the fixed salary type.
*Input allocation can be used for the following chart of accounts fields:
Afdeling (Department) of characters = 6
Udbetalingssted (Subsection) of characters = 6
Kontonummer (Account number) of characters = 20
Valgfri1 (Optional1) of characters = 10
Valgfri2 (Optional2) of characters = 10
Valgfri3 (Optional3) of characters = 10
Valgfri4 (Optional4) of characters = 10
Valgfri 5 (Optional5) of characters = 10
Valgfri6 (Optional 6) of characters = 10
In addition to the chart of accounts fields above, the sorting code may have additional fields,
however, not all of them will be included in the sequence in terms of decentralized recording.
If your sorting code includes the following chart of accounts fields:
Aflønning (Form of renumeration)
Afdeling (Department)
Kontonummer (Account no.)
then, the following should be used in decentralised recording:
Column 27 / AA: Afdeling (Department) – this is the first chart of accounts field available for input
allocation
Column 28 / AB: Kontonr. (Account no.) - this is the second chart of accounts field available for
input allocation
Form of renumeration is not applicable in this context, as input allocation is not available for this sorting.
Note: Decentralized loading of the following salary types is not possible but may be replaced by
other salary types.
However, salary types 4410 and 4412 should have both salary types 4410 and 4412 plus salary
types 3800, 3801, or 3804. Other salary types will be replaced completely by other salary types.
See additional descriptions in the Excel spreadsheet
Current salary type
Salary type text
Salary type for decentralized recording
400
Overfører feriefri år-1 dage
(Transferring holiday free, year -1, days)
310
400
Overfører feriefri år-1 timer
(Transferring holiday free, year -1, hours)
311
400
Overfører feriefri år-1 beløb
(Transferring holiday free, year – 1, amount)
312
400
Overfører afspadsering, år-1 timer
(Transferring time off, year -1, hours)
313
401
Overfører omsorgdage år-1
(Tranferring days of compassionate leave, year –1)
314
401
Overfører omsorgtimer år-1
(Transferring hours of compassionate leave, year –1)
315
401
Overfører aftalefridage år-1
(Transferring appointment free days, year –1)
316
401
Overfører aftalefritimer år-1
(Transferring appointment free hours, year –1)
317
865
Overfør ikke afholdt ferie dage
(Do no transfer used holiday – days)
318
865
Overfør ikke afholdt ferie timer
(Do not transfer used holiday – hours)
319
4280
Overfør ikke afholdt ferie dage
(Do no transfer used holiday – days)
4278
4280
Overfør ikke afholdt ferie timer
(Do not transfer used holiday – hours)
4279
4410
Feriefri til Fritvalgskonto – henterPer9905/Res100 (Holiday free for Options account – gets Per9905/Res100)
4410 – number of hours
4410
Korrektion af feriefridage (Correction of supplementary holiday - days)
3800
4410
Korrektion af feriefritimer (Correction of supplementary holiday - hours)
3801
4410
Korrektion af feriefribeløb (Correction of supplementary holiday – amount)
3804
4412
Feriefri til Fritvalgskonto – timer * sats (Holiday free for Options account – hours * rate)
4412 - Number of hours and rate
4412
Saldokorrektion af feriefridage (Balance correction supplementary holiday – days)
3800
4412
Saldokorrektion af feriefritimer (Balance correction of supplementary holiday – hours)
3801
4412
Saldokorrektion af feriefribeløb (Balance correction supplementary holiday – amount)
3804
600
Saldokorrektion feriedage/kr.
(Balance correction holiday/DKK)
510 – provide year
600
Saldokorrektion feriedage/kr.
(Balance correction holiday/DKK)
511 - current year
605
Saldokorrektion ferietimer/kr.
(Balance correction holiday hours/DKK)
512 – provide year
605
Saldokorrektion ferietimer/kr.
(Balance correction holiday hours/DKK)
513 – current year
606
Saldokorrektion feriedage optjent i år (Balance account – number of days of holiday accumulated this year)
514
606
Saldokorrektion feriedage/saldo i år (Balance correction – days of holiday/balance this year)
515
606
Saldokorrektion ferietimer optjent i år (Balance correction – hours of holiday accumulated this year)
516
10. MLE-45-ERIN (Reminder)
You can create and modify reminder by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), and DATO (DATE)
You can change the following fields by using Decentralized recording:
ERINDRINGSTEKST (REMINDER TEXT)
Case
18;1;MLE-45-ERIN;3;01082008;1;Jubilæum 2018
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-45-ERIN
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
Dato (Date)
8
D K
Format: DDMMYYYY
6
F
Modtager (Recipient)
1
N K
0=Kundeforhold (Customer ID) 1=Arbejdsgiver (Employer)
Only use 1 = Arbejdsgiver (Employer)
7
G
Erindringstekst (Reminder text)
30
X
For deletion of ’erindringstekst’ (reminder text), enter ’%’ into the field.
11. MLE-50-ANSO (Employment information for statistics)
Employment information can be created, modified and be accounted for an accruals basis by
using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), IP TYPE, IP CODE and STARTDATO (START DATE).
You can change the following fields by using Decentralized recording:
IP-TYPE (IP TYPE), IP-KODE (IP CODE), SLUTDATO (END DATE), VÆRDI (VALUE)
Case
18;1;MLE-50-ANSO;3;300;412110;;01082008
18;1;MLE-50-ANSO;3;800;4;;01082008
18;1;MLE-50-ANSO;3;600;99999;30.00;01082008
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-50-ANSO
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
IP-type
(IP type)
6
N K
6
F
IP-kode
(IP code)
6
N K
Populated with 99999 if IP type 600, 610, 620.
7
G
Value
9
N
Blank, 0 or positive
Can only be populated with IP-type 600, 610, 620. Format: 999999.99
8
H
Startdato
(Start date)
8
D K
Format: DDMMYYYY
9
I
Slutdato
(End date)
8
D
Format: DDMMYYYY
12. MLE-55-FRAV (Absence registrations)
You can create, modify and delete recoding of absence by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), STARTDATO (START DATE), and
FRAVÆRSKODE (ABSENCE CODE)
You can change the following fields by using Decentralized recording:
SLUTDATO (END DATE), BETEGNELSE (DESIGNATION), VARIGHED (DURATION), and
SATS (RATE)
On deletion, the following fields should always be provided:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), STARTDATO (START DATE), SLUTDATO
(END DATE), and FRAVÆRSKODE (ABSENCE CODE)
Case
18;1;MLE-55-FRAV;10078;12082008;13082008;40;Ferie i august;2
18;1;MLE-55-FRAV;987;14082008;14082008;18;Dagpenge;7.5;125
18;1;MLE-55-FRAV;992;02012008;02012008;40;;;;9
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-55-FRAV
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
Startdato
(Start date)
8
D K
Format: DDMMYYYY
6
F
Slutdato
(End date)
8
D M
Format: DDMMYYYY
7
G
Fraværskode (Absence code)
4
N K
8
H
Betegnelse (Designation)
30
X
9
I
Varighed (Duration)
10
N
Blank, 0 or positive
Format: 0-9999999.99
10
J
Sats (Rate)
10
N
Blank, 0 or positive
Format: 0-9999999.99
11
K
Sletmarkering (delete selection)
1
N
Blank, or 9 = delete absence
13. MLE-60-EIND (eIncome – Danish public authority)
eIncome fields may be created, modified or be accounted for on an accruals basis by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), RUBRIK (HEADER), KODE (CODE), and
STARTDATO (START DATE)
Case
18;1;MLE-60-EIND;3;10;0;01082008
18;1;MLE-60-EIND;3;11;0;01082008
18;1;MLE-60-EIND;4;66;0;15082008;;5000
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-60-EIND
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
Rubrik (Header)
4
N K
6
F
Kode (Code)
6
N K
7
G
Startdato (Start date)
8
D K
Format: DDMMYYYY
8
H
Slutdato
(End date)
8
D
Format: DDMMYYYY
9
I
Værdi (Value)
11
N
Blank, 0 or positive
Format: 0-9999999.99
10
J
Tekst (Text)
58
X
14. MLE-65-GREK (Re-ordering of ’eSkattekort’)
You can create a new request for eTaxcard by using Decentralized recording.
The following fields are key fields:
KUNDEFORHOLD (CUSTOMER ID), ARBEJDSGIVER (EMPLOYER), IDENTIFIKATION
(IDENTIFICATION), MEDARBEJDER (EMPLOYEE), STARTDATO (START DATE), and
SKATTEKORTTYPE (TAX CARD TYPE)
Case
18;1;MLE-65-GREK;1;01082008;H
18;1;MLE-65-GREK;2;15082008;H
Record format:
Field No.
Excel Column
Name
No. of characters
Type
Value
Description
1
A
Kundeforhold (Customer ID)
6
N K
KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)
2
B
Arbejdsgiver (Employer)
6
N K
ARBEJDSGIVERNUMMER (EMPLOYER NUMBER)
3
C
Identifikation (Identification)
11
X K
MLE-65-GREK
Record ID
4
D
Medarbejder (Employee)
15
N K
MEDARBEJDERNUMMER (EMPLOYEE NUMBER)
5
E
Startdato
(Start date)
8
D K
Format: DDMMYYYY
6
F
Skattekorttype (Tax card type)
1
X K
H or B
H = Hovedkort
(Tax rate and deduction card)
B = Bikort (Secondary card)
Vis hele artiklen
