During the day, or at the end of the day, you may want to retrieve information on any of the several operations that were performed during the day in your bank. You can generate this information in the form of reports in Oracle FLEXCUBE.
For every module you can generate reports, which give you data about the various events in the life of a specific contract, or across contracts, at a specific point in time. You can have analysis reports, daily reports, exception reports (reports on events that ought to have taken place on the contract but have not, due to various reasons), and history reports and so on.
From the Application Browser, select the Reports option. A list of all the modules to which you have access rights are displayed in the screen. When you click on a module, all the reports for which you have access rights under the selected module are displayed. Click on the report you want to generate. You will be given a selection Criteria based on which the report would be generated.
This chapter contains the following sections:
You can indicate preferences to print a report, while generating a report; however, the preferences are general.
The following are the common preferences you can maintain to print a report:
Format
Select the format in which you want the report to be generated from the options provided in the drop-down list. The following options are available:
Output
Select the output for the report from the options provided. The following options are available:
Printer At
Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:
Printer
Specify the name of the printer or select it from the option list provided. All the configured printers are displayed in the list.
This is applicable only if you have specified the output as ‘Print’.
Note
You can query or modify the account details of the customers whose accounts are permitted to you for the query/modification in the ‘Group Code Restriction’ screen.
This section contains the following topics:
This report gives details of the Cheques used, cancelled and rejected for an account. You can invoke this screen by typing ‘CARPCKDT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can indicate the following preferences for generating the report:
Report For
Select the option ‘Selected Account’ if you want to generate the cheque book details report for a selected account. Select the option ‘All Accounts’ if you want to generate reports for all accounts.
Account
If you have selected the option ‘Selected Account’ select the account for which the cheque detail report has to be generated from the adjoining option list.
The options that you specified while generating the report are printed at the beginning of the report. The contents of the Cheque Book Details Report are discussed under the following heads:
Header
The Header carries the title of the Report, information on the branch code, branch date, the date and time of report generation, the user-ID of the user generating the report, module, page and the event date.
Field |
Description |
Account |
The account number of the customer |
Description |
The description of the account |
Check Number |
The Cheque leaf number |
Status |
The status of the cheque |
Amount |
The amount for which the cheque is issued |
Presented On |
The date on which the cheque is presented in the bank |
Date on Cheque |
The date as given on the cheque |
Beneficiary |
The name of the person in whose name the cheque is issued |
This section contains the following topics:
This report gives details of the stop payment details issued on a cheque. You can invoke this screen by typing ‘CARPSPMT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can indicate the following preferences for generating the report:
Report For
Select the option ‘Selected Account’ if you want to generate the cheque book details report for a selected account. Select the option ‘All Accounts’ if you want to generate reports for all accounts.
Account
If you have selected the option ‘Selected Account’ select the account for which the cheque detail report has to be generated from the adjoining option list.
The options that you specified while generating the report are printed at the beginning of the report.
The contents of the Stop Payment Report are discussed under the following heads:
Header
The Header carries the title of the Report, information on the branch code, branch date, the date and time of report generation, the user-ID of the user generating the report, module, page and the event date.
Body of the report
Field |
Description |
Account |
The account number of the customer |
Description |
The description of the account |
Stop Payment No |
The stop payment instruction number |
Type |
The stop payment can be issued either on an amount or on cheque(s) |
Start Check No |
The starting cheque leaf number |
End Cheque No |
The ending cheque leaf number |
Amount |
The amount for which stop payment is done |
Effective Date |
The date from which the stop payment is effective |
Expiry Date |
The date on which the stop payment validity will expire |
The table below displays customer statistics for the last six months.
Field |
Description |
Customer Number |
FLEXCUBE Customer Number |
Account No |
FLEXCUBE Account Number |
Acc Currency |
Account Currency |
Cust. Name |
Customer name |
Acc Branch |
The branch in which the account was created |
Last Debit |
Last debit amount on the account for the month |
Last Credit |
Last credit amount on the account for the month |
Last Over Draft |
Last overdraft amount on the account for the month |
Simple Average Balance |
Simple Average balance of the account for the month |
Minimum Balance |
Minimum balance of the account for the month |
Maximum balance |
Maximum balance of the account for the month |
No of Dr transactions |
Number of debit transactions for that month |
No of Cr Transactions |
Number of credit transactions for that month |
Closing Balance |
Month end closing balance of that account |
Total Balance |
The balance of account (including the limit + uncleared / uncollected funds) |
No of Returned Cheques |
Total number of cheques returned on the account for that month |
Debit Interest |
Month END IC (Debit interest liquidated for that account only will be considered) |
N.S.F |
Number of transactions which could not be completed owing to Insufficient Balance in the account for the month |
CHG'BLE TR |
Number of chargeable transactions for the month |
DB.CHK.RTD |
Number of cheques returned for the month |
Debit AVG |
Debit average for the month |
Days in Debit |
Number of days in debit for the month |
Monthly Debit AVG |
Debit average for the month |
Credit AVG |
Credit average |
Days in Credit |
Number of days in Credit for the month |
Monthly Credit AVG |
Monthly credit average |
XOD AVG |
Excess overdraft average for the month |
DAYS XOD |
Number of days in excess overdraft for the month |
MNTH AV |
Excess overdraft average |
Number of times gone into Overdraft |
Number of times the account went into overdraft for the month |
Note
The balance is shown in terms of the account currency.
This section contains the following topics:
You can get the details of the account statement reports using ‘Account Statement Reports’ screen. You can invoke this screen by typing ‘ACDOPTN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can indicate the following preferences for generating the report:
Account Type
Select the type of account you want to view. The types of accounts that can be selected are as follows:
If physical account is chosen, then virtual account numbers will not be displayed in the ‘Account Number’ field. If Virtual Account is chosen, then the physical account numbers will not be displayed in the ‘Account Number’ field.
Account Selection Type
You have to indicate the account selection type of the customer. The options available are:
Statement Type
You have to indicate the statement type of the customer. The options available are:
You can indicate the following:
From Date
Specify the date from when you are generating this report.
To Date
Specify the date till when you are generating this report.
Account Number
Specify the account number. The option list displays all valid account numbers. Choose the appropriate one.
To view the joint holder’s details of an account and the mode of operation maintained at the account level, place the cursor on the Account Number field and press Ctrl+J. The system displays the ‘Joint Holder’ screen.
For more information on the ‘Joint Holder’ screen refer to the section ‘Joint Holder Maintenance’ in this User Manual.
Branch
The system displays the branch code of the selected account number.
Account Currency
Specify the account currency. The option list displays all valid account currencies. Choose the appropriate one.
For virtual accounts based on the Virtual Account Number and Account Currency combination the physical account is identified.
Charge
You have to indicate the type of charges. The options available are:
Virtual Account Transactions Only
The field is enabled if Normal Account is selected in the ‘Account Type’ field. Check this field if you want to view only those transactions that are performed using virtual accounts. While generating the statement for a physical account only the transactions that are done using the virtual account are displayed.
Show Linked A/C Details
Check this box if you wish to show linked account details. If virtual account is selected in the ‘Account Type’ field, then this field is disabled.
Dates
You have to indicate the type of dates. The options available are:
Note
Value Date option is disabled for Virtual Accounts.
Account Number
Specify the account number. The option list displays all valid account numbers. Choose the appropriate one.
Branch Code
The system displays the branch code of the selected account number.
Currency
Specify the currency of the account.
Range Account
From Account Number
Specify the account number from which the report needs to be generated. You can select the appropriate number from the adjoining option list that displays all the accounts maintained in the system.
To Account Number
Specify the account number to which the report needs to be generated. You can select the appropriate number from the adjoining option list that displays all the accounts maintained in the system.
From Account Branch
The system displays the branch code of the selected account number.
To Account Branch
The system displays the branch code of the selected account number.
From Account Currency
Specify the account currency from which the report needs to be generated. You can select the appropriate currency from the adjoining option list that displays all the currencies maintained in the system.
To Account Currency
Specify the account currency to which the report needs to be generated. You can select the appropriate currency from the adjoining option list that displays all the currencies maintained in the system.
Print Options
You have to indicate the type of print options. The options available are:
The options that you specified while generating the report are printed at the beginning of the report.
The contents of the Account Statement Report are discussed under the following heads:
Header
An Account Statement is the record of transactions and their effect on account balances over a specified period of time for a given account. An Account Statement lists the debits and credits that took place over a time period.
The Header carries the title of the Report, information on the Account Number of the user generating the report.
Field |
Description |
Branch Name |
This is the branch where the account resides. |
Branch Address 1 |
This is the address of the branch. |
Branch Address 2 |
This is the address of the branch. |
Branch Address 3 |
This is the address of the branch. |
Account Number |
Details about customer account Number. |
From date |
This is from date. |
To date |
This is to date. |
Page Number |
This is the page number. |
As of Date |
As of date. |
Customer Number |
This is the customer number. |
Customer Name |
This is the customer name. |
Customer Address 1 |
This is the address of the customer. |
Customer Address 2 |
This is the address of the customer. |
Customer Address 3 |
This is the address of the customer. |
Customer Address 4 |
This is the address of the customer. |
Opening Balance |
This is the opening balance of the customer. |
Transaction code Description |
This is the description of the transaction code. |
Transaction reference Number |
This is the reference number of the account for which transaction details is being reported |
Opening Date |
The opening date of the account. |
Previous Date |
Gives the date of the previous statement. |
Transaction Booking Date |
This is the transaction booking date. |
Transaction Amount |
This is the transaction amount. |
Additional Information |
Gives some additional information. |
Debit-Credit Indicator |
This indicates the nature of the transaction – debit or credit. |
Closing Balance |
This indicates the closing balance. |
Available Balance |
This indicates the available balance. |
Blocked Balance |
This indicates the blocked balance. |
Uncollected Balance |
This indicates the uncollected balance. |
Number of Debits |
Indicates the number of debit transactions. |
Number of Credits |
Indicates the number of credit transactions. |
Total Debit Value |
Indicates the total debit value. |
Total Credit Value |
Indicates the total credit value. |
Current Average Monthly Balance |
Indicates the current average monthly balance. |
Previous Average Monthly Balance |
Indicates the previous average monthly balance. |
Current Average Quarterly Balance |
Indicates the average quarterly balance. |
Previous Average Quarterly Balance |
Indicates the previous average quarterly balance. |
Note
The month end job ACBCSTAT batch runs in EOFI to compute account statistics and ACSTHAND batch runs at EOTI with daily frequency.
Note
For book dated statement, tags CURAVGMTHLYBAL and PREVAVGMTHLYBAL will compute the book dated current and previous average monthly balance.
For value dated statement, tags CURAVGMTHLYBAL and PREVAVGMTHLYBAL will compute the value dated current and previous average monthly balance.
Click ’OK’ button when you have specified your preferences in the ‘Account Statement Reports’ screen. The ‘Print Options’ screen gets displayed, where you can specify the preferences for printing the report.
You can view the charges for online statement generation in the ‘Charge Details’ screen. Click on ‘Charges’ button to invoke ‘Charge Details’ screen.
Contract Reference
System displays the contract reference number here.
System displays the following details under this section:
Waiver
Check this box to waive the charge.
Charge Amount
System displays the calculated charge amount here. You can amend this, if required.
Click on ‘Events’ button to invoke ‘Events’ screen.’
Reference Number
System displays the reference number here.
System displays the following details under this section:
This section contains the following topics:
PDC Summary report displays the details of all the cheques discounted for an account.You can generate report for post dated cheque details using ‘Customer Cheque Discounting Report’ screen by typing ‘PDRCHDRF’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Specify the following details here:
Beneficiary Account
Specify the beneficiary account. The adjoining option list displays the list of all the valid beneficiary accounts maintained in the system. You can choose the appropriate one.
From Date
Enter the date from when you are generating this report.
To Date
Enter the date till when you are generating this report.
Click ‘OK’ button to generate the report. Click ‘Exit’ to return to the Reports Browser.
The generated report will have the following information:
Field Name |
Field Description |
Account No./Deposit No. |
This indicates the TD account Number |
Product code |
This indicates the product code |
Product description |
This indicates the product description |
Customer ID |
This indicates the customer Id |
Customer Name |
This indicates the customer name |
Cheque number |
This indicates the cheque number |
Discounted date |
This indicates the discounted date |
Cheque date |
This indicates the cheque date |
Cheque CCY |
This indicates the cheque currency |
Cheque amount |
This indicates the cheque amount |
Cheque Status |
This indicates the cheque status |
Drawer identification |
This indicates the drawer identification |
Drawer Name |
This indicates the drawer name |
Drawer bank code (for the cheque) |
This indicates the drawer bank code for the cheque |
Aggregation Fields
Field Name |
Field Description |
Total cheque amount |
This indicates the total cheque amount |
Total Number of cheque |
This indicates the total number of cheque |
This section contains the following topics:
Oracle FLEXCUBE generates a report that contains the details of cheques that are cancelled and revised on a daily basis. This report is generated everyday during end of day operations.
The report contains the following details:
Header
Field Name |
Field Description |
Report Name |
Report name |
Bank Code / Bank Name |
Bank code and bank name |
Branch Code / Branch Name |
Current branch code and branch name |
Op ID |
Current user |
Report Run Date |
Current system date |
Report Run Time |
Current system time |
Body
Field Name |
Field Description |
Product Code |
PDC Product |
Account Number |
Beneficiary account number |
Account Name |
Beneficiary account description |
Cheque Purchase Number |
Transaction reference number |
Cheque Number |
Instrument Number |
Purchase Amount |
Cheque amount; Purchase/discount will be done for the entire amount |
Currency |
Currency of the instrument |
Interest Amount |
Interest Amount (Interest will be applicable for cheques discounted only. Interest will be computed from the purchase date till the liquidation date) |
SC Amount |
Service charge amount |
Clearing Transaction Reference Number |
Outward clearing transaction reference number for pdc purchased |
Teller ID |
Maker ID of the transaction |
Authorizer ID |
Checker ID of the transaction |
Status |
Cheque status |
Reject Code |
Reject code for cancellation |
Reject Reason |
Reject reason for cancellation |
This section contains the following topics:
Oracle FLEXCUBE facilitates generation of the Interest Statement Report for Customer Accounts without liquidating the Customer Accounts.
You can generate Interest Statement Report for Customer Accounts using ‘Customer Account Interest Statement’ screen. You can invoke this screen by typing ‘CARINSTM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid branch code in which the customer has an account. The adjoining option list displays all valid and authorized Branch codes. You can select the appropriate one.
Customer Number
Specify a valid customer identification number. The adjoining option list displays all valid and authorized customer identification numbers. You can select the appropriate one.
Account Number
Specify a valid customer account number for which you wish to generate the interest statement report. The adjoining option list displays all valid, authorized savings and current account numbers. You can select the appropriate one.
From Date
Specify the date from when you wish to generate the interest statement report for the specified customer account, from the adjoining calendar.
To Date
Enter the date till when you wish to generate the interest statement report for the specified customer account, from the adjoining calendar.
Note
‘To Date’ cannot be a future date
The report contains the following details:
Header
Field Name |
Field Description |
Report Name |
Report name |
Bank Code / Bank Name |
Bank code and bank name |
Branch Code / Branch Name |
Current branch code and branch name |
Op ID |
Current user |
Report Run Date |
Current system date |
Report Run Time |
Current system time |
Body of the Report
The generated report will provide the following information:
Field Name |
Field Description |
Customer Number |
Indicates the customer number |
Account Number |
Indicates the account number |
Currency |
Indicates the currency of the transaction |
Name |
Indicates the name of the customer |
Product |
Indicates the product for which the credit and debit details are displayed |
From Date |
This indicates date from when the interest is computed |
To Date |
This indicates date till when the interest is computed |
Interest Balance |
Indicates the interest balance |
Number of Days |
This indicates number of days for which the interest is computed |
Interest Rate |
This indicates interest rate based on which the interest is computed |
Amount |
This indicates calculated interest amount |
Total Credit Capitalized |
Indicates the total credit capitalized |
Total Debit Capitalized |
Indicates the total debit capitalized |
Total Tax Amount |
This indicates the total tax amount over the interest amount in the specified period |
Note
If the customer account is linked to multiple products or formulae, then the interest statement displays the credit and debit interest details separately for that customer account.
This section contains the following topics:
An account is moved to Dormancy state in the absence of any customer initiated transaction, in that account, for a period maintained at ‘Account Class Maintenance’ level. After a specific period, the status will be changed to unclaimed deposit.
These accounts are activated, once the customer initiates a transaction. At the end of the Dormant Activity, you can generate ‘Dormant Activated Report’ as part of EOD, which summarizes the transaction in the dormant accounts. It is a report of dormant accounts which were activated on that day. The accounts in this report are grouped based on the account class and currency type of the account.
You can invoke ‘Dormant Activated Report’ screen by typing ‘STRDAEOD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code for the Branch in which the customer has an account from the adjoining option list.
Activated Date
Specify a valid date, when the dormant account was activated, from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. The other content displayed in the Dormant Activated Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch |
Indicates Branch Code and Branch Name |
Module |
The module from which the report was generated |
Run Date |
Indicates Date on which report is generated |
Run Time |
The time at which the report was generated |
User ID |
Indicates User ID of the user who generated the report |
Page No |
The page number of the report |
Body of the Report
The following details are displayed as body of the generated report, grouped by the product code and currency:
Field Name |
Field Description |
Product Code |
Indicates Account Class |
Currency |
Indicates Currency of the Account |
The dormant details for each account class and currency are displayed in the report |
|
Account |
Indicates Customer Account |
Account Name |
Indicates Account Description |
Day’s Credit Amount |
Indicates Sum of Transaction Credit Amount for today in Account Currency |
Day’s Debit Amount |
Indicates Sum of Transaction Debit Amount for today in Account Currency |
Book Balance |
Indicates Book Balance |
Dormancy Start Date |
Indicates Dormancy Start Day |
Dormant Days |
Indicates Number of Dormant Days |
Maker ID |
Indicates Maker id of the Transaction |
Checker ID |
Indicates Checked Id of the transaction |
Txn code |
Indicates Transaction code of the Transaction |
Txn Description |
Indicates Transaction Description of the Transaction. |
This section contains the following topics:
When a customer losses cheque leaf issued for a Savings or Current Accounts, the same is informed to the respective branch. The corresponding branch updates these details in the system to avoid paying-out of these cheques.
During EOD, you can generate ‘Stop Cheques Maintained Report’, which lists out all the stop payment instruction carried out on that day. Stop cheques in this report are grouped based on the account type.
You can invoke ‘Stop Cheques Maintained Report’ screen by typing ‘STRSPEOD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code for the Branch in which the customer has an account from the adjoining option list.
From Date
Specify a valid date, from when the report is generated, from the adjoining calendar.
To Date
Specify a valid date, till when the report is generated, from the adjoining calendar.
Stop Payment Type
Select stop payment type for which you wish to generate the report from the adjoining drop-down list. This list displays the following values:
The parameters specified while generating the report are printed at the beginning of the report. The other content displayed in the Stop Cheques Maintained Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch Date |
Indicates the branch date |
Branch |
Indicates Branch Code and Branch Name |
Run Date |
Indicates Date on which report is generated |
User ID |
Indicates User ID |
Module |
Indicates the module code |
Run Time |
Indicates the time on which the report is generated |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account Number |
Indicates Customer Account Number |
Account Desc |
Indicates Account description |
Customer Id |
Indicates Customer Id |
Customer Name |
Indicates Customer Short Name |
Currency |
Indicates Currency of the Account |
Stop Payment Type |
Indicates Stop Payment Type |
Chq St No. |
Indicates Cheque Start Number |
Chq End No. |
Indicates Cheque End Number |
Amount |
Indicates Cheque Amount |
Stop Chq Date |
Indicates Stop Cheque Date |
Reason |
Indicates Reason for Stop Payment |
This section contains the following topics:
Branches collect PDC to ensure recovery and credit the customer accounts on the scheduled date. These cheques are presented in the outward clearing on the agreed due date.
During EOD, you can generate ‘Post Dated Cheques Due Today Report’, which lists details of all the PDC that were due and were cleared on that day. Transactions in this report are grouped based on the Instrument and clearing type of the cheques. Report also provides a Branch-wise presentation of cheques.
You can invoke the ‘Post Dated Cheques Due Today Report’ screen by typing ‘PDRDTTOD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code for the Branch in which the customer has an account from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. The other content displayed in the Post Dated Cheques Due Today Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current Branch Date |
Report Run Time |
Indicates Current Branch Time |
Branch Date |
Indicates the date of Branch in which report is taken. |
Page No |
Displays Page No out of total No of pages in report. |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Instrument Type |
Indicates PDC Type |
Clearing Type |
Indicates Clearing Product description of the PDC |
Account No |
Indicates Account Number (Beneficiary Account Number) |
Acct. Name |
Indicates Description of the Account if it is FCUBS account. If it is not, then it is left blank |
Bank Code |
Indicates Bank Code of the Issuer |
Cheque No |
Indicates Cheque number |
CCY |
Indicates the Currency of the Transaction |
Cheque Amount |
Indicates Cheque Amount |
Transaction Seq No. |
Indicates Transaction Sequence No. |
Deposit Date |
Indicates Cheque Deposit Date |
Instr. Date |
Indicates Activation Date |
Value Date |
Indicates Value Date of the Cheque |
Total Amount (Branch) |
Indicates the total amount |
This section contains the following topics:
Oracle FLEXCUBE provides customers a facility to open an account in the branch of their choice. You can generate ‘Inter Branch Accounts Opened Today Report’ to enable the branch, to have a control over all the accounts opened on other branches. This report lists the accounts created by the Bank Staff, who have Multiple Branch Operational Rights. However, the account branch and the Maker’s home branch should not be the same.
You can invoke the ‘Inter-Branch Accounts Opened Today Report’ screen by typing ‘STRIBRAC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code of the Branch in which report is being generated from the adjoining option list.
Date
Specify the date for which you wish to generate the report, from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Inter Branch Accounts Opened Today Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch |
Indicates Branch Code and Branch Name |
Run Date |
Indicates Date on which report is generated |
Run Time |
Indicates the time on which the report is generated |
Module |
The module from which the report is generated |
User ID |
Indicates User ID |
Page No |
The page number of the report |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch Code |
Indicates Branch code of the Account |
Customer ID |
Indicates Customer ID |
Customer Short Name |
Indicates Customer Short name |
Account Class |
Indicates Account Class of the Account |
Account No |
Indicates Account Number |
Account Desc |
Indicates Account description |
Account Opening Date |
Indicates Account Opening Date |
This section contains the following topics:
You can maintain Account Status Movement conditions at the ‘Account Class’ level, based on the conditions decided by your Bank and the compliance requirements of the Central Bank. During EOD, based on these and the conduct of accounts, system automatically classifies the assets on the daily basis. Based on this classification, system recognizes and provisions the income.
You can generate ‘Account Status Movement Report’ to enable the branches to follow-up the accounts so that the status of the accounts does not change to NPL status. This report lists CASA accounts that have moved to status based on the Account Class type of the account.
You can invoke the ‘Account Status Movement Report’ screen by typing ‘STRCASTM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code of the Branch in which report is being generated from the adjoining option list.
Account Number
Specify the account number for which the report has to be generated, from the adjoining option list.
Account Status
Specify the status of the Account number from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Inter Account Status Movement Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch Date |
Indicates the branch date |
Branch |
Indicates Branch Code and Branch Name |
Run Date |
Indicates Date on which report is generated |
User ID |
Indicates User ID |
Module |
Indicates the module code |
Run Time |
Indicates the time on which the report is generated |
Page No |
The page number of the report |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account Class |
Indicates Account Class of the Account |
Account Number |
Indicates Account Number |
Customer Id |
Indicates Customer Number |
Customer |
Indicates Customer Short Name |
Checker ID |
Indicates Checker ID |
No. of Days |
Indicates Number of Days the account is in the current status |
Account Status |
Indicates Account Status |
From Status |
Indicates the Status from which the account moved to the current status |
This section contains the following topics:
When a customer opens an account, the system updates interest rates based on those maintained at the Product level. However; branches can have an account level variance.
You can generate ‘Variances Maintained Today Report’ to inform branches about the variances maintained for that day. This report lists details of CASA and TD accounts for which the interest variances are maintained for the day. You can invoke the ‘Variances Maintained Today Report’ screen by typing ‘STRSPCON’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code of the Branch in which report is being generated from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Variances Maintained Today Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch Date |
Indicates the branch date |
Branch |
Indicates Branch Code and Branch Name |
Run Date |
Indicates Date on which report is generated |
User ID |
Indicates User ID |
Module |
Indicates the module code |
Run Time |
Indicates the time on which the report is generated |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account Number |
Indicates Account Number |
Customer Id |
Indicates Customer Number |
Customer Name |
Indicates Customer Short Name |
Account Class |
Indicates Account Class of the account |
Product |
Indicates Product used for account |
Effective Date |
Indicates Effective Date of new UDE values |
UDE Value |
Indicates new values of UDE |
Note
Variance maintained for the TD accounts is displayed for the current day.
If the account is a CASA account, system will not display the variance maintained for the current day. A back dated value has to provided as input parameter to view the variance report for CASA accounts
This section contains the following topics:
Oracle FLEXCUBE facilitates maintenance of operating instructions for a customer account. If an operating instruction is maintained for an account, then while processing transactions pertaining to that account the system validates the instructions.
You can generate ‘Operating Instructions Not Captured Report’ to list the accounts for which the following operating instructions are not maintained:
You can invoke the ‘Operating Instructions Not Captured Report’ screen by typing ‘CAROPICT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code of the Branch in which report is being generated from the adjoining option list.
Customer Type
Select customer type of the account for which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Customer Category
Specify a valid category of the customer for whose account you wish to generate a report, from the adjoining option list.
Account Number
Specify a valid account number for which you wish to generate a report, from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Operating Instructions Not Captured Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Bank Code |
Indicates Bank Code |
Bank Name |
Indicates Bank Name |
Branch Code |
Indicates Branch code |
Branch |
Indicates Branch Name |
Run Date |
Indicates Date on which report is generated |
User ID |
Indicates User ID |
Run Time |
Indicates the time on which the report is generated |
Body of the Report
The following details related to every customer are displayed as body of the generated report:
Field Name |
Field Description |
Customer Number |
Indicates Customer Identification ID |
Account Details |
|
Account Number |
Indicates Account Number |
Account Description |
Indicates Account Details |
Account Open date |
Indicates Account Opening Date |
Mode of Operation |
Indicates Operation Details |
Signatory Details Maintained |
Indicates Account Signature |
Account Status |
|
Status code |
Indicates Status Code |
Status description |
Indicates Status Description |
Minor Details |
|
Is Minor |
Indicates Customer Minor status |
Guardian Name |
Indicates Guardian Name |
Nominee Name |
Indicates Nominee Name |
Maker ID |
Indicates Maker ID |
This section contains the following topics:
Customer documentation standards for Minor Account are different from a regular Account. Minor accounts are also restricted to certain classes of transactions based on the set-up maintained at ‘Bank Parameters’ level.
You can generate ‘Minor Customer Details Report’ to view list of minor customers, which aid the Bank while auditing and controlling the account. This report lists details of all Minor Accounts available in the system for a given branch code, maturity type, days to attain age and date of attaining the age.
You can invoke the ‘Minor Customer Details Report’ screen by typing ‘CARMICUS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code of the Branch in which report is being generated from the adjoining option list.
No. of Days to Attain Maturity
Specify the number of days within which the Minor Account attains maturity.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Minor Customer Details Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Bank |
Indicates Bank Name |
Branch |
Indicates Branch Name |
Run Date |
Indicates Date on which report is generated |
User Id |
Indicates Operator ID |
Run Time |
Indicates Run Time |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Customer ID |
Indicates Customer ID |
Customer Name |
Indicates Customer Name |
Date of Birth |
Indicates Date of Birth |
Date of Maturity |
Indicates Date of Maturity |
Legal Guardian |
Indicates Name of the guardian |
Contact No |
Indicates Contact Number |
Status |
Indicates Customer status |
No of Days for maturity |
Indicates the number of days for maturity |
This section contains the following topics:
Oracle FLEXCUBE facilitates to view the overdraft accounts details in the system. The overdraft account can be a current or saving account, which will have the limits attached. Each limit will have the Limit amount, limit start and end date. You can generate ‘CASA-Overdraft Report’ to view the operative overdraft limit and current outstanding for each account. This report lists customer accounts which have the overdraft facility and limits that are associated to them.
The transaction details are grouped based on the Account Class. You can invoke ‘CASA-Overdraft Report’ screen by typing ‘CAROVDFT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Specify a valid code of the Branch in which report is being generated, from the adjoining option list.
Account Number
Specify a valid account number maintained in the specified Branch for which you wish to generate report, from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the CASA-Overdraft Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Bank |
Indicates Bank Name |
Branch |
Indicates Branch Name |
Run Date |
Indicates Date on which report is generated |
User Id |
Indicates Operator ID |
Run Time |
Indicates Run Time |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch Code |
Indicates the branch code |
Account Class |
Indicates the account class |
Customer ID |
Indicates the customer identification number |
Customer Name |
Indicates the name of the customer |
Account Number |
Indicates Customer Account Number |
Account Currency |
Indicates the account currency |
Book Balance |
Indicates Account current balance |
Line details for each account |
|
Line Start Date |
Indicates the line start date |
Line Expiry Date |
Indicates the line expiry date |
Line Currency |
Indicates Line Currency |
Line Amount |
Indicates Line Amount |
Overdraft Start date |
Indicates Temporary Over draft limit start date |
Overdraft End Date |
Indicates Temporary Over draft limit expiry date |
OD Currency |
Indicates Over draft currency |
OD Limit |
Indicates Temporary Over draft Limit in LCY |
Latest Debit Date |
Indicates Latest debit transaction date |
Latest Credit Date |
Indicates Latest credit transaction date |
Latest Debit Txn |
Indicates Latest debit transaction amount |
Latest Credit Txn |
Indicates Latest credit transaction amount |
If there are no customer initiated transactions for the period set at the product level, the CASA account status will be changed to dormancy. After a specific period in the dormancy status, the money is transferred to the unclaimed General Ledger account as decided by the bank. If any of the accounts have a credit balance that is less than the amount specified in the dormant status, then you can view details of these accounts in Insignificant Balance Dormant Account Report. This report will generate a list of dormant accounts which have credit balances less than the minimum amount.
This is a nil Balance Dormant Account Report for CASA Accounts. Accounts are grouped based on the product type. You can invoke ‘Insignificant Balance Dormant Account Report’ screen by typing ‘CARDORAC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
Insignificant Amount
Specify the insignificant amount balance available in the account for which the report is being generated.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Insignificant Balance Dormant Account Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Bank |
Indicates Bank Name |
Branch |
Indicates Branch Name |
Run Date |
Indicates Date on which report is generated |
User Id |
Indicates Operator ID |
Run Time |
Indicates Run Time |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Product |
Indicates the product |
Account Number |
Indicates the account number |
Customer No |
Indicates the customer number |
Customer Name |
Indicates Customer Name |
Maker Id |
Indicates Maker Id |
Dormancy Date |
Indicates Account dormant date |
Dormant Days |
Indicates Dormancy days |
Available balance |
Indicates Account available balance |
This section contains the following topics:
Credit Risk Rating (CRR) is analysed by Oracle FLEXCUBE Retail, to determine whether an asset is a performing asset or not. The bank can be track either at customer level or at account level based on preferences maintained by the system. You can generate ‘CRR Movement Report’ with details of status change.
You can invoke ‘CRR Movement Report’ screen by typing ‘ACRSTMOV’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following parameters here:
Branch Code
Select Branch code for which you want to generate the report from the options. The following options are available for selection:
If you have selected specific, specify a valid branch code for which you want to generate the report, from the adjoining option list.
Status
Select status for which you want to generate the report from the options. The following options are available for selection:
If you have selected specific, specify a valid transaction code for which you want to generate the report, from the adjoining option list.
Status Change Type
Select a valid type of status change for which you want to generate the report, from the adjoining drop-down list. This list displays the following values:
From Date
Specify a valid date from when you wish to generate the interest accrual report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the interest accrual report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the ‘CRR Movement Report’ is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Bank Code / Bank Name |
Indicates Bank code and Bank Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
Report Run Date |
Indicates Current Branch Date |
Report Run Time |
Indicates Current Branch Time |
Op Id |
Indicates Logged in user |
From Date |
Indicates Date captured as start date |
To Date |
Indicates Date captured as end date |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Module |
Indicates ‘ST’ for CASA Accounts, ‘CL’ for Loan Accounts, ‘CI’ for Islamic Financing, ‘LE’ for leasing, and ‘MO’ for Mortgages |
Customer Number |
Indicates Customer Number |
Customer Name |
Indicates Customer Name |
Account Number |
Indicates CASA Loan Account Number |
Customer Previous CRR |
Indicates Previous CIF Status |
Customer Current CRR |
Indicates Current CIF Status |
Account Previous Status |
Indicates,
|
Account Current Status |
Indicates,
|
Status Change Date |
Indicates,
|
Available Balance/Outstanding Balance |
Indicates,
|
CCY |
Indicates,
|
This section contains the following topics:
Oracle FLEXCUBE generates a report that contains the details of VAT deduction from CASA account for every branch on a monthly basis. For generating this report, the following conditions should be met:
You can use the UDF ‘TRNCODE_TYPE’ to define the type of charge vs. VAT, service charge or other charge.
The VAT deduction report is generated during end of day operations at the month end, based on the following parameters.
Based on the above details, the system generates the report.
The report contains the following details:
Header
Field Name |
Field Description |
Report Name |
Report name |
Bank Code / Bank Name |
Bank code and bank name |
Branch Code / Branch Name |
Current branch code and branch name |
Report Run Date |
Current branch date |
Report Run Time |
Current branch time |
Body
Field Name |
Field Description |
Product Code |
Product code |
Product Name |
Product description |
Currency |
Account currency |
Account Number |
Account number |
Customer Name |
Customer short name |
SC - Basis [Percentage / Fixed Amount] |
Service charge rule method will be provided Fixed Amount or Rate |
SC - Applicable [Percentage / Fixed Amount] |
Percentage or fixed amount applicable for service charge |
Service Charge |
Service charge in local currency |
VAT - Basis [Percentage / Fixed Amount] |
VAT Rule Method will be provided Fixed Amount or Rate |
VAT - Applicable [Percentage / Fixed Amount] |
Percentage or Fixed Amount applicable |
VAT Deducted |
VAT in local currency |
Transaction Reference Number |
Reference number of the transaction |
This section contains the following topics:
Oracle FLEXCUBE generates a report that contains the details of the duplicate Customers based on De-duplication rule condition maintained in the system. To invoke ‘Duplicate Customer List’ screen, type ‘STRPDEDP’ in the field at the top right corner of the Application toolbar and click the adjoining arrow button.
Branch Code
Specify the branch code for which you want to generate the report of the duplicate customers.
The report contains the following details.
Header
Field Name |
Field Description |
Branch Code / Branch Name |
Branch Code, All option can be selected if the report needs to be for all the branches |
Dedup Rule Condition |
Parameter based on which the de-duplication validation is done |
Body
Field Name |
Field Description |
Customer Number |
Customer Id of the duplicate customers |
Customer Type |
Type of the customer for the which the duplicate id is found |
Short Name |
Short name |
SSN |
Social Security Number of the customer |
Full Name |
Full name |
This section contains the following topics:
You can generate Account Activated Report using ‘Account Opened and Activated Report’ screen. You can invoke this screen by typing ‘CARPAACC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch Code
You can generate this report for all the branches or a single branch alone. You can indicate the branch for which the report is being generated using the following options:
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates the date on which the report was generated |
Report Run Time |
Indicates the time of report generation |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Category |
Indicates the category |
Branch Code |
Indicates the branch code |
Branch Name |
Indicates the name of the branch |
Customer Account |
Indicates customer account |
Customer Name |
Indicates customer name |
Account Open Date |
Indicates the date when the account was opened |
Account Type |
Indicates the type of account |
Currency |
Indicates the account currency |
RM Code |
Indicates the relationship manager code |
Passport/Licence Number |
Indicates the passport or license number |
Maker |
Indicates the name of the maker of the record |
Maker Date |
Indicates the date when the record was created |
Checker |
Indicates the name of the checker who authorized the record |
Checker Date |
Indicates the date on which the record was authorized |
This section contains the following topics:
You can generate Account Blocked Report using ‘Account Block and Reason Report’ screen. You can invoke this screen by typing ‘CARPACCB’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch Code
You can generate this report for all the branches or a single branch alone. You can indicate the branch for which the report is being generated using the following options:
Hold Code
The system allows to generate the amount block report based on hold code criteria.
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates the date on which the report was generated |
Report Run Time |
Indicates the report generation time |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch |
Indicates the branch code |
Branch Name |
Indicates the name of the branch |
Account Number |
Indicates the customer account number |
Currency |
Indicates the account currency |
Amount Block Number |
Indicates the amount block number |
Hold Code |
Indicates the hold code |
Customer Name |
Indicates the name of the customer |
Maker |
Indicates the maker ID of the record |
Maker Date |
Indicates the date when the record was created |
Checker |
Indicates the checker ID of the record |
Checker Date |
Indicates the date on which the record was authorized |
Blocked Date |
Indicates the blocked date |
Expiry Date |
Indicates the date of expiry of Block |
Amount |
Indicates the blocked amount |
Reason |
Indicates the reason of Block |
This section contains the following topics:
You can generate Account Closure Report using ‘Account Closure and Reason Report’ screen. You can invoke this screen by typing ‘CARPACCL’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch Code
You can generate this report for all the branches or a single branch alone. You can indicate the branch for which the report is being generated using the following options:
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates the date on which the report was generated |
Report Run Time |
Indicates time of report generation |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch Code |
Indicates the branch code |
Branch Name |
Indicates the name of the branch |
Closure Date |
Indicates the closure date of the Account |
Account Number |
Indicates the customer account number |
Account Currency |
Indicates the account currency |
Customer Name |
Indicates the name of the customer |
Accrued Profit Amount |
Indicates the accrued profit amount |
Account Current Balance |
Indicates the current account balance |
Reason |
Indicates the reason of the closure |
Approved By |
Indicates by whom the account closure is approved |
Maker ID |
Indicates the Maker ID of the record |
Checker ID |
Indicates the Checker ID who authorized the record |
This section contains the following topics:
You can generate Account Open or Closure Report using ‘Account Open or Close Report’ screen. You can invoke this screen by typing ‘CARPAOCR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates the date on which the report was generated |
Report Run Time |
Indicates the time of report generation |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account Number |
Indicates the customer account number |
Short Name |
Indicates the short name of the customer |
Full Name |
Indicates the full name of the customer |
Currency |
Indicates the account currency |
Current Balance |
Indicates the current account balance |
Account Officer Code |
Indicates the code of the account officer |
Maker ID |
Indicates the identification of the maker of the record |
Maker Date Stamp |
Indicates the date and time when the record was created |
Checker ID |
Indicates the identification of the checker who authorized the record |
Checker Date Stamp |
Indicates the date and time on which the record was authorized |
This section contains the following topics:
You can generate Passbook Details Report using ‘Passport Details’ screen. You can invoke this screen by typing ‘CARPASBK’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch
Specify the branch of the account.
Account
Specify the account number.
Account Description
Give a brief description on the account.
Passbook Number
Specify the passbook number.
Status
Specify the status of the passbook.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current System Date |
Report Run Time |
Indicates Current System Time |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account Number |
Indicates the customer account number |
Account Description |
Gives a brief description on the account |
Passbook Number |
Indicates the number of the passbook |
Passbook Status |
Indicates the status of the passbook |
Issue date |
Indicates the date when passbook was issued |
Status |
Indicates the status of the passbook |
Status Change Date |
Indicates the status change date |
Charge Component |
Indicates the charge component |
Charge Amount |
Indicates the charge amount |
Charge Currency |
Indicates the charge currency |
Charge Amount in Local Currency |
Indicates the charge amount in local currency |
Exchange Rate Used |
Indicates the exchange rate used |
This section contains the following topics:
You can generate Account Balance Report using ‘Account Balance List Report’ screen. You can invoke this screen by typing ‘CARPBALC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch Code
You can generate this report for all the branches or a single branch alone. You can indicate the branch for which the report is being generated using the following options:
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Date |
Indicates the branch open date |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates the date on which the report was generated |
Report Run Time |
Indicates time of report generation |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account Number |
Indicates the account number |
Short Name |
Indicates the short name of the customer |
Full Name |
Indicates the full name of the customer |
Currency |
Indicates the account currency |
Current Balance |
Indicates the currenct balance |
Unclear balance |
Indicates the unclear balance of the account |
Hold |
Indicates the amount on hold |
Available balance |
Indicates the available balance of the account |
This section contains the following topics:
You can generate Customer Limit Position Report using ‘Customer Limit Position Tracking Report’ screen. You can invoke this screen by typing ‘CARPCSLM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Liability ID Option
Select the liability Id from the following options:
Liability Number
Select the liability number from the adjoining option list, if the liability id option is selected as ‘Single’.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
Branch Date |
Indicates the branch open date |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates the date on which the report was generated |
Report Run Time |
Indicates the time of report generation |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Level |
Indicates the level of the record |
Liability ID |
Indicates the liability ID |
Line ID |
Indicates the Line ID |
Main Line |
Indicates the Main Line |
Group Name |
Indicates the name of the group |
Availability Flag |
Indicates whether the line is available or not |
Line Currency |
Indicates the currency of the line |
Limit Amount |
Indicates the limit amount of the line |
Start Date |
Indicates the start date of the line |
Available Amount |
Indicates the amount available for the line |
Expiry Date |
Indicates the expiry date of the line |
Utilization Amount |
Indicates the amount utilized from the line |
This section contains the following topics:
You can generate Dormant Account Report using ‘All Dormant Account Report’ screen. You can invoke this screen by typing ‘CARPDACC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch Code
You can generate this report for all the branches or a single branch alone. You can indicate the branch for which the report is being generated using the following options:
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates the date on which the report was generated |
Report Run Time |
Indicates the time of report generation |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch |
Indicates the branch code |
Branch Name |
Indicates the name of the branch |
RM Code |
Indicates the relationship manager code |
Account Number |
Indicates customer number |
Currency |
Indicates the account currency |
Full Name |
Indicates the full name of the customer |
Passport |
Indicates the passport |
Dormancy Date |
Indicates the date of dormancy of the account |
Dormancy Status |
Indicates the status of dormancy |
Account Opened Date |
Indicates the date when the account was opened |
Last Dr Activity |
Indicates the last debit activity date |
Last Cr Activity |
Indicates the last credit activity date |
This section contains the following topics:
You can generate Debit Card Issuance Report using ‘Debit Card issued Report’ screen. You can invoke this screen by typing ‘CARPDCRD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates date on which the report was generated |
Report Run Time |
Indicates time of report generation |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account Number |
Indicates the customer account number |
Full Name |
Indicates the full name of the customer |
Currency |
Indicates the account currency |
Name on the Card |
Indicates the name on the card |
Expiry Date |
Indicates the expiry date of the card |
MIS Code |
Indicates the MIS Code |
Maker ID |
Indicates the identification of the maker of the record |
Maker Date Stamp |
Indicates the date and time when the record was created |
Checker ID |
Indicates the identification of the checker who authorized the record |
Checker Date Stamp |
Indicates the date and time when the record was authorized |
This section contains the following topics:
You can generate New Minor Account Report using ‘New Minor Account Report’ screen. You can invoke this screen by typing ‘CARPMACC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch Code
You can generate this report for all the branches or a single branch alone. You can indicate the branch for which the report is being generated using the following options:
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates the date on which the report was generated |
Report Run Time |
Indicates time of generation of the report |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch |
Indicates the branch code |
Branch Name |
Indicates the name of the branch |
CIF Number |
Indicates the customer number |
Account Number |
Indicates account number |
Account Type |
Indicates the type of account |
Account Currency |
Indicates the account currency |
Customer Name |
Indicates customer name |
Account Open Date |
Indicates the date when the account was opened |
Customer DOB |
Indicates the date of birth of the customer |
Maker |
Indicates the Identification of the maker of the record |
Maker Date |
Indicates the date when the record was created |
Checker |
Indicates the Identification of the checker who authorized the record |
Checker Date |
Indicates the date on which the record was authorized |
This section contains the following topics:
You can generate Non Resident Account Report using ‘Non Resident Account Report’ screen. You can invoke this screen by typing ‘CARPNRAC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch Code
Specify the branch code from the adjoining option list.
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates date on which the report was generated |
Report Run Time |
Indicates time of report generation |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch Code |
Indicates the branch code |
Branch Name |
Indicates the name of the branch |
Account Number |
Indicates the account number |
Account Open Date |
Indicates the date when the account was opened |
Account Type |
Indicates the type of account |
Account Currency |
Indicates the account currency |
Customer Name and RM Code |
Indicates customer name and Relationship Manager Code |
Nationality |
Indicates the nationality of the customer |
Residing Country |
Indicates the country where the customer resides |
Customer Identification and Details |
Indicates the customer identification and detials |
Maker ID & Date |
Indicates the Identification of the maker and date of creation of the record |
Checker Id & Time |
Indicates the Identification of the checker who authorized the record and date of authorization |
This section contains the following topics:
You can generate a report of document checklist using ‘Document Checklist’ screen. You can invoke this screen by typing ‘STRDOCL’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Branch Code
Specify the branch code from the adjoining option list.
Document Status
Select the status of the document from the adjoining drop down list.
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current System Date |
Report Run Time |
Indicates Current System Time |
Page No |
The page number of the report |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Branch Code |
Indicates the branch code |
Customer Number |
Indicates the customer number |
Customer Name |
Indicates customer name |
Customer Account Number |
Indicates the account number of the customer |
Document Type |
Indicates the type of document |
Expiry Date |
Indicates the expiry date |
Expected Date Submission |
Indicates the expected date of submission |
Actual Submission Date |
Indicates the actual submission date |
This section contains the following topics:
You can generate CASA branch transfer report using ‘CASA Branch Transfer Report’ screen. You can invoke this screen by typing ‘STRFRCAS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Previous Branch Code
Specify the previous branch code from the adjoining option list.
Current Branch Code
Specify the current branch code from the adjoining option list.
Transferred Date
Specify the date of transfer of the branch.
Account Class
Specify the account class from the adjoining option list.
Customer No
Specify the customer number from the adjoining option list.
Customer Account No
Specify the customer account number from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current System Date |
Report Run Time |
Indicates Current System Time |
Page No |
The page number of the report |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Customer Account Number |
Indicates the account number of the customer |
Current Branch |
Indicates the current branch code |
Previous Branch |
Indicates the previous branch |
Transferred Date |
Indicates the transferred date |
Account Class |
Indicates the account class |
Customer Number |
Indicates the customer number |
Customer Name |
Indicates customer name |
This section contains the following topics:
You can generate Cheque Discounting Report using ‘Customer Cheque Discounting Report’ screen. You can invoke this screen by typing ‘PDRCHDRF’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Beneficiary Account
Specify the beneficiary account from the adjoining option list.
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current System Date |
Report Run Time |
Indicates Current System Time |
This section contains the following topics:
You can generate Cancelled or Rejected Report using ‘Cancelled or Rejected Report’ screen. You can invoke this screen by typing ‘CORRJDD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Report Date
Specify the report date from the adjoining calendar
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Branch Date |
Indicates the date of Branch in which report is taken |
Page No |
Displays Page No out of total No of pages in report |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current System Date |
Report Run Time |
Indicates Current System Time |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Number of Cheques Cancelled |
Indicates the number of cheques cancelled |
MC Number |
Indicates the MC Number |
Date of Booking |
Indicates the date of booking |
Amount |
Indicates the amount |
Customer Name |
Indicates customer name |
Beneficiary Name |
Indicates the name of the beneficiary |
Branch Code |
Indicates the branch code |
Processor ID |
Indicates the processor identification number |
Authorizer ID |
Indicates the authorizer ID |
This section contains the following topics:
You can generate this EOD Report at branch level for all CASA accounts with large debit balances. The report enlists all CASA accounts that have debit balance equal to or more than the threshold value maintained. The Report also displays the currency wise threshold value maintained for the account class of the CASA account.
For further details on report parameter and batch maintenances, refer to the Reports User Manual.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Branch Date |
Indicates the date of Branch in which report is taken |
Page No |
Displays Page No out of total No of pages in report |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current System Date |
Report Run Time |
Indicates Current System Time |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account Class |
Indicates the account class |
Currency |
Indicates the currency of the transaction |
Threshold Amount |
Indicates the threshold amount |
Account Number |
Indicates the account number |
Account Name |
Indicates the account name |
Customer ID |
Indicates the customer ID |
Customer Name |
Indicates the name of the customer |
Customer Telephone No |
Indicates the customer telephone number |
Available Balance |
Indicates the available balance |
This section contains the following topics:
You can generate ad-hoc combined statement through ‘Ad-Hoc Combined Statement’ screen.You can invoke this screen by typing ‘STDCDSMT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Customer No
Select the customer number from the adjoining option list.
Customer Name
The system displays the customer name.
Statement ID
Select the statement ID from the adjoining option list.
Balance
You can select the balance to view based on the book date or value date.
From Date
Specify the from date for the combined statement generation.
To Date
Specify the to date for combined statement generation.
Print Options
You can print, view or spool the statement.
Apply Online Charges
Check this box to indicate that the charges needs to be applied to generate the ad-hoc account statement.
Send to Customer
Check this box to send the statement to the customer.
You can process the ad-hoc combined statement by doing the following:
You can view the online charges computed for the generation of the combined statement through the Charges screen. If the charge needs to be waived, 'Apply Online Charge' in the main screen should be unchecked You can invoke this screen by clicking ‘Charges’ on the ‘Ad-Hoc Combined Statement’ screen.
The system displays the following details in the charges screen:
Note
The following maintenances are necessary for the online charge calculation:
This section contains the following topics:
You can generate Combined Statement Report using ‘Combined Statement Report’ screen.
Customer No
The system displays the customer number.
Statement ID
The system displays the statement ID.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Branch Date |
Indicates the date of Branch in which report is taken |
Page No |
Displays Page No out of total No of pages in report |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current System Date |
Report Run Time |
Indicates Current System Time |
Customer Name |
Indicates the name of the customer |
Customer Address |
Indicates the address of the customer |
Account Summary Details |
Indicates the summary details for CASA, TD and CL |
Body of the Report
The body of the report displays:
This section contains the following topics:
You can generate a report that contains the details of primary party changes made in the system using ‘Customer Change Report’ screen. To invoke this screen, type ‘STRCUSCH’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.
Specify the following details:
Branch Code
Specify the branch code for which you need to generate the report. The report will contain the details of the customer changes specific to the selected branch.
if you do not specify the branch code, the report will contain primary party changes happened in the system across all branches.
Account
Specify the account number whose details should be available in the report. The report will contain details pertaining to the customer changes happened on the selected account. If you do not specify the account number, the report will contain the details of the primary party changes happened in all the accounts in the selected branch.
Account Description
The system displays the account description based on the account selected.
From Date
Specify the start date of the report period. This can be the ‘To date’ or a date prior to that. By default, the system displays the current date.
To Date
Specify the end date of the report period. This can be the ‘From date’ or a date later than that. By default, the system displays the current date.
The report contains the following details:
This section contains the following topics:
You can generate passbook Issued Report to show date wise details of passbooks issued to various accounts.You can invoke the ‘Passbook Issued Report’ screen by typing ‘CARPBISU’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following details:
Branch
Select if single or all branch details needs to be generated. The list displays the following options:
After selecting the required option, specify the branch code. Alternatively, you can select branch code from the option list. The list displays all valid branch code maintained in the system.
User
Select if single or all user details needs to be generated. The list displays the following options:
After selecting the required option, specify the user details. Alternatively, you can select user code from the option list. The list displays all valid user code maintained in the system.
From Date
Select the date from which the reports need to be generated from the adjoining calendar.
To Date
Select the date till which the reports need to be generated from the adjoining calendar.
Report Format
Select the format in which you need to generate the report from the drop-down list. The list displays the following values:
Report Output
Select the output in which you need to generate the report from the drop-down list. The list displays the following values:
Printer At
Select location where you wish to print the report from the drop-down list. The list displays the following values:
Printer
Select printer using which you wish to print the report from the option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in ‘Passbook Issued Report’ is as follows:
Header
The Header carries the title of the report, information on the branch code, the date and time, the branch date, the user id, the module name and the page number of the report.
Body of the Report
The following details are displayed as body of the generated report:
Sl. No |
Field Name |
Information |
1 |
Issue Branch |
Branch Code From which passbook is issued |
2 |
Date of Issue |
Date on which Passbook is issued |
3 |
Account Branch |
Account branch of the account to which passbook is issued |
4 |
Account Number |
Account No. for which passbook is issued |
5 |
Account Description |
Account Description |
6 |
Passbook Type |
Type of Passbook |
7 |
Passbook Number |
Passbook Number |
8 |
Passbook Status |
Status of Passbook (e.g. Active, Re-issue & Active) |
9 |
Maker Id |
User id who issued the passbook |
10 |
Checker Id |
Authorizer who authorized the issue of passbook |