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