11. Reports

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), history reports and so on. A set of report formats is pre-defined for every module.

This chapter contains the following sections:

11.1 Generating Reports

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.

Click ’OK’ button when you have specified your preferences. The ‘Print Options’ screen gets displayed, where you can specify the preferences for printing the report.

In this screen, you can indicate the following preferences for printing the 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

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’.

Contents of the report

The contents of the report are discussed under the following heads:

Header

The Header section of the report carries the title of the Report, information on the User who generated the report, the branch code, the date and time and the page number of the report.

Body of the report

The actual contents of the report are displayed in this section. It is detailed for each report, in the subsequent sections of this document.

11.2 Accrual Control List Report

This section contains the following topics:

11.2.1 Generating Accrual Control List Report

The accrual control journal gives the details of accruals done on loan contracts, as of a specific date.

This report shows the Events and Component details for each account and will be generated for a specific combination of the Account Number, Event Date and Branch Name.

The Component and Item details will be displayed based on Events and Account Number.

You can invoke this report screen by typing ‘CLRPACCR’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.2.2 Selection Options

If you generate the report manually, the report will list the accounts whose Accrual Processing Date is equal to the date that you specify in the screen CL Accrual Control List.

Specify the following details:

Accrual Processing Date

Specify the accrual processing date to be considered for the report.

11.2.3 Contents of the Report

The options that you have specified while generating the report are printed at the beginning of the report. Apart from the header the following information is provided for each contract:

Body of the Report

Field Description
Account Num­ber The account number of the contract
Status The status of the loan contract
Component This is the component of the loan against which accrual entries are passed
Currency This is the component currency. If not specified at the Component level, the loan currency is displayed
Current Accrual This is the amount for which accrual entries are passed for the current month
Value Date The Value Date of the contract

 

11.3 Accrual Control List Summary Report

This section contains the following topics:

11.3.1 Generating Accrual Control List Summary Report

The Accrual Control List Summary report summarizes the details of accruals product wise.

11.3.2 Contents of the Report

Apart from the header the following information is provided for each contract:

Body of the Report

Field Description
Product Code This is the product for which the summary report is being generated
Status The status of the loan contract under the product
Component This is the component of the loan against which accrual entries are passed, for the contract under the product
Currency This is the component currency. If not specified at the Component level, the loan currency is displayed
Value Date The Value Date of the contract under this product
Current Accrual This is the amount for which accrual entries are passed for the current month

 

11.4 Adverse Status Report

This section contains the following topics:

11.4.1 Generating Adverse Status Report

The Adverse status report gives details of loan contracts that have moved into a status other than active and liquidated.

The amounts outstanding for the various components are reported in this report.

You can invoke this report screen by typing ‘CLRPSTAT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.4.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Product Type

You can generate the Adverse Status report for a specific Product Category or for all categories. Select a Product Category from the option list provided.

Product Code

You can generate a product-wise report. Select the Product Code from the option list which contains all valid products under the category you have selected.

Currency

Under specific Product(s), you can choose to generate reports in a specific currency(s).

Customer

You can generate this report for specific customer(s).

Status

Specify a valid status of the account from the adjoining option list.

