Part 2 :-
Bank statement mapping in oracle cash management
STATEMENT MAPPING HEADER
Rec Id
|
Position
|
Format
|
Concatenate Format
|
Include Indicator?
|
Desc Flex
|
|
STATEMENT_NUMBER
|
28
|
1
|
||||
BANK_ACCOUNT_NUM
|
25
|
1
|
||||
STATEMENT_DATE
|
62
|
3
|
||||
BANK_NAME
|
||||||
BANK_BRANCH_NAME
|
||||||
CONTROL_BEGIN_BALANCE
|
60
|
5
|
||||
CONTROL_END_BALANCE
|
62
|
5
|
||||
CONTROL_TOTAL_DR
|
||||||
CONTROL_TOTAL_CR
|
||||||
CONTROL_DR_LINE_COUNT
|
||||||
CONTROL_CR_LINE_COUNT
|
||||||
CONTROL_LINE_COUNT
|
||||||
CURRENCY_CODE
|
60
|
4
|
||||
CHECK_DIGITS
|
||||||
PRECISION
|
||||||
AVAILABLE_BALANCE
|
||||||
VALUE_DATED_BALANCE
|
||||||
AVERAGE_CLOSE_LEDGER_MTD
|
||||||
AVERAGE_CLOSE_LEDGER_YTD
|
||||||
AVERAGE_CLOSE_AVAILABLE_MTD
|
||||||
AVERAGE_CLOSE_AVAILABLE_YTD
|
||||||
ONE_DAY_FLOAT
|
||||||
TWO_DAY_FLOAT
|
||||||
STATEMENT_TIMESTAMP
|
Part 3 release continued ...
No comments:
Post a Comment