Home > Bank Interfaces > Business Internet Banking (BIB) > BIB Bank Statement Upload
The uploading of files of bank account transactions in the SAP MT940 export format will be manually exported from the Business Internet Banking (BIB) application and uploaded into Vision. The batch job used is JU2BB_BIB_BNK_STMNT_UPLOAD
A file will be created in the format shown in the table below. The information in the system field column relates to the field on the Bank Statement record that must be updated with the value on the file when the file is uploaded.
|
SIF FIELD |
FIELD DESCRIPTION |
FORMAT |
SYSTEM FIELD |
|
:20: |
Statement Date |
YYYYMMDD |
|
|
:25: |
Account Identification |
Bank ID/account number |
Bank Account Number. Update with the value after the / |
|
:28: |
Statement and/or sequence number |
Statement date year and Julian Date / sequential number e.g. first statement on 15.07.2004 = 20196/01 |
Statement Number |
|
:60F: |
Opening Balance |
D for Debit or C for Credit |
|
|
Date |
|
||
|
Currency Code |
|
||
|
Opening Balance with a comma as the decimal point |
|
||
|
:61: |
Statement line field |
Date (YYMMDD) |
Actual Transaction Date Business Effective Date |
|
Date (MMDD) |
|
||
|
Debit/Credit (D = Debit, C = Credit, RD = Reverse Debit, RC = Reverse Credit) |
|
||
|
Funds code |
|
||
|
Transaction Amount |
Monetary Amount If value for Debit/Credit is D or RC multiply by -1 |
||
|
Transaction type identification code: NCHK = Cheque, F plus TLA code e.g. FTFR for UK Same Day and International |
Payment Type - If value for Transaction Type is NCHK then update it with CHEQUE - If value for Transaction Type is FTFR then update it with EFT - If value for Transaction Type is neither NCHK or FTFR then do not update Payment Type |
||
|
Account owner reference: Cheques number for cheques, NONREF for other transaction types |
- If Transaction Type is NCHK then update Document Number. - If Transaction Type is FTFR then ignore |
||
|
Originating bank’s own reference: // |
|
||
|
:86: |
Information to account holder |
- if there is no narrative then 999 - if a cheques then 999/00 followed by up to 59 alphanumeric characters - otherwise 999/00 followed by the transaction type code, followed by any narrative up to 56 alphanumeric characters |
If Transaction Type is FTFR then update Document Number with the first 7 characters of the value following the transaction type e.g. if the value is 999/00FTFR1234567 then update the Document Number with the value of 1234567. |
|
:62: |
Closing Balance |
D (Debit) or C (Credit) |
|
|
Date (YYMMDD) |
Actual Transaction Date Business Effective Date |
||
|
Currency Code |
|
||
|
Amount, with a comma making the decimal point |
Account Balance If value for Debit/Credit is D multiply by -1 |