SWIFT940 Bank Statement Loading & Reconciliation Process in Oracle Cash Management, Part 3.
Part 3 :-
Bank statement mapping in oracle cash management
STATEMENT MAPPING LINES
Rec Id
|
Position
|
Format
|
Concatenate Format
|
Include Indicator?
|
Desc Flex
|
|
STATEMENT_NUMBER
|
||||||
BANK_ACCOUNT_NUM
|
||||||
LINE_NUMBER
|
||||||
TRX_DATE
|
61
|
1
|
||||
TRX_CODE
|
61
|
6
|
||||
EFFECTIVE_DATE
|
||||||
AMOUNT
|
61
|
5
|
||||
CURRENCY_CODE
|
61A
|
1
|
/OCMT/(aaa)
|
|||
USER_EXCHANGE_RATE_TYPE
|
||||||
EXCHANGE_RATE_DATE
|
||||||
EXCHANGE_RATE
|
61A
|
1
|
/EXCH/(aaa)
|
|||
TRX_TEXT
|
61A
|
1
|
||||
INVOICE_TEXT
|
61A
|
1
|
/INV/(~),/REMI/(~)
|
|||
BANK_TRX_NUMBER
|
61
|
8
|
||||
ORIGINAL_AMOUNT
|
61A
|
1
|
/OCMT/EUR(~),/OCMT/USD(~),/OCMT/SEK(~)
|
|||
CHARGES_AMOUNT
|
61A
|
1
|
/CHG1/EUR(~),/CHG1/USD(~),/CHG1/SEK(~)
|
|||
CUSTOMER_TEXT
|
61A
|
1
|
/BENM/NAME/(~)
|
|||
BANK_ACCOUNT_TEXT
|
61
|
8
|
||||
PRECISION
|
Part 4 release continued ...
No comments:
Post a Comment