Where to populate transaction number in MT940 file
Hi,
We are using bank statement mapping template similar to Standard, only difference is date format change. After running the Bank Statement Loader program the bank statement is generated in Interface.
Following is the mapping details in Mapping template:
Column Name | Rec Id | Position |
STATEMENT_NUMBER | 28 | 1 |
BANK_ACCOUNT_NUM | 25 | 1 |
STATEMENT_DATE | 62 | 3 |
CONTROL_BEGIN_BALANCE | 60 | 5 |
CONTROL_END_BALANCE | 62 | 5 |
CURRENCY_CODE | 60 | 4 |
TRX_DATE | 61 | 1 |
TRX_CODE | 61 | 6 |
AMOUNT | 61 | 5 |
TRX_TEXT | 61A | 1 |
BANK_TRX_NUMBER | 61A | 1 |
CUSTOMER_TEXT | 61 | 7 |
BANK_ACCOUNT_TEXT | 61 | 8 |
date format :
|
Bank File format Type SWIFT940
Control file SWIFT940.ctl
Bank statement file contents:
{1:F01ERNAKULAM}
{2:I940Bank of India}
{4:
:20:12345
:25:850220100003073
:28:005
:60:DR010118INR0,00