Payables and Cash Management - EBS (MOSC)

MOSC Banner

Where to populate transaction number in MT940 file

edited Aug 20, 2021 7:44AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

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 NameRec IdPosition
STATEMENT_NUMBER281
BANK_ACCOUNT_NUM251
STATEMENT_DATE623
CONTROL_BEGIN_BALANCE605
CONTROL_END_BALANCE625
CURRENCY_CODE604
TRX_DATE611
TRX_CODE616
AMOUNT615
TRX_TEXT61A1
BANK_TRX_NUMBER61A1
CUSTOMER_TEXT617
BANK_ACCOUNT_TEXT61

8

date format :

DDMMYY

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center