Decentralized recordings (english)

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.

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.

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.

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

DDMMYYXXXX

A Modulus 11 check is performed on the field. Fictitious civil reg. numbers xxxxxx9991 or xxxxxx9992 are valid. If cpr.nr. is ficitionous field 19 and 21 must have ’Nej’ for No. 

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
(M)

For deletion of e-mail enter % into the field.

(M – if mit.dk = Nej)

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 (Request tax card type)

1

X

H = Main taxcard

B = Secondary taxcard

Blank =  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 new tax card request.

18

R

Request date

8

D

The effective date of the e-tax card. Format: DDMMYYYY

19

S

mit.dk

3

X

Ja / Nej or Blank

Ja/Nej (yes/no) to Danish mit.dk must be indicated.

Ja = Mit.dk 
Nej = mitBasic and additional email address must be created in column N 
Blank = Ja (Yes)

20

T

Initials

10

X

Initial of employee

21

U

Nemkonto

3

X

Ja or Blank

Ja (yes) or blank. Danish NemKonto

22

V

Lønanciennitet

8

X

The employee’s Seniority date. Format: DDMMYYYY

23

W

TIN

27

X

TIN can consist of letters, numbers and characters

If the employee resides abroad (including Greenland and the Faroe Islands), the TIN must be provided. The TIN must comply with a specific format.

For deletion of TIN enter % into the field.

Field no.

Excel column

Name

Length

Type

Value / Format

Description

1

A

Customer ID

6

Key Numeric
Mandatory

Customer ID is a fixed number created by Intega Løn

2

B

Employer

6

Key Numeric
Mandatory

3

C

Identification

11

Key Characters
Mandatory
Fixed value

MLE-27-HRME

4

D

Employee

15

Key Numeric
Mandatory

Employee number

5

E

CPR no.

10

Numeric
Mandatory

XXXXXXXXXX

A Modulus 11 check is performed on the field. Fictitious civil reg. numbers xxxxxx9991 or xxxxxx9992 are valid. If cpr.nr. is ficitionous field 19 and 21 must have ’Nej’ for No. 

Value x must include a valid date. Format XXXXXXXXXX

6

F

CVR no.

8

Numeric
(Mandatory)

XXXXXXXX

A Modulus 11 check is performed on the field. The field is left blank if the CPR no is provided. The field is only populated if the value provided for the CPR no is 0 (zero). Format: XXXXXXXX

7

G

Last name

30

Characters
(Mandatory)

Mandatory for creating a new employee

8

H

First name

30

Characters
(Mandatory)

Mandatory for creating a new employee

9

I

Address 1

30

Characters
(Mandatory)

Mandatory for creating a new employee

10

J

Address 2

30

Characters

Can be deleted by entering % into the field

11

K

Postal code

9

Characters
(Mandatory)

Mandatory for creating a new employee
Danish postal code validation if country code is not provided or provided with ’DK’. Otherwise no check.

12

L

Foreign postal district

30

Characters
(Mandatory)

Mandatory if the employee has a foreign address. Otherwise left blank. Is deleted automatically if the country code is changed to ’DK’.

13

M

First time employment

8

Date
(Mandatory)

DDMMYYYY

Mandatory for creating a new employee
Format: DDMMYYYY

14

N

E-mail

50

Alphanumeric
(Mandatory)

Can be deleted by entering % into the field The field is mandatory if payslip is send to mitBasic

(mit.dk = Nej)

15

O

Country code

2

Characters
(Mandatory)

Mandatory for creating a new employee.
If the employee has a foreign address a value should always be provided for this field
If left blank the code will automatic be set to DK

16

P

Seniority

6

Numeric

YYMMDD

The length of the employee’s employment in number of years months and days
Can be deleted by entering % into the field
Format: YYMMDD

17

Q

Request tax card type

1

Characters

H = Hovedkort (taxrate and deduction card)
B = Bikort (secondary taxcard)

A tax card can only be requested when creating a new employee. 
If an existing employee having a new salary number is created the field must be left blank

18

R

Request date

8

Date

DDMMYYYY

The effective date of the e-tax card.
If no tax card i requested the field must be left blank

19

S

Mit.dk

3

Characters
(Mandatory)

Ja, Nej or blank

Ja/Nej (yes/no) or blank to Danish Mit.dk or mitBasic

Ja = Mit.dk

Nej = mitBasic and additional email address must be created in column N and V

Blank = Ja (Yes)

20

T

Initials

10

Characters

21

U

NemKonto

3

Characters