From Date (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date greater than the date you enter here.

To Date (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date lesser than the date you enter here.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

11.4.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Apart from the header the following information is provided for each contract:

Body of the Report

Field Description
Product Code This is the product for which the report is generated
Status This is the current status of the component that is in a status other than Active or Liquidated. The status codes are defined for a prod­uct and applied to contracts involving the product
Customer This is the CIF ID of the customer involved in the loan.
Customer Name The name of the customer
Account Number This is the account number of the loan account being reported
Component The component whose status details the report reflects
Currency This is the component currency. If not specified at the Component level, the loan currency is displayed
Maturity This is the Maturity Date of the loan
Maximum Over­due Days If more than one account is overdue under the product, this field will reflect the number of overdue days of the account with the highest number of overdue days
Overdue Amount This is the total amount that is overdue for the component as of the date of report generation
Date of Last Dis­bursement Date of Last Disbursement
Date of Last Pay­ment Date of Last Payment

 

11.5 Adverse Status Summary Report

This section contains the following topics:

11.5.1 Generating Adverse Status Summary Report

The Adverse Status Summary report summarizes the details of each contract.

11.5.2 Contents of the Report

Apart from the header the following information is provided for each contract:

Body of the Report

Field Description
Product Code This is the product for which the report is generated
Status This is the current status of the contract for which details are being reported
Component This is the component of the loan against which the payment due is being reported. If more than one component falls due on the same day they will be reported one by one
Currency This is the component currency. If not specified at the Component level, the loan currency is displayed
Earliest Due Date For all the loans reported, this is the earliest date on which a repayment is due
Latest Due Date For all the loans reported, this is the latest date on which a repay­ment is due
Cumulative Overdue Amount This is the total amount that is overdue for the component(s) as of the date of report generation

 

11.6 Amortization Report

This section contains the following topics:

11.6.1 Generating Amortization Report

The Amortization Report gives the amortization details of loan contracts.

You can invoke this report screen by typing ‘CLRPAMSC’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.6.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.\

You can specify the following preferences for the report:

Loan Account

Enter the Account Number for which amortization details should be displayed in the report. If you do not enter an account number here, the report will be generated for all accounts.

11.6.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Apart from the header the following information is provided for each contract:

Body of the Report

Field Description
Account Num­ber This is the reference number of the loan being reported
Principal The principal amount of the loan being reported
Product This is the product for which the report is generated
Customer This is the CIF ID of the customer involved in the loan
Tenor The tenor of the loan being reported
Year This is the year for which the amortization details are being dis­played in the report
Due date The due date of an installment of the loan
Currency The currency of the account
Installment This is the installment amount of the loan
Interest Due The interest amount due
Principal Due The principal amount due
Total Amount Due The total principal amount due on the loan

 

11.7 Contract Retrieval Report

This section contains the following topics:

11.7.1 Generating Contract Retrieval Report

The Contract Retrieval report gives you comprehensive information about a loan contract. Information about loan contracts that are active, liquidated and reversed can be retrieved through this report. You can generate the report for a variety of reasons.

You can invoke this report screen by typing ‘CLRPRETR’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.7.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Product Type

You can generate the Contract Retrieval Report for a specific product type or for all categories. Select a product type from the option list provided.

Product Code

You can generate a product-wise report. Select the Product Code from the option list which contains all valid products under the category you have selected.

Currency

Under specific Product(s), you can choose to generate reports in a specific currency(s).

Customer

You can generate this report for specific customer(s).

Maturity Type

You can generate the report only for a particular Maturity Type. The Maturity type of a loan can be

You can generate the report either for fixed maturity loans or call loans.

Account Status

You can generate the report based on the status of the loan contract. The report can be generated for loans with the following statuses only:

All the loans with the specified status for the specific period will be reported.

Auth Status

You can generate the report for loan contracts either with an authorized or unauthorized status.

From (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date greater than the date you enter here.

To (Value Date)

Enter the Value Date of the contracts. The system will generate a report for the contracts that have a Value Date lesser than the date you enter here.

From (Maturity Date)

Specify the Maturity Date of the loan. The report will be generated for all contracts whose Maturity Date is equal to, or greater than the date you have specified here.

To (Maturity Date)

Specify the Maturity Date of the loan. The report will be generated for all contracts whose Maturity Date is equal to, or less than the date you have specified here.

11.7.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Account Num­ber The account number for which the report is being generated
Account Status This is the current status of the account
Outstanding Amount This is the total outstanding amount that the customer has to repay. This amount also includes amounts belonging to earlier schedules that are yet to be paid. In case the customer has made pre-payments the outstanding amount can be less than the due amount
Product Code This is the product for which the report is generated
Product Cate­gory This is the product category to which the generated report belongs
Product Description This is the description of the product
User Refer­ence This is the reference number of the loan being reported
Customer This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Related Refer­ence Number This is the alternate account number
Account Cur­rency The currency of the account
Financed Amount The loan amount financed
Original Start Date This is the original start date of the loan
Booking Date The Booking Date of the contract
Value Date The Value Date of the contract
Maturity Type This is the Maturity Type of the contract
Maturity Date The Maturity Date of the contract
Tenor (In days) The tenor of the loan
User Defined Status The status of the loan
Auth Status The authorization status of the contract
Liquidation Mode The liquidation mode of the contract
Rollover Type The rollover mode
Rollover Count The rollover count
Component The components of the loan are listed here
Currency This is the currency of the component
Rate Type This is the rate type
Rate Code This is the rate code
Resolved Value This is the effective rate
Special Amount This is the special amount for the component
EUR Currency This is the EUR currency

11.8 Event Report

This section contains the following topics:

11.8.1 Generating Event Report

Contract events are events that have taken place during the tenor of a loan contract.

Contract Events report gives a list of all the events that have taken place during the tenor of a loan contract. The events are listed by their Value Date.

You can invoke this report screen by typing ‘CLRPEVNT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.8.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

From (Account Number)

Select the starting account number. The system will display event details of all accounts from this account number.

To (Account Number)

Select the ending account number. The system will display event details of all accounts upto this account number.

Note

If you do not enter an account number in the above two field, the system will display the event details of all accounts.

From (Event Date)

Enter the date from which event details should be generated in the report for accounts.

To (Event Date)

Enter the date upto which event details should be generated in the report for accounts.

Note

You have the option of not specifying the ‘From’ and ‘To’ dates, but if you specify the ‘From Event Date’, it will be mandatory for you to specify the ‘To Event Date’.

Include Accrual Events also

Check this box to indicate accrual related events should be included.

Single Account Number

Select this option to indicate the report should be generated for a single account number or for a range.

All

Select this option to indicate the report should be generated for all accounts.

11.8.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Account Number The account number of the contract
Account Currency The currency of the account
Customer ID This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Event Description This is the code of the event for which details are being reported
Event Date This indicates the date on which the event took place.
Component Name The component for which details are displayed in the report
Component Amount Tag The amount tag
Component Value The value of the amount tag
Component Currency The currency of the component

 

11.9 Lending Forward Contract Report

This section contains the following topics:

11.9.1 Generating Lending Forward Contract Report

A forward contract is a loan with a future value date. The value date is the date on which the loan takes effect. The tenor of the loan contract will begin on this date. All accounting entries for the loan contract, all calculations for interest and all the other components based on the tenor will be made from this date onwards.

The forward contract report gives details of all the loan contracts with a future value date. Only contracts that take effect on a date later than or same as the specified date are included in the report.

You can invoke this report screen by typing ‘CLRPFRWD’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.9.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

From (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date greater than the date you enter here.

To (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date lesser than the date you enter here.

Note

It is not mandatory for you to enter the ‘From’ and ‘To’ dates.

Product Category

You can generate the Forward Contract Report for a specific Product Category or for all categories. Select a Product Category from the option list provided.

11.9.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Product Cat­egory This is the product category to which the generated report belongs
Account Number The account number of the contract for which the report is generated
Customer ID This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Amount This is the principal amount involved in the loan
Currency This is the currency in which the amount is displayed
Euro Equiva­lent The Euro equivalent of the loan amount
Value Date This is the date on which the loan takes effect
Maturity Type This is the maturity type of the loan. It could be fixed or call.
Maturity Date This is the date on which the loan matures. The maturity date is gen­erated in the report only in case of fixed maturity loans.

Field Description
CHARGE DETAILS
Component The component on which a charge is being applied
Amount The charge amount
Currency The currency in which the amount is displayed
Euro Equivalent The Euro equivalent of the charge
Waiver Whether or not the charge has been waived
INTEREST DETAILS
Component The interest component
Amount The interest amount
Currency The currency in which the amount is displayed
Euro Equivalent The Euro equivalent
Rate The interest rate being applied
Effective Rate The effective interest rate
Waiver Whether the interest has been waived

11.10 Forward Amendments Details Changes Report

This section contains the following topics:

11.10.1 Generating Forward Amendments Details Changes Report

The Forward Amendments Details Changes Report gives a list of all the amendments made to contracts with a future value date.

You can invoke this report screen by typing ‘CLRPFWCH’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.10.2 Selection Options

If you generate the report manually, the report will list the accounts whose Effective Date is between the dates that you specify in the screen Forward Amendments Report screen.

You can specify the following preferences for the report:

From (Effective Date)

Enter the date from which the report should include amendment details.

To (Effective Date)

Enter the date upto which the report should include amendment details.

11.10.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

 

Body of the Report

Field Description
Account Num­ber The account number of the contract for which the report is being gen­erated
Maturity Date The Maturity Date of the contract
Value Date The Value Date of the contract
Loan Amount The principal loan amount of the contract
Currency This is the component currency. If not specified at the Component level, the loan currency is displayed
Customer ID This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Transaction Date The date of the transaction
Amendment Date The date of amendment
New Maturity Date The Maturity Date after amendment
Differential Amount This is the difference between the original financed amount and the new financed amount. If there is no change in the loan value, this field will be zero.
Latest ESN The latest Event Sequence Number
Component Name The component that has been amended
New Rate The new rate that has been applied to the component
Old Rate The original rate
New Rate Code The new rate code
Old Rate Code The original rate code

 

11.11 Interest Calculation Analysis Report

This section contains the following topics:

11.11.1 Generating Interest Calculation Analysis Report

The Interest Calculation Analysis Report is generated for the accounts required between the given Value Date ranges.

The report will be generated for a specific combination of Branch, Account Number and Value Date range.

You can invoke this report screen by typing ‘CLRPCALC’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.11.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Single/Range (Account Type)

Select this option to indicate you are either specifying a range of account numbers or a specific one whose report is to be generated.

All (Account Type)

Select this option to indicate the report should be generated for all accounts.

From (Account Number)

Select the starting account number. The system will display details of all accounts from this account number.

To (Account Number)

Select the ending account number. The system will display details of all accounts upto this account number.

From (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date greater than the date you enter here.

To (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date lesser than the date you enter here.

11.11.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Account Num­ber The account number of the contract for which the report is being generated
Value Date The Value Date of the contract
Maturity Date The Maturity Date of the loan contract
Customer Id This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Component The component for which details are being displayed in the report
Interest Method The method if interest calculation
Currency The account currency
Start Date Reflects the start date of change of interest rate
End Date Reflects the end date of change of interest rate
Basic Amount The basic amount on which the interest is calculated
Rate The interest rate applicable to a certain period
Number of Days The number of days for which the rate is applicable
Interest Amount The is the interest amount

 

11.12 Linked Contracts Utilization Report

This section contains the following topics:

11.12.1 Generating Linked Contracts Utilization Report

This report will include the details of the accounts, lines or collaterals that have been linked to an account, based on the selection criteria. Linkage Account details and the Amount Financed will be shown for each Account in this report.

You can invoke this report screen by typing ‘CLRPLICU’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.12.2 Selection Options

If you generate the report manually, the report will list the accounts that you have specified in the Linked Contract Utilization screen.

You can specify the following preferences for the report:

From (Account Number)

Select the starting account number. The system will display event details of all accounts from this account number.

Note

If you enter an account number in this field, you will have to enter an account number in the field ‘To’.

To (Account Number)

Select the ending account number. The system will display event details of all accounts upto this account number.

Note

If you do not enter an account number in the above two fields, the system will display the event details of all accounts.

11.12.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Account Number The account number of the contract
Amount Financed The loan amount
Currency This is the component currency. If not specified at the Compo­nent level, the loan currency is displayed
Value Date The Value Date of the contract
Maturity Date The Maturity Date of the loan contract
Linkage Type This is the linkage type
Linked Reference Number The reference number of the linkage type
Customer ID This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Linkage Amount The amount linked
Secured Portion This is the secured portion of the loan

 

11.13 Maturity Report

This section contains the following topics:

11.13.1 Generating Maturity Report

The maturity report gives information about a contract that is:

You can invoke this report screen by typing ‘CLRPMATR’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.13.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Product Category

You can generate the Contract Retrieval Report for a specific Product Category or for all categories. Select a Product Category from the option list provided.

Product Code

You can generate a product-wise report. Select the Product Code from the option list which contains all valid products under the category you have selected.

Contract Currency

Under specific Product(s), you can choose to generate reports in a specific currency(s).

Customer

You can generate this report for specific customer(s).

Maturity Type

You can generate the report only for a particular Maturity Type. The Maturity type of a loan can be

You can generate the report either for fixed maturity loan or call loans.

Liquidation Mode

Components of a loan can be liquidated automatically or manually. In auto liquidation a schedule will be automatically liquidated on the day it falls due. In manual liquidation a schedule amount has to be liquidated manually.

You can generate the report based on the liquidation mode that you have specified. The report can be generated only for loans with auto liquidation or you can generate the report for loans that have to be manually liquidated.

From Date (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date greater than the date you enter here.

To Date (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date lesser than the date you enter here.

From Date (Schedule Date)

Specify the Starting Date of the schedule.

To Date (Schedule Date)

Specify the Ending Date of the schedule.

11.13.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Call Contracts
Customer ID This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Account Number The account number for which the report is being generated
Currency This is the component currency. If not specified at the Component level, the loan currency is displayed
Financed Amount The loan amount
Outstanding Amount This is the total outstanding amount that the customer has to repay. This amount also includes amounts belonging to earlier schedules that are yet to be paid. In case the customer has made pre-payments the outstanding amount can be less than the due amount.
Fixed Contracts
Due Date This is the due date for the due amount
Customer ID This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Account Number The account number for which the report is being generated
Maturity Date Maturity Date of the loan
Component Component which is due
Currency Currency of the component
Due Amount The amount which is due
Outstanding Amount This is the due amount minus the amount paid

 

11.14 Overdue Schedules Details

This section contains the following topics:

11.14.1 Generating Overdue Schedules Details

Repayment schedules can be defined for various components of a product like principal, interest, commission and fees. These schedules will apply to all the loans involving the product unless you redefine them at the time of processing the loan.

The Overdue Schedules report gives details of all repayment schedules of a loan that are overdue (i.e., are not paid even when they are beyond their scheduled repayment dates.

You can invoke this report screen by typing ‘CLRPOSCH’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.14.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

Product Type

You can generate the Overdue Schedules Report for a specific product type or for all categories. Select a product type from the option list provided.

Product Code

You can generate a product-wise report. Select the Product Code from the option list which contains all valid products under the category you have selected.

Currency

Under specific Product(s), you can choose to generate reports in a specific currency(s).

Customer

You can generate this report for specific customer(s).

From Date (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date greater than the date you enter here.

To Date (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date lesser than the date you enter here.

From Date (Schedule Date)

Specify the Starting Date of the schedule.

To Date (Schedule Date)

Specify the Ending Date of the schedule.

11.14.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Due Date The due date of the component which is overdue
Overdue Days The number of days by which the component is overdue
Customer This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Account Num­ber The account number of the customer for whom the report is being gen­erated
Status The status of the component which is overdue
Component The component which is overdue
Currency This is the component currency. If not specified at the Component level, the loan currency is displayed
Overdue Amount This is the component amount that is overdue

 

11.15 Overdue Schedules Summary

This section contains the following topics:

11.15.1 Generating Overdue Schedules Summary

The Overdue Schedules Summary report summarizes the details of overdue schedules.

11.15.2 Contents of the Report

Apart from the header the following information is provided:

Body of the Report

Field Description
Product Code This is the product for which the report is generated
Status This is the current status of the contract for which details are being reported
Due Date This is the due date
Component This is the component of the loan against which the payment due is being reported. If more than one component falls due on the same day they will be reported one by one
Component Cur­rency This is the component currency. If not specified at the Component level, the loan currency is displayed
Cumulative Over­due Amount This is the total amount that is overdue for the component(s) as of the date of report generation

 

11.16 Periodic Rate Revision

This section contains the following topics:

11.16.1 Generating Periodic Rate Revision

The Periodic Rate Revision Report lists the details of a customer, the rate revision date and the effective rate.

The report will be generated for a specific combination of Revision Date, Customer, Account Number and Rate Code.

You can invoke this report screen by typing ‘CLRPREVN’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.16.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Product Category

You can generate a product-wise report. Select the Product Code from the option list which contains all valid products under the category you have selected.

Product Code

Select the Product Code from the option list which contains all valid products under the category you have selected.

Currency

Under specific Product(s), you can choose to generate reports in a specific currency(s).

Customer

You can generate this report for specific customer(s).

Maturity Type

You can generate the report only for a particular Maturity Type. The Maturity type of a loan can be

You can generate the report either for fixed maturity loan or call loans.

From Date (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date greater than the date you enter here.

To Date (Value Date)

Enter the Value Date of the contract. The system will generate a report for the contracts that have a Value Date lesser than the date you enter here.

From Date (Revision Date)

Enter the Revision Date from which the report has to be generated.

To Date (Revision Date)

Enter the Revision Date upto which the report has to be generated.

11.16.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Revision Date The rate revision date
Rate Code The rate code
Customer This is the CIF ID of the customer involved in the loan
Customer Name The name of the customer
Account Number This is the account number of the loan account being reported
Currency This is the component currency. If not specified at the Component level, the loan currency is displayed
Amount Financed The total amount financed
Component The component that has undergone a rate revision
Formula Name The name of the formula
Component Cur­rency The currency of the component
User Defined Ele­ment ID The User Defined Element
Resolved Rate The rate applicable

 

11.17 Loan Payoff Calculator Report (Account)

This section contains the following topics:

11.17.1 Generating Loan Payoff Calculator Report (Account)

The Loan Payoff Calculator Report lists the payoff values for the loan account and component-wise charges and fees details for the loan.

You can invoke this report screen by typing ‘CLRPAYAC’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.17.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Account No

Select the loan account number for which you need to generate the report.

Payoff Date

Enter the Payoff date up to which the report has to be generated.

11.17.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Principal (Amount Due) The principal amount that is due
Interest (Amount Due) The interest amount that is due
Net Payoff The net payoff amount for the loan
Prepayment Fees The prepayment fee associated with the loan
Component-wise Fees/Charges Details
Component Name Name of the component
Accessed & Unpaid(Fees/Charges) The fee or charge that is accessed and unpaid
Scheduled(Fees/Charges) The fee or charge that is scheduled
Total The total fees/charges
Component-wise Per Diem /Projected Interest Due
Component Name The name of the component
Per-diem Per-diem
Projected Due The projected interest due
Total The total fees/charges

11.18 Loan Payoff Calculator Report (Line)

This section contains the following topics:

11.18.1 Generating Loan Payoff Calculator Report (Line)

The Loan Payoff Calculator Report lists the payoff values for the line Id and component-wise charges and fees details for the loan.

You can invoke this report screen by typing ‘CLRPAYLM’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.18.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Line Code

Select the line Id for which you need to generate report.

Payoff Date

Enter the Payoff date up to which the report has to be generated.

11.18.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Principal (Amount Due) The principal amount that is due
Interest (Amount Due) The interest amount that is due
Net Payoff The net payoff amount for the loan
Prepayment Fees The prepayment fee associated with the loan
Unused Line Fee This is the unused line fee
Currency The currency in which the amount is displayed
Component-wise Fees/Charges Details
Component Name Name of the component
Currency(Fees/Charges) The currency in which the fee and charge amounts are displayed
Accessed & Unpaid(Fees/Charges) The fee or charge that is accessed and unpaid
Scheduled(Fees/Charges) The fee or charge that is scheduled
Total The total fees/charges
Component-wise Per Diem /Projected Interest Due
Component Name The name of the component
Per-diem Per-diem
Projected Due The projected interest due
Currency The currency in which the amount is displayed
Total The total fees/charges

 

11.19 Loan History Report

This section contains the following topics:

11.19.1 Generating Loan History Report

The Loan History Report lists the event-wise history details for a loan account. It shows all event details for different operations on account.

You can invoke this report screen by typing ‘CLRPLNHT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.19.2 Selection Options

If you generate the report manually (from the reports Browser) you can specify preferences for the generation of the report. The contents of the report are determined by the preferences that you specify.

You can specify the following preferences for the report:

Account Number

Select the loan account number for which you need to generate the history report.

11.19.3 Contents of the Report

The report options that you selected while generating this report are printed at the beginning of the report.

Body of the Report

Field Description
Account Number The loan account number
Account Currency The currency of the loan account
Customer Id The customer Id of the borrower
Customer Name The name of the borrowing customer
Component Name The name of the component associated with the loan
Item Value The value associated with the component
Event The name of the event during the loan cycle
Event Description Description for the event
Event Date The date on which the event occurred
Event Sequence Number The sequence number of the event

 

11.20 Automatic Loan Payment Exception

This section contains the following topics:

11.20.1 Generating Automatic Loan Payment Exception

The Automatic Loan Payment Exception report lists the details of the loan payment exceptions.

You can invoke this report screen by typing ‘CLRPALPE’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.20.2 Contents of the Report

The details of the loan payment exceptions like the customer number, amount due, settlement account etc. are displayed in the report.

Body of the Report

Field Description
Customer Loan Number The CIF ID of the customer involved in the loan
Customer Name The name of the customer
Dept Code The code of the department involved in the loan
Due Date The date on which the loan payment was due
Amount Due The repayment amount that is due
Settlement Account The settlement account associated with the loan
Account Type The type of the settlement account
Auto Liquidation Retries The number of retries for auto liquidation
Reason The reason for loan payment exception

 

11.21 Loan Past Due Notice

This section contains the following topics:

11.21.1 Generating Loan Past Due Notice

The Loan Past Due Notice report displays all notices for Past Due loans.

You can invoke this report screen by typing ‘CLRPLNPD’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.21.2 Contents of the Report

The details of all notices for ‘Past Due’ loans are displayed in the report.

Body of the Report

Field Description
Account Number The loan account number
Payment Due Date The due date for payment
Amount of Payment The amount that is due for payment
Currency The currency in which the amount is displayed
Notice Message The message text that is sent to the customer
Customer Address The address of the borrowing customer
Principal The principal amount
Interest The interest amount
Total Past Due Total amount that is past due for payment

 

11.22 Past Due and Non-performing Loan Month End Pro­jections Report

This section contains the following topics:

11.22.1 Generating Past Due and Non-performing Loan Month End Projections Report

The Past Due and Nonperforming Loan Month End Projections report lists the monthly projection details of past due and non-performing loans.

You can invoke this report screen by typing ‘CLRPDLIN’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.22.2 Contents of the Report

The details of the past due and non-performing loans are displayed in the report.

Body of the Report

Field Description
Past Due Category The past due category of the loan
Product Code The name of the loan product
Account Number The account number associated with the loan
Borrower The borrower of the loan
Credit Risk Rating The credit risk rating associated with the loan
Collateral Code The collateral code associated with the loan
Net Balance The principal outstanding
Interest Past Due The interest amount that is past due
No of Days Currently
Past Due		 The number of days the loan is currently past due
No of Days Projected
Past Due		 The projected number of days the loan remains past due
Last Interest Payment
Date		 The date when the last interest payment was done
Maturity Date The maturity date of the loan
Maturity Status The maturity status of the loan
Department Name The name of the department which initiated the loan
Niche Code The niche code associated with the loan

 

11.23 Ledger Verification Report

This section contains the following topics:

11.23.1 Generating Ledger Verification Report

The Ledger Verification Report lists the details of the ledger balances.

You can invoke this report screen by typing ‘CLRPLGBL’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

 

Specify the report print options and click ‘OK’ button to generate the report.

11.23.2 Contents of the Report

The details of the ledger balances like the GL account title, transaction amount, ledger balance etc. are displayed in this report.

Body of the Report

Field Description
Account The customer account number
Branch The branch where the account is located
Product Type The type of product
Product The product code
Description The description of the product
Amount The transaction amount
GL Account Title The title of the GL account
Balance The current GL balance
Difference The difference in GL balance

 

11.24 New Loans Report

This section contains the following topics:

11.24.1 Generating New Loans Report

The New Loans Report lists the details of all the new loans that have been booked.

You can invoke this report screen by typing ‘CLRPNWLN’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.24.2 Contents of the Report

The details of the new loans are displayed in this report.

Body of the Report

Field Description
Account Number The customer account number
Account Status The branch where the account is located
Product Code The code of the retail lending product
Product Category The product category of the retail lending product
Customer The identification of the borrowing customer
Customer Name The name of the borrowing customer
Account Currency The currency associated with the loan account
Financed Amount The total amount that has been financed
Original Start Date The original start date of the loan
Booking Date The booking date of the loan
Value Date The value date of the loan
Maturity Type The type of maturity
Maturity Date The date of loan maturity
Tenor The tenor of the loan
Auth Status The authorization status of the loan
User Defined Status The user defined status of the loan account
Liquidation Mode The mode of liquidating the loan
Rollover Mode The rollover mode of the loan
Rate Type The type of rate
Rate % The percentage of rate

 

11.25 Loan Rollover Monitoring Report

This section contains the following topics:

11.25.1 Generating Loan Rollover Monitoring Report

The Loan Rollover Monitoring Report lists the rollover details of all the loans.

You can invoke this report screen by typing ‘CLRPRLVR’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.25.2 Contents of the Report

The details of the loans including the type of rollover and date are displayed in this report.

Body of the Report

Field Description
Branch The customer account number
Customer The branch where the account is located
Loan Number The number of the loan
Currency The currency associated with the loan
Principal Amount The principal amount associated with the loan
Interest at Maturity The interest amount at loan maturity
Total Due Total amount that is due
Product The product code of the retail lending product
Product Description The product description
Rollover Type The type of rollover, whether manual or automatic
Value Date The value date of the loan
Maturity Date The maturity date of the loan

 

11.26 Loan Register/Trial Balance Report

This section contains the following topics:

11.26.1 Generating Loan Register/Trial Balance Report

The Loan Register/Trial Balance Report lists the loan register / trial balance details.

You can invoke this report screen by typing ‘CLRPTRBL’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.26.2 Contents of the Report

The loan register / trial balance details are displayed in this report.

Body of the Report

Field Description
Account Number The unique identification number of the account
Short Name The short name of the customer
Codes The product code and the type of the product
Product Category The category to which the product belongs
Interest Rate The interest rate associated with the loan
Face Amount The face amount associated with the loan
Net Payoff The net payoff amount for the loan
Perdiem The amount financed
Available Amount The amount available
Revolving Amount The revolving amount
Payment Amount Total amount (principal + interest) that has been repaid
Interest Balance The balance interest payment amount
Interest Payment The interest amount that has been repaid
Late Fee Due The total outstanding penalty
Principal Balance The balance principal amount associated with the loan
Principal Payment The principal amount that has been repaid
Maturity Balance The maturity balance
Note Date The date of the note
Payment Due Date The due date for loan repayment
Maturity The maturity date of the loan

 

11.27 Loan Rollover Notice

This section contains the following topics:

11.27.1 Generating Loan Rollover Notice

The Loan Past Due Notice report displays the notice details that are sent to customers in case of loan rollovers.

You can invoke this report screen by typing ‘CLRPRLNT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

11.27.2 Contents of the Report

The details of all notices related to loan rollovers are displayed in the report.

Body of the Report

Field Description
Date of Notice The date on which the notice was generated
Facility The facility details of the loan
Loan Reference The loan reference number
Principal Amount The principal amount associated with the loan
Interest at Maturity The interest amount due at maturity
Maturity Date The date of maturity of the loan
Notice Message The message text that is sent to the customer

 

11.28 Disbursements Made Today Report

This section contains the following topics:

11.28.1 Generating Disbursements Made Today Report

The life of the loan account starts when the loan is disbursed into an account. The loan is disbursed after the account is created. The first disbursement for an account is disbursed before the number of days maintained at the product level. You can generate ‘Disbursements made Today Report’ at EOD with details of the disbursements made for the current day which includes first, progressive, and final disbursements. This report also provides the total number of disbursements for the day.

You can invoke ‘Disbursements made Today Report’ screen by typing ‘CLRDISTD’ 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.

Disbursement

Select type of disbursement for which you need to generate the report, from the adjoining drop-down list. This list displays the following values:

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

11.28.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Disbursements made Today 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:

Sr. No. Field Name Field Description
1 Disbursement Type The type of disbursement
2 Acc No Indicates Loan Account Number
3 Amt Disbursed Indicates Actual amount disbursed today
4 Gross Loan Amount Dis­bursed Indicates Total loan amount sanctioned
5 Transaction Currency Indicates Currency
6 Net Amount Disbursed Indicates Amount Disbursed till date
7 Amount Debited Indicates Debited from other account which also increases the Principle of Loan
8 Amount Deducted Indicates The amount deducted from Disbursed amount (any charge)
9 Amount Billed This indicates the amount billed
10 Pay Mode Indicates Settlement mode
11 Cheque Number Indicates If the settlement mode is cheque
12 Formula Type This indicates the schedule type
13 Branch Indicates Branch code
14 Name Indicates Customer name
15 Term (Months) Indicates loan term
16 Interest Rate Indicates Loan interest rate
17 User Id Indicates Maker id
18 Supervisor Id Indicates Checker id
19 Product code Indicates Product code
20 Product Description Indicates Product description
21 Total number of dis­bursements for the day Indicates count

11.29 Insurance Policy Expired Today Report

This section contains the following topics:

11.29.1 Generating Insurance Policy Expired Today Report

Loan limits are sanctioned based on the collateral values offered, subject to the margins. Various collaterals like insurance policies are offered by the customers and the details are maintained in the system. You can generate ‘Insurance Policy Expired Today Report’ at EOD with the details of the matured insurance policies expired on the current day.

You can invoke ‘Insurance Policy Expired Today Report’ screen by typing ‘STRINEXP’ 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

Specify a valid number of days within which the Insurance policy expires.

Report Type

You can generate online report or EOD report using the following options:

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

11.29.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Insurance Policy Expired 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
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
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
Insurance Code Indicates Insurance Code
Insurance Name Indicates Insurance Name
Insurance Plan Indicates Insurance Plan/remarks
Date Maturity Indicates End date of the Insurance
Days to Expire Indicates No of days to expire
Collateral Id Indicates Collateral id of the Insurance
Collateral Name Indicates Collateral Description
Insurance Premium Indicates Insurance Premium Amount
Hair Cut Percentage Indicates Hair Cut Percentage
Margin Indicates Unutilised amount
Amount Covering Billing Account Indicates Insurance Amount

Note

11.30 Loan Settlement Notice Report

This section contains the following topics:

11.30.1 Generating Loan Settlement Notice Report

You can generate a report, which contains the details of loans that have received a notice for settlement, using ‘Loan Settlement Notice’ screen. To invoke this screen, type ‘CLRPSLNT’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.

Specify the following details:

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:

Account Number

You can generate this report for all the accounts or a single account alone. You can indicate the account number for which the report is being generated using the following options:

From Date

Specify the From Date. The report will contain the details of loan settlement notices processed from this date.

To Date

Specify the To Date. The report will contain the details of loan settlement notices processed till this date.

Report Format

Specify the format in which the report should be generated. The drop-down list displays the following options:

Choose the appropriate one.

Report Output

Specify the report output form required. The drop-down list displays the following options:

Choose the appropriate one.

PrinterAt

Specify the location at which the printer is available. The printer can be attached to one of the following:

Choose the appropriate one.

Printer

Specify the printer using which the report should be printed. The option list displays all valid printers maintained in the system. Choose the appropriate one.

Once you have captured the details, click OK. The system generates the report with a break-up of the group balances with Individual member account details.

Once you have captured the details, click OK. The system generates the report with the details of the accounts and loan settlement notices.

11.30.2 Contents of the Report

The report contains the following details:

Header

Field Name FCR Field name
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

FCC Report Field Name FCR Field Name
Account number Indicates the Account Number
Customer Name Indicates the Name of the Customer
Maturity Date Indicates the date of Maturity
Expected Date of Closure Indicates the Expected date of closure
Notice Date Indicates the Notice date
Total Arrears Indicates the Total Arrears
Total Outstanding Indicates the Total outstanding amount
Principal Balance Principal Balance
Product Code Product code
Transaction Date Indicates the date of transaction
Currency Currency

11.31 Taken Over Assets Reports

This section contains the following topics:

11.31.1 Generating Taken Over Assets Reports

You can generate Taken Over Assets report to list the taken over asset details. You can invoke ‘List of Taken Over Assets Reports’ screen by typing ‘CLRPTOAS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Specify the following here:

Branch Code

Select the transaction branch of the float extension from the adjoining option list.

Liability ID

Select the Liability Id from the adjoining option list.

Collateral Code

Select the collateral code from the adjopining option list.

From Date

Indicate the date from which transactions are extended. The system defaults current date. From Date should be lesser than or equal to ‘To Date’.

To Date

Indicate the date to which the transactions are extended. The system defaults current date. To Date should be lesser than or greater to ‘From Date’

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the report output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

PrinterAt

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

11.31.2 Contents of the Report

The contents of the report are discussed under the following heads:

Header

The header carries the Branch Code, Liability Id, Collateral Code, From Date and To Date.

Body of the Report

Field Description
Branch Code Branch Code of the takeover process
Liab ID Liability Name that owns the collateral
Collateral Code Code of the collateral which was taken over
Collateral Description The description of the selected collateral
Date of Take Over Date of take over processing
Take Over reference Reference Number of the process
Collateral Value Value of the collateral taken over
Collateral Currency The currency of the collateral
Loan Account Number The CL Contract Number settled
Amount Settled Amount that has been settled against the above contract (Currency-Amount)

 

11.32 Loans with CASA Benefit Report

This section contains the following topics:

11.32.1 Generating Loans with CASA Benefit Report

The ‘Loan with CASA Benefit Report’ will provide you the list of loans with CASA benefits. You can invoke the screen by typing the code ‘CLRSAVIN’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Product Code

Specify the product for which details are required to be generated.

From Date

Specify the maturity date from which details should be made available in the report. The system will include all contracts whose date is equal to or greater than this date.

To Date

Specify the maturity date till which details should be made available in the report. The system will include all contracts whose date is equal to or lesser than this date.

Report Format

Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Report Output

Select the report output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:

Printer At

Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:

Printer

Select printer using which you wish to print the report from the adjoining option list.

11.32.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the ‘Finances with CASA Benefit Report’ is as follows:

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

The following details are displayed as body of the generated report:

Field Name Field Description
Customer No Customer number
Customer Name This is the name of the customer
Account No Financing account number
Amount Financed Amount financed with Currency
Currency The currency in which the amount is displayed
Value Date Value date of the contract
Maturity Date Maturity date of the contract
Component Name Name of the savings component
CASA Linked The CASA account linked with the Finance account through savings component

11.33 Customer Loan Agreement

This section contains the following topics:

11.33.1 Generating Customer Loan Agreement

You can invoke the ‘Customer Loan Agreement’ screen by typing the code ‘CLRPADVC’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Account Number

Specify the account number from the adjoining option list.

11.33.2 Contents of the Report

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

The following details are displayed as body of the generated report:

Field Name Field Description
Account Number Indicates the account number
Currency Indicates the currency
Amount Disbursed Indicates the amount disbursed
Booking Date Indicates the booking date
Revolving Amount Indicates the revolving amount
Loan Product Indicates the loan product
Customer ID Indicates the customer ID
Value Date Value date of the contract
Interest Rate Indicates the rate of interest
Product Category Indicates the product category
Amount Financed Indicates the financed amount
Maturity Date Maturity date of the contract
Tenor Indicates the tenor

11.34 Loan Rejection Report

This section contains the following topics:

11.34.1 Generating Loan Rejection Report

You can invoke the ‘Loan Rejection Report’ screen by typing the code ‘CLRPRJCN’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Account Number

Specify the account number from the adjoining option list.

11.34.2 Contents of the Report

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

The following details are displayed as body of the generated report:

Field Name Field Description
Account Number Indicates the account number
Currency Indicates the currency
Amount Financed Indicates the financed amount
Value Date Indicates the value date
Maturity Date Maturity date of the contract
Credit Score Indicates the credit score

11.35 Loan Branch Transfer Report

This section contains the following topics:

11.35.1 Generating Loan Branch Transfer Report

You can invoke the ‘Loan Branch Transfer Report’ screen by typing the code ‘CLRTRBRN’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.

Processed Date

Specify the processed date from the adjoining calendar list.

Transfer Date

Specify the date of transfer from the adjoining calendar list.

Transfer Type

Select the type of transfer from the adjoining drop down list.

Transfer Status

Select the status of transfer from the adjoining drop down list.

Transfer ID

Specify the transfer ID from the adjoining option list.

Account Number

Specify the account number from the adjoining option list.

Customer ID

Specify the customer ID from the adjoining option list.

Current Branch

Specify the current branch from the adjoining option list.

Target Branch

Specify the target branch from the adjoining option list.

Product Code

Specify the product code from the adjoining option list

11.35.2 Contents of the Report

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

The following details are displayed as body of the generated report:

Field Name Field Description
Account Number Indicates the account number
Current Branch Indicates the current branch
Target Branch Indicates the target branch
Transfer ID Indicates the transfer ID
Transfer Status Indicates the status of transfer
Customer ID Indicates the customer ID
Customer Name Indicates the name of the customer
Product Code Indicates the product code
Transfer Date Indicates the transfer date
Transfer Type Indicates the transfer type
Processed Date Indicates the processed date

11.36 Ad-Hoc Combined Statement

This section contains the following topics:

11.36.1 Generating Ad-Hoc Combined Statement

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.

Based on Date Range

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.

Processing Ad-Hoc Combined Statement

You can process the ad-hoc combined statement by doing the following:

11.36.2 Charge Details

You can view, waive or modify the online charges computed for the generation of the combined statement through the Charges screen. You can invoke this screen by typing ‘CSCONLEVT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button or click ‘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:

11.37 Combined Statement Generation Report

This section contains the following topics:

11.37.1 Generating Combined Statement Generation Report

You can generate Combined Statement Report using ‘Combined Statement Report’ screen. You can invoke this screen by typing ‘RPRCNDLG’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Customer No

The system displays the customer number.

Statement ID

The system displays the statement ID.

11.37.2 Contents of the Report

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:

For further details on combined statement refer section ‘Maintaining Combined Statements’ section in ‘Generating Account Statements’ chapter of ‘CASA’ user manual.