Home
Utility Payments User Manual
Contents
1. 7 1 Function ID List 7 Screen Glossary 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 CGDQUERY Clearing Transaction Query IFDATMMN ARC Maintenance UPDAUINS Utility Bill Instruction Capture UPDBILDT Utility Bill Details UPDCOLLS Collection Details UPSCOLLS Collection Details Summary UPDPRDMN Utility Payment Product Definition UPDQUERY Bill Payment Query UPDTPMNT Utility Provider Type Maintenance UPSCAGMT Collection Agreement Summary ORACLE ORACLE Utility Payments 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 Acquis
2. Product serieei r Ee EA E se Ee EO NE ER 3 6 3 4 4 Specifying Accounts Details RE EE ENE 3 7 3 4 5 Specifying Charge Details Es Ee tensed Ga GO eg oe Ee De ER Ee ge Re enge ED E ER Vee ER 3 7 4 ACCOUNTS DETAILS AND CHARGES sesssssdsesssss dese ee ss seed ee Gee sd Ge se ee des see dese ede ee de ee ee dee oe Geo Ee de de ede 4 1 4 1 MAINTAINING ACCOUNTS DETAILS AND CHARGES UTILITY Ppopucrg ee ee ee ee ee ee ee ee ee ee ee 4 1 4 1 1 ARC M intenance See sesse se n n a a a E 4 2 4 1 2 Specifying Reject Details siine EE EE EE E basen EOT EEEE EE N N 4 9 5 PROCESSING BILL PAYMENTS ssiasssssssessessssscncsssccsssesssssvassessesscocssesseesssosessssabicesassesscosssssssasssecessasabesesesse 5 1 5 1 MAKING BILE PAYMENTS cies oa aE N 5 1 5 2 MAINTAINING UTILITY PROVIDER TYPE ccccecesssscececececseeeeceeececeeseeaeseeececsensaassecececeeseaeseseecesessasaeseeees 5 1 5 2 1 Specifying User Defined Fields 5 2 5 3 MAINTAINING BILL PARAMETERS see ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee Re Re ee ee ee RR Re ee ee ee RR Re ee ee ee Re Re ee 5 3 3 3 1 Specifying User Defined Fields 5 4 5 4 MAINTAINING BILL INSTRUCTIONS ssosseenensesseseneeeessesesteresssssreostressrrrneesssseseoersesssssrrostsssserrstestssesererseseesone 5 5 5 4 1 VIEWING Execution LOS EE EE OE EE eian iieii n ennei n ii E Ea s 5 8 5 4 2 Specifying User Defined Fields sisie eeste is ses Se ie ee ds Ge oos sege deeg inia a ri E 5 9 5 5 MAINTAINING PRODUCTS FOR U
3. These account details and charges are defined in the ARC Maintenance screen for a product and a specific Institution ID the ID of the utility provider and would apply to all customers that make payments to the specific utility provider The definition of accounts details and charges ARC is explained in the chapter Accounts Details and Charges in this user manual Specifying Clearing Cheque Details For bill payments that are being made through a single cheque or multiple cheques you must provide the details of the cheque instruments as well as the clearing details ai ORACLE You can invoke the Clearing Transaction Query screen by typing CGDQUERY in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Clearing Transaction Input Detail Branch Product Code Direction Reference Number Remitter Details Customer Account Country Instrument Details Draft Serial Number Instrument Routing Number Bank Code Branch Code Sector Code Instrument Type Date Details Transaction Date Instrument Date Bank Value Date Customer Value Date Reg CC Detail Remarks MT110 Reconcilation Detail Status Reference Number Late Clearing C Consider For Reg CC CO Special Avail el Entry Number End Point External Reference Beneficiary D
4. The options available are e No matching e Recon by Amount e Recon by bills e Recon by amount and bills Readjustment Check this option to specify the readjustment in bills This is applicable only in case of Local Currency Bills The calculation is based on change in the index currency value from the due date to the payment date If the readjustment is negative i e if the index currency rate goes down the due amount is collected Consolidation Reqd Check this option to denote if consolidation is required This is used to move the funds from the internal account to the customer s credit account If this is checked then consolidated amount will be transferred else Amount will be transferred contract wise For the bank s customer consolidation happens online by the consolidation batch process For a non bank customer consolidation happens at EOD as part of the Utility Payments batch process Consolidation Product Select the utility payment product from the option list if you have checked the consolidation required option Collection Coverage Select the collection coverage from the adjoining drop down list This list displays the following value e By Branch e By City e By Region Operation Instruction 1 Specify the message to be displayed in the transaction screen when the teller chooses the transaction Operation Instruction 2 Specify the message to be displayed in the transaction screen when the teller cho
5. bill issued by the utility provider against which the customer is making payment e Bill number e Bill Issue Date e Bill Currency e Bill Amount 5 15 ORACLE e Exchange Rate Details e Account Details 5 8 Viewing Transaction Details You can view the following transaction details e Offset Account Details e Charge Details e Net Paid Amount e Service ID e External Reference Number e Narrative 5 9 Executing Bill Payment Batch You can have all bill payments executed through a batch process For this you need to maintain the function ID UPBAUINS as a mandatory batch program using the Mandatory Batch Program Maintenance screen Mandatory Batch Program Maintenance Branch 000 Function identification UPBAUINS az Module UP Sequence Number Description e End Of Cycle Group G Transaction Input Error Handling Stop Automatic End Of Day End Of Transaction input and Run Emergency Program Continue with Automatic End End Of Financial input Of Day End Of Day Beginning Of Day Frequency Daiy 7 Number Of Days Holiday Rule Dont Execute 7 Run Date Execution Layer Database Job Code C Application Description Predecessors I Predecessors mi Input By DOCS Date Time Modification Number E Authorized Authorized By Date Time fv Open Sg ORACLE For further details about this screen refer the chapter Setting up Manda
6. customers you must specify basic details such as the Product Code Group Description and so on in the UP Product Definition screen You can invoke this screen by typing UPDPRDMN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button gt Utility Payment Product Definition Product Code Product Description Product Type Description Slogan Exchange Rate Variancelin Override Limit Stop Limit Rate Code Rate Type Preferred Product Group Product Group Description Start Date End Date Remarks Mod No Record Status Authorization Status Date Time Date Time Maker Checker In this screen you can only set up a basic profile for the product You cannot associate any account details or charge details for a specific utility provider To maintain these details for a specific utility provider for a specific product you must use the Accounting Rates and Charges Maintenance ARC screen Refer to the chapter Accounts Details and Charges in this user manual for information about the ARC Maintenance screen Features of Utility Payment Product Definition Main Screen You must specify the following details for a utility product in the UP Product Definition main screen e An identifier or code for the product which is unique to it e Aconcise description of the product e A slogan for the product 3 4 ORACLE e The group under which the pro
7. displayed here Regenerate Coupons Check this box to indicate that the coupons have to be regenerated 6 3 1 6 4 6 4 1 Viewing Collection Details Summary You can query for and view Collection transactions in the Collection Details Summary screen You can invoke the above screen by also entering UPSCOLLS in the field at the top right corner of the Application Toolbar and then clicking the adjoining arrow button Collection Details Summary Authorization Status z Record Status z Source Code EE File Name Due date PS Record No ad Aa Advanced Search Reset Records per page 15 vj 14 411 Of 1 il H Double click on a transaction to view the details Transaction Processing The transaction processing details are explained below Validation of Collection Details If at the agreement level data verification is checked then the transaction details are validated against the collection details In case the verification option is not checked then data is not validated Oracle FLEXCUBE does not verify the data against the company database directly In case the transaction is from an external source say internet then the external source has to validate the transaction details and transfer it 6 4 2 Additional Data Validation 6 4 3 6 4 4 The additional da
8. necessarily capture the rate that is to be applied on the transaction amount The rate that you specify will be applied after converting the amount into the Account Currency Minimum and Maximum Charge Amount When the charge type applicable on the transaction is a percentage of the transaction amount you have to capture the minimum and maximum charge amounts that should be applied on the transaction ZS ORACLE If the charge percentage involving a particular transaction is less than the minimum charge the system will by default debit the customer account with the minimum charge amount Similarly when the charge percentage exceeds the maximum amount the system will debit the customer account with the maximum charge amount The charge amount will be deducted in the currency that you specified earlier MIS Head Specify the MIS Head that is applicable for the charge related accounting entry Description You can indicate a short description for the charge Specifying Reject Details To specify the reject account details click on the Preferences button in the ARC Maintenance screen ARC Maintenance Preterence Bank Code Local Float Days Txn Offset Accounting Entry Required Reject Details Reject Account Reject Branch Reject Currency In this screen you can specify the following details Bank Code Specify the bank code of the remitter for the arc resolution Txn Offset Accounting Entry Required Check this b
9. the institution in whose favor a customer makes payments and on whose behalf your bank has agreed to accept and process such customer payments In Oracle FLEXCUBE a transaction is entered into the system against a product For instance a payment made by a customer towards electricity charges could be entered into the system against a product defined for processing electricity charges payments with accounting details rates and charges defined specifically for the utility provider that is the recipient of the payment When Oracle FLEXCUBE processes the transaction it will apply all the attributes and specifications made for the product against which the transaction was entered You can enter more than one payment transaction in favor of a utility provider against a product that has been created specifically for the utility provider Products for Utility Payment Transactions When you define products for processing payment transactions of customers you need to e Define an unique product for each type of utility payment transaction that your bank would process for customers Example In your bank you have offered customers the service of processing the following types of utility payments to the appropriate utility providers e Water Charges e Electricity Charges e Credit Card Statement Payments e Telephone Charges To process each type of utility payment you can define a utility product Therefore you could create the followi
10. 4 Specifying Accounts Details To recall you maintain a utility payments product to process a specific kind of utility payment made by customers In order to configure a product to process a specific type of payment made by customers in favor of a specific utility provider you also need to specify the details of the accounts or GL s to which accounting entries need to be posted for any payment transaction for the utility provider You specify these accounts details in the ARC Maintenance screen for each specific utility provider You also map the appropriate product to these details When you do so the product accounting details combination can then be used to process only all those payments made by customers to the specific utility provider to whom the accounts details are applicable To use the same product to process specific payments made by customers in favor of a different utility provider you will need to set up another set of accounting details that are specific to the utility provider in the ARC Maintenance screen and associate these details with the product Invoke the ARC Maintenance screen from the Application Browser For a full discussion of this screen refer the chapter Accounts Details and Charges in this user manual 3 4 5 Specifying Charge Details When you process utility payments made by customers your bank may need to levy certain service charges for each utility provider You can specify these charges s
11. Code ALL Customer All Customers v CustomerNo ALL 2011 12 01 Consolidation of funds is supported only for those Agreements in which the consolidation option is selected in the Agreement For the bank s customer consolidation will happen online by running the consolidation batch For a non bank customer consolidation will happen on EOD as part of UP batch 6 5 1 Specifying Consolidation Options You can select any of the following options for consolidation of collection amounts 6 5 1 1 Based on Bank s Branches You can select one of the two options provided All branches Selecting this indicates that the consolidation of collection is to be done based on all branches of the bank Single Branch Selecting this indicates that the consolidation of collection is to be done based on a single branch of the bank Branch When you select Single Branch for consolidation select the branch from the option list 6 5 1 2 Based on Bank s Customers 6 6 All Customers Selecting this indicates that the consolidation of collection is to be done based on all customers of the bank Single Customer Selecting this indicates that the consolidation of collection is to be done based on a single customer of the bank Customer No When you select Single Customer for consolidation select the customer number from the option list Collection consolidation is done in the product mentioned in the agreeme
12. Each product in Oracle FLEXCUBE is identified with a unique four character alphanumeric code You can indicate the appropriate utility product Similarly if you are maintaining the ARC details for an Account Class you can identify the appropriate Account Class from the existing list of account classes Example In our example of Mr Philip Smythe s credit card statement payments to Global Credit Solutions Limited you can indicate CCUP as the product for which you are maintaining ARC details in this screen This is the product that you have defined for the purpose of processing credit card statement payments for customers Currency You must indicate the currency in which the utility provider would accept utility payments made in favor of the utility provider involving the selected utility product Example In our example since Global Credit Solutions accepts credit card payments made in favor of them in USD you must indicate USD as the Currency Code in this screen For each currency in which the utility provider accepts utility payments made in favor of the utility provider you must maintain a separate set of ARC details in this screen For instance in our example if Global Credit Solutions Limited also proposes to receive utility payments into their GBP account in your bank you need to maintain a separate set of ARC details in this screen for the product CCUP Currency Code GBP and the receiving institution Global Credit Solutions L
13. Netting MIS Head Slab Type Interest Basis Their Charge Input By Authorized By Modification Authorized Date Time Date Time Number Open If you are maintaining ARC details for a utility product and a specific utility provider or institution the ARC details maintained in this screen will be used for posting entries for the utility product Institution ID and currency code combination The institution ID is the identification of the utility provider that will be the recipient of the utility payment being made by customers You must maintain ARC details for each specific utility provider for whom you process customer payments made in favor of the utility provider A unique single set of ARC details must be maintained for each utility provider You can however associate a utility product with many different ARC details sets Therefore you can use a particular utility product to process payments made in favor of any utility provider but you must maintain distinct ARC details for each individual utility provider Since the ARC related detail are maintained at the Head Office of your bank the details that you specify in this screen will be made applicable to all the branches of your bank 4 3 ORACLE Account Class Product While maintaining the ARC details for a utility provider you have to indicate the particular product that would be used to process payments made by customers in favor of the utility provider from the available list
14. TILITY BILL BAYMENTg 5 9 5 5 1 Specifying Clearing Cheque Details 5 10 5 5 2 Viewing Accounting Entries and OVerrides i s esse ese se se se Ge Ge Rd ee ee ee ee ee ee Se ee 5 13 5 6 VIEWING UTILITY PAYMENT TRANSACTION sssssnnsnsseseseneoeessseeserresseseseestresserroerssssesesersesssssrreeesssserrseenesee 5 15 5 7 VIEWING BILL DETAILS ese ese ee see se n ee ee ee GR RR ee ee ee GR Re ee ee Ee Re Re ee RR Re ee ee ee Re Re ee ee Re Re ee 5 15 5 8 VIEWING TRANSACTION DETAILS 5 16 5 9 EXECUTING BILL PAYMENT BATCH iese sesse esse se se ee ee ee ee ee ee ee ge ee ee ee ee ee ee ee ee ee ee Re ee ee ee ER Re Re ee ee ee Re Re ee 5 16 CDS EIER SC NIK AEN EE 6 1 6 1 INTRODUCTION ee EE ROER RE EE RE OE EEN 6 1 6 1 1 Customer and Payments Maintenance iese se se Se GR ee GR Re ee Re Ge RR ee ee RR ee ee Re ee ee 6 1 6 1 2 Service Provider Agreement Maintenance iese se ee Se SA Ge ee Ge ee ee ee Ge ee ee 6 1 ORACLE 6 1 3 Maintaining Customer Address Information ee ee ee ee Ge ee ee ee ee Se ee Gee 6 10 6 1 4 Collection by External Agenten 6 11 6 1 5 Specifying Charges for Subscribere iese ees sees se ese ee ee ee Ge Se Ge GR GRA Gee Ge Gee ee Ge ee ee ee ee 6 12 6 1 6 Specifying Charges for Service Provider 6 12 6 1 7 Specifying User Defined Fields 6 13 6 1 8 Viewing Collection Agreement SUMMATY iese ese ee ee Se SA RA RA Ge ee be ee ee ee ee Ge Gee 6 13 6 2 CHANGING COLLECTION STATUS ivsessesccoseseovsvenserevsesv
15. The Core Services User Manual e The Core Entities User Manual e The Procedures User Manual 1 5 Glossary of Icons Icons Function New n Copy Save pd Delete ir Unlock ea Print Close Lei Re open D Reverse R Template A Roll over M Hold E Authorize Liquidate Exit Sign off g Help Al Add row Delete row 1 2 ORACLE 2 1 2 Overview Introduction The Payments Utility Interface module enables your bank to process payments made by customers towards services and utilities provided by specific utility providers Customers may need to make these payments from any branch of your bank to any other branch of your bank For each kind of payment you can define a product in the UP Product Definition screen You can make the use of the product specific to payments made to a specific utility provider for a particular utility payment and a particular payment currency by defining ARC details in the ARC Maintenance screen You can capture details of each payment of a customer against a bill in the Bill Payments by Account Check or Cash screens depending upon the mode of payment Features The Payment Utility Interface module enables you to process utility payments made by customers by providing the following features e Flexible definitions of accounting entries and events involving payments e Definition of cha
16. The available values are e Daily e Monthly e Yearly Example Here consider that the customer pays with delay CLP 10 debt due date 15 December 2004 Payment day 5 Jan 2005 Interest rate 0 2 monthly Interests CLP 10 0 002 20 30 CLP 0 0133 So the amount to be paid CLP 10 CLP 0 0133 CLP 10 0133 6 1 2 2 Specifying Draft Details This information can be specified in case of non bank customers Gen Days Specify the number of days after the funds are cleared when a demand draft needs to be generated for service providers not associated with the bank Inst Type Select the instrument type for demand draft generation 6 1 2 3 Specifying Channels This information must be specified before crediting the amount to the service provider s account Channel Select the channel of payment from the drop down list Settlement Mode Select the settlement mode from the drop down list Retention Days Specify the number of days for retention This is the number of days which the bank will hold the cleared funds before crediting it to the company This is maintained per channel per settlement mode 6 1 2 4 Specifying Data Verification Details This information has to be specified if the Data Verification option is checked Field Name Select the fields that have to be verified against the collection file from the option list Data Verification Check this in order to specify verification of fields for the transacti
17. Utility Payments Oracle FLEXCUBE Universal Banking Release 11 3 83 02 0 April 2014 Oracle Part Number E53607 01 ORACLE FINANCIAL SERVICES Utility Payments Table of Contents 1 ABOUT THIS MANOA Livssissscssssssscssssssivccescssvscescsssessisossacoscsseccosccsssssscscnesoustoscebesisscebaesesseesssessiesivecescssuscusoess 1 1 1 1 INTRODUCTION EE es Ee EE DE Ee RE De ee Ee be Re ee ER DE ee EE oe ee ee oe GE ee Ee EE ed is 1 1 1 2 AUDIENCES EE Ie GE ee EE Ie E EE 1 1 1 3 ORGANIZATION e ie RE Ee oe Se EE Ee De RE ee aR Ge BE 1 1 1 4 RELATED DOCUMENTS scce tisse ei streer eaae E e EErEE EAEE E EEEE EEE EEE Dae EREN 1 2 1 5 GLOSSARY OF ICONS corinae N EE EE EE E EA E OE R EE 1 2 Zi e ON ATA DE EE T S E E EE E E E T T 2 1 2 1 vat oie 8 od OAR EE EE EE EN 2 1 2 1 1 VAa OE EE ee eee 2 1 3 DEFINING PRODUCTS FOR UTILITY PAYMENTS ccsssscssssscccsssscccsssscccssssccsessseccsesscceesssscscesenee 3 1 3 1 INTRODUCTION EE EE EE ER EE OE OE OE FEE 3 1 3 1 1 Advantage of Defining Product SE OE EE ER SE 3 1 3 1 2 Attributes Of SEA AR ER OR RE OR eee 3 1 3 2 PAYMENT TRANSACTIONS cine aE SE Eed E E EE Ge ed Ee ee Ge A E E EE EEN 3 2 3 3 PRODUCTS FOR UTILITY PAYMENT IRANSACTIONS 3 2 3 4 CREATING PRODUCTS FOR UTILITY PAYMENT IRANSACTIONS 3 4 3 4 1 Features of Utility Payment Product Definition Main Screen 3 4 3 4 2 Defining Other Attributes of Utility Payment Producte Se SR SA Ge Gee Gee ee se ee 3 6 3 4 3 Saving Utility Payments
18. account and clearing Dr Settlement account Depends on the settlement mode maintenance Cr Internal Account of the Customer maintained in the agreement For Account transfer 6 4 5 6 4 6 6 4 7 6 5 Dr Subscriber a c given in the transaction screen Cr Internal Account of the Customer maintained in the agreement For Cash Dr GL at the utility payment product level Cr Internal Account of the Customer maintained in the agreement Coupon Printing The service provider sends a file with details of payments by the customer for the next one year The interface transfers this information to Oracle FLEXCUBE for the coupon printing Oracle FLEXCUBE then generates the advice in the format maintained and displays the appropriate messaging table The interface also generates the output file for the coupons If the collection details are modified and the option Regenerate Coupons is checked in the Collection Details Screen then during EOD Oracle FLEXCUBE generates the advice and stores it internally The interface generates the file again Payment Advice Generation The collection files generated by the interface are sent to Oracle FLEXCUBE This information is displayed in the advice tables for the payment advice Collection Status Update The collection information in the collection details file has the following statuses e Active When the bank receives the collection file all the transaction have the status as Act
19. ained using the Collection Services Details Screen To invoke the screen type UPDCOLLS in the field at the top right corner of the Application browser and click the adjoining arrow button Collection Details RA Source Code E File Name SP Agreement Id ES Record No Due date K Currency ES Service Provider Id Bill No Amount T Regent Coupons Subscriber No Status Active ja Fields Maker Date Time Checker Date Time Here you can modify details pertaining to the transaction You can also enter the details of a new record To do this click new button on the toolbar Source Code Specify the source of upload for the collection services SP Agreement ID Specify the id of the agreement that the service provider holds with the bank Due Date Specify the due date of the collection Service Provider ID Specify the service provider id Amount Specify the amount to be collected from the customer Subscriber Number Specify the subscriber number Status Specify the status of processing of the transaction The options available in the drop down list are e Active e Paid e Expired e Paid by External Sources e Overdue e Sent File Name Specify the name of the collection file Record Number Specify the record number here Currency Specify the currency of the amount payable by the customer Bill Number The bill number is
20. ber DriCr Amount Tag Currency Foreign Currency A mj Any overrides that occurred when each entry was passed are also displayed ma ORACLE 5 6 5 7 Viewing Utility Payment Transaction You can view the bill payment transaction in the Bill Payment Query screen You can invoke this screen by typing UPDQUERY in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Payment Details Reference Number Institution Id Bill Detail Bill Number Bill Issue Date Bill Amount Bill Currency Consumer Number Rate Code Currency Product Code Transaction Currency Transaction Detail Offset Account Number Offset Account Branch Transaction Date e 2 External Reference Account Number Account Currency Service Id EES Input By Date Time Net Paid Transaction Tanked Narrative el Contract Status Authorized Rate code type Buy O Mid O Sell In this screen you can view the following details for each payment transaction e Reference Number e Institution Identification e Product Code e Transaction Currency e Tanked Transaction For more information on Tanked Transaction refer Branch Parameters chapter under Core Services module Viewing Bill Details You can view the details of the
21. ccounts for a payments transaction would presumably be different for each utility provider e The utility provider or the institution that would be the recipient for any payments of the type for which you have defined the product made by customers e The currency in which payments would be accepted e The details of any charges that your bank would need to collect or levy for the service of processing the utility payment These details could again be specific to each utility provider Example Global Credit Solutions Limited a credit company who have an USD account in your bank have designated your bank as authorized to accept credit card statement payments of their clients and credit the payments to their USD accounts One of your customers Mr Philip Smythe makes credit card statement payments to Global Credit Solutions through your bank He has an USD account in your bank through which he makes the payments You have maintained a product CCUP for processing credit card statement payments of customers You can use this product to process any credit card statement payments made by customers such as Mr Philip Smythe in favor of Global Credit Solutions Limited To do so you need to e Specify the ID of Global Credit Solutions Limited as the receiving institution for any credit card payments made by any customers such as Mr Philip Smythe e Associate Global Credit Solutions Limited s USD account in your bank with the produc
22. dit Solutions Limited with the product CCUP as the debit and credit accounts respectively e Define any charges that your bank would levy for the service of processing credit card statement payments and associate these with the product CCUP A product that you define for processing utility payments of a specific type to which you have attached any accounting details rates and charges applicable to a specific utility provider cannot be used to process payment transactions for any other utility provider Example The following utility providers PowerCorp Limited have designated your bank as authorized to receive utility service payments made by customers towards them and credit the same into their account with your bank e PowerCorp Limited electricity providers e Springwell Water Resources water supply providers e Communications Global telephone service providers Mr Alfred Werker a customer of your bank makes payments for electricity charges water charges and telephone charges to these institutions through your bank You have already defined three products WCUP ECUP and TCUP see example above for each type of payment The charges that you levy for processing each kind of payment could be different for each utility provider Also the accounts that would be impacted and the currencies involved would be different for each of the payments For instance the account that would be impacted when Mr Werker makes an elec
23. duct is classified e The life span of the product e Any narrative regarding the product remarks e The limits with regard to exchange rate variance that would apply to any transactions involving the product Product Code The product code is a unique identifier for the product in the system across all modules You can specify a code consisting of four characters You cannot use the code that you specify here for any other product in the system in any module If for instance you have specified PWBL as the product code for a utility product in this screen you cannot specify the same code for any other product in any other module in the system For any utility product you must specify a code Specify an indicative code for instance in our example of Mr Philip Smythe s credit card statement payments you could define CCUP as the product code for a product used to process credit card payments Product Type The product type indicates the category under which the product can be placed and the type of transaction that will be processed against the product A utility payments product can only be used to process utility payments made by customers in favor of a particular utility provider Product Description Give a brief description of the product This description can be used to easily locate and retrieve information regarding the product For any utility product you must specify a description Specify an indicative description for ins
24. e 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 services 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
25. e a recipient of utility payments you must maintain a separate set of ARC details in this screen For instance in our example if Mr Smythe also makes credit card payments to a different receiving institution utility provider say Central Bank in GBP you need to maintain a separate set of ARC details in this screen for the product CCUP Currency Code GBP and the receiving institution Central Bank combination 4 1 1 3 Identifying Offset Details You can specify the Branch and the offset account or GL into which offset entries are to be booked This will be the account that would be credited with the payment Typically this is the account held by the utility provider in your bank Example The receiving institution in the case of Mr Smythe s credit card payments is Global Credit Solutions Limited It is their account or specific GL with your bank that would be credited when Mr Smythe makes a payment against a credit card statement Therefore you must select the number of their account with your bank as the offset account If the receiving institution or utility provider has different accounts in your bank in different currencies and proposes to receive payments in any of those currencies you must maintain a distinct set of ARC details in this screen for each of the accounts 4 1 1 4 Identifying Transaction Details For walk in customers who do not hold accounts in your bank and who are making cash payments to the selected u
26. e retry definition Payment Mode Select the payment mode from the adjoining drop down list It can be any one of the following e Full e Partial If you select Full then the entire bill amount will be considered paid else only the amount specified in the Payment Amount field will be considered paid Payment Currency Specify the currency in which payment has to be made The adjoining option list displays all valid currency codes maintained in the system You can select the appropriate one Payment Amount In case of a partial payment specify the amount that should be paid ORACLE 5 4 1 Debit Branch Specify the branch where the debit account resides The adjoining option list displays all valid branch codes maintained in the system You can select the appropriate one Debit Account Specify the account that should be debited for making the bill payment The adjoining option list displays all accounts maintained in the debit branch in the system for the customer ID You can select the appropriate one Viewing Execution Log Click Execution Log button and invoke the Execution Log Details screen Execution Log Details Instruction Reference Customer ld Execution Date Detail Utility Provider Id D IK 10f1 TIETIES Debit Branch Debit Account Payment Currency Actual Bill Amount Execution Retry Detail DO 10f1 Here you can view the following details Inst
27. e the recipients of the bill payment Example One of your customers Mr Philip Smythe makes credit card statement payments to Global Credit Solutions Limited through your bank On Mr Smythe s statement the due amounts are expressed in Australian Dollars He has an USD account in your bank through which he makes the payments Global Credit Solutions Limited who are the utility providers have an USD account in your bank Mr Smythe s first credit card statement is issued by Global Credit Solutions Limited dated de August 2002 The amount to be paid is 200 AUD Mr Smythe makes payment against this card statement on ad August 2002 Entering the details of Mr Smythe s payment against this statement constitutes a utility payment transaction in Oracle FLEXCUBE You have maintained a product CCUP for processing credit card statement payments of customers You have also defined the following details in the ARC Maintenance for the product CCUP and the utility provider Global Credit Solutions Limited so that you can use it to enter and process the payment transaction for Mr Smythe e The ID of Global Credit Solutions Limited as the receiving institution or utility provider for any credit card payments made by customers such as Mr Philip Smythe e The USD account held by Global Credit Solutions Limited in your bank has been associated with the product CCUP as the credit account that will be credited with credit card payments made by cus
28. etails Customer Account Country Account Details Currency Instrument Currency Instrument Amount Account Currency Amount Exchange Rate Document Id Number Document Id Number Date Module Details Module Module Description Reference Number Event Sequence Number Reject Reason Status ed Cl Transaction Tanked Accounting Entries Input By Date Time Authorized By Date Time Contract Authorized Status In the Clearing Query Details screen you can view and modify existing transactions as well as enter new transactions Besides you can authorize such modification and new entries You will be able to view modify enter the following details in this screen e Reference Number of the bill payment transaction e Code of the utility payments product in which the transaction is being put through e Any external reference identification number that you have specified for the transaction e The account of the receiving institution or utility provider which is the offset account that will be credited with the bill payment amount e The amount due on the bill 5 11 ORACLE The message reference number for the matched MT110 message and the reconciliation status are displayed here For the transactions for which the Reconciliation is not applicable the Reconciliation status gets displayed as NA Example For instance let us sup
29. field displays the transaction date and cannot be modified User ID Specify the id of the Teller user for reconciliation Agreement ID This field displays all the agreement Ids for which the transactions have occurred on that particular day Customer No This field displays the customer number of associated to the agreement Alternate Customer Number This field displays the alternate customer number or the RUT for the customer Unlike the Customer Number Customer CIF ID this alternate customer number may be modified via Customer Maintenance later If the Alternate Customer Number is changed during the life of a contract then thereafter the contract will be shown with the latest updated Alternate Customer Number Currency The currency of payment is displayed here Mode The settlement mode of the payment is displayed here Channel The channel of the payment is displayed here No of Bills Enter the number of bills processed which are to be reconciled Amount Enter the total bill amount to be paid Overrides This field displays the overrides in case a transaction is not reconciled authorized Click Recon to perform reconciliation Click Confirm Overrides to confirm the overrides for successful reconciliation Once you have specified the necessary details click Query Overrides will be displayed under Overrides table for the selected agreement The overrides for the selected agreement are displayed too
30. following details in the corresponding charge tabs Charge Type The Charge Type that should be applied on the transaction It could either be a Percentage of the transaction amount or a Flat Charge Slab Type Select whether the Charge computation has to be over different Amount Slabs or Tiers 0 100 10 101 500 15 etc Basis You can indicate the basis amount on which the charge is to be computed Since you can maintain five different charge amounts the basis amount that you enter could either be the transaction amount or any of the earlier charge amounts For example let us assume you are maintaining Charge 1 The only basis for charge 1 can be the transaction amount While defining Charge 2 you can choose either the transaction amount or Charge 1 as the basis Similarly while defining Charge 3 you can choose the transaction amount or Charge 1 or Charge 2 as the basis Currency You can indicate the currency in which the charge amount would be expressed If the transaction currency is different from the charge currency a conversion would be done using the rate code and rate type that you specify for each charge Charge Account You can specify the charge account into which charge related entries are to be posted Gi ORACLE Netting Charge If two or more accounting entries for the same event are to be passed to the same account on the same Transaction Date these entries can be netted You can choose to net the cha
31. g utility payments of the customers of your bank You can further obtain information about to a particular field by placing the cursor on the relevant field and striking the lt F1 gt key on the keyboard 1 2 Audience This manual is intended for the following User User Roles Role Function Back office data entry clerk Input functions for contracts 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 Managers Generation of reports 1 3 Organization This manual is organized into the following chapters Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Overview is a snapshot of the features that the module provides Chapter 3 Defining Products for Utility Payments details the procedure to set up products for utility payments Chapter 4 Accounts Details and Charges explains the process of setting up details of accounts and charges for a utility product applicable for payment transactions is explained in this chapter Chapter 5 Processing Bill Payments deals with the procedure involved in entering the details of a utility payment transaction for a customer against an issued bill 1 1 ORACLE 1 4 Related Documents e
32. greement number Bank s Customer Check this option to denote if the customer has a relationship with the bank or not Agreement Description Specify a description for the agreement This is displayed to the customer when he creates an agreement Customer No Select the service provider ID Customer number from the option list For Bank s customer the option list contains ID s from the CIF information maintained For non bank s customers the Customer No is not validated This will be the RUT ID of the service provider When you specify the customer number the name of the customer will be displayed Customer number maintained should be a utility provider Alternate Customer Number This field displays the alternate customer number or the RUT for the customer Unlike the Customer Number Customer CIF ID this alternate customer number may be modified via Customer Maintenance later If the Alternate Customer Number is changed during the life of a contract then thereafter the contract will be shown with the latest updated Alternate Customer Number Customer Account Branch Specify the customer account branch code Account Number Select the account number to be credited from the option list This is the checking account of the service provider For Non Bank Customers the Account No can be specified as ALL and there will be no validation on the account Customer Account Currency Specify the currency for t
33. he Application tool bar and click on the adjoining arrow button Collection Agreement Summary oe a Authorization Status v Record Status v Agreement ID a Customer No lay Alt Customer Number 7 Q Search Advanced Search Records per page 15 v 14 41 Of 1 HI o Authorization Status Record Status Authorization Status Record Status Agreement ID Agreement Description ia El In this screen you can guery based on any combination of the following fields e Authorization Status e Customer No e Alt Customer No e Record Status 6 2 e Agreement ID After specifying the parameters for the query click Search The system displays all the records matching the parameters specified e Authorization Status e Record Status e Agreement ID e Agreement Description e Banks Customer e Agreement Ccy e Agreement Type e Account No e Customer No e Alt Customer No Changing Collection Status You can query for and view Collection transactions in the Collection Details summary screen You can invoke the above screen by also entering UPSCSTCH in the field at the top right corner of the Application Toolbar and then clicking the adjoining arrow button KL Collection Status Change Authorization Status Record Status Source Code B Status File Name ai Service Provider Id Due da
34. he check amount You must specify the amount being paid through each check i e the check amount This could be the entire due amount or a portion of it Specify the check amount in the Amount field in the Instrument Details section You must also specify the currency in which the check amount is expressed If this currency is different from the currency in which the bill amount is expressed you must specify the exchange rate that will be used in the Exchange Rate field Indicating the DIN You have to enter the Document Identification Number DIN which uniquely identifies an inward clearing transaction Indicating the DIN Date Enter the Din Date i e the date on which the inward clearing transaction was recorded Adding your remarks You can enter information about the check instruments as well as the clearing details intended for the internal reference of your bank The remarks are displayed when the details of a transaction are displayed or printed However this information will not be printed on any correspondence with the customer 5 5 2 Viewing Accounting Entries and Overrides You can view the accounting entries that would be passed during processing of the bill payment transaction by clicking Accounting Entries button in the Clearing Transaction Query screen The Accounting Entries screen is displayed ae ORACLE Accounting Entries Contract Reference Accounting Entries LIE Branch Account Num
35. he customer account Agreement Ccy Select the currency of the agreement from the option list The transactions under the agreement can be booked only in the agreement currency The agreement currency can be an index currency also If the agreement currency is an index currency then the transactions are accepted in the base currency of the index currency Agreement Type Select the type of agreement from the drop down list The options available in this list are e Simple e With Additional Data Validation e Installment The Installment Agreement Type has features of both Simple and Additional Data validation type of agreements Only in this case the bank provides an Accounts Receipt Service for Corporate that have multiple schedules Coll Start Date Specify the collection period start date from the option list Available options are e Without Restriction Collection can occur on any day e Day Collection can be performed every month from that day The values specified here must be in the range 1 to 31 e Month Collection can be performed from that month onwards The values specified here must be in the range 1 to 12 e Month Day Collection date is to be specified as a numeric month day combination Here 0102 implies 2nd of January e Fixed Date Specifying a date here implies that the collection start date is fixed and collection can occur only on this day The values for the option selected are specified in the Coll S
36. here You can specify values for each one of them First Execution Date Indicate the date from which the instruction should be executed using the adjoining calendar Next Execution Date The system computes the next execution date based on the execution frequency and displays it here Last Execution Date Indicate the date on which the instruction should be executed for the last time using the adjoining calendar gie ORACLE Execution Frequency Select the frequency of instruction execution from the adjoining drop down list It can be any one of the following e Monthly e Quarterly e Half Yearly e Yearly Execution Retry Count Specify the number of times that the payment execution should be re tried within the execution frequency in case of failure The retry happens on the next working day after the execution fails You can specify the maximum value as 99 Collection Mode Select the collection mode from the adjoining drop down list It can be any one of the following e Collect Full e Collect Partial For Collect Partial mode if the debit account balance is less than the bill payment amount then the system will take the available amount that can be paid and settle the remaining amount as per the retry definition For Collect Full mode if the debit account balance is less than the bill payment amount then no payment will be made The system will continue to recover the complete payment amount as per th
37. ider Agreement Maintenance The details regarding the agreement between the bank and the service provider is maintained using the Collection Services Agreement Screen This screen can be invoked from the Utility Payments module Collection Agreement Detailed in the application browser You can invoke the above screen by entering UPDCAGMT in the field at the top right corner of the Application Toolbar and then clicking the adjoining arrow button Collection Agreement Agreement Id 245589700181 M Banks Customer Agreement Description Customer No Customer Name Alt Customer Number Customer Account Branch Account No Customer Account Currency TF Allow Zero Amount Agreement CCY LE E Coll After Due Date Agreement Type simple e Coll Days After Due Date Coll Start Date without Restriction z Holiday Treatement ignore 7 Coll Start Value Coll Closing Date Without Restriction Coll Closing Value E Payment Advice For IP Allow Excess Payment instalments Payment Adv Days Internal Account Internal Account Internal Account Currency EE I Coll Stmt Read T Read Read oupon Printing Fe Service Provider Charges Subscriber Charges Fields Maker Date Time Mod No Checker Record Status Date Time Authorization Status You can capture the following details in this screen Agreement ID Specify the Customer A
38. ify the number of days up to which the payment can be made after the due date This can be specified only if the option Coll After due Date is checked Allow Access Payment Check this box if the access payment is allowed for the customer Coupon Printing For Installments In case of installment agreements select this option when you wish to have coupons printed for the installments Payment Advice for Installments In case of installment agreements the due amount and due date details of the clients of the service provider is generated and sent to the service provider company The service provider further sends these details to its clients Allow Partial Payment Check this option to allow partial payment Pay Adv Days Specify the number of days prior to the due date that the payment advice is to be sent by the bank Internal Account Select the internal account maintained by the bank for each customer from the option list This account is credited first during the day Funds are moved to Customer account at EOD along with the batch This can be a GL or current account Collection Stmt Reqd Check this option to specify if collection statement is required or not Collection statement is generated when the funds are moved to the credit account of the customer Funds will be consolidated and moved if consolidation is set to Yes at the agreement level Recon Method Specify the reconciliation method from the drop down list
39. imited Customer Group Specify the customer group to define charges This adjoining option list displays all valid customer groups maintained in the system You can choose the appropriate one Input to this field is mandatory Bank Code Specify the bank code of the remitter for the arc resolution 4 1 1 1 Specifying ATM Transaction Type You have to specify the type of ATM transaction for which you are defining the ARC details In Oracle FLEXCUBE each ATM transaction type is associated with a processing code While processing a transaction the processing code will uniquely identify the type of transaction for which the ARC definition has been maintained While processing ATM transactions the system picks up the corresponding Oracle FLEXCUBE ATM processing code from the ATM Server based on the ATM Transaction type ES ORACLE 4 1 1 2 Specifying Institution ID You must specify the ID of the utility provider for whom the ARC details are being maintained in this record These ARC details would be applicable for all payments to the utility provider involving the selected utility product and made in the selected currency Select the appropriate ID from the options list Example The recipient of Mr Philip Smythe s credit card statement payments is Global Credit Solutions Limited who are your customers and have an account in your bank You must select the CIF of this institution from the option list For each institution that would b
40. ing Bank Branch level it is picked up from here Customer float days In case Customer Float Days is not maintained at the Clearing Bank Branch level it is picked up from here Description End Point Description Display Only field Transaction Offset Accounting Entry Required Check this box for posting accounting entries for charges along with main transaction entry By default the system displays the status of this box as checked However you can modify this 4 1 1 6 Indicating Exchange Rate Revaluation You can specify the following details Profit Revaluation GL Specify the profit revaluation GL details Loss Revaluation GL Specify the loss revaluation GL details Exchange rate values are maintained at CCDRATES Rate type and Rate code preferred is maintained at product level and Negotiated cost rate is maintained at transaction level G ORACLE The Revaluation amount Transaction amount exchange rate Transaction amount negotiated rate Where Exchange rate is picked for the rate type and rate code maintained at Product level The system will display an override message if the negotiated rate is not within the exchange rate variance maintained at the product 4 1 1 7 Defining Charge details You can define a maximum of five charges A charge can be computed based either on the transaction amount or on an earlier charge amount As part of defining the Charge details for each charge you need to capture the
41. issues a check for the payment against his account You must specify Mr Gordon Greene as the remitting customer and his account as the remitter account If you have specified an account that uses an account class that is restricted for the product an override is sought when you attempt to save the contract Specifying Instrument Details You must also specify the details of the check instrument issued for the bill payment These details include e Instrument number e Details of the bank issuing the check i e codes of the bank and branch e Sector code and routing number You can also indicate for the bank that you have specified whether a check can be cleared on the next business day if presented past after the closure of clearing for the day Check the Late box to indicate this is ORACLE Specifying the date details The system displays the date of the bill payment transaction in the Transaction Date field You must specify the date of issue of the check used for bill payment Specify this in the Instrument Date field You must specify the date on which the bank will debit the remitter account for payment against the check Specify this in the Bank Value Date field The date on which the funds would be made available must also be specified in the Customer Value Date field This date could be different from the Bank Value Date if there is a float period applicable for the bank you have specified Specifying t
42. ition 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 intended 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 softwar
43. ive e Overdue When the collection amount is not paid by the due date then as per the agreement specifications it is marked as Overdue e Paid Paid in Bank Teller inputs the payment in Oracle FLEXCUBE through the transaction screen e Paid by External Source When the payment is done through an interface external source then an interface collection file is generated and sent to Oracle FLEXCUBE In such a case Oracle FLEXCUBE marks the status as Paid by External Source e Expired When the payment crosses the due date and collection is not allowed after the due date as per the agreement then the status is updated to Expired e Sent Collection by External Agency When the payment is sent to an external collection agency then the status is updated to External Agency These statuses are updated during online transactions and during execution of the BOD batch Collection Consolidation Once the collection amounts are collected from the customers during the day in the customer s internal account it has to be moved into the customer s credit account after consolidation This process of consolidation is performed at the end of the day through the Collection Consolidation Details screen You can invoke the above screen by entering UPDSCONS in the field at the top right corner of the Application Toolbar and then clicking the arrow button Collection Consolidate Details Branch All Branches v Branch
44. k Fields button on the Utility Provider Type Maintenance screen User Defined Fileds 1of1 UDF Details E Field Name x Value Cancel Refer the User Defined Fields module chapter under Modularity for further details about UDFs 5 3 Maintaining Bill Parameters You can maintain bill parameters for utility providers using the Utility Bill Structure Definition screen You can invoke this screen by typing UPDBILDT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Utility Bill Structure Definition Utility Provider Type Utility Provider Id Utility Provider Type Description Field Label Field Name Maker Date Time Mod No Checker Date Time Record Status Authorization Status You can specify the following details ve ORACLE 5 3 1 Utility Provider Type Specify the utility provider type for which you are maintaining parameters The adjoining option list displays all valid utility provider types maintained in the system You can select the appropriate one Utility Provider Type Description Based on the utility provider type the system displays the corresponding description Utility Provider ID Specify the CIF of the utility provider The adjoining option list displays all valid CIF of type Utility Provider maintained in the system You can select the appropriate one Field Label You ca
45. ment allows collection by external agency then the bank sends a file to the external agency indicating the payments to be collected Specify the no of days after which this file should be sent The status of the collection is marked as External Agency Specifying Charges for Subscribers Click Subscriber Changes to invoke the Charges Screen in order to input the charges for the subscribers Specifying Charges for Service Provider Click Service Provider Charges to input the charges for the service provider Service Provider Charges Product Code je Product Description Product Type Agreement ld 245589700388 Customer No SET ONE SET TWO SETTHREE SETFOUR SETFIVE Element Laj Functions D Operators Logical Operators v 101 FEE CERN For further details on Charges refer to the Charges and Fees Manual 6 1 7 Specifying User Defined Fields Click Fields to input the additional data user defined fields Here you can specify certain User Defined Fields UDFs for which the validation rules can be mentioned in the User Defined Fields screen The UDFs defined here are defaulted to the transaction input screen 6 1 8 Viewing Collection Agreement Summary You can view the details of the customers of your bank in the Collection Agreement Summary screen To invoke the screen type UPSCAGMT in the field at the top right corner of t
46. n capture five entities that should be captured in the bill Field 1 to 5 Specify the name of the entity for which value has to be captured during bill payment Field Name You can capture the name of field in UP module to which each label needs to be mapped The following value is available in the adjoining drop down list e Consumer No Note that you need to map one label to the field Consumer No For the remaining four labels you need not specify the UP field mapping Specifying User Defined Fields You can specify values for all user defined fields UDFs linked to the function ID in the User defined Fields screen T ORACLE Click Fields button on the Utility Bill Structure Definition screen User Defined Fileds 1of1 UDF Details r Field Name x Value Cancel Refer the User Defined Fields module chapter under Modularity for further details about UDFs 5 4 Maintaining Bill Instructions You can maintain bill payment instructions for utility providers using the Utility Bill Details screen You can invoke this screen by typing UPDAUINS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button d Utility Bill Instruction Capture Instruction Reference Utility Provider Type Branch Code Customer Id Utility Provider Id First Execution Date Next Execution Date Last Execution Date Execution Freq
47. ng products e WCUP for processing water charges payments of customers e ECUP for electricity charges payments e CCUP for credit card statement payments e TCUP for telephone charges payments SS ORACLE e You will have to define the utility provider who will be the recipient of each type of utility payment made by acustomer The details of accounts to which entries will be posted for payments exchange rates for cross currency conversion and any charges that your bank would levy on utility payments of any type accepted from customers towards each utility provider would be different Therefore you would need to map these details to the corresponding product that you have created Example One of your customers Mr Philip Smythe makes credit card statement payments through your bank On Mr Smythe s statement the due amounts are expressed in Australian Dollars He has an USD account in your bank through which he makes the payments The payments are made to Global Credit Solutions Limited who also have an USD account in your bank You have maintained a product CCUP for processing credit card statement payments of customers You can use this product to process any credit card statement payments of Mr Philip Smythe To do so you need to e Associate the standard AUD USD rates that you have defined in the system to the product CCUP e Associate Mr Smythe s USD account in your bank as well as the account held by Global Cre
48. nt and the charges maintained at the agreement are posted For consolidation for non customers of the bank DD is sent based on the DD gen days If its 1 day it will send after 1 day and if its 2 days then after 2 days Collection Reconciliation In this process you can input the number of bills and the corresponding collection amounts for a particular service provider as entered by the teller The system then checks these amounts and if there is a mismatch an error message id displayed This reconciliation process can be performed through the Collection Reconciliation screen You can invoke the above screen by entering in the field at the top right corner of the Application Toolbar and then clicking on the adjoining arrow button Collection Reconciliation Transaction Date 2011 12 01 User Id Agreement Id H cy Channel Customer Number Alt Customer Number No Of Bills Payment Amount Overrides 1of1 HIE mj overse Confirm Overrides Maker ID DOCUMENT2 Maker Date Stamp 2011 12 01 If the reconciliation processing does not happen during the day the system does not allow EOD processing This of course is applicable only for those agreements where reconciliation processing is reduired The system performs the reconciliation based on the reconciliation method specified in the agreement Transaction Date This
49. on against the collection file Active Check this field to indicate the agreement is active and can be used in collection transactions 6 1 3 Maintaining Customer Address Information In the Collection Agreement Screen click Address button to invoke the Customer Address Information Screen Customer Address Information Address Line1 Address Line 2 Address Line 3 Address Line 4 Address Line 1 4 Enter the customer address For Banks Customer Address is defaulted from Customer Maintenance and for non bank Customers it can be modified 6 1 4 Collection by External Agency Click External Agency in the Collection Agreement Screen to invoke the External Preferences Screen This is where you can mention details regard the external agency that undertakes collection External Preferences O Collection By External Collection Agent Agency Past Due Days Account ad Collection by External Agency Check this option to specify if the payment can be collected by external agency in case the payment is not done in due time Collection closing date is not validated for such collections Collection Agent Specify the external collection agency name Account Select the account number of the external agent with the back from the option list Past Due Days If payment is not received on due date and if the agree
50. onteensosnstecsnensentovensrtesvessonnebestanseostsoneseerteepsndsenestinvies 6 14 6 3 MAINTAINING COLLECTION DETAILS ees ee ee se ee see ee ee ee se ee ee ge ee Ge ee See ee SEA He rask ee eke ee oiean Ke ee Gee ee 6 15 6 3 1 Viewing Collection Details Summary 6 18 6 4 TRANSACTION PROCESSING ese ee Ge gee eer SUE n ee Ee GEE Gee sr DER gede ee te En GEE ROSE Ee E AES Gee Re Ee 6 18 6 4 1 Validation of Collection Details 6 18 6 4 2 Additional Data Voaltdetton sresti stes oaeiio eia 6 18 6 4 3 ELE m n a E EE RE EE 6 19 6 4 4 Eeue EE AR ER OE ERA EK 6 19 6 4 5 BE AE ER RE EE AE OE EE amen 6 20 6 4 6 Payment Advice Generasie iii GEE a eg ee SG ee GR de HS Sane Dag Dye Rg seke 6 20 6 4 7 Collection Status EE EO ER EE ER EA EE EE N 6 20 6 5 COLLECTION CONSOLIDATION eege 6 20 6 5 1 Specifying Consolidation OPHORNS ese ee see see se ee ee ee ee Ge Se Ge SR GRA GRA Ge Ge ee ee ee ee ee ee 6 21 6 6 OOLLECTION RECONCILIATION oee aeea Ee ONE ee En Ge EE vee ee ER Gee Gegee Ge GER Se ER ee Ge ER ee 6 22 7 SCREEN GLOSSARY 0 0 ese sesse sesse ees Be Ee Be Ee Bee Ee Be EA Be EE Be Ee Re Se EA Be EE Bee GE SE Se Ee Be Ee Be ee Re ee Se Ee 7 1 ie vo RIES OER ONE EE N EO EE EE Ee EO 7 1 ORACLE 1 About this Manual 11 Introduction This manual is designed to help acquaint you with the Utility Payments Module of Oracle FLEXCUBE It provides an overview of the module and guides you through the various steps involved in processin
51. oses the transaction Partial Payment Transaction Limit Specify the limit allowed for a transaction when partial bill amount is accepted Excess Payment Transaction Limit Specify the limit allowed for a transaction when excess bill amount is accepted Automatic Debts Check this box to indicate that the debts are to be cleared automatically Subscriber Registration Required Check this box to indicate that the subscriber registration is required Verify Subscriber Check this box to indicate that the subscriber is verified 6 1 2 1 Specifying Interest Details Collection Agreement Operation Instruction 1 Operation Instruction 2 Partial Payment Transaction limit Excess Payment Transaction limit Interest Details Subscriber Registration Required I Verify Subscriber Collection Coverage e I Interest Calc Reqd Interest Rate Period Dail z Grace Days I Prepayment Allowed Channels Delay Day Basis Discount Days Limit Interest Rule Data Verification Working Days e PF RI Gen Days Inst Type I Data Verification I Active Auxillary Accounts 10f1 m Settlement Mode Retention Days 10f1 10f1 HIE dose wow Check this to denote if interest calculation is required for the payments If this option is checked then specifying the due date is mandatory for late pa
52. ox if transaction offset accounting entry is required n ORACLE Local Float Days Specify the number of local float days The specified number of local float days will be considered only if the Local clearing option is checked in the Cheque Deposit screen Reject Branch Specify the branch code of the reject account The adjoining option list displays all the valid reject account branches maintained in the system You can select the appropriate one Reject Account Specify the GL or account number of the reject account The adjoining option list displays all the valid reject account GL or account numbers maintained in the system You can select the appropriate one If arc is maintained for specific currency then current accounts of arc currency can also be maintained for Reject Details Reject Currency Specify the currency of the reject account The adjoining option list displays all the valid reject account currencies maintained in the system You can select the appropriate one ie ORACLE 5 Processing Bill Payments 5 1 Making Bill Payments A customer of your bank could choose to make payments for utility services to the required institutions or utility providers against bills issued by them through your bank Such payments are bill payment transactions In a bill payment transaction the entities involved in a contract are the customer your bank and the institutions utility providers that ar
53. pecifically for a utility provider in the ARC Maintenance screen and associate the product you have created with these charges Whenever you use the product to process a utility payment made to the utility provider for whom you have defined the charges in the ARC Maintenance screen they are applied by default You can override these default charges if necessary Invoke the ARC Maintenance screen from the Application Browser For a full discussion of this screen refer the chapter Accounts Details and Charges in this User Manual od ORACLE 4 1 4 Accounts Details and Charges Maintaining Accounts Details and Charges Utility Products The institution or utility provider The entities that are recipients of any kind of utility payments made by customers are known as receiving institutions or utility providers For instance a company that provides telephone services in favor of whom a customer may make payments for telephone services is one type of utility provider After you have defined a utility payments product to process a specific kind of utility payment of customers you must configure the product to process payments made to a specific utility provider To do this you must specify the following details for the product e The details of accounts or GL s to which accounting entries would be posted when the utility payments are processed This would be specific to each utility provider since the debit and offset a
54. pecify the number of days after the maturity date until when the bank can collect money Collection cannot occur after the number of day specified e Fixed Day The value specified here must be within the range 1 to 31 e Fixed Month The value specified here must be within the range 1 to 12 e Fixed Date Specifying a date here implies a one time collection e Last working day of the year as maintained in the system e Last banking day of the year as maintained in the system If the collection start date is Month 1 and the end date is Month 3 then the collection can occur between 01 Jan to 217 Mar Holiday Treatment Specify the action to be performed for collection in case the due date falls on a holiday from the drop down list The options available here are e Ignore e Prev Working Day e Next Working Day If the due date is fixed then as per the holiday treatment mentioned here the system moves the same This has no impact on the interest calculation as interest is always calculated from the due date Coll After Due Date Check this option to denote if the bank can collect money after due date If this option is not checked then the collection transaction after the due date is rejected Allow Zero Amount Check this option to denote if the system can accept transactions with zero amounts This option is provided for tax payments where a zero amount payable can be captured in the system Coll Days After Due Date Spec
55. pose that Mr Smythe makes his credit card payment through a check You would need to specify the check details through the Clearing Query Details screen In this screen the following details are displayed e The reference number assigned by the system was 0OOOCCUP022150001 This is displayed in the Reference Number field in the Clearing Query Details screen e CCUP is the code of the utility product that you have set up against which you are entering the bill payment of Mr Smythe in favor of Global Credit Solutions Limited This is displayed in the Product Code field e Since Global Credit Solutions Limited is the beneficiaries recipients of Mr Smythe s bill payments their ID is displayed in the Customer field in the Beneficiaries section e The bank account of Global Credit Solutions Limited which you specified as the offset account that would be credited with the bill payment amount is displayed as the beneficiary account in the Beneficiary Details section e The amount due on the bill is displayed in the Amount field in the Account Details section Specifying Remitter Details If the check used for bill payment is being issued against an account other than the debit account typically a third party account you must specify the account in the Remitter Details section You must also specify the name of the remitter or third party Example Mr Smythe s credit card payments are made by a third party Mr Gordon Greene who
56. rge leg of the Transaction Account debit entry with the main leg of the customer accounting entry Transaction Code You can indicate the code using which the accounting entries would be booked for each charge Rate Code and Rate Type While settling charges for cross currency transactions you can choose to debit the customer by applying the mid rate buy rate or by using the buy sell spread over the mid rate Therefore you need to specify the Exchange Rate details for each ARC definition record that you maintain in the system Firstly indicate the Rate Code for which different rates can be maintained A list of all the rate codes maintained in the Floating Rates Maintenance screen is displayed in the list You can choose the appropriate code In addition to specifying the Rate Code you have to indicate the Rate Type which should be picked up for exchange rate conversions involving settlement of charges for cross currency transactions You can maintain any one of the following as the Rate Type e Buy e Mid e Sell After identifying the Rate Code and Rate Type you can indicate the basis amount on which charges are to be computed Charge Amount You have to specify the flat amount only when the charge type is a Flat Amount The flat amount will be collected in the currency that you have specified in the Currency Code field Rate If you have indicated that the charge should be a percentage of the transaction amount you have to
57. rges applicable e Definition of exchange rates applicable for cross currency conversions e _Inter branch payment transactions can be processed Si ORACLE 3 1 3 Defining Products for Utility Payments Introduction A product is a specific service facility scheme or utility that you make available to customers of your bank For instance processing payments made by customers for utility services to a utility provider institution could be thought of as a product Advantage of Defining Product When you process a utility payment transaction for a customer you need to provide the following details e Any applicable charges levied for the service of processing payments e The specific accounts that would be impacted debited or credited when the payment takes place e The exchange rates that would apply in the case of cross currency conversions that may need to be done when a payment is processed e The transaction codes under which accounting entries would be posted for each leg of the transaction e For an inter branch transaction you would need to specify the branch in which the debit account resides To avoid capturing these details each time a payment transaction is processed you can define a product You can specify all the details mentioned above and define a specific set of accounts charges and rates for each utility provider for whom you need to process payment transactions These details can then be mapped to the p
58. roduct Whenever you process a payment made by a customer to the utility provider against the product the system applies all the specifications made for the product to the transaction and you need not specify them afresh Attributes of Product A product is characterized by its attributes The attributes are options that you define that will apply to any actual transactions that will be processed against the product In the case of a product that you create to process utility payments made by a customer to a utility provider you can define a specific set of accounting details applicable charges and rates that would apply to each specific utility provider These details can be mapped to the product 3 1 2 1 Other Attributes The following are the other attributes you could define for a utility payments product e The user defined fields that you would want to use for entering transactions against the product Ge ORACLE 3 2 3 3 e The management reporting MIS details for transactions involving the product Payment Transactions A transaction is a specific operation with financial implications such as a payment that involves two or more entities A customer who approaches your bank to avail of any of the services offered by your bank enters into a transaction or contract with your bank In the case of utility payments of customers the entities involved are the customer your bank and the utility provider The utility provider is
59. ruction Reference Number Utility Provider ID Customer ID Execution Date Debit Branch Debit Account ORACLE e Payment Currency e Actual Bill Amount e Status e Payment Mode e Payment Amount e Maximum Retry Count e Retry Count e Paid Bill Amount e Status e Error Code e Message 5 4 2 Specifying User Defined Fields 5 5 You can specify values for all user defined fields UDFs linked to the function ID in the User defined Fields screen Click Fields button on the Utility Bill Details screen User Defined Fields UDF Details 10f1 LU Refer the User Defined Fields module chapter under Modularity for further details about UDFs Maintaining Products for Utility Bill Payments A product is a specific service scheme or facility that you make available to customers For instance the facility of accepting payments from customers on behalf of utility providers for bills issued by them for utility services is a specific service you could offer This service can be thought of as a product SH ORACLE 5 5 1 In Oracle FLEXCUBE a bill payment transaction for a customer is entered into the system against a specific product that has been created for processing particular types of utility payments made by customers in favor of specific utility providers For instance electricity charges payment made by a customer to a specific electrical services provider is entered into the system agains
60. t CCUP as the offset or credit account that will be credited with all credit card payments made by customers such as Mr Smythe in favor of them through your bank e Specify USD as the currency in which payments would be accepted e Specify the account that will be debited for credit card statement payments made in cash by any clients of Global Credit Solutions Limited through your bank who do not have an account in your bank ORACLE e Define any charges that your bank would levy for the service of processing credit card statement payments made in favor of Global Credit Solutions Limited and associate these with the product CCUP e Associate the standard AUD USD rates that you have defined in the system to the product CCUP Throughout our discussion of how accounts details and charges information is specified for a utility product in this chapter we will be referring to the example given above ARC Maintenance Screen The ARC Maintenance screen allows you to maintain these details for any utility product against which you process utility payments made by customers in favor of a specific utility provider Through this screen you can perform the following tasks while posting accounting entries related to utility payment transactions involving a utility product in Oracle FLEXCUBE e Specify the Accounting entry definition e Indicate the Exchange Rate specifications for any charges e Capture the Charges that should be le
61. t a product created specifically for the utility provider for electricity charge bill payments Defining a product simplifies the process of entering a transaction since you can associate a product with certain accounting and charges details that will be applied to all payment transactions entered against the product automatically saving your effort to specify them afresh each time you input a transaction When Oracle FLEXCUBE processes the transaction it will apply all the attributes and specifications made for the product against which the transaction was entered You can enter more than one payment transaction of a customer for a specific service against a product created for the utility provider Before you enter any payment transactions for a utility provider you should have already defined a specific product to process payments against bills issued against the specific service provided by the utility provider The definition of products for utility payments is explained in detail in the chapter Defining Products for Utility Payments in this user manual For each utility provider you must also define the following details and associate them with the product 1 The specific GL s to which accounting entries would be posted for the payment made for a specific utility to the utility provider 2 Any applicable charges that your bank levies for the service of processing payments made for a specific utility to the utility provider
62. ta is linked to the transaction as UDF The validation logic is associated with the UDF definition The data is validated when you input the values for these UDF using the UDF validation logic Readjustment The bank collects readjustments for local currency based bills only The calculation is based on the change in the index currency from the due date to the payment date The collection is done based on the index currency on the collection date Example Local Currency Amount due on 15 Dec 1000000 Suppose index currency value 5 Jan 16000 Suppose index currency value15 Dec d 15968 Payment date is 5 Jan Readjustment 1000000 16000 15968 1000000 2004 If the readjustment is negative then the original amount is collected Readjustment can be for late payments or early payments Transactions The transactions are processed based on the settlement mode as explained below e Cash Teller Processed by Utility Payment Product of type Cash e Clearing Clearing transaction is triggered for the external bank cheques through common multimode settlement screen Processed by Utility Payment Product of cheque type e CASA _ Processed by Utility Payment product e External Account A Payment and Collection Transaction is triggered through common multimode settlement screen Processed by Utility Payment Product of utility payment type In all the modes the accounting entries are as below For settlement mode external
63. tance in our example of Mr Philip Smythe s credit card statement payments for the product CCUP you could specify Credit card statement payments as the description Slogan Specify a catchphrase for the product You could specify a marketing motto or any other saying that encapsulates the product in a few short words For any utility product you must specify a slogan Product Group Products are classified into different groups based on similar characteristics The classification makes it simple to retrieve information about a class of products A list of product groups maintained in the Product Group Definition is displayed in the list box from which you can select the appropriate group ES ORACLE 3 4 2 3 4 3 Start and End Date To recall a product is a scheme or service that your bank offers customers Typically a scheme or service is available to customers within a fixed period This period is the life span of the product You specify the product life span by providing a Start Date and an End Date The period between the two dates is when the product is available for use If you do not specify an end date the product can be used indefinitely or until it is closed Remarks You can specify information about a product that will be used for reference within your bank It will not be printed on any correspondence with customers but will be displayed when the details of any payment transaction involving the prod
64. tart Value Here only the option is selected Note the following e When Coll Start Date is Without Restriction then there will be no Coll End Date e When Coll Start Date is Fixed Date then Coll Close Date will be disabled Coll Start Value In case you choose day Month Month Day or Fixed Date as the Coll Start Date then the start value has to be specified here e Day The values specified here must be in the range 1 to 31 e Month The values specified here must be in the range 1 to 12 e Month Day Here a month day combination is to be specified That is 0102 implies 2nd of January e Fixed Date Specifying a date here implies that the collection start date is fixed and collection can occur only on this day Coll Closing date Specify the collection period closing date from the option list Available options are e Without Restriction Collection can close on any day e Until Due Date Collection can occur until the due date e Schedule Days after Due Date Collection can occur unto a maximum number of days after the due maturity date and not a single day after that e Day Collection can close on a fixed day specified e Month Collection can close on a fixed month e Last working day of the year as maintained in the system e Last banking day of the year as maintained in the system Coll Closing Value Specify the closing value if you have chosen the closing date as any of the following e Schedule Days after Due Date S
65. te SP Agreement id Amount B Bill No Currency S Record No Q Search Advanced Search Records per page 15 vw j4 4 1 of 1 py ry Authorization Status Record Status Source Code Status File Name Service Provider Id Due date SP Agree he lt ii nete Fa Expres Pedy External Sources Overdue Sen In the above screen you can base your queries on any or all of the following parameters and fetch records e Authorization Status e Source Code e File Name e Due Date e Amount e Currency e Record Status e Status e Service Provided ID e Agreement ID e Bill Number e Process Status e Record Number Select any or all of the above parameters for a query and click Search button The records meeting the selected criteria are displayed System displays the following records that match the search criteria Select the record whose status you need to change and click the required status button The following status buttons are available in the screen e Active e Paid e Expired e Paid by External Source e Overdue e Sent 6 3 Maintaining Collection Details When a collection file is sent by the bank to the service provider an interface is provided wherein the service provider can change the details of a particular transaction if required after sending the file to the bank and before processing The changes can be maint
66. tility provider you must specify the account that must be debited to which debit entries will be posted as well as the branch in which this account resides The branch information could also be used in the case of an inter branch payment transaction Example Mr Edward Smith a walk in customer makes his credit card statement payments to Global Credit Solutions Limited by cash through your bank In this field you must specify the cash account that will be debited for this payment as the transaction account 4 1 1 5 Identifying Transaction Codes In addition you have to also identify the transaction codes against which offset and debit related entries for the payment ought to be tracked ORACLE Indicating the netting of debit leg of charge You have the option to net the accounting entries for the debit leg of the charges along with the main transaction entries Check this box to indicate that the debit leg of the charges is to be netted before passing the accounting entries Leave the box unchecked to pass the entries without netting the charges of the debit leg Generating transaction advice Whether an Advice needs to be generated for the Transaction redundant for J2EEBranch might still be used for other Interfaces Float days basis Whether to consider the Calendar Days or Working Days for computing the Value Date based on the Floats maintained Bank float days In case Bank Float Days is not maintained at the Clear
67. tomers such as Mr Smythe e USD as the currency in which payments would be accepted by Global Credit Solutions Limited e Any charges that your bank would levy for the service of processing credit card statement payments for Global Credit Solutions Limited have been defined and associated with the product CCUP e The standard AUD USD rates that you have defined in the system are also associated with the product CCUP 5 2 Maintaining Utility Provider Type You can maintain different types of utility providers using the Utility Provider Type Maintenance screen S ORACLE You can invoke this screen by typing UPDTPMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Utility Provider Type Maintenance Utility Provider Type Utility Provider Type Description Maker Date Time Mod No Checker Date Time Record Status Authorization Status You can specify the following details Utility Provider Type Specify a unique identifier for the utility provider type The code can be alphanumeric and can have a maximum of 35 characters Utility Provider Type Description Give a brief description for the utility provider type You can specify a maximum of 105 alphanumeric characters 5 2 1 Specifying User Defined Fields You can specify values for all user defined fields UDFs linked to the function ID in the User defined Fields screen SES ORACLE Clic
68. tory Programs for EOD in the AEOD User Manual The system fetches the bill amount bill date and bill number from an external system The batch executes the payments for instructions maintained in the current branch Each payment creates a utility payment transaction The product for posting transaction is picked up from a back end system parameter If you want advices to be generated for the payments then you will have to check the box Generate Advice in the in ARC Maintenance screen SZ ORACLE 6 1 6 Collection Services Introduction The bank extends collection services to service providers These are of three types e Simple Services e Services with Additional data verification e Accounts Receipts collection Services Such operations are mutually agreed upon by the bank and the service provider based on a Collection Agreement Customer and Payments Maintenance The details of service providers are maintained in the Customer maintenance feature offered by Oracle FLEXCUBE For further details on Customer Maintenance refer the Core Entities User Manual The transactions for the payments by the subscribers to the service providers is maintained using the Utility Payment Product Definition The charges and accounting entry definition is maintained through the ARC Maintenance screen For further details on Utility Payments and the ARC Maintenance Screen refer the Utility Payments User Manual 6 1 2 Service Prov
69. tricity payment would be PowerCorp s account with your bank Whereas when he makes a water supply payment it would be Springwell s account with your bank Also the charges that would be levied in each case would be different In view of this you would need to define three different sets of accounting and charges details for each kind of payment for each utility provider one each for processing electricity charges payment water charges payment and telephone charges payment Having defined these accounting and charges details you will need to map these details to the corresponding product for each of the utility providers mentioned above SS ORACLE 3 4 3 4 1 For instance when you define the account that would be impacted with Mr Werker s electricity payment as PowerCorp s account and define appropriate charges you must map these details to the product ECUP If a second electricity services provider say Global Power Resources also designates your bank as authorized to accept electricity charges payments made by customers you can define another product other than ECUP and set up specific accounting and charges details for the same Alternatively you could use the same product ECUP and define a different set of accounting and charges details that would be applicable to payments made by customers to Global Power Resources Creating Products for Utility Payment Transactions To create a product for utility payments of
70. uct are displayed or printed Defining Other Attributes of Utility Payment Products After specifying all these basic details of a product you can indicate certain specific attributes for the product Each of these attributes can be defined in the corresponding screen that you can invoke from the UP Product Definition main screen by clicking the appropriate icons Attributes with common characteristics are grouped together in common screens simplifying the process of defining them Click Fields button to specify any user defined fields that would be required during entry of transactions involving the product Click MIS to specify any MIS details that would be applicable for any utility payment transactions involving the product Saving Utility Payments Product After you have specified all the mandatory information required for the product in the product definition screens you could save the product You will not be allowed to save the product until you have specified all the mandatory information When you save the product the following information is updated and displayed in the status bar of the UP Product Definition screen e Your User ID in the Input By field e The date and time at which you entered the product in the Date Time field Also the status of the product is updated as Open and Unauthorized Another user with authorization rights must authorize it before you can begin to use it SH ORACLE 3 4
71. uency Execution Retry Count Collection Mode Execution Log Maker Checker Utility Provider Type Description Parameters Debit Branch Debit Account Payment Mode Fi Payment Currency Payment Amount Date Time Date Time Record Status Authorization Status You can capture the following details 5 5 ORACLE Instruction Reference Number The system generates a unique identifier for the instruction and displays it here on saving the record Branch Code The current logged in branch is displayed here Customer Id Specify the Customer Identification Number CIF of the customer for which payment instructions are being maintained The adjoining option list displays all valid CIF maintained in the system You can select the appropriate one Utility Provider ID Specify the CIF of the utility provider The adjoining option list displays all valid CIF of type Utility Provider maintained in the system You can select the appropriate one Utility Provider Type Specify the utility provider type for which you are maintaining instructions The adjoining option list displays all valid utility provider types maintained in the system You can select the appropriate one Utility Provider Type Description Based on the utility provider type the system displays the corresponding description Parameters The system picks up all parameters maintained for the utility provider type and displays them
72. vied You can invoke this screen by typing IFDATMMN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The accounts details and charges details or ARC details can be specified to be applicable either for an account class or a product type You need to indicate this in the ARC Maintenance screen e ORACLE If you are maintaining ARC details for an Account Class the ARC details maintained in this screen will be used for posting entries for the Account Class and ATM Transaction Type combination ARC Maintenance Description Branch Name Code Main Transaction Code Charge From Account Management Branch Offset Details Main Leg for the Account Class Product ena Ac Generate Transaction Transaction Type geg Advice Currency Transaction Details End Point Account Class Product Account Class Branch Bank Float Days Product Type Account Description Float Days Basis der Tea Code Customer Float Days Working Offset Transaction Debit Account ad Description Information System Liquidation Product for Demand Draft Netting Charges Customer Group Generate MT101 Bank Code Exchange Rate Revaluation Profit Revaluation GL Loss Revaluation GL Charge 1 Charge 2 Charge3 Charge4 Charge5 Basis Rate Charge Account Minimum Charge Transaction Code Maximum Charge Charge Type Rate Type Currency Amount Rate Code Description
73. yments during transaction input Maker Checker Date Time Mod No Record Status Authorization Status Date Time Interest Calculation Required Delay Days Basis Select the delay basis to be considered while calculating interest from the drop down list The options available are e Working Days The system does not consider holidays for interest calculation e Calendar Days The system considers all days irrespective of holiday or working day for interest calculation Prepayment Allowed Check this to specify if prepayment is allowed Interest Rule Select the Interest Rule from the drop down list This is one of the Charge rules maintained in the subscriber Charge definition screen Grace Days Specify the number of days beyond the due date till when payments can be made without any interest charges However the interest on payments made after the grace days is calculated from the due date Discount Days Limit Specify the discount days limit This is the no of days before the due date for which the discount will be given For an Agreement if discount days are maintained then pre payment needs to be maintained for that else the system does not allow payment before due date The charge rules maintained in the subscriber charges should be of discount type and not premium type for the discounts to be calculated Interest Rate Period Select the interest rate period from the drop down list
Download Pdf Manuals
Related Search
Related Contents
TEST REPORT User manual ブラックフィルム - 阪神技術研究所 User Manual Conference Server User Guide v. 7.3 mortero acrílico acabado fratasado y gota Hardware Manual plafonds 4 a. Copyright © All rights reserved.
Failed to retrieve file