Ja, Nej or blank

Ja (yes), Nej (No) or blank to Danish NemKonto

22

V

E-mail (Private)

50

Characters

(Mandatory)

Can be deleted by entering % into the field

23

W

Birthdate

8

Date

DDMMYYYY

MEDARBEJDER.FOEDSELSDAG
Can be deleted by entering % into the field

24

X

Gender

1

Numeric

0 = Female
1 = Male

MEDARBEJDER.KOEN

25

Y

Citizenship

2

Characters

Same as country code

STATSLANDEKODE
If left blank the code will automatic be set to DK
Can be deleted by entering % into the field

26

Z

Nationality

2

Characters

Same as country code

FOEDELANDEKODE
If left blank the code will automatic be set to DK
Can be deleted by entering % into the field

27

AA

Default absence calendar

6

Numeric

DEFAULTKALENDERKODE
Can be deleted by entering % into the field

28

AB

Comment

60

Characters

KOMMENTAR
Can be deleted by entering % into the field

29

AC

Nickname

50

Characters

KALDENAVN
Can be deleted by entering % into the field

30

AD

Foreign CPR no

20

Characters

CPRNRUDLAND
Can be deleted by entering % into the field

31

AE

Payment seniority

8

Date

DDMMYYYY

Date of seniority to calculate payments

32

AF

TIN

27

X

TIN can consist of letters, numbers and characters

If the employee resides abroad (including Greenland and the Faroe Islands), the TIN must be provided. The TIN must comply with a specific format.

For deletion of TIN enter % into the field. 

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 

 

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 system. 

Format: DDMMYYYY

9

I

Stillingskategori (Position category)

4

N M

E.g. monthly or hourly paid employee.

10

J

Ansættelsesbetegnelse (Employment designation or jobtitle)

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

Number of work days per week, maks 8

Only feasible for companies in the financial trade. 

Field no.

Excel column

Name

Length

Type

Value

Description

1

A

Customer ID

6

Key
Numeric

Customer ID is a fixed number created by Intega Løn

2

B

Employer

6

Key
Numeric

3

C

Identification

11

Key
Characters

MLE-32-HRAN

4

D

Employee

15

Key
Numeric

Employee number

5

E

From date

8

Date
(Mandatory)

DDMMYYYY

Must be blank in case of Termination

6

F

Commencement date

8

Date

Is not applied.

7

G

Termination code

1

Numeric
(Mandatory)

3 = Monthly paid
4 = Hourly paid
8 = Employee without holiday pay

Mandatory in case of Termination. 
When populating this field the From date field must NOT be populated. 
In case of reemployment enter % into the field.

8

H

Termination date

8

Date
(Mandatory)

DDMMYYYY

Mandatory in case of Termination.

9

I

Position category

4

Numeric
(Mandatory)

Mandatory in case of new hire

10

J

Title

30

Characters

Can be deleted by entering % into the field

11

K

Standard time per month

6

Numeric
(Mandatory)

999.99

Mandatory in case of new hire
Must be 0 (zero) in case of Hourly paid

12

L

Standard time
Company agreement

6

Numeric
(Mandatory)

999.99

Mandatory in case of new hire

13

M

Salary group

6

Characters
(Mandatory)

Mandatory in case of new hire

14

N

Cost Center

6

Characters

Case sensitive. Department must be created before entering on employment
Can be deleted by entering % into the field

15

O

Subsection

6

Characters

Case sensitive. Subsection must be created before entering on employment
Can be deleted by entering % into the field

16

P

Association code

5

Numeric

Can be deleted by entering % into the field

17

Q

Afv. Pnr.

10

Numeric

XXXXXXXXXX

Modulus check of field contents
Can be deleted by entering % into the field

18

R

Chart of accounts

2

Characters

Checks for existence of loaded chart of accounts
Can be deleted by entering % into the field

19

S

Optional 1

10

Alphanumeric

Can be deleted by entering % into the field

20

T

Optional 2

10

Alphanumeric

Can be deleted by entering % into the field

21

U

Optional 3

10

Alphanumeric

Can be deleted by entering % into the field

22

V

Optional 4

10

Alphanumeric

Can be deleted by entering % into the field

23

W

Optional 5

10

Alphanumeric

Can be deleted by entering % into the field

24

X

Optional 6

10

Alphanumeric

Can be deleted by entering % into the field

25

Y

Lønramme

6

Characters

Blank

26

Z

Løntrin

6

Characters

Blank

27

AA

Rykkode1

6

Characters

Blank

