Detailed Specification of M-Tape (Magnetic Tape) 

Standard tenant record (magnetic tape): Record type M

Field

Charact.position

Length

Format

Field definit.

Contents

Comment

1

1

1

A

R

Record type

Content: R

2

2-8

7

N

A

Customer number

Number of the customer

3

9-10

2

N

A

Computer center number

 

4

11

1

N

R

Constants

Contents: 0

5

12-24

13

N

R

Classification key3)

Figures 12-13=00 / 14-16 County /17-20 order No./ 21-24 user No.

6

25-30

6

N

R

Begin of period settlement or move-in date in period of settlement

Format YYMMDD

During tenant changeover always the move-in date of the user

7

31-50

20

A-N

R

Customer classification key

Number of apartment, consumer or tenant account of user

8

51-75


76-77

25


2

A-N


A-N

O

2. User name


Constants

2: Line: Name of tenant, owner or invoice recipient

Content: blank 3)

9

78-102


103-104

25


2

A-N


A-N

R

1. User name


Constants

1: Line: Name of tenant, owner or invoice recipient

Content: blank 3)

10

105-129


130-131

25


2

A-N


A-N

O

Address: zip code, location

Constants

5 figures zip code / 21 figures, location name

Content: blank 3)

11

132-156


157-158

25


2

A-N


A-N

O

Address: street

Constants

Street name, blank character, house number


Content: blank 3)

12

159-170

12

N

R

Residential period in period settlement

Form DDMMYYDDMMYY (beginning -end)

If there is no change of user, the field must contain the settlement period

13

171

1

N

 

Description

1 = Direct debit procedure

14

172

1

N

O

Description for common room

2 = common rooms, or 0

15

173

1

N

O

Description

1 = No calculation of advance payment, otherwise 0

16

174

1

N

 

Description

Content: 0 3)

17

175

1

N

O

Description VAT

1 = VAT identifier (brutto on advance payments)

2 = VAT identifier (net on advance payments)

18

176

1

N

O

Description

1 or 3 = calculation apportionment loss risk, or 0

19

177

1

A-N

 

Description

Content: blank 3)

20

178

1

A-N

 

Description

Content: blank 3)

21

179

1

A-N

 

Description

Content: blank 3)

22

180

1

A-N

 

Description

Content: blank 3)

23/1

181-197

17

A-N

 

Reserves

Content: Blank

23/2

198-205

8

N

 

Last advance payment amount

Content: 0 3)

24

206-211

6

N

O

Basic share heating

4,2 figures

25

212-219

8

N

O

Advance payment heating or total advance payment

6,2 figures for heating, hot water and other items

26

220-225

6

N

O

Basic share hot water

4,2 figures

27

226-233

8

N

O

Advance payment hot water

6,2 figures

28

234-239

6

N

O

Basic share other items

4,2 figures

29

240-247

8

N

 

Advance payment for other items

Content: 0 3)

30

248-255

8

N

O

Flat-rate heating

6,2 figures

31

256-263

8

N

O

Flat-rate hot water

6,2 figures

32

264-271

8

N

 

Flat-rate other items

Content: 0 3)

33

272-279

8

N

 

Flat-rate cold water

Content: 0 3)

34

280-287

8

N

O

Back payments previous year

6,2 figures

35

288-295

8

N

O

Credit previous year

6,2 figures

36

296-303

8

N

 

Advance payment amount

6,2 figures

37

304-311

8

N

 

Amount

Content: 0 3)

38

312-350

39

   

Reserves

Content: blank 3)

1) Format

A = alphabetical data

B = numerical data

A-N = alphanumerical data

2) Field def.

R = Required field

O = Optional field

A = As agreed

3)

Standard record formats for the data exchange are developed by the appropriate institutions. The field lengths are the maximum ones allowed.

Positions and fields with the symbol 3) are not processed.