7/25/2019 BR100 Cash Management 0 1

1/13

AIM

BR.100 APPLICATIONSSETUP

Oracle Cash Management

Author

Creat!on "ate #ul$ 1%& '01(

Last U)*ate*

"ocument Re+

,ers!on 0.1

Approvals:

-A))roer 1/

-A))roer '/

Co)$ Numer

1

7/25/2019 BR100 Cash Management 0 1

2/13

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 coer )age& +or *ocument control )ur)oses.

I+ $ou reCM!e a har* co)$ o+ th!s *ocument& )lease 2r!te $our name on the +rontcoer& +or *ocument control )ur)oses.

'

7/25/2019 BR100 Cash Management 0 1

3/13

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!erale.............................................

O)en Issues.........................................................................................Close* Issues.......................................................................................

(

7/25/2019 BR100 Cash Management 0 1

4/13

CM: Dene !"stem Parameters

Cash Management#!etup#!"stem#!"stem ParametersDescription: 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 setu) has to e *one +or each Legal Ent!t$.

!"stem Parameters

$egal %ntit"

$edger

&egin Date

!"stem Controls

!how Cleared Transactions6es

!igning Authorit" ApprovalManuall$ Controlle*

!how Void Pa"ments6es

ArchiveUnchec5e*

Allow Adding $ines to 'mported!tatement

6esPurge

Chec5e*

$ines per Commit1

Cash Management Transactions

%(change Rate T"peCor)orate

7/25/2019 BR100 Cash Management 0 1

5/13

&an) !tatement Cash *owRate Date

Cash 7lo2 "ate

&an) Transfer Rate DateTrans+er "ate

Authori+ationNot Re3u!re*

8

7/25/2019 BR100 Cash Management 0 1

6/13

CM: Dene Pa"ment Template

Cash Management#!etup#!"stem# Pa"ment TemplateDescription: Use th!s +orm to *e4ne Pa$ment Tem)late +or Ban5 Trans+er Transact!ons.

,-eneral Details# ./ Pa"ment to D01

Template Code Transaction !u2t"peBan5 Trans+er

Repetitive Code6es

Authori+e TransactionNo

Currenc"

!ettle TransactionNo

Transfer Amount 9

CommentsNIL

Description 9

!tatus Act!e

!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"

%

7/25/2019 BR100 Cash Management 0 1

7/13

,Pa"ment Details#

Pa"ment Method:!re

Anticipated Value Da"s9

Pa"ment Reason9

&an) Charge &earer9

Pa"ment Reason Comments9

,-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"

;

7/25/2019 BR100 Cash Management 0 1

8/13

,Pa"ment Details#

Pa"ment Method:!re

Anticipated Value Da"s9

Pa"ment Reason9

&an) Charge &earer9

Pa"ment Reason Comments9

7/25/2019 BR100 Cash Management 0 1

9/13

CM: Dene Pa"ment Template

Cash Management#!etup#!"stem# Transaction !u2t"peDescription: Use th!s +orm to *e4ne Transact!on Sut$)e +or Ban5 Trans+er Transact!ons.

!u2t"pe Name Description

!hort Name !tatus

!u2t"pe Parent Name

10

7/25/2019 BR100 Cash Management 0 1

10/13

CM: Dene &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 %6ectiveDates:!tart

%6ective Dates:%nd

1loatDa"s

Trans !ourCM Reconciliation!e7uenCM

MatchingAgent

CorrectionMethod

Create Activit" Pa"mentMethod

Pa$ment 1 AP Pa$ments 1

Rece!)t ' AR Rece!)ts 1

11

7/25/2019 BR100 Cash Management 0 1

11/13

CM: Dene &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 Rec'd Position 1ormat Concatenate1ormat 'nclude 'ndicator8 Desc 1le(

STATEMENTNUMBER ' 1

BAN=ACCOUNTNUM ' '

STATEMENT"ATE ' (

BAN=NAME ' >

BAN=BRANC?NAME ' @

CONTROLBEINBALANCM ' 8

CONTROLEN"BALANCM ' %

CONTROLTOTAL"R ' ;

CONTROLTOTALCR '