28

AB

Rykkode2

6

Characters

Blank

29

AC

Rykkode3

6

Characters

Blank

30

AD

Næsterykdato1

8

Date

Blank

31

AE

Næsterykdato1

8

Date

Blank

32

AF

Næsterykdato1

8

Date

Blank

33

AG

Autoryk1

1

Characters

Blank

34

AH

Autoryk2

1

Characters

Blank

35

AI

Autoryk3

1

Characters

Blank

36

AJ

Working days per week

1

Numeric

Blank

Can only be used in Intega Løn for companies in the financial trade

37

AK

Deviation in type of payment

12

Characters

Bagudløn (paid in arrears)
Forudløn (paid in advance)

If the employee should have another type of payment than registered on the position category

38

AL

No of work function

6

Numeric
Mandatory

Number of work function set up in Intega HR table

39

AM

Deviation in holiday type

2

Characters

J = Yes to deviation 
N = No to deviation

If the employee should have another calculation of holiday than is setup on the position category

40

AN

Deviation in location

1

Numeric

41

AO

Position

50

Characters

STILLING

42

AP

Internal position code

5

Characters

INTERNSTILLINGSKODE

43

AQ

Type of position

5

Characters

STILLINGSTYPEKODE

44

AR

Change reason code

5

Characters

AENDRINGSAARSAGSKODE

45

AS

Internal title code

5

Characters

INTERNTITELKODE

46

AT

Work settlement code

5

Characters

ARBEJDSORDNINGKODE

47

AU

Educational requirement code

6

Numeric

UDDANNELSESKRAVKODE

48

AV

Extra Termination time Person

2

Numeric

Number of months

EKSTRAOPSIGPERSONMAANED

49

AW

Extra Termination time Company

2

Numeric

Number of months

EKSTRAOPSIGFIRMAMAANED

50

AX

Seniority for Termination

8

Date

DDMMYYYY

ANCIENNITET2

51

AY

Seniority for anniversary

8

Date

DDMMYYYY

JUBILAEUM2

52

AZ

Cause of Termination

10

Characters

FRATRAEDELSESAARSAGSKODE

53

BA

Department ID

9

Numeric

DEPARTMENTID

54

BB

Type of employment

5

Characters

ANSATTYPEKODE

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

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 eller 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 OBS

Applied for input allocation

28

AB

Kontoplanfelt2 (Chart of accounts field)

20

X

*See OBS

Applied for input allocation

29

AC

Kontoplanfelt3 (Chart of accounts field)

20

X

*See OBS

Applied for input allocation

30

AD

Kontoplanfelt4 (Chart of accounts field)

20

X

*See OBS

Applied for input allocation

31

AE

Kontoplanfelt5 (Chart of accounts field)

20

X

*See OBS

Applied for input allocation

32

AF

Kontoplanfelt6 (Chart of accounts field)

20

X

*See OBS

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.

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

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.

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

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

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

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)

Field No.

Excel column

Name

No. of characters

Type

Value

Description

1

A

Kunderforhold (Customer ID)

6

N K

KUNDEFORHOLDSNUMMER (CUSTOMER ID NUMBER)

2

B

Arbejdsgiver (Employer)

6

N K

ARBEJDSGIVERNUMMER (EMOLOYEE NUMBER)

3

C

Identifikation (identification)

11

X K

MLE-70-SKAT

Record ID

4

D

Medarbejder (employee)

15

N K

MEDARBEJDERNUMMER (EMPLOYEE NUMBER)

5

E

Skattekorttype (Taxcard type)

1

X K

H, K, F or B

H for hovedkort (main)
K for Bruttokort
F for Frikort 
B for Bikort

6

F

Amount

9

N

FRADRAGMÅNED (DEDUCTION PR. MONTH)

7

G

Frikort amount

9

N

FRIKORTBELØB (AMOUNT IN TOTAL)

8

H

Percentage

3

N K

TRAEKPROCENT (PERCEMTAGE)

9

I

Start date

8

D K

Format: DDMMÅÅÅÅ

10

J

End date

8

D K

Format: DDMMÅÅÅÅ

11

K

Ekstratraek

2

N

EKSTRATRAEK (PERCENTAGE)

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 (Identifacation)

11

X K

MLE-80-TLF

Record ID

4

D

Medarbejder (Employee)

15

N K

MEDARBEJDERNUMMER (EMPLOYEE NUMBER)

5

E

Phone number

20

X

Phone number

6

F

Local

4

X

Local number

7

G

Text

10

X

Name