Home

Term Deposit User Manual

1. Accounting Role Amount Tag Dr Cr Indicator AP02 ACR_ADu 1 IACR_ADJ Credit 8 6 2 3 ILIQ Interest Liquidation Accounting Entries Accounting Role Amount Tag Dr Cr Indicator AP02 ACCR 1 ILIQ Debit AP02 PNL_ADJ 2 IACQUIRED Credit AP02 BOOK 2 IACQUIRED Debit AP02 BOOK 1 IACQUIRED Credit AP02 ACQUIRED 1 IACQUIRED Debit AP02 BOOK 1 ILIQ Credit AP02 BOOK 3 TAX ADJ Debit AP02 TPBL 3 TAX Credit AP02 BOOK 3 TAX Debit AP02 PNL 2 ILIQ Credit AP02 BOOK 2 ILIQ Debit AP02 TPBL_ADJ 3 TAX ADJ Credit 8 6 2 4 IMAT Interest Maturity Accounting Entries Accounting Role Amount Tag Dr Cr Indicator INT LIQD IMAT Debit INT BOOK IMAT Credit PRINC LIQD PMAT Debit PRINC BOOK PMAT Credit 8 6 3 TD with Rate Chart Allowed You can set up event wise accounting entries and advices for the product as suggested below Sample accounting entries for IC Product with Rule ID RCO2 are given below 8 12 ORACLE 8 6 3 1 DEBK Book Accounting Entries Accounting Role Amount Tag Dr Cr Indicator TDACCOUNT TD PRINC Credit TDOFFSET TD PRINC Debit 8 6 3 2 IACR Interest Accrual Accounting Entries Accounting Role Amount Tag Dr Cr Indicator RCO02 PNL 1 IACR Debit RC02 ACCR 1 IACR Credit RCO02 PNL ADJ 1 IACR ADJ Debit RC02 ACR ADJ 1 IACR ADJ Credit 8 6 3 3 ILIQ Interest Liquidation Accounting Entries A
2. M M 9 1 9 2 MAINTENANCE eret SY eot ter ele daa Ee ER ER IESS 9 1 9 2 1 Capitalized Deposit with Penalty eese eene enne ren een eene ene 9 3 9 2 2 TD with Normal Tenor and Penalty eese seen nere nnne entren nennt nennen rennen nee 9 8 9 2 3 Recurring Deposit Rule 1 ere pnt t etie ee t nre une eeu a e Eee te tip ttr da 9 11 9 2 4 Rate Chart Allowed with Penalty eee esses eene nnne entente nnne ennt tenente 9 14 9 37 UDE VALUE MAINTENANCE iieri ette erit IH RO dnsvstndsesdsneodedundiecnsedtcodpaceavevancvien 9 18 9 3 1 TD with Ca pitalizdtiOh iiiter ti edi teet it eel tee ed ote de 9 18 9 3 2 Normal TD with Simple Interest Feu dece Ue 9 19 9 3 3 TAX RATE TD with Rate Chart 9 19 9 3 4 Recurring deposit SCHEME ite ri A eat e OE Rega 9 19 9 3 5 Rule for Calculating Readjustment te HN estet nte ie MI lee oie EET 9 19 94 IC RATESMAINTENANCGE encre terret Ep eI eH Or reinen redeo des 9 24 95 INTRODUCTION tees reto oit rob EHE e a d tame des 9 25 DDOPENINGBY ACCOUNT DEBIT e ter od e RE ERE dea pe heut 9 25 10 TD TAX RULE SET UP e eeeeeeeee sensn ses sos esa sone sesso sets sone Tasti 1
3. Q Search Advanced Search Records per page 15 vj I4J 4 1 of 1 y y Authorization Status Record Status Branch Code Pay In Option General Ledger Code You can query on records based on any one or all of the following criteria e Authorization Status e Record Status e Branch Code e Payin Option Click Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them e Authorization Status e Record Status e Branch Code e Payin Option d ORACLE 3 3 Double click on a record to invoke the detailed screen for that record Maintaining Closing Mode When you close an account the system checks whether any Interest Charge IC products linked to the account are pending liquidation If the account does not have any IC products pending liquidation the system will display list of Close Out modes to facilitate account closure You can maintain the closing modes using Term Deposit Closing Mode Maintenance screen To invoke this screen type STDCLOSE in the field at the top right corner of the Application tool bar and click the adjoining arrow button Customer AIC Closing Mode Maintenance Close Mode Product Description Debit Credit Credit v Input By Authorized By Modification Authorized exit Date Time Date Time Number Open Specify the following details Closing Mode
4. Account Class The Term Deposit tab is displayed by default Here you can capture the following details Branch Code The system displays the branch code Account No The system displays the TD account number Customer Number The system displays the customer number However you can change it Currency The system displays the TD currency d ORACLE 6 2 3 Account Class Specify the account class from which the interest and deposit should be picked up If you have selected the Account Class option then you have to specify the Account Class Else you can leave it blank Account Account Class Indicate whether the interest and deposit should be picked up from the parent account TD account or from the account class The options available are 9 If you select the option Account then on clicking P button the system will default the interest and deposit details from the parent TD account If you select the Account Class option then on clicking P button the system will default the interest and deposit details from the account class selected Cheque DD Details Tab Click Bankers Cheque tab on the Term Deposit screen and invoke the following screen Here you can capture details of the banker s cheque by which the TD needs to be redeemed You need to maintain these details if you have selected Payout Option as Banker s Cheque or Demand D
5. 1 Accot Authorization Status A Authorized U Unauthorized Action Flag R Redemption E Renewal Redemption By S Savings G GeneralLedger B Bank Cheque Redemption Mode N Full Redemption Y Partial Redemption You can query on records based on any one or all of the following criteria pea ORACLE 6 4 Authorization Status Record Status Redemption Reference Number Branch Code Account Number Transaction Date Click Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them Generating an Advice Authorization Status Record Status Redemption Reference Number Branch Code Account Number Transaction Date Customer Id Account description Redemption Amount Action Redemption By Currency Redemption Mode Bank Narrative Savings Narrative GL Narrative You can generate a TD and Duplicate deposit advice using the Deposit Advice generation screen To invoke this screen type ICDBADHC in the field at the top right corner of the Application tool bar and click the adjoining arrow button 6 24 ORACLE Term Deposit Advice Advice No of Advices Generated Branch Code 000 Print Status Customer Account Number 2 You need to specify the following details Branch Code The system displays the branch code Customer Account Number Specify the account for which you want to generate a
6. 9 22 ORACLE F Book Debit Accr Condition Result Purpose o ing Credit uals r Flag m 1 Book Credit N READJACC 1 SCHD AMOUNT T Principal 0 AND DMATREADJ Readjust DAYS FROM _ ment for START schedule READJ ELG D payout AYS AND SCHD AMOUN T gt 0 1 Book Credit N READJACC 1 FORMULA9 TDMA Interest 1 AND TREADJ Readjust DAYS FROM ment for START schedule READJ ELG D payout AYS AND SCHD AMOUN T gt 0 AND FORMULAQ9 gt 0 1 Tax Debit N FORMULA1 FO FORMULA1 FOR Tax 2 RMULA2 FORM MULA2 FORMULA ULA3 FORMUL 3 FORMULA4 FO A4 FORMULAS5 RMULA5 FORMUL FORMULA6 F A6 FORMULA7 F ORMULA7 FOR ORMULA8 FORM MULA8 FORMU ULA9 FORMULAT1 LA9 FORMULA 0 FORMULA11 T 10 FORMULA11 AX_RATE 100 gt 0 Formula for TDS on Demat Sale Form Book Debit C Accr Conditi Result Purpose ula ing redit uals on Flag 1 Book Credit CURRE CURRENT BAL INT Interest NT BA RATE DAYS YEA L gt 0 R 100 2 Tax Debit TD EN FORMULA1 TDS_R_ Normal DORSE ATE 100 when TD is D 0 not sold 9 23 ORACLE 9 4 Tax Debit N TD EN LEAST Greatest Tax when DORSE CURRENT BAL the D 1 FORMULA1 DematTD TD_SALEAMT 0 T is sold DS_RATE 100 FO RMULAt1 TDS RATE 100 IC Rates Maintenance You can maintain rate codes for b
7. cccscsssesscsssesessesscssesssesecseseseseseeessesesesessessscseseeseesesenessueeeenesene 3 3 3 3 MAINTAINING CLOSING MODE nisi tie REDIERE DIGG D REED RETO IER UE 3 4 3 3 1 Specifying UDF Values I Em 3 5 3 4 VIEWING CLOSING MODES SUMMARY EE NEE 3 6 3 5 MAINTAINING ACCOUNT CLASS FOR tire evio tov isese emerek 3 7 3 5 1 Account Details EE EEEE ede kie ER e AEN VER 3 8 3 5 2 Maintaining Deposit Details eese eene nennen nennen rennen eene tenete tenet enne ne 3 9 3 5 3 Maintaining Transaction Tax Details eese eee eene nennen nenne trennen eren ens 3 20 3 6 MAINTAINING TERM DEPOSIT FRACTIONING nene eene ennemi nne trennen nere nnne 3 20 3 6 1 Specifying Fraction Details etie eterne A e ue ue eee aae dies 3 22 3 7 MAINTAINING REASON CODE eerte certe ten b Ee e oe REF Rie Ee PR Ye eE ee PES Fave epe Eee Ene Yeh 3 24 3 8 SETTING UP INTEREST PREFERENCES FOR TD sess eene enne enne nnns 3 24 3 8 1 Specifying Accounting Roles for Unclaimed Deposits esee 3 25 3 8 2 Linking TD Account Class to Interest Product eee 3 27 3 8 3 Specifying Deposit Preferente S iui ester ette desine qe XI ooo eee P de ort veers etos certi dev ee pud 3 28 3 9 MAINTAINING FLOATING INTEREST RATES sseee
8. Authorization Status v Record Status v Branch Code aE RD Account Number LH Payment Branch Code az Payment Currency LE Product Code sz Transaction Date 5 Q Search Advanced Search Reset rr T Records per page 14 4 4 or 1 Ml Authorization Status Record Status Branch Code RD Account Number Payment Branch Code Payment Currency Product Code Trans Authorization Status A Authorized U Unauthorized Record Status C Closed O Open You can query on records based on any one or all of the following criteria e Authorization Status e Record Status e Branch Code e RD Account Number e Payment Branch Code e Payment Currency e Product Code e Transaction Date Click Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them e Authorization Status e Record Status e Branch Code e RD Account Number e Payment Branch Code is ORACLE 7 4 e Payment Currency e Product Code e Transaction Date Double click on a record to invoke the detailed screen for that record Reversing Payment You can reverse the payments made to the RD account rather the installment amounts to the recurring deposit account Invoke the Recurring Deposit Payments Reversal screen from the application browser You can also invoke this screen by typing ICDPMREV in the field at the top right corner of the Application too
9. Maturity Date E Next Maturity Date Tenor Rollover Rollover Principal Close on Maturity Principal Interest Amount Interest Move Interest to Unclaimed Move Principal to Unclaimed Rollover Amount Term Deposit Payout Details Pay Out Type Percentage Offset Branch Offset Account Narrative D Account Term Deposit Payout Out You can capture the following details Maturity Date The system picks up the maturity date from the default tenor from the linked account class and displays it here However you can modify this date Next Maturity Date On selecting the Auto Rollover box the system displays the next maturity date based on the previous tenor of the deposit Tenor The system calculates the tenor of the deposit account as the difference between interest start date and maturity date and displays it In case of change in maturity date the system changes the value of this field Auto Rollover Check this box to automatically rollover the deposit you are maintaining You have to indicate Rollover Type on selecting this option ORACLE Close on Maturity Check this box to close the term deposit account on maturity date and transfer the amount as per the pay out details maintained for the TD Move Interest to Unclaimed Check this field to move the interest amount to the unclaimed GL mapped at the IC product in th
10. Amount Exceeding Specify the deposit amount here The report generated will include only those accounts which exceed the deposit amount specified here Click OK button to generate the report Click Exit to return to the Reports Browser 11 4 1 Contents of the Report 11 5 The contents of the report are discussed under the following heads Header The Header carries the Bank code Branch Run Date User ID and the Period for which the report is generated Body of the report The generated report will have the following information Field Name Field Description Customer with deposit This indicates the name of the customer whose deposit amount amount total gt exceeds the amount criteria specified Customer ID This indicated the unique id of the customer Customer Short Name This indicates the short name of the customer Account Currency This indicates the currency of the account Deposit amount This indicates the deposit amount Deposit Detail Summary by Total Amount Report This report provides a summary of currency wise deposit details You have an option to print and view the report in pdf or excel format You can invoke Deposit Detail Summary by Total Amount screen by typing TDRDDSUM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 11 6 ORACLE Deposit detail summary Processing Date Bra
11. Prepayment Notice Period Pre Payment Notice Period Pre Closure Currency Maximum Amount Auto Rollover 7 Pre Closure Allowed v Use Rate for Revised Tenor F Generate Roll Over advice Maturity Advice Mat Notice Period 7 Generate Maturity advice The system displays the account mask details The account mask given here is applicable to the TD accounts opened under this account class Endorsable Check this box to indicate that the TD is endorsable If you check this the TD booked under this account class can be transferred to other beneficiary If you do not check this the account class is of nominative type and the TD cannot be transferred to other beneficiary Readj Elg Days Specify the number of days for readjustment Only after these many days the TD will be eligible for readjustment benefit 3 16 ORACLE Readjustment is a facility to customers to keep a deposit in UF currency other than local currency however the transactions should be carried in Local Currency In such case the customer gets in addition to the Principal and Interest the readjustment benefits also in case the exchange rate between the UF and local currency goes up Prepayment Notice Period Prepayment Notice Period The customer needs to serve the notice period for a TD pre closure The notice period for TD pre closure is maintained here Pre Closure Pre Closure Allowed
12. e Use DAYS when the formula needs the number of days from last liquidation date of account to current date e Use DAYS FROM START SDE when the formula needs the number of days from account opening date to current date e The value for PENALTY_APPLY SDE is always set as 1 i e Yes If you check the box Waive Penalty in the Term Deposits Redemption screen ICDREDMN the system will change the SDE value to 0 i e No for that particular account e The value for PENALTY_BASIS SDE is taken as the redemption amount For details about the screen refer the chapter Maintaining Interest Rules in the Interest and Charges User Manual You can maintain rules for the following e Capitalized Deposit with Penalty e TD with Normal Tenor and Penalty e Recurring Deposit Rule e Rate Chart Allowed with Penalty For the purpose of calculating readjustment the new SDE s are provided in the IC rule SDE Type Explanation DAYSFRMINTSTART Factory SDE which will give the no of days from Term Shipped deposit interest start date till today CURRENT BAL existing Factory Current Account Balance new check the release area Shipped DDL tool TENOR Factory SDE which will give the td default tenor Shipped REDEM Factory New SDE with values Shipped 0 normally 1 in case of manual redemption INT ELG DAYS Factory IC Product level Interest Eligible Days Shipped READJ ELG DAYS Fac
13. 9 2 1 Capitalized Deposit with Penalty Specify the following details 9 3 ORACLE On Account Opening Month Check this box On Account Closure Month Check this box SDE Maintain the following SDEs UDE DAYS DAYS_FROM_START DLY_NET_BAL_M PENALTY_APPLY PENALTY_BASIS TENOR YEAR Maintain the following UDEs Type For each of the UDEs select the option Rate from the adjoining drop down list TAX_RATE TD_1 TD_2 TD_3 TD_PNL Get Latest For each of the UDEs select the option Use Effective from the adjoining drop down list Click Formulas button and invoke the Formulas screen 9 4 ORACLE Formula Number Periodicity Daily DebitiCredit Debit BookFlag Booked DaysinaYear Actuals Accruals Required DaysinaMonth Actuals Rounding Required Interest Method Default From Currency Definition Tax Category az Tax Description Calculation Parameters Booking Basis Percent Book Tax To Expense Local Currency Basis Account Tax Payable Currency Flag Basis Amount Tax Amount Option Option Method Method Decimals Decimals Units Units You need to maintain two booked formulae and one tax formula Formula 1 Specify the following details Book Flag Select Booked from the adjoining drop down list Debit Credit Sele
14. User Defined Element Waive Currency Generate UDE Change Advice Open Effective Dates Here you can capture the following details Branch The system displays the branch code where the child TD resides Account Class The system displays the account class to which the TD belongs Account The system displays the child TD account number EE ORACLE 6 2 6 Customer No The customer identification CIF of the TD customer is displayed here Interest Tab This tab is displayed by default You can specify the following details Calculation Account Specify the calculation amount of the child TD The adjoining option list displays all accounts maintained in the respective branch You can select the appropriate one Interest Start Date Indicate the date from which interest calculation should start using the adjoining calendar Interest Booking Account Specify the account to which interest should be booked You have an option of booking interest to a different account belonging to another branch The accounts maintained in the selected booking branch are available in the option list provided The system liquidates the interest into the selected account Interest Booking Branch Specify the interest booking branch The adjoining option list displays all valid branch codes available in the system You can select the appropriate one Interest Statement Check this box to generate an interest statement for the account The i
15. Yen ORACLE Here you can capture the following details Cheque Details Specify the following details Bank Code Specify the bank code of the Bankers cheque Currency The system displays the TD currency You cannot modify it Payable Branch Specify the payable branch for the cheque The adjoining option list displays all branch codes linked to the specified bank code You can select the appropriate one Instrument Type Instrument type of the TD will be defaulted here based on the payout type value selected in the main screen if you have selected Payout Type as Demand Draft or Bankers Cheque Beneficiary Details Specify the following details Beneficiary Name Specify the name of the beneficiary for the pay out Passport IC Number Specify the passport number or identification card number of the beneficiary for the pay out Narrative Specify the description for the pay out Beneficiary Address Specify the address of the beneficiary for the pay out pe ORACLE 5 11 3 Specifying PC Details Click PC tab to capture pay out details if you have opted for TD pay out through PC transfer to another account Term Deposit Payout Details Branch Code Currency Account Term deposit Bankers Cheque DD PC Counterparty Counterparty Bank Code Counterparty Account Currency Beneficiary Details Beneficiary Address Beneficiary Name PassportiC Number Narrative The following
16. You need to maintain the following modes CASH This indicates closure by cash FT This indicates closure by funds transfer GL This indicates closure by transfer to GL BCA This indicates closure by banker s cheque PC This indicates closure by transfer of funds to another account using PC module Description Give a brief description for the closing mode Hs ORACLE Product Specify the Retail Teller product that should be used for booking withdrawal entries It can be any one of the following e Retail Teller Product e Product linked to the instrument type Debit Credit The closure can be effected by means of a debit or a credit to the account For each of the aforesaid closing modes you need to select the Debit option from the adjoining drop down list 3 3 1 Specifying UDF Values All User Defined Fields UDFs linked to the function ID STDCLOSE are displayed in the User Defined Fields screen Invoke this screen by clicking Fields button on the Term Deposit Closing Mode Maintenance screen User Defined Fields User Defined Fields l 0 Lo o Here you can specify values for each UDF Refer the User Manual titled User Defined Field for details about defining UDFs i ORACLE 3 4 Viewing Closing Modes Summary You can view summary of all closing modes using the Term Deposit Closing Mode Maintenance screen To invoke this screen type STSCLO
17. 9 6 ORACLE Book Flag Select Booked from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select 30 Days from the adjoining drop down list Days in a Year Select 360 from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expression Case Result DLY_NET_BAL_M gt 0 AND PENALTY_BASIS DAYS FROM START DAYS PENALTY_APPLY 1 TD PNL 100 YEAR Formula 3 Specify the following details Book Flag Select Tax from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select 30 Days from the adjoining drop down list Days in a Year Select 360 from the adjoining drop down list Rounding Required Check this box 9 7 ORACLE 9 2 2 Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expression Case Result FORMULA 1 gt 0 FORMULA1 TAX RATE 100 TD with Normal Tenor and Penalty Specify the following details On Account Opening Month Check this box On Account Closure Month Check this box SDE Maintain the following SDEs UDE DAYS DAYS FROM START DLY NET BAL M PENALTY APPLY PENA
18. Assume that the accounting role is TDAB ACCR 1 This role indicates the following e The IC product is TDAB e formula number is 1 for example credit interest accrual which was defined in formula 1 Assume that the accounting role is TDAB PNL 2 This role indicates the following e The IC product is TDAB The formula number is 2 for example debit interest posting against income GL defined for formula 2 You should select the appropriate accounting role on the Role to Head Mapping screen for every product 8 2 ORACLE Note that TDAA BOOK X represents the settlement account where the amount is credited or debited against P L account This role cannot be attached to any GL on the Role to Head Mapping screen It is used while maintaining event wise accounting entries 8 3 ORACLE Sample accounting role for IC Rule ID like APO1 are given below AP01 ACCR 1 AP01 ACQUIRED 1 APO1 ACR ADJ 1 1 1 AP01 BOOK 2 AP01 BOOK 3 AP01 PNL ADJ 1 AP01 PNL ADJ 2 APO01 PNL 1 APO01 PNL 2 APO1 TPBL ADJ 3 APO01 TPBL 3 AP02 ACCR 1 AP02 ACQUIRED 1 APO2 ACR ADJ 1 AP02 BOOk 1 AP02 BOOK 2 AP02 BOOK 3 AP02 PNL ADJ 1 AP02 PNL ADJ 2 AP02 PNL 1 AP02 PNL 2 APO02 TPBL ADJ 3 AP02 TPBL 3 INT BOOK INT LIQD PRINC BOOK PRINC LIQD RC02 ACCR 1 RC02 ACQUIRED 1 RC02 ACR ADJ 1 8 4 ORACLE RC02 BOOK 1 RC02 BOOK 2 RC02 BOOK 3 RC02 PNL ADJ 1 RC02 PNL ADJ 2 RC02 PNL 1
19. however the interest gets liquidated to the interest booking account On save the redemption amount will be updated after considering the principal plus interest less tax In case of readjustment system pays the redemption balance after considering the principal Interest interest readjustment principal readjustment additional interest in case of pre closure during grace or the maturity date is a holiday and additional interest readjustment in case of pre closure during grace or the maturity date is a holiday less tax o If the cluster identification is specified at the account class level then the system will validate for the following e During partial redemption the withdrawal amount should be a multiple of withdrawal unit maintained at the Deposits Cluster Maintenance level else the system will display the following error message Withdrawal amount must be multiples of withdrawal unit e Withdrawal amount should be greater than minimum booking amount maintained at the Deposits Cluster Maintenance level else the system will display the following error message Withdrawal exceeds minimum balance level Waive Penalty Check this field to waive any penalty related to the deposit redemption Renewal You can do renew a TD only during the grace period You can select the TD account and define the tenor for which TD should be renewed however the rollover takes effect only at the end of the grace days During renewal
20. 6 7 Since the grace period is 0 the Principal can be redeemed through Term Deposit Redemption Input screen ICDREDMN before EOD on July 05 2010 If the Principal remains unclaimed until EOD on July 05 the Principal will be moved into Unclaimed Principal Miscellaneous GL with an instrument code Reference number for reconciliation with the value date as the maturity date i e July 05 2010 From July 06 onwards the Principal can be debited from the Miscellaneous GL using the reference number Instrument Code Note the following e f you select the Move to Unclaimed GL option then on maturity date the funds will be stored in the TD account and further accrual will be stopped until the grace period e f you redeem the TD in the grace period you will receive the Principal and interest amount accrued on that account as of the maturity date e f you renew the TD the system will start interest accrual from the maturity date of the old TD e debit the amount from the Unclaimed Interest or Unclaimed Principal you will need the corresponding instrument Code Reference number as these GLs are miscellaneous credit GLs Closing TD by Payout to Loan Account If you select Payout Type as Loan Account at term Deposits Redemption Input level then the system credits the payout amount and automatically initiates liquidation event The components of the loan which are due on the payout date are liqui
21. Accounting collateral tracking rollover handling and accounting and tracking of unclaimed deposits are completely automated This means your staff with the treasury department can remain focused on customer service e Multi Mode Pay in TD can be funded using multiple pay in modes You can choose any combination of the following pay in modes gt Pay in by transfer from GL gt Pay in by Savings Account gt Pay in by Cash Only from Savings module e Multi Mode Pay out In case of automatic and manual redemption a TD can be redeemed using multiple pay out modes You can choose any combination of the following pay out modes gt Pay out by Banker s Cheque gt Pay out by funds transfer to any account specified by the customer gt Pay out by child TD creation wherein another TD is created using the maturity amount gt Pay out by transfer to GL gt Pay out by cash Only from Savings module e Simulation The TD module offers a simulation tool wherein a TD can be simulated to enhance sales and service aspects to new existing customers You can also generate a TD Certificate 2 2 1 Pre requisites for TD Processing To handle a term deposit in Oracle FLEXCUBE you need to 1 2 Set up a suitable account class Set up an IC rule Set up a suitable IC product Maintain UDE Account Class combination Define IC rates Define floating interest rates Maintain a term deposit account Define Interest Cond
22. Charge Booking Branch By default the customer s account in the current branch will be displayed However you have the option of booking charge to a different account belonging to another branch also You can select the Charge Booking Branch from the option list available The accounts maintained in the selected Booking Branch will be available in the option list provided for Charge Booking Account Charge will be liquidated into the selected account aA ORACLE Rate Chart Allowed The system defaults this preference from account class and it indicates that the system should calculate TD interest based on the LDMM float rate maintained in the LD MM Floating Rate input screen CFDFLTRT If it is checked the system will pick interest rates based on different tenors minimum amount currency and effective date for a TD The system does not allow you to amend it During account creation for TDs if Rate Chart Allowed is checked the system does not allow floating rate code During IC calculation if the rate code is maintained for the UDE then the system derives the interest rate from the Rate Maintenance done in LD MM Floating Rate input screen CFDFLTRT Consolidated Charge Account Specify the account for posting consolidated charges The adjoining option list displays all valid accounts maintained in the system You can select the appropriate one Currency Specify the term deposit currency Periodic Rate The s
23. a joint savings account is opened The holders are the following e CIF 1 112223334 e Name of holder 1 Juan P rez e CIF 2 223334445 e Name of holder 2 Miguel Tapia Since the term deposit and the account are joint holding with same holding order this transaction is not subject to transaction tax and the system should not charge the tax 10 8 ORACLE 11 Reports 11 1 Introduction The following are the reports that you can generate in TD module e Customers Fixed Deposit Report e TD Full Balance Listing Report e Large FD Report e Deposit Detail Summary by Total Amount Report e Interest Paid Report e TD Statement of Accounts Report e TD Account Class Summary Report e Term Deposits Opened for the period Report e Term Deposits Closed for the period Report e Term Deposits Renewed for the period Report e Term Deposits Maturity Report To generate any of these reports choose Reports in the Application Browser Choose TD under it A list of all the reports in TD module will be displayed You can choose to view or print the report The time and the operator who generated the report will be displayed 11 2 Customers Fixed Deposit Report This report lists out all time deposit accounts for a given customer This report also provides an additional information of whether lien is marked or not You have an option to print and view the report in pdf or excel format You can invoke Customers Fixed Deposit screen by ty
24. 1 000 000 000 2012 01 01 _ 85 Borrow Tenor and Interest Rate Details 1of1 Tenor To Interest Rate Maximum Rate for Term Deposits Pre Closure Differential for Term amp 5 0 6 Maker Date Time Checker Date Time Mod No Record Status The floating interest rates are defined through this screen A Rate Code identifies a set of rates defined for a combination of Currency Amount Slab optional and Effective Date Also for each such combination you can maintain rates that can differ by each tenor The following details have to be captured here os ORACLE Rate Code and Description You can maintain new rate codes and also provide values for existing ones like MIBOR LIBOR etc For a new code you need to capture a unique id The id can include a maximum 10 alphanumeric characters Currency You have to associate each Rate Code with a currency You can define rates for the same Rate Code in different currencies Select a currency from the option list provided Effective Date Each rate that you define for a Rate Code and Currency combination should have an Effective Date associated with it This is the date on which the rate comes into effect Once a rate comes into effect it will be applicable till a rate with another Effective Date is given for the same Rate Code and Currency combination Example Rate Code T
25. ACCR 1 ILIQ Debit TDFN ACQUIRED 1 IACQUIRED Debit TDFN BOOK 1 IACQUIRED Credit TDFN BOOK 2 ILIQ Credit TDFN PNL 2 ILIQ Debit TDFN BOOK 3 ILIQ Credit TDFN PNL 3 ILIQ Debit TDFN BOOK 4 ILIQ Credit TDFN PNL 4 ILIQ Debit TDFN BOOK 5 ILIQ Credit TDFN PNL 5 ILIQ Debit TDFN BOOK 6 ILIQ Credit TDFN PNL 6 ILIQ Debit TDFN BOOK 7 ILIQ Credit TDFN PNL 7 ILIQ Debit TDFN BOOK 8 ILIQ Credit TDFN PNL 8 ILIQ Debit TDFN BOOK 9 ILIQ Credit TDFN PNL 9 ILIQ Debit TDFN BOOK 10 ILIQ Credit TDFN PNL 10 ILIQ Debit TDFN BOOK 1 1 ILIQ Credit TDFN PNL 1 1 ILIQ Debit TDFN BOOK 12 TAX Debit TDFN TPBL 12 TAX Credit TDFN BOOK 12 TAX ADJ Debit 8 15 ORACLE TDFN TPBL_ADJ 12 TAX ADJ Credit IMAT Interest Maturity Accounting Entries Accounting Role Amount Tag Dr Cr Indicator INT LIQD IMAT Debit INT BOOK IMAT Credit PRINC LIQD PMAT Debit PRINC BOOK PMAT Credit 8 6 5 Payable interest for one or more schedules The system should allow the payment for one or more overdue schedules it should pass a consolidated entry when more than one schedule is liquidated 8 6 5 1 IMAT Interest Maturity Accounting Entries Accounting Role Amount Tag Dr Cr Indicator Interest overdue unclaimed GL IMAT Debit Settlement mode account IMAT Credit 8 6 6 TDS amount for one or more schedules The system should dynamically map role GL INT LIQD to Interest overdue unclaimed GL when the Overdue
26. Account Blocked Reason Code Mod No Record Status Authorization Status Date Time Date Time Here you can capture the following details Branch Code The system displays the branch code of the sign on branch Customer No Specify the customer identification CIF for whom you are creating a TD The adjoining option list displays all valid CIF maintained in the system You can choose the appropriate one Customer Name The system displays the name of the customer based on the CIF specified Term Deposit Account Number Account numbers can either be generated automatically or you can choose to allocate them manually If you have enabled auto generation of customer account numbers at the bank parameters level the system will create a unique reference number to identify the TD account and display it here on pressing the P populate button In case of manual number allocation specify a unique account number In case of a child TD creation as part of payout of parent TD the number will be automatically generated Mx ORACLE Term Deposit Currency Specify the currency of the TD A list of all the currencies maintained in the system is displayed in the available option list You can select the appropriate one SD User Reference The system displays the SD user reference for the TD TD Ref No The reference number of the TD is generated by default This reference number i
27. Any failed sweeps after this date will not be picked up for processing the next day 5 19 1 Specifying UDF Values All User Defined Fields UDFs linked to the function ID ICDINSTR are displayed in the User Defined Fields screen Invoke this screen by clicking Fields button on the Term Deposits Instruction Maintenance screen User Defined Fields User Defined Fields Field Name Value Here you can specify values for each UDF Refer the User Manual titled User Defined Field for details about defining UDFs vee ORACLE 5 20 Viewing Instruction Summary You can view summary of all instructions using the Term Deposits Instruction Summary screen To invoke this screen type ICSINSTR in the field at the top right corner of the Application tool bar and click the adjoining arrow button Authorization Status Record Status Account Number Search Advanced Search Reset Records per pagel 1 5 14 1 of 1 Authorization Status Record Status Branch Code Account Number Sweep To Account Sweep Branch Authorization Status A Authorized U Unauthorized Record Status C Closed O Open You can query on records based on any one or all of the following criteria e Authorization Status e Record Status e Account Number Click Search button The system identifies all records sat
28. Counter Party Bank Code Specify the bank code of the counter party Counter Party Offset Account Specify the branch code of the account for redemption Beneficiary Details Indicate the following details Beneficiary Name Specify the name of the beneficiary Address Line 1 to 2 Specify the address of the beneficiary Other Details Specify other details if any for the beneficiary Narrative Give a brief description for the payout o After entering the details for TD creation if the maturity date of the TD falls on a holiday then system will display an error and will not allow you to proceed further Holiday Treatment if TD Payout is another TD When the TD payout instruction has been mentioned as another TD based on the start date and tenor if the maturity date falls on a holiday then the system will display the following error message Maturity date is on holiday kindly change the tenor or maturity date The system will not perform any maturity date adjustment automatically based on the instruction given in Holiday Movement field For the new TD creation irrespective of the option provided in Holiday Movement the system will display the following error message Maturity date is on holiday kindly change the tenor or maturity date 6 20 ORACLE 6 2 9 If maturity date falls on a holiday then you need to change the tenor maturity date manually and proceed with TD creation The system will
29. Customer Accounts Maintenance screen If you have decided to include account code as part of the customer account number in the account number mask then at the time of creating a new customer account number you will need to select the account class for the account number being generated In the option list provided the account class is displayed along with the associated account code When the account number gets populated it is the account code that forms a part of the customer account number Dual Currency Deposit Check this box to indicate that account class is for creating dual currency deposits You can check this box only if the account type is Deposit While setting up a dual currency deposit account class you need to check this box Natural GL any ORACLE 3 5 2 The reporting of all turnovers of the particular account class will be directed to the GL that you identify as the natural GL Based on the characteristic of the account balance you can specify whether the turnover is to be posted to the Debit GL or to the Credit GL Deposit accounts normally have a credit balance Applicable Customer Status Select the applicable customer status to indicate whether deposit product is available to minors or not You can choose one of the following values from the adjoining drop down list e Not Applicable e Major e Minor e Both Note the following e default Not applicable option is selected whe
30. Date Enter the TD accounts which are opened till this date However by default the system displays the current application date Branch Specify the branch code of the TD account The adjoining option list displays the list of all the valid TD RD branch codes maintained in the system You can choose the appropriate one Account Class Specify the account class of TD account The adjoining option list displays the list of all the valid TD RD account classes maintained in the system You can choose the appropriate one m ORACLE Customer Specify the customer number of the customer The adjoining option list displays the list of all the valid customer numbers maintained in the system You can choose the appropriate one Click OK button to generate the report Click Exit to return to the Reports Browser Body of the report The generated report will have the following information Field Name Field Description Account No Deposit No This indicates the TD account Number Customer Name This indicates the Name of the TD account holder Date of Open This indicates the TD account opened date Value Date This indicates the Value Date of the TD account Deposit Amount This indicates the Deposit Amount Deposit Term This indicates the TD Tenor Maturity Date Interest Start Date Maturity Date This indicates the Maturity date of the TD account Total Interest Payable This indicates the Interest Amo
31. Interest schedule is getting paid 8 6 6 1 IMAT Interest Maturity Accounting Entries Accounting Role Amount Tag Dr Cr Indicator Settlement mode account IMAT Debit TDS GL IMAT Credit 8 6 7 Accrued Interest for the schedule The accounting entries corresponding to schedule status change from Pending to Overdue will be 8 16 ORACLE 8 6 7 1 ILIQ Interest Liquidation Accounting Entries Accounting Role Amount Tag Dr Cr Indicator Interest payable GL or ILIQ Debit Interest Expense GL overdue unclaimed ILIQ Credit 8 6 8 Accounting Entries for TD Opening by Account Debit on Event Class Maintenance 8 6 8 1 DEBK Book The following are the tax accounting entries passed for the Tax Class DPTCL Deposit Tax Class Accounting Role Amount Tag Dr Cr DPTCL_COD DPTCL_LIQD Dr DPTCL_COD DPTCL_LIQD Cr At the TD Product Level when the Accounting Entries are maintained for the event DEBK the accounting entries related to the Deposit Booking will have the Transaction Code DPT Accounting Role Amount Tag Dr Cr Dr Settlement Account TD_PRINC Dr Term Deposit New TD_PRINC Cr ORACLE 9 1 Introduction 9 Annexure B IC Rule Set up This Annexure lists the Interest and Charge IC rules that need to be maintained for the TD module of Oracle FLEXCUBE It also gives the UDEs and rates for whi
32. Months Years Dual Currency Deposit Linked Currency Currency Option Product Fixing Days Maximum Schedule Days Minimum Installment Amount On the maturity date of a deposit you can opt to e Rollover the deposit e Liquidate the deposit e Move it to an unclaimed GL The values given here will be defaulted when the TD is opened However you can modify defaulted values for each TD Auto Rollover You can opt to automatically rollover a deposit if it is not liquidated on its maturity date Check this box to automatically rollover deposits opened under the account class TDs that are open and marked for Auto Rollover will automatically be rolled over during the Beginning of Day operations on the Maturity date You can define the terms and conditions for the new deposit while maintaining the deposit account Close on Maturity Deposit accounts opened under an account class can be closed automatically on the Maturity Date of the deposit You can specify this for the account class you are maintaining by checking this box If you check this box then during the Beginning of Day operations on the Maturity Date the account will be closed The principal will be moved if specified to the account your customer has directed In case you don t check this box and the deposit remains unclaimed you can opt to move the principal and interest to the respective Uncl
33. Principal Interest as defined above till the grace period 1 day is over Hence the renewal of deposit is possible till EOD starts on maturity date 1 i e till July 14 2010 But the maturity date will be taken as the value date for renewal i e July 13 2010 On maturity date grace period count 0 renewal is possible and value date of TD will be July 13 2010 On July 14 2010 grace period count 1 renewal is possible and value date will still be July 13 2010 In case renewal is not done within the grace period on lapse of the grace period both the principal and interest will be moved to Unclaimed Principal and Unclaimed Interest Misc GLs respectively with an instrument code reference number for reconciliation July 15 2010 onwards grace period is over the principal and interest can be debited from the Miscellaneous GLs using the reference number instrument code No renewal is possible beyond this date 6 6 2 Moving Principal to Unclaimed Principal retaining interest in Interest Booking Account The following example explains this case Assume the following 26157010000906 is the TD account opened under Account class ACCT for which Grace period for renewal is 0 e Booking Account is a savings account and Principal Liquidation Account is a TD account The TD is maturing on July 05 2010 and Interest is liquidated into the Interest booking account on July 05 during BOD oor ORACLE 6 6 3
34. Revision Required Check this box to indicate that rate revision is required Rate Change Period in Days The system displays the rate change period in days The no of days in which the rate has to be re picked is based on the rate change period Rate Revision is a facility to the customer where the rate changes depending on the period maintained in the IC product level The variable rate is picked up in the periodicity of rate change days and any rate maintained in between the rate change days will not be considered In case rate is not maintained on the rate change day then the latest rate will be picked up Interest Eligibility Details Interest Elg Dys Number of days beyond which the TD is eligible for interest mer ORACLE 3 9 Maintaining Floating Interest Rates You can apply interest either as a Fixed rate or as a Floating rate A floating rate corresponds to the market rates for the day These rates are maintained and updated daily or whenever they change in the Floating Rate Maintenance screen You can invoke this screen by typing CFDFLTRI in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button LD MM Floating Rate Input Branch Code x 000 Rate Code LLLL1 Rate Description FLOAT1 Currency Effective Date and Amount Slab 1of1 1of1 148 E etectve Date por Lend v IE af
35. Rollover Check this box to automatically rollover the deposit you are maintaining You have to indicate Rollover Type on selecting this option Close on Maturity Check this box to close the term deposit account on maturity date and transfer the amount as per the TD pay out details Note that for a recurring deposit you need to mandatorily check this box Tes ORACLE For a TD only one of the options Close on Maturity or Auto Rollover can be checked Move Interest to Unclaimed Check this box to move the interest amount to the unclaimed GL mapped at the IC product in the accounting roles on grace period end date If you select this option you will have to check the box Move Principal to Unclaimed Move Principal to Unclaimed Check this box to move the principal amount to the unclaimed GL mapped at the IC product in the accounting roles and liquidate the interest amount to the interest booking account on grace period end date If you select this option then only principal amount will be moved to unclaimed GL the interest will be settled as per TD pay out details If you check both Move Interest to Unclaimed and Move Principle to Unclaimed then TD amount i e Principal and interest will be moved to the respective unclaimed GLs irrespective of the TD pay out details maintained If the options Move Principal to Unclaimed and Move Interest to Unclaimed are checked the payout cannot be giv
36. YEAR Formula 2 Specify the following details Book Flag Select Booked from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select 30 Days from the adjoining drop down list Days in a Year Select 360 from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expressions Case Result RD INSTALL DUE 0 RD INSTALL DUE OVERDUE PENALTY RD OVERDUE DAYS 100 YEAR Formula 3 Specify the following details Book Flag Select Tax from the adjoining drop down list 9 13 ORACLE 9 2 4 Debit Credit Select Debit from the adjoining drop down list Days in a Month Select 30 Days from the adjoining drop down list Days in a Year Select 360 from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expressions Case Result FORMULA1 gt 0 FORMULA1 TAX_RATE 100 Rate Chart Allowed with Penalty Specify the following details On Account Opening Month Check this box On Account Closure Month Check this box SDE Maintain the following SDEs e DAYS e DAYS FROM START e DEPOSIT AMOUNT
37. account begins End date Specify the date on which the joint holding of the account ends 5 23 ORACLE 5 9 Capturing User Defined Fields All User Defined Fields UDFs linked to the function ID STDCUSTD are displayed in the User Defined Fields screen Invoke this screen by clicking Fields button on the Deposit Account Booking screen User Defined Fields UDF Details 10f1 Here you can specify values for each UDF Refer the User Manual titled User Defined Field for details about defining UDFs Click Fields button on the Deposit Account Booking screen and invoke the User Defined Fields screen oo ORACLE 5 10 Specifying Account Signatory Details Click Signatory button on the Deposit Account Booking screen and invoke the Signatory Details screen Signatory Details Branch Code Account Account Description Customer No Minimum No of Signatories Customer Name Account Message Signatory Details 10f1 ET Signature Id Signatory Name Signatory Type Approval Limit Signatory Message E E Here you can capture the following details Branch code The system defaults the current branch here Account This is the account number to which signatories are to being linked Account description The system displays the description for the account you have selected Customer No Enter the customer signatory you
38. allow you to Save a TD redemption entry only when the maturity date is not falling on a holiday When option Auto Rollover is checked and rollover instructions are provided during the time of deposit opening or as an amendment after opening there will not be any holiday treatment done for the field Next Maturity Date Even though the Next Maturity Date is a holiday there will not be any changes during TD creation or amendment Holiday treatment will applied to the next maturity date at the time of rollover Holiday Treatment during TD Auto Rollover Based on the auto rollover instructions provided during TD creation amendment if the maturity date is falling on a holiday then the system will perform the holiday treatment as below If the Holiday Movement is chosen as Next Working Day then the Next Maturity Date will be adjusted to the next working date If the Holiday Movement is chosen as Previous Working Day then the Next Maturity Date will be adjusted to the previous working date If the Holiday Movement is chosen as No Change in Maturity Date then the behavior of the system will be based on the set up done for batch processing Normally the batch process set up will be done always as an Error but it can be configurable to an override e gnore Override System will automatically process the request amp there will not be any change in the maturity date even
39. as Next Working Day then the Maturity Date will be adjusted to the next working date If the Holiday Movement is chosen as Previous Working Day then the Maturity Date will be adjusted to the previous working date If the Holiday Movement is chosen as No Change in Maturity Date then the behaviour of the system will be based on the set up done for batch processing Normally the batch process set up will be done always as an Error but it can be configurable to an override e Ignore Override System will automatically process the request and there will not be any change in the maturity date even though the maturity date is falling on holiday i e the maturity date will be a holiday for that deposit e Error The transaction will be failed and needs to be handled procedurally When there is a change in Maturity Date due to holiday treatment the tenor will be adjusted accordingly Interest rate pick up will happen based on the revised tenor Generating and Viewing Account Certificate To generate the details of TD account in certificate format click the Generate Certificate button on the Customer Accounts Simulation screen To view the details of the certificate generated for the simulated account click the View Certificate button on the Customer Accounts Simulation screen The following details are displayed e The Document Certificate Number e The account bran
40. at the IC product in the accounting role INT UNCLAIMED on maturity date or grace period end date of the term deposit account If you select this option then you will have to check the box Move Interest to Unclaimed Move Principal to Unclaimed Check this field to move the principal amount to the unclaimed GL mapped at the IC product in the accounting role PRN_UNCLAIMED on maturity date or grace period end date of the term deposit account If you select this option only principal amount will be moved to unclaimed GL and the interest will be settled through defined TD pay out mode If you check both Move Interest to Unclaimed and Move Principle to Unclaimed boxes then the TD amount i e Principal Interest will be moved to the Unclaimed GL irrespective to the defined TD pay out details Rate Chart Allowed Check this box to indicate that the system should calculate TD interest based on the LDMM float rate maintained in the LD MM Floating Rate input screen CFDFLTRT If you check this box the system will pick interest rates based on different tenors minimum amount currency and effective date fora TD Note that you will not be able to modify this preference once the record is authorised ORACLE Minimum Specify the minimum amount for which deposit should be created under this account class The system will not allow you to book a deposit account with less than this minimum amount in the account c
41. being queried aa ORACLE Amount The system displays the foreign currency amount of transaction of the account being queried Lcy Amount The system displays the local currency amount of transaction of the account being queried Transaction Date The system displays the transaction date of transaction of the account being queried Value Date The system displays the value date of the transaction Trn Int Dt The system displays the transaction Initiation date of transaction of the account being queried Related Account The system displays the related account of transaction of the account being queried Auth Stat The system displays the authorization status of transaction of the account being queried User ID The system displays the user Id of transaction of the account being queried 6 9 1 1 IC Batch Processing There will be no interest paid during the course of the deposit in Discounted type products The Amount Block created on term deposit account for discounted interest will be removed by the system during the maturity of the term deposit The discounted interest of the rolled over deposit will be paid upfront during rollover If Amount Block for Discount option is required the amount block will also be done on the new deposit TD rollover batch will be changed to do this operation 6 10 Prepayment of a Term Deposit Your customer can intimate you 5 calendar days in advance for his her intentions of doing a prepaym
42. check box Rate Chart Allowed is unchecked the system will display the following error message d ORACLE Use Rate for Revised Tenor applicable only for rate chart deposits e If this checkbox is unchecked then the system will apply the pre closure differential rates during pre closure operations provided the rule formula and the rate code are maintained to support the same Tax Rate Detail Input Tax Reqd Check this box to indicate that input tax is required or not This is used only for projection purpose The tax amount can be projected using Interest and Charges Single Account Online Calculation screen Auto Rollover Generate Rollover Advice Check this box to indicate that rollover advice is required Rollover advice will be generated only for the TD accounts opened with this account class Fractioning Details Fraction Allowed Check this box to indicate whether fractioning is allowed for the account class Minimum Amount for TD Fraction Specify the minimum TD amount to be maintained in the child TD created This is mandatory if the option Fraction Allowed is checked Min Amt Currency Specify the currency of the minimum amount for TD fraction The minimum fractioning amount will be validated based on the currency Maturity Advice Generate Maturity Advice Check this box to indicate that maturity advice is required Mat Notice Period The system indicates the number of days to generate maturi
43. customer number of the TD List of Joint Holders Joint Holder Code Specify the customer ID of the joint beneficiary The option list displays all valid customers maintained in the system Choose the appropriate one Description The system displays the name of the joint holder ORACLE 4 Joint Holder Specify the joint holder type By default the system displays Authorized Signatory as the joint holder type However you can modify this to Joint and First Joint and Other or Joint or First Start Date Specify the start date of the joint holding The start date cannot be a date in the past End Date Specify the end date of the joint holding However you can leave this field blank If you do not specify the end date the TD will remain as Joint In case of endorsement you can change the account type from Single to Joint or vice versa You will have to specify the joint holder details at that time 5 Viewing Endorsement Details for a TD You can view the endorsement details in the Endorsement Log screen Click Endorsement Log button on the Deposit Account Booking screen Endorsement Log x Endorsement Log Details Account Number FTDTDF24608000028 Account Description FTD00001 1 of1 m Serial No BeneficiaryID Date Of Endorsement FirstName Last Na Dn 2 8080 01 MAR 2011 ARUN KUMAR ied gt Account Number The system displays t
44. day for months with lt 30 days e For months with 30 days on the 30th if 30th is a holiday on the next working day If you set the statement date to 31 then account statements will be generated on e The 31 for month with 31 days if 31st is a holiday on the next working day e last working day for months lt 31 days For a fortnightly statement you could specify 1 and 15 For all other cycles account statement will be generated on the last day of that cycle Secondary A C Statement This refers to the type of statement to be generated periodically by the system for this account You can specify whether you want a detailed or summary statement or if you do not want a statement for this account at all Tertiary A c Statement This refers to the type of statement to be generated periodically by the system for this account You can specify whether you want a detailed or summary statement or if you do not want a statement for this account at all Statement Account Specify the account for which the statement has to be generated The adjoining option list displays all valid accounts maintained in the system You can select the appropriate one Exclude Same Day Reversal trns from Stmt If you do not wish transactions booked and reversed on the same day to be reflected in the account statement you can specify the preference here This feature is applicable only for the customer account legs and not for the related GL legs Al
45. denter hane etie seen 6 28 o EE IIS S UICE 6 30 6 8 1 Holiday Treatment during Simulation eese eene nennen nennen ens 6 32 6 8 2 Holiday Treatment for Sweep Accounts eese eese nennen nennen trennen rennen 6 33 6 8 5 Generating and Viewing Account Certificate eese een een eee 6 33 6 8 4 Specifying Interest Details for Simulated Account eese eene 6 34 ie ORACLE 6 9 DEPOSIT AUDIT TRAIL INQUIRY ccccessssssceeececsesssaececececeesesueceeeceesesaaesesececeeseaaesesececeensaaeaesececeesenseaeeeeees 6 38 6 10 PREPAYMENT OF A TERM DEPOSIT eese entente tenete ins 6 42 6 10 1 Prepayment Request nene iross rre isie tens nennen 6 43 7 OPERATIONS 48 7 1 7 1 INTRODUCTION POM 7 1 7 2 CAPTURING PAYMENT DETAILS esee eee nennen teint trains insane insi train sinas insere instet 7 1 7 2 1 Viewing ACCOUNTING ENUTIES PE 7 4 7 2 2 Specifying UDF Values t 7 4 7 3 VIEWING PAYMENT SUMMARY seseseeeneeenen nennen rentrer treni nne tenni n trennen enne nn 7 4 7 2 REVERSING PAYMENT 7 6 8 ANNE
46. in ACY Account class total interest paid This indicates the Account class total for interest paid to To date date in ACY Currency total Interest paid Today This indicates the Currency total for Interest paid Today in ACY Currency total Interest paid To This indicates the Currency total for interest paid To date date in ACY Branch total Interest paid today This indicates the Branch total for Interest paid Today in ACY Branch total for interest paid To This indicates the Branch total for Interest Paid To Date in Date ACY 11 7 TD Statement of Accounts Report This is a report all financial transactions that are customer initiated along with the interest payout and tax deduction if any that has taken place in a time deposit account There are multiple financial transactions like deposits interest pay out etc that takes place in a time deposit account Some of these will be customer initiated while others may be done by the system for auto renewal sweep transactions etc The customer needs to get a list of such transactions that have taken place in his her account along with key transaction details like date transacted description maturity date of the deposit etc This report is generated monthly at EOFI 11 7 1 Contents of the Report The report will have the following elements Field Name Field Description Customer Name This indicates the name of the Customer Customer ID This indicates the unique
47. in the Customer MIS Change Log screen Branch Code Account Change Log Details 10f1 lymijwisciass Transaction Date oldmiscode Newmiscode L Here you can view the following details Branch Code The current logged in branch code is displayed here Account The system displays the TD account number Change Log Details You can view the following details e MIS Class e Transaction Date e Old MIS Code e New MIS Code TU ORACLE 5 6 2 Viewing Transfer Log Click Transfer Log button on the Management Information System screen and invoke the Balance Transfer Log screen When MIS reclassification occurs with respect to a customer account or contract the balances in a GL associated with the old MIS code in each case are transferred to the GL for the new MIS code if the option of transferring MIS balances upon reclassification has been set in the Chart of Accounts screen for the GL Balance Transfer Log Account Balance Transfer Log Details 10f1 m Branch Code Product Code Fin Year Transaction Date GL Code MIS Class OldMISCode NewMIS Here you can view the following details Account The system displays the TD account number Balance Transfer Log Details You can view the following details Branch Code Product Code Fin Year Transaction Date GL Code MIS Class Old MIS Code New MIS Code TRF Ind 5 18 ORACLE e Currency e
48. no accounting entry is passed The system changes the TD interest start date as the maturity date of the old TD In the Deposit tab of the Deposit Accounts Booking screen you can see the new maturity date based on the tenor defined here Days Specify number of days for the renewal of term deposit Months Specify number of months for the renewal of term deposit Years Specify number of years for the renewal of term deposit is ORACLE Note the following e saving the tenor the system displays the Maturity Date e The system allows the Renewal of the term deposit for the tenor which is less than the maximum tenor maintained at the account class level e The charge associated with the Close mode product will be deducted during full and partial redemption for the payout modes Account and GL the charge will be applicable based on the retail teller product for the payout through BC and DD Next Maturity Date The system displays the new maturity date based on the given renewal period during renewal Term Deposit Redemption Pay Out Details Specify the following details for TD payout Pay Out Type Select the pay out type from the drop down list The options available are e Account e General Ledger e Banks Check e Payments e Term Deposit e Demand Draft e Loan Payment For Dual Currency Deposits you are allowed to select only GL and Savings Account options as the pay
49. on the Maturity Date the account will be closed The principal will be moved if specified to the account your customer has directed If the deposit remains unclaimed you can opt to move the principal and interest to the respective Unclaimed GLs maintained at your bank Transferring to Unclaimed Deposit on Maturity As explained in the Deposit Tab section in the chapter TD Account you can move the deposit to an unclaimed GL as per options specified in Deposit Tab in Deposits Account Booking screen upon deposit maturity end of grace period The following three options are available for unclaimed deposits oo ORACLE e Move both Principal and Interest to the Unclaimed Principal and Unclaimed Interest GLs respectively e Move Principal to an Unclaimed Principal GL but retain interest in the Interest Booking Account The aforesaid options are explained in the following examples 6 6 1 Moving Principal and Interest to Unclaimed GLs The following example explains this case Assume the following e 26155010000889 is the TD account opened under Account class ACCT2 for which Grace period for renewal is 1 e Interest Booking Account and Principal Liquidation account TD accounts The TD is maturing on July 13 2010 Note that the grace period counter is 0 till the start of July 13 EOD The grace period counter is 1 till the start of July 14 EOD The TD can be renewed post maturity for
50. out mode You can either select GL or Savings Account but not both Also you can select only one GL or one Savings account and not multiple GLs or accounts in either case If the rollover is for principal interest as per deposit instructions provided by the customer the maturity interest will get added to the principal and the rollover will be affected for the total amount If the rollover is only for the principal amount as per customer instructions the maturity interest will be paid out as per payout option chosen by the customer Periodic interest if any should continue to be available for liquidation Transaction TAX Exempt Check this box to exempt transaction tax The check box will be enabled only when the Paying mode is selected as General Ledger ORACLE 6 2 1 Percentage Specify the amount of redemption in percentage Redemption Amount Specify the actual amount of redemption The percentage and redemption amount are conditionally mandatory You should specify either the percentage or the redemption amount Offset Branch Specify the branch code of the account for redemption Offset Account Specify the account number GL for redemption from the adjoining option list The offset account should not be given in case of payout type as Payments Term deposit Banker s cheque and Demand draft If you select Payout Option as Loan Payment then this list displays active loan account numbers Narrat
51. period maintained at the account class level Auto Liquidation Check this box if auto liquidation of the pre payment for the term deposit is required This remains checked only if the redemption account is defined at the TD account level Approved Specify whether the request is to be approved or rejected from the adjoining drop down list Remarks Enter the redemption remarks for the pre payment of the term deposit Seq ORACLE 7 RD Operations 7 1 Introduction You can perform the following operations on a Recurring Deposit RD e Payment e Reversal 7 2 Capturing Payment Details You have the option of allowing manual receipt of instalments Invoke the Recurring Deposits Payment Input screen from the Application by typing ICDPMNTS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Recurring Deposit Payment Input RD Account Details Branch Code z Transaction Date RD Account Number Maturity Date Installment Amount Currency Payment Details Payment Branch Code Payment Account Number Product Code Exchange Rate Payment Currency Payment Amount Minimum Payment Amount F Paid Amount RD Account Payments lhis CTTEREUUTTUU Eens Contract Status DOC004 Authorized By Modification Authorized cancer Cancel
52. should pass an overdraft in the payment account i e CASA when the account does not have sufficient funds for making RD installment payment Installment Frequency Specify the frequency for payment of installment for RD Days Specify the instalment frequency in terms of days Months Specify the instalment frequency in terms of months Years Specify the installment frequency in terms of years Minimum Schedule Days Specify minimum schedule days here Maximum Schedule Days Specify maximum schedule days here vis ORACLE Minimum Installment Amount Specify the minimum RD installment here For further details about setting up an account class refer the chapter Maintaining Mandatory Information in the Core Entity User Manual 3 5 2 1 Specifying Additional Preferences for TD Click on the Additional Preferences button in the Deposit Account Details screen to specify additional preferences for term deposit The Additional Preferences screen is as shown below Additional Preferences Account Mask Readj Currency Readj Elg Days 7 Endorsable 7 Reaj Reqd z3 Tax Rate Detail 7 Input Tax Reqd Fractioning Details Min Amount for TD Fraction Minimum Amount Currency Holiday Treatment E Fraction Allowed Holiday Calendar Holiday Movement Deposit Account Mask Ignore No Change
53. subsequent operations after opening of dematerialized TD s e Converting of a physical TD to a dematerialized TD e Fractioning e Endorsement e Interest liquidation and payment not supported as interface processing e Interest and or Principal payment not supported as interface processing e Converting of a dematerialized TD to a physical TD Third Party Number Specify the third party depository identification details where the TD account is available Choose the appropriate one from the option list This field is enabled only if the Custody Status field is selected as With Third Party TD Sale Amount Specify the TD sale amount This field will be used when TD account status is Active and TD beneficiary is changed You can specify the TD sale amount only for Demat TDs You cannot specify the sale amount for Physical TDs In case of Demat TD and if the customer wishes to sell the TD to other beneficiary the TD sale amount will be entered here TD Sale Currency The system will display the TD sale currency This is displayed based on the TD account currency Account Block Details Account Blocked Check this box to block the TD account This field is enabled only during amendment of the TD Reason Code Specify the reason for blocking the TD account Select the appropriate reason code from the option list Following Block codes should be used as the reason code for blocking e Bank I
54. term deposit accounts in the system using the Deposit Account Summary screen To invoke this screen type STSCUSTD in the field at the top right corner of the Application tool bar and click the adjoining arrow button ORACLE Deposit Account Summary Authorization Status Record Status Branch Code Account Custody Stat Account Stat Document Status ne Search Advanced Search Records perpage 15 f jq 4 1 of 1 py imi Authorization Status _ Record Status Custody Stat me You can query on records based on any one or all of the following criteria e Authorization Status e Record Status e Branch Code e Term Deposit Account Number e Custody Status e Document Status e Account Status Click Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them e Authorization Status e Branch Code e Term Deposit Account Number e Description e Customer No id ORACLE e Term Deposit Currency e Custody Status e Document Status e Account Status e Account Description e Customer Number e Account Class e Account Open Date e Alternate Account Number e Account Number e Account Type Double click on a record to invoke the detailed screen 5 19 Specifying Deposit Instructions You can give instructions for processi
55. the September 5 2001 there has been no movement of funds in the particular account If you have opted for the Generate Only on Movement option the system will not generate a statement message for September 5 2001 If you choose not to enable this option account statements will be generated regardless of whether there has been a movement of funds or not Type You can specify whether you want a detailed or summary statement or if you do not want a statement for this account at all Account The system displays the account number for which you are setting the statement details Cycle You can specify the frequency for generating the account statements To specify the frequency of the statements click on the adjoining drop down list The following list is displayed e Annual e Semi annual e Quarterly e Monthly e Fortnightly e Weekly e Daily On For a weekly statement you specify the day of the week on which account statements should be generated and for fortnightly and monthly statements the dates of the month To specify for weekly statements click on the adjoining drop down list The following list of days will be displayed e Monday e Tuesday e Wednesday e Thursday vr ORACLE e Friday e Saturday e Sunday To specify for monthly statements enter a number between 1 and 31 corresponding to the system date If you set the statement date to 30 then account statements will be generated on e last working
56. the Tax Bourne by parameter is selected as Bank 10 2 3 Maintaining Transaction Code You can invoke Transaction Code Maintenance screen by typing STDTRCOD in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button we ORACLE Transaction Code Maintenance Transaction Details Transaction Code Description SWIFT Code Availability Information Q Immediate Q On Value Date After Days with New Value Date O After X Days Preferences Maker Checker For the transaction Code DPT Deposit Tax attach the Tax Scheme DPTS Deposit Tax Scheme by using the Cheque Mandatory O interest and Charges Transaction Count Interest and Charges Turnover Inclusion Consider For Account Activity Interest and Charges Balance Inclusion Consider for Turnover Limit Consider For Cover Account Date Time Date Time MIS Head External Code Anti Money Laundering Monitoring Money Laundering Required Product Category LE Statement Day Basis Current Working Day Intraday Release Salary Credit v Available Balance Check Required Interests and Charges Penalty Inclusion Inter Branch in Local Currency Acumen Transaction Code Exempt Advance Interest Escrow Processing Available Balance Update T
57. the currency for the pay out Beneficiary Details Specify the following details Beneficiary Details Specify the details of the beneficiary Beneficiary Name Specify the name of the beneficiary 5 40 ORACLE Passport IC Number Specify the Passport IC Number of the beneficiary Narrative Give a brief description for the payout Beneficiary Address Specify the address of the beneficiary 5 12 Specifying Schedule Details You can maintain the schedule details in Schedule Details screen Click Schedules button to invoke the screen Schedule Details AccountNo undefined M 4 10M ES m Start Date Frequency Unit No Of installments Schedule Amount 10f1 _ Specify the following details Account No The system displays the account number of the TD Start Date Specify the start date of the payment schedule The schedule start date must be a date in the future aad ORACLE 5 13 Number of Instalments Specify the number of instalments with same periodicity Frequency Specify the frequency of the schedule Choose one of the following frequencies e Daily e Monthly e Quarterly e Half yearly e Yearly Frequency Unit Specify the unit of frequency Schedule Amount Specify the term deposit schedule amount to be liquidated for each schedule Schedule Currency The system displays the currency of the settlement amount
58. the product code that which you have specified Debit During transaction processing the system will validate whether any restrictions are placed on the account based on the product code If you have indicated to allow Dr Transactions for the product ABCD and attempt to post a debit entry the system will seek an override If the message has been configured as an override instead of an error you will be able to continue the transaction despite the restrictions by providing appropriate reasons for the same Otherwise you cannot continue with the transaction During maintenance or online operations in the respective contract screens for the restricted transactions when you specify the customer account the system checks whether the account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved ix ORACLE Credit During transaction processing the system will validate whether any restrictions are placed on the account based on the product code If you have indicated to allow Cr transactions for the product ABCD and attempt to post a credit entry the system will seek an override If the message has been configured as an override instead of an error you will be able to continue the transaction despite the restrictions by providing appropriate reasons for the same Otherwise you cannot continue with the transaction Duri
59. to debit the payment account for the payment amount as per the installment frequency Move Maturities to Unclaimed Check this field to move all the funds on the maturity date to the unclaimed GL mapped to the accounting role in the IC product Payment Branch Specify the details for the branch to which the payment account belongs Payment Account Specify the Payment Account this can be either savings account or the current account from which the installment for the Recurring Deposit is collected as per the installment frequency Installment Amount Specify the installment amount that has to be collected from the payment account as per the installment frequency This installment amount should be greater than the minimum amount mentioned at the account class Recurring Deposit Account Check this field to indicate recurring deposit account Payment Date Specify the date on which the payment needs to be done for recurring deposit account ud ORACLE 6 9 Payment Currency Specify currency of the payment amount Note the following e system enables the offset account and branch detail fields only if the option to pay is selected as the savings account e The Unclaimed Interest and Principal GLs are specified while maintaining an Interest and Charges IC Deposit Type product The Accounting Roles for the GLs are INT UNCLAIMED PRN_UNCLAIMED respectively When maintaining an IC Deposit type produ
60. to move all the funds on the maturity date to the unclaimed GL mapped to the accounting role in the IC product Note that this box is unchecked and disabled for RD Payment Branch Specify the details for the branch to which the payment account belongs Payment Accounts Specify the payment account this can be either savings account or the current account from which the installment for the Recurring Deposit is collected as per the installment frequency Installment Amount Specify the installment amount that has to be collected from the payment account as per the installment frequency This installment amount should be greater than the minimum amount mentioned at the account class Recurring Deposit Account Check this box to indicate recurring deposit account Payment Date The system displays the account booking date as the date on which the payment is made for recurring deposit account You cannot modify it Payment Currency The system displays the account currency of the payment account Note the following e system enables the offset account and branch detail fields only if the option to pay is selected as the savings account Unclaimed Interest and Principal GLs are specified while maintaining an Interest and Charges IC Deposit Type product The Accounting Roles for the GLs are INT UNCLAIMED UNCLAIMED respectively When maintaining an IC Deposit type product you have to map thes
61. while arriving at the maturity date gt Example 1 Consider the date 14 06 2013 is a currency holiday but not a branch holiday When the option Both Deposit Currency amp Branch Holidays are chosen this currency holiday will be taken into consideration for holiday treatment gt Example 2 Consider the date 15 06 2013 is a branch holiday but not a currency holiday When the option Both Deposit Currency amp Branch Holidays are chosen this branch holiday will be taken into consideration for holiday treatment gt Example 3 Consider the date 23 06 2013 is a branch holiday as well as a currency holiday When the option Both Deposit Currency amp Branch Holidays are chosen this date will be taken into consideration for holiday treatment Holiday Movement Select the holiday movement When the maturity date is falling on a holiday based on the calendar feature chosen the following options will be used for holiday movement i e based on the option chosen the maturity date will get adjusted e Next Working Day If the computed maturity date is falling on a holiday based on the holiday calendar chosen then the maturity date will be moved to the next working day e Previous Working Day If the computed maturity date is falling on a holiday based on the holiday calendar chosen then the maturity date will be moved to the previous working day e Change in the Maturity Date If this option is selected system will no
62. 0 1 10 1 INTRODUCTION PR RR 10 1 10 2 TD OPENING BY ACCOUNT DEBIT EE Ee NEE Ee Seken 10 1 10 2 1 Transaction Tax Maintenance Set Up essent nennen nennen trennen rennen 10 1 10 2 2 Defining Transaction Level Taxes as 1 10 2 10 2 3 Maintaining Transaction Code eese 10 3 10 24 Maintaining Events Classis iie EEG RH RERUM TIERE EE XE ENTE EER 10 4 10 2 5 Maintaining Role to Head Mapping Class essent eene nenne ener 10 6 11 REPORTS er 11 1 Ill INTRODUCTION inerte ebrei it ERO e RN REO adieu vaya ORE Mere E 11 1 ORACLE 11 2 CUSTOMERS FIXED DEPOSIT REPORT ccccccecececececeeeeseeeeeecececececeeeeeeeeseeeeceeecececeeececececeeeeeeeeeeeeeceeeeeeesess 11 1 11 214 Contentsof the Report isse tete rU ROI ER RR nre EP e CER ie E e ERREUR ERR 11 2 11 3 TD FULL BALANCE LISTING REPORT ccccccececececesecseeeseececeesceeseeeseececeeececececececececeeeceeeeeeeeeeeeeceeeseeesess 11 3 1134A CONTENU OF the Report eet Ren ERREUR E RS 11 4 eddie m 11 5 Jl Contentsof the Report iie remet HER OUR IRE RR E RE side CERE ree o ER R 11 6 11 5 DEPOSIT DETAIL SUMMARY BY TOTAL AMOUNT REPORT scceceseeeceseescecececececececececeeeeeceeeeeeeceeeeeeeeess 11 6 II3 l Contents Of the Report te r
63. 1 12 09 IACR Interest Accrual 1 6 2011 12 13 IACR Interest Accrual m 7 2011 12 15 IACR Interest Accrual M Accounting Entries The system displays the following details e Reference number of the TD account e Event sequence number e Event date e Event Code e Description of the event You can also view the accounting entries and the advices by clicking Accounting Entries and Messages button respectively 5 16 Viewing Change Log Click Change Log button on the Deposit Account Booking screen and invoke the View screen ORACLE 1of1 Modification Number Modification Status MakerID Maker Date Stamp Authorization Status View Changes Remarks Maker Remarks First Checker Remarks Maker Override Remarks Checker Remarks 1of1 Warnings B Warning Code Warning Description E id 1of1 Fields E Field Name ow Value New you can view the following details e Modification Number e Modification Status e Maker ID e Maker Date Stamp e Authorization Status e View Changes e Remarks e Maker Remarks e Maker Override remarks e First Checker Remarks e Checker Remarks e Warning Code one ORACLE e Warning Description e Field Name e Old Value e New Value 5 17 Maintaining Amount Blocks Oracle FLEXCUBE allows you to facilitate creation of manual amo
64. 6 TD Operations explains the operations you can perform on a TD Chapter 7 RD Operations explains the operations you can perform on a recurring deposit Chapter 8 Annexure A Accounting Entries lists the suggested event wise accounting entries that can be set up for the Interest and Charge product applicable for the TD module of Oracle FLEXCUBE Chapter 9 Annexure B IC Rule Set up lists the Interest and Charge IC rules that need to be maintained for the TD module of Oracle FLEXCUBE It also gives the UDEs and rates for which values need to be maintained Chapter 10 Reports provides a list of reports that can be generated in this module and also explains their contents 1 1 3 Related Documents e Procedures User Manual e Settlements User Manual e Core Entities User Manual 1 1 4 Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function New m Copy Save 6 Delete Unlock Print D Close B Re open p Reverse n Template ORACLE Icons Function eS Roll over ti Hold E Authorize Liquidate Exit Sign off o Help Delete row Option List le Add row Confirm t 2 Enter Query 0 Execute Query Refer the Procedures User Manual for further det
65. Amount Specify the amount for which TD should be simulated Next Maturity Date On selecting the rollover for the TD account the system defaults the next maturity date from the previous tenor of the deposit Deposit Tenor The system calculates the tenor of the deposit account to the difference between Interest start date and Maturity date and displays it In case of change in maturity date the system changes the value of this field Rollover Type Indicate the components that should be rolled over by choosing one of the following options e Principal e Principal Interest e Special Amount Rollover Amount If a special amount is to be rolled over you have to specify the amount less than the original deposit amount in this field exe ORACLE Term Deposit Pay in Option Indicate the method for initial funding during account creation Choose one of the following options e PAYIN BY GL e PAYIN BY CASH e PAYIN BY SAVINGS Offset Account Specify the account number GL from which the fund should transferred to TD account as part of simulation This field returns the branch code if the account is selected and NULL is returned if GL is selected If the pay in mode is GL then the system will display only GLs and if the pay in mode is account then only accounts will be displayed in the option list Recurring Deposit Specify the following details Auto Payment Take Down Check this field to allow the recurring deposit account
66. BAL M 0 AND TD PNL 100 YEAR PENALTY BASIS NET BAL M TENOR gt 90 AND TENOR lt 180 AND PENALTY_BASIS DAYS TD 2 DLY_NET_BAL_M gt 0 AND TD_PNL 100 YEAR PENALTY_BASIS DLY_NET_BAL_M TENOR gt 180 AND TENOR lt 730 AND PENALTY BASIS DAYS TD 3 DLY NET BAL M 0 AND TD_PNL 100 YEAR PENALTY BASIS DLY_NET_BAL_M Formula 2 Specify the following details Book Flag Select Booked from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select Actuals from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expression Case Result DLY NET BAL gt 0 AND PENALTY BASIS DAYS FROM START PENALTY APPLY 1 DAYS TD PNL 100 YEAR 9 10 ORACLE 9 2 3 Formula 3 Specify the following details Book Flag Select Tax from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select Actuals from the adjoining drop down list Rounding Required Check this box Click Formula Wizard bu
67. Bankers Cheque BC Transfer to Other bank PC Transfer to GL GL Transfer to Savings Account AC Note the following This option will be available only when account number generation is Auto For Dual Currency Deposits you are allowed to select only GL and Savings Account options as the pay out mode You can either select GL or Savings Account but not both You can select only one GL or one Savings account and not multiple GLs or accounts in either case Percentage Specify the amount of redemption in percentage Offset Branch Specify the branch code of the account for redemption The adjoining option list displays all valid branch codes available in the system You can select the appropriate one ou ORACLE Offset Account Specify the account number GL for redemption The adjoining option list displays all valid accounts and GLs available in the offset branch You can select the appropriate one Narrative Give a brief description for the redemption 6 2 7 1 Indicating Payout Details Click Term Deposit Payout Out button in the Interest Charges screen and invoke the following screen Term Deposit Payout Details Bank Cheque Counter Party Details Banks Cheque Bank Code Payable Branch Currency Beneficiary Details Beneficiary Name Address Line 1 Other Details Address Line 2 Narrative Address Line 3 Country Code The Bank Cheque ta
68. Check this box to indicate whether the account class supports pre closure of deposits opened under it Only when this check box is checked you log pre closure request RQST for the TD using TD Pre payment Request screen If it is unchecked and if you try to log a request then the system will display the following error message Pre Closure not supported for this type of TD When the Pre Closure is not allowed as the Account Class maintenance user cannot log the pre closure request but still user can do Pre Closure from the redemption screen where the following override will be displayed Valid Pre Closure Request is not available for the Term Deposit Currency Specify the currency The adjoining option list displays all valid currencies available in the system You can choose the appropriate one For deposits in other currencies the maximum amount will be validated after converting the deposit amount to the currency selected as Pre Closure Max Currency using standard mid rate Maximum Amount Enter the maximum pre closure amount to which the pre closure can be processed This field will be applicable only when the check box Pre Closure Allowed is checked Use Rate for Revised Tenor If you check this box the system will calculate the revised interest for the pre closure period when the pre closure requested for a rate chart allowed TD This will be applicable only for rate chart TD s If the
69. Code Event Description DEBK Deposit Booking IACR Interest Accruals ILIQ Interest Liquidation IMAT Interest Maturity RQST Preclosure Request RRQS Reversal of Preclosure Request RDBK Reversal of Payin You need to set up the following events for a Charge product Event Code Event Description CLIQ Charge Liquidation UDCH Change of UDE Values Amount Tags The following amount tags are available Amount Tags Description IACQUIRED Acquired Interest Amount IACR Interest Accrual IACR_ADJ Interest Accrual Adjustments 81 ORACLE 8 4 Amount Tags Description ILIQ Interest Liquidation Amount IMAT Interest Maturity PMAT Principal Maturity TAX Tax TAX ADJ Tax Adjustment TD PRINC Deposit Principal Amount Accounting Roles Accounting roles are automatically defaulted by Oracle FLEXCUBE based on the IC Rule attached to the particular IC product An accounting role could be accrual P L or tax payment For creation of role type standard abbreviations are used across Oracle FLEXCUBE The accounting role is created in the following format TDAA accounting role type gt lt X gt Where e TDAA represents the IC product e Xrepresents the number of the formula for which the accounting role is created If you have maintained more than one formula for a rule the system will default accounting roles for each of your formulae Example
70. D account number to be fractioned ORACLE No of Fractions Specify the number of fractions to be done on this main account The minimum number of fractions required is two Branch Code The system displays the branch code based on the TD account Currency The system displays the currency details based on the TD account Confirmed Once the fraction is processed the system displays the status of this checkbox as checked The fraction TD account numbers are then populated The fractions is confirmed only if the main TD amount is equal to the fraction TD amount and the number of fractions is equal to the number of rows of fraction TD Amount The system displays the TD amount of the main TD TD Type The system displays the value based on the main TD type The TD type can be Physical or Demat 3 6 1 Specifying Fraction Details Seq No The system displays the sequence number Fraction Account The system displays the fraction account number after the fractioning is confirmed and authorized In case the account number is auto generated then the fraction accounts are generated automatically on authorization Fraction Percentage Specify the fractioning percentage Based on the percentage given the system creates the fractioned TD Fraction Amount Specify the fraction amount The system displays the fraction amount based on the fraction percentage ORACLE Type Select the beneficiary type of the new TD account f
71. Date Time Date Time Number Open ance e ORACLE On invoking this screen all the outstanding and future installments are displayed You can choose to pay any multiple of the installment amount To do this the system will clear all the overdue amounts first and then allocate the amounts to current and future installments RD Account Details Specify the following details Branch Code Specify the branch where the RD resides The adjoining option list displays all valid branch codes maintained in the system You can select the appropriate one Transaction Date Specify the transaction date for which payment is supposed to be initiated RD Account Number Specify the RD Account Number You can also choose the appropriate one from the option list The option list displays the deposit type of accounts maintained in the system Maturity Date The system display the maturity date of the RD on specifying the recurring deposit account Installment amount The system displays the installment amount for the RD on specifying the recurring deposit account CCY The system displays the currency for the RD on specifying the recurring deposit account Payment Details Specify the following details Payment Branch Code Specify the code assigned to the branch in which the payment is to be made The adjoining option list displays all valid branch codes maintained in the system You can select the appropriate one Payment Account Numbe
72. Description Cheque Number Accounting Entries 10f1 Specify the following details Branch Code Specify the branch code of the account Account No Specify the TD RD Account numbers of the branch The adjoining option list displays the list of all the valid TD RD account numbers maintained in the system You can choose the appropriate one Trn From Date Specify the transaction from date Trn To Date Specify the transaction to date Cheque Number Specify the cheque number issued for the transaction Currency The system displays the account currency of the account being queried Action Select the event of the account for the action This drop down will have aoe ORACLE e Booking e Liquidation e Accrual e Rollover e Redemption e RD Payments e RD Payments e Reversal Account Description The system displays the description of the account being queried Account Class The system displays the account class of the account being queried Description The system displays the description of the account class of the account being queried Accounting Entries You can view the accounting entries details Event The system displays the event of transaction of the account being queried Description The system displays the description of the transaction i e the description of the transaction code Branch The system displays the account branch of transaction of the
73. ED 10 INTEREST 251110002 Mterest Payable to FORMULA 10 er TDFN ACQUIRED L TDFN ACQUIRED 1 1 NTEREST 9 251110002 11_ m its id TDFNACQUIRED TDFN ACQUIRED 2 NTEREST 251110002 Payable to FORMULA 2 ime Deposits mi TDFN ACQUIRED amp e al Specify the following details in case you have opted for moving interest and or principal to unclaimed GL Accounting Role Choose UNCLAIMED and INT UNCLAIMED from the adjoining list Account Head Attach INT UNCLAIMED to a miscellaneous GL for unclaimed interest for eg 25691234 Similarly map PRN_UNCLAIMED to a miscellaneous GL for unclaimed principal for eg 25691235 vce ORACLE 3 8 2 Linking TD Account Class to Interest Product You can link the TD Account Class to the Interest product in the Interest and Charges Interest Product Preferences screen Click Preferences button on the Interest and Charges Product Maintenance screen and invoke the following screen Interest Product Preferences x Product Code TDFN UDE Currency Description TD FINAL PDT Product Type LM Parameters Calculation and Liquidation Accrual Product Level Payment Method Bearing Accrual Day 0 Discounted Frequency Amount Block for Discount Cycle Days 0 First Liquidation On 12 31 2010 Months 1 Liquidation at Month Ends Year 0 Start Date 12 31 2010 Start From Account Opening Back Value Recal
74. ERMDEP45 Currency U S Dollar Effective Date Interest Rate 01 January 2005 12 5 14 January 2005 12 0 31 January 2005 13 0 These rates will be applicable as follows Period Interest Rate 1 January to 13 January 2005 12 5 14 January to 30 January 2005 12 0 31 January to one day before the next date 13 0 The rates will be applied to an account depending on whether it has been defined with Automatic Rate Code Usage or Periodic Rate Code Usage You can specify this in the UDE Values screen Amount Slab For a specific Rate Code and Currency combination you can define an amount slab However this is not mandatory A rate that has been defined for an Effective Date Amount Slab combination will be applicable to an amount less than or equal to the specified amount 4 ORACLE Example Let us extend the example we discussed for Rates and Effective Dates to include amount limits Amount USD Effective Date Interest Rate 10 000 01 January 05 12 5 50 000 01 January 05 13 0 999 9 million 01 January 05 14 0 If the rates have to be applied on 1 Jan 05 they will be picked up as follows e For a loan with an amount less than or equal to USD10 000 the rate will be 12 5 e loan with an amount greater than USD 10 000 and less than or equal to 50 000 the rate will be 13 e For
75. Exrate e Amount 5 7 Specifying Statement Details Click Statement button on the Deposit Account Booking screen and invoke the Statement Details screen Statement Details Primary Account Statement Previous Statement Details Generate Statement Only Date On Movement Balance None No Summary Detailed Account Secondary Account Statement Previous Statement Details Generate Statement Only Date On Movement Balance None No Summary Detailed On Tertiary Account Statement Statement Account Generate Statement Only On Movement Previous Statement Details Date Balance No Type Exclude Same Day Reversal Transactions from Statement Exclude Same Day Reversal Transactions from Statement rae You can specify the following details Primary A C Statement This refers to the type of statement to be generated periodically by the system for this account You can specify whether you want a detailed or summary statement or if you do not want a statement for this account at all 5 19 ORACLE Generate Stat Only On Movement Check this box to indicate that an account statement should be generated for the account only when there has been a movement of funds into the account or when funds have been transferred out of the account For instance let us assume that on the August 21 2001 you have set the account statement generation frequency as Daily for the account LI020804 On
76. Formula Wizard screen In this screen you need to maintain the following expression Case Result AND PENALTY APPLY 1 YEAR 100 DEPOSIT AMOUNT 20 PENALTY BASIS DAYS FROM START TD PNL Formula 3 Specify the following details Book Flag Select Tax from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list 9 16 ORACLE Days in a Year Select Actuals from the adjoining drop down list Accrual Required Check this box Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expression Case Result FORMULA1 gt 0 FORMULA1 TAX_RATE 100 9 2 4 1 Formula for Discounted Interest Sample formula below DEPOSIT AMT TENOR RATE YEAR 100 DEPOSIT AMT System defined Element SDE for principal amount of the deposit TENOR SDE for tenor of the deposit RATE UDE for interest rate on the deposit YEAR SDE days in the year 360 365 366 Actual 9 17 ORACLE 9 3 UDE Value Maintenance You can maintain UDE values for the rules using the Interest amp Charges User Data Element Maintenance screen You can invoke the Interest amp Charges User Data Element Maintenance screen by typing ICDUDVAL in the field at the top right corner of th
77. LTY BASIS TENOR YEAR Maintain the following UDEs Type For each of the UDEs select the option Rate from the adjoining drop down list TD 1 TD 2 TD 3 TD PNL TAX RATE 9 8 ORACLE Get Latest For each of the UDEs select the option Use Effective from the adjoining drop down list Click Formulas button and invoke the Formulas screen You need to maintain two booked formulae and one tax formula Formula 1 Specify the following details Book Flag Select Booked from the adjoining drop down list Debit Credit Select Credit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select Actuals from the adjoining drop down list Accrual Required Check this box Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen Formula 1 Specify the following expressions Case Result TENOR lt 90 AND DLY_NET_BAL_M DAYS 1 100 DLY NET BAL M 0 AND YEAR PENALTY BASIS 0 TENOR gt 90 AND TENOR lt 180 AND DLY_NET_BAL_M DAYS TD_2 100 DLY_NET_BAL_M gt 0 AND YEAR PENALTY BASIS 0 9 9 ORACLE Case Result TENOR gt 180 AND TENOR lt 730 AND DLY_NET_BAL_M DAYS TD 3 100 DLY NET BAL M 0 AND YEAR PENALTY BASIS 0 TENOR 90 AND PENALTY BASIS DAYS TD 1 NET
78. MM Floating Rate Input ICDBADHC Term Deposit Advice ICDINSTR Term Deposits Instruction Maintenance ICDPMNTS Recurring Deposit Payment Input ICDPMREV Recurring Deposit Payments Reversal ICDPRMNT Interest amp Charges Product Maintenance ICDRATES Interest amp Charges Rate Input ICDREDMN Term Deposits Redemption Input ICDRESTR Interest amp Charges Branch Availability Maintenance ICDRLMNT Interest amp Charges Rule Maintenance ICDUDVAL Interest amp Charges User Data Element Maintenance ICSEXELG Term Deposits Execution Log Summary ICSINSTR Term Deposits Instruction Summary ICSPMNTS Recurring Deposit Payment Summary ICSREDMN Term Deposits Redemption Input Summary STDACCLS Account Class Maintenance STDADMNT Non CIF Address Maintenance STDAMBLK TD Amount Block Input STDCLOSE Term Deposit Closing Mode Maintenance STDCUSTD Deposit Account Booking 12 1 ORACLE Function ID Function Description STDSCSAC Term Deposit Simulation STDTDPAY Term Deposit Pay In Parameters Maintenance STDTDFRA TD Fractioning STSCLOSE Term Deposit Closing Mode Maintenance STSCUSTD Deposit Account Summary STSTDPAY Term Deposit Pay In Parameters Summary TDDPRPPY Deposit Redemption Request TDRCLOSE TD Account Closed Report TDRDDSUM Deposit detail summary TDRFDREP Large FD report TDRFIDEP Customers Fixed Deposit Report TDRFULBL TD Full balance Listi
79. MT Payout Redemption amount PENALTYDET Penalty details _ MAKERID Teller name _ TXNDATETIME Transaction date amp time 8 6 ORACLE 8 5 1 2 Rollover Advices This rollover advice will be generated only for term deposits during rollover A message type TD_ROLL will be used Tag Description _ BRANCHNAME Branch Name BRNADD1 Branch address line 1 BRNADD2 _ Branch address line 2 BRNADDS Branch address line 3 TDATE Rollover date Advice Reference _CUSTNAME Customer name _ADD1_ Customer address line 1 _ADD2_ Customer address line 2 _ADD2_ Customer address line 3 _ADD4_ Customer address line 4 TDACNO _ Term deposit account number _AMT_ Rollover amount _CCY_ Term deposit currency _DEPTTENOR Term deposit tenor _MATDATE_ Maturity date __ Maturity amount _INTRATE_ Interest rate _INTAMT_ Projected Interest amount JTDROLLTYPE Rollover type BLOCKEDAMT Blocked Lien amount TAXAMT Tax Amount TAXRATE Tax Rate 8 7 ORACLE 8 5 1 3 TD Advice This advice will be generated for original and duplicate advice for Term Deposit A message type ICCOD will be used The tag DUPLICATE will be displayed only in case of duplicate advice generated Tag Description _ BRANCHNAME Branch Name BRNADD1 Branch address l
80. Name Guardian Name Date of Birth Relationship Relationship Address1 Address1 Address2 Address2 Address3 Address3 Address4 Address4 Minor Linked Enies Restrictons ms statement Jom ders iiis Account signatory TO Payout Detar Endorsement Log Preterences vent change Loo Maker Date Time Mod No Checker Record Status Exit Date Time Authorization Status Specify the following details Name Specify the name of the nominee Date of Birth Specify the date of birth of the nominee 4 18 ORACLE Relationship Specify the relationship of the nominee with the customer Address 1 to 4 Specify the address of domicile of the nominee You can enter the address in four lines You can specify a maximum of 105 alphanumeric characters in each line Minor Check this box if the nominee is a minor Guardian Name If the nominee is a minor specify the name of the guardian Relationship Specify the relationship of the guardian with the minor Address 1 to 4 Specify the address of domicile of the guardian You can enter the address in four lines You can specify a maximum of 105 alphanumeric characters in each line 2 09 ORACLE 4 1 8 Deposit Tab Click Deposit tab on the Deposit Account Booking screen The following tab will be displayed Deposit Account Booking Branch Code 000 Customer No 000000102 Pay In Option Term Deposit Account Customer Name ARAR Pay in Mode Others Nu
81. Number Open Combine the tax rule into a Tax Scheme DPTS Deposit Tax Scheme 10 2 2 Defining Transaction Level Taxes as Classes You can define the attributes of a transaction level tax under the corresponding section of the Tax Class Maintenance screen You can invoke this screen by typing TADTAXCL the field at the top right corner of the Application tool bar and clicking the adjoining arrow button is ORACLE Tax Class Maintenance Class Code Class Description Module las Description Transaction Level Tax Issuer Tax Type Withholding Net Consideration Borne By Bank v Add Subtract v C Cash Outflow SWIFT Qualifier Event For Association az Basis Component Event for Application aZ Default Rule Event For Liquidation az C Default Waiver Allow Rule Amendment C Allow Amount Amendment Amend After Association Cl Amend After application Input By Authorized By Modification Authorized ext Date Time Date Time Number Open You can create a Tax Class DPTCL Deposit Tax Class Refer the section Maintaining Tax Class in Class User Manual under Modularity for details about this screen On the Transaction Tax Maintenance STDTRNTX Screen link the Tax Scheme DPTS Tax Class DPTCL and the GL Account Head 1110111 This GL Account Head 1110111 will be debited with the Tax Amount in case
82. R DEPOSIT AMOUNT de ORACLE 4 1 4 TD Account Creating a Deposit Account You can create a term deposit account using the Deposit Account Booking screen To invoke this screen type STDCUSTD in the field at the top right corner of the Application tool bar and click the adjoining arrow button Click New button on the Application toolbar If the user has multi branch operational rights the system will display Transaction Branch screen Here you can select the transaction branch Transaction Branch Code Transaction Branch Code Here you are allowed to book other branch transactions from the logged in branch Also you can query other branch transactions from the logged in branch The system defaults the logged in branch by default as the transaction branch Transaction Branch Select the appropriate branch from the list of branches available in the option list This screen will be available only for those users who has Multi Branch Operational check box enabled at User Maintenance Screen While clicking Ok button the system validates the access rights of the selected branch and function for the user If you don t have appropriate rights on the selected branch and function the system would raise an error message If you select a valid branch the system updates the same as transaction branch and the transaction would be posted for this branch The system performs the action level acce
83. RC02 PNL 2 RC02 TPBL_ADJ 3 RC02 TPBL 3 TDACCOUNT TDOFFSE0054 TDRD ACCR 1 TDRD ACQUIRED 1 TDRD ACR ADJ 1 TDRD BOOK 1 TDRD BOOK 2 TDRD BOOK 3 TDRD PNL ADJ 1 TDRD PNL ADJ 2 TDRD PNL 1 TDRD PNL 2 TDRD TPBL ADJ 3 TDRD TPBL 3 INT UNCLAIMED MAT UNCLAIMED PRN UNCLAIMED 85 TD Advices The following list contains details of the advices that are applicable to the TDs you can process at your bank 8 5 1 1 Redemption Advices This redemption advice will be generated only for term deposits with option Redemption Advice Required checked at the product level A message type REDM will be used 8 5 ORACLE Tag Description BRANCH Branch code of the term deposit REF TD account number _ BRANCHNAME Branch name where term deposit is held BRNADD1 Branch address line 1 BRNADD2 Branch address line 2 BRNADDS Branch address line 3 CUSTID _ CIF ID _ CUSTNAME Customer name _ADD1_ Customer address line 1 _ADD2_ Customer address line 2 _ADD2_ Customer address line 3 _ADD4_ Customer address line 4 _CCY_ Currency of Term Deposit _AMT_ Term deposit amount _ TOTREDMAMT _ Total Redemption amount MATDATE _ Maturity Date REDMDATE Redemption date _ REDMBRANCH Redemption account branch REDMACCOUNT Redemption account to REDMNARRATIVE Redemption narrative PAYOUTTYPE Pay out Type PAYOUTPERONT Payout Percentage PAYOUTREDMA
84. SE in the field at the top right corner of the Application tool bar and click the adjoining arrow button Term Deposit Closing Mode Maintenance A Authorization Status v Record Status v Close Mode le Debit Credit Credit Q Search Advanced Search Reset Records per page 14 414 Authorization Status Record Status Close Mode Description Product DebitCredt Authorization Status A Authorized U Unauthorized Record Status C Closed O Open You can query on records based on any one or all of the following criteria e Authorization Status e Record Status e Close Mode e Debit Credit Click Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them e Authorization Status e Record Status e Close Mode RS ORACLE 3 5 e Description e Product e Debit Credit Double click on a record to invoke the detailed screen for that record Maintaining Account Class for TD To handle term deposits in Oracle FLEXCUBE you have to set up an account class of type Deposit in the Account Class Maintenance screen To invoke this screen type STDACCLS in the field at the top right corner of the Application tool bar and click the adjoining arrow button Account Class Maintenance Account Class Start Date Descrip
85. Schedule Details On clicking Explode button the system displays the following details e Due Date the schedule due date e Amount the term deposit amount for the schedule with currency e Status the schedule status whether Due or Paid e Paid Amount the amount paid out as schedule In case TD has an amount block and the schedule amount could not be paid in full on the schedule date the schedule will be paid out from the available amount This field displays such amount paid Viewing Endorsement Log Click Endorsement Log button to view the Endorsement Log screen du ORACLE TD Endorsement Log Account Number 0000000917000000017 Endoresement Details 10f1 Serial Date Of Endorsement Beneficiary Type Beneficiary ID Short Name 1 11 30 2011 009000422 1 009000421 lt You can view the following details on this screen Account Number The system displays the account number of the TD Serial Number The Sequence number of endorsement is displayed Beneficiary ID The system displays the beneficiary ID Date of Endorsement The system displays the date on which endorsement happened Name The system displays the name of the beneficiary Short Name The system displays the short name of the beneficiary Beneficiary Type The system displays type of beneficiary as either Single or Joint Account Endorsee The system dis
86. Term Deposits Oracle FLEXCUBE Universal Banking Release 11 3 2 0 0LA April 2014 Oracle Part Number E53607 01 ORACLE FINANCIAL SERVICES ORACLE Term Deposits Table of Contents 1 ABOUT THIS MANUAL p 1 1 1 1 INTRODUCTION C 1 1 1 1 1 1 1 1 1 2 IgM 1 1 1 1 5 1 2 1 1 4 Glossary OF ICONS eet n Hint Cose Vica tse vied etd 1 2 2 TERM DEPOSITS AN OVERVIEW 2 1 2 1 1 4 2 1 2 2 TERM DEPOSIT IN ORACLE 2 1 AIO NIRE 2 2 2 2 1 Pre requisites Jor TD Proc Ssihg siii site E PEE 2 2 3 TERM DEPOSIT MAINTENANCE 3 1 3 1 MAINTAINING PAYIN PARAMETERS wossicsscccsscocessesctdsscssssiescoaceiaess evades abe ERE ER etr ede SERE het eic Ele a einn 3 1 3 1 1 Specifying UDF Values iiie ek sets seas e Ue eee ed 3 2 3 2 VIEWING PAYIN PARAMETERS SUMMARY
87. XURE A ACCOUNTING ENTRIES cscsssssssssssssssssscsssssssssssssssssnesssssesesssssessssssesssssessessesesees 8 1 8 1 ACCOUNTING ENTRIES AND ADVICES FOR inneren 8 1 5 2 JEVENISZ entente 8 1 AMOUNT PAGS E EE 8 1 B4 ACCOUNTING ROLES Rr ROTER ANTE 8 2 WD ADVICES enea 8 5 8 6 EVENT WISE ACCOUNTING ENTRIES FOR PRODUCTS ccccccescssesscsseesesseescssecssesecseeseceseecssesesesesseesesneseee 8 9 8 6 1 LD With Capit lizatioh c icit iyi tee toda edet dere 6 9 6 6 2 Normal TD with Simple Interest ise i EO Eee rebat teste Eine iter edes 6 11 6 6 3 ID with Rate Chart Allowed rtr beber 6 12 8 6 4 Product for Readjustment TDFN 6 14 8 6 5 Payable interest for one or more schedules eee eene rennen 6 16 8 6 6 TDS amount for one or schedules eese en rennen 6 16 6 6 7 Accr ed Interest for the schedule ete tke Re ERE e EROR 6 16 6 6 8 Accounting Entries for TD Opening by Account Debit on Event Class Maintenance 6 17 9 ANNEXURE B IC RULE 9 1 9 1
88. a loan with an amount greater than USD 50 000 and less than or equal to USD 999 9 million the rate applied will be 14 A huge amount 999 9 million has been given as the last amount limit This denotes that after 50 000 there is no upper limit in the slab Borrow Lend Indicator For every Amount Slab Effective Date combination you should define the rate to be applied as a borrow rate a lend rate or a mid rate Borrow rates are applied for loans taken by the bank and lend rates applied on loans disbursed Tenor and Interest Rate The rates that will be applied for a given combination of Amount Slab Effective date Lend Borrow Indicator can be tenor based In this screen you can also define interest rates for different tenors For instance for an amount slab you can maintain rates for the Rate Code LIBOR for tenors 1 30 Days 30 90 Days and so on If you do not maintain tenor wise interest rates you have to maintain the tenor as 0 and then specify the rate This is mandatory to save the details TD Maximum Interest Rate Specify the maximum interest rate for each combination of currency tenor and amount slabs This is applicable only to term deposits where check box Rate Chart Allowed is checked The Interest Rate field will be defaulted as the minimum interest rate applicable for the combination of CCY tenor amount slab PR ORACLE TD Pre Closure Differential Specify a value to compute the disco
89. account classes having Use Rate for Revised Tenor as Yes or No where appropriate formula can be picked up based on this SDE If the interest liquidation frequency is anything other than OY OM OD at TD account level and if the check box Use Rate for Revised Tenor is checked then the system will display the following error message Invalid Interest Liquidation Frequency Pre Closure Differential based formula set up The pre closure differential is used to compute the discount factor that will return the discounted maturity amount upon pre closure In order to settle the redemption amount and interest separately the following formulae will be used e Formula 1 The normal interest calculation should be maintained as a non booking credit interest formula like DEPOSIT_AMOUNT INTRATEUDE DCTENOR YEAR Please note this formula will calculate the total interest payable on the TD during the full term corresponding to the Days in a Year basis for formula 1 This is applicable only for TD s where there is no periodic interest liquidations e Formula 2 A subsequent credit interest formula can be maintained as a booking formula such that 5 ORACLE gt Condition is 0 Normal Interest obtained as the result of Formula 1 is payable gt Condition REDEM is 1 revised interest can be calculated as the result of DEPOSIT AMOUNT FORMULA1 1 PCDIFF INTRATE UDE RESIDUAL TENOR YEA
90. account being queried Account Number The system displays the account number being queried Dr Cr The system displays the Dr Cr Indicator of transaction of the account being queried Amount The system displays the foreign currency amount of transaction of the account being queried on ORACLE Lcy Amount The system displays the local currency amount of transaction of the account being queried Transaction Date The system displays the transaction date of transaction of the account being queried Value Date The system displays the value date of the transaction Trn Int Dt The system displays the transaction Initiation date of transaction of the account being queried Related Account The system displays the related account of transaction of the account being queried Auth Stat The system displays the authorization status of transaction of the account being queried User ID The system displays the user Id of transaction of the account being queried Accrual You can view the accrual details Event The system displays the event of transaction of the account being queried Description The system displays the description of the transaction i e the description of the transaction code Branch The system displays the account branch of transaction of the account being queried Account Number The system displays the account number being queried Dr Cr The system displays the Dr Cr Indicator of transaction of the account
91. ails about the icons 1 3 ORACLE 2 1 2 2 2 Term Deposits An Overview Introduction A Term Deposit TD also known as fixed deposit is a deposit that is held at a financial institution for a fixed term A fixed deposit account allows customers to deposit money for a set period of time thereby earning a higher rate of interest in return These are of varying maturities ranging anywhere from a day or a month to a few years When a term deposit is placed the lender the customer understands that the money can only be withdrawn after the term has ended and in case of premature withdrawal the financial institution can levy a penalty In some cases the customer may be required to give notice of withdrawal of term deposit in that case termed as notice deposits When the term is over the deposit can be withdrawn or it can be held for another term partly or fully Generally speaking the longer the term the better is the yield on the money Some banks put conditions like minimum amount of deposit and in multiples of specific units of amount For e g the minimum deposit amount is Euro 100 and deposits can be made in multiples of Euro 10 Banks may allow full or partial withdrawal of amount Customers can place TD as collateral while availing loan facility or while availing Letters of Credit Guarantee facility from the bank Recurring Deposit RD is an account where the lender customer deposits a fixed amount of money ev
92. aimed GLs maintained at your bank o If you check the Auto Rollover box you will not be able to check Close on Maturity box Your specifications here will default to all deposit accounts opened under the account class However when maintaining a deposit account you can change the specifications that default d ORACLE Note that this box will be automatically checked if you check the box Recurring Deposit in the Deposit Account Details screen Allow Partial Liquidation Check this box to indicate that partial liquidation is allowed If you do not check this box the system will not allow partial redemption o If Pre Closure Allowed is unchecked and check box Allow Partial Liquidation is checked then the system will display the following override Partial liquidation is selected when Pre closure is not supported for the TD account class The pre closure maximum amount will not affect the partial liquidations on the TD Refer the section Maintaining Floating Interest Rates in this Manual for details about maintenance required for partial liquidation of TD Allow Partial Liquidation with Amount Block Check this box to indicate that partial liquidation is allowed for the deposits with amount blocks If the TD is linked partially then partial liquidation of the TD will be allowed only if you check this box Move Interest to Unclaimed Check this field to move the interest amount to the unclaimed GL mapped
93. al CCY Deposit is checked at the Account Class Maintenance screen You will be allowed to modify this value even after authorization Currency Option Product Specify the currency option product under which an Options contract has to be created in case of a Dual Currency deposit The adjoining option list displays all valid Options products with Product Type CO available in the system You can choose the appropriate one On saving the account class system validates the following to ensure that the currency option product selected here has the below features e Contract type is Trade e Option Type is Call e Deal Type is Buy e Option Style is Plain Vanilla e Barrier is not allowed e Delivery type is Physical e Expiration Style is American 93s ORACLE Fixing Days Specify the number of days from TD maturity date before which the exchange rate has to be fixed You will be allowed to capture this value here only if the option Dual CCY Deposit is checked at the Account Class Maintenance screen You will be allowed to modify this value even after authorization Recurring Deposit Specify the following details for recurring deposits Recurring Deposit Check this box to indicate that a recurring deposit can be created under the account class Move Maturity to Unclaimed This box is unchecked and disabled for recurring deposits Move funds on Overdraft Check this option to indicate that the system
94. ally by the system can be manually removed in case of premature closure Only closure allowed on the amount blocks manually and amendment of these amount blocks is not allowed TD amount blocks will be available in the Amount Block Input screen Rollover Amount If a special amount is to be rolled over you have to specify the amount less than the original deposit amount in this field Payin Details You can specify the following details of the deposit Term Deposit Payin Option Indicate the method for initial funding during account creation Choose one of the following options e Clearing Cheque Instruments e internal Instruments e General Ledger e Account e Internal Cheque You can have multiple sets of amount being taken from different accounts to fund the same TD o You cannot select a combination banker s cheque and demand draft for multi mode deposits You cannot combine the payin Option As Cheque with other payin modes Transaction Tax Exempt Check this box to exempt transaction tax The check box will be enabled only when the Paying mode is selected as General Ledger Percentage Indicate the percentage of the amount to be deposited using the specified pay in mode Amount Specify the amount being deposited to open a TD using the specified pay in mode ES ORACLE Note the following e Input to one of the fields is mandatory either pay in Amount or Percentage e f you input
95. an select the account from this list Interest Charge will be liquidated into the selected account Consolidated Charge Branch Select the charge booking branch from the option list available You have an option of booking interest charge to a different account belonging to another branch The accounts maintained in the selected booking branch are available in the option list provided The system liquidates the Interest Charge into the selected account Product Code Specify the product code UDE Currency Specify the UDE currency for the product that you apply on the account UDE values that you specify for the account subsequently will be taken to be in this currency Generate UDE Change Advice Check this box to generate the UDE change advice Waive Charge This box is unchecked by default However you cannot waive charge on a TD Leave this box unchecked Open Check this box to make the product applicable again More than one product may be applicable on an account class at the same time You can temporarily stop applying a product on an account class by closing it You can achieve this by un checking the box Open The product will cease to be applied on the account class VS ORACLE Effective Date Specify the effective date of a record which is the date from which a record takes effect The system displays the maturity date of the parent TD However you can change it Open Specify the open records with different Effecti
96. anch Code to which the account belongs for which you are defining special conditions is displayed in this field Account The Account number of customer for which you are defining special conditions is displayed in this field You can click the Default button to default the Charge Products and the corresponding details applicable for the account You can then modify these values to define the special conditions 5 3 1 1 Specifying Product Details Specify the following details Product Code The system defaults a product when you click the Default button at the time of account creation You must modify it to identify the Charge product using which the applicable charges would be collected Currency The charges would be collected in the currency defined for the selected charge product and this currency is displayed on the screen id ORACLE 5 4 Minimum and Maximum You must indicate the charge amount range representing the minimum and maximum charge that can be applied for the account Free Items You must indicate the number of free items for which the customer will not be charged Open By default each charge consolidation charge setup that you set up is enabled and active You can also disable the setup by checking the Open box Waive Charges You can choose to waive charges for an account Specifying Linked Entities Click Linked Entities button on the Deposit Account Booking sc
97. ange de te assisted 6 8 6 2 4 Counter Party Details Tab eee iis cas exe ce totae EY e un da eae Eee Eee aec ep e RETE RUE 6 10 6 2 5 Capturing Interest Details iiu rep a P Cea 6 11 6 2 6 Jin AY TAD NET 6 12 6 2 7 Deposit Tab ec teet o d ate s ene ILU een EP Cue 6 14 6 2 8 Holiday Treatment if TD Payout is another eene enne entente enne 6 20 6 2 9 Holiday Treatment during TD Auto Rollover eese eene tenentes 6 21 6 2 10 Holiday Treatment during Manual 6 22 0 2 11 Authorizing ronsQction iuo petes petam sey get dae ie EROR YER nee lap CHR IRE 6 22 6 3 VIEWING TD REDEMPTION DETAILS trente inni nne 6 23 6 4 GENERATING AN ADVICE aaa 6 24 6 5 CLOSING A TD c r ME LT 6 26 6 6 TRANSFERRING TO UNCLAIMED DEPOSIT ON MATURITY eee ener enne rennen 6 26 6 6 1 Moving Principal and Interest to Unclaimed 6 27 6 6 2 Moving Principal to Unclaimed Principal retaining interest in Interest Booking Account 6 27 6 6 3 Closing TD by Payout to Loan Account esses eene eene nennen nente nre nennen enne enne 6 28 6 7 VIEWING ED EXECUTION erre retenti
98. apping Class You can build a role to head mapping class in the Role to Head Mapping Class Maintenance screen You can invoke this screen by typing CSDRHMCL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Role to Head Mapping Class Maintenance Class Code Description Module Description Role To Head Mapping 1 1 r Map Type Accounting Role Accounting Role Description Role Type AccountHead Accounting Head Description Input By Authorized By Modification Authorized Date Time Date Time Number Open For the Tax Class DPTCL following details will be maintained Map Type Accounting Role Role Type Account Head Static DPTCL_LIQD 11000001 The GL Account Head that is mapped will get credited with the Tax Amount as in our example the Tax Bourne by parameter is selected as Customer At the TD Product Level the following accounting entries will be passed for the event DEBK the accounting entries related to the Deposit Booking will have the Transaction Code DPT Accounting Role Amount Tag Dr Cr Transaction Code Dr Settlement Account TD PRINC Dr DPT Term Deposit TD PRINC Cr DPT Hefer the section Maintaining Role to Head Mapping Class in Class User Manual under Modularity for details about this screen ix ORACLE 10 2 5 1 Transaction Tax Calculation Consid
99. applicable again More than one product may be applicable on an account class at the same time You can temporarily stop applying a product on an account class by closing it You can achieve this by un checking the box Open The product will cease to be applied on the account class Interest Charges Effective Dates 85 UDE Effective Date Open Account UDE Value User Defined Elementid UDE Value Rate Code Term Deposit Payout Out Specify the following details os ORACLE Effective Dates Specify the following details Effective Date Indicate the date from which a record takes effect using the adjoining calendar Open Check this box for records with different effective dates if the values of the UDEs vary within the same liquidation period Account UDE Value Specify the following details User Defined Element ID Specify the UDE ID for the account UDE Value Specify the values for a UDE for different effective dates for an account When interest is calculated on a particular day for an account with special conditions applicable the value of the UDE corresponding to the date will be picked up Rate Code Specify the rate code for the account 6 2 7 Deposit Tab Click Deposit tab in the Interest Charges screen to capture deposit details ae ORACLE interest Charges Branch Account Class Account Customer Number Interest Deposit
100. ar and click the adjoining arrow button TD pre payment request Branch Code Customer Id Account Currency Account Description Request Details Approved Req ID Auto Liquidation Req Date Redem Date Remarks Maker ID Date Time Authorized Checker Id exit Date Time Record Status exit Here you can specify the following details Customer Id System displays the Customer id of the term deposit Branch Code System displays the branch code of the term deposit one ORACLE Account Specify the account number of the term deposit for which the prepayment request needs to be raised Account description Provide the account description of the term deposit Request Id The Request Id for the pre payment of the term deposit is auto generated by the system Qv cannot create a request for a TD account which already has a prepayment request Req date The system defaults the system date of the branch as the request date for the pre payment of the term deposit however you can create a new request if the previous request is expired or has be reversed Redemption Date The system will display the Redemption date based upon the parameters maintained at the account class level However you can change it The redemption date has to be greater than or equal to the Request date redemption date can be either the system date or the calculated date i e system date plus the prepayment notice
101. at happens to the settlement account linked to this account class of a loan contract or retail teller contract if the system detects insufficient funds in the account during liquidation In other words the system will track the account for receivables credits As and when a credit happens the funds will be allocated to the loan or the retail teller contract for liquidation Replicate Customer Signature Check this box to indicate that customer signature should be replicated to the account Endorsable The system displays whether the TD is endorsable or not based on the maintenance in the account class You cannot modify this after saving the TD 6 ORACLE Auto Liquidation Schedule Check this book to enable auto liquidation In case of a TD booked with schedules if you check this the schedule payout happens automatically on the schedule date Otherwise the schedule payout will not happen on the schedule date You need to redeem the schedule amount manually Status Tracking Custody Status The system maintains the following for custody status of a TD You can choose one of the following e Retention if external cheque or instrument clearing is used for the TD pay in e Electronic Custody TD in Active status and pay in has happened e With Client once TD is printed e Duplicate Issued If the option Mark as Duplicate is checked while printing a TD e With Third Party If the third party bank cod
102. ated the print reprint or reversal of print request Blank in case the custody status is Electronic Custody or With Third Party e Maker Maker ID e Date Time Maker Date Time e Checker Checker ID Date Time Checker Date TimeDocument Status The system maintains the following doc statuses You can choose one of the following e Prepayment Requested if there is a prepayment request which is yet to be approved or rejected e Subject to Liquidation if there is a prepayment request which is approved e Prepayment Cancellation if there is a prepayment request which is rejected or reversed This field is enabled only when a pre closure request is made approved or rejected Account Status The system maintains the following account status e Inactive TD account opening without pay in e Active TD account with pay in e Paid Closed on or after maturity e Prepaid Redeemed or closed before maturity e Over Due Unclaimed after maturity e Susceptible to renew Grace days period between maturity date and rollover working days e Cancelled due to clearing cheque return the system close the TD without paying interest e Reversed close of inactive TD or close of active TD on the activation date itself Demat Details TD Type Select the type of account from the drop down list Following are the options available in the drop down list e Physical e Dematerialized T9 ORACLE The
103. ault the system displays the current application date Branch Specify the branch code of the TD account The adjoining option list displays the list of all the valid TD RD branch codes maintained in the system You can choose the appropriate one Account Class Specify the account class of TD account The adjoining option list displays the list of all the valid TD RD account classes maintained in the system You can choose the appropriate one ORACLE Customer Specify the customer number of the customer The adjoining option list displays the list of all the valid customer numbers maintained in the system You can choose the appropriate one Click OK button to generate the report Click Exit to return to the Reports Browser Body of the report The generated report will have the following information Field Name Field Description Account No Deposit No This indicates the TD account Number Customer Name This indicates the Name of the TD account holder Closed Date This indicates the TD account closed date Amount of Deposit This indicates the Deposit Amount Maturity Date This indicates the Maturity date of the TD account Reason for Closure Display the Narrative which is captured during the TD Redemption For auto closed account this will be blank Proceeds credit to This will show the Payment Mode of the Redemption Interest Amount This indicates th
104. b is displayed by default You can capture the following details for pay out using a banker s cheque Banks Cheque Specify the following cheque details Bank Code Specify the bank code of the Bankers cheque Payable Branch Specify the payable branch for the cheque The adjoining option list displays all branch codes linked to the specified bank code You can select the appropriate one Currency The currency code is displayed here oe ORACLE Beneficiary Details Indicate the following details Beneficiary Name Specify the name of the beneficiary Other Details Specify other details if any for the beneficiary Narrative Give a brief description for the payout Country Code Specify the country code for the payout address Address Line 1 to 3 Specify the address of the beneficiary for the payout 6 2 7 2 Counter Party Details Tab Click Counter Party Details tab on the Term Deposit Payout Details screen and invoke the following screen Here you can capture details for pay out through PC transfer to another bank account Term Deposit Payout Details Bank Cheque Counter Party Details Counterparty Details Counter Party Bank Code Counter Party Offset Account Currency Beneficiary Details Beneficiary Name Address Line 1 Other Details Address Line 2 Narrative You can capture the following details ey ORACLE 6 2 8 Counter Party Details Specify the following cheque details
105. both Amount and Percentage the value in Amount field will take precedence Offset Branch The system populates the branch code of the account from which fund is transferred to TD account Offset Account Specify the account number GL from which the fund is transferred to TD account This field returns the branch code if the account is selected and NULL is returned if GL is selected If the pay in mode is GL then the system will display only GLs and if the pay in mode is account then only accounts will be displayed in the option list Narrative Specify description for the offset branch for TD Account Deposit Account Booking Term Deposit Payout Details Payout Type Percentage Offset Branch Offset Account Narrative ETE v Recurring Deposit Installment Frequency Auto Payment Takedown Move funds on Overdraft Move Maturities to Unclaimed Days Payment Branch a Months Payment Accounts a Years Installment Amount Recurring Deposit Account Payment Date Payment Currency I lt Maker Date Time Mod No Record Status 3 Cancel Checker Date Time Authorization Status Term Deposit Payout Details The TD module allows you to close a TD using multiple pay out modes viz e Pay out by Bankers Check e Pay out by transfer to GL e Pay out by transfer
106. ccounting Role Amount Tag Dr Cr Indicator RC02 BOOK 2 ILIQ Debit RC02 BOOK 1 IACQUIRED Credit RC02 ACQUIRED 1 IACQUIRED Debit RC02 BOOK 2 IACQUIRED Credit RC02 PNL ADJ 2 IACQUIRED Debit RCO02 PNL 2 ILIQ Credit RC02 BOOK 3 TAX ADJ Debit RC02 BOOK 3 TAX Credit RC02 TPBL_ADuJ 3 TAX ADJ Debit RC02 BOOK 1 ILIQ Credit RC02 ACCR 1 ILIQ Debit RC02 TPBL 3 TAX Credit 8 13 ORACLE 8 6 3 4 IMAT Interest Maturity Accounting Entries Accounting Role Amount Tag Dr Cr Indicator INT LIQD IMAT Debit INT BOOK IMAT Credit PRINC LIQD PMAT Debit PRINC BOOK PMAT Credit 8 6 4 Product for Readjustment TDFN For readjustment a sample rule TDFN has been mentioned in Annexure B The following accounting roles and events are needed to calculate readjustment for the sample rule TDFL 8 6 4 1 DEBK Book Accounting Entries Accounting Role Amount Tag Dr Cr Indicator TDACCOUNT TD PRINC Credit TDOFFSET TD PRINC Debit 8 6 4 2 IACR Interest Accrual Accounting Entries Accounting Role Amount Tag Dr Cr Indicator TDFN ACR ADJ 1 IACR ADJ Credit TDFN PNL ADJ 1 IACR ADJ Debit TDFN ACCR 1 IACR Credit TDFN PNL 1 IACR Debit 8 6 4 3 ILIQ Interest Liquidation Accounting Entries Accounting Role Amount Tag Dr Cr Indicator 8 14 ORACLE TDFN BOOK 1 ILIQ Credit TDFN
107. ch e reference number e The report Module e contents of the message To procure a hard copy of the certificate click Print The generated certificates are also available through the Messaging browser Messaging archival or purge action determines the storage or removal of these certificates from the Application Browser one ORACLE 6 8 4 Specifying Interest Details for Simulated Account To specify the interest and charge related details of the term deposit account click the Interest button The screen is as shown below Special Conditions Maintenance Hlal Interest Start Date Account Details Charge Start Date Branch Interest Booking Branch Account Charge Booking Branch la O Dr Cr Advices E Calculation Account Interest Booking Account Charge Booking Account C interest Statement Product Details C Waive Product Product az Generate UDE Change User Defined Element Advice Currency Open IL Product Mop Display IL Type UDE Values Dates ss o E Interest SDE az You can define the interest and charge related details associated with the customer s deposit account ORACLE For more information on specifying Interest details for TD refer to the section Specifying Interest Details in the chapter TD Additional De
108. ch values need to be maintained 9 2 IC Rule Maintenance The components required to calculate interest the principal period and rate are broadly referred to as Data Elements Data elements are of two types e System Data Elements SDEs e User Data Elements UDEs In addition to specifying how the SDEs and UDEs are connected through the formulae you also define certain other attributes for a rule using the Interest and Charges Rule Maintenance screen You can invoke this screen by typing ICDRLMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Rule Id Apply Interest On Account Opening Month Rule Description Primary Element System Elements LIESS 0 las eds Forma Rate Input By Date Time Note the following On Account Closure Month LM Parameters CJ Integrated LM Integrated LM Type we User Elements Get Latest User Elements Type v Use Effective Amount Modification Number Authorized By Date Time Authorized exit Open a ORACLE e Use the SDE DLY NET BAL for capitalization of interest when the interest booking account is mentioned as the TD account e Use the SDE DEPOSIT_AMOUNT for simple interest calculation based on deposit amount original principal when interest booking account is mentioned as TD account
109. cks of type discounted exist the system throws an override stating Amount Blocks exist for the Discounted Deposit Account In case of partial redemption the amount block on the TD account will be updated to the extent of the credited discounted interest On accepting the override the system will close the amount blocks and process the redemption The amount blocks can also be closed manually However in the case of a full redemption the system will close any existing amount Blocks of type discounted and process the redemption A new amount block is created by the system for the balance amount of the deposit A discounted term deposits can also be renewed within the grace days You can select the TD account and define the tenor for which TD should be renewed During renewal of discounted term deposits event ROLL is triggered with accounting entries for the interest paid on the extended period The system changes the TD interest start date as the maturity date of the old TD In Deposit Accounts Booking screen you can see the new maturity date based on the tenor Note the following e You cannot choose Partial Redemption for a Recurring Deposit RD e You cannot redeem an auto created deposit ORACLE Redemption Amount Specify the redemption amount for the partial redemption Ensure that the redemption amount is less than the account balance On partial redemption the system pays only the principal amount
110. configured as an override instead of an error you will be able to continue the transaction despite the restrictions by providing appropriate reasons for the same Otherwise you cannot continue with the transaction During maintenance or online operations in the respective contract screens for the restricted transactions when you specify the customer account the system checks whether the account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved Specifying MIS Details Click MIS button on the Deposit Account Booking screen and invoke the Management Information System screen ove ORACLE Management Information System Branch Code Calc Method Account Rate Type MIS Group Spread Pool Code Linkto Group Account Level Rate Code Pool Code Reference Rate Transaction MIS Codes Cost Code Composite MIS Codes Change Log Transfer Log Specify the following details Branch Code The current logged in branch code is displayed here Account The TD account number is displayed here MIS Group For an account the transaction type of MIS class will be picked up from the account class Rate Code Specify the rate code You can also select the appropriate one from the adjoining option list which displays all valid rate codes maintained in the system Calc Method Specify the method to be co
111. ct Credit from the adjoining drop down list Days in a Month Select 30 Days from the adjoining drop down list Days in a Year Select 360 from the adjoining drop down list Accrual Required Check this box Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen 9 5 ORACLE Formula Wizard Formula Wizard a Expression Case Result Element wi Functions Operators Logical Operators Specify the following expressions Case Result TENOR 90 AND DLY NET BAL M 0 AND DLY NET BAL DAYS TD 1 100 PENALTY BASIS 0 YEAR TENOR gt 90 AND TENOR lt 180 AND DLY NET BAL M 0 AND DLY BAL M DAYS TD 2 100 PENALTY BASIS 0 YEAR TENOR gt 180 AND TENOR 730 AND DLY NET BAL M 0 AND DLY NET BAL M DAYS TD 3 100 PENALTY BASIS 0 YEAR TENOR lt 90 AND DLY_NET_BAL_M gt 0 AND PENALTY_BASIS DAYS TD_1 PENALTY BASIS DLY NET BAL M TD_PNL 100 YEAR TENOR gt 90 AND TENOR lt 180 AND DLY_NET_BAL_M gt 0 AND PENALTY_BASIS DAYS TD_2 PENALTY_BASIS DLY_NET_BAL_M TD_PNL 100 YEAR TENOR gt 180 AND TENOR lt 730 AND DLY_NET_BAL_M gt 0 AND PENALTY_BASIS DAYS TD_3 PENALTY_BASIS DLY_NET_BAL_M TD_PNL 100 YEAR Formula 2 Specify the following details
112. ct you have to map these Accounting Roles to the appropriate GLs maintained at your bank e The system allows you to select Close on Maturity box only when you specify the recurring deposit details You have to maintain deposit transaction code as DPN redemption transaction code as RED and prepayment transaction code as TRF for the recurring payments in the Branch Parameters for the Interest and Charges e recurring deposit payments are part of IC batch beginning of day activity Installment Frequency Specify the following details Move funds on Overdraft Check this option to indicate whether the Recurring Deposit account funds should move to an unclaimed account if it is overdue Days Specify the installment frequency in terms of days Months Specify the installment frequency in terms of months Years Specify the installment frequency in terms of years Deposit Audit Trail Inquiry The following new audit trail Inquiry will be provided to query the Audit Trail details of a TD and RD Accounts You can query the audit trail details of a TD and RD accounts using Customer Account TD Audit Trail screen To invoke this screen type ACDAUDTR in the field at the top right corner of the Application tool bar and click the adjoining arrow button ad ORACLE Customer Account TD Audit Trail Branch Code Currency Account No Account Description Trn From Date Account Class Trn To Date
113. culation Refund Tax on Pre Closure Flag Frequency Defer Liquidation Liqd based on A C Opening Defer Liquidation Days 0 Track Receivables Liquidation Before Month End OD interest reversible Defer Before Month End Days 0 Integrated LM Product Integrated LM Type Agreed OD Agreed OD Product Debit Interest Notification Receivable General Ledger Redemption Advice Required Account Details 1of1 38 Accoumciass Description currency Min Avg Balance forinterest Act nin Amt cov with Readjustment Exit Here you can specify preferences for profit calculation and application on the accounts to which this product is applied Account Details You can indicate the TD accounts on which this product should be applied Account Class Specify the account class of Deposit type that you have maintained for creating TDs The adjoining option list displays all valid account classes maintained in the system You can select the appropriate one 3 27 ORACLE 3 8 3 All TDs created under this account class will inherit the profit parameters maintained in this screen Note that you should not link the same account class to multiple IC products One deposit account class should be linked only to one interest product and one charge product Special Condition Check this box for the deposit type of account class Repop at Liqn If the box Rat
114. d amounts for the simulated TD account Branch The branch where the deposit account is being simulated is displayed here on clicking new icon in the Application Toolbar Customer Specify the customer for whom the account is being simulated You can also select the customer from the option list provided Customer Name The name of the customer for whom the account is simulated is displayed here based on the customer selected 0 ORACLE Account Currency Specify the currency for the deposit account You can also select the currency from the option list provided Account Class Specify the deposit type of account class under which the deposit should be simulated You can also select the appropriate account class from the option list provided Description Based on the account class specified the system displays the corresponding description Click Default button after specifying the customer account class and currency Account Number The account number of the customer for whom you need to simulate a deposit account is displayed here Status The status of the simulated account is displayed here based on the customer selected First Nominees Specify the first person to hold the right to the simulated account balance after the customer s expiration DCN The Delivery Control Number used for uniquely identifying a message in Oracle FLEXCUBE is displayed here Second Nominees Specify the secondary p
115. d in case of Dual Currency Deposit The option list displays all the Option Products with Product Type CO o You need to mandatorily specify this product if the Linked Currency is entered You will be allowed to capture this value here only if the option Dual CCY Deposit is checked at the Account Class Maintenance screen You will be allowed to modify this value even after authorization On saving the account system validates the following to ensure that the currency option product selected here has the below features e Contract type is Trade mee ORACLE e Option Type is Call e Deal Type is Buy e Option Style is Plain Vanilla e Barrier is not allowed e Delivery type is Physical e Expiration Style is American Option Contract Ref No The system displays here the reference number of Options contract that is being created while authorising the dual currency TD account Exchange Rate Specify the exchange rate between TD account currency and the linked currency Initially it will be defaulted with the standard exchange rate However you are allowed to change the same Linked Currency Settlement A c Here you can specify the settlement account of the linked currency in case if the settlement has to happen in the linked currency at maturity The adjoining option list displays all valid accounts maintained in the system You can select the appropriate one Linked Currency GL You can capture the GL used for postin
116. d to capture the following details in case you want to redeem the child TD using a banker s cheque Te ORACLE Cheque Details Specify the following details Bank Code Specify the bank code of the Bankers cheque Currency Specify the currency in which the cheque is drawn Payable Branch Specify the payable branch for the cheque The adjoining option list displays all branch codes linked to the specified bank code You can select the appropriate one Beneficiary Details Specify the following details Beneficiary Name Specify the name of the beneficiary for the pay out Passport IC Number Specify the passport or IC number of the beneficiary for the pay out Narrative Specify the description for the pay out Beneficiary Address Specify the address of the beneficiary for the pay out 5 11 6 3 PC Tab for Child TD Click PC tab to capture payment details if you want to redeem the child TD through a PC transfer to another account d ORACLE Payout Parameters Bankers Cheque PC Counterparty Counterparty Bank Code Counterparty Account Currency Beneficiary Details Beneficiary Address Beneficiary Name PassporvlC Number Narrative The following details are captured here Counterparty Specify the following details Counterparty Bank Code Specify the bank code of the counter party Counterparty Account Specify the account name of the counterparty for the pay out Currency Specify
117. date from the previous tenor of the deposit Tenor When you click Tenor button the system calculates the tenor of the deposit account to the difference between Interest start date and Maturity date and displays it In case of change in maturity date the system changes the value of this field Renewal Tenor The system displays the TD original tenor In case of manual rollover during grace the system displays the manually rolled over tenor till the end of grace days At the end of the grace days on TD rollover the renewal tenor and the tenor will be set to the new manually rolled over tenor Rollover Type Indicate the components that should be rolled over by choosing one of the following options e Principal If you select this option then the system will roll over the principal amount alone on TD maturity date or end of the grace period If interest booking account is given as TD account then on maturity date the interest amount will be first liquidated to the TD account and then settled as per the pay out details maintained for the TD account e Principal Interest For you to choose this option the interest booking account has to be the TD account If you select this option then the system will roll over the principal and interest amount on TD maturity date or end of the grace period e Special Amount If you choose this option the system will roll over the amount specified in Rollover Amount field irrespective of w
118. dated based on the liquidation order maintained for Loan Account If the payment amount is greater than the due amount then the system generates an interest book log and the account will be closed manually Note the following e The maturity date of the payout loan account should be greater than the maturity date of the TD account e Payout Loan Account and the Term Deposit Account customers are different then the system displays an override message Viewing TD Execution Log You can view the execution log of all TDs using the Term Deposits Execution Log Summary screen To invoke this screen type ICSEXELG in the field at the top right corner of the Application tool bar and click the adjoining arrow button ORACLE Branch Code Account Currency Code Run Date Search Advanced Search Reset Records per page 15 ida 1 of 1 s Branch Codel Account Currency Code Eventi Tenor Amount Run Datel Execution Status Error Reason Deposit Number Maturity Date Execution Status E Error S Success U Unprocessed You can query on records based on any one or all of the following criteria e Branch Code e Account e Currency Code e Run Date Click Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them e Branch Code e Account e Currency Cod
119. dditional Preferences and Account Mask are not applicable x ORACLE 3 5 1 Start Date Specify the date from which the account class should become active using the adjoining calendar You will be able to create accounts under this account class from this date End Date You can also specify the life span of the account class by indicating the end date The end date for an account class refers to the termination date after which creation of new account under the account class is disallowed Consequently the option list for Account Class in all further transactions screen in Oracle FLEXCUBE will not display the expired account class as of the system date However the existing accounts for the account class will be active even after the end date If you do not specify an End Date for the account class the account is taken to be open ended account class Account Details Tab This tab is displayed by default on invoking the Account Class Maintenance screen Account Code As per your bank s requirement you can choose to classify account classes into different account codes The bank can decide the manner in which the account classes are to be assigned to different account codes An account code can consist of a maximum of four characters Depending on the customer account mask maintained the value in the account code field would be used during the generation of customer account numbers through the
120. default tenor in terms of days Months Specify the default tenor in terms of months Years Specify the default tenor in terms of years Maximum Tenor Specify the maximum tenor for which deposits can be created under this account class Days Specify the maximum tenor in terms of days Months Specify the maximum tenor in terms of months Years Specify the maximum tenor in terms of years Minimum Tenor Specify the minimum tenor for which deposits should be created under this account class gate ORACLE Days Specify the minimum tenor in terms of days Months Specify the minimum tenor in terms of months Years Specify the minimum tenor in terms of years Dual Currency Deposits Dual Currency Deposit DCD is a short term currency linked deposit through which you earn a higher interest rate than regular term deposits The Bank converts the deposit currency into the linked currency at the pre determined conversion rate on the fixing date two working days prior to deposit maturity At maturity you receive the principal and interest in either the deposit currency or the linked currency whichever is weaker The following details are captured here Linked Currency Specify the linked currency if the account class is to be used for creating TD with Dual Currency option Alternatively you can also choose the currency from the adjoining option list You will be allowed to capture this value here only if the option Du
121. details are captured here Counterparty Specify the following details Counterparty Bank Code Specify the bank code of the counter party for the pay out Counterparty Account Specify the account name of the counter party for the pay out Currency Specify the currency of the counter party for the pay out Beneficiary Details Specify the following details Beneficiary Name Specify the name of the beneficiary for the pay out dn ORACLE Beneficiary Address Specify the address of the beneficiary for the pay out Passport IC Number Specify the passport or identification card number of the beneficiary for the pay out Narrative Specify the description for the pay out Note that the system will process TD payout through PC transfer using a bridge GL that is specified for the account class in the Deposit Account Details screen Refer the section Maintaining Deposit Details in the chapter Term Deposit Maintenance for details about the bridge GL 5 11 4 Capturing Payout Interest Details for Child TD As mentioned before if you have opted for creation of a child TD on maturity of the parent TD you need to specify interest details of the child TD Click Interest button on the Term Deposit Payout Details screen and invoke the Term Deposit Interest screen In this screen the system defaults all the parameters maintained for the parent TD However you can modify them Te ORACLE Term Deposi
122. djusted to the next working date If the Holiday Movement is chosen as Previous Working Day then the maturity date will be adjusted to the previous working date If the Holiday Movement is chosen as No Change in Maturity Date then the maturity date will not be adjusted However the system will display the following message Maturity Date is a Holiday as per the Holiday Treatment When there is a change in maturity date due to holiday treatment the revised tenor and maturity date will be displayed in the Simulation screen and Interest rate pick up will happen based on the revised tenor The simulation calculations will happen based on the revised tenor and the interest rate picked up for that tenor If there is an automatic change in the maturity date due to holiday treatment the system will display the following message 05 ORACLE 6 8 2 6 8 3 The maturity date and tenor has been changed due to holiday System should display the maturity date and the tenor The tenor should get adjusted accordingly and the same should be displayed and the Simulation advice also will display the details of revised tenor and maturity date Holiday Treatment for Sweep Accounts When a new TD account is created through a sweep transaction Maturity Date will get calculated If this date is falling on the holiday then the system will perform the holiday treatment below If the Holiday Movement is chosen
123. e Preferences subsystem ORACLE Button Function Events This invokes the Events subsystem Change Log This invokes the Customer Address Change Log screen 5 2 Specifying Interest Details Click Interest button on the Deposit Account Booking screen and invoke the IC Special Conditions Maintenance screen IC Special Conditions Maintenance Account Details Branch Code Account Calculation Account Interest Start Date Interest Booking Account Charge Start Date Charge Booking Account Interest Booking Branch Interest Statement Dr Cr Advices Consolidated Charge Account Charge Booking Branch Currency Rate Char Allowed Periodic Rate Product Details Product Code UDE Currency Waive Interest Generate UDE Change Advice Open Interest Type Effective Date 1of1 E UDE Values 1of1 You can specify the following details ORACLE Branch Code The Branch Code to which the account belongs for which you are defining special conditions is displayed in this field Account The account number of customer for which you are defining special conditions is displayed in this field Calculation Account Specify the header account to which the child accounts should be linked The adjoining option displays all valid accounts maintained in the system You can choose the appropriate one By default it will be same as the c
124. e e Event e Tenor e Amount e Run Date e Execution Status e Error Reason e Deposit Number e Maturity Date ore ORACLE 6 8 Simulating TD Oracle FLEXCUBE allows you to simulate a TD account in order to enhance sales and services to new and existing customers You can also provide the customer a certificate with all the details of account This certificate is generated with a pre printed number You can simulate an account for a customer using the Customer Accounts Simulation screen The details of a account can be entered in this screen and a printed certificate of the account can be obtained by using this screen To invoke this screen type STDSCSAC in the field at the top right corner of the Application tool bar and click the adjoining arrow button Term Deposit Simulation Branch Account Currency Account Number Account Class Customer la Description Customer Name Default Status First Nominees Document Number Second Nominees Account Open Date Medias Single Clearing Bank Code Joint Clearing Account Number Alternate Account Number In this screen you can input all the details of the Deposit account A term deposit account is simulated based on all the information you provide in the screen above You can also view and generate the details of the term deposit account certificate of the account Addtionally you can view the details of interest charges an
125. e PENALTY APPLY e PENALTY BASIS e YEAR 9 14 ORACLE UDE Maintain the following UDEs UDE Type TD_1 Rate as Rate Code TD_PNL Rate TAX_RATE Rate Get Latest For each of the UDEs select the option Use Effective from the adjoining drop down list Click Formulas button and invoke the Formulas screen You need to maintain two booked formulae and one tax formula Formula 1 Specify the following details Book Flag Select Booked from the adjoining drop down list Debit Credit Select Credit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select Actuals from the adjoining drop down list Accrual Required Check this box Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen Specify the following expression Case Result 9 15 ORACLE DEPOSIT_AMOUNT gt 0 DEPOSIT_AMOUNT TD_1 DAYS YEAR 100 Formula 2 Specify the following details Book Flag Select Booked from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select Actuals from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the
126. e accounting role INT UNCLAIMED on grace period end date If you select this option you will need to check the box Move Principal to Unclaimed Move Principal to Unclaimed Check this box to move the principal amount to the unclaimed GL mapped at the IC product in the accounting role PRN UNCLAIMED and liquidate the interest amount to the interest booking account on grace period end date If you select this option then only principal amount will be moved to unclaimed GL the interest will be settled as per TD pay out details If you check both Move Interest to Unclaimed and Move Principle to Unclaimed then TD amount i e Principal and interest will be moved to the respective unclaimed GLs irrespective of the TD pay out details maintained and the payout will not be given Rollover Type Indicate the components that should be rolled over by choosing one of the following options e Principal If you select this option then the system will roll over the principal amount alone on EOD of TD maturity date or BOD after end of the grace period If interest booking account is given as TD account then on maturity date the interest amount will be first liquidated to the TD account and then settled as per the pay out details maintained for the TD account e Principal Interest For you to choose this option the interest booking account has to be the TD account If you select this option then the system will roll over th
127. e Accounting Roles to the appropriate GLs maintained at your bank T ORACLE e The system allows you to select Close on Maturity box only when you specify the recurring deposit details You have to maintain deposit transaction code as DPN redemption transaction code as RED and prepayment transaction code as TRF for the recurring payments in the Branch Parameters for the Interest and Charges e On booking date RD installment accounting entries are posted during the IC batch Post End of Transaction Input stage From the second installment entries are posted during every IC BOD batch on the schedule date e RD installment is overdue due for insufficient funds in the payment account then the system will collect the overdue installment amount as soon as funds are available during the IC batch Post End of Transaction Input stage on that day During the same batch the system will also calculate the number of overdue days and apply penalty on that e RD penalty amount is calculated at the EOD but penalty is collected on account liquidation date from the interest booking account Installment Frequency Specify the following details Move funds on Overdraft Check this option to indicate that the system should pass an overdraft in the payment account i e CASA when the account does not have sufficient funds for making RD installment payment Days Specify the installment frequency in terms of days Mon
128. e Application tool bar and clicking the adjoining arrow button UDE Values Product Code az Branch Code az Effective Date Description Accrual Frequency Product Accruals Rate Chart Allowed Liquidation Frequency Days Months Years User Data Elements E User Element User Element Value Account Class Currency Code Rule Description User Element Amounts Currency Description Rate Code 1 18 TD Rate Code Input By Authorized By Modification 9 3 1 Authorized exit Open Number Date Time Date Time For details about the screen refer the chapter Giving UDE Values for Condition in the Interest and Charges User Manual In this screen you need to maintain the following UDEs for the different IC products Assume that you have maintained the following IC products e TD with Capitalization e Normal TD with Simple Interest e TD with Rate Chart Allowed e Recurring deposit Scheme TD with Capitalization You need to maintain values for the following UDEs under this product TD1 ORACLE 9 18 9 3 2 9 3 3 9 3 4 9 3 5 e TD2 e e TD PNL e TAX RATE Normal TD with Simple Interest You need to maintain values for the following UDEs under this product e TD 1 e TD2 TD 3 e TD PNL TAX RATE TD with Rate Chart Allowed You need to maintain values for th
129. e Chart Allowed has been checked for the account class then you should leave this box unchecked Refer the chapter Defining Interest and Charge Products in the Interest and Charges User Manual for details about setting up the product Refer the chapters Annexure A Accounting Entries and Advices in this User Manual for details on the accounting entry set up for the IC products Also refer the chapter Annexure B IC Rule Set up in this User Manual for details about setting up IC rules for the products Specifying Deposit Preferences Click the Deposit Preferences button in the Deposit Account Details screen to specify additional preferences for a term deposit Deposit Prefrences Deposit Allow Back Value TD Min Sys Date to Mat Date in Days Schedules Allowed TD with Rate Revision Rate Revision Required Rate Change Period in Days 90 Interest Elgibilty Details Interest Elg Dys Deposit Allow Back Value TD Check this box to allow Back value for TD Only if this box is checked back dated TD s will be allowed to be booked ven ORACLE Min Sys to Mat Date in days For back valued Term deposits the minimum days required from the current system date to the Term deposit maturity date Schedules Allowed Check this box to indicate that schedules are allowed Only if this box is checked the schedules will be allowed to be given in the TD account level TD with Rate Revision Rate
130. e Interest Amount This will show the actual interest amount which has been paid to the customer Maturity Amount This will show the sum of Deposit amount and Interest Amount Branch This indicates the Branch Name Product Code This indicates the Account Class code of the TD account Product Title This indicates the Account Class description of the TD account Product Currency This indicates the Currency of the TD account class 11 15 ORACLE 11 11Term Deposits Renewed for the Period Report This report lists the term deposit accounts which are renewed for the given period You can generate this report using TD Account Renewed Report screen by typing TDRRENEW in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button From Date To Date Branch Account Class Customer Specify the following details here From Date Enter the TD accounts which are renewed from this date However by default the system displays the current application date To Date Enter the TD accounts which are renewed till this date However by default the system displays the current application date Branch Specify the branch code of the TD account The adjoining option list displays the list of all the valid TD RD branch codes maintained in the system You can choose the appropriate one Account Class Specify the account c
131. e following UDEs under this product TD 1 TD e TAX RATE Recurring deposit Scheme You need to maintain values for the following UDEs under this product e TD 1 e OVERDUE PENALTY e RATE Rule for Calculating Readjustment For readjustment a sample product TDFN has been mentioned in Annexure A The following formuals are needed to calculate readjustment for the sample rule TDFL Book Debit Accr Condition Result Purpose ing Credit uals Flag 9 c3Z 707 9 19 ORACLE 9 c3 707 Book ing Flag Debit Credit Accr uals Condition Result Purpose Book Credit REDEM 0 OR DAYSFROMINT STRT gt INT_ELG DAYS AND SCHD AMOUN T 0 CURRENT BAL I NT RATE 100 LE AST DAYS TENOR y YEAR Interest Book Credit READJACC 1 AND DAYS_FROM CURRENT_BAL INT_RATE 100 DA YS FRMLAST LIQ START READJ ELG D AYS AND SCHD_AMOUN T 0 JYEAR TDMATRE ADJ Interest readjust ment Book Credit REDEM 0 AND READJACC 1 AND DAYS FROM START READJ ELG D AYS AND DAYS FROM _ START TENOR AND REDEM AMOU NT 0 AND SCHD AMOUN T 0 OR REDEM 1 AND READJACC 1 AND DAYS_FROM_ START gt READJ ELG D AYS AND REDEM AMOU CURRENT BAL T DMATREADJ Principal readjust ment 9 20 ORACLE F Book Debit Accr Condition R
132. e is specified This field is enabled only if you select the Account Type field as Dematerialized For Demat TDs the custody status can be selected as Electronic Custody or With Third Party 4 1 1 1 Viewing Custody Status Change You can view the history log of custody status change at account level through Custody Status Change Details screen Click Custody Status Change Details button in the Deposit Account Booking screen to invoke this screen Custody Status Change Details Mod No Action Custody Status PrintBranch Maker Date Time Checker Date Time 1 Account Creation Electronic Custody John 2012 03 05 16 14 04 John 2012 03 05 16 14 04 Print Request With client 001 John 2012 03 07 18 14 04 John 2012 03 07 18 14 04 Reprint Request Duplicate issued Jack 2012 03 09 12 18 34 Jack 2012 03 09 12 18 34 Reprint Request Duplicate issued Jack 2012 03 09 12 18 34 Jack 2012 03 09 12 18 34 Reprint Request Duplicate issued James 2012 03 09 12 18 34 James 2012 03 09 12 18 34 You can view the following details e No Mod No should be updated when an account is created and then on every subsequent print reprint and reversal of print request T ORACLE e Action The possible values for these fields are Account Creation Print Request Reprint Request and Reversal Request e Custody Status Relevant custody status value e Print Branch Branch which had initi
133. e of manual payment or pre closure of TD system updates the TD account status as prepaid or paid based on maturity date and payment value date during the payment authorization In case of reversal of pay in of inactive TD system updates the TD account status as Reversed The TD account will be open only till end of day The custody status remains By Retention until the cheque is cleared Once the clearing retention days are over system updates the custody status as Electronic Custody during the BOD TD batch processing Further and TD pay in advice is generated Even for other cases the custody status is Electronic Custody ORACLE TD certificate ICCOD advice printing is allowed if the TD custody status is Electronic Custody and TD type is Physical with no redemption settlement account given Once the Deposit receipt is printed the custody status is marked as With Client TD certificate Re print is allowed only when the status is With client and on re print the status changes to Duplicate Receipt Issued The TD batch manages the following aspects e Automatic Account Status Change e Automatic Custody Status Change e Automatic Document status change e Periodic Interest Readjustment Accruals e Automatic Schedule Interest Readjustment Liquidations e Automatic Maturity Interest Readjustment Liquidations e Automatic Rollover of TD account balance e Auto Schedule balance liquidations e Auto
134. e principal and interest amount on EOD of TD maturity date or BOD after end of the grace period e Special Amount If you choose this option the system will roll over the amount specified in Rollover Amount field irrespective of what the interest booking account is Upon maturity of the rolled over TD the system will roll over with the same amount special amount and settle the interest amount as per TD pay out details maintained e Interest For you to choose this option the interest booking account has to be the TD account If you select this option then the system will roll over the interest amount on EOD of TD maturity date or BOD after end of the grace period The principal will be settled as per the pay out details maintained Rollover Amount If a special amount is to be rolled over you have to specify the amount less than the original deposit amount e ORACLE Term Deposit Payout Details Interest Charges Auto Rollover Rollover Type Principal on Maturity Principal interest Amount Q Interest Move Interest to Unclaimed Move Principal to Unclaimed Rollover Amount Term Deposit Payout Details E Pay Out Type Percentage Offset Branch Offset Account Narrative Term Deposit Payout Out Specify the following details in order to allow automatic pay out Pay Out Type Select the pay out mode from the drop down list The options available are
135. e that should be picked up by the system for the TD pay in for the current branch The adjoining option list displays all valid GLs maintained in the system You can select the appropriate one In case the Payin Option is Payin by GL the system debits for the TD using this general ledger In case the Payin Option is Pay in by Cash you need to specify the cash GL here This pay in option is applicable only for branch screens In case the Payin Option is Pay in by Internal Instruments you need to specify the internal instrument here Specifying UDF Values All User Defined Fields UDFs linked to the function ID STDTDPAY are displayed the User Defined Fields screen Invoke this screen by clicking Fields button on the Term Deposits Payin Parameters Maintenance screen User Defined Fields User Defined Fields d Field Name Here you can specify values for each UDF Refer the User Manual titled User Defined Field for details about defining UDFs me ORACLE 3 2 Viewing Payin Parameters Summary You can view summary of all payin parameters using the Term Deposit Payin Parameters Summary screen To invoke this screen type STSTDPAY in the field at the top right corner of the Application tool bar and click the adjoining arrow button Term Deposit Pay In Parameters Summary Authorization Status Record Status Branch Code Pay In Option
136. e to indicate Rollover Type on selecting this option Close on Maturity Check this box to close the term deposit account on maturity date and transfer the amount as per the pay out details maintained for the child TD Move Interest to Unclaimed Check this box to move the interest amount to the unclaimed GL mapped at the IC product in the accounting roles on grace period end date If you select this option you will need to check the box Move Principal to Unclaimed ORACLE Move Principal to Unclaimed Check this box to move the principal amount to the unclaimed GL mapped at the IC product in the accounting roles and liquidate the interest amount to the interest booking account on grace period end date If you select this option the principal liquidation account should be the term deposit account Next Maturity Date On selecting the rollover for the TD account the system defaults the next maturity date from the previous tenor of the deposit Deposit Tenor The system calculates the tenor of the deposit account to the difference between Interest start date and Maturity date and displays it In case of change in maturity date the system changes the value of this field Rollover Type Indicate the components that should be rolled over by choosing one of the following options e Principal e Principal Interest e Special Amount e Interest Rollover Amount If a special amount is to be rolled over you have to s
137. ebits from TD account It recalculates the tenor for the redemption amount i e Reduced Tenor Completed tenor from the TD value date till the partial redemption date in months It recalculates the profit for the previous periods including the current period Till partial redemption date by considering the redemption amount as the TD amount and on the reduced tenor It applies the interest based on the new reduced tenor The amount slab derived from the rate chart maintenance is Amount 1 It recalculates the interest for the remaining amount from TD Start date till last liquidation period by considering the remaining amount as TD balance and on the original tenor of TD is Amount 2 In case of TD payouts the system calculates the interest amount paid to the customer till date which is Amount 3 If the interest for the previous periods is already paid to the customer then the system debits the customer with the difference amount between already liquidated amount till the last liquidation date and newly recalculated profit for redemption amount and remaining amount and debits customer with Amount3 Amount1 Amount2 em ORACLE e system considers the balance amount after the partial redemption as the new TD with the original TD tenor 3 9 1 3 Calculating Interest Rate during Pre Closure of a TD Oracle FLEXCUBE allows calculating Interest Rate during Pre Closure of a TD The system performs the following ac
138. en While saving the details the system validates this Term Deposit Amount Specify the amount which is paid for the time deposit creation in the account currency This amount should be equal to or greater than the minimum threshold amount specified for the linked account class If you have specified the percentage in the Pay In options on clicking the Compute button the system computes the amount And while saving the system validates the sum of Pay In Amounts against the TD Amount keyed in The system will validate for the following e The deposit amount should be equal or greater than minimum booking amount maintained at the Deposits Cluster Maintenance screen else the system will display the following error message The deposit amount is less than the minimum booking amount e deposit amount should be a multiple of the booking unit maintained at the Deposits Cluster Maintenance screen else the system will display the following error message The deposit amount must be in multiples of booking unit Computed Amount On clicking the Compute after specifying the percentage under the Pay In Details section the system computes the amount of the TD in this field On saving the record the system validates the sum of Pay In amounts against the TD Amount keyed in Tel ORACLE Next Maturity Date On selecting the rollover for the TD account the system defaults the next maturity
139. ent This is the current scenario can be changed based on your bank s discretion This specification is maintained at the TD account class level one ORACLE 6 10 1 For more details on interest eligibility and prepayment details refer the section titled Account classes for Time Deposit Accounts in CoreEnty_02 doc user manual This is recorded in the system and the system generates a notice in this regard The notice registered in the system has to be approved by a supervisor On the fifth day your customer is allowed to pre close the TD On emergency cases the prepayment request is input with a request date and availability date as system date The authorizer approves the request on the same day and you can close the deposit on the same day If the prepayment is done within 30 days no interest and readjustment is paid for any time deposit The system automatically reverses the accrual till date in such cases However if a deposit is prepaid after 30 days and is a readjustable deposit only the interest is paid proportionately For such deposits no benefit of readjustment is given The interest benefits of a pre closed TD depend on the interest eligibility days maintained at the corresponding account class level TD Prepayment Request You can capture a TD prepayment request through the TD Prepayment Request screen To invoke this screen type TDDPRPPY in the field at the top right corner of the Application tool b
140. eposited In Current Period The total available balance displayed by the system includes the initial funding amount and unutilized line amount in case the customer enjoys an OD limit You can also view the outstanding debit interest and or charges due on the account as on the current date You can also view the amount that can be withdrawn against uncollected funds on the account The system computes the allowable amount based on the Withdrawable Uncollected Funds Basis option specified in the Branch Parameters Preferences screen s ORACLE Unposted When this branch is under EOD processing the inter branch transactions that have originated from other branches are tanked The funds are made available automatically after BOD and till such time they are treated as unposted items 4 1 4 Specifying Joint Holder Details for a TD You can specify the joint holder details provided you have checked Type as Joint in the Account Details tab of the Deposit Account Booking screen Click on Joint Holders button to maintain the joint holder details The screenshot is as follows Branch Code 000 Account Customer No List of Joint Holders 10f1 HHE Joint Holder Code Joint Holder Type StartDate End Date po Branch Code The system displays the current branch code Account Number The system displays the account number of the current TD Customer Number The system displays the primary
141. er a Customer with a CIF Id 000123 Consider a CASA Account Class SAVIN In the Transaction Tab the value for Exempt is not checked Consider a CASA Account 000777 opened for CIF ID 000123 under CASA Account Class SAVIN There are 2 holders in this Savings Account At the account level you can choose to default the transaction tax either from the Customer or the Account Class For this requirement user is always expected to use Account Class Once the Transaction Tax details are defaulted you can choose to change the value of the Exempt check box In the above illustration the user chooses Default from Account Class and the check box Exempt is not checked If the check box Exempt is not checked at the CASA Account level then only the system will go and check account holding pattern Otherwise it will skip the remaining steps as no tax is required As the check box Exempt is not checked so at the time of the transaction the system will check the holding pattern and holding order The above case falls in the category of different holding pattern order and hence system will apply tax for this transaction 10 2 5 2 Tax Amount Calculation Particulars Rate Amount Transaction amount used as a calculation basis 375500 00 Transaction Tax Amount 0 005 18 775 Step 1 Truncation of third decimal 15 77 Step 2 Rounding 15 75 After making
142. erson to hold the rights to the simulated account balance after the customer s expiration Account Open Date The date on which the account has to be opened is defaulted based on the account class selected here You can however change the value of the opening date of account Media Select the media to communicate account related details to the customer such as account maintenance related charges fees interest etc from the option list You can choose either of the following e Mail e Telex on ORACLE 6 8 1 e SWIFT e Fax Type The type of account is defaulted based on the account class selected However you can select the type of deposit account that you are maintaining a simulation for you can select any one of the following options e Single e Joint Clearing Bank Code The code for the bank serving as clearing house for the simulated account is displayed here Clearing Account Number The account number for the clearing activity for the simulated account is displayed here Alternate Account Number Specify an alternate account for the simulated account Holiday Treatment during Simulation During simulation if the maturity date is falling on a holiday based on the start date and tenor is given then system should automatically move the maturity date based on the Holiday Movement set up done at the Account Class level If the Holiday Movement is chosen as Next Working Day then the maturity date will be a
143. ery month for a fixed tenure generally ranging from one year to five years This scheme is meant for investors who want to deposit a fixed amount every month in order to geta lump sum after some years The small monthly savings in the Recurring Deposit scheme enable the lender to accumulate a handsome amount on maturity Interest at TD rates is computable on monthly or quarterly compounded basis Dual Currency Deposit DCD is a short term currency linked deposit that allows the lender to earn a higher interest rate than regular TD The bank provides the customer lender with a yield enhancement over and above the normal TD rate In return the bank has the right to convert the deposit currency into a linked currency at the pre determined conversion rate on the fixing date The fixing date may be few for instance 2 working days prior to deposit maturity Thus at maturity the lender shall receive the principal and interest in either the deposit currency or the linked currency whichever is weaker In other words while taking the deposit the bank also buys a currency option from the depositor and the enhanced interest is the premium the bank pays for this option Term Deposit in Oracle FLEXCUBE In Oracle FLEXCUBE you can create and service a deposit TD RD and DCD either through the TD module or by using the Savings Teller Branch module ORACLE Salient Features The salient features of TD module are listed below e Automation
144. esult Purpose o ing Credit uals r Flag m NT lt 0 AND SCHD_AMOUN T 0 4 Book Credit N READJACC 1 REDEM_AMOUNT Radjustm AND TDMATREADJ ent for DAYS FROM the START redeeme READJ ELG D d AYS AND principal REDEM AMOU incase NT gt 0 AND of partial SCHD AMOUN redempti T 0 on 5 Book Credit N REDEM 1 CURRENT Additiona AND NT RATE YEAR interest ADD DAYS 0 100 ADD_DAYS for AND preclosur DAYS FROM _ START gt 0 AND REDEM_AMOU NT lt 0 AND SCHD_AMOUN T 0 e 9 21 ORACLE F Book Debit Accr Condition Result Purpose o ing Credit uals r Flag m u 6 Book Credit N REDEM 1 REDEM_AMOUN Additiona AND T INT_RATE YEA interest ADD_DAYS gt 0 R 100 ADD DAY for AND S partial DAYS FROM _ redempti START gt 0 AND on REDEM_AMOU NT gt 0 AND SCHD_AMOUN T 0 7 Book Credit N READJACC 1 FORMULAS TDAD Readjust AND DREADJ ment for REDEM 1 additional AND interest FORMULA5 gt 0 preclosu AND re SCHD_AMOUN T 0 8 Book Credit N READJACC 1 FORMULA6 TDAD Readjust AND DREADJ ment for REDEM 1 additional AND interest FORMULA6 gt 0 Partial AND redempti SCHD_AMOUN on T 0 9 Book Credit N SCHD AMOUN SCHD_AMOUNT I Interest T gt 0 AND NT RATE A00 LE for REDEM 0 AST DAYS TENOR Schedule y YEAR payout
145. for the Term Deposit used by the account to the Account Opening Date If no Free Period has been indicated for the account class used by the account the Charge Start Date is defaulted to the Account Opening Date that is charges on the account would be applied right from the account opening date and displayed in the Special Conditions Maintenance screen You can override the default Charge Start Date and specify the desired start date for charge application Interest Booking Branch By default the customer s account in the current branch will be displayed in this screen in the Interest Charge Booking Account and Interest Charge Booking Branch fields However you have the option of booking interest charge to a different account belonging to another branch also You can select the Interest Charge Booking Branch from the option list available The accounts maintained in the selected Booking Branch will be available in the option list provided for Interest Charge Booking Account You can select the account from this list Interest Charge will be liquidated into the selected account Dr Cr Advices You can indicate whether you want to generate an interest liquidation advice for a customer account Check this box to indicate that the system must generate payment advices when interest liquidation happens on an account The advices are generated in the existing SWIFT or and MAIL format No advices will be generated if you leave this box unchecked
146. fy the name of the city Location Specify the location that forms a part of the address The option list displays all valid location codes maintained in the system Choose the appropriate one Based on the location code selected the system displays the name of the location Country Specify the country that forms a part of the address The option list displays all valid country codes maintained in the system Choose the appropriate one Based on the country code selected the system displays the name of the country d ORACLE 4 1 6 1 Viewing Turnover Amounts In the Customer Account Turnover Amounts screen you can view the total turnover of this customer account from the first date of this month to the current day s system date Also you can view the accumulated interest associated with debit or credit transactions after the last liquidation To view the turnovers for the account click the Turnover button 4 1 7 Nominee Tab Click Nominee tab on the Deposit Account Booking screen The following screen will be displayed Deposit Account Booking ee Branch Code Customer No Pay In Option Term Deposit Account Customer Name Pay in By Number Clearing Type Term Deposit Currency Account Class gu SD User Reference Cheque Instrument No Cheque Date TD Ref No Drawee Account Number Routing No Main Nominee Deposit Dual Currency Deposit Check List Nominee Details 1of1
147. g the settlement entries in the linked currency The adjoining option list displays all valid GLs maintained in the system You can select the appropriate one Fixing Days Specify the number of days from TD maturity date before which the exchange rate has to be fixed This will be defaulted from the Account Class Maintenance screen However you change it Note that fixing days cannot be lesser than zero or greater than the tenor of the TD Yield Enhancement Specify the additional yield percentage that the customer receives for agreeing on the currency Option Inception Fair Value Specify the market value of the option contract at inception This will be defaulted in the linked Options contract 4 1 10 Check List Tab Click Check List tab on the Deposit Account Booking screen The following screen will be displayed TES ORACLE Deposit Account Booking Branch Code Customer No Term Deposit Account Customer Name Number Term Deposit Currency Account Class SD User Reference TD Ref No Main Nominee Deposit Dual Currency Deposit Check List Pay In Option Pay in By Clearing Type Cheque Instrument No Cheque Date Drawee Account Number Routing No Document List 1of1 Document Type Mandatory Checked iil Remarks Remarks Preterences event changes Maker Date Time Checker Date Time Mod No Record Status Author
148. ges during TD creation or amendment Holiday treatment will applied to the next maturity date at the time of rollover 4 1 12 Capturing Additional Details You can capture additional details for the account by clicking the following buttons in the Deposit Account Booking screen Button Function Interest This invokes the IC Special Conditions Maintenance screen Charges This invokes the Account level charges conditions screen Linked Entities This invokes the Linked Entities screen Restrictions This invokes the Products and Transaction Codes Restriction screen MIS This invokes the Management Information System screen Statement This invokes the Statement Details screen Joint Holders This invokes the Joint Holder screen Fields This invokes the User Defined Fields screen Account This invokes the Signatory Details screen Signatory TD Payout This invokes the Term Deposit Payout Details screen Details Endorsement This invokes the Endorsement Log screen Log Schedules This invokes the Schedules screen Preferences This invokes the Preferences screen Events This invokes the Events screen 4 31 ORACLE Button Function Change Log This invokes the Customer Address Change Log screen Refer the chapter Capturing Additional Details in thi
149. hat the interest booking account is Upon maturity of the rolled over TD the system will roll over with the same amount special amount and settle the interest amount as per TD pay out details maintained e Interest For you to choose this option the interest booking account has to be the TD account If you select this option then the system will roll over the interest amount on TD maturity date or end of the grace period The principal will be settled as per the pay out details maintained You should choose the option Principal if you have checked the following boxes e Auto Rollover e Move Interest to Unclaimed e Move Principal to Unclaimed The system will select the option Principal and disable this field if you check the box Close on Maturity ORACLE At the time of TD rollover in case of discounted interest only Principal can be rolled over The Cumulative option is not allowed with Discounted Interest option The interest computed during deposit booking with discounted option will be paid to the liquidation account When Amount block option is checked at the product level the amount block will be created on the TD account to the extent of the credited discounted interest This amount block will use the Hold Code which has Hold Type as Discounted TD in the Hold Maintenance screen This is to safeguard the bank from withdrawal of interest by the customer The amount block created automatic
150. he account number of the TD Serial Number The system displays the sequence number of endorsement Tus ORACLE Beneficiary ID The system displays the beneficiary ID Date of Endorsement The system displays the date on which endorsement happened Name The system displays the name of the beneficiary Short Name The system displays the short name of the beneficiary Beneficiary Type The system displays type of beneficiary as either Single or Joint Account Endorsee The system displays the old primary beneficiary who held the TD account before endorsement TD Sale Amount The system displays the TD sale amount TD Sale Currency The system displays the TD sale currency This is displayed based on the TD account currency 4 1 6 Viewing Third Party Details You can maintain the third party details using Non CIF Address Maintenance screen You can invoke this screen by typing STDADMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button ate ORACLE Non CIF Address ID No Name Address Drawer City Location Country Maker Date Time Checker Date Time Specify the following details ID Number Specify the identification number for the non CIF address Name Specify the name of the third party Address Specify the address in the fields provided Drawer City Speci
151. holiday kindly change the tenor or maturity date The system will not perform any maturity date adjustment automatically based on the instruction given in Holiday Movement field i e For TD manual rollover irrespective of the option provided in Holiday Movement the system will always will display the following error message Maturity date is on holiday kindly change the tenor or maturity date 6 2 11 Authorizing Transaction For the transaction to be authorized click Authorize button The following screen will be displayed ee ORACLE 6 3 Authorization Branch Term Deposit Account Number Redemption Reference Number Account Currency overs Confirmed Override Text The accounting entries for redemption renewal are passed only on authorization Viewing TD Redemption Details You can view the details of TDs redemption using the Term Deposit Redemption Input Summary screen To invoke this screen type ICSREDMN the field at the top right corner of the Application tool bar and click the adjoining arrow button Authorization Status Record Status x Redemption Reference Number Branch Code Account Number Transaction Date l Search Advanced Search Reset Records per page 15 v MW 14 of 1 m3 Authorization Status Record Status Redemption Reference Number Branch Code Account Number Transaction Date
152. hrough PPC Include Linked Account Balance include Linked OD C Apply City Compensation Transaction Tax Tab Tax Bourne by value will be Customer Account For more details on this screen refer the chapter Period Code Maintenance in Core Service User Manual 10 2 4 Maintaining Events Class You can build the events that you would like to include in an Events Class in the Events Class Maintenance Screen You can invoke this screen by typing CSDACTCL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 10 4 ORACLE Events Class Maintenance Class Code Description Module Module Description Event Class Input By Authorized By Modification Authorized Date Time Date Time Number Open You need to set the following details Class Code Set Tax Class as DPTCL Deposit Tax Class Module Set module TD Term Deposit Event Set Event DEBK Deposit Booking The following accounting entries will be passed Accounting Role Amount Tag Dr Cr Transaction Code DPTCL COD DPTCL LIQD Dr ITF DPTCL COD DPTCL LIQD Cr ITF The transaction code ITF Transaction Tax there will not be any Tax Scheme attached Refer the section Maintaining Events Class in Class User Manual under Modularity for details about this screen me ORACLE 10 2 5 Maintaining Role to Head M
153. ices Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services
154. id of the Customer ORACLE Field Name Field Description Address This indicates the address of the Customer Account No This indicates the customer account number Current Deposit No This indicates the Deposit No Current Balance This indicates the current balance in the account Deposit Renewal Date This indicates the date on which the Deposit Renewal was done Maturity Date This indicates the Maturity Date of the account Date of Txn This indicates the date of transaction Txn Description This is a small description of the transaction Cheque ref no This indicates the Reference No Dr Cr Amount This indicates the amount credited or debited 11 8 TD Account Class Summary Report This summary report provides MIS information like principal amount interest amount etc with respect to term deposit accounts of the bank This is a GL wise currency wise Account class summary report for all the branches This report provides information about Account class Code Account class Name Total Accounts Principal Balance Interest Accrued The totals are also provided This report will be generated at EOD 11 8 1 Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Bank name Branch Run Date User ID and the Period for which the report is generated Body of the report The generated report will have the fol
155. ies the method in which a tax component a Stock Exchange tax a Local tax etc is calculated You can build tax rules in the Tax Rule Maintenance screen You can invoke this screen by typing TADRULE in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Tax Rule Maintenance Rule Code Country Code Tax Category Effective Date Currency Details Rounding Details Additional Slab Currency Details Currency Reference Currency Calculation CCY Basis Tax CCY Basis Authorized By Date Time Customer Category Description Description Exchange Rate Rate Type Rate Code Basis Percentage Modification Number Authorized Open 10 1 ORACLE You can create a Tax Rule DPTR Deposit Tax Rule with the following values e Rule Method Rate e In the Slab tab Basis Amount To Maximum Value e Rate 0 005 Refer the section Defining Tax Rules in Tax User Manual under Modularity for details about this screen 10 2 1 1 Maintaining Tax Scheme Details Tax schemes can be built in the Tax Scheme Maintenance screen You can invoke this screen by typing TADSCHEM the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Tax Scheme Maintenance Scheme Code Description Rule Details Input By Authorized By Modification Authorized exit Date Time Date Time
156. in option Cheque is selected you must specify the following details Cheque Instrument No Specify the cheque instrument number ta ORACLE Cheque Date Specify the date of issue of the cheque Clearing Type Specify the clearing type for the transaction The adjoining option list displays a list of the clearing types maintained in the system You can select the appropriate one Same Holder Specify if the term deposit holder and the customer account holder are the same Choose one of the following options from the drop down list e Same Holder Tax will be exempted for this option e Other Holder Tax will be deducted for this option Mandatory only if the Pay in By is selected as Cheque By default the value is Other Holder Drawee Account Number Specify the drawee account number Routing No Specify the Routing number The option list displays all valid routing numbers maintained at the branch level Choose the appropriate one from the option list Details maintained in this screen are classified under the following tabs Main Here you maintain the main attributes of the TD like the account number customer code the account class account currency type of account single or joint account status etc Nominee Here you can capture nominee details for the TD Deposit Here you specify deposit specific details Dual In this tab you can maintain details of a dual currency Currency depo
157. ine 1 BRNADD2 _ Branch address line 2 _BRNADD3_ Branch address line 3 TDATE Rollover date Advice Reference _CUSTNAME Customer name _ADD1_ Customer address line 1 _ADD2_ Customer address line 2 _ADD2_ Customer address line 3 _ADD4_ Customer address line 4 TDACNO _ Term deposit account number _AMT_ Rollover amount _CCY_ Term deposit currency __ DEPTTENOR Term deposit tenor MATDATE Maturity date __ Maturity amount _INTRATE_ Interest rate __ DUPLICATE _ Duplicate Certificate USERNAME _ User Name who has generated the advice ENDORSABLE _ TD is endorsable or not which is defined at the at TD account level _SECTORCODE _ Branch code maintenance for the TD opening branch 8 8 ORACLE 8 6 Tag Description _BRANCH_ TD opening branch _TDACCLSDESC_ TD Account Class Desc _CLEARINGBNKCODE _ Clearing Bank Code _CUSTNO_ Customer Number CIF _CUSTIDENTITYPE_ Unique Identifier Name maintained at STDCIF _CUSTIDENTINO_ Unique Identifier Value maintained at STDCIF CUSTTYPE _ Customer type Individual Bank or Corporate DEPAMT Initial Deposit Amount in readjustable currency _INTAMT_ Interest amount on maturity of Term deposit _FLOATRATECODE Floating rate Rate code value of Term deposit PERIODICRATE Periodic rate of Term deposit _INTSTARTDATE__ Start Date for interest calculation In case of fixed term dep
158. ion of grace period respectively Thegrace period is maintained only at the account class level You cannot modify it for any account Settlement Bridge GL To facilitate multi mode pay out you need to maintain a Bridge GL between the TD and the pay out module PC Specify the Bridge GL that should be used for processing pay out of TDs under this account class The adjoining option list displays all valid GLs maintained in the system You can select the appropriate one Product Category To facilitate multi mode pay out specify a product category or select a product category from the adjoining option list The option list contains the outgoing payment product categories ORACLE Transaction Code Specify the transaction code that should be used to process TD pay out by PC The adjoining option list displays all valid transaction codes maintained in the system You can select the appropriate one Cluster Identification Specify a valid cluster ID which you need to link to deposit account class The option list displays all valid cluster IDs maintained in Deposit Account Cluster Maintenance screen You can link cluster ID only for term deposits Default Tenor You can define a tenor for the deposits that are opened under an account class Deposits opened under the account class will automatically acquire this tenor However you can change the tenor to suit the requirements of a specific deposit Days Specify the
159. iption Interest Billing Liquidation Slogan Charge Basis Product Group Description Product Group Description Booking Account Type Start Date 12 31 2010 Rule TDFN End Date Rule Description FINAL RULE Remarks Accounting Roles Events Branch customer Preferences status Maintenance Maker V32628 Date Time Mod No 3 Checker V32628 12 01 2011 11 53 16 Record Status Open Date Time Authorization Status Authorized 12 01 2011 11 53 19 3 8 1 Specifying Accounting Roles for Unclaimed Deposits In case you have checked the option Move Interest to Unclaimed and Move Principal to Unclaimed in the Deposit Account Details screen at the account class level you will have to specify appropriate accounting roles for the IC product using the Accounting Roles screen Click Accounting Roles button on the Interest and Charges Product Maintenance screen and invoke the following screen diss ORACLE Accounting Roles x Product Code TDFN Product Description TD FINAL PDT Class Details Class Code Class Description Roles 9 4 102 gt M Go mm m Accounting Role Role Description AccountHead GLDescripion amp TDFN ACCRUAL interest Payable to mmt FORMULA1 251110002 Time Deposits TDFN ACQUIRED 4 1 TDFN ACQUIRED 1 NTEREST gg 251110002 Payable to FORMULA 1 v ime eposits d TDFN ACQUIRED A TDFN ACQUIR
160. is signatory is a joint account holder with rights to sign instruments only up US 8000 Signature ID Specify the signatory identification number Signatory Name The system displays the corresponding name of the signatory ID specified Signatory Type Specify the signatory type Approval Limit Specify the amount up to which the account signatory can approve for debits Signatory Message The system displays the message corresponding to the signatory yu ORACLE 5 11 Indicating TD Payout Details Click TD Payout Details button on the Deposit Account Booking screen and invoke the Term Deposit Payout Details screen to capture the parameters for automatic pay out Term Deposit Payout Details Branch Code Currency Account Term deposit Bankers Cheque DD PC Branch Code Default From Parent Account Currency Account Class Customer No Account Class e Here you can capture the following details Branch code The system defaults the current branch here Account This is the account number to which signatories are to being linked Currency The system defaults the TD currency 5 11 1 Term deposit Tab This tab is displayed by default on invoking the screen Here you can capture details for creation of a child TD as part of pay out of the parent TD Customer No The system defaults the customer number PE ORACLE Branch code The system defaults the current branch here Currency The
161. isfying the specified criteria and displays the following details for each one of them e Authorization Status e Record Status e Branch Code e Account Number e Sequence Number e Sweep To Account e Sweep Branch Double click on a record to invoke the detailed screen for that record Tes ORACLE 5 1 ORACLE 6 TD Operations Introduction You can perform the following operations on a Term Deposit TD e Redemption e Advice generation e Closure e Simulation Redeeming a TD The Term Deposits Redemption Input screen enables you to redeem a term deposit Using this screen you can do a premature redemption either in full or in part and also complete redemption on maturity of the deposit This screen also allows you to renew the TD However renewal of the TD is enabled only if you have specified Grace period for Renewal option for the account You can invoke the Term Deposit Redemption Input screen by typing ICDREDMN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Term Deposits Redemption Input Branch Term Deposit Account Number Customer Id Account Description Account Currency Account Balance Redemption Reference E Waive Interest Number Redemption Renewal Redemption Mode Partial Redemption Redemption Redemption Amount 7 Waive Penalty E Suppress Redemption Renewal Advice Days Months Years Next Maturi
162. itions and other parameters for the deposit account Maintain Pay in and Close out mode parameters e ORACLE This manual explains how you can create and service a deposit through the TD Module For details about TD creation using Branch you may refer the Savings User Manual a ORACLE 3 1 3 Term Deposit Maintenance Maintaining Payin Parameters In case you have specified that the TD Payin be done by GL you need to maintain the GL details through the Term Deposit Payin Parameters Maintenance screen You can also invoke this screen by typing STDTDPAY in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Term Deposit Pay In Parameters Maintenance Branch Code E Pay In Option General Ledger E x General Ledger Code Maker Date Time Checker Date Time To link appropriate GLs in case the pay in option chosen is pay in by GL you need to maintain the following details Branch Code Specify the branch code for which you want to maintain payin parameters The adjoining option list displays all valid branch codes maintained in the system You can select the appropriate one Payin Option Select the payin option from the adjoining drop down list The following options are available e Payin by GL e Payin by Cash e Payin by Internal Instruments a ORACLE 3 1 1 General Ledger Code Specify the GL cod
163. ive Give a brief description for the redemption TD Redemption Settlement of cash term deposits e Settlement of a LCY term deposit in cash is non exempted e Settlement of a FCY term deposit in cash is non exempted Term deposit settlement through a customer account credit e Term deposit settlement through a customer account credit single holding same holders is tax exempted e Term deposit settlement through a customer account credit joint holder in same order is tax exempted e Term deposit settlement through a customer account credit different holding pattern is non exempted ITF is applied to debit and credit accounts Term deposit settlement by issuing a demand draft e Term deposit settlement by issuing a demand draft is non exempted ORACLE Term deposit settlement through GL account credit e Term deposit settlement through GL account credit and without tax exemption the tax status depends on the flag values e Tax exempted term deposit settlement through GL account credit the tax status depends on the flag values 6 2 2 Capturing Pay Out Details Click TD Pay Out button on the Term Deposit Redemption Input screen and invoke the following screen Here you can specify details of the child TD that should be created on maturity of the parent TD Term Deposit Cheque DD Details Counter Party Details Branch Code AccountClass lag Customer Account Number Customer Number _ Account
164. ive Date Indicate the following details Effective Date The Effective Date of a record is the date from which a record takes effect You can maintain different values for a UDE for different effective dates for an account When interest is calculated on a particular day for an account with special conditions applicable the value of the UDE corresponding to the date will be picked up Typically you would want to open records with different Effective Dates if the values of UDEs vary within the same liquidation period Open Typically you would want to open records with different effective dates if the values of UDEs vary within the same liquidation period UDE Values Specify the following details User Defined Element ID Specify the UDE for which value is given The adjoining option list lists all UDEs maintained for the Interest Rule You can select the appropriate one UDE Value Specify the value of the UDE For a fixed interest rate you can specify a numeric value ER ORACLE 5 3 Rate Code If you want to use a floating rate instead of a fixed rate you should specify a valid IC rate code The system will pick up the applicable rate based on the branch currency and effective date combination maintained for the rate code in the Interest amp Charges Rate Input screen ICDRATES For a given tenor the system picks up the applicable rate as per the effective dates defined for the rate code TD Rate Code S
165. ization Status The following details are displayed from the account class e Document Type e Mandatory Specify the following details Checked Check this box to indicate that the received documents are acknowledged Remarks 1 to 10 Specify the additional information if required 4 1 11 Holiday Treatment during TD Creation charges une emnes Reatictons ms Statement sane res account soc 10 Payout Dorais Endorsement Lo During the TD creation based on the start date and tenor provided if the maturity date falls on a holiday then system will display the following error Term Deposit maturity date is a holiday as per holiday treatment setup in account class Please change maturity date to proceed 4 30 ORACLE The system will not perform any maturity date adjustment automatically based on the instruction given in Holiday Movement field Suppose maturity date is on a holiday you need to change the tenor maturity date manually and proceed with TD creation The system will allow you to create a TD transaction when the maturity date is not falling ona holiday When Auto Rollover option is chosen and rollover instructions are provided during the time of deposit opening or as an amendment after opening there will not be any holiday treatment done for the field Next Maturity Date Even though the Next Maturity Date is a holiday there will not be any chan
166. l bar and clicking the adjoining arrow button Recurring Deposit Payments Reversal Branch Code az RD Account Number Transaction Date Auth status Contract Status Here you can capture the following details Branch Code Specify the code assigned to the branch in which the payment is to be made You can also choose the branch code from the adjoining option list RD Account Number Specify the recurring account number for which the installments are to be collected The system displays the recurring deposit accounts that are in open and authorized status in the adjoining option list You can choose the appropriate one from this list Transaction Date The system displays the transaction date for which reversal is supposed to be initiated a ORACLE Auth status The system displays the authorization status Contract Status The system displays the contract status Reversal of a payment transaction can be done from this screen When a transaction is reversed the system updates the contract status as V Reversed s ORACLE 8 1 8 2 8 3 8 Annexure A Accounting Entries Accounting Entries and Advices for TD This Annexure lists the suggested event wise accounting entries that can be set up for the Interest and Charge product applicable for the TD module of Oracle FLEXCUBE Events You need to set up the following events for an Interest product Event
167. lass Maximum Specify the maximum amount for which deposit can be created under this account class The system will not allow you to book a deposit account with less than this minimum amount in the account class Grace Period for Renewal Specify the grace period for renewing a TD Only if you opt for this option the TD can be renewed using the Term Deposit Redemption screen ICDREDMN upon maturity of the TD This option is applicable only to auto rollover deposits Grace days cannot be given if the option Close on Maturity is checked This option is applicable only for deposits whose interest and principal is moved to unclaimed GLs upon maturity After the account has matured renewal of the TD is possible from the beginning of day BOD of the maturity date to the end of day EOD of the grace period The TD is renewed with the value date as of the maturity date when the grace period is valid The counter for the grace period is 0 on the maturity date It is incremented by 1 during EOD processing of every subsequent day When the grace period counter is 0 TD renewal is possible before start of the EOD as of the maturity date When the grace period counter goes to 1 TD renewal is possible before start of the EOD of the maturity date 1 and so on Refer the section Redeeming a TD and Transferring to Unclaimed Deposit on Maturity in this User Manual for details about TD redemption and applicat
168. lass of TD account The adjoining option list displays the list of all the valid TD RD account classes maintained in the system You can choose the appropriate one ORACLE Customer Specify the customer number of the customer The adjoining option list displays the list of all the valid customer numbers maintained in the system You can choose the appropriate one Click OK button to generate the report Click Exit to return to the Reports Browser Body of the report The generated report will have the following information Field Name Field Description Account No Deposit No This indicates the TD account Number Name of the Deposit This indicates the Name of the TD account holder Date of Opening This indicates the TD account opened date Value Date of Deposit This indicates the Value date of TD account Deposit Amount This indicates the Deposit Amount Period of Deposit This indicates the TD Period Due Date This indicates the Maturity date of the TD account Total Interest Payable This indicates the Interest Amount This will show interest amount on the maturity date Maturity Value This will show the sum of Deposit amount and Total Interest Payable Branch This indicates the Branch Name Auto Rollover Will indicate whether the TD is Auto Rollover or not 11 17 ORACLE 11 12Term Deposits Maturity Report This report list
169. lowing information Field Name Field Description GL Type This indicates the GL Type GL Code This indicates the GL Code ORACLE 11 10 Field Name Field Description Currency This indicates the currency for the respective GL Account Class Code This indicates the Account Class code Total Accounts This indicates the Total Accounts Principal balance This indicates the Principal Balance in the accounts Interest Accrued This indicates the Interest Accrued for the accounts Following elements will be displayed for Totals Field Name Field Description Principal Balance This indicates the total Principal Balance of the accounts Interest accrued This indicates the total Interest accrued for the accounts 11 11 ORACLE 11 9 Term Deposits Opened for the Period Report This report list the term deposit accounts which are opened for the given period and that are currently on open status You can generate this report using TD Account Opened Report screen by typing TDROPEN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button From Date To Date Branch Account Class Customer Specify the following details here From Date Enter the TD accounts which are opened from this date However by default the system displays the current application date To
170. m fraction amount specified at the account class e Each TD fraction will have a minimum capital of one 1 million COP i ORACLE Once the fractioning is confirmed main TD will be cancelled and new fraction TDs are opened and become active For fractioned TDs the system triggers back dated accrual if the system date is later than the main TD account creation date The fractioned TD must inherit the following characteristics of the original TD e Ifthe interest liquidation is done at the maturity date or in advance e Liquidation base 360 365 or 366 e Type of rate fixed floating Fixed and floating rates are taken from rate tables at the time of opening special rate is a fixed rate which is entered manually at the time of opening e Rate e Tenor e Frequency e Opening date e Maturity date You can maintain the term deposit fractioning using TD Fractioning screen You can invoke this screen by typing STDTDFRA in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button TD Fractioning Branch Code 000 No of Fractions Account E Confirmed Currency Compute Term Deposit Amount TD Type Fraction Details EE m Sequence Number Fraction Account FractionPercentage Fraction Amount Type Third PartyID Beneficiary ID Maker Date Time Checker Date Time Account No Specify the main T
171. matic maturity liquidations of TD e Auto Closure of Pre payment requests 4 1 3 Viewing Amounts and Dates You can view all financial details of this account along with the details of the previous debit or credit activities However access to all financial information of an account can be restricted for any user The financial details of an account include the account balance the uncleared debit and credit balances the debit and credit turnover and the interest details The turnover limit details of an account include the current financial period currency utilized and unutilized limit balances TUE ORACLE Click Amounts and dates button in the Deposit Account Booking screen Amounts And Dates Branch Code Account Opening Daily Turnover Dr Daily Turnover Cr Current ACY Uncollected Withdrawal Uncollected Funds Blocked Receivable Available Unutilized Amount Total Available Provision Amount Unposted Debit Dr Credit Cr Uncollected Unauthorized Debit Dr Credit Cr Uncollected Cr Turnover Change Log Turnover Limit Details Opening Daily Turnover Dr Daily Turnover Cr Debit Dr Credit Cr Current LCY Accrued Interest Dr Accrued Interest Cr Interest Due Charge Due Previous Date Debit Credit DR Activity CR Activity Unposted Dr Unposted Cr Unposted Current Period Currency Maximum Credit Turnover Allowed D
172. mber Term Deposit Currency Account Class 15LDMM Clearing Type 2 Cheque Instrument No 2 Same Holder Same Holder Cheque Date E Drawee Account Number Routing No az SD User Reference TD Ref No Main Nominee Deposit Dual Currency Deposit Check List Maturity Date Next Maturity Date Next Rate Change Date Tenor Renewal Tenor Auto Rollover Rollover Type Principal 7 Close on Maturity Principal Interest 7 Move Interest to Unclaimed Special Amount Move Principal to Unclaimed Interest Computed Amount Rollover Amount Term Deposit Amount Compute Recalc Pay In Details HEE Term Deposit Pay In Option Transaction TAX Exempt Payin Date Offset Branch Offset Account Offset Currency Date Time Mod No Date Time Record Status Authorization Status Specify the following details Maturity Date The system defaults the maturity date from the default tenor from the account class However you can modify this date On this date the term deposit account gets liquidated Next Rate Change Date The system displays the next rate change date based on the based on the rate change period maintained at the IC product level This is applicable only for rate revision accounts Auto
173. mount Term In days This indicates the term of the deposit account in days Maturity Date This indicates the maturity date of the deposit account Interest Accrued This indicates the interest accrued for the deposit account The generated report will have the following information displayed for totals Field Name Field Description Principal Amount This indicate the total principal amount of the deposit account Interest Accrued This indicates the total interest accrued for the deposit account 11 4 Large FD Report This report provides customer wise details of large time deposits beyond the given amount criteria You have an option to print and view the report in pdf or excel format You can invoke Large FD Report screen by typing TDRFDREP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Large FD Report Branch Code Currency Code ALL Amount Exceeding Specify the following details here 11 5 ORACLE Branch Code Select the branch code for which the report needs to be generated from the adjoining option list The list displays all valid branch codes You have an option to select all the branches or a single branch Currency Select the currency code from the adjoining option list The list displays all valid currency codes maintained in the system By default the value ALL will be displayed
174. n new account class is created e f you select Minor option at the CIF level and Applicable customer status as Major at the account class level then the system will throw up the following error message The A c class you selected is for major customer e f you uncheck Minor option at the CIF level and select Applicable customer status as Minor at the account class level then the system will throw up the following error message The A c class you selected is for minor customer Maintaining Deposit Details Click the Deposits button to define the parameters for a deposit type account class The Deposit Account Details screen is displayed ae ORACLE Deposit Account Details Minimum Tenor Auto Rollover Minimum Close On Maturity Maximum Allow Partial Liquidation Grace Period for Renewal Allow Partial Liquidation Settlement Bridge GL with Amount Block Move Interest To Unclaimed Move Principal to Unclaimed Cluster Identification Rate Chart Allowed Transaction Code Product Category Days Months Years Recurring Deposit Minimum Schedule Days Default Tenor Days Months Years Installment Frequency Recurring Deposit Days Move Maturity to Unclaimed Months Move funds on Overdraft Years Maximum Tenor Days
175. n advice The adjoining option list displays all valid accounts maintained in the system You can select the appropriate one No of Advice Generated The system displays the advice number being generated On rollover of Term deposit this field will be updated as zero Print Status Select the print status from the drop down list and the available options are e None e Duplicate This option is used to generate a duplicate advice e Reverse The custody status of the TD should be changed to the previous status Click Generate button The system will generate the deposit advice The generated advice can be viewed on clicking the Print button eee ORACLE 6 5 6 6 Message Details Swift Message Type DCN 000 Version Number REFERENCE NUM Bank Futura Unit 1 Block 4 California ANNUAL PERCENTAGE YEILI JED FOR THE DEPOSIT TENOR 30 OUNT T 5000 Remarks Reject Reason Message Trailer ou can view the advice using the Outgoing Message Browser Summary screen MSSOUBRS You cannot print de materialized TDs Closing a TD Deposit accounts can be closed automatically on the Maturity Date of the deposit You can specify this by choosing the Close on Maturity option while creating the TD A deposit acquires the specifications for the account class under which it is opened you can change this If you choose the Close on Maturity option during the Beginning of Day operations
176. n list The options available in the drop down list are as follows e Open If you select this option the report will be generated for all open deposit accounts e Close If you select this option the report will be generated for all closed deposit accounts Click OK button to generate the report For the selected branch currency wise deposit amount and number of deposits for the previous month and current month will be displayed along with the cost 96 Click Exit to return to the Reports Browser 11 3 1 Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Bank Branch and Run Date for which the report is generated Body of the report The following detail block elements are displayed in the report Field Name Field Description Account Class Code This indicates the account class code Account Class Name This indicates the name of the account class Account Number This indicates the customer account number Customer ID This indicates the unique id of the customer Customer Name This indicates the name of the customer Open Date This indicates the date on which the account was opened 11 4 ORACLE Field Name Field Description Account Class Code This indicates the account class code Value Date This indicates the value date of the deposit transaction Principal Amount This indicates the Principal A
177. n you define product restriction attributes for an account itself rather than for the account class to which it belongs it is referred to as a Special Condition You can apply special conditions by selecting the option Applicable If you opt to define special conditions for an account the restrictions defined for the Account Class to which the account belongs will NOT apply to this account If you wish to continue with the account class restrictions opt for Not Applicable Product List Specify the restriction type here The options available are e Allowed If you select this the products entered in the multi entry block will be allowed for that account e Disallowed If you select this option the products entered in the multi entry block will be disallowed Product You can select the products and specify the type of transaction Dr Cr or both that you would like to allow disallow for each product In contracts involving the selected products the accounts would be used for processing the selected type of transaction For instance assume that for the account A1 you have allowed Dr for the product ABCD This would mean that if a Dr entry for the product ABCD is passed to the account A1 it would go through but in case a Cr entry is passed for this product then the system will display a message indicating that the transaction is restricted for the account Description The system displays the description for
178. nch Code Specify the following details here Process Date Select the date on which the report has to be processed from the adjoining calendar button Branch Code Select the branch code for which the report needs to be generated from the adjoining option list The list displays all valid branch codes You have an option to select all the branches or a single branch For the selected branch currency wise the deposit amount and number of deposits for previous month and current month are displayed along with the cost 96 11 5 1 Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Bank Branch Run Date Operator ID and the Period for which the report is generated Body of the report The generated report will have the following information Field Name Field Description Currency This indicates the account currency um ORACLE No of Deposits Displays the currency wise number of deposits for a branch for the previous month Previous month This indicates the previous month deposits Deposits Cost p a This indicates the cost percentage per annum No of deposits This indicates the currency wise no of deposits for a branch for the current month Current month This indicates the current month deposits Deposits Cost p a This indicates the cost percentage per annum 11 6 Interest Paid Repo
179. ng TDRMATR TD Account Maturity Report TDROPEN TD Account Opened Report TDRRENEW TD Account Renewed Report 12 2 ORACLE ORACLE Term Deposits April 2014 Version 11 3 83 02 0 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashira 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2005 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or in
180. ng auto created deposits The values you specify here will override the parameters you have maintained in the Account Class maintenance Invoke the Term Deposits Instruction Maintenance screen from the Application Browser to maintain the deposits instructions specifically for the auto created deposits Type ICDINSTR in the field at the top right corner of the Application tool bar and click the adjoining arrow button LZ Deposit Instructions Account Number z Branch Code Account Class Sequence Number Customer Number Currency Code Sweep Branch Tas Deposit Currency Sweep To Account Tenor Amount Sweep Multiple Of Minimum Required Balance Start Date Source Code Retry Till Date External Reference C Once Authorized Input By Authorized By Modification Authorized Date Time Date Time Number Open You can set the terms and a condition for a deposit as follows SP ORACLE Account Number Specify the account number of the term deposit The adjoining option list displays all valid TD accounts maintained in the system You can select the appropriate one Account Class The system displays the account class to which the TD is linked Customer Number The system displays the customer of the TD Sweep Branch Specify the branch where the sweep to account resides The adjoining option list displays all valid branch codes maintained in the system You can select
181. ng maintenance or online operations in the respective contract screens for the restricted transactions when you specify the customer account the system checks whether the account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved Transaction Details Indicate the following preferences Special Condition By default the restrictions maintained at the account class level will be displayed here When you define transaction code restriction attributes for an account itself rather than for the account class to which it belongs it is referred to as a Special Condition You can apply special conditions by selecting the option Applicable at the account level If you opt to define special conditions for an account the restrictions defined for the Account Class to which the account belongs will NOT apply to this account If you wish to continue with the account class restrictions opt for Not Applicable Transaction List Specify the restriction type here The options available are e Allowed If you select this the transaction codes entered in the multi entry block will be allowed for that account e Disallowed If you select this option the transaction codes entered the multi entry block will be disallowed Transaction Code Likewise you can maintain restrictions for transaction codes as well Transaction code ba
182. not allow re populating at liquidation at IC product level when the account class of type Rate Chart Allowed is checked at the IC product e ORACLE e The redemption with BC PC and Child TD not allowed in case of account class of account having Rate Chart Allowed e f check box Use Rate for Revised Tenor is unchecked during pre closure processing revised interest can be calculated using the Pre closure Differential along with the current interest rate on the TD based on rate code linked to TD The system will display the following override Revised rate will not be considered for calculating pre closure interest e The parameter only controls if the rate re pick up will happen or otherwise You have to set the corresponding interest formula using pre closure differential to compute the interest payable by discounting the original maturity amount e following SDEs will be used to calculate pre closure amount using the Pre closure Differential gt RESIDUAL_TENOR This SDE will store the number of days remaining from Pre closure Request Date and TD maturity date as per Days in Year selection at formula 1 gt DCTENOR This SDE should return the tenor corresponding to Days in a Month basis for formula 1 gt RVSD_RATE This SDE can be used in formula conditions same IC product having formulae for calculating interest using both these methods can be linked to
183. nsidered for MIS related component computation s ORACLE Rate Type If you have indicated that rates maintained for the individual account should be picked up for MIS refinancing you have to specify the Rate Type that is to be used The options available are e Fixed e Floating Automatic indicating that the system should pick up the refinancing rate associated with the account Since the account number is linked to a Rate Code the System picks up the rate code associated with the account when the EOD processes are run to refresh the various rates Spread Specify the spread that should be applied if rate type is selected as floating type Pool Code Account Level Define the Pool Code Account Level to which the account class or product belongs Pool Code For an account the pool code will be picked up from the account class Transaction MIS Group For an account the transaction type of MIS class will be picked up from the account class Composite MIS Group The composite type of MIS class will be defaulted from those defined for the customer Cost Code For an account the cost codes will be picked up from the account class Tie ORACLE 5 6 1 Viewing Change Log Click Change Log button on the Management Information System screen and invoke the Change Log screen If MIS reclassification occurs through changing of the MIS codes for the Customer Type of MIS classes the system will store the changes made
184. nstructed e Deceased e Judicial e Lost e Judicial and Loss e Judicial and Deceased ORACLE e Judicial and Bank Instruction e Loss and Deceased e Loss and Bank Instructed e Deceased and Bank Instructed Auto Deposit A TD can also be automatically created from a savings account if the balance in the savings account exceeds a predefined limit You can capture the following details of such a TD Sweep Type The system indicates the type of sweep based on which the TD was created It can be any one of the following e 1 This indicates No sweeps e 1 This indicates Default from account class e 0 This indicates that deposit is instructed Master Account No The system displays the account number of the savings account from which this auto deposit was created The system automatically updates the account status of the TD during the life cycle of a TD as explained in the flow chart below mL ORACLE Account Statuses and its movement Account Closure Returns TD Balance TD Amount Cancelled 7 Redemat For Renewable TD s on liquidation date till before Maturity Rollover Days PREPAID On Rollover On Auto For Non Redemption Renewable TD s on Susceptible to Renew Liquidation date 4 1 2 Processing If maturity date is a holiday then the status change processing of those accounts happens on the next working day of the maturity date In cas
185. nt date as the TD creation date You cannot modify this Alternate Account Number The system displays the account number as the alternate account number However you can change it Clearing Bank Code The code for the bank serving as clearing house for the account is displayed here ORACLE Address Specify the address of the customer You can use this field if the advice has to be sent to an address different from the customer address maintained In such case it is mandatory to specify the location and media Location An address for a customer account is based on the Location and Media combination Location codes maintained through the Account Address Location Type Maintenance screen are made available against this field Select the appropriate one The address maintained here is always the primary or the default address Each customer can have several addresses for a particular media To distinguish between one address of a customer from another for a given media it is essential for you to specify a unique location for each address Media Select the media to communicate account related details to the customer such as account maintenance related charges fees interest etc from the option list You can choose any one of the following e FAX e MAIL e SWIFT e TELEX Option Indicate your preferences for the following Track Receivable Check this box if you choose to block the subsequent credit th
186. nterest statement will furnish the values of the SDEs and UDEs and the interest rule that applies on the account Dr Cr Advices Check this box to generate payment advices when interest liquidation happens on an account The advices are generated in the existing SWIFT or and MAIL format No advices will be generated if you leave this box unchecked Charge Booking Branch Specify the charge booking branch The adjoining option list displays all valid branch codes available in the system You can select the appropriate one Charge Book Account Specify the account to which charge should be booked You have an option of booking charge to a different account belonging to another branch The accounts maintained in the selected booking branch are available in the option list provided The system liquidates the charge into the selected account ere ORACLE Charge Start Date Indicate the date from which charge calculation should start using the adjoining calendar Product Code Specify the interest charge IC product code that should be linked to the account The adjoining option list displays all valid IC products available in the system You can select the appropriate one UDE Currency Specify the UDE Currency defined for the product Waive Check this box to waive off an interest or a charge that has been specified Generate UDE Change Advice Check this box to generate the UDE change advice Open Check this box to make the product
187. o gives different combination of transaction tax for term deposit and Savings account TD Opening by Account Debit Case 1 A customer opens a single holder term deposit for an amount of S 375500 by debiting his joint savings account Since he is the holder of the term deposit but the account is joint that is it has more than one holder this transaction will be eligible for the transaction tax also since the single holder rule is not met in this case 9 25 ORACLE 10 1 Introduction 10 TD Tax Rule Set up This chapter lists the TD tax rules that need to be maintained for the TD module of Oracle FLEXCUBE It also gives different combination of transaction tax for term deposit and Savings account 10 2 TD Opening by Account Debit Case 1 A customer opens a single holder term deposit for an amount of S 375500 by debiting his joint savings account Since he is the holder of the term deposit but the account is joint that is it has more than one holder this transaction will be eligible for the transaction tax also since the single holder rule is not met in this case Transaction Description Transaction Tax Remarks Term Deposit Creation Transaction by Savings Account Debit This transaction is subject to Term Deposit Single Holding transaction tax as there is different holding pattern order Savings Account Joint Holding 10 2 1 Transaction Tax Maintenance Set Up A tax rule identif
188. or Child TD sese 5 32 5 11 6 Deposit Tab Deposit Preferences for Child 5 35 D212 SPECIFYING SCHEDULE DETAILS ROREM RE sates 5 41 513 VIEWING ENDORSEMENT LOG nete e ROREM GRENIER REOR EU IR Pr EE RET AEN 5 42 5 14 SETTING ACCOUNT PREFERENCES eee nein ei tentes hse teas sina 5 44 20 15 VMIEWING EVENT DETAILS estie ore Fd e RE tO ERR petiere e 5 44 20 10 VIEWINGCHANGE LOG eter des cr 5 45 5 17 MAINTAINING AMOUNT BLOCKS esee E enne trennt ense innen enin 5 47 20 18 VIEWING ED SUMMARY erre Pe ERE Exe Ee EE cuueesvesdevieegcaneyebecdeveesbentvenartuentavics 5 48 5 19 SPECIFYING DEPOSIT INSTRUCTIONS eet terre deste tete coi eerte ese eri herbe ue ep 5 50 3 19 1 Specifying UDF Values itte eiue Yee aeg 5 52 5 20 VIEWING INSTRUCTION S MMARY onseren reion iver KEE nennen trennen entente nnn 5 53 6 1 6 1 INTRODUCTION e 6 1 O22 REDEEMING 6 1 6 2 1 TD Redemplion 4 ee pe ete ter ete e aa e 6 6 6 2 2 Capturing Pay Out Detdils et GR rte itle tois ce y EE HEC dele sete 6 7 6 2 3 Cheque DD Details Grit aE te P O Ma
189. orking Day e Likewise the backdated deposits will be handled based on the holiday set up Suppose there is any changes in the holiday calendar after opening the TD due to change in ADHOC holidays there will not be any impact on the maturity dates for the existing deposits Due to ADHOC holiday changes if the maturity date of the existing deposit is falling on a holiday then the interest processing will be done based on the parameter set up done for Process Till field at IC Branch Parameters level But there will not be any movement on maturity date Due to ADHOC holidays if the maturity date is falling on holiday the additional interest calculation process will be done When there is any changes in the holiday calendar after opening the TD and auto rollover instructions are provided for that TD then ADHOC holiday date also will be considered during the time of auto rollover During the auto rollover if the new maturity date is falling on a holiday then system will automatically adjust the maturity date to the next working date Accordingly the tenor also should get modified For successive rollovers the original tenor of the TD should be retained provided the maturity date is not falling on holiday 6 2 10 Holiday Treatment during Manual Rollover For manual rollover transaction based on the start date and tenor if the maturity date falls on a holiday then the system will display the following error message Maturity date is on
190. osit it is date of opening of TD and in case of roll over TD it is previous maturity date _ TDAMTWORD _ Amount words _AMTINWORDS Amount in Words in readjustable currency _JOINTHOLDERCODE_ _JOINTHOLDERDESC_ _JOINTHOLDERTYPE_ Joint Holder Details _UDFTAGS_ All UDFs associated to term deposit account Event wise Accounting Entries for Products You can set up various IC products for handling TDs Some representative products are listed below e TD with Capitalization e Normal TD with Simple Interest e TD with Rate Chart Allowed e Recurring deposit Scheme 8 6 1 TD with Capitalization 8 9 ORACLE You can set up event wise accounting entries and advices for the product as suggested below Accounting roles are for sample rule ID APO1 8 6 1 1 DEBK Book Accounting Entries Accounting Role Amount Tag Dr Cr Indicator TDACCOUNT TD PRINC Credit TDOFFSET TD PRINC Debit 8 6 1 2 IACR Interest Accrual Accounting Entries Accounting Role Amount Tag Dr Cr Indicator AP01 PNL_ADJ 1 IACR_ADJ Debit AP01 ACR_ADu 1 IACR_ADJ Credit APO01 PNL 1 IACR Debit AP01 ACCR 1 IACR Credit 8 6 1 3 ILIQ Interest Liquidation Accounting Entries Accounting Role Amount Tag Dr Cr Indicator AP01 ACCR 1 ILIQ Debit AP01 PNL_ADJ 2 IACQUIRED Credit AP01 BOOK 2 IACQUIRED Debit AP01 BOOK 1 IACQUIRED Credit AP01 ACQUIRED 1 IACQUIRED Debi
191. pecify the amount less than the original deposit amount in this field Payout Type Indicate the method for initial funding during account creation Choose one of the following options e Account Number e General Ledger e Bankers Cheque e Payments Percentage Specify the percentage of the amount that be rolled over g ORACLE Offset Branch The system populates the branch code of the account from which fund is transferred to TD account Account Specify the account number GL from which the fund is transferred to TD account This field returns the branch code if the account is selected and NULL is returned if GL is selected If it is Pay In mode in GL then the system displays only GL s and if the Pay In mode is Account then only accounts are displayed in the option list Narrative Specify remarks about the transaction 5 11 6 1 Specifying Pay out Parameters for Child TD Click Payout Parameters button on the Term Deposit Interest screen and invoke the Payout Parameters screen Here you can specify pay out preferences for the child TD Payout Parameters Bankers Cheque PC Cheque Details Currency Bank Code Payable Branch Beneficiary Details Beneficiary Address Beneficiary Name Passport lC Number Narrative This screen comprises two tab viz e Bankers Cheque e PC 5 11 6 2 Bankers Cheque Tab for auto pay out of Child TD By default this tab is displayed on invoking the screen You nee
192. pecify the rate code to be used for TD calculation The adjoining option list displays all rate codes maintained using the LD MM Floating Rate Input screen CFDFLTRT You can select the appropriate one You can use TD rate code only when you have checked Rate Chart Allowed option for the account class that is linked to the IC product In the corresponding IC rule you need to ensure that UDE Type is maintained as Rate as Rate Code for interest rate pick up for this account Refer the chapter Annexure B IC Rule Set up in this User Manual for further details about IC rules Note the following e f you specify the UDE value and also a rate code rate code or TD rate code the system will add the UDE value to the specified rate code value and apply that interest rate on the deposit e You can define either the rate code or the TD rate code but not both Specifying Charge Details Click Charges button on the Deposit Account Booking screen and invoke the Account level charges conditions screen Note that this screen is not applicable for Term Deposits De ORACLE Account level charges conditions Account Details Branch Code Account Product Details Anda x Product Code Minimum Description Maximum Currency Free Items Waive Charges Open List of Slab Amounts 10f1 CEEITUENNCTIUNMMNE GN NN Ci You can specify the following details Branch code The Br
193. ping TDRFIDEP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 11 1 ORACLE Customers Fixed Deposit Report Customer Number az Specify the following details here Customer No Select the customer number from the adjoining option list The list displays all valid customer codes Click OK button to generate the report Click Exit to return to the Reports Browser 11 2 1 Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Bank Name Branch Run Date User ID and the Period for which the report is generated Body of the report The following detail block elements are displayed in the report Field Name Field Description Customer ID This indicates the unique id of the customer Customer Name This indicates the name of the customer Customer Type This indicates the type of customer Account Number This indicates the customer account number oe ORACLE The generated report will have the following information grouped customer wise and account number wise Field Name Field Description Rate type This indicates the rate type for an account Officer ID This indicates the unique id of the officer Currency This indicates the account currency Deposit amount LCY This indicates the deposit amount of the accoun
194. plain the Term Deposits TD module of Oracle FLEXCUBE It provides an overview to the module and provides information on using the Term Deposits module of Oracle FLEXCUBE You can further obtain information specific to a particular field by placing the cursor on the relevant field and striking F1 on the keyboard 1 1 1 Audience This manual is intended for the following User User Roles Role Function Back office managers officers Authorization functions Product Managers Product definition and authorization End of day operators Processing during end of day beginning of day Financial Controller Product Generation of reports Managers 1 1 2 Organization This manual is organized into the following chapters Chapter 1 About this Manual acquaints you quickly with the organization audience glossary of icons and related documents for this User Manual Chapter 2 Term Deposits An Overview offers a brief insight into the TD module and lists out the salient features Chapter 3 Term Deposit Maintenance explains the maintenances required for creating and servicing TDs Chapter 4 TD Account gives details about how to create a TD account Chapter 5 TD Additional Details gives information about the additional information that can be captured while creating a TD It also explains the procedure to maintain instructions for operating a TD ORACLE Chapter
195. plays the old primary beneficiary who held the TD account before endorsement ORACLE 5 14 5 15 TD Sale Amount The system displays the TD sale amount If the Demat TD is sold the TD Sale amount will be displayed TD Sale Currency The system displays the TD Sale currency The TD account currency will be defaulted as the TD Sale currency Setting Account Preferences Click Preferences button to set the account preferences Account Preferences x Advices Generate Maturity Advice Generate Renewal Notice Exit Generate Maturity Advice Check this box to enable generation of maturity advice The system defaults the status of this check box as maintained at the account class level However if the box is checked at the account class level you can modify it here Generate Renewal Advice Check this box to enable generation of renewal advice The system defaults the status of this check box as maintained at the account class level However if the box is checked at the account class level you can modify it here Viewing Event Details Click Events button to view the event details und ORACLE Events Reference Number 0O9TDSL113340006 Events hd 9 10f1 p MI UNEIITTEMENNCTIONENENCCIDIO NENNC 1 2011 11 30 DEBK Term Deposit Booking O 2 2011 11 30 IACR Interest Accrual 3 2011 12 01 IACR Interest Accrual 4 2011 12 08 IACR Interest Accrual 5 201
196. r Specify the payment account number used for manual payment for the RD The adjoining option list displays all valid savings account and current accounts maintained in the system You can select the appropriate one ie ORACLE Product Code Specify the retail teller product with combination of ARC maintenance You have to ensure that the retail teller product is enabled for RD payments by checking the field RD Payments allowed at the teller product level maintenance preferences screen Exchange Rate Specify the exchange rate if the account currency is different from the currency in which the payment amount is expressed Payment Currency Specify the currency in which the payment is being made The adjoining option list displays all valid currency codes maintained in the system You can select the appropriate one Payment Amount Specify the amount deposited as payment Here you can specify the installment amount or the complete deposit amount in multiples of the a installment amount Minimum Payment Amount The system displays the installment amount indicating the minimum amount that can be deposited in the RD account After entering the RD accounts payment details click P button The system then calculates the paid amount and displays them in the respective fields RD Account Payments On click of P button along with paid amount the system calculates the due days due date instalment amount and RD contract stat
197. r reet n eei eee Pe hetero eere eaae puri iens 5 2 2 9 SPECIFYING CHARGE DETAILS M 5 8 D4 SPECIFYING LINKED ENTITIES gt 5 10 9 9 SPECIFYING RESTRICTIONS E M 5 11 2 0 SPECIFYING MIS DETAILS s 5 14 5 6 1 Viewing CHANGE Log tert t e eet Pre ENERO eset Pr HELME as A RE Erbe eget 5 17 5 6 2 Viewing Transfer Log eec etr PREDA IS ERR TE SERRE REPE EE ERE EHE REESE 5 18 5 7 SPECIFYING STATEMENT DETAILS s ssccesesesssennsntevsepvedbeonsssnsterstenseontinnestesvenbonnrosestanstehsseneieesteesseibonseeeetsy 5 19 5 8 SPECIFYING JOINT HOLDER DETAILS EEES EEE EENAA E E ERES 5 22 29 0 CAPTURING USER DEFINED FIBEDS 4 eter HO DERI REOR I RERUM E EANES ESA ENa 5 24 5 10 SPECIFYING ACCOUNT SIGNATORY 5 5 25 5 4 INDICATING TD PAYOUT DETAIES eerte eem e rte Re E SEHR ER A rH Rete ESAE 5 27 LILI Teri Geposit i eO epe eH SO UR Yee 5 27 DAL Bankers Cheque DD Tab 2i eR EROR Ue ees eR Re apg at Hep CER IRL 5 28 OX Specifying PC Details ui d He tope toe o E Mag CEP I doe 5 30 5 11 4 Capturing Payout Interest Details for Child TD essent 5 31 5 11 5 Interest Tab interest preferences f
198. raft Term Deposit Cheque DD Details Counter Party Details Cheque DD Details Instrument Type Bank Code Jaz Cheque Date Payable Branch Beneficiary Details Address Line 1 Beneficiary Name Other Details Narrative Address Line 2 Address Line 3 Country Code You can capture the following details Cheque Details Specify the following cheque details or ORACLE Bank Code Specify the bank code of the Bankers cheque Cheque Date Specify the cheque date for the pay out Payable Branch Specify the payable branch for the cheque The adjoining option list displays all branch codes linked to the specified bank code You can select the appropriate one Beneficiary Details Indicate the following details Beneficiary Name Specify the name of the beneficiary for the payout Other Details Specify other details if any for the beneficiary Narrative Give a brief description for the payout Country Code Specify the country code for the payout address Address Line 1 to 3 Specify the address of the beneficiary for the payout oe ORACLE 6 2 4 Counter Party Details Tab Click Counter Party Details tab on the Term Deposit screen and invoke the following screen Here you can capture pay out details for PC transfer to another bank account You need to maintain these details if you have selected Payout Option as Payments Term Deposit Cheque DD Details Coun
199. ranches using the Interest amp Charges Branch Availability Maintenance screen You can invoke this screen by typing ICDRESTR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button IC Rate Code Branch Availability Rate Code Branch Restrictions Allow Disallow Branch Specific Rates EEE ol las Input By Authorized By Modification Authorized Date Time Date Time Number Open You need to maintain the following rate codes for all branches of your bank e FLOATRATE For the aforesaid rate code you need to maintain rates and effective dates in the Interest and Charges Rate Input screen You can invoke the Interest and Charges Rate Input screen by typing ICDRATES in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 9 24 ORACLE 9 5 9 6 interest amp Charges Rate Input Currency Code az Branch Code az Rate Code az LI Effective Date Input By Authorized By Modification Authorized exit Date Time Date Time Number Open These rates are picked up by the TD module while processing interest applicable on a TD account Refer the chapter Floating Rate Codes for IC Module for details about rate maintenance Introduction This chapter lists the TD tax rules that need to be maintained for the TD module of Oracle FLEXCUBE It als
200. reen and invoke the Linked Entities screen LZ Csccusin_Desc Account Number 10f1 Specify the following details Customer Select the customer from the option list with whom you want to establish the relationship with the account that you are maintaining 30 ORACLE Description In this field the system displays the name of customer that you have selected in the previous field You cannot change the description Relations By default the system will select the customer of the account as the Primary Holder This is a pre shipped relationship and you will not be allowed to change the relationship Include Relationship Check this box to indicate that relationship should be inherited for all transactions Specifying Restrictions Click Restrictions button on the Deposit Account Booking screen and invoke the Products and Transaction Codes Restriction screen Products and Transaction Codes Restriction Product Details Product List Allowed Disallowed Special Condition Applicable Not Applicable 10f1 r a Transaction Details Transaction List Allowed Disallowed Special Condition Applicable Not Applicable 10f1 TEZIE c i zn ORACLE Specify the following details Product Details Indicate the following preferences Special Condition By default the restrictions maintained at the account class level will be displayed here Whe
201. rest Check this box to waive penalty interest calculated on the account Suppress Redemption Advice By default the system will generate the redemption advice However if you check this box the redemption advice creation will be suppressed This field is applicable only for Discounted and Bearing products e ORACLE Renewal Redemption Choose Renewal option to renew the accounts that are within the grace period days Choose Redemption to redeem the term deposit Remarks You can provide a brief description about the TD Redemption Indicate the following details if you have chosen Redemption Redemption Mode Select the mode of redemption from the following options e Full Redemption In this case you can redeem the complete deposit balance of the account On save the redemption amount will be equal to the account balance Full redemption will update the status of the deposit amount as closed On complete redemption interest along with principal is redeemed The redemption amount is equal to the total of principle and interest amounts subtracted by penalty and tax amounts e Partial Redemption In this case you have to specify the redemption amount Ensure that that the redemption amount is less than the account balance On partial redemption only the principal amount is paid out but the interest gets liquidated to the interest booking account on partial redemption During partial redemption if amount blo
202. rom the drop down list Following are the options available in the drop down list e Single e Joint Beneficiary ID Specify the primary beneficiary of the new account Beneficiary Specify the joint holder details Custody Stat Select the custody status from the drop down list While fractioning if the parent TD type is Demat then you need to define the custody status of the child TD Following are the options available in the drop down list e Electronic Custody e With Third Party You need to specify the custody status only if the Main TD is of Demat type Third Party ID Specify the third party ID This is applicable only if the custody status is With Third Party This field is enabled only if you select the Custody Status as With Third Party Redemption Acc Brn Based on the redemption account selected the system displays the redemption account branch Redemption Acc Specify the principal liquidation account In case the fraction TD has the custody status as With Third Party the redemption account must be a GL Redemption Acc Ccy This is the principal liquidation account currency The system displays the redemption currency based on the redemption account Interest Book Brn The system displays the interest booking account branch es ORACLE 3 7 3 8 Interest Book Acc Specify the interest booking account The interest book account is mandatory if the fraction TD has the custody statu
203. rt This is a report of term deposits interest paid for the day In this report accounts are grouped Account class wise and interest type wise This report is generated at BOD 11 6 1 Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Bank name Branch Run Date User ID and the Period for which the report is generated Body of the report The generated report will have the following information Field Name Field Description Account Class Code This indicates the Account Class Code Account Class Name This indicates the name of the account class Currency This indicates the account currency Interest Type This indicates the interest type for the TD account Following elements will be displayed for branch account class and interest type Field Name Field Description Account Number This indicates the Account Number s ORACLE Customer Name This indicates the name of the Customer Payment Frequency This indicates the Payment Frequency Interest paid today This indicates the Interest paid today in ACY Interest paid To date This indicates the Interest paid To date in ACY Following elements will be displayed for Totals Field Name Field Description Account class total interest paid This indicates the Account class total for interest paid today today
204. s User Manual for details about the aforesaid buttons o During endorsement TD sale amount is specified in the TD Account Opening screen and the same will be logged in the endorsement log During the closure on maturity or redemption of the TD account system calculates and liquidates the TDs for the dematerialized TD accounts 4 32 ORACLE 5 1 5 TD Additional Details Capturing Additional Details You can capture additional details for the account by clicking the following buttons in the Deposit Account Booking screen Button Function Interest This invokes the IC Special Conditions Maintenance screen Charges This invokes the Account level charges conditions screen Linked Entities This invokes the Linked Entities screen Restrictions This invokes the Products and Transaction Codes Restriction screen MIS This invokes the Management Information System screen Statement This invokes the Statement Details screen Joint Holders This invokes the Linked Entities screen Fields This invokes the User Defined Fields screen Account This invokes the Signatory Details screen Signatory TD Payout This invokes the Term Deposit Payout Details screen Details Endorsement This invokes the Endorsement Log subsystem Log Schedules This invokes the Schedules subsystem Preferences This invokes th
205. s a combination of the branch code and the IC product code Account Class Specify the account class to which the particular account belongs You can select the appropriate account class from the option list that displays all deposit type of account classes maintained in the system Account classes that have surpassed their end date expired will not be displayed in the option list Pay In Option Pay in By Select the pay in option from the adjoining drop down list This list displays the following values e Cheque e Others If you want to create TD through cheque you must specify the pay in option as Cheque If the pay in option Cheque is selected you need to pay the total TD amount only by cheque and during account class default the account opening dates would be updated as expected value date of the cheque transaction The clearing product used for the cheque should not bear any charges in the ARC Maintenance If the clearing product has any charges then the system will display an error message on display of TD account number Note the following e If the pay in option once selected from the main tab cannot be changed after account class defaults e details of the cheque entered the Main tab will be automatically displayed in the Pay in details of the Deposit tab You cannot modify it e option as cheque is not applicable to discounted TDs If the pay
206. s as With Third Party In that case the interest booking account must be a GL Interest Book CCY The system displays the interest booking currency For the new TDs the IC functionality will do the catch up accrual from the account opening date till Fractioning Date on Running ICEOD Batch during BOD Maintaining Reason Code You can maintain the reason code for the blockage using Reason Code screen You can invoke this screen by typing TDDRSNCD in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Reason Code Reason Description Maker Date Time Checker Date Time Reason Code Specify the reason code for the blockage Reason Description You can provide a brief description for the blockage reason here Setting Up Interest Preferences for TD os ORACLE You need to set up an Interest Charge product to handle the calculation of interest and charges on a TD You can set up a product using the Islamic Profit Distribution Product Maintenance screen invoked from the Application Browser You can invoke the Interest and Charges Product Maintenance screen by typing CDPRMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Interest and Charges Product Maintenance Product Code TDFN Include For TDS Calc Product Description TD FINAL PDT Deposit Product Type Tax Descr
207. s the term deposits which will be matured for the given period You can generate this report using TD Account Maturity Report screen by typing TDRMATR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button From Date To Date Branch Account Class Customer Specify the following details here From Date Enter the From date This should be greater than the current application date To Date Enter the To date This should be greater than the current application date Branch Specify the branch code of the TD account The adjoining option list displays the list of all the valid TD RD branch codes maintained in the system You can choose the appropriate one Account Class Specify the account class of TD account The adjoining option list displays the list of all the valid TD RD account classes maintained in the system You can choose the appropriate one Customer Specify the customer number of the customer The adjoining option list displays the list of all the valid customer numbers maintained in the system You can choose the appropriate one ORACLE Click OK button to generate the report Click Exit to return to the Reports Browser Body of the report The generated report will have the following information Field Name Field Description Account No Deposit No This indicates the TD account Number Cu
208. sed restrictions are allowed only for entries initiated from the Data Entry module Otherwise you should use product code based restriction Description The system displays the description for the transaction code that you have specified vis ORACLE 5 6 Debit During transaction processing the system will validate whether any restrictions are placed on the account based on the transaction code If you have indicated to allow Dr transactions for a particular transaction code and attempt to post a credit entry the system will seek an override If the message has been configured as an override instead of an error you will be able to continue the transaction despite the restrictions by providing appropriate reasons for the same Otherwise you cannot continue with the transaction During maintenance or online operations in the respective contract screens for the restricted transactions when you specify the customer account the system checks whether the account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved Credit During transaction processing the system will validate whether any restrictions are placed on the account based on the transaction code If you have indicated to allow Cr transactions for a particular transaction code and attempt to post a debit entry the system will seek an override If the message has been
209. seeeee eene ener enne nn enint nre 3 30 3 9 1 Maintaining Parameters for Premature Withdrawal Of TD sse 3 33 4 S 4 1 4 1 CREATING As DEPOSIT ACCOUNT orsi Gee GR IRR RH REGII ORE AERIS 4 1 4 1 1 Main TOD mm 4 5 4 1 2 PICARD M 4 11 4 1 3 Viewing Amounts and D tes ie e rie casas eei eH HUC rege rae red 4 12 4 1 4 Specifying Joint Holder Details for a TD essere eene nennen nenne 4 14 4 1 5 Viewing Endorsement Details for a TD cesses eene trennen nennen ens 4 15 4 1 6 Viewing Third Party Details iie e i Esp rige totis Co Reset 4 16 4 1 7 Nominee TAD m 4 18 4 1 8 Deposit ELT E X 4 20 4 1 9 Dual Currency Deposit M Rm 4 27 4 110 N EE O ER EE RETER 4 29 4 1 11 Holiday Treatment during TD Creation eese eene nennen rennen 4 30 412 Capturing Additional Details uie ie retro E eS esce R 4 31 5 TD ADDITIONAL DETAILS eeeeeeeeee eese ee ene enses suse 5 1 ORACLE 5 1 CAPTURING ADDITIONAL 5 5 1 2 2 SPECIFYING INTEREST DETAILS eerte it
210. sit Deposit Check List In this tab you can maintain the document related details T4 ORACLE 4 1 1 Main Tab On invoking the Deposit Account Booking screen this tab is displayed by default You can specify the following details Description This is the description of the account Here you can enter the nature of the TD account If a customer has two or more accounts under one account class you can specify the purpose of that account Account Type You have to indicate whether the account is to be opened only by the account holder or whether it can be jointly operated The account type can be Single or Joint Country Code Specify the country code to define country limits The adjoining option list displays all valid country codes maintained in the system You can select the appropriate one Mode of Operation Indicate the mode of operation Choose one of the following options from the drop down list e Single e Jointly e Either Any one or Survivor e Former or Survivor e Mandate Holder Account Open Date The date on which the account has to be opened is defaulted based on the account class selected here You can change the opening date of the account to a date in the past You cannot set the account open date to a future date However when a TD is paid in by cheque the system considers the fund available date of the cheque as the account open date TD Creation Date The system displays the curre
211. so reversals made through the DE module will not be considered for exclusion This specification is defaulted from the account class linked to the account You can change it for a specific account ae ORACLE 5 8 Specifying Joint Holder Details Click Joint Holders button on the Deposit Account Booking screen and invoke the Joint Holders screen Joint Holders Branch Code Account Customer No List of Joint Holders 10f1 mi Joint Holder Code Joint Holder Type Start Date End Date t Specify the following details Branch Code The system displays the branch code of the current branch Account The system displays the account number here Customer No The system displays the customer account number Joint Holder Code Specify the code number assigned to each of the joint holders of this account Description This is the description of the joint holder Here you can enter the name of the joint holder and also his relationship with this customer Joint Holder Type Indicate the type of authority Select the appropriate one from the drop down menu The options are e Authorized Signatory iae ORACLE Customer Contact Person Guardian Custodian Developer Guarantor Joint and First Joint and Other Joint or First Joint or Other Nominee Related for Enquiry Solicitor Sole Owner Third Party Trustee Valuer Start Date Specify the date from which the joint holding of the
212. ss rights validation only on Save operation 4i ORACLE Deposit Account Booking N Branch Code 000 Term Deposit Account Number Customer No Customer Name Term Deposit Currency Account Class SD User Reference Pay In Option Pay in Mode Clearing Type Cheque Instrument No Others gt Same Holder Other Holder Cheque Date Drawee Account Number 2i Routing No az TD Ref No Main Nominee Deposit Dual Currency Deposit Check List Description Option Demat Details Account 9 Single Track Receivable Joint E Replicate Customer Country Code a Signature Mode of Operation 7 Endorsable Single 7 Auto Liq Schad Amounts And Dates Account Open Date e TD Creation Date Alternate Account Number Clearing Bank Code Address Type Physical Third party code TD Sale Amount TD Sale Currency Status Tracking Custody Status v Custody Status Change Details Document Status Account Status Auto Deposit Sweep Type Master Account Number Fraction Details Main Account Fraction Date Fungible No ISIN No Operation No Control No Account Block Details
213. stomer Name This indicates the Name of the TD account holder Date of Open This indicates the TD account opened date Value Date This indicates the Value Date of the TD account Deposit Amount This indicates the Deposit Amount Maturity Date This indicates the Maturity date of the TD account Deposit Term This indicates the TD Tenor Maturity Date Interest Start Date Total Interest Payable This indicates the Interest Amount This will show interest amount on the maturity date Maturity Amount This will show the sum of Deposit amount and Interest Amount Branch This indicates the Branch Name Product Code This indicates the Account Class code of the TD account Product Title This indicates the Account Class description of the TD account Product Currency This indicates the Currency of the TD account class Currency Total This indicates the Currency wise total for deposit amount Interest Payable and Maturity Amount Auto Rollover Will indicate whether the TD is Auto Rollover or not 11 19 ORACLE 11 1 ORACLE 12 Screen Glossary 12 1 Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual Function ID Function Description ACDAUDTR Customer Account TD Audit Trail CFDFLTRI LD
214. system defaults the TD currency Default From Indicate whether the details should be picked up from the parent TD account or the account class by choosing one of the following options e Account e Account Class Account Class Specify the account class if you have selected the Default From as Account Class If you select the Default From as Account then on clicking of P button the system will default the interest and deposit details from the parent TD account Or if you select the Default From as Account Class then on clicking P button the system will default the interest and deposit details from the account class selected For the child TD you will have to capture interest calculation and pay out preferences You can do this by clicking Interest button on the screen Refer the section Capturing Payout Interest Details for Child TD in this chapter for details about capturing interest preferences for Child TD in case auto pay out by rollover option is selected 5 11 2 Bankers Cheque DD Tab Click Banker s Cheque DD tab to capture cheque related details if you have opted for TD pay out through a banker s cheque Term Deposit Payout Details Branch Code Currency Account Term deposit Bankers Cheque DD PC Cheque DD Details Instrument Type Bank Code Currency Payable Branch Beneficiary Details Beneficiary Address Beneficiary Name PassportvlC Number Narrative
215. t E R 11 7 11 6 INTEREST PAID REPORT o reco eee eoe ee ve ae tuv c oec vue vae eau uae nee Uh 11 8 ILOT Contents ofthe Report isset LU E as ARES Fe Heap E IER Perse gi 11 8 11 7 TD STATEMENT OF ACCOUNTS REPORT ccccccscecececececececeeeceeecsesceeeesceceescececececececeeeeeeeeeeeeeeseeeeeeeseeeeeecs 11 9 LIU Contenis of te Report uie Orge IHE E HA YE AERE HR Ce FEL He EU HER Gata d 11 9 11 8 TD ACCOUNT CLASS SUMMARY REPORT cccccccccsececesecececseceececeesceesesescececececececececeeseeeeceesceeeeeeseeeeeeeess 11 10 LL6 1 Contents of the Report sio ee ie Yer E le tede Pe ERR Dep e pb bas vba eae 11 10 11 9 TERM DEPOSITS OPENED FOR THE PERIOD REPORT cccsscesecececececsceeecececececececscececseseseseseeeeeeeseeeeeecess 11 12 11 10 TERM DEPOSITS CLOSED FOR THE PERIOD REPORT cccccccccsecesecesecesecesseeseceseeesseesesesecesseeseeeseeeeeeess 11 14 11 11 TERM DEPOSITS RENEWED FOR THE PERIOD REPORT ccccccccccecesecececesecesecesecesecesecesecessseseseseeseeeess 11 16 11 12 TERM DEPOSITS MATURITY REPORT eeeeeetee ee ememenenennnen nnnm nne etes ese uses ase ese e ese se eset 11 18 12 12 1 12 1 FUNCTION 12 1 ba ORACLE 1 About this Manual 1 1 Introduction This manual is designed to ex
216. t AP01 BOOK 1 ILIQ Credit AP01 BOOK 3 TAX ADJ Debit AP01 TPBL 3 TAX Credit AP01 BOOK 3 TAX Debit AP01 PNL 2 ILIQ Credit AP01 BOOK 2 ILIQ Debit 8 10 ORACLE Accounting Role Amount Tag Dr Cr Indicator APO1 TPBL ADJ 3 TAX ADJ Credit 8 6 1 4 IMAT Interest Maturity Accounting Entries Accounting Role Amount Tag Dr Cr Indicator INT LIQD IMAT Debit INT BOOK IMAT Credit PRINC LIQD PMAT Debit PRINC BOOK PMAT Credit o You need to maintain entries for each of your booking type formulae otherwise the system will not be able to process IC Tax entries are mandatory if tax parameters are maintained for your rule When you don t maintain tax through the Tax sub system but instead you maintain it as a debit type interest component you should use the common accounting roles and amount tags 8 6 2 Normal TD with Simple Interest You can set up event wise accounting entries and advices for the product as suggested below Sample accounting entries for IC Product with Rule ID APO2 are given below 8 6 2 1 DEBK Book Accounting Entries Accounting Role Amount Tag Dr Cr Indicator TDACCOUNT TD PRINC Credit TDOFFSET TD PRINC Debit 8 6 2 2 IACR Interest Accrual Accounting Entries Accounting Role Amount Tag Dr Cr Indicator AP02 PNL 1 IACR Debit AP02 ACCR 1 IACR Credit AP02 PNL_ADJ 1 IACR_ADJ Debit ORACLE
217. t Interest Account Details Interest Deposit Calculation Account Interest Booking Account Charge Booking Account Interest Statement Product Details Product Code UDE Currency Effective Date Interest Start Date Charge Start Date Interest Booking Branch Dr Cr Advices Charge Booking Branch Waive Charges Generate UDE Change Advice Open 10f1 UDE Values 10f1 User Defined Element Id UDE Value Rate Code Payout Parameters This screen comprises two tabs viz e Interest e Deposit 5 11 5 Interest Tab interest preferences for Child TD You need to capture the following details here Interest Tab You can capture the following interest related details Calculation Account Select the calculation account of the child term deposit from the option list 5 32 ORACLE Interest Booking Account You can select the accounts for booking interests on transactions processed at your bank Charge Booking Account You can select the accounts for booking charges on transactions processed at your bank Interest Statement You can also indicate if you would like to generate an interest statement for the account The Interest Statement will furnish the values of the SDEs and UDEs and the interest rule that applies on the account Consolidated Charge Account Specify the account The option list consolidated change account Dr Cr Advices You can indica
218. t change the maturity date automatically even though the maturity date is falling on a holiday However system will display the following message mus ORACLE Maturity Date is a Holiday as per the Holiday Treatment 3 5 3 Maintaining Transaction Tax Details 3 6 Click Transaction Tax button on Account Class Maintenance screen to invoke the Transaction Tax Details Screen Transactiih tax Details x Transaction tax Exemption Details Transaction TAX Exempt Ok Cancer Transaction TAX Exempt Check this box to indicate that the transaction tax is exempted for that account class The exempt option cannot be modified if active accounts exist for that account class Maintaining Term Deposit Fractioning Fractioning is the process to split one TD into many fractions or new TDs The original TD is called Main TD and the new TDs are called Fractions TD Fractioning can be completed during the day and the process can only be confirmed when the values of the Fractions TD are equal to the value of the main TD The system will close the draft versions which are not confirmed at the end of the day Following are the validations required for fractioning of a TD e Fractioning is not allowed for a blocked TD e Fractioning is possible only at the branch where the TD was opened e Fractioning can be done if the TD has a minimum principal two 2 million COP The System validates this based on the minimu
219. t in local currency Deposit value date This indicates the value date of the deposit transaction in an account Maturity date This indicates the maturity date of a deposit account Deposit term This indicates the term of the deposit account Deposit amount ACY This indicates the deposit amount in account currency for an account Lien Details This indicates the Lien Details Amount Blocked of an account 11 3 TD Full Balance Listing Report This report gives a complete listing of time deposit accounts opened till the run day This report gives account class wise grouping of accounts with totals You have an option to print and view the report in pdf or excel format You can invoke TD Full Listing Reports screen by typing TDRFULBL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button TD Full balance Listing Branch Code i Status Processing Date v Specify the following details here 11 3 ORACLE Branch Code Select the branch code for which the report needs to be generated from the adjoining option list The list displays all valid branch codes You have an option to select all the branches or a single branch Processing Date Select the date for processing the report from the adjoining calendar button By default the current date is displayed here Status Select the account status from the drop dow
220. t into which the principal should be liquidated You should also Interest Start Date Specify the date from which the interest accruals of TD account begins Maturity Date The system defaults the maturity date from the default tenor from the account class However you can modify this date On this date the term deposit account gets liquidated 6 35 ORACLE Auto Rollover Check this field to automatically rollover the deposit you are maintaining You have to indicate Rollover Type on selecting this option Close on Maturity Check this field to close the term deposit account on maturity date and transfer the amount to the principal liquidation account If you select this option the principal liquidation account should be an account other than the term deposit account Move Interest to Unclaimed Check this field to move the interest amount to the unclaimed GL mapped at the IC product in the accounting roles on grace period end date of the term deposit account If you select this option the principal liquidation account should be the term deposit account Move Principal to Unclaimed Check this field to move the principal amount to the unclaimed GL mapped at the IC product in the accounting roles and liquidate the interest amount to the interest booking account on grace period end date of the term deposit account If you select this option the principal liquidation account should be the term deposit account Term Deposit
221. tails in this User Manual 6 8 4 1 Specifying Deposit Details Click Deposit button in the IC Special Conditions Maintenance screen to specify preferences for the simulated account Details for Deposit types of Account Principal Liquidation Branch Interest Start Date Maturity Date TD Pay Option Offset Branch Recurring Deposit Payment Branch Payment Account Installment Amount Payment Date Payment Currency E fel E Auto Rollover Close on Maturity Move Interest to Unclaimed C Move Principal to Unclaimed v Auto Pay C Move to Principal Unclaimed Jag RD Account Specify the following details Principal Liquidation Branch Principal Liquidation Account Next Maturity Date Deposit Tenor Rollover Details Rollover Amount Offset Account TD Amount Installment Frequency Days Months Years Principal Principal Interest Special Amount az C Move Funds on Overdraft Specify the branch in which the liquidation account is maintained The adjoining option list displays all valid branches maintained in the system You can select the appropriate one Principal Liquidation Account On maturity the principal of a time deposit can be liquidated into an account you specify This would typically be the customer s account When maintaining a deposit indicate the accoun
222. te whether you want to generate an interest liquidation advice for a customer account Check the Debit Credit Advices box to indicate that the system must generate payment advices when interest liquidation happens on an account The advices are generated in the existing SWIFT or and MAIL format No advices will be generated if you leave this box unchecked The preference you have made in the Customer Account Class screen will be defaulted here However you can choose to change your preference to generate or suppress these Advices Interest Start Date The system displays the Maturity date of the parent TD as the interest start date for the child TD However you can modify it Interest for this account will be calculated according to the special conditions that you define subsequently Charge Start Date For the account for which you are defining special conditions you must specify the date from which you would like to apply charges Charges for this account will be calculated according to the special conditions that you define subsequently By default charges on an account would be applied when the free banking period if any elapses This means that the Charge Start Date is arrived at by the System by adding the Free Banking Period days if any specified for the account class used by the account to the Account Opening Date If no Free Period has been indicated for the account class used by the account the Charge Start Date is defaul
223. ted to the Account Opening Date that is charges on the account would be applied right from the account opening date and displayed in the Special Conditions Maintenance screen You can override the default Charge Start Date and specify the desired start date for charge application is ORACLE Interest Booking Branch By default the customer s account in the current branch will be displayed in this screen in the Interest Charge Booking Account and Interest Charge Booking Branch fields However you have the option of booking interest charge to a different account belonging to another branch also You can select the Interest Charge Booking Branch from the option list available The accounts maintained in the selected Booking Branch will be available in the option list provided for Interest Charge Booking Account You can select the account from this list Interest Charge will be liquidated into the selected account Charge Booking Branch By default the customer s account in the current branch will be displayed in this screen in the Interest Charge Booking Account and Interest Charge Booking Branch fields However you have the option of booking interest charge to a different account belonging to another branch also You can select the Interest Charge Booking Branch from the option list available The accounts maintained in the selected Booking Branch will be available in the option list provided for Interest Charge Booking Account You c
224. tended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and serv
225. ter Party Details Counter Party Details Counter Party Bank Code Counter Party Offset Account Beneficiary Details Beneficiary Name Address Line 1 Address Line 2 Other Details Narrative You can capture the following details Counter Party Details Specify the following cheque details Counter Party Bank Code Specify the bank code of the counter party Counter Party Offset Account Specify the branch code of the account for redemption Beneficiary Details Indicate the following details Beneficiary Name Specify the name of the beneficiary eu ORACLE 6 2 5 Address Line 1 to 2 Specify the address of the beneficiary Other Details Specify other details if any for the beneficiary Narrative Give a brief description for the payout Capturing Interest Details The Child TD parameters are similar to the Parent TD except the child will not have the option to create a new TD as part of Pay out You can capture the details of child TD that is created by payout through Interest Charges screen by clicking on the Interest button on the Term Deposit screen Interest Charges LS Branch Account Class Account Customer Number Interest Deposit Calculation Account Interest Start Date Interest Booking Account Interest Booking Branch Interest Statement Dr Cr Advices Charge Book Account Charge Booking Branch Charge Start Date Product s EJ
226. the appropriate one Sweep to Account Specify the account to which the sweep is carried out The adjoining option list displays all valid accounts maintained in the sweep to branch You can select the appropriate one Amount Specify the deposit amount Minimum Required Balance Specify the minimum balance required for creation of auto deposit Only the amount above this limit will be used for auto creating deposits Source Code Specify a code assigned for the sweep External Reference Number The system displays the identification number of the transaction in the source system Branch Code The system displays the branch code of the branch where the TD account resides Sequence Number The system generates a sequence number for the instruction you are maintaining and displays it here Currency Code The system displays the TD currency Tet ORACLE Deposit Currency Specify the currency in which the auto deposit should be created The adjoining option list displays all valid currency codes maintained in the sweep to branch You can select the appropriate one Tenor The system displays the default tenor maintained for the linked account class Sweep Multiple of Indicate the number in multiples of which the sweep should be carried out Start Date Indicate the date from which instructions should be valid using the adjoining calendar Retry Till Date Indicate the date post which the instructions will be rendered invalid
227. the truncation system will store this value for sending it to the extract The following accounting entries will be passed Account Debit Credit Savings Account 000777 375500 00 TD Account New 375500 00 Savings Account 000777 15 75 Transaction Tax Payable GL 11000001 15 75 wt ORACLE Case 2 Transaction Description Transaction Tax Remarks Term Deposit Creation Transaction by Savings Account Debit This transaction is exempt from transaction tax as there is same holding pattern order Term Deposit Single Holding Savings Account Single Holding A customer opens a single holder term deposit for an amount of S 300000 by debiting his single holder savings account Since the customer is the holder of both the term deposit and of the savings account then this transaction is exempt from transaction tax Case 3 Transaction Description Transaction Tax Remarks Term Deposit Creation Transaction by Savings Account Debit This transaction is exempt from transaction tax as there is same holding pattern order Term Deposit Joint Holding Savings Account Joint Holding A customer opens a joint holder term deposit for an amount of S 300000 in which the holders are the following e CIF 1 112223334 e Name of holder 1 Juan P rez e CIF 2 223334445 e Name of holder 2 Miguel Tapia In order to create the deposit
228. though the maturity date is falling on holiday i e the maturity date will be a holiday for that deposit e Error The transaction will be failed amp needs to be handled procedurally When there is a change in Next Maturity Date due to holiday treatment interest rate pick up will happen based on the revised tenor for rollover if required However the original tenor deposit opening tenor of the deposit needs to be retained for future rollovers provided the maturity date is not falling on the holiday If the maturity date is falling on a holiday in any of the future roll over then the same holiday treatment is applicable When the deposit gets opened as on date with value date as back dated and rollover also to be done during the period between the value date and the current date For instance e Holiday calendar Deposit Branch Holidays e Holiday Movement Next Working Day e Deposit is opened on 20 Aug 2013 with value date as 20 Aug 2012 for a period of 3months e Auto rollover option is selected as Yes for the same deposit tenor of 3 months im ORACLE gt First Maturity Date is 20 Nov 2012 Working Day gt After rollover next maturity date is 20 Feb 2013 Holiday hence revised maturity date will be 21 Feb 2013 Next working day as per account class gt Next rollover will be for the original tenor 3months from 21 Feb 2013 is 21 May 2013 Working Day gt Next maturity date will be 21 Aug 2013 W
229. ths Specify the installment frequency in terms of months Years Specify the installment frequency in terms of years 4 1 9 Dual Currency Deposit Click Dual Currency Deposit tab on the Deposit Account Booking screen The following tab will be displayed Ter ORACLE Deposit Account Booking Branch Code Customer No Pay In Option Term Deposit Account Customer Name Pay in By Clearing Type Term Deposit Currency Account Class 9 Go tives Rre Cheque Instrument No Cheque Date RAN Drawee Account Number Routing No Main Nominee Deposit Dual Currency Deposit Check List Dual Currency Deposit Linked Currency Currency Option Product Option Contract Reference Exchange Rate Linked Currency Settlement Account Linked Currency GL Fixing Days Yield Enhancement Inception Fair Value Linea Ene Restctons ms Statement Jot ders isi account sianatory Payout etas Endorsement Log Sched event Maker Date Time Mod No Checker Record Status Date Time Authorization Status Specify the following details Dual Currency Deposit You can capture the following details for the deposit Linked Currency This option is defaulted from the account class However you can modify this value Currency Option Product Specify the currency option product from the option list under which the Options Contract has to be create
230. tion End Date Account Type Line of Credit Account Account Details Statement Parameters c Escrow Details Account Code Provisioning Details Dormancy Days Escrow Transfer Applicable Required Account Statement Format Prid F Transaction Code rovisioning Frequency Display IBAN in Advices 9 Transaction Code For Inter Pay Provision Currency 8 Local Reversal Dual Currency Deposit Account Cash Deposit Limit on Trust Account OD Loan Creation Exposure Category Event Class Code Natural Debit Credit Dormancy Parameters Debit Interest Charge Liquidation Initial Funding Applicable Customer Liquidate Using Receivable Event Class Code Status Verify Funds Charge Role To Head Charges Debit Notice d Charge Start Advice Liquidation Days Advice Days Liquidation Mode Free Period Restrictions Brann Currency Restriction Customers Categories mis Preterences REG Deposit Auto Deposit GL Lines Status Rule Block Statement Notice Aacivona Preferences Dormancy Account mask Transaction Tax Maker Date Time Mod No Checker Date Time Record Status Authorization Status Specify the following details Account Class and Description Identify the account class you are setting up with a unique code and a brief description Account Type Select the Deposit from the drop down list In case of deposits type of account the buttons A
231. tion during calculation on Pre Closure of the TD e credits the TD balance to customer payout account and debits from TD account e It calculate the completed tenor of TD e It calculates the interest rates for the amount slab and completed tenor from the rate chart maintenance e It recalculates the interest from TD start date including pre closure period by considering the redemption amount and reduced tenor Then the system debits the customer account with the difference between already liquidated amount and newly calculated amount till the previous period of pre closure e It reverses the accrued amount for the current period e Close the TD The IC rule set up for Pre Closure Differential interest calculation is as follows Frm_No Booked N condition Result on Booked 1 NON DEPOSIT_AMOUNT gt 0 DEPOSIT_AMOUNT MCR BOOKED DAYS 100 YEAR 2 BOOKED DEPOSIT AMOUNT gt 0 DEPOSIT_ AMOUNT MCR DCTENOR 100 YEAR 3 NON DEPOSIT AMOUNT gt 0 FORMULA1 BOOKED AND REDEM 0 OR REDEM 1 AND RVSD RATE 1 4 BOOKED DEPOSIT AMOUNT gt 0 DEPOSIT AMOUNT FORMULA2 ANDREDEM 1AND 1 MCR PCDIFF MCR RESIDUA RVSD RATE 0 L TENOR 100 YEAR DEPOSIT AMOUNT 9 Note the following e system picks the floating rates at the time of booking and rollover only e system does not post any separate accounting entries for Penalty e system does
232. to own bank Savings Account TM ORACLE e Pay out by transfer to Other Bank s Account e out resulting in a new child TD e Pay out by demand draft Note that you can also close a TD by a cash pay out But this option is available only in TD Account Opening by Multimode screen You can specify following pay out details of the deposit Payout Type Indicate the method for settlement of the TD on maturity date Choose one of the following options e Bankers Cheque e Payments e General Ledger e Account e Term Deposit e Demand Draft Percentage Specify the percentage of the amount of redemption by the pay out mode selected Offset Branch The system displays the branch code of the account to which fund is transferred from TD account Offset Account Specify the account number GL to which the fund is transferred to TD account This field will return the branch code if the account is selected and NULL will be returned if GL is selected If Pay out mode is GL then the system will display only GLs and if the Pay In mode is Account then only accounts will be displayed in the option list Narrative Specify the description for the redemption Recurring Deposit Specify the following details ORACLE Auto Payment Take Down Check this box to allow the recurring deposit account to debit the payment account for the payment amount as per the installment frequency Move Maturities to Unclaimed Check this field
233. tory TD Account class level Readjustment Eligible Shipped Days 9 2 ORACLE READJACC Factory 1 to Indicate Re adjustable Accounts 0 otherwise Shipped based on account class readjustment flag TDMATREADJ Factory For Re adjustable Accounts Shipped TD maturity date Ex Rate b w TD CCY to LCY TD Interest Start date Ex Rate b w TD CCY to LCY TD Interest Start date Ex Rate b w TD CCY to LCY DAYS FRMLAST LIQ Factory Days elapsed from last interest liquidation till Shipped current date DAYS FROM START Factory Days elapsed from account start date till current Shipped date TDADDREADJ Factory For Readjustable Accounts Shipped TD CCY to LCY rate on the Next Working Day of maturity date of deposit TD CCY to LCY rate on the maturity date of deposit TD CCY to LCY rate on the maturity date of deposit ADD DAYS Factory SDE which will give the no of additional days if Shipped maturity date was holiday for renewable TDs REDEM AMOUNT Factory New SDE with values Shipped REDEM AMOUNT 20 In case of full redemption this SDE will return 0 REDEM_AMOUNTS3 gt 0 In case of partial redemption the SDE will give the partially redeemed amount SCHD_AMOUNT Factory New SDE with values Shipped SCHD_AMOUNTS 0 In case of normal payouts other thean the schedule payout SCHD_AMOUNTS0 In case of schedule payout the ampunt to be paid out in each schedule will get updated
234. tton and invoke the Formula Wizard screen In this screen you need to maintain the following expression Case Result FORMULA 1 gt 0 FORMULA1 TAX RATE 100 Recurring Deposit Rule Specify the following details On Account Opening Month Check this box On Account Closure Month Check this box SDE Maintain the following SDEs e DAYS e DLY NET BAL M e RD INSTALL DUE ORACLE e RD OVERDUE DAYS e YEAR UDE Maintain the following UDEs e TD 1 e OVERDUE PENALTY e TAX RATE Type For each of the UDEs select the option Rate from the adjoining drop down list Get Latest For each of the UDEs select the option Use Effective from the adjoining drop down list Click Formulas button and invoke the Formulas screen You need to maintain two booked formulae and one tax formula Formula 1 Specify the following details Book Flag Select Booked from the adjoining drop down list Debit Credit Select Credit from the adjoining drop down list Days in a Month Select 30 Days from the adjoining drop down list Days in a Year Select 360 from the adjoining drop down list Accrual Required Check this box Rounding Required Check this box 9 12 ORACLE Click Formula Wizard button and invoke the Formula Wizard screen Specify the following expressions Case Result NET BAL M gt 0 DLY NET BAL M DAYS TD 1 100
235. ty Date Remarks Term Deposit Redemption Pay Out Details Pay Out Type Transaction TAX Exempt Percentage Redemption Amount 7 Account v TD Pay Out Overdue Schedules Input By DOC1 Authorized By Contract Status Authorized Date Time Date Time ot ORACLE You have to specify the following fields for redeeming the TD Redemption Reference Number The system displays the reference number here when you save the redemption This field will be enabled only for the query mode and not for the new transaction Branch Specify the branch where the TD resides The adjoining option list displays all valid branch codes maintained in the system You can select the appropriate one Customer Identification The customer identification CIF of the customer for whom TD needs to be renewed or redeemed is displayed based on the TD account number Term Deposit Account Number Specify the TD Account Number You can also choose the appropriate one from the option list The option list displays the deposit type of accounts maintained in the system o The option list does not display auto deposit type of accounts Account Currency The TD currency is displayed here based on the TD account number Account Description A description of the TD is displayed here based on the TD account number Account Balance The account balance is displayed here based on the TD account number Waive Inte
236. ty advice before the actual maturity Based on this period the maturity notice is generated ahead of the maturity date is ORACLE Holiday Treatment During Account class modification following fields under Holiday Treatment Holiday Calendar or Holiday Movement cannot be modified when active accounts are already there for the account class If an user tries to modify these fields then the following error message will be displayed Field Holiday Calendar of Account Class Deposit Cannot be Modified and Field Holiday Movement of Account Class Deposit Cannot be Modified The maturity dates which are falling on a holiday for TD Opening Rollover as well as for Simulation is adjusted based on following parameters and calculators Holiday Calendar Select one of the following holiday calendar options to arrive at the maturity date e gnore When this option is chosen system will not consider any of the holiday calendars while arriving at the maturity date It means no holiday treatment will be done for the maturity dates which are falling on holiday e Deposit Currency Holidays Only currency holiday table will be taken into account while arriving at the maturity date e Deposit Branch Holidays Only Branch holiday table will be taken into account while arriving at the maturity date e Both Deposit Currency amp Branch Holidays When this option is chosen both currency amp branch holiday table will be taken into account
237. u apply on the account UDE values that you specify for the account subsequently will be taken to be in this currency Waive Interest This box is unchecked by default However you cannot waive interest on a TD Leave this box unchecked Generate UDE Change Advice Check this box to indicate that interest rate change advice has to be generated for the account at EOD The system generates interest rate change advices for accounts when the interest rate changes as part of EOD For those accounts when interest rate changes the details are handed off for rate change advice generation and the same is generated in the pre determined SWIFT format as per MT 935 The advice tag used for interest rate change is RTCHG ADVICE The advice format for interest rate change as per MT935 is given below Status Tag Field Name Content Options No M 20 Transaction Reference Number 16x 1 23 Further Identification 16x 2 25 Account Identification 35x 3 M 30 Effective Date of New Rate 6 n 4 M 37H New Interest Rate 1 a12d 5 O 72 Sender to Receiver Information 6 35x 6 ve ORACLE Status Tag Field Name Content Options No M Mandatory O Optional Open You can temporarily stop applying an IC product on a TD by un checking this box The product will cease to be applied on the term deposit You can make the product applicable again by checking this box Effect
238. unt This will show interest amount on the maturity date Maturity Amount This will show the sum of Deposit amount and Total Interest Payable as computed in the above column Branch This indicates the Branch name Product Code This indicates the Account Class code of the TD account Product Title This indicates the Account Class description of the TD account Product Currency This indicates the Currency of the TD account class Currency Total This indicates the Currency wise total for deposit amount Interest Payable and Maturity Amount Close on Maturity This will show whether TD will be closed on maturity Auto Rollover This will show whether TD will be automatically rolled over 11 13 ORACLE 11 10Term Deposits Closed for the Period Report This report list the term deposit accounts which are closed for the given period and that are currently on open status You can generate this report using TD Account Closed Report screen by typing TDRCLOSE in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button From Date To Date Branch Account Class Customer Specify the following details here From Date Enter the TD accounts which are closed from this date However by default the system displays the current application date To Date Enter the TD accounts which are closed till this date However by def
239. unt blocks and closure of the same for TD accounts You can maintain the amount blocks using Amount Block Input screen To invoke this screen type STDAMBLK in the field at the top right corner of the Application tool bar and click the adjoining arrow button TD Amount Block Input TD Account Block Details Branch Amount Block Number Account Effective Date Amount Expiry Date Amount Block Type Reference Number Hold Code Hold Description Remarks Maker Date Time Mod No Checker Date Time Record Status Authorization Status You can specify the following details Branch The system displays the branch code Account Specify the TD account details Amount Specify the amount details d ORACLE 5 18 Amount Block Type Select the type of amount block from the drop down list Following are the options available in the drop down list e FLEXCUBE e Switch e PreAuth e Escrow e System e CASA e Bulk Salary e Discounted TD Hold Code Specify the hold code Amount Block Number The system displays the amount block number Effective Date Specify the effective date This cannot be a date in the past Expiry Date Specify the expiry date This cannot be later than the maturity date of the TD Reference Number Specify the reference number Hold Description The system displays the description for the hold code specified Remarks Specify remarks if any Viewing TD Summary You can view a summary of all
240. unt factor that returns the discounted maturity amount upon pre closure 3 9 1 Maintaining Parameters for Premature Withdrawal of TD Oracle FLEXCUBE allows you to capture current TD balance amount using the SDE DEPOSIT AMOUNT which will consider TD amount sum of partial redemption amount You need to maintain the parameters by capturing the Interest rates on the basis of tenor minimum amount currency and effective date for a TD Based on these parameters the system picks the corresponding rate during Normal Maturity Pre Closure and Partial Redemption of TD Oracle FLEXCUBE also provides additional spread rate maintenance in addition to interest rate for TD based on the parameters maintained which is added to the derived interest rate from the rate chart maintenance and used for Interest calculation 3 9 1 1 Calculating Interest Rate during Normal Maturity of a TD Oracle FLEXCUBE performs calculation of Interest Rate during normal Maturity of a TD During interest liquidation on maturity for TDs the system derives the interest rate from the rate maintenance in LD MM Floating Rate Input screen based on tenor minimum amount currency and effective date for a TD 3 9 1 2 Calculating Interest Rate during Partial redemption of a TD Oracle FLEXCUBE performs calculation on partial redemption of the TD On partial redemption the system performs the following actions It credits the redemption amount to customer payout account and d
241. us Due Date The system displays due date of the installment Installment Amount The system displays installment amount Payment Date Specify payment date for the RD Normally the payment date is the same as the transaction date Due Days The system displays overdue days in case payment is overdue ie ORACLE 7 2 4 Viewing Accounting Entries Click Events button in the Recurring Deposits Payment Input screen and view accounting entries 7 2 2 Specifying UDF Values All User Defined Fields UDFs linked to the function ID ICDPMNTS are displayed the User Defined Fields screen Invoke this screen by clicking Fields button on the Recurring Deposit Payment Input screen User Defined Fields User Defined Fields T Field Name Value Here you can specify values for each UDF Refer the User Manual titled User Defined Field for details about defining UDFs Click Fields button on the TD Accounts Maintenance screen and invoke the User Defined Fields screen 7 3 Viewing Payment Summary You can view summary of all RD payments using the Recurring Deposit Payment Summary screen To invoke this screen type ICSPMNTS in the field at the top right corner of the Application tool bar and click the adjoining arrow button is ORACLE LZ Recurring Deposit Payment Summary
242. ustomer account However you can change it Interest Booking Account You can select the account for booking interests on transaction processed at your bank At the time of creating an IC product if you have maintained the booking account type as Interest in the Interest and Charges Product Definition screen the Interest will be liquidated into the Interest Booking account By default the customer s account in the current branch will be displayed in this screen in the Interest Booking Account field However you have the option of booking interest to a different account belonging to another branch also The accounts maintained in the selected Booking Branch will be available in the adjoining option list You can select the appropriate account Interest will then be liquidated into the selected account If the TD is of Demat type and the custody status is selected as With Third Party then the interest booking account should be a GL Charge Booking Account You can select the account for booking charges on transactions processed at your bank At the time of creating an IC product if you have maintained the booking account type as Charge in the Interest and Charges Product Definition screen the charge will be liquidated into the Charge Booking account By default the customer s account in the current branch will be displayed in this screen in the Charge Booking Account field However you ha
243. ve Dates if the values of UDEs vary within the same liquidation period UDE ID Specify the UDE ID for the account UDE Value Specify the values for a UDE for different effective dates for an account When interest is calculated on a particular day for an account with special conditions applicable the value of the UDE corresponding to the date will be picked up Rate Code Specify the rate code for the account 5 11 6 Deposit Tab Deposit Preferences for Child TD Click Deposit tab to capture deposit related details of the child TD if you have opted for creation of a child TD on maturity of the parent TD The system defaults all the parameters maintained for the parent TD in this screen However you can modify them VD ORACLE Term Deposit Interest Account Details Interest Deposit Maturity Date Next Maturity Date Deposit Tenor Auto Rollover Rollover Type Principal Close on Maturity Principal Interest Move Interest to Unclaimed Special Amount Move Principal to Interest Unclaimed Rollover Amount Term Deposit Payout Details 10f1 CNET You need to capture the following details here Maturity Date The system defaults the maturity date from the default tenor from the account class However you can modify this date On this date the term deposit account gets Auto Rollover Check this field to automatically rollover the deposit you are maintaining You hav
244. ve the option of booking charge to a different account belonging to another branch also The accounts maintained in the selected Booking Branch will be available in the adjoining option list You can select the appropriate account Charges will then be liquidated into the selected account Interest Statement Check this box to indicate that you would like to generate an interest statement for the account The Interest Statement will furnish the values of the SDEs and UDEs and the interest rule that applies on the account s ORACLE Interest Start Date Specify the date from which the interest accruals of TD account begins You can specify the date as of booking the TD or any date in the future If you specify a date in future the system will post entries for account opening DEBK event on the account opening date with the value date as interest start date It will start interest accrual calculation on the date specified in this field and post entries for IACR event Charge Start Date For the account for which you are defining special conditions you must specify the date from which you would like to apply charges Charges for this account will be calculated according to the special conditions that you define subsequently By default charges on an account would be applied when the free banking period if any elapses This means that the Charge Start Date is arrived at by the System by adding the Free Banking Period days if any specified
245. want to link to the account You can link a customer signatory to an account either by e Click on the option list next to the Signatory Number A list of customer signatory numbers whose details have been captured will be displayed along with their names Pick up the signatory whom you want to make an account signatory for the account e Keying in the customer Signatory Number and Name directly if the signatory number has not been maintained through the Customer Signatory details screen ios ORACLE If the signatory ID that you specify has not been maintained the System displays an override On confirming the override you will be allowed to save the signatory details An error message is displayed if you enter a duplicate Signatory ID Each time you capture a new Signatory ID at the account level you must identify the relationship of the signatory with the customer On endorsing to a new customer you need to change the customer signature details of the old customer Otherwise the system will display an error message Minimum Number of Signatories Specify the minimum number of signatories necessary to endorse an instrument involving the account Customer Name The system displays the name of the corresponding customer Account Message You can capture information about particular signatories These messages could pertain to the name number and the type of signatory your customer is For instance you can capture a message like Th
246. ystem displays the periodic rate according to TD tenor and days in a year basis Click Compute button to re calculate the periodic rate whenever the UDE values are modified The periodic rate will be calculated using the expression Interest Rate xTD tenor Basis of IC Rule Days in a year Where Interest Rate is UDE value rate picked for the UDE linked to TD rate code TD Tenor is the tenor of the TD as per Days in a Year basis selected for Formula 1 The days in a year basis will be value corresponding to formula 1 credit interest booking formula for YEAR SDE Note Bank should maintain same Days in a year for all formulae of the same IC rule attached to the IC product Example Interest rate 5 4 p a TD tenor 90 days IC Days in a year 360 Periodic Rate 5 4 90 360 Es ORACLE 1 35 Note The periodic rate will always be rounded to 5 decimal points Product Details Specify the following details Product Code Specify an interest product in order to allow calculation of interest When you apply an interest product on the account interest for the account will be calculated according to the interest rule attached to the product A TD can be linked to two products only one interest type of product and one charge type of product The system will not allow you to maintain more products for a single TD UDE Currency Specify the UDE currency for the product that yo

Term Deposit User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents