Place.W-1 (importing data into indirect input lines)

The name of the file

Place.W-1

Module

Calculation of salaries for employees

File format

TEKST – ASCII

Notes

Each record ends with two special control characters CR and LF
Codes are written with leading zeros.

No.

Field name

Field type

Lenght

From

To

Field description

1

Employee code

Code

7

1

7

Data from the code book with leading zeros, e.g. 0001001

2

Billing type code (SAOP)

Code

3

8

10

Data from the code book with leading zeros, e.g. 001

3

Cost center code

Code

7

11

17

Data from the code book with leading zeros, e.g. 0000001

4

Cost object code

Code

7

18

24

Data from the code book with leading zeros, e.g. 0000002

5

Reference code

Code

7

25

31

Data from the code book with leading zeros, e.g. 0000003

6

Work order code

Text

20

32

51

Work order code, e.g. 123456

7

Customer code

Code

7

52

58

Data from the code book with leading zeros, e.g. 0000500

8

Number of units

Number

3 + 2

59

63

The number of units without a decimal point. For example 16000 for 160 hours.

9

Sign of the number of units

Sign

1

64

64

A sign for the number of units, eg "-". Entry is optional in the case of a positive sign.

10

Price per unit

Number

7 + 2

65

73

Price per unit without decimal point, e.g. 1995 for €19.95.

11

Unit price sign

Sign

1

74

74

Sign for unit price, eg "-". We do not need an entry in the case of a positive sign.

12

Percent

Number

3 + 2

75

79

A percentage without a decimal point, e.g. 12000 for 120%

13

The percent sign

Sign

1

80

80

Percentage sign, eg "-". We do not need an entry in the case of a positive sign.

14

Gross amount

Number

9 + 2

81

81

Gross amount without decimal point, e.g. 110095 for 1,100.95 €

15

Sign of the gross amount

Znak

1

92

92

Amount sign, eg "-". We do not need an entry in the case of a positive sign.

16

Period start date

Date

8

93

100

Period start date in yyyymmdd format, e.g. 20151201 for December 1st 2015

17

Period end date

Date

8

101

108

Period end date in yyyymmdd format, e.g. 20151231 for December 31st, 2015

18

Number of days of the period

Število

2

109

110

A positive number without a decimal point, e.g. 23 for 23 days.

Empty analytics are written with spaces - example in the third line.

If further data in the row is not relevant, the row can be completed earlier - example in the fourth row.
 
Example file place.W-1:

000100110100000010000002000000300000000000000123456000050016000-000001995-00000-00000110095-201512012015123123
000100210100000020000003000000400000000000000443316000050015000-000001395-00300-00000120000-201512102015121001
0001001101                                                16000-000001995-00000-00000110095-201512012015123123
0001001101                                                16000-

V tem prispevku