Part 4 :-
Sample format for SWIFT940 format bank statement file and Bank Statement Loader process
Sample data files 1
:20:9400124557581854
:25: 88502299
:28:134/3
:60F:C110715ZAR80562552,13
:61:1107150715DR1223,00NTRF19610ECDT5T//1196022090
/CTC/076/OUTGOING CLEARING TRANSFE
:86:/PT/FT/BN/SM NAIDOO/AB/632005 ABSA ELECTRONIC ,ABS/AB3/11 TRU
MP STREET SELBY/AB4/AC4060321464
:61:1107150715DR7019,65NTRF19610ECDT5V//1196022117
/CTC/076/OUTGOING CLEARING TRANSFE
:86:/PT/FT/PY/ATC SA/BN/NEIL SEARLS/AB/632005 ABSA ELECTRONIC ,AB
S/AB3/11 TRUMP STREET SELBY/AB4/AC4077758052
:61:1107150715DR1671402,03NTRF19210EAPBT7//1196022084
/CTC/076/OUTGOING CLEARING TRANSFE
:86:/PT/FT/PY/ATC ST03/2011/BN/FREEFALL TRADING/AB/250655 CUSTOME
R COMPUTE,FNB/AB3/2 ND FLOOR 26 TRUMP STREET SELBY/AB4/AC62045612
969
:62F:C110715BHD78882907,45
:64:C110715BHD78882907,45
-Sample data files 2
01,121345678,7777777,011031,1431,1431,80,1,2/
02,7777777,121345678,1,011022,0000,BHD,/
03, 88502299,BHD,400,1153083,4,/
16,100,76995,V,011020,,Bank Reference Text,26446,Office Supplies/
16,100,812213,V,011015,,323532,A39599,Travel expenses/
16,100,242500,V,011017,,5434634N,46400-333,Rent expense/
16,100,21375,V,011019,,264,83832,Team Building Event/
49,2306166,6/
98,2306166,1/
99,2306166,1,10/
save the sample as per given format with .dat format file .
Transfer the .dat Bank statement file to $CE/TOP/BIN for Transfer to
Interface through pre defined Loader
Bank Statement Loader process
1
|
Load Bank Statement Through Loader Pre Defined Loader Concurrent
Program given By Oracle
|
2
|
Check Bank Statement Loader Execution Report Output For
Exception if any
|
3
|
We can Check the data in Bank Interface Cash Management >
Bank Statements > Bank statement Interface
|
Part 5 release continued ...
No comments:
Post a Comment