BR100 Cash Management 0 1

AIM

BR.100 APPLICATIONS SETUP Oracle Cash Management

Author Crea Creat! t!on on "ate ate

#ul$ #ul$ 1%& '01( '01(

Last U)*ate* "ocument Re+ ,ers!on

0.1

Approvals:

-A))roer 1/ -A))roer '/

Co)$ Num umer

 

1

Document Control Change Record ( Date

Author

Versio n

Change ReferenCM

1.0

Reviewers

Name

Position

Note To Holders:

I+ $ou reCM!e an electron!c co)$ o+ th!s *ocument an* )r!nt !t out& )lease 2r!te $our name on the e3u!alent o+ the coer )age& +or *ocument control )ur)oses. I+ $ou reCM!e a har* co)$ o+ th!s *ocument& )lease 2r!te $our name on the +ront coer& +or *ocument control )ur)oses.

'

Contents

"ocument Control....................................................................................... CM "e4ne S$stem Parameters................................................ .................. CM "e4ne Pa$ment Tem)late................................................................... CM "e4ne Pa$ment Tem)late................................................................. CM "e4ne Ban5 Co*es............................................................................. CM "e4ne Ban5 Statement Ma))!ng....................................................... O)en an* Close* Issues +or th!s "el!erale............................................. O)en Issues......................................................................................... Close* Issues.......................................................................................

(

CM: Dene !"stem Parameters Cash Management#!etup#!"stem#!"stem Parameters Description: Use th!s +orm to *e4ne S$stem Parameters +or cash management. The s$stem )arameters are o)erat!ng un!t s)ec!4c an* so th!s set u) has to e *one +or each Legal Ent!t$.

!"stem Parameters $egal %ntit" $edger &egin Date

!"stem Controls !how Cleared Transactions !how Void Pa"ments Allow Adding $ines to 'mported !tatement

 6es  6es  6es

!igning Authorit" Approval Archive Purge

$ines per Commit

Cash Management Transactions %(change Rate T"pe

Cor)orate

Manuall$ Controlle* Unchec5e*   Chec5e*

1

&an) !tatement Cash *ow Rate Date &an) Transfer Rate Date Authori+ation

Cash 7lo2 "ate

 Trans+er "ate Not Re3u!re*

8

CM: Dene Pa"ment Template Cash Management#!etup#!"stem# Pa"ment Template Description: Use th!s +orm to *e4n e Pa$ment Tem)late +or Ban5 Trans+er Transact!ons. ,-eneral Details# ./ Pa"ment to D01 Template Code Repetitive Code

Transaction !u2t"pe

 6es

Currenc" Transfer Amount Description

Authori+e Transaction !ettle Transaction

9 9

Comments !tatus

!ourCM &an) Account

Destination &an) Account

&an) Account Num2er

&an) Account Num2er

&an) Account Name

&an) Account Name

&ranch Name

&ranch Name

&an) Name

&an) Name

$egal %ntit"

$egal %ntit"

 Ban5 Trans+er  No  No  NIL   Act!e

%

,Pa"ment Details# Pa"ment Method Pa"ment Reason  Pa"ment Reason Comments

:!re  9

Anticipated Value Da"s &an) Charge &earer

9 9

9

,-eneral Details# 3/ Receipts 1rom D01 Template Code

Transaction !u2t"pe

Repetitive Code

Authori+e Transaction

Currenc"

!ettle Transaction

Transfer Amount

Comments

Description

!tatus

!ource &an) Account

Destination &an) Account

&an) Account Num2er

&an) Account Num2er

&an) Account Name

&an) Account Name

&ranch Name

&ranch Name

&an) Name

&an) Name

$egal %ntit"

$egal %ntit"

;

,Pa"ment Details# Pa"ment Method Pa"ment Reason  Pa"ment Reason Comments

:!re  9

Anticipated Value Da"s &an) Charge &earer

9 9

9

<

CM: Dene Pa"ment Template Cash Management#!etup#!"stem# Transaction !u2t"pe Description: Use th!s +orm to *e4ne Transact!on Sut$)e +or Ban5 Trans+er Transact!ons. !u2t"pe Name

Description

!hort Name

!tatus

!u2t"pe Parent Name

10

CM: Dene &an) Codes !etup#&an)s#&an) Transaction Codes 4!elect the &an) Account Num2er5 Description: Th!s !n+ormat!on !s re3u!re* onl$ 2hen an5 !nter+aCM !s use* to u)loa* Ban5 statements. T"pe

Code

Description

%6ectiv e Dates: !tart

%6ectiv e Dates: %nd

1loat Da"s

Trans !ourCM

Reconciliati on !e7uenCM

Pa$ment

1

AP Pa$ments

1

Rece!)t

'

AR Rece!)ts

1

Matching Agent

Correction Method

C rea te

A ct iv it "

Pa" me nt Method

11

CM: Dene &an) !tatement Mapping !etup#&an)s#&an) !tatement Mapping 4Header 'nformation5 Name

BAI'

%na2led

Chec5e*

Description

Ma))!ng tem)late +or BAI'

Precision

 9

Control 1ile

BAI'.ctl

Timestamp 1ormat

 9

&an) 1ile 1ormat T"pe

BAI'

Date 1ormat

""MM66

,Header# Column Name

STATEMENTNUMBER BAN=ACCOUNTNUM STATEMENT"ATE BAN=NAME BAN=BRANC?NAME CONTROLBEINBALANCM CONTROLEN"BALANCM CONTROLTOTAL"R CONTROLTOTALCR CONTROL"RLINECOUNT CONTROLCRLINECOUNT CONTROLLINECOUNT C?EC="IITS PRECISION A,AILABLEBALANCM ,ALUE"ATE"BALANCM A,ERAECLOSELE"ERMT" A,ERAECLOSELE"ER6T" A,ERAECLOSEA,AILABLEMT" A,ERAECLOSEA,AILABLE6T" ONE"A67LOAT  T:O"A67LOAT STATEMENTTIMESTAMP

Rec 'd

' ' ' ' ' ' ' ' ' ' ' '

Position

1ormat

Concatenate 1ormat

'nclude 'ndicator8

Desc 1le(

1 ' ( > @ 8 % ; < 10 11 1'

!etup#&an)s#&an) !tatement Mapping 4$ine 'nformation5

1'

Name

%na2led

Description

Precision

Control 1ile

Timestamp 1ormat

&an) 1ile 1ormat T"pe

Date 1ormat

,$ines# Column Name

STATEMENTNUMBER BAN=ACCOUNTNUM LINENUMBER  TR"ATE  TRCO"E E77ECTI,E"ATE AMOUNT CURRENC6CO"E USEREC?ANERATET6PE EC?ANERATE"ATE EC?ANERATE  TRTET IN,OICMTET BAN=TRNUMBER

Rec 'd

Position

1ormat

18 18 18 18 18

1 ' > @ 8

18 18

; <

18

%

18

10

Concatenate 1ormat

'nclude 'ndicator8

Desc 1le(

ORIINALAMOUNT C?ARESAMOUNT CUSTOMERTET BAN=ACCOUNTTET PRECISION

1(

0pen and Closed 'ssues for this Delivera2le 0pen 'ssues 'D

'ssue

Resolution

Responsi2ilit"

Target Date

'mpact Date

Resolution

Responsi2ilit"

Target Date

'mpact Date

Closed 'ssues 'D

'ssue