Organisation Unit Bank Account (File Layout)

Detail record

 

Field Name 

Field Size 

ATTR 

O/M 

Start 

End 

Description / Value 

1 

File indicator 

4 

Char 

M 

1 

4 

AB34

2 

Org_unit_code 

8 

Char 

M 

5 

12 

Organisation Unit Code 

3

Start_date 

8 

Num 

M 

12

20

CCYYMMDD - date from which the bank account is effective. 

4

R_DTI_ACCOUNT 

16 

Char 

O 

21

36

The bank account number. 

5

T_NAME 

50 

Char 

O 

37

86

The name of the bank account holder. 

6

C_UDPV_BANK_

ACC_TP 

15 

Char 

M 

87

101

The type of bank account.

BUILDING SOCIETY

CURRENT

CREDIT CARD

SAVINGS

TRANSMISSION 

7

F_MANDATE 

1 

Char 

M 

102

102

Value must be N 

8

R_LINE 

8 

Num 

M 

103

110

Only required if BANK INTERFACE = NEDINFORM. 

9

Organization Code 

6 

Char 

M 

111

116

The organization (e.g. bank) code.

Note: 

This will become unique in the system. 

10

Branch Code 

6 

Char 

M 

117

122

Bank branch code. 

11

C_UDPV_BANK_

INTERFACE 

15 

Char 

M 

123

137

The bank interface service that must be used for this bank account.  

CASHFOCUS 

NEDINFORM 

12

IBAN

34

Char

O

138

171

International Bank Account Number

13

SWIFT_ID

15

Char

O

172

186

SWIFT Bank Code ID

14

BS_ROLL_NO

35

Char

O

187

221

Building Society Roll Number

15

BANK_INTERFACE

15

Char

O

222

236

Bank Interface Type:

ACB

BARCLAYS KENYA

BARCLAYS ZAMBIA

BANK TRANSFER

BIB

BUREAUFOCUS

CASHFOCUS

FNB ONLINE

FNB PACS

IAT

IP

LDC

MULTIDATA

NEDINFORM

CPS 

SCT

SDP

SPD

 

Note:

Positions 1-3 of the last row must contain EOF, followed by a return character.

 

When the file is loaded, the system will check that the Organisation Unit Code is unique.  If not, the Bank Account Details will not be loaded for that Organisation Unit and an error message will be written to the error log.

 

For more details refer to Organisation Unit Bank Acc Upload under

Processes

File Transfer

Conversion

Uploading Files and Documents