Home

Back Office User Manual

1. 5 Click the Close button BA433 Collateral To Account Inquiry One collateral can be linked to more than one account Using this option you can view all the accounts that are linked to any collateral The system provides information on total collateral value unused collateral value all the linked account numbers the percentage share value of the collateral linked to each account the type of collateral etc Definition Prerequisites e BAM 74 Collateral Header Maintenance e BAMBS89 Collateral Code Maintenance e Loan amp CASA account to which the collaterals are attached Modes Available Not Applicable To inquire on accounts linked to a collateral 1 Type the fast path BA433 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Collaterals gt Collateral To Account Inquiry 2 The system displays the Collateral To Account Inquiry screen ORACLE Collateral To Account Inquiry Collateral To Account Inquiry Collateral ID Collateral Code J Currency Total Collateral value 0 00 Unused Collateral value g 0 00 Field Description Field Name Description Collateral ID Mandatory Numeric 22 Type the ID of the collateral Collateral Code Mandatory Drop Down Select the collateral code from the drop down list The collateral codes are added and maintained in the Collateral Codes Maintenance Fast Path BAM39 option C
2. Task Download E Select Area Default O Branch Folder Select File File Name FileID Narrative File Upload Download Field Description Field Name Description File Description Mandatory Alphanumeric 120 Type the description of the file that the user wants to upload or download ORACLE Field Name Task Select File File Name File ID Narrative Description Mandatory Drop Down Select the task from the drop down list It allows the user to upload download the file The options are e Upload e Download Conditional Command Button Select the file which has to be uploaded using the Browse button This field is enabled only if Upload option is selected in the Task field Mandatory Alphanumeric 120 Type the name of the file which has to be downloaded uploaded This field is editable only if the user wants to download a file Display This field displays the unique identification number of the file corresponding to the file name Mandatory Alphanumeric 120 Type the narration based on the transaction By default the system displays narration depending on the transaction 3 Type the file description and press the lt Tab gt or lt Enter gt key 4 Select the appropriate task from the Task drop down list 5 Select the area and type the file name Upload Local File ORACLE Upload Local File File Description Test Task Download x
3. Mandatory Alphanumeric 40 Type the name of the outward remittance file maintained in the RJSin folder on the application server Mandatory Alphanumeric 40 Type the name of the output helper class file Mandatory Alphanumeric 40 Type the name of the folder in which the output helper class file is uploaded ORACLE Field Name Displays Future Date Allowed Gefu Setup External System Code Processor Type Optional Check Box Select the checkbox to allow future date Note This field will not be available for the teller to do modifications File Type ot Common Parameters Gefu Setup cL setup ise Format crx Upload Template Report Output File Transactional Commit Size Number of Parallel Streams Allow Reversal Encryption Required Algorithm Name Encryption Key EOD Bitmap Parallel Processing CheckSum Required Internal To External Hold Required Upload Commit Size Value Date Validation Record Details Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Displays Upload Template Mandatory Alphanumeric 40 Type the name of the template file which gives the format of the input flat file The Upload Template is defaulted from the file type entered Report Optional Ch
4. Account No Principal Balance Deduction Amount Balance Present CRR Display This column displays all the account numbers of the customer in case of Customer Based Search criterion In case of Account based search only that account number mentioned in the search criterion is displayed Display This column displays the outstanding principal balance Display This column displays the total amount that is deducted as per the last collateral valuation Display This column displays the balance Display This column displays the current CRR ORACLE Column Name Description Expected Provision Display This column displays the provision value corresponding to the account CRR Account Provision Display This column displays the provision maintained at the account level The value will be the same as Expected Provision in case the Account Provisioning is set to Automatic Accounted Display Provision This column displays the value of provision to an extent the GL entries have been passed at the account level If the GL entries for provisioning is maintained as Yes the value will be same as Account Provision User Provision Display This column displays the provision maintained manually by the user in the Provision Adjustment tab Account Status Display This column displays the status of the account 7 Click the details in the Accounts tab to activate the other tabs Provision History
5. For example The customer s short name is George Abraham One can search the above customer by entering Geo in the Search String field Display This field displays the identification code of the customer A customer IC along with customer type is a unique method of customer identification across the bank covering all branches Based on the combination the system can identify the customer as an existing customer even when the customer opens a new account in another branch A social security number passport number birth certificate or corporate registration can be used as a customer IC Display This field displays the ID of the customer A customer ID is an identification number generated by the system after customer addition is completed successfully This running number unique to a customer across the system is generated after the system has identified the Customer IC and Customer Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system A social security number passport number can be used Display This field displays the name of the home branch where the customer s account is maintained Display This field displays the full name of the customer Display This field displays the customer CRR The customer will be assigned the worst CRR of all the accounts and all the accounts will follow the customer s CRR Account Based Search
6. Linkage Code Linkage Type SC Nature Type Ccy This column displays the service charge code of all the service charges levied on the account Display This column displays the linkage code Display This column displays the linkage type Display This column displays the nature of charge i e the category of the service charge Display This column displays the currency code in which the applicable service charges are payable ORACLE Column Name Description Description Display This column displays the service charge description Start Date Display This column displays the start date End Date Display This column displays the end date Level Display This column displays the service charge level 6 Double click a record to enable the Charges Applied Summary tab Charges Applied Summary int Inquiry SC Details _ current Package C Expired Packages Filter Criteria all RP Account Level Product Level From Date ES To Date EE p F Charges Applied Charges Applied Surmmary Charges Due SC History SC Code t L ers Cumulative Count of Transactions 1 fi o i 1 i Cumulative Amount of Transactions Is Is e 5 Is 5 SC Charged Is Is o 5 Is 5 Differential SC Charged o le e o e o SC Amount Waived Jo Jo Jo o Jo o SC Amount Earmarked e le e o To o Field Description Field Name Description ORACLE Field
7. MTD Display This column displays the SC information for the current month It displays the total number of transactions for the running month For example if the current date is January 30th this field displays the SC information from start of the month i e from January 1st to January 30th ORACLE Column Description Name RYTD Display This column displays the information of the service charges for the past 12 completed calendar months For example if the current date is May 31 2002 then this field displays the SC information from May 1 2001 to April 31 2002 CYTD Display This column displays the information of the service charges for the current year till date For example if the current date is June 23 2003 then this field displays the SC information from January 1 2003 to June 22 2003 YTD Display This column displays the history of the service charge for the current year till date The year beginning for this calculation is the financial beginning of year For example if the current date is 23 June 2003 this field will display the number of transactions for an account for a period from 1 April 2003 22 June 2003 where April 1 is the beginning of the financial year ITD Display This column displays the number of transactions for an account since the account was opened The inceptions to date field provides the details of a service charge levied on an account since it was opened 7
8. ORACLE Account Provision Search Criteria Customer Based Search IC 270519761 Account Based Search Customer Full Name GEORGE GEROGE THOMAS Customer Id Home Branch 700 Customer CRR R Account Number Customer Id Account Number Accounted Provision i Accounts Provision History Provision Adjustment Customer CRR Home Branch Expected Provision Inquiry Option 31 12 2007 10 00 10 00 0 80 0 80 of SYSTEM SYSTEM 31 01 2008 10 14 10 14 0 01 0 81 of SYSTEM SYSTEM Y 29 02 2008 10 28 10 28 0 01 0 82 o SYSTEM SYSTEM Field Description Field Name ok close _ Description Account Number Expected Provision Accounted Provision Display This field displays all the account numbers of the customer in case of Customer Based Search criterion In case of Account based search only that account number mentioned in the search criterion is displayed Display This field displays the provision value corresponding to the account CRR Display This field displays the value of provision to an extent the GL entries have been passed at the account level If the GL entries for provisioning is maintained as Yes the value will be same as account provision ORACLE Field Name Description Inquiry Option Mandatory Drop Down Select the inquiry option from th
9. Service Charges Details button provided at the bottom right corner of all charged transactions and events maintenances For more information refer to Service Charge Details in Common Screens option in Oracle FLEXCUBE Introduction User Manual SCMO02 SC Package for Customer Using this option you can link a SC package to a customer Following activities can be performed using this maintenance e Link SC Package to the customer e Specify the customer s existing accounts to which the package should be linked e Specify an effective date from when the SC package linked at customer should get affected at customer s accounts Definition Prerequisites e SCMO01 SC Package Definition e 8053 Customer Addition ORACLE Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add a service charge package for customer 1 Type the fast path SCM02 and click Go or navigate through the menus to Transaction Processing gt Account Transactions gt Customer Transactions gt SC Package Link at Customer 2 The system displays the SC Package for Customer screen SC Package for Customer SC Package for Customer Search Criteria Customer Short Name Search String Full Name David J Paul ID 600075 IG ABC Service Charge Package fi CURRENT ACCT CORPORATE Customer SC Waiver Flag 7 Package Detail
10. l 7 z Aree ameer 26 09 2010 06 09 2020 E TSAMEER 20110331 Add txt TSAMEER isoeo s 08 20 2 o le processa a 3 ameer 26 09 2010 06 09 2070 z e ISAMEER 20110331 ECS del txt TSAMEER TS TS S gt HH bs ie o le processa SSAMEER 20110331 Addit ISA H gt zone Fa z o le PROCESS 0 03 2070 z SA 1 Ecs Lot TSA 1 1 o processa TSAMEER 20110331 ECS mod ot ISA 1314 02 piii i 2 2 2 ROCE E E rl x close _ciear_ Field Description Column Name Description Upload Date Display This column displays the date on which the file is uploaded from the branch Branch Code Display This column displays the branch code from where the file is uploaded File Name Display This column displays the file name selected for upload User ID Display This column displays the user ID of the teller who uploaded the file Start Time Display This column displays the time when upload is initiated End Time Display This column displays the time when upload is completed ORACLE Column Name Total Records Total Accepted Total Rejected Not Processed Is Processed File Total Debit Amount Total Debit Count Total Credit Amount Total Credit Count Narration Status Description Display This column displays the total number of records in the file Display This column displays the total num
11. stomer ID r A Cu Currency Branch re nch SC Details Current Package Filter Criteria All Fro orvorsie00 shee Expired Packages RP Account Level Product Level Tee lerfor se00 m Date Global Definitions Charges Applied Field Description Field Name Account Details Account No Name Customer ID Status Currency Description Mandatory Numeric 14 Type the CASA number of the customer for which you want to perform the SC history account inquiry Display This field displays the short name of the primary customer linked to the account Display This field displays the customer ID Display This field displays the CASA status Display This field displays the currency in which the account is maintained ORACLE Field Name Description Product Display This field displays the name of the product to which the CASA belongs Branch Display This field displays the branch in which the account is opened and maintained SC Details Current Package Expired Packages Filter Criteria From Date To Date Mandatory Radio Button Select this radio button Mandatory Radio Button Select this radio button Mandatory Radio Button Select the filter criteria by clicking the appropriate radio button The options e All e RP e Account Level e Product Level This field is enabled only if t
12. Alpha numeric Last nine digits Running sequence number unique across bank common for Adhoc and regular requests On reaching 999999999 the number will get reset to 1 numeric Requesting Branch Mandatory Drop Down Select the branch code from the drop down list This is the bank or branch that has initiated request for the stock ORACLE Field Name Request Type Date of Request Ad hoc Request Reason Reference No 1 Reference No 2 Description Mandatory Drop Down Select the request type from the drop down list The options are e Adhoc When a request is placed before the re order level is reached it is termed as Ad hoc e Regular When a request is placed after re order alert is generated Mandatory Pick List dd mm yyyy Select the request date from the pick list By default this field displays the current posting date It must be less than or equal to current date and cannot be a future date Conditional Alphanumeric 40 Type the reason for requesting the stock This field is enabled if the user selects the Adhoc option in the Request Type field Optional Alphanumeric 12 Type the first reference number Optional Alphanumeric 12 Type the second reference number Column Name Description Srl No Display This column displays the system generated serial number Request id Display Stock catalog Code Denm This column displays the request ID Mandatory Drop Down
13. Date To isfoaj2o08 e Current Balance 4 of units Details Denomination Details Stock Details Denomination Balance of units Field Description Column Name Description Purchase Order Request No Supplier Date of Order Display This column displays the purchase order number Display This column displays the request number Display This column displays the name of the supplier Display This column displays the date on which the order was placed 10 Click the Ok button to return to the Details tab ORACLE 11 Click the Close button Note The results of the query are based on the requesting location and the Inputs The pending orders are displayed If no input specified all pending orders and their details are displayed ORACLE Service Charges Service Charge Details Screen The Service Charges Details is a common screen which is linked to all the transactions and events maintenance s for which a bank may levy charges This screen enables a user to view the details of the charges levied for the particular transaction or an event Examples of such transactions would be purchasing a TC selling a banker s cheque or DD etc This option allows the user to only change the SC Amount The user may increase or decrease or even waive it as required This screen attached to transactions and events maintenance s can be navigated to by clicking the
14. Description Mandatory Numeric 11 Type the acquirer institution ID The institution ID is allotted to the bank by the central bank or the governing body for non branch channels like TBS ATM and POS Optional Numeric 11 Type the forwarder institution ID The institution ID allotted to the bank by the central bank or the governing body for non branch channels like TBS ATM and POS who own and manage the POS network Conditional Numeric 15 Type the card acceptor identification code This code identifies the POS which defines the point of transaction in both local and interchange environments Conditional Numeric 16 Type the card acceptor terminal ID Each unique code identifies a terminal at the card acceptor location Mandatory Numeric Nine Type the GL account number The bank will maintain a dummy merchant account for each POS terminal This is the account number which will be credited online for the transaction amount and debited for the discount amount for On Us transactions arriving from that POS terminal If a merchant has installed multiple POS terminals each of them could be associated with the same dummy merchant account number Mandatory Pick List Select the originating branch code from the pick list The originating branch code refers to the branch through which the POS transactions would be routed to the respective branches In practical scenarios where all POS operations a
15. Field Name From Acct Ccy From LOB From Product Code From GL Acct No To GL Branch To Acct Ccy To LOB To Product Code To GL Acct No Acct Ccy Rate Description Mandatory Drop Down Select the GL currency in which the From GL Account will be debited from the drop down list This field is for future use This field is for future use Mandatory Pick List Select the GL account number from the pick list The GL description name is populated adjacent to the GL account number This is the GL account which will be debited Mandatory Pick List Select the appropriate GL branch for miscellaneous transfers to that branch from the pick list The list displays all the branches defined in FLEXCUBE Mandatory Drop Down Select the GL currency in which the To GL Account will be credited from the drop down list This field is for future use This field is for future use Mandatory Pick List Select the GL account number from the pick list The GL code is populated adjacent to the GL account number This is the GL account which will be credited Display This field displays the rate at which the account currency is converted to the local currency of the bank The teller s right to change the account currency rate within a range is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Depending on the configurable option at
16. Optional Check Box Select the Levy Issuer Fee Online check box if you want to debit the issuer fees online simultaneously along with the transaction Issuer fees is normally passed on by the switch ETBI on which the ATM TBS runs Issuer fees is included in the message that is passed on by the switch ETBI and gets debited online with the original transaction amount provided this flag is checked Mandatory Alphanumeric Five Type the funds appropriation sequence This field denotes the sequence in which the transaction amount needs to be appropriated while debiting the account The options are e S Sweep In e O Overdraft e V Overline e A Advance against unclear funds e T Temporary Overdraft Click the Add button 4 Enter the bank code and press the lt Tab gt or lt Enter gt key Enter the required information in the various fields ORACLE ATM Bank Params Maintenance Bank Code I Institution Id 1111 Issuer Fee GL 100031800 ATM Cash GL 100010101 Forwarder Cash GL 100010101 Acquirer Cash GL 100010101 Forwar der Fee GL 100081800 Acquirer Fee GL 100021800 Debit Suspense GL 100074000 Credit Suspense GL 100074000 Remittance Debit GL 100074000 Remittance Credit GL 100074000 Settlement GL 100074000 Remit Branch Code Jakarta v Allow Funds Transfer Across Customers V Levy Issuer Fee Online m Funds Appropriation Sequence
17. Select the appropriate stock catalogue code of the stock or the inventory item for which the request order is placed from the drop down list Mandatory Drop Down Select the appropriate denomination value of the stock from the drop down list If denomination is not applicable the drop down displays 0 option Select 0 in this case ORACLE Column Name Description Qty req Mandatory Numeric 10 Type the appropriate amount of stocks required For example 50 units of banker s cheque It can be 50 leaves or booklets of banker s cheque Total Display This column displays the total value Total Value Denomination Quantity For example If Denomination 100 and Quantity 20 Then Adjustment Total value 2000 Only stock or inventory items which are tracked denomination wise will have an Adjustment Total value Delete y n Toggle Click the toggle status to change the value to Y if you want to delete the particular stock item from the list By default the system displays the value as N Order Stocks Transaction Order Stock x Order Stocks Purchase Order No 10 Request No oz1ssss9se n Date of order 1s 02 2008 e5 Supplier code M SHDFC Reference no 1 fit Reference no 2 2 add Delete Stockcatalogtode Denm Qtyrea Series 021599995 29 BARODO 200 BKI 2 3 75000 02
18. Start DownLoad J Load File Stop Cancel ORACLE Field Description Field Name Description Entity Mandatory Pick List Select the entity to be downloaded from the pick list This field is used for adhoc download by the System Operator at the branch From Mandatory Drop Down Select the location of the local office where the database is maintained from the drop down list This field is used for adhoc download Delete Old Record Optional Check Box Select the Delete Old Record check box if you want to delete the old record from the local branch database This option will refresh the table in the branch database and download all the authorised records from the central host thus enabling a full download To Mandatory Drop Down Select the branch code to which the adhoc download has to be done from the drop down list This field is used for adhoc download Path This is for future use 3 Select the entity from the pick list 4 Enter the appropriate information in the relevant field 5 Click the Download button Download Service ORACLE Download Service Entity B Codes From BANK OF AMERICA Delete Old Record To LBC Path Browse Start DownLoad Load File Stop Cancel 6 The system displays the services which can be downloaded Note For more information on Authorisation transactions refer to the FLEXCUBE Introduction User Manual
19. Stock Code Date From 15704 2008 pale 15704 2008 Indent Request Reference Purchase Order Reference Current Balance of units C 7 s remo anise um tore a e ses sos frances CHERE arisiouse C so Bevan DRAFT BRI KFARWESTMOVE o pn Personale ch Barknouss 4 Denomination Balance of units Field Description Column Name Description Stock Code Display This column displays the stock code Stock Name Display Branch Name User ID Issuer Currency This column displays the stock name Display This column displays the branch code Display This column displays the ID of the user who has placed the request This column is displayed if Stock Transaction option is selected in the Stock Inquiry drop down list Display This column displays the issuer bank name Display This column displays the currency in which the stock is issued ORACLE Column Name Description Txn Date Display This column displays the transaction date This column is displayed if the Stock Transactions option is selected from the Stock Inquiry drop down list Req Date Display This column displays the request date This column is displayed if the Indent Request Status option is selected from the Stock Inquiry drop down list Req Type Display This column displays the request type This column is displayed if the Indent Re
20. 5531 Download Upload File This option is used to transfer the file from the Branch to the RJSIN area of Host for further processing and even to download any file from the Data Center This option is commonly used in case of Clearing files upload that are received from the Central Bank for clearing and even used for External file Upload GEFU Definition Prerequisites Not Applicable Modes Available Not Applicable To view about the upload file status 1 Type the fast path 5531 and click Go or navigate through the menus to Operator Processes gt Data Download Options gt Download Upload File 2 The system displays the Download Upload File screen Generic External File Upload ORACLE Download Upload File FileName Posting Date 202 2008 Action Field Description Field Name Description File Name Mandatory Alphanumeric 40 Type the file name along with the path of the Local PC from where the file needs to be uploaded or Downloaded Posting Date Mandatory Pick List dd mm yyyy Select the posting date from the pick list This is always the FLEXCUBE Retail Processing date Action Mandatory Drop Down Select the action to be performed from the drop down list The options are e Upload Use this option to Upload the File e Download Use this option to Download the File 3 Type the file name and posting date 4 Select the Action from the drop down list Dow
21. Bosa Record Details _ EE By Authorized By Last Mnt Date Last Mnt Action Authorized 6 Click the Ok button 7 The system displays the message Record Added Authorization Pending Click the OK button 8 The ATM bank parameters are added once the record is authorised ATMO02 ATM Acquirer POS Id Maintenance Using this option you can maintain the various Switch IDs the physical ATM terminals that connect to these switches and the originating branch code for a particular ATM Each ATM is logically attached to a GL ATM CASH GL in some branch originating branch in FLEXCUBE Every ATM in the ATM network of a Bank has two ATM IDs Card Acceptor terminal ID and Card Acceptor ID code which uniquely identify the ATM The ATM Acquirer POS ID Xref maintenance maintains the cross reference between the ATM IDs ATM CASH GL and the ATM branch Also every Forwarder VISA Master Card which the bank interfaces with has to be configured through this option Definition Prerequisites Not Applicable Other Prerequisites e GL Codes have to be defined Modes Available ORACLE Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add ATM acquirer POS ID 1 Type the fast path ATMO2 and click Go or navigate through the menus to Global Definitions gt Channels gt ATM Acquirer POS Id Maintenance 2 The
22. Credit Risk Rating ORACLE Field Name Description Account Number Customer CRR Customer Id Home Branch Mandatory Numeric 14 Type the account number of the customer for which the CRR is to be inquired It could be a CASA account or a loan account Display This field displays the customer CRR The customer will be assigned the worst CRR of all the accounts but all the accounts of the customer will have respective CRR Display This field displays the customer ID Display This field displays the name of the home branch where the CASA account loan account is maintained To search based on customer select the search criteria from the drop down list Type the search string in Customer Based Search section and press the lt Tab gt or lt Enter gt key Select the customer from the pick list 5 To search based on account type the account number in Account Based Search section and press the lt Tab gt or lt Enter gt key 6 The system displays the Accounts tab Accounts ORACLE r Customer Based Search Search Criteria Customer Short Name 1 Customer IC p e Customer Full Name Search String ie Home Branch E Customer ID Customer CRR Account Based Search Account Number Customer CRR Customer ID a Home Branch Field Description Column Name Description
23. Customer CRR Display Account Driving Customer CRR Initiated By Authorized By This field displays the Customer CRR code and the corresponding description Display This field displays the account number which is responsible for the customer CRR Display This field displays the user name can be SYSTEM who initiated this movement Display This field displays the username can be SYSTEM who authorized this movement ORACLE Universal CRR History CRR Enquiry Customer w Search String Account Number 50000000309611 r Information Customer ID 603898 Customer IC ASHISH09111977 Customer Name ASHISH S GOKHALE Customer CRR 10 Standard Home Branch MAIN BRANCH AKG GILSASA Current Arrear Details Arrear Details as on NPA Date Crr Evaluation Details Date Universal CRR Initiated By Authorized By 31 12 2013 O fsdafsad TDINESH system 31 12 2013 3001 LOSS ASSET I SYSTEM SYSTEM o fo 4 gt Field Description Field Name Description Date Display This field displays the date of movement of Universal CRR The details are displayed in descending order of date Universal CRR Display This field displays the Universal CRR code and the corresponding description Initiated By Display This field displays the user name can be SYSTEM who initiated this movement Authorized By Display This field displays the
24. External File Setup 2 The system displays the External File Setup screen External File Setup ORACLE External System Code File Type Processor Type Output Template Deferred Auth Required Relative Path XFF File Name Output File Helper Class Output Folder Helper Class Future Date Allowed Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description External System Mandatory Numeric 40 Code Type the external system code against which the file was uploaded in this field File Type Mandatory Alphanumeric 40 Type the file type in this field Processor Type Mandatory Drop Down Select the processor type from the drop down list The options are e UPLOAD e EXTRACTS ORACLE Field Name Description Format Mandatory Drop Down Select the format in which file has to be uploaded extracted from the drop down list The options are e D DataBase e G GEFX e X EXTRACT 3 Enter the external system code and file type or select from the pick list External File Setup External File Setup W External System Code AP_BA_MIS_EXTRACT MIS Extract File Type AP_BA_MIS_EXTRAXT MIS Extract Processor Type EXTRACTS Format EXTRACT Common Parameters Gefu Setup GL Setup Gefx Setup Output Template Deferr
25. Rule Details SC History SC Code Financial Year 2006 Cumulative Count of Tre ansactions oo Cumulative Amount of Transactions 0 0 SC Charged 0 0 Differential SC Charged 0 0 SC Amount Waived SC Amount Earmarked o 0 Field Description Field Name Description SC Code Display This field displays the service charge code for which the user can view the summary Financial Mandatory Drop Down te Select the year for which the data is saved from the drop down list Column Name Description ORACLE Column Name Description Description Display This column displays the description of the service charges applied The options are e Cumulative Count of Transactions It denotes the total count of transactions which triggers the selected SC including free transactions e Cumulative Amount of Transactions It denotes the total transaction amount which triggers the selected SC including free amounts e SC Charged It indicates the actual amount of selected SC levied on the account e Differential SC Charged It indicates the additional or reduced charges levied on an account due to presence of certain positive negative benefits such as variances as compared to the normal rate prevalent at the time of charging e SC Amount Waived It denotes the amount of charges waived either due to NSF situation or waivers at the discretion of teller e SC Amount Earmarked It i
26. This column displays the date of updating the classification Previous CRR Display This column displays the CRR of the account prior to change on the corresponding date New CRR Display This column displays the new CRR of the account on the corresponding date Reason Display This column displays the reason for which the CRR was changed Initiated By Display This column displays the user who has initiated the CRR movement against each movement Authorized By Display This column displays the user who authorised the transaction performed by the initiator Customer CRR History ORACLE CRR Enquiry f FR m Search Criteria Customer Search String Account Number 50000000309611 r Customer Information Customer ID 603898 Customer IC ASHISH09111977 Customer Name ASHISH S GOKHALE Customer CRR 10 Standard Home Branch MAIN BRANCH Account CRR Account Details CRR History KOPSA SAAGA ESA Universal CRR History Current Arrear Details Arrear Details as on NPA Date Crr Evaluation Details Date Customer CRR Account Driving Customer CRR Initiated By n 31 12 2013 3005 ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLM 50100000302391 SYSTEM SYSTEM 0 fo 4 gt Field Description Field Name Description Date Display This field displays date of movement of Customer CRR The details are displayed in the descending order of date
27. dated records are clubbed in one file the system will process all records during the upload and if for the upload date any future dated transactions are envisaged the same are treated as non processed and will not be picked up by the system in future However the back value dated transactions are processed on any processing date Hence the bank has to create different files for different value dates and then input the file processing date also as the future date in this option Then accordingly the file will be processed on the specific future value date FLEXCUBE will block uploads depending upon the setup combination for External System Code File Type Department Code and Template Code System allows for maintenance of Aadhaar number and Aadhaar linked account via upload This file will have to be manually uploaded Authorization is required to upload this file This file will have to be manually uploaded using External System Code CUSTOMER and File Type label as AADHAAR and File Type name should be AADHAAR_ACCOUNT_LINKAGE Authorization is required to upload this file The new checksum logic for OCA files is as below e Record checksum will be Ref_sys_no Sum of digits of account in an incremental pattern where every next instance is considered as complete number Amount to be considered in full without decimal Cheque Date e Footer Checksum will be Sum of Part 1 last 7 digits of all record level checksum of all rec
28. opened If not the SC package linked at the product level is attached to the account Using this option you can modify or customise an SC package for a CASA The following changes can be made to the SC package attached to the account e Waiver of specific all Service Charges for an account e Changes to SC capitalisation parameters e Modification of SC priority that will be effective in case NSF situation is encounter when charging periodic charges Definition Prerequisites e SCM01 SC Package Definition Modes Available Add Modify Delete Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To modify service charge package for an account 1 Type the fast path SCMO3 and click Go or navigate through the menus to Transaction Processing gt Account Transactions gt CASA Account Transactions gt Other Transactions gt SC Package Changes at Account 2 The system displays the SC Package Changes at Account screen SC Package Changes at Account ORACLE Package Details _ Charge Package _ Record Details Input By Field Description Field Name Accoun t Level SC Waiver Flag Description Account Details Account No Name Customer ID Status Mandatory Numeric 14 Type the account number of the customer for which you want to perform the SC package changes inquiry Display This field displays the short nam
29. Billing Information Maintenance ORACLE Search Criteria iF vij ID Full Name Search String j J Ic Customers Registered With Billing Companies J Bill Company ID Customer Bill Code eT ey Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Modity Delete Cancel Amend O Authorize Inquiry oo A ok chose cer Field Description Field Name Description Search Criteria Mandatory Drop Down Select the search criteria to search for the customer from the drop down list The options are e Customer short name e Customer IC Identification criteria arrived at by the bank during customer addition e Customer ID Unique identification given by the bank ORACLE Field Name Search String Full Name Customers Registered with Billing Companies Bill Company ID Description Mandatory Alphanumeric 20 Type the search string to search for a customer corresponding to the search criteria selected in the Search Criteria field If the search criterion is specified as customers short name or IC then any of the letter s of the short name or IC can be entered The system displays the pick list of all those customers having those letters in their respective criteria Select the appropriate customer from the existing customer list For example The c
30. Click the OK button 6 The system displays the message File Upload in Progress Please see the status through BAM 96 screen Click the Ok button ORACLE Generic External File Upload External System Code File Type Upload File File Details ecor Input File Addtionataris tiz Process None istAdd Upload Date 02 20 2 EE Dane Batch No fi 120 No on j 4 File Size Record Data TON PARK NEW YORK NY Previous Next ST043 Load Inward Remittance File The bank provides the facility of Electronic Clearing System ECS to its customers to make payments to various utility service providers Via ECS the customers accounts are directly debited for the payable amount ORACLE Using this option you can upload a bulk list of all customers whose accounts need to be debited with such inward direct debits This inward remittance file must be maintained in pre defined format and this file must exist on the application server in the RJSin folder Definition Prerequisites Not Applicable Modes Available Not Applicable To load an inward remittance file 1 Type the fast path ST043 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Handoff gt Load Inward Remittance File 2 The system displays the Load Inward Remittance File screen Load Inward Remittance File Load Inward Remittance File Agent Code ia Currency Code
31. Down Select the stock code if you want to perform the inquiry based on the status of a particular stock or inventory item from the drop down list Mandatory Drop Down Select the user ID if you want to perform the inquiry based on the user who has placed the request from the drop down list Conditional Drop Down Select the transaction type from the drop down list The options are e All Will display stock transactions in all statuses e Receipts Will display all stock that is in Receive status e Issues Will display all stock that is in Issued status e Orders Will display all stock for which purchase order is placed e Requests Will display all stock for which request is placed This field is enabled only if the Stock Transactions option is selected in the Stock Inquiry field Mandatory Pick List dd mm yyyy Select the date from which you want to perform the inquiry from the pick list Mandatory Pick List dd mm yyyy Select the date up to which you want to perform the inquiry from the pick list ORACLE Field Name Description Indent Request Mandatory Pick List PorSrence fr Select the indent request reference from the pick list to view the stock status based on the indent request reference The result for indent request reference will show the supplier code the date of order placement in the Purchase Detail tab Purchase Order Mandatory Pick List neterente Select the purchase order reference
32. Dr Cr Using this option you can post an entry between two GLs using the Miscellaneous GL Transfer Dr Cr option The From GL account will be debited and the to GL account will be credited After the transaction is successful the user can inquire on GL transactions and movements on GL accounts using GL Transactions and Movements Fast Path GLM04 option You can use GL To GL Funds Transfer Request Fast Path 1094 option for future dated GL transfers Definition Prerequisites e BAM97 Currency Codes Cross Reference e BAM99 GL Codes Cross Ref Maintenance Modes Available Not Applicable To debit miscellaneous transaction to general ledger account 1 Type the fast path 1005 and click Go or navigate through the menus to Transaction Processing gt GL Transactions gt Transfer gt Miscellaneous GL Transfer Dr Cr 2 The system displays the Miscellaneous GL Transfer Dr Cr screen Miscellaneous GL Transfer Dr Cr From Acct Cey From GL Acct no T EJ To Acct Cecy To GL Acct No ji Ta Acct Ccy Rate Txn Cecy Rate From Amount To Amount Reference No User Reference No Narrative Miscellaneous GL Xfer ORACLE Field Description Field Name Description From Acct Mandatory Drop Down Currency From GL Acct No To Acct Currency To GL Acct No Acct Currency Rate Txn Currency Rate From Amount Select the GL currency in which the From GL Account wi
33. Drop Down Select the criterion based on which you want to perform the inquiry from the drop down list The options are e Branch e Entity e Entity and Branch e Date e ID Conditional Pick List Select the name of entity from the pick list This field is enabled if the user selects the Entity or Entity amp Branch option in the Criterion field Conditional Drop Down Select the branch to which the download has been performed from the drop down list If the user selects the Entity or Entity amp Branch option in the Criterion field the branch code is defaulted to the teller login branch Conditional Pick List dd mm yyyy Select the date from which you want to view the details of download which have taken place to the branch from the pick list This field is enabled if the user selects the Date option in the Criterion field Conditional Pick List dd mm yyyy Select the date up to which you want to view the details of download which have taken place to the branch from the pick list This field is enabled if the user selects the Date option in the Criterion field Conditional Alphanumeric 20 Type the ID This field is enabled if the user selects the option ID option in the Criterion field Description ORACLE Column Name Description Name Requester Display This column displays the name of the branch that has requested for the download Name Entity Display This colu
34. From Inventory Branch Date of Receipt Description Mandatory Pick List Select the purchase order number which is used to track the purchase order status from the pick list On receipt of the stock from supplier this purchase order number is used to indicate receipt Mandatory Pick List Select the supplier from whom the stock is received from the pick list Mandatory Drop Down Select the inventory branch that has placed the request for the stock from the drop down list Mandatory Pick List dd mm yyyy Select the date of receipt from the pick list The receipt date cannot be greater than the current date Column Name Description Srl No Display This column displays the system generated serial number for each stock item in the list Request id Display Stock catalog Code Denm Qty req Series This column displays the request ID for each stock item in the list Display This column displays the stock catalogue code of the stock or the inventory item for which the request order is placed Display This column displays the denomination value of the requested stock Display This column displays the quantity of stocks In case of partial receipt for the stock request the user can modify the original values to reflect the received stock values The quantity can be reduced from the original requested but cannot be increased For example 50 units of banker s cheque It can b
35. Input File Post Process Field Description Field Name Description ORACLE Field Name Description Agent Code Mandatory Pick List Select the agent code that the bank maintains from the pick list The agent code is typically a code assigned to the banks where the beneficiary of the inward direct debit hold their accounts The bank will debit the customer s account and beneficiary account and the agent bank would be credited The beneficiary accounts of the inward direct debit will be maintained in several agent banks Hence the bank will maintain a separate inward remittance file for each agent bank Currency Code Mandatory Drop Down Select the currency code from the drop down list The inward remittance file is maintained based on currency All the inward direct debits in a particular currency to an agent bank will be maintained in a single file Input File Mandatory Alphanumeric 20 Type the name of the inward remittance file maintained in the RJSin folder on the application server Post Process Optional Check Box Select the Post Process check box to convert the file in the acceptable format 3 Enter the agent code and press the lt Tab gt or lt Enter gt key or select it from the pick list 4 Enter the required information in the various fields Load Inward Remittance File ORACLE Inward Remittance File 5 Click the Ok button 6 The system d
36. Miscellaneous GL Transfer Dr Cr From Acct Cey From GL Acct no 100099000 ARK wa To Acct Cey tr A E 7 To GL Acct No 110001002 al EJ Acct Ccy Rate 60 00000 Txn Ccy Rate 60 00000 From Amount 1 000 00 To Amount Reference No 2 User Reference No fi Narrative Miscellaneous GL Xfer 5 Click the Ok button 6 The system displays a message Authorization Required Do you want to continue Click the Ok button 7 The system displays the Authorization Reason screen Enter the required information and click the Grant button The system displays the transaction sequence number message box The transaction number is system generated that uniquely identifies each transaction performed by a teller and can be used for tracking the transaction Click the Ok button 10 The system displays the serial number Click the Ok button Note For more information on Authorization transactions refer to the FLEXCUBE Introduction User Manual 1905 Cross Cost Center Miscellaneous GL Transfer Dr Cr Using this option you can post debit and credit transactions between two GL accounts The GL accounts can be transacted in any branch If the transaction takes place across the branches then at the end of day system will pass the inter branch accounting entries Your can select the product code for the Dr and Cr account number The selected product code would be stamped in the transaction log and
37. Name Description To Branch To User Adjustment Quantity Series Number Start Number End Number Adjustment Total Value Reason For Adjustment Mandatory Drop Down Select the appropriate to branch from the drop down list Mandatory Pick List Select the user for whom the adjustment transaction is performed from the pick list Mandatory Numeric 10 Type the inventory quantity to be adjusted Mandatory Numeric 12 Type the series number of the stock to be adjusted Mandatory Numeric 10 Type the start number in the stock series The stock has to be transferred from this number onwards Display This field displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 Display This field displays the adjustment total value based on the denomination and quantity specified Adjustment Total Value Denomination Quantity For example If Denomination 100 and Quantity 20 Then Adjustment Total value 2000 Only stock or inventory items tracked denomination wise will have adjustment total value Mandatory Alphanumeric 40 Type the reason for adjusting the stock or the inventory item 3 Select the stock code from the drop down list 4 Enter the required information in the various fields Stock Adjustment ORA
38. Ok to Continue Click the Ok button 7 The service charge package details for an account are modified Note To change the sequence order of the Service Charge Code select the code and click the Up or Down button Double click the toggle status in the Waiver Flag Waive Uncharged column corresponding to the SC code you want to waive SCMO05 SC History for Account Inquiry Using this option you can view all the service charge details charged or overdue on an account over a period of time The inquiry is used to view e Detailed information of all the Service Charges levied for the account up to the current date e Complete details of all the Service Charges waived for the account till the current date e Service Charge amount earmarked due to non availability of funds e Service Charge history details like transaction counts for Service Charge e Additional Service Charge history details like counts amounts for current period month year rolling year and since inception Definition Prerequisites Not Applicable Modes Available Not Applicable To view the service charge details for an account 1 Type the fast path SCM05 and click Go or navigate through the menus to Transaction Processing gt Account Transactions gt CASA Account Transactions gt Inquiries gt SC History For Account Inquiry 2 The system displays the SC History for Account Inquiry screen SC History for Account Inquiry ORACLE
39. Package Details Service Charge Package Account Level SC Waiver Flag s no 1 1002 INR PASSBOOKISSUE SCPERIODIC NOLINK I 1 Anniversary Monthly n ol N N 2 Ji INR I a E N N a Ju o I N N a 122 INR gt N N s esi o E E N N e esi nr E E N N 7 e01 INR X g E N N E 303 INR ji gt a E N N 9 B14 INR E N N 10 1000 NR N N 11__ 1o01 o z E E N N 12 1001 iNR z E N N 13 1011 INR z l E N N 14 1016 opp ji al N N 15 1036 NR ji z N N 16 2020 usp ji z N N 17 2134 INR j z N N 18 2151 INR i z N N 19_ 2501 o E E N N 20 3203 INR ji N N 21 4202 INR ji N N 22 6001 INR N N 23 e005_ o E 3 e N N 24 6005 INR ji E m Fi N N 25 _ eo10 o E E N N 26 6010 INR z E E N N 27 6020 INR j 5 a E N N 28 6101 INR ji N N 29 7000 iNR N N 20 7002 o z E l N N 31 7500 o z z E N N 32 s001 o z zl E N N 33 so02 o E N N z Record Details Input By Authorized By Last Mnt Action Authorized J u 7 on au F or a 2 ORACLE 5 Modify the relevant information and click the Ok button 6 The system displays the message Record Modified Authorisation Pending Click
40. Partial Write OfF Rear cE TEST r Write Off Details ne Normal Suspended OutStanding Writeoff OutStanding Writeoff Interest 2935 52 2935 62 oss o 0 63 Penalty Interest b no Dooa 0 Compounding Interest Arrears p a bo i Diverting Interest Arrears 0 bo o Post Maturity Interest o bo ooo o Fees SC oo bo Premium b p Ee jf Legal Fee bo n b i OutGoings Eoo 0 Eoo o Principal L 5 000 00 50000 InterestAcoued 7 0 0 Penalty Accrued l ooi Total Writeoff 5 984 05 Suspended Reversals 1 048 63 Net WriteOff 52535 62 Princ Provision Drawdown p 00 UnColl Int Prov Drawdown 5 00 m n se i a Clear 10 11 Click the Ok button The system displays the message Authorisation required Do You Want to continue Click the Ok button The system displays the Authorization Reason screen Enter the required information and click the Ok button The system displays the message The account has been writtenoff Click the Ok button ORACLE AC008 Provision Inquiry and Modification for Loans and Overdraft Using this option you can view the details of the provisioning group rate provisioning base and the individual provisioning amounts for a selected CASA Loan account The fields Discounted Cash Flow of Credit and Discounted Collateral Value can be modified based on which the provision calculation will be made An External system will provide th
41. Prerequisites Not Applicable Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add TBS acquirer POS ID 1 Type the fast path TBS02 and click Go or navigate through the menus to Global Definitions gt Channels gt TBS Acquirer Pos ID Maintenance 2 The system displays the TBS Acquirer Pos ID Maintenance screen TBS Acquirer Pos ID Maintenance Acquirer Institution Id GJ TBS Identification Code Channel Number Originating Branch Code Record Details fe By Authorized By Last Mnt Date ORACLE Field Description Field Name Description Acquirer Institution Id TBS Identification Code Channel Number Originating Branch Code Mandatory Numeric 11 Type the acquirer institution ID The institution ID is allotted to the bank by the central bank or the governing body for non branch channels like TBS ATM and POS Mandatory Alphanumeric 15 Type the TBS identification GL code This is a unique identification code for a particular ETBI that is installed in the bank There could be multiple ETBls in the same bank which are serviced by different branches Mandatory Numeric Eight Type the channel number pertaining to the TBS Identification Code Channel number refers to the various ports on the ETBI from where multiple service call line
42. S No Display This column displays the system generated serial number that indicates the row item number Collateral Id Display This column displays the unique ID of the collateral linked to the application Collateral Type Display This column displays the type of the collateral ID Collateral Value Display This column displays the actual lendable value of the collateral ORACLE 3 Type the application number and press the lt Tab gt or lt Enter gt key Application Collateral Delink Application Collateral Delink Application No 0100721080005 S No Collateral Id Collateral Type Collateral Value 1 CBZ1 Auto Collat 1 50 000 00 Close Clear 4 Click the Ok button 5 The system displays the Authorization Required Do You Want to Continue Click the OK button 6 The system displays the Authorization Reason screen 7 Enter the relevant information and click the Ok button 8 The system displays the message Stock Adjustment completed successfully Click the OK button Note For more information on Authorisation transactions refer to the FLEXCUBE Introduction User Manual BA434 Account To Collateral Inquiry Collateral refers to all property including the proceeds thereof assigned transferred or pledged to the bank by the customer as collateral for loans overdraft It also refers to other extensions of credit and all Capital Stock Mortgage Collateral Securities Colla
43. Select Area Default Branch Folder Select File File Name Download FileID Narrative Download file 6 Click the Ok button OR Click the View button to view the file This button is enabled only if the View option is selected in the Task field 7 If you click the Ok button the system displays the message Authorization required Do You Want to continue Click the Ok button 8 The system displays the Authorization Reason screen 9 Enter the relevant information and click the Grant button 10 The system displays the serial number Click the Ok button 11 The system displays a message File Request Submitted Successfully Click the Ok button 12 The system displays the transaction sequence number It is a system generated unique number Click the Ok button BAM 96 File Upload Inquiry GEFU Using this option you can inquire on the status of one or more files You can provide a set of filter criteria to inquire on particular files and their details These files can be viewed with record level details and further sub details of every record File reversal or cancellation can be done through the External File Processing Upload File Status Inquiry Fast Path BAM94 option Definition Prerequisites e BA452 File Upload GEFU ORACLE Modes Available Not Applicable To view upload file details 1 Type the fast path BAM96 and click Go or navigate through the menus to Transaction Processing
44. The system displays the Provisioning Parameters at Bank level for Loans and Overdrafts screen Provisioning Parameters at Bank level for Loans and Overdrafts ORACLE Provisioning Parameters at Bank level for Loan Provisioning Groups and Parameters E Provisioning Group x Provisioning Sub Group Components of Provisioning Base On Balnce Sheet Amount Outstanding Interest Outstanding Commitment Fee Off Balance Sheet Amount Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Co JLo cee e Field Description Field Name Description Provisioning Groups and Parameters Provisioning Mandatory Drop Down Group Select the provisioning group code from the drop down list The options are e Individually assessed e Commonly assessed These groups are maintained as part of Day 0 activity in the backend tables Provisioning Sub Mandatory Pick List Group Select the provisioning sub group code and description from the pick list The sub groups are maintained as part of Day 0 activity in the backend tables Additions can be made to these sub groups subsequently in the backend tables Components of Provisioning Base ORACLE Field Name Description On Balnce Sheet Optional Check Box Amount Select the On Balnce Sheet Amount check box to calculate the provision amount on the balance sheet amount i e
45. The system displays the Transfer Stocks screen Transfer Stocks Transfer Option Stock Code Denomination Code Series No E Quantity D Start No L End No Narrative Transfer Stacks Field Description Field Name Description Transfer Option Mandatory Drop Down Select the transfer option from the drop down list The options are e Sell to Vault Select this option to initiate a purchase of stocks e Buy from Vault Select this option to initiate a sale of stocks ORACLE Field Name Description Stock Code Mandatory Drop Down Select the stock code for the stock or inventory item which you want to transfer from the drop down list Denomination Mandatory Pick List Code Select the denomination code for the stock code being transferred from the pick list The denomination needs to be selected for inventory items such as traveler s cheque etc which are tracked denomination wise Series No Mandatory Alphanumeric 12 Type the number of the series from which the denominations starts Quantity Mandatory Numeric 10 Type the number of stocks that are being transferred For example 50 units of banker s check It can be 50 leaves or booklets of banker s cheque Start No Mandatory Numeric 10 Type the start number in the stock series This number onwards the stock has to be transferred End No Display This field displays the end number of the
46. aE a 185 5531 Download Upload FW srcti os es tS cca Sade aea oer cael sanan niani aaa kaa Eaa ae aE EEEE aA 187 5504 Download Upload Status Inquiry cceccceccseeeseeeeececeeeeeeeaeceeaeeeeeeeeseaeeeeaaeseeeeeeeeeees 189 Soo DOO LON einir E 191 Filo AG sanconsnsrennkanananni nana 196 BAM SCHEDULAR SETUP ccris onia a E a E eaS 196 BAMO4 External File SONA cs ceca secrete cheer caste paavend cette Hasvenacedacsbieeaadedtecdaae nana arrend tbr ened 202 BA450 LoopUp Code File Type Cross Reference cccecccececeeeeeeeeeneeeeeeeeseaeeeeaaeeseneeeaas 211 21043 Load howard Remittance Fe ceca esceyaiees obvuesis suru sean piveeeta davtasad dana ANS 219 21044 Ouiward Remittances Handati aerua Sa 222 8899 Upload Account Balanca Pile eanne pavvesgspniag minus as tnaa eee 225 CHIM4S Gheque Book Issue Upload arcuri a S E Ea 227 Feo ah e aU E A PE A EE E E A A E T T 228 BAM 6 File Upad Inquiry GEFU sects heres RA NESANA 231 7240 lt File Upad Siats AUI Y srann anaa e NAA A 239 8239 Upload Local File To Pawel nossa a 242 8240 File Upload To Finware Status MUY einsidan 244 BAA455 View File Processing Stalts orirersiriiriniriis sas iaira rtir eared dation niededparnmienvendelies 247 AS The Ch NOUI ar E E E 250 ORACLE Back Office ORACLE Back Office Back Office module is designed to collectively accommodate all the internal transactions in FLEXCUBE Retail Internal transactions are categorized as those
47. displays the Account Provision screen ORACLE Account Provision r Customer Based Search Search Criteria Customer Short Name Search String 1 Customer IC Customer ID Home Branch Customer Full Name Customer CRR Account Based Search Account Number a Customer CRR i Customer ID Home Branch Field Description Field Name Description Customer Based Search Search Mandatory Drop Down Criteria Select the search criteria to search for the customer from the drop down list The options are e Customer short name The short name of the customer e Customer IC Identification criteria arrived at by the bank during customer addition e Customer ID Unique identification given by the bank ORACLE Field Name Description Search String Customer Ic Customer Id Home Branch Customer Full Name Customer CRR Conditional Alphanumeric 20 Type the search string to search for a customer corresponding to the search criteria selected in the Search Criteria field If the search criterion is specified as customers short name or Customer IC then any of the letter s of the letter of the short name or IC can be entered The system displays the pick list of all those customers having those letters in their respective criteria Choose the appropriate customer from the existing customer list
48. displays the provision maintained at the account level The value will be the same as Expected Provision in case the Account Provisioning is set to Automatic Unsecured Amount Display This field displays the principal amount that is unsecured User Adjustment Mandatory Numeric 13 Two Type the adjustment amount This field will accept negative values also and the negative value will result in reduction in the account provision to that extent 8 To maintain provision details manually enter the relevant information in the Provision Adjustment tab and click the Ok button to save the data 9 Click the OK button 10 The system displays the message Authorisation required Do You Want to continue Click the Ok button 11 The system displays the Authorization Reason screen 12 Enter the required information and click the OK button AC004 Account WriteOff Using this option you can fully or partially write off the balances and arrears in the account In case of full write off you will not be allowed to modify anything other than commit the transaction while in partial write off you can to specify the amount of arrears to be written off against each type of arrears Additionally you can specify the amount of Provision Drawdown i e the amount to be taken from the provision GL for part write off Definition Prerequisites e LNO57 Loan Direct Account Opening Modes Available Not Applicable To write off the acco
49. files Optional Check Box Select the Generate InterBranch GL Flag check box to include bridge GLs for inter branch transactions Mandatory Pick List Select the designated branch for which the files need to be uploaded from the pick list Mandatory Pick List Select the suspense GL code that will be used for passing debit suspense entries from the pick list Mandatory Pick List Select the suspense GL code that will be used for passing credit suspense entries from the pick list This tab is enabled if the EXTRACTS option is selected in the Processor Type drop down list ORACLE External File Setup File Type External System Code AP_BA_MIS_EXTRACT Ji MIS Extract eps BA MIS _EXTRAXT Processor Type Common Parameters Gefu Setup GL E Gefx Setup Direction our Process SP Name Extarct O MIS Extract Format GEFx x Record Details By Field Description Field Name Authorized By Last Mnt Date Last Mnt Action Authorized Description Direction Process SP Name 7 Click the Ok button Conditional Drop Down Select the direction in which the file has to be uploaded from the drop down list The options are e IN e OUT This field is enabled if the Upload Commit Size is defined Optional Alphanumeric 40 Type the name of the SP process The system displays the message Record Added Authorisation Pe
50. from the pick list The registered customer will be billed for the services rendered to them by the company In addition the bank on behalf of the billing company will collect the payments ORACLE Field Name Description Customer Bill Code Optional Alphanumeric 20 Type the customer bill code The customer will be linked to the billing company on the basis of this code Click the Add button 3 4 Select the search criteria from the drop down list 5 Enter the search string and press the lt Tab gt or lt Enter gt key 6 Select the bill company ID from the pick list and enter the customer bill code IB Customer Application Billing Information Maintenance IB Customer Application Billing Information Maintenance Search Criteria Search String b EJ ID 603614 IC 11411111111111111111111 Full Name SACHIN Customers Registered With Billing Companies FE Bill Company ID i2 CJ Customer Bill Code l2 7 SSSSSSS_ _ _ S IP Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized add modiy O Delete O Cancel Anend Authorize 1 nquiry 7 Click the Ok button 8 The system displays the message Record Added Authorisation Pending Click the OK button 9 The customer registered with a billing company is added once the record is authorised BAIB6 IB Transaction Customer Relationship Cross Reference
51. gt Internal Transactions gt Handoff gt File Upload Inquiry GEFU 2 The system displays the File Upload Inquiry GEFU screen File Upload Inquiry GEFU External System Code File Type File Name User Id Upload Date File List Il Branch Code 240 Sanpoz mumear Status All v Process Date 01 01 1800 _ Field Description Field Name Description External System Code Optional Pick List Alphanumeric 40 Select the external system code against which the file was uploaded from the pick list or enter it The corresponding external system name is displayed in the adjacent field ORACLE Field Name File Type File Name User Id Status Upload Date Process Date Branch Code Description Optional Pick List Select the file type from the pick list The corresponding file type name is displayed in the adjacent field Optional Pick List Select the name of the file with extension from the pick list Optional Pick List Select the login ID assigned to the person who added the particular file from the pick list The set up of Id s is part of SMS functions The User ID is automatically picked up and stored by the system for every transaction Mandatory Drop Down Select the status of the file which is being inquired upon from the drop down list The options are e All Displays all file names irrespective of stat
52. inquire Column Name Description File Id Display This column displays the ID of the file which the user wants to inquire Description Display This column displays the default narration based on the transaction ORACLE Column Name Description Status Display This column displays the status of the file which the user has inquired The status can be as follows e Submitted e In Progress e Completed e Failed e All Upload Download Display This column displays the status of the file The status are e U e D Reason for failure Display This column displays the reason for the failure success of upload or download of the file Type the posting date and press the lt Tab gt or lt Enter gt key Select the status from the drop down list Enter the relevant information in the various fields Click the View button NO Oi 0 The system displays the file status File Upload Status Inquiry ORACLE Teller ID Posting Date 15 02 2008 Status All x Ref No Task 7 jFilerd Description Status Upload Download Reason for failure Hv ubmitte u uploaded View Cancel 8 Click the Cancel button 8239 Upload Local File To Finware This option is used to upload a file from workstation to branch server and update the upload table Definition Prerequisites Not Applicable Modes Available Not Applicable To upload local file to finware 1 Type the fast path 823
53. series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 Narrative Mandatory Alphanumeric 40 Type the narration based on the transaction By default the system displays narration depending on the transaction 3 Select the transfer option from the drop down list 4 Enter the required information in the various fields Transfer Stocks ORACLE Transfer Stocks Transfer Option Sel To vaut Stock Code 112 _ REGTEST x Denomination Code Series No 5001 1G Quantity 1000 Start No it 2001 endo 3000 Narrative Transfer OF Stocks 5 Click the Ok button 6 The system displays the message Authorization Required Do You Want to continue Click the OK button 7 The system displays the Authorization Reason screen 8 Enter the relevant information and click the Grant button Note For information on Authorization transactions refer to the FLEXCUBE Introduction User Manual IV011 Stock Inquiries Using this optionyou can perform several inquiries to assist in tracking inventory items or stock Inquiries can be performed at the following levels e Central Inventory Department Branch details related to the central inventory department and the branch can be viewed e Branch Level Only branch level details can b
54. short name or IC then any of the letter s of the short name or ID can be entered The system displays the pick list of all those customer s having those letters in their respective criteria Select the appropriate customer from the existing customer list For example The customer s short name is George Abraham One can search the above customer by entering Geo in the search string field Display This field displays the identification code of the customer A customer IC along with customer type is a unique method of customer identification across the bank covering all branches Based on the combination the system can identify the customer as an existing customer even when the customer opens a new account in another branch A social security number passport number birth certificate or corporate registration can be used as a customer IC Display This field displays the ID of the customer A customer ID is an identification number generated by the system after customer addition is completed successfully This running number unique to a customer across the system is generated after the system has identified the Customer IC and Customer Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system Display This field displays the full name of the customer Display This field displays the short name of the customer Column Name Descripti
55. teller can modify this rate within certain boundaries The teller s right to change the account currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Mandatory Numeric 22 Type the amount which will be debited from the From GL account ORACLE Field Name Description To Amount Display This field displays the amount that will be credited to the To GL account This amount will be in the To Account currency The transaction amount in transaction currency is converted to this amount in GL currency using the exchanges rates displayed earlier and automatically displayed by the system Reference No Mandatory Numeric 12 Type the reference number This field is provided to keep a reference number for the transaction for future use User Reference No Optional Alphanumeric 40 Type the user reference number assigned to identify the transaction This field is enabled or disabled depending on the profit booking being enabled or disabled for the particular transaction Narrative Mandatory Alphanumeric 40 Type the narration based on the transaction By default the system displays narration depending on the transaction 3 Select the from and to account currency from the drop down list and the corresponding account numbers from the pick list 4 Enter the from amount and the reference number Miscellaneous GL Transfer Dr Cr ORACLE
56. transaction history related tables only for handoff Breach of branch code based exchange rate variance set at the template will be validated for the login branch Reversal of the transaction will not validate the branch code currency code restriction for the GLs involved in the transaction ORACLE Definition Prerequisites e BAM97 Currency Codes Cross Reference e BAM99 GL Code Cross Ref Maintenance Modes Available Not Applicable To debit miscellaneous transaction to general ledger account 1 Type the fast path 1905 and click Go or navigate through the menus to Transaction Processing gt GL Transactions gt Transfer gt Cross Cost Center Miscellaneous GL Transfer Dr Cr 2 The system displays the Cross Cost Center Miscellaneous GL Transfer Dr Cr screen Cross Cost Center Miscellaneous GL Transfer Dr Cr From GL Branch From Acct Cey From LOB From Product Code From GL Acct No E To GL Branch ee To Acct Cecy To LOB To Product Code To GL Acct No E E Acct Cey Rate Txn Cey Rate From Amount To Amount Reference No User Reference No Narrative Cross Cost Center GLT i tote cancel Field Description Field Name Description From GL Branch Mandatory Pick List Select the appropriate GL branch for miscellaneous transfers from that branch from the pick list The list displays all the branches defined in FLEXCUBE ORACLE
57. transactions which are mainly performed at back office i e transactions that are not directly initiated by the customer in the system The complete range of transactions under this category covers specific global setup security and audit related activities apart from covering transactions on accounts like file upload and NPA non performing assets processing Key Features of Back Office module FLEXCUBE Retail Banking Solution offers the best features with an interactive interface that emphasizes on intelligent business logic for financial companies This manual is divided into various sub sections namely Delivery Channel Related Transactions This section describes the delivery channel related transactions which include global definitions for electronic banking channels automated teller machines ATM telephone banking service etc Security Management System SMS This section describes about the usage of various maintenances for security control and its utilities NPA Related Transactions This section describes the transactions that pertain to Non Performing Assets processing General Ledger Transactions This section covers all transactions pertaining to GL activities Collaterals This section describes about linking of collateral to the account Inventory This section communicates about the stock transactions pertaining to inventory maintenance The system facilitates the bank with uploading files for various transactions w
58. username can be SYSTEM who authorized this movement Current Arrear Details ORACLE CRR Enquiry fv R r Search Criteria Customer Search String Account Number 500000003096 11 r Customer Information Customer ID 603898 Customer IC ASHISH09111977 Customer Name ASHISH S GOKHALE Customer CRR 10 Standard Home Branch MAIN BRANCH Account CRR Account Details CRR History Customer CRR History Universal CRR History KOTUCUS UE BASIS Arrear Details as on NPA Date Crr Evaluation Details Select Arrear All gt wea Outstanding Principal Outstanding Interest 0 00 Outstanding Service Charge Arrear Date Arrear Type Arrear Amount Arrear Pending Last Paid Date eed E ese 1646 1 03 1990 31 12 2013 ic 1000000 1000000 01 01 1950 31 12 2013 ls 1500 1500 01 01 1950 o fo q 5 Field Description Field Name Description Select Arrear Outstanding Principal Outstanding Interest Outstanding Service Charge Drop down Select the required arrear type from the drop down list Based on the selection the outstanding arrears of that type are displayed The options are e All e Interest e Service Charge e Principal Display This field display the total of all Principal arrears outstanding as on Inquiry Display This field displays the total of all Interest arrears outstanding as on Inquiry Display This
59. you can facilitate the cross reference between the POS IDs dummy account and the POS branch Also every forwarder VISA Master Card which the bank interfaces with has to be configured through the POS Acquirer POS Id Maintenance option ORACLE Definition Prerequisites Not Applicable Other Prerequisites e GL Codes should be defined Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add POS acquirer POS ID 1 Type the fast path POSO1 and click Go or navigate through the menus to Global Definitions gt Channels gt POS Acquirer POS Id Maintenance 2 The system displays the POS Acquirer POS Id Maintenance screen POS Acquirer POS Id Maintenance POS Acquirer POS Id Maintenance amp PR Acquirer Institution 14 Cc Forwarder Institution Id Card Acceptor Identification Code Card Acceptor Terminal Id POS GL Account No Originating Branch Code CASH GL Account No CASH Branch Code Spend Class Spend Sub Class Record Details ia By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description ORACLE Field Name Acquirer Institution Id Forwarder Institution Id Card Acceptor Identification Code Card Acceptor Terminal Id POS GL Account No Originating Branch Code CASH GL Account No CASH Branch Code
60. 10 Standard Normal 10 Standard 50000000309611 10 Standard 10 Standard Normal 10 Standard f t 4 50000000310816 _ 50 Loss 50 Loss Suspended 50 Loss 50000000311210 50 Loss 50 Loss Suspended 50 Loss 50000000311220 __ 10 Standard 10 Standard Normal 10 Standard 50000000311476 10 Standard 10 Standard Normal 10 Standard 50000000311513 S0 Loss 50 Loss Suspended 50 Loss 50000000311542 10 Standard 10 Standard Normal 10 Standard 50000000311552 10 Standard 10 Standard Normal 10 Standard 50100000002165 _ o _ 10 Standard __ Normal_ ms 1 W 4 d Field Description Column Name Description Account Number Display This column displays the account number ORACLE Column Name Present Account CRR Expected Account CRR Accrual Status Present UCRR Include in Equalization New Account CRR New Accrual Status Recalled Account Status Description Display This column displays the current CRR of the account If the CRR movement is automatic then the system will display the account CRR as of the last classification frequency If the CRR movement is manual then the last CRR recorded by the user will be displayed Display This column displays the expected account CRR as of current date based on the classification plan attached to the account In case of amanual CRR movement the expected CRR helps the user to compare and maintain the ac
61. 1599995 10 Passbook 021599995 23 BDI 021599995 29 BARODD ln Io s l sfojnje lojio jio E lo la N aia lO Nin l l lolo iz iz iz jiz g Io ko Io lo lo lo IS 150000 Record Details _ Input By Authorized By Last Mnt Date Last Mnt Action Authorized ORACLE Field Description Field Name Description Purchase Order No Request No Date of order Supplier Code Reference no 1 Reference no 2 Column Name Display This field displays the unique purchase order number which is used to track the purchase order status On receipt of the stock from supplier this purchase order number is used to indicate receipt It will be generated based on the combination of supplier code and request number The supplier code first three digits will be prefixed to the request number First three digits Supplier code 001 002 Alphanumeric Next fourteen digits The request number generated by the system relating to Request No consisting of following Four digits Branch code of the purchasing branch one digit Request type Adhoc A Regular R nine digits Sequence number Mandatory Pick List Select the request number for which purchase order needs to be placed from the pick list The pick list displays only those request numbers against which there are no orders placed or p
62. 33860 sow CH N 000000055756 SOW LN N 000000055772 SOW ji LN N 000000055798 sow LN N 000000055814 ji SOW j LN N 000000064477 sow j CH N Record Details p By Authorized By Last Mnt Date Last Mnt Action Authorized C add Lick _clese_ ORACLE 8 Link the account for which TIN has to be generated 9 Click the Ok button 10 The system displays the Record Added Authorisation Pending Click Ok to Continue Click the OK button 11 The IVR TIN is generated one the record is authorised BAIB4 IB Bank Params Maintenance Using this option you can set the bank parameters for operating the internet banking facility and maintain GL accounts for Fee GL and banker s cheque issue GL This maintenance also allows you to decide whether the service charges for Internet Banking transactions are to be applied at EOD and the funds appropriation sequence for the debit transaction Note The system automatically authorises this transaction Definition Prerequisites e BAM20 Bank Codes Maintenance Modes Available Add Modify Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add IB bank parameters 1 Type the fast path BAIB4 and click Go or navigate through the menus to Global Definitions gt Channels gt IB Bank Params Maintenance 2 The system displays the IB Bank Params Maintenance screen IB Bank Params Maintenance ORACLE IB Ban
63. 5 000 00 Narrative GL Miscellaneous Credit Against Cash Field Description Field Name Description GL Ccy Mandatory Drop Down Select the GL currency of the GL account to be debited from the drop down list This can be different from the local currency Txn Ccy Mandatory Drop Down Select the transaction currency from the drop down list This field by default displays the account currency as the transaction currency While posting the transaction entries to the account the transaction currency is converted into the account currency and for posting the GL entries it is converted into the local currency of the bank GL Account Mandatory Pick List Select the GL account number from the pick list The GL name is populated adjacent to the GL account number This is the GL account in the transaction branch which will be credited ORACLE Field Name GL Ccy Rate Txn Ccy Rate Txn Amount GL Amount Reference Number User Reference No Description Display This field displays the exchange rate at which the GL account currency is converted to local currency of the bank to be used for converting the GL currency to the local currency of the bank The exchange rate values must be defined and downloaded The teller s right to change the GL currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Depending on
64. 9 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Others gt Upload Local File To Finware 2 The system displays the Upload Local File To Finware screen Upload Local File To Finware ORACLE Narrative File Upload to Finware Field Description Field Name Description File Description Mandatory Alphanumeric 255 Type the description of the file which is to be uploaded Task Display This field displays the upload status File Name Display This field displays the name of the file File ID Display This field displays the unique id of the file Narrative Display This filed displays the short description of the task Enter the file description and press the lt Tab gt or lt Enter gt key Click the Attach button The system displays the Upload Files screen Click the Browse button to select the file to be uploaded O n S w Click the Upload button The system displays the message file uploaded Please click on close ORACLE 7 Click the Close button 8 Click the OK button 9 The system displays the upload local file to finware details Upload Local File to Finware 5_4_test txt Narrative File Upload to Finware Flexcube x A File Request Submitted Successfully 10 The system displays the message File Request Submitted Successfully Click the OK button 11 The system displays the transaction sequence number Cli
65. Bill Payment transaction through Internet Note The system automatically authorises this transaction Definition Prerequisites Not Applicable Other Prerequisites e The CASA for the billing company should be opened with the bank before maintaining billing company details Modes Available ORACLE Add Modify Delete Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add billing company details 1 Type the fast path BAIB2 and click Go or navigate through the menus to Global Definitions gt Channels gt IB Bill Company Details Maintenance 2 The system displays the IB Bill Company Details Maintenance screen IB Bill Company Details Maintenance IB Bill Company Details Maintenance Company Id E pT Company Type Company Name Bill Information Available Payment After Due Date Payment Type Allowed Grace Period Days Cut Off Period Days Company Account No i Company Address Contact Person Phone Number Collection Center Code Bill Details File Name Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized A C Cancel Amend Authorize Inquiry Field Description Field Name Description Company ID Mandatory Alphanumeric Six Type the company ID It is the unique identification given to the service provider by the bank This ID is manually gen
66. CLE Stock Code Bankers cheque Denomination Type of Adjustment Cancelled x Adjustment Date 1 01 2008 E From Branch ks E From User a1 _suPER 16o TEBANG To User Adjustment Quantity Ir 100 Series Number 201 Start Number Coo oas End Number Adjustment Total Value 71 Reason For Adjustment cheque lost 6 Click the OK button 7 The system displays the Authorization Required Do You Want to continue message Click the OK button The system displays the Authorization Reason screen Enter the required information and click the Grant button 10 The system displays the message Stock Adjustment Completed Successful Click the OK button Note For information on Authorisation transactions refer to the FLEXCUBE Introduction User Manual 9019 Transfer Stocks When a teller initiates a buy or sell of a specific inventory item s to the vault teller it is termed as the transfer of stocks You have to enter the stock code denomination and the total quantity he she wants to purchase or sell for successful completion of the transaction Definition Prerequisites Not Applicable Other Prerequisites e V001 Stock Transactions Modes Available ORACLE Not Applicable To transfer the balance stock 1 Type the fast path 9019 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Inventory gt Transfer Stocks 2
67. Daily AED Inward Cheque Return Charges Others 12 Anniversary Daily AED Outward Cheque Return Charges Others 13 Anniversary Daily AED Dormancy Charges Periodic 14 Anniversary Daily AED Account Closure Charges Others 15 Anniversary Daily AED Duplicate Statement Charges Others 16 Anniversary Daily O cioa eoa em fo Ya se fon fe fe Je oVe Oo Bebo oso Oro OO o eo Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized a sd m Add C Modify Delete Cancel C Amend Authorize Inquiry _Ok Close Clear 6 The system displays the package details and the account details Package Details Package Details tab displays brief information of the service charges linked to the Service Charge package ORACLE SC Package for Customer Search Criteria Customer Short Name Search String Full Name David J Paul ID Icy ABC Service Charge Package 1 CURRENT ACCT CORPORATE Customer SC Waiver Flag 7 Package Details Account Details Code Ccy Description Type Priority CapType Cap Freq Anniv Day Anniv Month AED Low Bal Charges Current Acct Periodic 1Calendar Monthly 0 AED Semi Annual Handling Charges Periodic 2 Calendar Half Yearly AED TC Sale Charges Others 3 Calendar Daily AED TC Encashment Charges Others 4Anniversary Daily AED Cheque Discounting Charges Others 5 Anniversary Daily AED PDC Handling Charges Others 6 Anniversary Daily AED PDC Cancellation Charges Other
68. Double click the service charge amount in the Charges Applied Summary tab to enable the Charges Applied Details tab Charges Applied Details ORACLE count Inquiry Status Product 4 SC Details current Package C Expired Packages Filter Criteria All RP Account Level Product Level From Date To Date EE Charges Applied Charges Applied Summary Charges Applied Details Charges Due Rule Details SC History SC Code History Type Period Type 29 02 2008 0 00 S Cee J _clese _ _cleer_ Field Description Field Description Name SC Code Display This field displays the service charge code for which the charges summary is viewed History Display Type This field displays the information of applied service charge For example Cumulative Amount of Transactions or SC Amount Earmarked Period Display Type This field displays the period for the SC levied for the current month or financial year or calendar year Column Name Description Date Display This column displays the date on which the SC is applied ORACLE Column Name Description Amount Rule Applied Charges Due Display This column displays the SC amount debited from the account Toggle The status is Y if the rule is applied to the SC code it is applicable for SC of Periodic type and non branch based SC transactions The Rule Details tab is enabled if the us
69. E Column Name Account No Provisioning on Balance Sheet Amount Provisioning on Outstanding Interest Provisioning on Outstanding Commitment Fee Provisioning on Off Balance sheet Amount Total Provision Amount Date of Provision Provisioning Rate Description Display This column displays the account number Display This column displays the provisioning amount on the principal outstanding Display This column displays the provisioning amount on the outstanding interest receivable Display This column displays the provisioning amount on the outstanding commitment fee Display This column displays the provisioning amount on the off balance sheet amount Display This column displays the total provisioning amount which is a total of the above four provisioning amounts Display This column displays the date of provision Display This column displays provisioning rate for the account on which the corresponding provision has been calculated 3 Enter the account number and press the lt Tab gt or lt Enter gt key 4 Enter the relevant information 5 Click the Inquire button Provision Inquiry and Modification for Loans and Overdraft ORACLE Provision Inquiry and Modification for Loans and Overdraft Account Based Search Account Number 70000000419440 Name GEORGEDANNIELPAUL Provisioning Group Commonly Assessed Provisioning Sub Group Debit C
70. Name Description SC Code Display This field displays the service charge code for which the user can view the summary Column Description Name Description Mandatory Pick List Select the description of the service charges applied from the pick list The options are e Cumulative Count of Transactions It denotes the total count of transactions which triggers the selected SC including free transactions e Cumulative Amount of Transactions It denotes the total transaction amount which triggers the selected SC including free amounis e SC Charged It indicates the actual amount of selected SC levied on the account e Differential SC Charged It indicates the additional or reduced charges levied on an account due to presence of certain positive negative benefits such as variances as compared to the normal rate prevalent at the time of charging e SC Amount Waived It denotes the amount of charges waived either due to NSF situation or waivers at the discretion of teller e SC Amount Earmarked It indicates the amount earmarked for a retry when an NSF condition is encountered in the previous attempt to charge Current Display This column displays the SC information pertaining to the current anniversary period For example if the anniversary period for the service charge starts from January 25th and the current date is January 30th then this field displays the SC information between January 25th and January 30th
71. Numeric Five Type the number of rows that should be added in the cluster This field is applicable only if the user selects the Add Option in the Maintenance Option field Display This field displays the data of the accounts belonging to the selected branch Display This field displays the table for which the data is requested Select the criterion and request for from the respective drop down list The system enables or disables the table name and the branch depending on the criterion selected 5 Select the Add Option option from the Maintenance Option drop down list 6 Click the Ok button 7 The system displays the data entry section ORACLE 8 Select the DATA OF option from the drop down list Cluster Maintenance Cluster Maintenance Criterion Table Name gt Request For Host 7 Table Name User Profile table al Branch Maintenance Option Add Option gt Rows to Add 12 DATA OF FOR TABLE NAME ACF1 able ACF Js ACF1 ACF1 ACF1 ACF1 ACF1 ACF1 ACF1 ACF1 ACF1 ACF1 atia Ok cancel 9 Click the Ok button 10 The system displays the message Record Saved Successfully To delete download cluster Select the criterion and request for from the respective drop down list The system enables or disables the table name and the branch depending on the criterion selected Select the Delete Option option from the Maintenance Option drop down list Click t
72. Oracle FLEXCUBE Core Banking Back Office User Manual Release 11 6 0 0 0 Part No E65544 01 October 2015 ORACLE ORACLE Back Office User Manual October 2015 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2015 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently
73. Status Inquiry Using the File Upload Status Inquiry option you can inquire the status of the uploaded downloaded file Definition Prerequisites e 7239 Upload Local File To view file upload status 1 Type the fast path 7240 and click Go or navigate through the menus to Transaction Processing gt Internal Transaction gt Others gt File Upload Status Inquiry 2 The system displays the File Upload Status Inquiry screen File Upload Status Inquiry File Upload Status Inquiry Posting Date 31 12 2007 Status fan v Ref No Field Description Field Name Description Teller ID Display This field displays the ID with which the teller has logged in ORACLE Field Name Description Posting Date Status Ref No Task File Id Mandatory Pick List dd mm yyyy Select the date on which the file has been uploaded or downloaded from the pick list By default the system displays the current system date Mandatory Drop Down Select the status of the file which the user wants to inquire from the drop down list The options are e Submitted e In Progress e Completed e Failed e All By default Submitted option is selected Optional Alphanumeric Nine Type the reference number Optional Alphanumeric 35 Type the name of the task The user can inquire for the downloaded uploaded file Optional Alphanumeric 22 Type the ID of the file for which the user wants to
74. The name of the service charge package that is attached to the account ORACLE Field Name Description Customer SC Check Box Waiver Flag Select the check box if you want to waive all the service charges in the package It indicates whether the SC package attached to the account is marked for SC waiver or not 3 Click the Add button 4 Select the search criteria from the drop down list 5 Type the search string press the lt Tab gt or lt Enter gt key and select it from the pick list SC Package for Customer SC Package for Customer Search Criteria Customer Short Name Search String Full Name David J Paul ID 600075 IG ABC Service Charge Package 1 CURRENT ACCT CORPORATE Customer SC Waiver Flag D Account Details Code Ccy Description Type Priority CapType Cap Freq Anniv Day Anniv Month AED Low Bal Charges Current Acct Periodic 1 Calendar Monthly o AED Semi Annual Handling Charges Periodic 2 Calendar Half Yearly AED TC Sale Charges Others 3 Calendar Daily AED TC Encashment Charges Others 4Anniversary Daily AED Cheque Discounting Charges Others S Anniversary Daily AED PDC Handling Charges Others 6 Anniversary Daily AED PDC Cancellation Charges Others 7 Anniversary Daily AED Standing Order Set Up Charges Others 8 Anniversary Daily AED Standing Order Failure Charges Others Anniversary Daily AED Standing Order Amendment Charges Others 10 Anniversary Daily AED Stop Payment Charges Others 11 Anniversary
75. The search criteria to search for the customer The search criteria are as follows e Customer short name e Customer IC Identification criteria IC arrived at by the bank during customer addition e Customer ID Unique FLEXCUBE Retail identification given by the bank Mandatory The search string to search for a customer corresponding to the search criteria selected in the Search Criteria field If the search criterion is specified as customer s short name or IC then the beginning letter of the short name or IC can be entered The system displays the pick list containing customers who match the criteria Choose the appropriate customer from the pick list For example the customer s short name is John S Winter In this case you can specify the short name as JSW Display The full name of the customer The full name of the customer is defaulted from the Customer Addition option Display The ID of the selected customer A customer ID is an unique identification number generated by the system after customer addition is completed successfully This is the number that the system uses to track the customer Display The identification code of the selected customer A customer IC with customer type is a unique method of customer identification across the bank covering all branches A social security number passport number birth certificate or corporate registration can be used as Customer IC Mandatory
76. Using this option where the bank can define whether a customer depending upon his her relation with the account is allowed not allowed to perform a particular transaction The system allows ORACLE only for these customer relationship with the account to perform Internet banking transaction for the given transaction mnemonic Note The system automatically authorises this transaction Definition Prerequisites Not Applicable Modes Available Add Modify Delete Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add a cross reference between a customer relationship and an IB transaction 1 Type the fast path BAIB6 and click Go or navigate through the menus to Global Definitions gt Channels gt IB Transaction Customer Relationship Cross Reference 2 The system displays the IB Transaction Customer Relationship Cross Reference screen IB Transaction Customer Relationship Cross Reference IB Transaction Cu er R ynship Cross Reference Transaction Mnemonic a Customer Relationships Sole Owner Joint and Other Joint and First Joint Or First Joint or Other Trustee Guarantor Minor Authorised Signatoy r Record Details Input By Authorized By Last Mnt Date Last Mnt Action L Authorized CO Delete Cancel Amend I Authore x _ cese clear _ Field Description Field Name De
77. ally write off the amount of arrears Optional Drop Down Select the reason for write off factory shipped from the drop down list Display This field displays the type of arrears Display This field displays the extent of normal arrears outstanding against each type of arrear ORACLE Field Name Normal Write Off Suspended Outstanding Suspended Write Off Principal Interest Accrued Penalty Accrued Total WriteOff Suspended Reversals Net WriteOff Princ Provision Drawdown Description Conditional Numeric 13 Two Type the normal write off value in case the Partial Write Off option is selected In case the Full Write Off option is selected this column displays the amount that can be written off Display This field displays the extent of suspended arrears outstanding against each type of arrear Conditional Numeric 13 Two Type the suspended write off value in case the Partial Write Off option is selected In case the Full Write Off option is selected then this column displays the amount that can be written off Display This field displays the principal amount Display This field displays the interest accrued on this account that is yet to be capitalized Display This field displays the amount if penalty that is accrued from the last capitalization date Display This field displays the sum of total arrears principal and accrued interest to be writt
78. amend O Authorize O Ingu ok Chose 6 Click the Ok button 7 The system displays the message Record Added Authorisation Pending Click the OK button 8 The market calendar details are added once the record is authorised ORACLE Collaterals BAM46 Collateral Propagation When a Collateral is re evaluated the new value of the collateral needs to be applied This is applicable specifically for financial securities wherein the security value of the collateral changes as per market conditions and a feed containing value of each stock comes from the stock exchange Using this option propagation of collateral can be done which will trigger a change in the drawing power of the collateral whose value has changed Definition Prerequisites Not Applicable Modes Available Not Applicable To propagate re evaluation of a collateral 1 Type the fast path BAM46 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Collaterals gt Collateral Propagation 2 The system displays the Collateral Propagation screen Collateral Propagation ORACLE Collateral Propagation 1 Completed Field Description Column Name Description LO Code Display This column displays the local office code The local office represents a regional office under which all the branches within a particular territory are grouped So when the user propagates collateral to a local off
79. ards 2 Provisioning Rate 30 Customer Account Risk Category pi Discounted cash Flow of Credit ACy __ Discounted cash Flow of Credit LCv Discounted Collateral Yalue Acy Discounted Collateral Yalue LCY r Provision History FromDate 0171272007 To Date 15 01 2008 Heal 70000000419440 48225 o 174440 14976000 15198665 15 12 2007 30 70000000419440 24225 402 360509 33 14976000 15361136 33 31 12 2007 30 1 Jala 6 Click the Close button Examples on provisioning Example 01 Account Exposure 500 On balance 200 Off balance 50 Accrued Interest 20 Commitment fees and LV 800 1 P on balance eligibility 500 On balance 800 LV 300 A A lt 0 then provision P on 0 2 P interest eligibility 50 accr int 300 A remaining LV 250 B B lt 0 then provision P i 0 3 P commitment eligibility 20 com fees 250 B 230 C C lt 0 then provision P c 0 4 P off balance eligibility 200 230 C 30 D D lt 0 then provision P off 0 Example 02 Exposure 500 on balance 200 off balance 50 accr int ORACLE 20com fees and LV 300 1 P on balance eligibility 500 On balance 300 LV 200 A A gt 0 then provision P on 200 A 0 236 Provision rate 47 2 2 P interest eligibility 50 accr int O remaining LV 50 B B gt 0 then provision P i 50 B 0 236 Provision rate 11 8 3 P commitment eligibility 20 com fees 0
80. artial orders are placed Mandatory Pick List dd mm yyyy Select the date of request from the pick list This date must be a current or previous date and cannot be a future date Mandatory Pick List Select the approved supplier code from the drop down list The pick list displays the list of all approved suppliers Optional Alphanumeric 12 Type the first reference number Optional Alphanumeric 12 Type the second reference number Description Srl No Display This column displays the system generated serial number for each stock item ORACLE Column Name Request id Stock catalog Code Denm Qty req Series Start End Description Display This column displays the request ID for each stock item in the list Display This column displays the stock catalogue code of the stock or the inventory item for which the request order is placed Display This column displays the denomination value of the requested stock Mandatory Numeric Seven Type the quantity of stocks The user can modify the quantity of stocks requested at the time of placing an order The quantity can be reduced from the original requested but cannot be increased For example 50 units of banker s cheque It can be 50 leaves or booklets of banker s cheque Conditional Numeric 10 Type the series number that has been defined for the particular stock code Conditional Numeric 10 Type
81. ateral Value Account Currency Type Display This column displays the unique collateral ID Display This column displays the description for the collateral Display This column displays the ratio of the secured collateral linked to the limit and the gross collateral value as present in collateral header Display This field displays the gross collateral linked to the limit on the account Sum of share value should be less than or equal to total collateral value as defined in Collateral Header If collateral currency is different from account currency the conversion to account currency will be done as per the last mid rate of the last EOM for the collateral currency Display This field displays the actual lendable value of the collateral The conversion of collateral value from collateral currency to account currency will be done as per the last mid rate of the last EOM for the collateral currency Display This column displays the collateral type The types are e P Primary e S Secondary 3 Enter the account number and press the lt Tab gt or lt Enter gt key 4 The system displays the account to collateral details Account To Collateral Inquiry ORACLE Account To Collateral Inquiry Account No 000000007492 Currency ine First Previous o al a Next Last 517 Automobile 100 50 000 00 50 000 00 P 208 Finantial Security 100 25 000 00 25 000 00 P 516 Land 100 75 000 00 75 000 00 P
82. ber of records accepted Display This column displays the total number of records rejected Display This column displays the total number of records which are not processed Display This column displays the total number of records which are not processed Display This column displays the total debit amount Display This column displays the total debit count Display This column displays the total credit amount Display This column displays the total credit count Display This column displays the description of the transaction Display This column displays the status of the process processed or unprocessed 6 Double click on the appropriate record to enable the File Details tab File Details ORACLE External System Code File Type Al File Name D User Id sameer O Status Upload Date 6 09 fe Process Date E Branch Code 30 File List File Datailal Fle Summary Record Details Batch No 30 No of Records File Size File Comments 50100000000070 380S07S 240 2 1555 20491231 N Sameer Padhy FORM ok I 22 PROCESSED Erocessea Successfully ox cise _ciear_ Field Description Field Name Description Batch No Display This field displays the batch number of the selected file No of Records Display This field displays the total number of records in the selected file File Size Display This field displays t
83. cecccsseeecccsseeseseeecseuuauceesaeaueeeeeeeeseuaeeeeeanas 46 BAO92 Auto Relock Time Maintenance ccc ccc ccceccccceeecccsseeseseeeceseueeseesauaueeeeaeueeseuaueeseanas 48 COIE ieee lee ee oe Open OEE ree eT re Oe en eee Opie ree erie ere Re ere er 51 BAMAG Collateral PP OPiS UII cestcedasesscnsndstendus dense cecatecdaaconpcancdabuednuedids a E EAE a ER EaR 51 BAMA47 Application Collateral Delink sssrinin aaa i 53 BA434 Account To Collateral UQUINY sccnscccnesiecdan dense rcnsrsdaacenisssersieedaadeeisscaiinaebcadnesvene doen 55 BASS Collateral To Account MOUP sccscccccestecdaadentncasssaFaarcensssctaieedandoeidssettberteadeniitebataadenls 58 Asset Classification Transaction icscscccicecsccttesssstetvessncdteeactadvesanadteesnatedscsanstosasttivessauanesastienauas 62 AC001 Account Classification Preferences c ccssssssssssssesssssssssscesssesesssssssesessssrsssserereees 62 ACO ORE lly e cae er niia een emt a eer ete entre Ter entrnrn erate 64 FS Account Provisio ecnin E eeel 80 FOO Account Wro fi orenen EA A R TN 89 AC008 Provision Inquiry and Modification for Loans and Overdraft cccccsscecsesteeeeeees 94 ACM607 Provisioning Parameters at Bank level for Loans and Overdrafts ccssceeeeee 99 General Ledger Transacuons isscc ascites nine 103 1060 GL Miscellaneous Debit Against Cash 00 ccccccecsceenceceeeeeeeaeeeeneeseseeeseaeeesaaesneneeeeaees 103 1460 GL Miscellaneous Credi
84. ch D shall does not belong to the Cluster for Branch A for the ch_acct_mast table Download Process When Branch A requests the Host for download of ch_acct_mast table download scheduler will consider Cluster Maintenance for this table and will extract data of accounts belonging to Branches A B amp C After extraction the system and loads the data into Branch A database Similarly when Branch B and Branch C trigger download of table ch_acct_mast from host the system downloads data of accounts for their own respective branches since Cluster Maintenance is not maintained for Branch B and Branch C Definition Prerequisites Not Applicable Modes Available Not Applicable To add download cluster 1 Type the fast path 8890 and click Go or navigate through the menus to Operator Processes gt Data Download Options gt Cluster Maintenance 2 The system displays the Cluster Maintenance screen Cluster Maintenance ORACLE Cluster Maintenance Criterion Table Name gt Request For Host gt Table Name User Profile table Branch 999 Maintenance Option Add Option z Rows to Add fi2 DATA OF FOR TABLE NAME acrid Se file table faci Jser Profile table fact ser Profile table faci User Prot faci Jser Profi faci Jser Profi faci Jse faci Jser Profi Field Description Field Name Description Criterion Mandatory Drop Down Select the appropriate criteria from the drop down list It ind
85. ck Adjustment screen Stock Adjustment ORACLE Stock Adjustment ES 2 E Stock Code v Denomination Type of Adjustment Adjustment Date 1 01 2008 E From Branch E x From User i Hb To Branch To User Adjustment Quantity Series Number Start Number End Number Adjustment Total value Reason For Adjustment Field Description Field Name Description Stock Code Mandatory Drop Down Select the stock code for the stock or the inventory item you want to make adjustment to from the drop down list Denomination Conditional Pick List Select the denomination code for the stock code being transferred from the pick list The denomination needs to be selected for inventory items such as traveler s check etc which are tracked ORACLE Field Name Description Type of Mandatory Drop Down Adjustment Select the type of adjustment from the drop down list It is the status the user wants to amend the inventory item to The options are e Cancelled A teller can mark a reversed banker s cheque issue transaction as Cancelled Since the instrument has already been marked as Used the system does not update the status of the instrument e Duplicate If a customer reported a TD certificate as lost and has a duplicate issued the teller can mark it as duplicate Since the original certificate has already been marked as Used the system does not up
86. ck the OK button 12 The system displays the upload file Id Click the OK button 8240 File Upload To Finware Status Inquiry This screen is used to inquire the status of uploaded files to Finware Definition Prerequisites e 8239 Upload Local File To Finware Modes Available Not Applicable To inquire the status of file upload to finware 1 Type the fast path 8240 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Others gt File Upload To Finware Status Inquiry ORACLE 2 The system displays the File Upload To Finware Status Inquiry screen File Upload To Finware Status Inquiry ile are quii Teller ID SUMA z Posting Date 15 01 2008 Status All X Ref No Task I Filetd f Field Description Field Name Description Teller ID Conditional Drop Down ree the Teller ID for which you want to search the upload etails This field is enabled for supervisor Posting Date Mandatory dd mm yyyy Type the posting date for the file upload ORACLE Field Name Description Status Ref No Task File Id Column File Id Description Status Upload Download Reason for failure Optional Drop Down Select the status for which you want to inquire the details The options are e All e Completed e Failed e In Progress e Submitted Optional Alphanumeric 255 Type the reference number for which you want t
87. count CRR Display This column displays the current accrual status of the account Display This column displays the Universal CRR of the account Display It displays Y in case the account is included for equalization else it displays N Display This column displays the new CRR value for each account of the customer if any change has been done by the user Display This column displays the new accrual status for each account of the customer based on the new CRR Display This column displays the recalled status of the account N indicates that the account is not recalled and Y indicates that the account is recalled Display This column displays the status of the account 3 Click the account number row to activate other tabs Account Details ORACLE CRR Enquiry amp rR r Search Criteria Customer Search String Account Number 50000000311552 r Customer Information Customer ID 603898 Customer IC ASHISHO9111977 Customer Name ASHISH S GOKHALE Customer CRR 10 Standard Home Branch MAIN BRANCH Account CRR PESME CRR History Customer CRR History Universal CRR History Current Arrear Details Arrear Details as on NPA Date Crr Evaluaton Details r CRR Details Account Number 50000000311552 Recalled Account E Actual Date Of Classification Present Account CRR 10 Standard Accrual Status Normal r Loan Account Details CASA
88. ct the appropriate criteria from the drop down list It indicates the criteria on which the download schedule is maintained The options are e Table Name If the user selects this option it specifies that the schedule has been set up for only one branch code and more than one table e Branch Code If the user selects this option it specifies that the schedule has been set up for only one table and more than one branch e Both If the user selects this option it specifies that the schedule has been set up only for a specific branch and a specific table ORACLE Field Name Request For Table Name Branch Maintenance Option Rows to Add Column Name Table Name Description Mandatory Drop Down Select the entity for which the request has been made from the drop down list The options are e Host If you the user selects the request for Host option the schedule for download will reside on the host database and will be executed in the Central application server as per specified frequency e Branch If the user selects the request for Branch option the schedule for download will reside on the branch database The branch server will execute the download process as per the specified frequency By default this field displays the Host option as scheduling forms part of host activity i e the Central Database Conditional Pick List Select the table name for schedule maintenance from the pick l
89. cy derived from the product under which the account was opened Credit Risk Rating ORACLE Field Name Description Movement Include in Check box Equalization Select the check box to include in equalization Classification Pref Mandatory Pick list Plan Code Select the Classification preference code from the pick list Classification Criteria Mandatory Pick list Plan Code Select the classification criterial plan code from the pick list Provision Plan Code Mandatory Pick list Select the provision plan code from the pick list Classification Check box Required Select the checkbox if classification is required 3 Click the Modify button 4 Enter the account number and press the lt Tab gt or lt Enter gt key 5 Enter the required details 6 Click the OK button 7 The system displays message Record Modified Authorisation Pending Click Ok to Continue Click the OK button 8 The account classification preferences details are modified once the record is authorised AC002 CRR Enquiry FLEXCUBE enables classification of an account into one of the Credit Risk Ratings depending upon the performance of the asset The record with the lowest CRR Code numeric value will be treated as the best category and the one with the highest CRR code as the worst Using this option you can inquire about CRR movement and view the CRR Movement history The system provides information on present CRR new CRR t
90. d depending on capitalisation frequency irrespective of anniversary day anniversary month e Anniversary SC application date depends on capitalisation frequency and anniversary day anniversary month Cap Freq Display The service charge capitalisation frequency i e the time intervals at which the bank will levy the service charge The options are e Daily e Monthly e Bi monthly e Quarterly e Yearly Anniv Day Display The anniversary day of the SC package Anniv Month Display The anniversary month the SC package Account Details The Account Detail tab lists all the existing accounts for which the selected customer is a primary customer In this section the user can link the new SC package to specific existing account s An Effective Date can be mentioned for the package to be effective from a future period for the existing accounts ORACLE SC Package for Customer Search Criteria Customer Short Name Search String Full Name David J Paul ID 600075 IG ABC Service Charge Package fi CURRENT ACCT CORPORATE x Customer SC Waiver Flag 7 Package Details Account Details Date Effective 05 10 2004 EE Account Number Service Charge Package 600075001001 600075151001 600075151002 Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized C L C C m Add C Modify Delete Cancel C Amend C Authorize Inquiry Ok Close Clear Field Descript
91. d File Name wild card Scheduler Type v a Record Details i By Authorized By Last Mnt Date Last Mnt Action Authorized 5 Enter the required information in the various tabs Common Parameters ok _ close clear _ ORACLE SCHEDULAR SETUP External System Code AP_ci TADI y El File Type P_CH_ENTRACT_ADHe cer E ID E I Common Paramei ters Frequency Scheduler S Stup Event Scheduler Setup Start Date 01 01 1800 es End Date isrozr2o0s Ite Upload File Name wild card Schedular Setup Scheduler Type EVENT v Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description Start Date Optional Pick List dd mm yyyy Select the start date from the pick list End Date Optional Pick List dd mm yyyy Select the end date from the pick list Upload File Optional Alphanumeric 20 Name wild card Type the upload file name Scheduler Type Mandatory Drop Down Select the type of scheduler from the drop down list The options are e EVENT e FREQUENCY e TIME 6 The system enables the relevant tab based on the appropriate option selected from the Scheduler Type drop down list ORACLE Time Frequency Scheduler Setup External System Code File Type AP_CH_E ADHOC CAP E ID Common Parameters Time Frequency Sc
92. dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and i
93. date the status of the instrument e Found If a branch is able to locate the lost inventory item itis marked as Found e Lost During the receipt if an inventory item is found lost it is marked as Lost e Returned When an inventory item is returned on an account that it is above the excess level it is marked as Returned For example excess inventory at branch level for stock code A is 100 units Branch Z holds 102 units Branch Z will mark 2 units of stock A as Returned e Torn If a check book is found to be torn after receipt the teller can mark it as Torn e Used If the instrument serial number is wrongly entered during an offline transaction then the actual instrument number used can be updated with the used status e Rejected If a stock item is not issued as per the request order it can be rejected For example if the central inventory department requested USD TC of denomination 100 and the supplier issued INR TC of denomination 100 that were marked as received then these TCs can be marked as rejected Adjustment Date Mandatory Pick List dd mm yyyy Select the appropriate date of adjustment from the pick list By default this field displays the current posting date as date of adjustment From Branch Mandatory Drop Down Select the inventory branch from the drop down list From User Mandatory Pick List Select the user who is performing the adjustment transaction from the pick list ORACLE Field
94. de refer to Standard Maintenance Procedures To view the file processing status 1 Type the fast path BA455 and click Go or navigate through the menus to Transaction Processing gt Internal Transaction gt Inquiries gt View File Processing Status 2 The system displays the View File Processing Status screen View File Processing Status ORACLE Upload Date isjo1jzoos ES Branch Code File Name Sent to FLEXCUBE FLEXCUBE File Name Error Description File Last Modified Time Processing Start Time Last Processed Time Completion Status Processing Status Field Description Field Name Description Upload Batch Branch Code File name Sent to FLEXCUBE FLEXCUBE File Name Error Description Mandatory Pick List dd mm yyyy Type the upload date or select it from the pick list Mandatory Numeric Four Pick List Type the branch coder or select it from the pick list The branch name is displayed in the adjacent field Mandatory Pick List Select the uploaded file name from the pick list Display This field displays whether the file was sent to FLEXCUBE Display This field displays the corresponding file name Display This field displays the error description if there was error while uploading the file ORACLE Field Name Description File last Modified Display Time This field displays the file modificatio
95. displays the Authorization Reason screen ei Oy Ol e o 0 Enter the required information and click the Grant button 10 The system displays the transaction sequence number The transaction number is a system generated number that uniquely identifies each transaction performed by a teller and can be used for tracking the transaction Click the Ok button Note For more information on Authorization transactions refer to the FLEXCUBE Introduction User Manual 1460 GL Miscellaneous Credit Against Cash A General Ledger account of the transaction branch can be credited and the corresponding debit can be passed to the cash GL account in the same branch using this option Using this option you can inquire about GL transactions and movements on GL accounts after the transaction is successful Definition Prerequisites Not Applicable Modes Available Not Applicable To credit miscellaneous transaction to general ledger account 1 Type the fast path 1460 and click Go or navigate through the menus to Transaction Processing gt GL Transactions gt Cash gt GL Miscellaneous Credit Against Cash 2 The system displays the GL Miscellaneous Credit Against Cash screen GL Miscellaneous Credit Against Cash ORACLE GL Cey uso GL Account 100022150 Txn Amount GL Amount Reference Number 56323 User ReferenceNo 4888 Txn Cey im S TxnCcy Rate 1 00000 GL Cey Rate 4 55000 4
96. e 50 leaves or booklets of banker s cheque Conditional Numeric 10 Type the series number that has been defined for the particular stock code ORACLE Column Name Description Start End Total Confirm y n Delete y n Issue Stocks Conditional Numeric 10 Type the start number The stock item is ordered from this value onwards Display This column displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 Display This column displays the total based on the denomination and quantity specified Total Denomination Quantity For example If Denomination 100 and Quantity 20Then Total 2000 Only stock or inventory items tracked denomination wise will have an Adjustment Total value Toggle Click the toggle status to change the value to Y to confirm the physical receipt of either full or partial stock By default the system displays the value as N If the stock is received in partial the user will need to modify the quantity field to reflect the quantity actually received The stock level will not be updated at inventory till the confirmation flag is set to Y Toggle Click the toggle status to change the value to Y if you want to delete the particular stock item from the list By default the system disp
97. e Dec 16 15 29 592 Fri Nov 30 00 00 00 Wed Nov 19 09 42 2Wed Nov 19 09 42 286 mandate_creation_bSu ddeb dsn_09010918Su BILL STATION sul mandate _creation_bSut mandate_creaion_besu ee ae eS BI changerin chene 5 Click Close button Coe ox oo iio ORACLE
98. e data for calculation of the provision entries The data provided by the external system is account wise and that includes the Provisioning group Provisioning Sub group and Provisioning rate for the account The data is provided as and when there is a change in any of the parameters required for provisioning The Provision frequency is daily Provision is calculated from the date of account opening till the date of closure Provisioning and GL entries will be processed on daily basis when there is a change in any of the parameters or values The provision is always calculated in account currency In the case of commonly assessed group Liquidation Value LV will not be taken into account for calculation of provision For more information refer to the Examples provided at the end of the chapter Definition Prerequisites e ACMO7 Provisioning Parameters at Bank level for Loans and Overdrafts e External file upload for the Loans and overdraft accounts for which the modification inquiry is made Modes Available Not Applicable To perform provision inquiry and modification for loans and overdrafts 1 Type the fast path AC008 and click Go or navigate through the menus to Global Definitions gt AC gt Provision Inquiry and Modification for Loans and Overdraft 2 The system displays the Provision Inquiry and Modification for Loans and Overdraft screen Provision Inquiry and Modification for Loans and Overdraft ORACLE Acc
99. e drop down list In case the preference of an account has been changed during the life cycle of the account from Pass GL Entries to Do not pass GL entries then one can inquire on the amount that has been passed to the GL or the total provision done till date or both along with the re calculated running balance Column Name Description Date Display This column displays the date on which this provisioning was done Bal Book Display Princ Balance Incremental Provision Total Provision Bal UnColl Int Prov Initiated By Authorised By GL Entries This column displays the book balance Display This column displays the principal balance Display This column displays the incremental provision Display This column displays the total provision Display This column displays the difference between the uncollected interest provided and the uncollected interest provisioning reversed Display This column displays the user who has initiated this provisioning In case the provisioning option is automatic then this column displays the user as SYSTEM Display This column displays the user who has authorized this provisioning In case the provisioning option is automatic then this column displays the user as SYSTEM Display This column displays whether the GL entries for this provisioning amount has been passed Provision Adjustment ORACLE Customer Based Search Search Crit
100. e of the primary customer linked to the account Display This field displays the ID of the selected customer Customer ID is an identification number generated by the system after customer addition is completed successfully This running number unique to a customer across the system is generated after the system has identified the Customer IC and Customer Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system Display This field displays the account status ORACLE Field Name Description Currency Display This field displays the currency in which the account is maintained Product Display This field displays the name of the product under which the CASA is opened Branch Display Package Details Service Charge Package Account Level SC Waiver Flag This field displays the home branch to which the customer belongs Display This field displays the name of the service charge package that is attached to the account Optional Check Box Select the Account Level SC Waiver Flag check box to waive SC on the SC package attached to the account The check box is selected if SC waiver is applicable to the account If this check box is selected all service charges in the package will be waived for the account Column Name Description Srl No Display This column displays the running serial number Code Display This column displa
101. e viewed e Teller Level Only teller level details can be viewed Three types of Inquiries that aid in inventory tracking are e Indent Requests Status e Balance on hand e Stock Transactions Definition Prerequisites ORACLE e V001 Stock Transactions Modes Available Not Applicable To inquire on stock 1 Type the fast path IV011 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Inquiries gt Stock Inquiries 2 The system displays the Stock Inquiries screen Stock Inquiries Indent Request Reference Stock Inquiry v User ID Trans Type Purchase Order Reference Branch Stock Code DateFrom 15704 2008 Date To 1570472008 Current Balance of units Denomination Balance of units Denomination Details Stock Details Purchase Details Field Description Field Name Description ORACLE Field Name Stock Inquiry Branch Stock Code User ID Trans Type Date From Date To Description Mandatory Drop Down Select the appropriate stock inquiry option from the drop down list The options are e Balance On Hand e Stock Transactions e Indent Request Status Mandatory Pick List Select the branch code from the pick list This is the inventory bank that has placed the request on behalf of the allowed branch Mandatory Drop
102. eck Box Select the Report check box if the report is to be generated Output Optional Check Box Select the Output check box if the output file is to be generated ORACLE Field Name File Transactional Commit Size Number of Parallel Streams Allow Reversal Encryption Required Algorithm Name Encryption Key EOD BITMAP Parallel Processing CheckSum Required Internal to External Displays Optional Check Box Select the File Transactional check box to decide on the equal intervals at which to commit the file Mandatory Numeric Five Type the count for commit Mandatory Numeric Five Type the number of parallel streams allowed Optional Check Box Select the Allow Reversal check box if reversal is allowed Optional Check Box Select the Encryption Required check box if encryption is required Conditional Pick List Select the name of the algorithm from the pick list This field is enabled only if the Encryption Required check box is selected Conditional Alphanumeric Type the key for encryption This field is enabled only if the Encryption Required check box is selected Conditional Drop Down Select the EOD Bitmap from the drop down list The options are e None e EOD e BOD This field is enabled if the Commit Size and Number of Parallel Stream defined Optional Check Box Select the check box to allow parallel processing Optional Check Box Se
103. ed File Status Display Extract Date This column displays the file status of the extract Display This column displays the date of generation of the extract Date Time Extract Display Started This column displays the date and time of the start of extract generation Date Time Extract Display Ended This column displays the date and time of the end of extract generation ORACLE Column Name Description Total Records File Name Comments Skipped Records 3 Select the system code Display This column displays the total number of records in the extract Display This column displays the file name Display This column displays the comments Display This column displays the records which are skipped during extract from the pick list 4 Enter the other relevant details File Extract Inquiry System Code BILL STATION File Type User Id Extract Date J First Previous BILL STATION BILL STATION BILL STATION BILL STATION BILL STATION Mandate Creation At a34d3401e5F275609999 Mandate Creation At6a34d3401ebaeff70 9999 Mandate Creation At8a96c7bd1e39dc1809999 Mandate Creation AtGa96c7bd1e3ed3ael9999 Mandate Creation atga96c7bd1db2dsbaco BIE STATIS Sat Mar 15 00 00 00Mon Dec 22 21 27 4 Mon Dec 22 21 27 44 Tue Apr 15 00 00 O0CFri Jan 09 18 01 11 jFri Jan 09 18 01 11 j2 Fri Feb 29 00 00 00 Mon Dec 15 17 35 31 a Fri Feb 29 00 00 00 Tue Dec 16 15 29 5 Tu
104. ed Auth Required Relative Path XFF File Name Output File Helper Class Output Folder Helper Class Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized m add O Modify O Delete O d O Authorize O In 4 The system displays the file upload setup details in the various tabs Common Parameters ORACLE External File Setup Field Description Field Name External System Code ap_BA_MIS_EXTRACT JE mts Extract File Type AP_BA_MIS_EXTRAXT 7 MIS Extract Processor Type TRAC Format EXTRACT v Common Parameters Gefu Setup GL Setup Gefx Setup Output Template ij Deferred Auth Required F Relative Path XFF File Name fap_ext_MIS_Extract Output File Helper Class mi5 _extract Output Folder Helper Class Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Cladd By copy add O Modify O Delete O cancel O Am Authorize Inquiry Displays Output Template Deferred Auth Required Relative Path XFF File Name Output File Helper Class Output Folder Helper Class Mandatory Alphanumeric 40 Type the name of the template file which gives the format of the output flat file Optional Check Box Select the Deferred Auth Required check box if the deferred authorization is required before uploading of files Mandatory Alphanumeric 40 Type the path for the file upload
105. eld Name ATM Cash GL Forwarder Cash GL Acquirer Cash GL Forwarder Fee GL Acquirer Fee GL Debit Suspense GL Credit Suspense GL Remittance Debit GL Description Mandatory Numeric Nine Type the ATM cash GL code This GL account will be credited or debited for cash transactions done through the Bank s ATM network by the bank customers Mandatory Numeric Nine Type the forwarder cash GL code Mandatory Numeric Nine Type the acquirer cash GL code This GL account will be debited for the remote on us transactions transactions performed by the customers of other banks through the Bank s ATM network Mandatory Numeric Nine Type the forwarder fee GL code This GL account will be credited for the transactions performed by other bank s customers through the ATM network owned and managed by our bank in the capacity of a forwarder Mandatory Numeric Nine Type the acquirer fee GL code This GL account will be credited for fees on transactions done by banks which act as Acquirer institutions Mandatory Numeric Nine Type the debit suspense GL code This GL account will be debited in case of any suspense generated on account of ATM transactions Entries in this GL should be manually reversed out after rectifying the cause of suspense Mandatory Numeric Nine Type the credit suspense GL code This GL account will be credited in case of any suspense generated on account of ATM t
106. en off Display This field displays the sum of suspended interest which is interest penal interest and post maturity interest and suspended service charge fees to be written off Display This field displays the net amount which will be the write off expense GL as a result of write off Net Write off Total write off Suspended reversals Provision Drawdown Conditional Numeric 13 Type the extent to which provision is to be utilized for the purpose of write off ORACLE Field Name Description UnColl Int Prov Display Drawdown This field displays the amount of uncollected interest provision utilized or draw down for the loan account being written off Enter the account number and press the lt Tab gt or lt Enter gt key The system displays the write off account details when the Full Write Off option is selected 5 The system allows to modify the write off account details when the Partial Write Off option is selected 6 Enter the required information in the various fields Account WriteOff Account WriteOff amp FR r Account Details Account No 50000000311513 ASHISH S GOKHALE Branch SANDOZ MUMI Product 70005 Loan Product 4 Sanc Exp C Currency INR Total Balance 55 032 Total Arrears a Princ Provision Made _______ 11 000 00 Security Value 0 00 UnColl Int Provision Made SS Full write off
107. er double clicks the column C Expired Packages RP Account t Level Product Level Charges Applied Charges Applied Fetch a1 1221 SCTXN Service Charge LTL CASH WITHDRAWAL pa Summary Charges Applied Details Charges Due Rule Details SC History 2008 02 29 00 00 00 0 Field Description Column Name Description Code Linkage Code Display This column displays the SC code of all the service charges payable on the account Display This column displays the linkage code ORACLE Column Name Description Linkage Type Display This column displays the linkage type SC Nature Type Display This column displays the nature of charge i e the category of the service charge The options are e Commission e Service Charge e Fees e Taxes Commission and Service Charge are income profit made by a bank in return for the services offered by them Fees and Taxes are amount levied on public by the Government or other agencies Ccy Display This column displays the currency code in which the applicable service charges are payable Description Display This column displays the service charge description Due On Display This column displays the date on which the service charge will be debited from the account In case of service charge of type Online the due date will be same as the date of transaction 8 Double click the Rule Applied column in the Char
108. er gt key 4 Select the collateral code from the drop down list 5 Click the Ok button The system displays the collateral to account details Collateral To Account Inquiry ORACLE ccount Inquiry ollateral ID 517 Collateral Code 1 Automobile INR Currency INR otal Collateral Value 50 000 00 Unused Collateral Value TA 1 000000007492 100 000 000 Primary Card Change Pin Cheque Cost Rate Denomination Instrument Inventory Pin Validation Service Charge Signature Travellers Cheque 6 Click the Close button ORACLE Asset Classification Transaction ACO001 Account Classification Preferences Using this option you can view and modify the account level asset classification preferences with respect to movement Plan Arrears claw back and Provision Plan The parameters displayed here are defaulted from the product at the time of account opening Account classification Preferences are inherited from the Global Product level preferences Definition Prerequisites e 8051 CASA Account Opening e LNO57 Loan Direct Account Opening e LNM11 Product Master Maintenance Modes Available Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To modify the account classification preferences details 1 Type the fast path AC001 and click Go or navigate
109. erated Company Type Mandatory Alphanumeric Two Type the company type The bank assigns different codes to the companies to whom it provides the billing services ORACLE Field Name Company Name Bill Information Available Payment After Due Date Payment Type Allowed Grace Period Days Cut Off Period Days Company Account No Company Address Contact Person Phone Number Description Mandatory Alphanumeric 20 Type the company name The name of the service provider or the billing company on whose behalf the bank collects the payments for the bills Optional Check Box Select the Bill Information Available check box if the billing information of the company is available to the bank Optional Check Box Select the Payment After Due Date check box if you want to accept the payment received from the customer of the billing company after the due date specified in the bill Mandatory Alphanumeric One Type the payment type which is allowed The options are e P Part Payment allowed i e amount less than or equal to the outstanding e F Only Full Payment allowed i e full outstanding amount e E Excess Payment allowed i e payment amount can be greater than or equal to the outstanding amount Mandatory Numeric Five Type the number of grace days allowed for late payment of the bill without any penalty Mandatory Numeric Five Type the number of days after the due date beyond w
110. eria Customer IC GEORGEHARR Customer Full Name GEORGE HARRISON Customer Id J Home Branch 9999 Customer CRR 51 t Account Based Search Account Number Customer Id Customer CRR Home Branch Account Number 00 1 Principal Balance 25 Secured Amount Unsecured Amount 2 Adjustment Expected Provision Accounted Provision 0 00 Account Provision 0 00 User Adjustment 0 00 Ok _ Cancel Field Description Field Name ok _ctese_ _ clear _ Description Account Number Expected Provision Principal Balance Accounted Provision Display This field displays all the account numbers of the customer in case of Customer Based Search criterion In case of Account based search only that account number mentioned in the search criterion is displayed Display This field displays the provision value corresponding to the account CRR Display This field displays the principal balance outstanding Display This field displays the value of provision to an extent the GL entries have been passed at the account level If the GL entries for provisioning is maintained as Yes the value will be same as Account Provision ORACLE Field Name Description Secured Amount Display This field displays the total principal amount that is secured as per the last valuation Account Provision Display This field
111. es or disables the table name depending on the criterion selected Select the Delete Option option from the Maintenance Option drop down list Click the Ok button The system displays the data entry section in the screen Select the relevant check box Click the Ok button NO Qt e O M ORACLE 8 The system displays the message Record Deleted Successfully To view download scheduler 1 Select the criterion and request for from the respective drop down list The system enables or disables the table name depending on the criterion selected Select the View Option option from the Maintenance Option drop down list Click the Ok button 5 The system displays the download scheduler details 8890 Cluster Maintenance PP oO RN In the Download Cluster option branches that are expected to have common data are grouped for the cluster branch after download from Host to Branch A cluster could be defined for those cases where the physical branch locations of some branches are close by and the customer of any of these branches are also be serviced in the offline mode Download Scheduler option also refers to the Download Cluster maintenance before downloading data into the branch database For example A bank has four Branches A B C and D Branches A B and C are physically closer and are to be defined in a cluster Cluster Download is maintained for Branch A on ch_acct_mast table so as to include data from Branch B and Branch C Bran
112. field displays the total of all Service Charge arrears outstanding as on Inquiry ORACLE Field Name Description Arrear Date Arrear Type Arrear Amount Arrear Pending Last Paid Date Display This field displays the date on which the outstanding arrear was raised Display This field displays the type of the arrear Display This field displays the amount of the arrear raised for the arrear type on a respective date Display This field displays the amount of arrears pending for appropriation for the arrear type on a respective date Display This field displays the date on which the last payment was made for the arrear Arrear Details as on NPA Date CRR Enquiry fe PR Customer Search String Customer Information Customer ID 603898 Customer IC ASHISH09111977 Customer Name ASHISH S GOKHALE Customer CRR 10 Standard Home Branch MAIN BRANCH Account CRR Account Details CRR History Customer CRR History Universal CRR History Current Arrear Details Gg Sc SES ers Crr Evaluation Details NPA Date Account Status on NPA Date Outstanding Principal Outstanding Interest Outstanding Service Charge Arrear Date Arrear Type Arrear Amount Arrear Pending Last Paid Date ORACLE Field Description Field Name Description NPA Date Account Status on NPA Date Outstanding Principal Outstanding In
113. from the pick list to view the stock status based on the purchase order reference The result for purchase order reference will show the supplier code the date of order placement in the Purchase Detail tab Current Balance Optional Numeric 22 of units Type the number of inventory units that are currently available Denomination Optional Numeric 22 Balance of units Type the number of denomination units that are available Select the stock inquiries from the drop down list The system enables the corresponding fields and tab depending on the stock inquiries selected 5 Enter the required information in the various fields Stock Inquiries ORACLE Stock Inquiry Bal User ID Indent Request Reference Trans Type Purchase Order Reference Branch C peterrom fig 04 2008 4 Stock Code Dat Tas 15 04 2008 g Current Balance of units Denomination Balance of units Denomination Details Stock Details Purchase Details Card Change Pin Cheque Cost Rate Denomination Instrument Inventory Pin Validation Service Charge Signature Travellers Cheque E 6 Click the Ok button 7 The system enables the Details tab Details ORACLE Stock Inquiry Balance on Hand User ID Trans Type Branch
114. ges Applied Details tab to enable the Rule Details tab Rule Details ORACLE SC Details current Package Expired Packages Filter Criteria All RP Account Level Product Level From Date ee To Date ee Charges Applied Charges Applied Surnmar y Charges Applied Details Charges Due Rule Details SC History Field Description Column Name Description Rule Eval Seq Display This column displays the sequence of evaluation of rule Rule Display This column displays the description of the rule Condition No Display This column displays the condition number Reason Text Display This column displays the reason for attaching the rule to the service charge Original Val Display This column displays the original value of the service charge Rule Effect Display This column displays the description of the rule effect ORACLE Column Name Description Final Val Display This column displays the final value of the service charge after the rule has been applied Final Value Original SC Value Rule Returned Value SC History Customer ID Status Currency Product Branch e SC Details current Package Expired Packages Filter Criteria All RP Account Level Product Level From Date fred To Date ce E Charges Applied Charges Applied Summary Charges Applied Details Charges Due
115. gt or lt Enter gt key Enter the appropriate information in the fields Select the appropriate branch code from the drop down list ATM Acquirer POS Id Maintenance ATM Acquirer POS Id Maintenance fo FR Acquirer Institution Id Card Ac ceptor Identification Code Forwarder Institution Id Card Acc Card Acceptor Terminal Id Originating Branch Code 240__ L J sanpoz mumsar ATM Cash GL 73000011 Deposit Cash GL 73000040 Acquirer Fee GL 72000030 Forwarder Fee GL 73000025 E Incomin 1g Remit GL 73000048 Outgoing RemitGL 267000053 Settlement GL 2s7000057 eptor Terminal Name Authorized By Last Mnt Date Last Mnt Action Authorized ok _ cose _ cier 7 Click the Ok button 8 The system displays the message Record Added Authorization Pending Click Ok to Continue Click the OK button 9 The ATM acquirer POS ID is added once the record is authorised Note The same Card Acceptor Identification Code can have multiple Card Acceptor Terminal Ids linked to it Every combination of Card Acceptor Identification Code and Card Acceptor Terminal Ids is unique POS01 POS Acquirer POS Id Maintenance Each POS Point of Sale is logically attached to a dummy account in some branch originating branch in FLEXCUBE Every POS in the POS network of a Bank has two POS IDs Card Acceptor terminal ID and Card Acceptor ID code which uniquely identify the POS Using this option
116. he Expired Package option is selected Conditional Pick List mm dd yyyy Selec t the from date from the pick list This field is enabled only if the Expired Package option is selected Conditional Pick List mm dd yyyy This field is enabled only if the Expired Package option is selected 3 Enter the account number and press the lt Tab gt or lt Enter gt key 4 The system enables the Charges Applied tab SC History for Account Inquiry ORACLE Account Details Account No T Name Customer ID Status Currency Product 4 D Branch _ SC Details current Package Expired Packages Filter Criteria All Account Level Product Level To Date plied Details Charges Due Rule Details Sc Histor From Date Charges Applied harges Applied Summar 91 1221 SCTXN Service Charge LTL CASH WITHDRAWAL NA 5 View the information in the various tab screens Charges Applied ORACLE SC Details Filter Criteria All From Date current Package Expired Packages Account Level Product Level kE To Date l F ra Charges Applied Charges Applied Summar yll at a221 scTxN Service Charge Jett CASH WITHDRAWAL l NA Charges Due SC History Field Description Column Name Description SC Package Display This column displays the SC package code Code Display
117. he OK button 8 The customer relationship is added to the IB transaction BAIB5 IB Block Transfer Across Products Using this option you can allow or disallow transfer of funds through Internet Banking between accounts belonging to two specific products For example this facility can be used to restrict credit into accounts opened under certain specific type of products like Non Resident Accounts where the bank does not allow customers to transfer funds from certain types of products Note The system automatically authorises this transaction Definition Prerequisites e The products should be added and authorised in FLEXCUBE Retail Modes Available Add Delete Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To block transfer of funds across products under internet banking facility 1 Type the fast path BAIBS5 and click Go or navigate through the menus to Global Definitions gt Channels gt IB Block Transfer Across Products 2 The system displays the IB Block Transfer Across Products screen ORACLE IB Block Transfer Across Products From Product Code To Product Code Transfer Disallowed Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Mody Delete Cancel Amend Authorize Inquiry Field Description Field Name Description From Product Mandatory Drop Down Code Select the pr
118. he Ok button The system displays the data entry section in the screen Select the relevant check box Click the Ok button The system displays the message Record Deleted Successfully Do N p on e p To view download cluster 1 Select the criterion request for and table name 2 Select the View Option option from the Maintenance Option drop down list ORACLE 3 Click the Ok button 4 The system displays the cluster details 8892 Download Service Download service is the service that is running on the Local Branch server this will trigger Download request from the Branch to the Central Database This service uses the Pull methodology instead of push methodology The service running at the respective branch server will pull data from the central host to the designated branch server This service is used by schedule download at the Branch Server and also for Adhoc download request by the System Operator at the Data Center or by the System Administrator at the Branch Definition Prerequisites Not Applicable Modes Available Not Applicable To download the service 1 Type the fast path 8892 and click Go or navigate through the menus to Operator Processes gt Data Download Options gt Download Service 2 The system displays the Download Service screen Download Service Download Service Entity Bank Codes From BANK OF AMERICA gt Delete Old Record mest LBC be Path Browse
119. he data to the respective branch server If the link between central host and branch is down a flat file will be created in a pre designated directory on the central host and the same will be downloaded after the link is functional If the scheduler is configured on the branch server the scheduler will pull the data from the central host If the link is down no action occurs When the link comes up the scheduler will work on all outstanding schedules Due to scheduled downloads the branch database will have the latest data as of last download from the host This maintenance also significantly reduces download related responsibility on the System Operator Definition Prerequisites Not Applicable Modes Available Not Applicable To inquire about the upload file status ORACLE 1 Type the fast path 8889 and click Go or navigate through the menus to Operator Processes gt Data Download Options gt Download Scheduler Maintenance 2 The system displays the Download Scheduler Maintenance screen Download Scheduler Maintenance Criterion poe _ Request For Branch gt Table Name B Z Branch Maintenance Option Add Option 7 Rows to Add 15 A Table Name Name Requester ErEqJUENGE Frequency Qualifier Start Date Start B Type Interval ACF On Time Other x 30 07 2005 12 30 Ok Cancel Field Description Field Name Description Criterion Mandatory Drop Down Sele
120. he reason for the movement accrual status etc Definition Prerequisites e 8051 CASA Account Opening e ACO001 Account Classification Preferences e LNO57 Loan Direct Account Opening e SMMO6 Template Access Rights Maintenance Modes Available Credit Risk Rating ORACLE Not Applicable To maintain account classification 1 Type the fast path AC002 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Classification gt CRR Enquiry 2 The system displays the CRR Enquiry screen CRR Enquiry CRR Enquiry r Search Criteria Customer X Search String Account Number Customer ID Customer IC Customer Name Customer CRR Home Branch Customer CRR History Universal CRR History Current Arrear Details Arrear Details as on NPA Date Crr Evaluation Details Account Number Present Account CRR Expected Account CRR Accrual Status Present UCRR Field Description Field Name Description Search Criteria Customer Optional Radio Button Drop Down Select the search criteria to search for the customer from the drop down list The options are e Customer short name Short name of the customer e Customer IC Identification criteria arrived at by the bank during customer addition e Customer ID Unique identification given by the bank ORACLE Field Name Search St
121. he total file size of the selected file File Comments Display This field displays the comments if any Column Name Description Record Id Display This column displays the record identification number Record Length Display This column displays the length of the record ORACLE Column Name Description Record Status Comments Record Data Display This column displays the status of the record Display This column displays the comments related to the record Display This column displays the data recorded 7 Double click on the appropriate record to enable the Record Details tab File Summary This tab is for future use Record Details The sub details of the record are displayed according to the selected record File Name User Id Upload Date Branch Code File List File Details Record Id Record Status Comments AccountType AccountNumber CompanyID BranchCode ConsumerNo UpperLimit ExpiryDate ReasonCode MandateStopFlag StopStartDate StopEndDate BenefDetails MandateType Remarks ActionCode Record Details PROCESSED Processed Successfully 50100000000070 3809075 240 5 1555 0 20491231 N Sameer Padhy FORM ok 1 Status Process Date 8 Click the Close button on cere E a Note The user can enter more than one criteria to perform the inquiry on the file upload status ORACLE 7240 File Upload
122. heduler Setup Scheduled Time HH MM 00 00 Scheduler Frequency Monthly v Scheduled Units 3 EOD Event Record Details _ Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description Scheduled Optional Numeric Two Two Time HE Ney Type the schedule setup time Scheduler Conditional Drop Down Frequency Select the scheduler frequency from the drop down list This field is enabled if the Frequency option is selected in the Scheduler Type field Scheduled Units Mandatory Numeric Five Type the number of scheduled units For Example If the scheduler is required to run once in 2 weeks then the frequency should be weekly and scheduled units should be two EOD Event Optional Check Box Select the EOD Event check box to run the scheduler at the time of EOD ORACLE Event Scheduler Setup Scheduled Event Record Details i By Field Description Field Name Description Scheduled Event Mandatory Alphanumeric 20 Type the event for which the scheduler is to be run The scheduler event occurs between the start date and the end date of the specified event The events supported are EOD BOD Cut off Inward Clearing Outward Clearing Uploads Extracts Resource Scheduler Setup ORACLE This tab is for future use 7 Click the Ok butt
123. here the bank wants to debit or credit numerous accounts at a time or for other activities such as uploading the file to facilitate bulk checkbook issue Service Charges This section provides details about linking the service packages to the customer or the existing accounts of the customers Download Related This section provides details about the setup of automatic download of data from central host to the various branch servers ORACLE Delivery Channel Related Transactions ATMO01 ATM Bank Params Maintenance Using this option you can define the bank parameters GL accounts required for Oracle FLEXCUBE which are necessary for maintaining ATM Automated Teller Machine transactions which occur through various ATM channels across the network The hold variance percentage and the hold period is also defined here The system places a Master Money Hold on the account when it grants authorisation on an offline POS i e signature based POS transaction The Hold has a certain validity period The MasterMoney Hold will be removed by the system if the debit has a matching Authorisation Code and is within the defined tolerance range The debit will then be posted to the account If either the Authorisation Code and or settlement amount for debit not within the tolerance does not match the Hold is not removed Such a Hold will expire on the expiry date Definition Prerequisites e BAM20 Bank Codes Maintenance Other Prerequisites e GL C
124. hich payment received from the customers of the billing company will not be accepted Mandatory Numeric 14 Type the valid account number of the company held with the bank The bill amount received from the customer will be credited to this account Mandatory Alphanumeric 40 Type the postal address of the billing company Optional Alphanumeric 20 Type the name of the contact person All interactions will be addressed to this contact person Optional Numeric 16 Type the contact number of the billing company ORACLE Field Name Description Collection Center Optional Alphanumeric 10 Code Type the collection code of the center A unique code is assigned to the collection center of the company Bill Details File Optional Alphanumeric 20 Name Type the path and the name of the bill details file The name of the file containing the bill details and its path is stored in a separate file outside FLEXCUBE Retail 3 Click the Add button 4 Type the company id and press the lt Tab gt or lt Enter gt key 5 Enter the required information in the various fields IB Bill Company Details Maintenance aintenance Company Id e Company Type i Company Name ABC Ltd Bill Information Available z PSY AARDE Payment Type Allowed Full Payment Grace Period Days 10 Cut Off Period Days 10 Company Account No 000000002220 i E Company Address Spec
125. his field displays the total number of records loaded from the file in the branch database If the total records in file and uploaded records are not equal a branch report needs to be generated 3 Enter the file path or click the Browse button and navigate to the file path Upload Account Balance File File Path D Test Upload xls Browse Total Records in File Uploaded Records 4 Click the Upload button 5 The system displays the account balance file and displays the message File Uploaded Successfully Click the Ok button ORACLE CHM43 Cheque Book Issue Upload Using this option you can upload cheque book issue file to facilitate bulk cheque book issue activity This cheque book issue file must be maintained in pre defined format and this file must exist on the application server in the RJSin folder When the file name is provided the system locates and picks up file The status of the uploaded file whether processed or not can be viewed in the External File Processing Upload File Status Inquiry Fast Path BAM94 option Definition Prerequisites Not Applicable Modes Available Not Applicable To upload cheque book issued 1 Type the fast path CHM43 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Handoff gt Cheque Book Issue Upload 2 The system displays the Cheque Book Issue Upload screen Cheque Book Issue Upload Che
126. icates the criteria on which the download cluster is maintained The options are e Table Name If the user selects this option it specifies that the cluster has been set up for only one branch code and more than one table e Branch Code If the user selects this option it specifies that the cluster has been set up for only one table and more than one branch e Both If the user selects this option it specifies that the cluster has been set up only for a specific branch and a specific table ORACLE Field Name Request For Table Name Branch Maintenance Option Rows to Add DATA OF FOR TABLE NAME Description Mandatory Drop Down Select the entity for which the request has been made from the drop down list The options are e Host e Branch By default this field displays the Host option as clustering forms part of host activity i e the Central Database Conditional Pick List Select the table name for cluster maintenance from the pick list This field is enabled if the user selects the Table Name or Both options in the Criterion field Conditional Drop Down Select the branch code for which cluster maintenance is defined for a table drop down list This field is enabled if you select Branch Code or Both options in the Criterion field Mandatory Drop Down Select the cluster maintenance option from the drop down list e Delete Option e Add Option e View Option Conditional
127. ice it is effectively propagated to all the branches within that local office Status Display This column displays the status of the collateral propagation By default this field displays the status as Not Started 3 Click the Start button to propagate re evaluation details to all branches Collateral Propagation ORACLE Collateral Propagation 1 Completed 4 Click the Close button BAM47 Application Collateral Delink Using this option you can de link a collateral linked to a loan account application This transaction has to be authorised by a supervisor and the collateral can be released after successful Authorisation Definition Prerequisites e BAM74 Collateral Header Maintenance e BAM 9 Collateral Codes Maintenance Modes Available Not Applicable To delink collateral linked to an application 1 Type the fast path BAM47 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Collaterals gt Application Collateral Delink 2 The system displays the Application Collateral Delink screen Application Collateral Delink ORACLE Application Collateral Delink Application No S No Collateral Id Collateral Type Collateral Value Co Close Clear Field Description Field Name Description Application No Mandatory Numeric 16 Type the loan application number to which the collateral ID is linked Column Name Description
128. ify the original values to reflect the received stock values The quantity can be reduced from the original requested but cannot be increased For example 50 units of banker s cheque It can be 50 leaves or booklets of banker s cheque Display This column displays the series number that has been defined for the particular stock code received Display Numeric Seven Type the start number from which a stock item is received Display This column displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 Display This column displays the total based on the denomination and quantity specified Total Denomination Quantity For example lf Denomination 100 and Quantity 20Then Total 2000 Only stock or inventory items tracked denomination wise will have an Adjustment Total value ORACLE Column Name Description Confirm y n Toggle Click the toggle status to change the value to Y to confirm the physical issue of stock either in full or partial By default the system displays the value as N If the stock is issued in partial the user will need to modify the quantity field to reflect the quantity actually issued The stock level will not be updated at the issue bank branch till the confirmation flag is set to Y Delete y n Toggle C
129. ination value in numbers Denomination Display Balance This column displays the denomination balance available in the inventory 9 Double click a record to enable the Stock Details tab Stock Details ORACLE Stock Inquiry Branch User ID Indent Request Reference Trans Type Purchase Order Reference Date From 30 04 2008 Stock Code Date To 30 04 2008 Current Balance of units Denomination Balance of units Details Denomination Details 5 Purchase Details Field Description Column Name Description Denomination Display Value This column displays the denomination value Denomination Display Balance This column displays the denomination balance Denomination Display This column displays the denomination in words Series Display This column displays the series Start No Display This column displays the inventory start number End No Display This column displays the inventory end number Stock Ccy Display This column displays the stock currency ORACLE Column Name Description Current Series Total Value Purchase Details Stock Inquiry Display This column displays the current series total value User ID Indent Request Reference Purchase Order Reference Trans Type Branch Stock Code GJ Date From 15 04 2008
130. int Details Sanctioned Amount 8 791 59 Limit Drawing Power 0 00 Disbursed Amount 0 00 Collateral Available 0 00 Outstanding Bal 0 00 Book Balance 0 00 Principal Arrears 0 00 Current Balance 0 00 Interest Arrears 0 00 Interest Arrears 0 00 Other Arrears 0 00 Principal Arrears Sc Arrears Min Amount Due Other Arrears 0 00 4 gt Field Description Field Name Description CRR Details Account Number Display Recalled Account Actual Date of Classification This field displays the account number Optional Check Box Select the Recalled Account check box if the account can been recalled Display This field displays the date on which asset classification criteria for movement from Normal to Suspended was satisfied Example An account has satisfied DPD criteria for forward movement to NPA on 15 06 2009 However the Classification frequency is monthly and account gets classified as suspended on the month end However the account classification date shows 30 06 2009 where as it has turned NPA on 15 06 2009 The system will show the date as 15 06 2009 in this field Days Past Due ORACLE Field Name Present Account CRR Accrual Status Loan Account Details Sanctioned Amount Disbursed Amount Outstanding Bal Principal Arrears Interest Arrears Other Arrears Min Amount Due CASA Account Details Limit Drawing Po
131. ion Agent Code Mandatory Pick List Select the agent code from the pick list The agent code is typically a code assigned to the bank where investment companies hold their accounts The investment company s account at agent bank would be debited and the customer s account in your bank is credited The bank can receive a list of outward direct credit from several agent banks and a separate outward remittance file is maintained for each agent bank ORACLE Field Name Description Currency Code Mandatory Drop Down Select the currency code from the drop down list The outward remittance file is maintained based on currency All the outward direct credits in a particular currency from a certain agent would be maintained in a single file Output File Mandatory Alphanumeric 40 Type the name of the outward remittance file maintained in the RJS in folder on the application server Post Process Optional Check Box Select the Post Process check box to convert the file in the acceptable format 3 Enter the agent code and press the lt Tab gt or lt Enter gt key or select it from the pick list 4 Enter the required information in the various fields Outward Remittance Handoff Outward Remittance Handoff Agent Code 012 a Currency Code INR Output File Post Process 5 Click the Ok button 6 The system displays the message Authorization Required Do You Want to contin
132. ion Mandatory Drop Down Select the appropriate transaction option from the drop down list The options are Request Stock Order Stock Receive Stock Issue Stock Based on the transaction type selected the tab for the respective transaction will be activated 3 Click the Add button 4 Select the appropriate transaction from the drop down list 5 The system enables the corresponding tab depending on the transaction type selected Request Stocks ORACLE Stock Transactions Transa ction Re Request Stocks Request No Requesting Branch HO Request Type Adhoc x Date of Request 15 02 2008 36 Ad hoc Request Reason Urgent Requirement Reference No 1 1 Reference No 2 2 Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized A O Authorize Cyanine Field Description Field Name Description Request No Display This field displays the a unique request number will get auto populated It is used to track the request status by the bank or branch and to place the purchase order with supplier by central inventory department The request number displayed will be based on the combination of data from requesting branch and request type fields The format is First four digits Branch code pertaining to branch for which stock is ordered Numeric Next one digits Request type Adhoc A Regular R
133. ion Field Name Description Date Effective Mandatory dd mm yyyy The date or select it from the calendar from which the new linked service charge package should be effective for the existing accounts Column Name Description Account Number Display The account number of the customer Service Charge Display Package The service charge package code and name Change Toggle Status Click the toggle status and select the Y value to attach the new selected package to the account By default this field displays the value N The new package will be effective for the selected accounts from the effective date specified ORACLE 7 Click the Ok button 8 The system displays the message Record Added Authorization Pending Click Ok to Continue Click the Ok button Note When a SC Package is attached to a customer this new SC package functions as the default package instead of the default product package The waivers specified in the linkage will be defaulted to the account SCMO03 SC Package Changes at Account A SC package can be attached at a customer level or at the product level The SC package linked either at the customer level or product level is defaulted at the CASA level Hence for an account the SC package depends on the SC package linked either at the customer level or product level If there is a SC package attached at customer level the same is defaulted to the account when it s
134. isplays the message Authorization Required Do You Want to continue Click the Ok button 7 The system displays the Authorization Reason screen 8 Enter the required information and click the Ok button 9 The system displays the message File Uploaded Successfully Click the Ok button ST044 Outward Remittance Handoff The bank provides the facility of Electronic Clearing System ECS to its customers where the customers accounts are directly credited with the amount of interest or dividend earned on their investments Using this option you can maintain and upload bulk list of all customers whose accounts need to be credited with such outward direct credit This Outward Remittance Hand off file must be maintained in pre defined format and this file must exist on the application server in the RJSin folder Definition Prerequisites Not Applicable Modes Available Not Applicable It is the file extract given out from FLEXCUBE to other software ORACLE To load an outward remittance hand off 1 Type the fast path ST044 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Handoff gt Outward Remittance Handoff 2 The system displays the Outward Remittance Hand off screen Outward Remittance Handoff Outward Remittance Handoff Agent Code ka Currency Code xij Output File Post Process Field Description Field Name Descript
135. ist This field is enabled if the user selects the Table Name or Both options in the Criterion field Conditional Drop Down Select the branch code for which schedule maintenance is defined for a table from the drop down list This field is enabled if the user selects Branch Code or Both options in the Criterion field Mandatory Drop Down Select the schedule maintenance option from the drop down list The options are e Delete Option e Add Option e View Option Conditional Numeric Five Type the number of rows that should be added in the schedule This field is applicable only if the user selects the Add Option in the Maintenance Option field Description Mandatory Drop Down Select the table name scheduled to be downloaded from the drop down list ORACLE Column Name Description Name Requester Mandatory Drop Down Select the name of the requester who has scheduled the download from the drop down list Frequency Type Mandatory Drop Down Select the frequency type of the download that is scheduled by the bank from the drop down list Frequency Interval Mandatory Numeric 22 Type the frequency interval of the download that is scheduled by the bank Qualifier Mandatory Drop Down Select the qualifier of the download that is scheduled by the bank from the drop down list Start Date Display This column displays the start date of the download Start Time Display This column displa
136. k Params Maintenance Bank Code Funds Transfer Currency Service charge at EOD Fee GL Funds Appropriation Sequence BC Issue GL Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized vl Delete Cancel Amend Authore Inquiry Field Description Field Name Description Bank Code Funds Transfer Currency Service charge at EOD Fee GL Mandatory Numeric Five Type the code of the bank for which global definitions should to be maintained Each code uniquely identifies a different bank Mandatory Drop Down Select the funds transfer currency from the drop down list The options are e Transaction Currency e Account Currency Optional Check Box Select the Service charge at EOD check box if you want to levy service charges for internet banking transactions at EOD Mandatory Numeric Nine Type the fee GL code This GL account will be credited for internet banking fees collected from the customer ORACLE Field Name Description Funds Mandatory Numeric Five Appropriation S Sequence Type the funds appropriation sequence This field denotes the sequence in which the transaction amount needs to be appropriated while debiting the account The options are e S Sweep In e O Overdraft e V Overline e A Advance against unclear funds e T Temporary Overdraft BC Issue GL Mandatory Numeric Ni
137. lays the value as N ORACLE Stock Transactions Transaction Issue Stock x Issue Stocks Request No e Issued To Date of Issue 15 siig _ Record Details Field Description Field Name Description Request No Mandatory Pick List Select the request number for which purchase order is placed from the pick list The pick list displays only those request numbers against which full orders or partial orders are placed Issued To Mandatory Drop Down Select the appropriate bank or branch for which the inventory bank had placed the request for stock from the drop down list Date of Issue Mandatory Pick List dd mm yyyy Select the date of issue from the pick list Column Name Description Srl No Display This column displays the system generated serial number for each stock item in the list ORACLE Column Name Request id Stock catalog Code Denm Qty req Series Start End Total Description Display This column displays the request ID for each stock item in the list Display This column displays the stock catalogue code of the stock or the inventory item for which the request order is placed Display This column displays the denomination value of the requested stock Display This column displays the quantity of stocks In case of partial receipt for the stock request the user can mod
138. lect the check box if checksum is required Optional Check Box ORACLE Field Name Displays Hold Required Optional Check Box Select the checkbox to allow hold required facility Upload Commit Optional Numeric Size Type the upload commit size Value Date Drop Down Validation Select the value date validation fro the drop down list The options are GL Setup Blank Neither future dated nor backdated transactions will be allowed Allow Future Value dated Only future dated transactions up to seven days will be supported Allow Back value dated Future dated transactions will not be allowed Allow All Both future dated and back dated will be supported This tab is enabled if the UPLOAD option is selected in the Processor Type drop down list You can enter details in this tab if data is entered in the Commit Size and Number of Parallel Streams fields ORACLE External File Setup External System Code Ap_BA_MIS_EXTRACT JA as extract File Type ap_ba_mis_extract MiS extract Processor Type Common Parameters Gefu Setup 6L Setup Format GEFx w Generate Bridge GL Flag F Bridge System Cash Debit GL 190100415 Internal Transfer Debit GL 190100416 Balance Bridge Flag F Generate InterBranch GL Flag z DesignatedBranch fa ji Suspense Debit GL 490100417 B Suspense Credit GL somos J amp J Bridge S
139. lick the toggle status to change the value to Y if you want to delete the particular stock item from the list By default the system displays the value as N 6 Enter the required information in the various fields Click the Ok button 8 The system displays the message Record Added Authorization Pending Click Ok to Continue Click the Ok button 9 The stock transaction details are added once the record is authorised Note Click Add button to add request stocks IV002 Stock Adjustment Using this option you can adjust amend the stock status to reflect the correct position of instruments that have been cancelled returned torn lost in transit etc Other than the issue and use of stock status for everyday transactions the teller or vault teller can maintain other statuses such as Rejected Torn Cancelled Lost Misplaced etc to indicate the position of stocks in hand e g The Central Inventory department required USD traveler s cheque of denomination 100 However the supplier issued INR traveler s cheque of denomination 100 that were marked as received These traveler s cheque can be marked as rejected Definition Prerequisites e V001 Stock Transactions Modes Available Not Applicable To adjust the balance stock 1 Type the fast path IV002 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Inventory gt Stock Adjustment 2 The system displays the Sto
140. ll be debited from the drop down list Mandatory Pick List Select the GL account number from the pick list The GL description name is populated adjacent to the GL account number This is the GL account which will be debited Mandatory Drop Down Select the GL currency in which the To GL Account will be credited from the drop down list Mandatory Pick List Select the GL account number from the pick list The GL code is populated adjacent to the GL account number This is the GL account which will be credited Mandatory Numeric 13 Two This field displays the rate at which the account currency is converted to the local currency of the bank The teller s right to change the account currency rate within a range is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Depending on the configurable option at the bank level the teller can modify this rate within certain boundaries If the account currency and the local currency are same the field takes the default value as 1 which cannot be modified Display This field displays the rate at which the transaction currency is converted to the local currency of the bank The teller s right to change the transaction currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Depending on the configurable option at the bank level the
141. mers Levy Issuer Fee Online Funds Appropriation Sequence POSCash GL Acquirer Cash GL Acquirer Fee GL _ Record Details __ Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description Bank Code Debit Suspense GL Institution Id Issuer Fee GL POSCash GL Mandatory Numeric Five Type the code of the bank for which global ATM definitions should be maintained Each code uniquely identifies a different bank Mandatory Numeric 11 Type the institution ID The bank is identified in the network using this ID This ID is allotted by the central bank of the country or the body that governs payment systems in the country Mandatory Numeric 10 Type the issuer fee GL code This GL account will be credited for fees on transactions done through the Bank s POS network Mandatory Numeric Nine Type the GL to be debited or credited for the cash transactions done through the bank s POS network by the bank s customers ORACLE Field Name Forwarder Cash GL Acquirer Cash GL Forwarder Fee GL Acquirer Fee GL Debit Suspense GL Credit Suspense GL Code Discount GL Allow Funds Transfer Across Customers Levy Issuer Fee Online Description This field is for future use Mandatory Numeric Nine Type the GL to be credited by the amount of cash to be debited for remote on us tra
142. mits backed by Liquid Collateral this is the number of days from Collateral Breach date Liquid Collateral Display Breach Date For OD limits backed by Liquid Collateral date on which the outstanding balance in account gt Lien amount on the collateral For OD Limits not backed by Liquid Collateral this will be NULL Liquid Collateral Display Amount For OD limits backed by Liquid Collateral this is the lien amount on the collateral For OD Limits not backed by Liquid Collateral this will be NULL Stock Statement Display Submission DPD This field displays the number of days since the last stock statement submission date Stock Statement Display Submission Date This field displays the Date on which the stock statement was submitted by customer 4 Click the Close button ACO003 Account Provision Using this option you can view the provisioning details of an account along with the history of provisioning You can also maintain manual provision for the accounts where the provisioning parameter is set to manual provisioning Definition Prerequisites e 8051 CASA Account Opening e LNO57 Loan Direct Account Opening e ACO001 Account Classification Preferences Modes Available Not Applicable To maintain account provision 1 Type the fast path AC003 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Classification gt Account Provision 2 The system
143. mn displays the table name that has been requested to be downloaded Status Display This column displays the status of the download request The options are e Data Loaded This indicates successful download e Load Failed This indicates unsuccessful download e Data Extraction Failed This indicates unsuccessful download Request Time Display This column displays the request date and time for download of a table to the branch Reply Time Display This column displays the reply time for download of the table Select the criterion and request for from the respective drop down list 4 The system enables or disables the name entity and the branch depending on the criterion selected 5 Enter the relevant information 6 Click the Ok button File Upload Inquiry GEFU ORACLE Download Log Request For Branch Criterion Enty gt Name Entity Bank Codes g Branch of Date From Dateto No Data Extracted No Data Extracted No Data Extracted 2005 08 16 17 16 04 No Data Extracted 2005 08 16 15 36 03 7 The system displays the download log details 8 Click the Cancel button ORACLE File Upload BAM53 SCHEDULAR SETUP Using this option you can schedule the execution of file extracts or file uploads The triggering can be based on Date Time frequency or based on the occurrence of certain events or event based on availability of some predefined res
144. n branch channels like TBS ATM and POS who own and manage the ATM network Display This field displays the card terminal name Display This field displays the card terminal ID Each unique code identifies a terminal at the card acceptor location Mandatory Pick List Select the branch code from the pick list The originating branch code refers to the branch through which the ATM transactions would be routed to respective branches In practical scenarios where all ATM operations are centralized the branch code would be unique However if there are multiple switches that accept ATM requests all catered to by different branches the respective branch code needs to be maintained Mandatory Numeric Nine Enter the ATM cash GL code This GL account will be debited on performing on us remote on us off us transactions Mandatory Numeric Nine Enter the deposit cash GL code Mandatory Numeric Nine Enter the acquirer fee GL code which accepts the card for performing the transaction Mandatory Numeric Nine Enter the forwarder fee GL code which is responsible for forwarding the transaction from the acquirer to the issuer Mandatory Numeric Nine Enter the incoming remit GL code Mandatory Numeric Nine Enter the outgoing remit GL code Mandatory Numeric Nine Enter the settlement GL code ORACLE 3 4 5 6 Click the Add button Enter the acquirer institution ID and press the lt Tab
145. n time Processing Start Display Time This field displays the file processing start time Last Processed Display Time This field displays the file processing time Completion Status Display This field displays the upload completion status Processing Status Display This field displays the file processing status 3 Enter the branch code or select it from the pick list and press the lt Tab gt Enter key 4 Select the file name from the pick list The system displays the file processing status View File Processing Status Upload Date osfo5 2010 ES Branch Code 240 Sanpoz mumBar File Name 240_IL_AMLHIGH aml J amp J Sent to FLEXCUBE Yo FLEXCUBE File Name 240_IL_AMLHIGH aml Error Description File Last Modified Time 05 05 2010 10 59 57 Processing Start Time 05 05 2010 11 45 27 Last Processed Time 05 05 2010 11 45 31 Completion Status COMPLETE Processing Status Files have been deleted gt _ ox _ close Clear 5 Click the Close button ORACLE BAM94 File Extract Inquiry Extracts are data files in format as required by external system taken from the FCR database Extract generation is done through the Parametrized Output Generator Fast Path BA453 option For a given set of parameters when an extract generation is requested you can inquire the status using this utility Definition Prerequisites e BA453 Parameterized Outpu
146. ndatory Pick List Select the system code from the pick list The user can select one of the system codes from all the file upload codes available in system File Type Mandatory Pick List Select the file type from the pick list The relevant file types under the system code will be available for selection the user can select the file type Lookup Value Mandatory Alphanumeric 120 Type the lookup value This filed is free text field without any validations Click the Add button Enter the system code and press the lt Tab gt or lt Enter gt key or select it from the pick list Enter the input file type and press the lt Tab gt or lt Enter gt key or select it from the pick list 0 O S w Type the lookup value LoopUp Code File Type Cross Reference File Type STOCKACCTBAL System Code ACCOUNT a amp Lookup Value 1233 Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized ORACLE 5 Click the Ok button 6 The system displays the message Record Added Autorisation Pending Click the Ok button ORACLE BA452 File Upload GEFU Using this option you can facilitate bulk miscellaneous transactions Including account customer with high severity memo i e you can use this option for bulk transactions bulk CASA account opening bulk CASA account closure etc The features of the GEFU functionality where if the multiple value dates specially future
147. ndicates the amount earmarked for a retry when an NSF condition is encountered in the previous attempt to charge FYTD Display This column displays the history of the service charge for the previous years The year beginning for this calculation is the financial beginning of year For example if the current date is 23 June 2004 this field will display the number of transactions for an account for a period from 1 April 2003 31 March 2004 where April 1 is the beginning of the financial year if 2003 option is selected in the Financial Year drop down list 9 Click the Close button SCMO06 SC Package Linkage to Code Task Using this option you can link Service Charge Package code to a particular maintenance or Task Code Definition Prerequisites e SCMO01 SC Package Definition Modes Available ORACLE Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add a template task cross reference 1 Type the fast path SCMO6 and click Go or navigate through the menus to Global Definitions gt Service Charge gt SC Package Linkage to Code Task 2 The system displays the SC Package Linkage to Code Task screen SC Package Linkage to Code Task SC Package Linkage to Code Task Task Code CHOO1 E Package Code cv118 CLOSE_OUT WITHDRAWAL x a Record Details Input By Authorized By Last Mnt Date Last Mnt Action A
148. nding Click the Ok button The external file set up is done once the record is authorised BA450 LoopUp Code File Type Cross Reference This option is used for setting up lookup values system code lookup value ORACLE The name value pair list will act as an aide in file type selection In File Upload GEFU option Fast Path BA452 after entering the system code a new field Company Code will be added This will show the list of companies maintained in the list On selecting the company code the file type will get defaulted File type changes in File Upload GEFU option to accept lookup value and resolve file type on the basis of file type lookup value combination Definition Prerequisites Not Applicable Modes Available Add Modify Delete Cancel Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To set the file type cross reference 1 Type the fast path BA450 and click Go or navigate through the menus to Global Definitions gt Customer gt LoopUp Code File Type Cross Reference 2 The system displays the LoopUp Code File Type Cross Reference screen LoopUp Code File Type Cross Reference System Code File Type Lookup Value Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description ORACLE Field Name Description System Code Ma
149. ne Type the BC issue GL code This GL account will be credited when BC issue requests are received through Internet Banking 3 Click the Add button 4 Type the bank code and press the lt Tab gt or lt Enter gt key 5 Enter the required information in the various fields IB Bank Params Maintenance ORACLE IB Bank Params Maintenance Bank Code 25 Funds Transfer Currency Account Currency x Service charge at EOD v Fee GL 100031800 Funds Appropriation Sequence s BC Issue GL 100020250 Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized TINTER1 TINTER1 22704 2008 14 59 14 Authorize Delete Gencel Amend Authorize O Inquiry 6 Click the Ok button 7 The system displays the message Record Authorized Click the OK button 8 The internet bank parameters are added BAIB2 IB Bill Company Details Maintenance Using this option you can accept bill payments on behalf of service providers for a fee In such cases the customers of the billing company will pay their bills to the bank and the bank in turn will credit the account of the billing company The billing companies who want to avail this facility have to register their details with the bank and must have a savings and checking account with the bank The bank will register the details of the billing company in the billing company details This maintenance is required for the
150. nk for which global ATM definitions should be maintained Each code uniquely identifies a different bank Mandatory Numeric 10 Type the acquirer fee GL code This GL account will be credited for fees on transactions done by banks which act as Acquirer institutions Optional Check Box Select the Allow Funds Transfer Across Customers check box if you want to allow the transactions involving funds transfer across different customers Mandatory Numeric 10 Type the issuer fee GL code This GL account will be credited for fees on transactions done through the Bank s ATM network Optional Check Box Select the Levy Issuer Fee Online check box if you want to debit the issuer fees online simultaneously along with the transaction Issuer fees is normally passed on by the switch ETBI on which the ATM TBS runs Issuer fees is included in the message that is passed on by the switch ETBI and gets debited online with the original transaction amount provided this flag is checked Mandatory Numeric 11 Type the acquirer institution ID The institution ID is allotted to the bank by the central bank or the governing body for non branch channels like TBS ATM and POS ORACLE Field Name Description Funds Mandatory Alphanumeric Five Appropriation i Sequence Type the funds appropriation sequence This field denotes the sequence in which the transaction amount should be appropriated while debiting the acc
151. nload Upload File ORACLE File Name Test Posting Date 2202 2008 Action Download File ok sws Cancel 5 Click the Ok button 5504 Download Upload Status Inquiry Using this you can view the status of the upload request after uploading or downloading data file into the system Definition Prerequisites Not Applicable Modes Available Not Applicable To view the download upload status 1 Type the fast path 5504 and click Go or navigate through the menus to Operator Processes gt Data Download Options gt Download Upload Status Inquiry 2 The system displays the Download Upload Status Inquiry screen Download Upload Status Inquiry ORACLE tus Inquiry DE Field Description Field Name Description Request ID Mandatory Alphanumeric 30 Type the request id of the file whose download or upload status needs to be inquired This Id is generated by the system after uploading the file using the GEFU upload option or the Download Upload file Option 3 Type the request ID Download Upload Status Inquiry ORACLE Download Upload Status Inquiry Request ID 1234 Gees cance 4 Click the Status button 5 The system displays the status of the download upload file status 8891 Download Log Download Log option is where verification is done for download request made by the branch by schedule or even when Adhoc download is made by the Data Center Operat
152. nsaction amount needs to be appropriated while debiting the account Valid values are a combination of the following components e S Sweep in e O Overdraft e V Overline e A Advance against unclear funds e T Temporary Overdraft 3 Click the Add button 4 Enter the required information in the various fields POS Bank Params Maintenance Bank Code Es 1 _ Debit Suspense GL Institution Id haz o Issuer Fee GL 100022150 POSCash GL 100022150 Forwarder Cash GL 100022150 Acquirer Cash GL 100022150 Forwarder Fee GL 100022150 Acquirer Fee GL 100022150 Debit Suspense GL ro00ze000 Credit Suspense GL 100036000 Code Discount GL 100022150 Allow Funds Transfer Across Customers 7 Levy Issuer Fee Online iv Funds Appropriation Sequence soa Record Details E By 5 Click the Ok button 6 The system displays the message Record Added Authorization Pending Click Ok to Continue Click the OK button Authorized By Last Mnt Action Authorized Last Mnt Date EE ok cise 7 The POS bank parameters are added once the record is authorised ORACLE POS04 POS BIN Xref Maintenance Using this option you can define the bank level global definitions related to POS transactions and decide whether funds transfer across customers can be permitted for POS transactions or not Definition Prerequisites e GL acco
153. nsactions done through the bank s POS network by the customers of other banks Mandatory Numeric Nine Type the GL to be credited on transactions done by other bank s customers through the POS network owned and managed by our bank in the capacity of a forwarder Mandatory Numeric Nine Type the GL to be credited for fee amounts out of transactions where in the said bank acts as an acquirer institution Mandatory Numeric Nine Type the GL to be debited in case of suspense generation on account of POS transactions Mandatory Numeric Nine Type the GL to be credited in case of suspense generation on account of POS transactions Mandatory Numeric Nine Type the code discount GL This GL is used for Merchant discounts Optional Check Box Select the Allow Funds Transfer Across Customers check box if the transactions involving funds transfer across different customers should be permitted Optional Check Box Select the Levy Issuer Fee Online check box to debit the issuer fees online simultaneously with the transaction Issuer fees is normally passed on by the switch ETBI on which the POS TBS runs Issuer fees is included in the message that is passed on by the switch ETBI and gets debited online with the original transaction amount provided this flag is checked ORACLE Field Name Description Funds Appropriation Sequence Mandatory Alphanumeric Five Type the sequence in which the tra
154. nsfer across customers can be permitted for TBS transactions or not Transactions that are happening through TBS channel are dependent on these parameters ORACLE Normally transaction fee issuer fee is charged by the switch for the TBS transactions If the Levy Issuer Fee Online check box is selected this fee will be debited online with the original transaction amount Definition Prerequisites Not Applicable Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add TBS bank parameters 1 Type the fast path TBS01 and click Go or navigate through the menus to Global Definitions gt Channels gt TBS Bank Params Maintenance 2 The system displays the TBS Bank Params Maintenance screen TBS Bank Params Maintenance Bank Code Bank Parameters Acquirer Fee GL Allow Funds Transfer Across Customers Issuer Fee GL Levy Issuer Fee Online Acquirer Institution Id Funds Appropriation Sequence Record Details fe By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description ORACLE Field Name Bank Code Bank Parameters Acquirer Fee GL Allow Funds Transfer Across Customers Issuer Fee GL Levy Issuer Fee Online Acquirer Institution Id Description Mandatory Numeric Five Type the bank code of the ba
155. o inquire the details Optional Alphanumeric 35 Type the task for which you want to search the upload details Optional Alphanumeric 255 Type the name of the file for the upload query Description Display This column displays the file id as per the given search criteria Display This column displays the reference description for the searched file Display This column displays the status of the file upload Display This column displays the nature of transaction Display This column displays the reason for failure incase the uploading has failed in Upload Local File to Finware Fast Path 8239 option 3 Click the View button The system displays the status of the file uploaded to finware 4 Select the teller ID from the drop down and press the lt Tab gt or lt Enter gt key File Upload To Finware Status Inquiry ORACLE Teller ID TUMA v Posting Date Status Ref No Task File Id Description Status Upload Download Reason for failure load u n nnectto remote host vie BA455 View File Processing Status Branch may process various upload transactions during the day Processing and completion status is essential to track the uploaded transactions This screen displays the upload file status in database based on branch code and upload date Definition Prerequisites Not Applicable Modes Available Inquiry For more information on the procedures of every mo
156. odes have to be defined Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add ATM bank parameters 1 Type the fast path ATMO1 and click Go or navigate through the menus to Global Definitions gt Channels gt ATM Bank Params Maintenance ORACLE 2 The system displays the ATM Bank Params Maintenance screen ATM Bank Params Maintenance ATM Bank Params Maintenance on 7 Bank Code e ATM Cash GL Acquirer Cash GL Acquirer Fee GL Credit Suspense GL Remittance Credit GL Funds Approp Sequence Record Details iw By Authorized By Last Mnt Date Last Mnt Action Authorized O Add O modify O Delete O O O i a 9 s Inquiry Field Description Field Name Description Bank Code Mandatory Numeric Five Type the code of the bank for which global ATM definitions should be maintained Each code uniquely identifies a different bank Institution Id Mandatory Numeric 11 Type the institution code Each code uniquely identifies the bank in the network Institution ID is allotted by the central bank of the country or the body that governs payment systems in the country Issuer Fee GL Mandatory Numeric Nine Type the issuer fee GL code This GL account will be credited for fees on transactions done through the Bank s ATM network ORACLE Fi
157. oduct code for which funds transfer needs to be restricted or allowed from the drop down list To Product Code Mandatory Drop Down Select the product code to which funds transfer needs to be restricted or allowed from the drop down list Transfer Optional Check Box Disallowed Select the Transfer Disallowed check box if you want to disallow the funds transfer between the selected products 3 Click the Add button 4 Select the from product code and to product code from the respective drop down list IB Block Transfer Across Products ORACLE From Product Code To Product Code Transfer Disallowed Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized j Cancel Amend Authorize O Inquiry 5 Click the Ok button 6 The system displays the message Record Authorized Click the OK button 7 The transfer of funds across products under Internet Banking facility is blocked BA092 Auto Relock Time Maintenance Using this option you can set the auto relock time for your system You can enter the time in which the system will be locked if not used by the user Definition Prerequisites Not Applicable Modes Available Add By Copy Add Modify Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add the auto relock time details 1 Type the fast path BA092 and click Go
158. on Display This field displays the provisioning rate for the account as provided by the external system Display This field displays the customer account risk category for the account as provided by the external system Conditional Numeric 13 Two Type the discounted cash flow of credit for the account This field is enabled for Individually Assessed group of accounts The value for this field is in the account currency and is used for provision calculations Conditional Numeric 13 Two Type the discounted cash flow of credit for the account This field is enabled for Individually Assessed group of accounts The value for this field is in the local currency Conditional Numeric 13 Two Type the discounted collateral value for the account This field is enabled for Individually Assessed group of accounts The value for this field is in the account currency and is used for provision calculations Conditional Numeric 13 Two Type the discounted collateral value for the account This field is enabled for Individually Assessed group of accounts The value for this field is in the local currency Mandatory Pick List dd mm yyyy Select the date from the pick list to indicate the start date for the generation of Provision History Mandatory Pick List dd mm yyyy Select the date from the pick list to indicate the end date for the generation of Provision History Description ORACL
159. on 8 The system displays the message Record Added Authorisation Pending Click Ok to Continue Click the Ok button 9 The schedule gets setup once the record is authorised BAM54 External File Setup Files generated by external systems consist of various types of transactions that needs to be uploaded and processed within FLEXCUBE Using this option you can setup the upload parameters for the combination of external system code and file type associated GL s and the scheduling When the future date arrives the system will automatically process the file uploaded and subsequently the debit credit will be taken place Automatic upload takes place if the scheduling for this activity is setup If deferred authorization is maintained for the upload type in the screen then the file can be inquired by selecting the file status as Unauthorized from status drop down field And the record status will be updated as Not processed If the file is not authorized on the same day FLEXCUBE will purge the file as a part of the EOD process Definition Prerequisites Not Applicable Modes Available Add By Copy Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To view the file upload setup 1 Type the fast path BAM54 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Handoff gt
160. on Account Linkage Issue Reissue Display TIN Accounts Linked This field display the issuance status of the TIN ORACLE Column Name Description Account No Display This field displays the account number of the selected customer Account Display Relation This field displays the customer account relation Module Display This field displays the account type Link Y N Toggle Click the toggle status to change the value to Y to link the account for TIN generation By default the system displays the value as N 3 Click the Add button 4 Select the search criteria from the drop down list 5 Type the search string press the lt Tab gt or lt Enter gt key 6 The system displays a list of customer s that match the search criterion 7 Select the customer from the pick list The customer details are displayed in the screen IVR TIN Request IVR TIN Request Customer Information Search Criteria Search String 600045 Ic ID s90 Full Name Short Name gt Account Linkage IssuefReissue TIN 900000004325 i sow CH N 000000004341 SOW CH N sow CH N 000000004440 sow I CH N 000000004465 I sow I CH N 000000004473 Ji SOW CH N 000000004861 I SOW I CH N 000000004887 sow CH N Accounts Linked 000000004911 sow I CH N 000000009621 I SOW I cH N 000000009670 I Sow I CH N 000000009720 sow CH N 0000000
161. on User Manual ORACLE Inventory IV001 Stock Transactions Using this option you can execute the following e Request stock from the central inventory The request can be regular or adhoc with stock inventory code denomination details and total quantity required e Keep track of stock ordered from suppliers The purchase order number date purchase and inventory details e Keep record of stock received from the suppliers The receipt date and the received inventory details e Issue stock to branches The issued date branch and the issued inventory details Definition Prerequisites Not Applicable Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add stock transaction details 1 Type the fast path IV001 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Inventory gt Stock Transactions 2 The system displays the Stock Transactions screen Stock Transactions ORACLE Transaction Request Stock f n Request Stocks Request No Request Type Ad hoc Request Reason Reference No 1 Requesting Branch Date of Request 1 5 SRS Reference No 2 _ Record Details _ Input By Field Description Field Name Description Transact
162. once the record is authorised ORACLE General Ledger Transactions 1060 GL Miscellaneous Debit Against Cash Using this option a general ledger account of the transaction branch can be debited and the corresponding credit can be passed to the Cash GL account in the same branch Definition Prerequisites Not Applicable Modes Available Not Applicable To debit miscellaneous transaction to general ledger account 1 Type the fast path 1060 and click Go or navigate through the menus to Transaction Processing gt GL Transactions gt Cash gt GL Miscellaneous Debit Against Cash 2 The system displays the GL Miscellaneous Debit Against Cash screen GL Miscellaneous Debit Against Cash ORACLE GL Cey INR v Txn Amount GL Amount Reference Number User Reference No Narrative MISC DEBIT GL Ccy Rate 1 00000 Txn Cey nm S Txn Ccy Rate 1 00000 Field Description Field Name Description GL Ccy Mandatory Drop Down Select the GL currency of the GL account to be debited from the drop down list This can be different from the local currency Txn Ccy Mandatory Drop Down Select the transaction currency in which the cash is to be paid out from the drop down list While posting the transaction entries to the account the transaction currency is converted into the account currency and for posting the GL entries it is converted into the local currency of the bank GL Account Mandato
163. or future use Optional Alphanumeric 30 Type the user reference number assigned to the customer ORACLE Field Name Description Narrative Optional Alphanumeric 120 Type the narration based on the transaction By default the system displays narration depending on the transaction 3 Select the GL currency and transaction currency from the drop down list 4 Select the GL account number from the pick list 5 Enter the transaction amount and reference number GL Miscellaneous Credit Against Cash inst Cash GL Cey uso Txn Cey um S GL Account fiooozz1so cHany CJ GL Cey Rate 4 55000 Txn Cey Rate 1 00000 Txn Amount 45 000 00 GL Amount Reference Number 56323 User Reference No 4888 Narrative GL Miscellaneous Credit Against Cash 6 Click the Ok button 7 The system displays Authorizsation Required Do You Want to continue Click the OK button The system displays the Authorization Reason screen Enter the relevant information and click the Grant button 10 The system displays the transaction sequence number message box The transaction number is system generated that uniquely identifies each transaction performed by a teller and can be used for tracking the transaction Click the OK button Note For more information on Authorization transactions refer to the FLEXCUBE Introduction User Manual ORACLE 1005 Miscellaneous GL Transfer
164. or navigate through the menus to Global Definitions gt Master gt Auto Relock Time Maintenance 2 The system displays the Auto Relock Time Maintenance screen Auto Relock Time Maintenance ORACLE Auto Relock Time Maintenance System Type v Starting Date to Apply Auto Re lock Time min Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description System Type Mandatory Drop Down Select the system type from the drop down list It is the type of system for which you want to set the auto relock time The options are e ATM e IB Starting Date to Conditional Pick List dd mm yyyy Apply Select the starting date from the pick list The date from which the auto relock time will be effective Auto Re lock Time Conditional Numeric Four Type the auto relock time It is the time in which the system will be locked if not used after logging in the system The auto relock time should be entered in minutes Click the Add button Select the system type from the drop down list and the starting date to apply from the pick list 5 Enter the auto relock time ORACLE Auto Relock Time Maintenance Bu System Type ATM Starting Date to Apply 31 12 2008 Auto Re lock Time 4 Min Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Claddsy copy add O modfy 0 O cancel
165. or or System Administrator in the Branch The Log or Details of download will be displayed with respect to the Teller Branch A user cannot view details of download for other branches Definition Prerequisites Not Applicable Modes Available Not Applicable To view the download log 1 Type the fast path 8891 and click Go or navigate through the menus to Operator Processes gt Data Download Options gt DownLoad Log 2 The system displays the File Upload Inquiry GEFU screen File Upload Inquiry GEFU ORACLE Request For Branch Criterion Entity gt Name Entity Branch Date From p quester Lec z Lec z ja Bank Codes Field Description Field Name Description Request For Mandatory Drop Down Select the option from where the request is made from the drop down list The options are e Host If the user selects this option then the system displays the number of times the download request has been made by the Branch server to the Central Database server and whether data extraction is successful or not e Branch If the user selects this option then the system displays the number of times the download request has been made to the host and whether data loading is successful to the Local Branch Server or not ORACLE Field Name Criterion Name Entity Branch Date From Date To Column Name Description Mandatory
166. ords Sum of Part 2 remaining 13 digits of record level checksum of all records The new checksum logic for OCC files is as below e The record checksum will be Sum of digits of account in an incremental pattern where every next instance is considered as complete number amount to be considered in full without decimal ref sys no transaction date YYYYMMDD transaction currency e Footer Checksum will be Sum of Part 1 last 7 digits of all record level checksum of all records Sum of Part 2 remaining 13 digits of record level checksum of all records Definition Prerequisites e BAM54 External File Setup Modes Available Not Applicable To upload the file Generic External File Upload ORACLE 1 Type the fast path BA452 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Handoff gt File Upload GEFU 2 The system displays the File Upload GEFU screen File Upload GEFU File Upload GEFU fe FR External System Code El Lookup Value File Type es Upload File Handoff File Details Input File Name Narration Process Date 07 04 2017 g ok cise _ciear_ Field Description Field Name Description External System Mandatory Pick List Code Select the external system code against which the file was uploaded from the pick list The corresponding external system name is displayed in
167. ount The options are e S Sweep lIn e O Overdraft e V Overline e A Advance against unclear funds e T Temporary Overdraft 3 Click the Add button 4 Type the bank code and press the lt Tab gt or lt Enter gt key 5 Enter the required information in the other fields TBS Bank Params Maintenance TBS Bank Params Maintenance Bank Code _ Bank Parameters a lt Fee GL 100031800 Allow Funds Transfer Across Customers Issuer Fee GL 100031800 Levy Issuer Fee Online Acqui Acquirer Institution Id i1 Funds Appropriation Sequence OSA _ Record Details _ Input By Authorized By Last Mnt Date Last Mnt Action Authorize d 6 Click the Ok button 7 The system displays the message Record Added Authorization Pending Click Ok to Continue Click the OK button ORACLE 8 The TBS bank parameters are added once the record is authorised TBS02 TBS Acquirer Pos ID Maintenance Using this option you can maintain the various ETBI IDs the channels that originate from these ETBIs and the originating branch code for a particular ETBI In a centralized TBS environment the branch code is unique In case of multiple Switches that accept TBS requests where all switches are catered to by different branches the respective branch codes need to be maintained Transactions that occur through TBS channel are dependent on these parameters Definition
168. ount Based Search _ Account Number E Name Provisioning Group Provisioning Sub Group Provisioning Rate Customer Account Risk Category nd Modification for and Overdraft Discounted cash Flow of Credit ACY _ Discounted Collateral Yalue ACY Discounted Collateral Value LCv _ Discounted cash Flow of Credit LCv Provision History From Date 15 01 2008 i E To Date 15 01 2008 Field Description Field Name Description Account Based Search Account Number Name Provisioning Group Provisioning Sub Group Mandatory Numeric 14 Type a valid CASA Loan account number for which provision details are required to be modified inquired Display This field displays the name of the customer Display This field displays the applicable provisioning group for the account as provided by the external system The options for the group are e Individually Assessed e Commonly Assessed Display This field displays the applicable provisioning sub group for the provisioning group as provided by the external system ORACLE Field Name Provisioning Rate Customer Account Risk Category Discounted cash Flow of Credit ACY Discounted cash Flow of Credit LCY Discounted Collateral Value ACY Discounted Collateral Value LCY Provision History From Date To Date Column Name Descripti
169. ount of SC arrears Other Arrears Display This field displays the sum of all the other arrears on the loan account Other Arrears include Premium Legal Fees and Outgoing Arrears CRR History CRR Enquiry Customer m Search String Account Number 50000000309611 r Customer Information Customer ID 603898 Customer IC ASHISH09111977 Customer Name ASHISH S GOKHALE Customer CRR 10 Standard Home Branch MAIN BRANCH AccountCRR Account Details age Customer CRR History Universal CRR History Current Arrear Details Arrear Details as on NPA Date Crr Evaluation Details Account Number 50000000309611 Present Account CRR 10 Standard Accrual Status Normal Date Previous CRR New CRR Reason Initiated By Anesized 31 12 2013 3001 LOSS ASSET 1 3005 ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLM EQUALIZATION BY 50100000302391 SYSTEM _ SYSTEM 31 12 2013 1 ZERO DPD 300 1 LOSS ASSET 1 P SYSTEM SYSTEM 31 12 2013 1 ZERO DPD 1 ZERO DPD ACCOUNT OPENING TDINESH SYSTEM o fo 4 gt Field Description Field Name Description ORACLE Field Name Description Account Number Display This field displays the account numbers Present Account Display CRR This field displays the current CRR of the account Accrual Status Display This field displays the current accrual status of the account Column Name Description Date Display
170. ource Definition Prerequisites e BAM5D4 External File Setup Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To setup a schedular 1 Type the fast path BAM53 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Handoff gt SCHEDULAR SETUP 2 The system displays the SCHEDULAR SETUP screen SCHEDULAR SETUP ORACLE External System Code File Type Start Date o17o1 1800 Ee End Date 01701 1 Upload File Name wild card p Scheduler Type Record Details e By Authorized By Last Mnt Date Last Mnt Action Authorized add O modi O dele Oca O Amend O ok Field Description Field Name Description External System Code File Type ID Mandatory Pick List Select the external system code from the pick list Mandatory Pick List Select the file type from the pick list Display This field displays the scheduler ID This value is incremented by one everytime a scheduler is setup 3 Click the Add button 4 Select the external system code and file type from the pick list SCHEDULAR SETUP ORACLE External System Code AP File Type AP_CH_EXTRACT_ADHOC_CAP ID Sana OR Start Date 01 01 1800 g End Date 01 01 1800 E Uploa
171. que Book Issue Upload File Name Batch Number Field Description ORACLE Field Name Description File Name Mandatory Alphanumeric 20 Type the name of the cheque book issue file maintained in the RJSin folder on the application server Batch Number Display This field displays the system generated batch number 3 Enter the file name and press the lt Tab gt or lt Enter gt key Cheque Book Issue Upload 4 Click the Ok button The system displays the message Authorization Required Do You Want to continue Click the Ok button 6 The system displays the Authorization Reason screen 7 Enter the required information and click the Ok button 8 The system displays the message File Uploaded Successfully Click the Ok button 7239 Upload Local File Using the Upload Local File option you can download the extracted files to the RJSOUT folder This option can also be used to upload the file from the local machine ORACLE Definition Prerequisites e BA453 Parameterized Output Generator For file download e Copy the File from RJSOUT to the local system for file upload Modes Available Not Available To upload a local file 1 Type the fast path 7239 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Others gt Upload Local File 2 The system displays the Upload Local File screen Upload Local File File Description
172. quest Status option is selected from the Stock Inquiry drop down list Req Flag Display This column displays the request flag type This column is displayed if the Indent Request Status or Stock Transactions option is selected from the Stock Inquiry drop down list Purchase ID Display This column displays the purchase ID This column is displayed if the Indent Request Status option is selected from the Stock Inquiry drop down list Qty Display This column displays the quantity ordered Recorder Level Display This column displays the recorder level This column is displayed if the Balance on Hand option is selected from the Stock Inquiry drop down list 8 Double click a record to enable the Denomination Details tab Denomination Details ORACLE Stock Inquiry Balance on Hand User ID Indent Request Reference Purchase Order Reference Trans Type Branch g Stock Code Date From 15704 2008 Date To 15 04 2008 Current Balance of units j Denomination Balance of units ils Stock Details Purchase Details TC CITIBANK Field Description Column Name Description Denomination Display This column displays the denomination value in words Currency Short Display Name This column displays the currency code in which the denomination is made Denomination Display Value This column displays the denom
173. r CRR History Universal CRR History Current Arrear Details Arrear Details as on NPA Date PoMS CUELGO els Account CRR Code Universal CRR Code Customer CRR Code 10 Standard 10 Standard 10 Standard NPADPD Interest Arrear DPD CAM Expiry DPD Inactivity Days LTV Breach DPD TOD Overline DPD Liquid Collateral Breach DPD Stock Statement Submission DPD e o ol ol ojcjojo NPA Date Oldest Interest Arrear Date CAM Expiry Date Date Last Credit LTV Breach Date TOD Overline Date Liquid Collateral Breach Date Stock Statement Submission Date Actual LTV 0 00 Allowed LTV Liquid Collateral Amount 0 00 Field Description Field Name Description Account CRR Code Universal CRR Code Customer CRR Code NPA DPD NPA Date Display This field displays the Account CRR code and corresponding description Display This field displays the Universal CRR code and corresponding description Display This field displays the Customer CRR code and corresponding description Display This field displays the number of days from NPA date for which the account is suspended Display This field displays the date on which the account moved from Normal to Suspended bucket ORACLE Field Name Interest Arrear DPD Oldest Interest Arrear Date CAM Expiry DPD CAM Expiry Date Inactivity Days Date Last Credit LTV Breach DPD LTV B
174. ransactions Entries in this GL should be manually reversed out after rectifying the cause of suspense Mandatory Numeric Nine Type the remittance debit GL code The GL will be debited if the other bank account holder is allowed to give debit instructions for debiting an ATM bank customer The reconciliation or accounting of the remittance debit GL has to be done operationally from the file hand off ORACLE Field Name Remittance Credit GL Settlement GL Remit Branch Code Allow Funds Transfer Across Customers Levy Issuer Fee Online Funds Appropriation Sequence Description Mandatory Numeric Nine Type the remittance credit GL code The GL will be credited if the ATM facilitates fund transfer option and the customer of the bank does a fund transfer from his account to an external account The reconciliation or accounting of the remittance credit GL has to be done operationally from the file hand off Mandatory Numeric Nine Type the settlement GL code This GL account will be debited or credited in case of remote on us or off us transactions The net balance in this GL will be claimed from or paid to other banks in the network Optional Alphanumeric 12 Type the branch code for remittance Optional Check Box Select the Allows Funds Transfer Across Customers check box if you want to allow the transactions involving funds transfer across accounts belonging to different customers
175. rd Added Authorization Pending Click Ok to Continue Click the OK button User Defined Entity ORACLE 9 The POS acquirer POS ID is added once the record is authorised POS02 POS Bank Params Maintenance Using this option you can define the bank level global definitions related to POS transactions and decide whether funds transfer across customers can be permitted for POS transactions or not Transactions that are happening through POS channel are dependent on these parameters The various GL accounts for the POS and the suspense GL accounts are maintained in this option Normally transaction fee issuer fee is charged by the switch for the POS transactions If the Levy Issuer Fee Online check box is selected this fee will be debited online with the original transaction amount Definition Prerequisites e GL accounts to have maintained Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add POS bank parameters 1 Type the fast path POSO2 and click Go or navigate through the menus to Global Definitions gt Channels gt POS Bank Params Maintenance 2 The system displays the POS Bank Params Maintenance screen POS Bank Params Maintenance ORACLE POS Bank Params Maintenance Bank Code __ Debit Suspense GL Institution Id Code Discount GL Allow Funds Transfer Across Custo
176. re centralized the branch code would be unique However if there are multiple switches that accept POS requests all catered to by different branches the respective branch code should be maintained Mandatory Numeric Nine Type the Cash GL Account number Mandatory Pick List Select the applicable Cash Branch Code from the pick list ORACLE Field Name Description Spend class Optional Pick List Select the spend class from the pick list The spend class defined against the POS ID will be returned in the UDE UDE Spend Sub class Optional Pick List Select the spend sub class from the pick list The spend sub class defined against the Spend Class will be returned in the UDE 3 Click the Add button 4 Enter the required information in the various fields 5 Click the Validate button The system enables the last two fields 6 Enter the GL account number and select the originating branch code POS Acquirer POS Id Maintenance POS Acquirer POS Id Maintenance amp Pie Acquirer Institution Id ___ 7 Forwarder Institution Id Card Acceptor Identification Code Card Acceptor Terminal Id POS GL Account No Originating Branch Code CASH GL Account No CASH Branch Code Spend Class Spend Sub Class Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized 7 Click the Validate button and then click the Ok button 8 The system displays the message Reco
177. reach Date Actual LTV Allowed LTV TOD Overline DPD TOD Overline Date Description Display This field displays the DPD for the oldest interest arrear irrespective of type of arrear Display dd mm yyyy This field displays the date of oldest interest arrear Display This field displays the number of days since CAM has expired Display dd mm yyyy This field displays the CAM expiry date Display This field displays the number of days for which the account was inactive Display This field displays the date on which last credit was made on account Display This field displays the number of days since LTV Breach date Display dd mm yyyy This field displays the date on which LTV for the account has come more than the LTV Allowed for the account product Display This field displays the LTV ratio of account Display This field displays the allowed LTV ratio for the account as defined in Product master Display For OD Limits not backed by Liquid Collateral this is the number of days from TOD Overline date Display dd mm yyyy For OD limits backed by Liquid Collateral this will be NULL For OD limits not backed by Liquid Collateral this is the date on which the account turned TOD when OD Limit 0 or Overline when outstanding balance in account gt OD Limit and o s bal lt 0 ORACLE Field Name Description Liquid Collateral Display Breach DPD For OD li
178. remaining LV 20 C C gt 0 then provision P c 20 C 0 236 Provision rate 4 72 4 P off balance eligibility 300 0 remaining LV 300 D D gt 0 then provision P off 300 D 0 236 Provision rate 70 8 Total provision 47 2 11 8 4 72 70 8 134 52 Note LV Liquidation Value LV Discounted Value of Collateral Discounted value of Cash flow of credit ACM07 Provisioning Parameters at Bank level for Loans and Overdrafts Using this option you can define the bank level parameters for the provisioning groups and components of the provisioning base The components of provisioning bases can be subsequently modified The provisioning will consider the new components of provisioning bases from the date of modification In case any new component is added the provisioning for the new component will happen from the date of modification and in case an existing component is excluded from the provisioning base the provision for that component will get nullified by the system Definition Prerequisites Not Applicable Modes Available Add By Copy Add Modify Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add provisioning parameters at bank level for loans and overdrafts 1 Type the fast path ACMO7 and click Go or navigate through the menus to Global Definitions gt AC gt Provisioning Parameters at Bank level for Loans and Overdrafts 2
179. ring Account Number Customer Information Customer ID Customer IC Customer Name Description Conditional Alphanumeric 20 Type the search string to search for a customer corresponding to the criteria selected in the Customer drop down list If the search criterion is specified as customers short name or Customer IC then any of the letter s of the short name or IC can be entered The system displays the pick list of all those customers having those letters in their respective criteria Select the appropriate customer from the existing customer list For example The customer s short name is George Abraham One can search the above customer by entering Geo in the Search String field Optional Radio Button Click Account number to view CRR details for a particular account number Display This field displays the ID of the customer A customer ID is an identification number generated by the system after customer addition is completed successfully This running number unique to a customer across the system is generated after the system has identified the Customer IC and Customer Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system The ID should be such that it is in conjunction with the customer Type and can determine if the customer is an existing customer A social security number passport number can be used Display Thi
180. ry Pick List Select the GL account number from the pick list The GL name is populated adjacent to the GL account number This is the GL account in the transaction branch which will be debited ORACLE Field Name GL Ccy Rate Txn Ccy Rate Txn Amount GL Amount Reference Number User Reference No Description Display This field displays the GL currency rate The exchange rate at which the GL account currency is converted to local currency of the bank of conversion to be used for converting the GL currency to the local currency of the bank The exchange rate values must be defined and downloaded The teller s right to change the GL currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Depending on the configurable option at the bank level the teller can modify this rate within certain boundaries The teller s right to change the account currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Display This field displays the rate at which the transaction currency is converted to the local currency of the bank The teller s right to change the transaction currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Depending on the configurable option at the bank level the teller can modif
181. s Account Details Code Ccy Description Type Priority CapType Cap Freq Anniv Day Anniv Month AED Low Bal Charges Current Acct Periodic 1 Calendar Monthly 0 AED Semi Annual Handling Charges Periodic 2 Calendar Half Yearly AED TC Sale Charges Others 3 Calendar Daily AED TC Encashment Charges Others 4Anniversary Daily AED Cheque Discounting Charges Others 5 Anniversary Daily AED PDC Handling Charges Others 6 Anniversary Daily AED PDC Cancellation Charges Others 7 Anniversary Daily AED Standing Order Set Up Charges Others 8 Anniversary Daily AED Standing Order Failure Charges Others 9 Anniversary Daily AED Standing Order Amendment Charges Others 10 Anniversary Daily AED Stop Payment Charges Others 11 Anniversary Daily AED Inward Cheque Return Charges Others 12 Anniversary Daily AED Outward Cheque Return Charges Others 13 Anniversary Daily AED Dormancy Charges Periodic 14Anniversary Daily AED Account Closure Charges Others 15 Anniversary Daily AED Duplicate Statement Charges Others 16 Anniversary Daily O GOOO Oro OO sonic OOG OCOLO Ovo oO ere oOo Sl Os nse Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized DCO C DC ooo m Add C Modify Delete Cancel C Amend C Authorize Inquiry _Ok close Clear Field Description Field Name Description ORACLE Field Name Search Criteria Search String Full Name Service Charge Package Description Mandatory Drop Down
182. s 7 Anniversary Daily AED Standing Order Set Up Charges Others 8 Anniversary Daily AED Standing Order Failure Charges Others Anniversary Daily AED Standing Order Amendment Charges Others 10 Anniversary Daily AED Stop Payment Charges Others 11 Anniversary Daily AED Inward Cheque Return Charges Others 12 Anniversary Daily AED Outward Cheque Return Charges Others 13 Anniversary Daily AED Dormancy Charges Periodic 14 Anniversary Daily AED Account Closure Charges Others 15 Anniversary Daily AED Duplicate Statement Charges Others 16 Anniversary ono O 0O o oo ooo O o Sco og SO so ooo Ooo Bola Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Add C Modify Delete Cancel C Amend C Authorize Inquiry Field Description Column Name Description Code Display The SC code This column is non editable Ccy Display The currency in which the service charge is levied Description Display The SC name as the description for the service charge code Type Display The service charge linkage type e Periodic SC applied in a frequency e Others SC applied adhoc without a frequency Priority Display The order in which the service charges shall be applied SC will be applied in the ascending order of priority at the time of application ORACLE Column Name Description Cap Type The SC capitalisation type The options are e Calendar SC application date will be calendar base
183. s field displays the identification code of the customer A customer IC along with customer type is a unique method of customer identification across the bank covering all branches Based on the combination the system can identify the customer as an existing customer even when the customer opens a new account in another branch A social security number passport number birth certificate or corporate registration can be used as a customer IC The IC should be such that it is in conjunction with the customer Type and can determine if the customer is an existing customer A social security number passport number can be used Display This field displays the name of the customer ORACLE Field Name Description Customer CRR Display This field displays the customer CRR The customer will be assigned the worst CRR of all the accounts and all the accounts will follow the customers CRR Home Branch Display This field displays the name of the home branch where the CASA account loan account is maintained Account CRR Customer Search String Account Number 50000000311552 Customer IC ASHISH09111977 Customer Name ASHISH S GOKHALE Home Branch MAIN BRANCH y Customer CRR History Universal CRR History Current Arrear Details Arrear Details as on NPA Date Crr Evaluati Account Number Present Account CRR Expected Account CRR Accrual Status Present UCRR 50000000309232 _ 10 Standard
184. s originate There could be multiple channels originating from the same ETBI Mandatory Drop Down Select the originating branch code from the drop down list The originating branch code refers to the branch through which the TBS transactions would be routed to the respective branches In practical scenarios where all TBS operations are centralized the branch code would be unique However if there are multiple switches that accept TBS requests all catered to by different branches the respective branch code should be maintained 3 Click the Add button 4 Type the acquirer institution ID and press the lt Tab gt or lt Enter gt key 5 Enter the required information in the other fields TBS Acquirer Pos ID Maintenance ORACLE TBS Acquirer Pos ID Maintenance Acquirer Institution Id TBS Identification Code 5 Channel Number Originating Branch Code HO v _ Record Details _ Input By Authorized By Last Mnt Date Last Mnt Action Authorized m m 6 Click the Ok button 7 The system displays the message Record Added Authorization Pending Click Ok to Continue Click the OK button 8 The TBS acquirer POS ID is added once the record is authorised TBSO3 IVR TIN Request Using this option you can generate telephonic identification number TIN of the customer The customer can request TIN on IVR If the customer has multiple accounts the accounts which has to be linked
185. scription ORACLE Field Name Description Transaction Mandatory Pick List pemone Select the transaction mnemonic from the pick list The bank can define whether a customer depending on the relationship with the account is allowed or not allowed to perform a particular transaction Customer Optional Check Box Relationships Select the appropriate check box corresponding to the customer relationship if you want to allow the access of the selected transaction mnemonic for the specified relationship The options are e Sole Owner e Joint or First e Guarantor e Joint and Other e Joint or Other e Minor e Joint and First e Trustee e Authorised Signatory 3 Click the Add button 4 Select the transaction mnemonic from the pick list 5 Select the appropriate customer relationships check box IB Transaction Customer Relationship Cross Reference ORACLE IB Transaction Customer Relationship Cross Reference Transaction Mnemonic 508 Customer Relationships V Sole Owner Joint Or First Guarantor Joint and Other Joint or Other Minor Joint and First Trustee Authorised Signatoy r Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized O Delte Gencel Amend Authorize O Inquiry 6 Click the Ok button 7 The system displays the message Record Authorized Click t
186. st It is the time interval at which the bank will levy the service charges The options are e Daily e Monthly e Bi Monthly e Quarterly e Half Yearly e Yearly Conditional Numeric Two Type the anniversary day of SC The number of days will be zero if the Calendar option is selected in the Cap Type field Conditional Numeric Two Type the anniversary month of SC The number of months will be zero if the Calendar option is selected in the Cap Type field ORACLE Column Name Description Waiver Flag Toggle If the SC is waived for the account then this field displays the value Y By default displays the value N To waive a single service charge from the package click the toggle status to change the value to Y Waive Uncharged Toggle By default the value is N If Waiver Flag has been changed to Y then e N Denotes that uncollected SC should be charged on the account e Y Denotes that uncollected SC should be waived on the account As package change activity if a service charge is waived in the middle of the capitalisation period Waiver Uncharged flag determines the treatment of uncollected service charge 3 Click the Modify button 4 Enter the account number and press the lt Tab gt or lt Enter gt key SC Package Changes at Account Account Details a Account No Doo000010 Name MBABUMHAR Customer ID 00755 status 7 Currency 1 Product Branch
187. system displays the ATM Acquirer POS Id Maintenance screen ATM Acquirer POS Id Maintenance ATM Acquirer POS Id Maintenance amp E Acquirer Institution Id C Card Acceptor Identification Code Forv rder Institution Id Card Acceptor Terminal Name Card Acceptor Terminal Id Originating Branch Code ATM Cash GL Deposit Cash GL Acquirer Fee GL Forv rder Fee GL Incoming Remit GL Outgoing RemitGL Settlement GL Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description Acquirer Institution Mandatory Numeric 11 Id Enter the acquirer institution ID The institution ID is allotted to the bank by the central bank or the governing body for non branch channels like TBS ATM and POS Card Acceptor Mandatory Alphanumeric 15 Identification Code Enter the card acceptor identification code This code identifies the ATM which defines the point of the transaction in both local and interchange environment ORACLE Field Name Forwarder Institution Id Card Acceptor Terminal Name Card Acceptor Terminal Id Originating Branch Code ATM Cash GL Deposit Cash GL Acquirer Fee GL Forwarder Fee GL Incoming Remit GL Outgoing Remit GL Settlement GL Description Mandatory Alphanumeric 11 Enter the forwarder institution ID The institution ID allotted to the bank by the central bank or the governing body for no
188. t Against Cash ccccccceeesceceeeeeeeeeeeeeeseeeeeseaeeeeaaeeneneeenaees 106 1005 Miscellaneous GL Transtar DCN aseiniad iah 110 1905 Cross Cost Center Miscellaneous GL Transfer Dr Cr cccceceeeeeeeeeteeeseeeeeeeeeaees 113 MODON eee emir er OR POA Or Pee PO POR SO Pe eS Eee ee 118 WODI se oy eee Macio ena a Gute taudegepacureteuntusede peas 118 POE Glok PUG E kossinn a aaa a A a A 130 SOT Teame r o OCKE orere a a E aa Ea A E EAS 134 MOTI Stock MOUNES srie aae cakveasnaneestiadiuesaincneentaraueratamerntcens 137 Seice CAE E S cca an om mre scm pena mm oo ec Rnd aa deed poe 148 Service Charge Details Serec i ees cieests anisini andai aada Na aaa E aaa 148 S0M0Z2 SC Package for Customer nonsastra aaia aiaa aN 148 SCMO3 SC Package Changes at Account cccccceesseeeeeeeceeeeeeaeeeeaaeeeeeeeseaeeesaaeseeaeeeeneeess 155 SCM05 SC History for Account INQOUY asaini naanin anana aaa aa aaa adaini 160 SCMO6 SC Package Linkage to Code Task ccccssecsesceceeeeeseaeeeeeaeeeeeeeseaeeeeaaesneaeeeeeeeees 173 Download Related TranSactioiis isscccccccccoscccccccseceetaecinseccweconctnesapeeuaneconsunnadnesansetenceenssnecuneceone 176 ORACLE 8889 Download Scheduler Maintenance ccccccesseceeceeeeeeeeeaeeeeaaeseeeeeseaeeesaeeeeneeseeeeess 176 8890 Cluster PUTT II asesinan naiai anana i a aeaa aa ka aA Ea 181 8892 Download Service Sacra etedasetn cet uind on ini anana aN awaa aAa aeaa
189. t Generator Modes Available Not Applicable To make an inquiry on file extract 1 Type the fast path BAM94 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Handoff gt File Extract Inquiry 2 The system displays the File Extract Inquiry screen File Extract Inquiry File Extract Inquiry system Code rs File Type J eT User Id C JE Extract Date EH First Previous o fo Field Description Field Name Description ORACLE Field Name System Code File Type User Id Extract Date Description Mandatory Pick List Select the system code against which the file was uploaded from the pick list Optional Pick List Select the file type from the pick list File types are enabled based on the System Code selected Optional Pick List Select the login ID of the person who had generated the file extract from the pick list The User ID is automatically picked up and stored by the system for every transaction Optional Pick List dd mm yyyy Select the extract date from the pick list Column Name Description System Code Display This column displays the system code for the extract File Type Display This column displays the file type for the extract File Id Display This column displays the file ID for the extract Branch Code Display This column displays the branch where the extract was generat
190. t was opened The product code is a unique number across all the modules that can identify an authorised and valid product Account No Branch Display opened Product Display Credit Risk Rating ORACLE Field Name Currency Total Balance Total Arrears Princ Provision Made Security Value UnColl Int Provision Made Full Write Off Partial Write Off Reason For Closure Write Off Details Arrears Normal Outstanding Description Display This field displays the account currency derived from the product under which the account was opened Display This field displays the total balance outstanding in CASA account or loan account Display This field displays the total interest arrears due in CASA account or loan account Display This field displays the principal provision available for the account as maintained by the system or manually maintained for any diminution in the value of the loan overdraft assets Display This field displays the total principal amount that is secured as per the last collateral valuation This will include both the Primary and Secondary Collaterals Display This field displays the current position of any uncollected interest provided for in the term loan account Optional Radio Button Click Full Write Off to write off the entire amount mentioned in the write off details section Optional Radio Button Click Partial Write Off to parti
191. teral and other Collateral including the proceeds thereof which are now or hereafter pledged to the bank Using this option you can view the collaterals that are linked to specific accounts The system provides information on collateral details like the value of the collateral in percentage which has been shared with the account the actual lendable value of the collateral and the type of collateral i e primary or secondary ORACLE Definition Prerequisites e BAM 74 Collateral Header Maintenance e BAM 9 Collateral Codes Maintenance e CASA and Loan accounts to which the collateral is attached Modes Available Not Applicable To inquire on collateral linked to an account 1 Type the fast path BA434 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Collaterals gt Account To Collateral Inquiry 2 The system displays the Account To Collateral Inquiry screen Account To Collateral Inquiry Account To Collateral Inquiry Account No Currency First Previous jo yo Next Last Field Description Field Name Description Account No Mandatory Numeric 14 Type the account number for which you want to perform the inquiry ORACLE Field Name Description Currency Column Name Display This field displays the currency of the account Description Collateral Id Collateral Desc Share Share Value Account Currency Coll
192. terest Outstanding Service Charge Arrear Date Arrear Type Arrear Amount Arrear Pending Last Paid Date Display This field displays date on which the account became NPA Display This field displays the account status as on NPA date Display This field displays the total of all Principal arrears outstanding as on NPA date Display This field displays the total of all Interest arrears outstanding as on NPA date Display This field displays the total of all Service Charge arrears outstanding as on NPA date Display This field displays the date on which the outstanding arrear was raised as on NPA date Display This field displays the type of the outstanding Arrear as on NPA date Display This field displays the amount of the arrear raised for the arrear type on a respective date as on NPA date Display This field displays the amount of arrears pending for appropriation for the arrear type on a respective date as on NPA date Display This field displays the date on which the last payment was made for the arrear as on NPA date CRR Evaluation Details ORACLE CRR Enquiry f PR r Search Criteria Customer ma Search String Account Number 50000000309611 r Customer Information Customer ID 603898 Customer IC ASHISHO9111977 Customer Name ASHISH S GOKHALE Customer CRR 10 Standard Home Branch MAIN BRANCH Account CRR Account Details CRR History Custome
193. the adjacent field Lookup Value Mandatory Alphanumeric 60 Enter the lookup value ORACLE Field Name Description File Type Mandatory Pick List Select the file type from the pick list The corresponding file type name is displayed in the adjacent field 3 Select the external system code and the file type from the pick list File Upload GEFU External System Code ADDF CHANGE frares Seys File Type Upload File Handoff File Details Input File Name El Narration Process Date 15 02 2008 RE ok _ close __clear_ 4 Enter the required information in the Upload File tab Upload File ORACLE External System Code ADDRCHANG Aa File Type _ _ Upload File Handoff File Details Input File Name rtgs03051 1007incorrec taccoun ttHt Process Date ie cise Slear_ Field Description Field Name Description Handoff File Details Input File Name Mandatory Alphanumeric 40 Type the name of the file that is to be uploaded Narration Mandatory Alphanumeric 40 Type comments for the file Process Date Conditional Pick List dd mm yyyy Select the date on which the file is processed from the pick list The process date field should be current posting date or future date The field enabling or disabling will depend on the Input File Name field 5
194. the bank level the teller can modify this rate within certain boundaries If the account currency and the local currency are same the field takes the default value as 1 which cannot be modified ORACLE Field Name Description Txn Ccy Rate From Amount To Amount Reference No User Reference No Narrative Display This field displays the rate at which the transaction currency is converted to the local currency of the bank The teller s right to change the transaction currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Depending on the configurable option at the bank level the teller can modify this rate within certain boundaries The teller s right to change the account currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Mandatory Numeric 13 Two Type the amount which will be debited from the From GL account Display This field displays the amount that will be credited to the To GL account This amount will be in the To Account currency The transaction amount in transaction currency is converted to this amount in GL currency using the exchanges rates displayed earlier and automatically displayed by the system Mandatory Alphanumeric 12 Type the reference number This field is provided to keep a reference number for the transaction for f
195. the configurable option at the bank level the teller can modify this rate within certain boundaries The teller s right to change the account currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Display This field displays the rate at which the transaction currency is converted to the local currency of the bank The teller s right to change the transaction currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Depending on the configurable option at the bank level the teller can modify this rate within certain boundaries The teller s right to change the account currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Mandatory Numeric 22 Type the transaction amount indicating the cash which is being paid out The transaction currency may or may not be different from the GL currency Display This field displays the GL amount that will be credited to the GL This amount will be in the GL currency The transaction amount in transaction currency is converted to this amount in GL currency using the exchanges rates displayed earlier and automatically displayed by the system Mandatory Alphanumeric 12 Type the reference number This field is provided to keep a reference number for the transaction f
196. the principal outstanding Outstanding Optional Check Box Interest Select the Outstanding Interest check box to calculate the provision amount on the outstanding interest Outstanding Optional Check Box Commitment Fee Select the Outstanding Commitment Fee check box to calculate the provision amount on the commitment fee Off Balance Sheet Optional Check Box Amount Select the Off Balance Sheet Amount check box to calculate the provision amount on the off balance sheet amount 3 Click the Add button 4 Select the provisioning group from the drop down list and press the lt Tab gt or lt Enter gt key 5 Select the provisioning sub group from the pick list Provisioning Parameters at Bank level for Loans and Overdrafts Provisioning Parameters at Bank level for Loans and Overdrafts Provisioning Groups and Parameters Provisioning Group Individually As Provisioning Sub Group Debit Cards Components of Provisioning Base On Balnce Sheet Amount ital Outstanding Interest Outstanding Commitment Fee Off Balance Sheet Amount F Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized fy Det O Cancel O Amend O Authorize O Inquiry 6 Click the Ok button ORACLE The system displays the message Record Added Authorisation Pending Click the OK button The provisioning parameters at bank level for loans and overdrafts are added
197. the start number from which a stock item is ordered If the Auto Serial No flag is on then system automatically generates the Start No by incrementing the highest number of the current stock The user can modify the Start No or provide it when it is not already available Display This column displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 ORACLE Column Name Description Total Display This column displays the total value Total Value Denomination Quantity For example If Denomination 100 and Quantity 20 Then Adjustment Total value 2000 Only stock or inventory items which are tracked denomination wise will have an Adjustment Total value Delete y n Toggle Click the toggle status to change the value to Y if you want to delete the particular stock item from the list By default the system displays the value as N Receive Stocks Transaction Receive Stock x Purchase Order No TE Received From M S HDFC Pi Inventory Branch SANDOZ MUMBAI _ v Date of Receipt Baf1z 2010 Record Details Last Mnt Action Authorized Input By Authorized By Last Mnt Date Field Description Field Name Description ORACLE Field Name Purchase Order No Received
198. through the menus to Transaction Processing gt Internal Transactions gt Classification gt Account Classification Preferences 2 The system displays the Account Classification Preferences screen ORACLE Account Classification Preferences Account Classification Preferences Account No LCG Customer Name Currency Product Name Branch CL Include in Equalization Classification Pref Plan Code Classification Criteria Plan Code Provision Plan Code Classification Required Record Details Field Description Field Name Input By Authorized By Last Mnt Action Authorized m Last Mnt Date Add Modify Delete Cancel Amend Authorize Inquiry Description Account Number Customer Name Branch Product Currency Mandatory Numeric 14 Type the account number of the customer for which the CRR is to be inquired modified It could be a CASA account or a loan account Display This field displays the short name of the primary customer as entered in the Customer Addition Fast Path 8053 option Display This field displays the name of the home branch where the account was opened Display This field displays the product code and name under which the account was opened The product code is a unique number across all the modules that can identify an authorised and valid product Display This field displays the account curren
199. to TIN can be specified Definition Prerequisites e 8053 Customer Addition Modes Available Add Modify Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add IVR TIN request 1 Type the fast path TBSO3 and click Go or navigate through the menus to Global Definitions gt Channels gt IVR TIN Request 2 The system displays the IVR TIN Request screen ORACLE IVR TIN Request IVR TIN Request Customer Information Search Criteria Customer Short Name Ic Full Name Search String ID Short Name Account Linkage Issue Reissue TIN Accounts Linked Record Details Authorized By Last Mnt Date Last Mnt Action Authorized p By D Field Description Field Name Description Search Criteria Mandatory Drop Down Select the criteria to search for the customer from the drop down list The options are e Customer short name e Customer IC Identification criteria IC arrived at by the bank during customer addition Customer ID Unique identification given by the bank ORACLE Field Name Search String Full Name Short Name Description Mandatory Alphanumeric 20 Type the search string to search for a customer based on the criteria selected in the Search Criteria field If the search criterion is specified as customer s
200. tramind Park Avenue Contact Person Tom Smith Phone Number 9076479786 Collection Center Code 5 Bill Details File Name Test log Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized 3 L r L j Cancel L Amend Authore O1 C o JC cee C cer 6 Click the Ok button 7 The system displays the message Record Authorized Click the OK button 8 The bill company details are added ORACLE BAIB3 IB Customer Application Billing Information Maintenance The bank can register the customers of the billing companies in this maintenance The customer of the billing company provides the billing details which is registered in the system This option is used for paying bills through Internet Using this option you can maintain yhe billing company details Definition Prerequisites e BAIB2 IB Bill Company Details Maintenance e 8053 Customer Addition Modes Available Add Delete Cancel Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add a customer who is registered with a billing company 1 Type the fast path BAIB3 and click Go or navigate through the menus to Transaction Processing gt Customer Transactions gt IB Customer Application Billing Information Maintenance 2 The system displays the IB Customer Application Billing Information Maintenance screen IB Customer Application
201. ts 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 ORACLE Table of Contents BACK OGO ccnn scenes esoeadcinmsed 5 Me Saar setae sa cnc rsh eee se An each macs een nn noth states a wt daca aa Daan oct sak oan 6 Delivery Channel Related Transactions cccsssececesssceenseeeeeenseeeeeenseseeeenseenensnseseeeenseeneees 7 ATMO1 ATM Bank Params WeINeCMBNCGs aiscesciieccschenscesdadeveeecnntssderabeeceisdeeveeedadvecctedataneeeedivealas 7 ATMO2 ATM Acquirer POS Id Maintenance sessirnir isinen iaiia 11 POS01 POS Acquirer POS ld MaintenanGE saririsa aa 14 POS02 POS Bank Params Maite Nee Gsis E EN NE aN a 18 POS04 POS BIN Xref MaintenanCO reciia ETE NE a 22 TBS01 TBS Bank Params Mal Mt nance iscissi T aE a 23 TBS02 TBS Acquirer Pos ID Maintenance iin cavviniaccssensd oavvenisass vinci abvvniaservendosiveniiosnvinnisntune 27 TESO YR TIN Rogu bec REN paventiaanteeieniun 29 BAIB4 IB Bank Params Maintenance sersoiisisriiassisria rinis rinnassa ESANA oa BAIB2 IB Bill Company Details Maintenance ccccccccessseceeessneeeeesseeeeesseeeessnaeeeensseeeeess 36 BAIB3 IB Customer Application Billing Information Maintenance cccccsccessseeeeeesteeeeees 40 BAIB6 IB Transaction Customer Relationship Cross Reference cc cccccsssceceesseeeeesteeeees 43 BAIB5 IB Block Transfer Across Products 0 ccccc
202. ue Click the Ok button ORACLE 7 The system displays the Authorization Reason screen 8 Enter the required information and click the Ok button 8893 Upload Account Balance File After the file is received from the data center at a branch the system administrator should copy the file in RJSOUT folder of D Flexcube Host Runarea After copying the account balance file System Administrator in the Branch has to upload the file in the Branch database using the Upload Account Balance File option after logging into FLEXCUBE using System Administrator ID on the Branch Server After upload CASA balances will be updated in the branch with the balances maintained at the host at the time of generation of the account balance file Definition Prerequisites Not Applicable Modes Available Not Applicable To upload an account balance file 1 Type the fast path 8893 and click Go or navigate through the menus to Operator Processes gt Data Download Options gt Upload Account Balance File 2 The system displays the Upload Account Balance File screen Upload Account Balance File File Path if ORACLE Field Description Field Name Description File Path Mandatory Pick List Select the path where the file is stored from the pick list Or use the Browse option to load the file Total Records in Display File This field displays the total records to be loaded from the file Uploaded Records Display T
203. unt 1 Type the fast path AC004 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Classification gt Account WriteOff 2 The system displays the Account WriteOff screen Account WriteOff ORACLE Account Writeoff wr r Account Details Account No Branch Product Currency Total Balance Total Arrears Princ Provision Made Security Value 0 UnColl Int Provision Made Full Write Off Partial Write Off Reason For Closure X r Write Off Details Normal Suspended Arrears OutStanding Writeoff OutStanding Writeoff Interest D o 0 Penalty Interest 0 o o Compounding Interest Arrears fj o o Diverting Interest Arrears 0 o o Post Maturity Interest 0 o o Fees SC 0 o 0 Premium 0 o 0 o Legal Fee 0 o 7 o OutGoings 0 o 0 o Principal Interest Accrued oO Penalty Accrued o Total WriteOff Suspended Reversals 0 00 Net Writeoff iD Princ Provision Drawdown 0 00 UnColl Int Prov Drawdown 3 4 gt OK Close ff clear Field Description Field Name Description Account Details Mandatory Numeric 14 Type the account number of the customer for which the CRR is to be inquired modified It could be a CASA account or loan account This field displays the home branch where the account was This field displays the product code and name under which the accoun
204. unts to have maintained Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To maintain POS Bin Xref parameters 1 Type the fast path POS04 and click Go or navigate through the menus to Global Definitions gt Channels gt POS Bin Xref Maintenance 2 The system displays the POS BIN Xref Maintenance screen POS BIN Xref Maintenance Bin Number C71 FWD ID r Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized aa Field Description Field Name Description ORACLE Field Name Description Bin Number Mandatory Numeric 10 Type the ten digit bin number FWD ID Mandatory Alpha numeric 10 Type the FWD ID 3 Click the Add button 4 Enter the required information in the various fields POS BIN Xref Maintenance Bin Number 1234567891 FWD ID 1234567830 Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized 5 Click the Ok button 6 The system displays the message Record Added Authorization Pending Click Ok to Continue Click the OK button 7 The POS BIN parameters are added once the record is authorised TBSO1 TBS Bank Params Maintenance Using this option you can define the bank level global definitions related to TBS Telephone Banking Service transactions and decides whether funds tra
205. urrency Display This field displays the currency of the collateral Total Collateral Display Value This field displays the total value of the collateral Unused Collateral Display Value This field displays the total collateral value that has not been utilized ORACLE Column Name Description No Display This column displays the system generated serial number that indicates the row item number Account No Display This column displays the account number to which the collateral ID is linked Share Display This column displays the ratio of the secured collateral linked to the limit and the gross collateral value as present in collateral header secured collateral collateral value product level lendable margin gross collateral used by the limit Share Display Value Collateral This column displays the share value amount of the gross Currency collateral linked to the limit on the account Sum of share value should be less than or equal to total collateral value as defined in Collateral Header Collateral Display Value Collateral This column displays the actual lendable value Currency Collateral Security Display This column displays the collateral type Propagate Toggle Collateral Value Click the toggle status to change the value to Yes to propagate the collateral value By default the system displays the value as No 3 Type the collateral ID and press the lt Tab gt or lt Ent
206. us e Authorized e Failed e Canceled e In Progress e Upload In Progress e Processed Displays only processed and authorized file e Unauthorized e In Process Mandatory Pick List dd mm yyyy Select the date on which the files were uploaded from the pick list Mandatory Pick List dd mm yyyy Select the date on which the files were processed or are going to be processed from the pick list Mandatory Pick List Select the name of the branch from which the upload was initiated from the pick list 3 Based on the criteria selected the inquiry is performed For example Type the upload date or select it from the calendar The system displays the list of all files that are uploaded on the selected date ORACLE File Upload Inquiry GEFU External System Code SCOUN al ACCOUNT File Type ECS amp ECS File Name E User td Faea a Status Upload Date prorso00 PE Process Date Branch Code 240_ SaNDoz mumear File List File Details Fue Record Detail All v 01 01 1800 Ea 4 Click the Ok button 5 The system displays the upload file status details File List ok close _ _ctear_ ORACLE External System Code ac Account File Type Ecs File Name User Id TSAMEER Status Processed x Upload Date 06 09 2010 Process Date 01 01 1800 EE Branch Code 240 _ J Sanooz mumear File List
207. ustomer s short name is George Abraham One can search the above customer by entering Geo in the Search String field Display This field displays the ID of the customer A customer ID is an unique identification number generated by the system after customer addition is completed successfully This running number unique to a customer across the system is generated after the system has identified the Customer IC and Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system Display This field displays the identification code of the customer A customer IC along with customer type is a unique method of customer identification across the bank covering all branches Based on the combination the system can identify the customer as an existing customer even when the customer opens a new account in another branch The contents of Customer IC depends on the customer type and business rules of the bank For e g a bank may have social security number passport number etc as the Customer IC for all Individual customers may be used Display This field displays the full name of the customer The full name of the customer is defaulted from the Customer Addition Fast Path 8053 option Optional Pick List Select the customer who is registered with the billing company from the pick list Mandatory Pick List Select the identification number of the billing company
208. uthorized e E as T Add Modify C Delete C Cancel C Amend C Authorize Inquiry Ok C ciose Clear Field Description Field Name Description Task Code Mandatory Pick List Select the task code from the pick list Package Code Mandatory Pick List Select the SC package code that will be attached to the task code from the pick list 3 Click the Add button 4 Type the task code and press the lt Tab gt or lt Enter gt key 5 Enter the relevant information ORACLE SC Package Linkage to Code Task SC Package Linkage to Code Task Task Code cnoo E Package Code c18 CLOSE_OUT WITHDRAWAL x gl Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized ____ L LD m Add Modify C Delete C Cancel C Amend Authorize Inquiry Tok Close Clear 6 Click the Ok button 7 The system displays the message Record Added Authorization Pending Click Ok to Continue Click the Ok button ORACLE Download Related Transactions 8889 Download Scheduler Maintenance Using this option a specific frequency can be set up to download a specific table s to a its own branch database from the Host database This is a mandatory setup for some tables that are required in the branch The scheduler can be configured on the host application server or branch server If the scheduler is configured on the host application server the scheduler will push t
209. uture use Optional Alphanumeric 40 Type the user reference number assigned to identify the transaction This field is enabled or disabled depending on the profit booking being enabled or disabled for the particular transaction Mandatory Alphanumeric 40 Type the narration based on the transaction By default the system displays narration depending on the transaction 3 Select the from account currency from the drop down list 4 Enter the other relevant details Cross Cost Center Miscellaneous GL Transfer Dr Cr ORACLE From Acct Cey From LOB To GL Branch To Acct Cey To LOB To GL Acct No Acct Cey Rate Txn Cey Rate From Amount To Amount From GL Branch From GL Acct No 240 G INR v From Product Code 130100055 THAN 560 BW INR w To Product Code so1000s6 EJ 5 Click the OK button 6 The system displays the message Authorization required Do you want to continue Click the OK button 7 The system displays the Authorization Reason screen Enter the relevant information and click the Grant button OUE ok Cancel The system displays the transaction sequence number message box The transaction number is system generated and ituniquely identifies each transaction performed by a teller and can be used for tracking the transaction Note For more information on Authorization transactions refer to the FLEXCUBE Introducti
210. wer Collateral Available Book Balance Current Balance Description Display This field displays the current CRR of the account Display This field displays the current accrual status of the account Display This field displays the sanctioned amount corresponding to the loan account Display This field displays the total disbursed amount corresponding to the loan account Display This field displays the current outstanding balance corresponding to the loan account Display This field displays the principal arrears on the loan account Display This field displays the interest arrears on the loan account Display This field displays the sum of all the other arrears on the account Other Arrears include Premium Legal Fees and Outgoing Arrears Display This field displays the total MAD for the revolving loan accounts Display This field displays the sanctioned limit or the drawing power amount whichever is lower Display This field displays the collateral security amount corresponding to the account Display This field displays the book balance of the CASA account Display This field displays the current balance of the account ORACLE Field Name Description Interest Arrears Display This field displays the interest arrears Principal Arrears Display This field displays the principal arrears SC Arrears Display This field displays the total outstanding am
211. y this rate within certain boundaries The teller s right to change the account currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable Mandatory Numeric 13 Two Type the transaction currency indicating the cash which is being paid out The transaction currency may or may not be different from the GL currency Display This field displays the GL amount that will be debited to the GL This amount will be in the GL currency The transaction amount in transaction currency is converted to this amount in GL currency using the exchanges rates displayed earlier and automatically displayed by the system Mandatory Alphanumeric 12 Type the reference number This field is provided to keep a reference number for the transaction for future use Optional Alphanumeric 30 Type the user reference number assigned to the customer ORACLE Field Name Description Narrative Optional Alphanumeric 40 Type the narration The system displays the default narration based on the transaction The user can change the narration if required Select the GL currency and transaction currency from the drop down list Select the GL account number from the pick list Enter the transaction amount and reference number Click the Ok button The system displays the message Authorization Required Do You Want to continue Click the OK button The system
212. ys the service charge code Ccy Display This column displays the currency code in which the service charge is levied Description Display Linkage Type This column displays the service charge name as the description for the service charge code Display This column displays the type of trigger on which the SC is to be charged e Periodic SC applied in a frequency e Others SC applied adhoc without a frequency ORACLE Column Name Linkage Code Priority Cap Type Cap Freq Anniv Day Anniv Month Description Display This column displays the linkage code Depending on the linkage type this code is an exact trigger for charging SC For e g for linkage type transaction Cash Deposit cash withdrawal type of transactions will be displayed Mandatory Numeric Five Type the priority of the service charge in the package This is the order in which the service charges shall be applied SC will applied in the ascending order of priority at the time of application Mandatory Drop Down Select the SC capitalisation type from the drop down list The options are e Calendar SC application date will be calendar based depending on capitalisation frequency irrespective of anniversary day anniversary month e Anniversary SC application date depends on capitalisation frequency and anniversary day anniversary month Mandatory Drop Down Select the SC capitalisation frequency from the drop down li
213. ys the start time of the download Select the criterion and request for from the respective drop down list The system enables or disables the table name depending on the criterion selected Select the Add Option option from the Maintenance Option drop down list Enter the number of rows to be added Click the Ok button The system displays the data entry section oO NOT P w Enter the relevant information in the data entry section Download Scheduler Maintenance ORACLE Criterion cem Request For Branch Table Name BI Branch Maintenance Option Add Option gt Rows to Add 15 Pees Frequency Qualifier Start Date Z Table Name Name Requester Type Interval Bank Codes ACF1 J On Time 7 Other J 30 07 2005 5 12 30 Ok Cancel 10 Click the Ok button 11 The system displays the message Record Saved Successfully To modify download scheduler Select the criterion and request for from the respective drop down list The system enables or disables the table name depending on the criterion selected Select the Modify Option option from the Maintenance Option drop down list Click the Ok button The system displays the data entry section Modify the relevant information and click the Ok button NO Ot o ONS The system displays the message Record Updated Successfully To delete download scheduler Select the criterion and request for from the respective drop down list The system enabl
214. ystem Cash Credit GL howa JA Internal Transfer Credit GL 190100417 J Record Details Input By Field Description Field Name Authorized By Last Mnt Date Last Mnt Action Authorized Displays Generate Bridge GL Flag Bridge System Cash Debit GL Bridge System Cash Credit GL Internal Transfer Debit GL Optional Check Box Select the Generate Bridge GL Flag check box if bridge GL is to be used Conditional Pick List Select the bridge system cash debit GL for cash from the pick list This field is enabled only if the Generate Bridge GL Flag check box is selected Conditional Pick List Select the bridge system cash credit GL for cash from the pick list This field is enabled only if the Generate Bridge GL Flag check box is selected Conditional Pick List Select the bridge debit GL for inter branch from the pick list This field is enabled only if the Generate Bridge GL Flag check box is selected ORACLE Field Name Displays Internal Transfer Credit GL Balance Bridge Flag Generate InterBranch GL Flag Designated Branch Suspense Debit GL Suspense Credit GL Gefx Setup Conditional Pick List Select the bridge credit GL for inter branch from the pick list This field is enabled only if the Generate Bridge GL Flag check box is selected Optional Check Box Select the Balance Bridge Flag check box to include bridge GLs un balanced

Back Office User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents