Bulk Journal Take-on Layout (Annuity Migration)

Field Name

Field Size

DEC

ATTR

O/M

Start

End

Description / Value

1

FundNumber

7

Char

M

1

7

Scheme code.

Left aligned.

No leading zeroes

2

Portfolio Code

8

Char

O

8

15

Portfolio Number.

3

Member Number

20

Char

M

16

35

Member reference number.

Left aligned. No leading zeroes

4

Monetary Amount

11

2 

Char

M

36

46

Amount. 

Must have leading zeroes.

No Actual decimal but last two characters represents the cents.

5

Due date

8

Num

M

47

54

Due date of Transaction.

6

Effective Date

8

Num

M

55

62

Effective Date of Transaction.

7

Transaction Date

8

Num

M

63

70

Actual Date the amount was paid.

8

Income Type

5

Char

M

71

74

Benefit Product Code

9

Unit Value

15

5

Num

O

75

89

The value by which you want to reduce or increase the unit value. 

10

Unit Value Sign

1

Char

M

90

90

+ or - 

Always use +

11

Process

15

Char

M

91

105

The accounting process that is applicable.

12

Accounting Activity

15

Num

M

106

120

Use “YTD PENSION” for the Annuity YTD

“YTD PEN TAX” for the Tax YTD

13

PAY CENTRE

15

Num

M

121

135

Pay Centre of the Scheme.

14

Benefit Event

50

2

Num

M

136

185

Use spaces

15

Debit Bank Account

16

Char

C

186

201

Bank account number to debit.

16

Credit Bank Account

16

Char

C

202

217

Bank account number to credit.

17

Payee Name

50

Char

O

218

267

Surname and initials of member

18

Payment Type

15

Char

O

268

282

For Migration default to “CHEQUE”.

19

Document Number

25

Char

O

283

307

Special Sequence Number.

20

Document Number Chained

25

Char

O

308

332

Special Sequence Number.

21

Secondary Member Number

15

Char

O

333

347

Secondary Membership Number