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 10 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 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 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 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 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 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 = No 0 = Yes  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 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)