39. Reports

This chapter contains the following sections:

39.1 Deleted Transaction Listing Report

This section contains the following topics:

39.1.1 Generating List of Deleted Transactions Report

This report lists out the deleted transaction details pertaining to each product under each module pertaining to every user. You can invoke this screen by typing ‘ACRDLTXN’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

Specify the following details.

Module

Indicate whether the reports should be generated for a single module or for all modules.

If you choose ‘Single’, you need to specify the module for which the report needs to be generated. The option list provided displays all valid module codes maintained in the system. You can select the appropriate one.

Transactions

Indicate the type of transactions that should be covered in the report. The following options are available:

Products

Indicate whether the reports should be generated for a single product or for all products.

If you choose ‘Single’, you need to specify the product code for which the report needs to be generated. The option list provided displays all valid product codes maintained in the system. You can select the appropriate one.

User

Indicate whether the reports should be generated for a transactions entered by all users or a single user.

If you choose ‘Single’, you need to specify the user ID based on which the report needs to be generated. The option list provided displays all valid user IDs maintained in the system. You can select the appropriate one.

From

Specify the batch from which the transactions need to be considered for report generation.

To

Specify the batch until which transactions need to be considered for report generation.

Print Copies

Check this box to indicate that the report needs to be printed.

Click ‘OK’ to generate the report.

39.1.2 Contents of Report

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

Header

The Header carries the title of the report, information on the branch code, branch date, the ID of the user who generated the report, the date and time at which it was generated, the modules covered in the report, the product codes covered in the report, batch information, transactions covered in the report and printing preference.

Body of the Report

This report is sorted module-wise. For every module the following details are displayed.

The following transaction details are displayed.

Field Name

Field Description

Reference Number

This is the reference number of the deleted transaction

Account Branch

This is the branch where the account resides.

Account Number

This is the account number.

Currency

This is the currency of the transaction.

Debit/Credit

This indicates the nature of the transaction – debit or credit.

Transaction Code

This is the transaction code.

Status

This is the status of the transaction

Value Date

Indicates the value date of the transaction

Account description

This is the account description.

Fcy Amount

This is the transaction amount in foreign currency.

Transaction Descrip­tion

This is the description of the transaction code

Exchange Rate

This is the exchange rate

LCY Amount

This is the Amount in Local currency

Narrative

This is the narrative text associated with the transaction.

Instrument Number

This is the instrument number linked to the transaction.

Auth ID

This is the authorization ID

Total Debits

Total amount debited under the respective user, product and module

Total Credits

Total amount credited under the respective user, product and module

User ID

This is the user ID of the user who entered the transac­tion.

Grand Total Debits

This is the grand total amount of all the debit transaction grouped by transaction code and user.

Grand Total Credits

This is the grand total amount of all the credit transaction grouped by transaction code and user.

39.2 Accounting Journal Report

This section contains the following topics:

39.2.1 Generating Accounting Journal Report

This report gives details of every journal entry transaction. You can invoke this screen by typing ‘ACRJRNAL’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

Specify the following details:

Module

Indicate whether the reports should be generated for a single module or for all modules.

If you choose ‘Single’, you need to specify the module for which the report needs to be generated. The option list provided displays all valid module codes maintained in the system. You can select the appropriate one.

Transactions

Indicate the type of transactions that should be covered in the report. The following options are available:

Products

Indicate whether the reports should be generated for a single product or for all products.

If you choose ‘Single’, you need to specify the product code for which the report needs to be generated. The option list provided displays all valid product codes maintained in the system. You can select the appropriate one.

User

Indicate whether the reports should be generated for a transactions entered by all users or a single user.

If you choose ‘Single’, you need to specify the user ID based on which the report needs to be generated. The option list provided displays all valid user IDs maintained in the system. You can select the appropriate one.

From

Specify the batch from which the transactions need to be considered for report generation.

To

Specify the batch until which transactions need to be considered for report generation.

Print Copies

Check this box to indicate that the report needs to be printed.

Position Entries

Check this box to indicate that the report needs to cover position accounting entries.

Report Date

Specify the date as on which the report needs to be generated.

Click ‘OK’ to generate the report.

39.2.2 Contents of Report

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

Header

The Header carries the title of the report, information on the branch code, branch date, the ID of the user who generated the report, the date and time at which it was generated, the modules covered in the report, the product codes covered in the report, batch information, transactions covered in the report and printing preference.

Body of the report

The report is sorted by modules. Under every module, it lists out product-wise transaction details.

The following transaction details are displayed.

Field Name

Field Description

Product

This is the product code of the transaction.

User Id

This is the user ID of the user who entered the transaction.

Reference No

This is the transaction reference number.

Account Branch

This is the account branch.

Account Number

This is the account number.

Currency

This is the currency of the transaction.

Dr/Cr

This is the nature of the transaction – either debit or credit.

Transaction Code

This is the transaction code while posting the journal entry.

Module

This is the module code of the report

Description

This is the description of the transaction code.

Status

Status of the transaction.

Value Date

This is the value date of the transaction.

Account Descrip­tion

This is the description of the account.

Event

This is the event triggered on the transaction.

Fcy Amount

This is the transaction amount in a foreign currency

Exchange Rate

This is the exchange rate used if the transaction is in any other currency.

Lcy Amount

This is the transaction amount in local currency.

Auth ID

This is the user ID of the user who authorized the transaction.

Total Debits

Total amount debited under the respective user, product and module

Total Credits

Total amount credited under the respective user, product and module

Grand Total Deb­its

This is the grand total amount of all the debit transaction grouped by transaction code and user.

Grand Total Cred­its

This is the grand total amount of all the credit transaction grouped by transaction code and user.

39.3 Cash Flow Report

This section contains the following topic:

39.3.1 Generating Cash Flow Report

The ‘Cash flow report’ gives details of the cash flow by accounts or by account class. The report contains details of the Account Number or Account Class, and the list of Accounts or Account Classes. You can invoke this screen by typing ‘ACRPCASH’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

The screen is as shown below:

Specify the following details.

Report Name

Specify the name of the report. The option list provided displays all valid reports maintained in the system. You can select the appropriate one.

Report Type

Indicate whether the report should be a detailed report or a summary report.

Notice Contracts

Check this box to indicate that notice contracts should be covered in the report.

Call Contracts

Check this box to indicate that call contracts should be covered in the report.

Select Account Class/Account

Indicate whether the reports should be generated based on account class or account.

All/Specific Records

Indicate whether the reports should be generated for all records in an account class/account or for specific records.

Account Class

If you have indicated ‘Account Class’ as the basis for report generation, specify the account classes that should be considered. Click add icon to add rows. You can select a valid account class from the adjoining option list.

Account

If you have indicated ‘Account’ as the basis for report generation, specify the accounts that should be considered. Click add icon to add rows. You can select a valid account from the adjoining option list.

Click ‘OK’ to generate the report.

39.3.2 Contents of Report

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

Header

The Header carries the title of the report, information on the branch code, the ID of the user who generated the report, the module, page number and the date and time at which it was generated.

Body of the Report

The report is sorted on the currency of the cash flow.

Field Name

Field Description

Interval

Indicates the interval of cash flow

Amount In

This is the amount debited into the particular account for the particular period.

Account

This is the account number

Account Class

This indicates the account class

Amount Out

This is the amount credited from the account during the spec­ified period.

Net Flow

Indicates the net flow

Currency

Indicates the currency of the transaction

39.3.3 Cash Flow (Summary) Report

The Cash Flow summary report summarizes the details of cash flow for particular Accounts or Account Classes.

Header

The Header carries the title of the report, information on the branch code, the ID of the user who generated the report and the date and time at which it was generated.

Body of the Report

The report is sorted on the currency of the cash flow for different account classes and their accounts. The following details are displayed.

Field Name

Field Description

Amount In

This is the amount debited into the particular account for the specific period

Amount Out

This is the amount credited from the account during the specified period

Net Flow

This is the net amount available in the account for the specified period

39.4 Future Dated Account Balance Report

This section contains the following topics:

39.4.1 Generating Future Dated Contracts Report

This report gives balances of future dated transactions. You can invoke the screen by typing ‘ACRPFVBL’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

You can specify the following parameters:

Select Account Class/Account

Select account criteria for generating the report from the following options:

Report Preferences

Select report preference criteria for generating the report from the following options:

Account Class

Specify valid account classes for which you need to generate the report from the adjoining option list, if you have selected ‘Account Class’.

Account

Specify valid account classes for which you need to generate the report from the adjoining option list, if you have selected ‘Account’.

39.4.2 Contents of the Report

Header

The Header carries the title of the report, information on the branch code, branch date, the ID of the user who generated the report, the date and time at which it was generated and the modules covered in the report.

Body of the Report

The following details are displayed.

Field Name

Field Description

Date

This gives the date for which a future dated transaction is booked for the account.

Reference Num­ber

This is the reference number of the future dated transaction

Inflow

This is the inflow amount.

Outflow

This is the outflow amount.

Balance

This is the available balance.

Currency

This is the currency of the account

Customer

This is the name of the customer.

Account

This is the account number of the customer.

Account Class

This is the account class.

Opening

This is the opening balance of the account.

39.5 Current Rates Report

This section contains the following topics:

39.5.1 Generating Currency Rate Report

This report gives details on rates for currency pairs. You can invoke the screen by typing ‘CYRTCURR’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

Specify the following details.

Selection

Indicate whether the report should be generated for all currency pairs or for a given currency pair.

Currency 1

If you have chosen, ‘Selected Currency Pair’, then specify the first currency that forms a pair. The adjoining option list displays all valid currency codes maintained in the system. You can select the appropriate one.

Currency 2

If you have chosen, ‘Selected Currency Pair’, then specify the second currency that forms the pair. The adjoining option list displays all valid currency codes maintained in the system. You can select the appropriate one.

Click ‘OK’ to generate the report.

39.5.2 Contents of Report

Header

The Header carries the title of the report, information on the branch code, the ID of the user who generated the report, the date and time at which it was generated, the module covered in the report and reporting options.

Body of the report

The report is sorted by currency pairs. The following details are displayed.

Field Name

Field Description

Currency Pair

This gives the currency pairs for which rate report has been generated.

Quotation

This indicates the quotation type – either direct or indirect.

No. of Units

This indicates the number of units of one currency being quoted against the other.

Rate Type

This is the rate type.

Mid Rate

This is the mid rate used for conversion.

Buy Rate

This is the buy rate used for conversion.

Sale Rate

This is the sell rate used for conversion.

39.6 Rate History Report

This section contains the following topics:

39.6.1 Generating Currency Rate History Report

This report gives details on history of rates for currency pairs. You can invoke the screen by typing ‘CYRTHIST’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

39.6.2 Contents of the Report

Header

The Header carries the title of the report, information on the branch code, branch date, the ID of the user who generated the report, the date and time at which it was generated, the module covered in the report, reporting options, currency pair, from date and to date .

Body of the report

The report is sorted by currency pairs. The following details are displayed.

Field Name

Field Description

Currency Pair

This gives the currency pairs for which rate report has been gener­ated.

Quotation

This indicates the quotation type – either direct or indirect.

No of Units

This indicates the number of units of one currency being quoted against the other.

Rate Type

This is the rate type.

Date

The effective date of the rates applied.

Mid Rate

This is the mid rate used for conversion.

Buy Rate

This is the buy rate used for conversion.

Sale Rate

This is the sell rate used for conversion.

39.7 Customer Account Opening Confirmation Report

This section contains the following topics:

39.7.1 Generating Customer Account Opening Confirmation Report

You can generate a report for the customer, confirming that his / her account with the bank has been successfully opened. This report contains the following details:

You can generate the Customer Account Opening Confirmation report for one customer or all the customers at once, as of a specific date. To generate the report, invoke ‘Customer Account Opening Confirmation’ screen.

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

The screen is as shown below:

Customer Type

You can generate customer account opening confirmation report for one or all the customers. Indicate your choice here. If you select ‘Single Customer’, you have to specify the customer number in the space provided.

Customer Number

If you wish to generate a report specific to one customer, specify the customer number. The option list displays all valid customer numbers maintained in the system. Select the appropriate one.

Date

Specify the date as of which you want to generate the report.

Once you have set the preferences, click ‘OK’ button. The system displays the print option screen, where you can set your preferences as to viewing and printing the report.

39.7.2 Contents of the Report

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

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

Field Name

Field Description

Customer Name

Indicates the name of the customer

Customer Number

Indicates the customer number

First Nominee

Indicates the name of the first nominee

Second Nominee

Indicates the name of the second nominee

Address

Indicates the contact address for the customer whose cheque has been rejected.

Client Account Number

Indicates the Account Number of the client

39.8 Account Closing Confirmation Report

This section contains the following topics:

39.8.1 Generating Account Closing Confirmation Report

This report gives details about closing confirmation of an account in ‘Account Closing Confirmation’ screen. To invoke this screen, type ‘CSRPACCC’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

The screen is as shown below:

39.8.2 Contents of Report

The contents of account closing confirmation have been discussed under the following heads:

Header

The Header carries the title of the report, information on the branch code, the ID of the user who generated the report, the date and time at which it was generated, the modules covered in the report and customer number of the account holder for whom the report is being generated.

Body

You can find the following details in the body of the report:

Field Name

Field Description

Client Number

The account number of the client

39.9 Activity Journal Report

This section contains the following topics:

39.9.1 Generating Activity Journal Report

This report gives details about activity journal in ‘Core Activity Journal’ screen. To invoke this screen, type ‘CSRPACTJ’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

From Date

Specify the start date of the report date range. The system will include the details of the record from this date.

To Date

Specify the end date of the report date range. The system will include the details of the record until this date.

Report For

Specify whether you want to generate the report for all the modules or selected modules alone. If you select ‘Selected Modules’, you need to specify the modules below.

Module

If you need to generate the report for selected modules, you need to indicate the modules here. Use the add button to add more modules.

39.9.2 Contents of 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, the ID of the user who generated the report, the date and time at which it was generated and the modules covered in the report.

Body

You can find the following details in the body of the report:

Field Name

Field Description

Module

The module for which the report is being generated

Product Type

The type of product for which the report is being generated

Contract Ref No

The reference number of the contract being reported

Counter Party No

The CIF ID of the customer involved

Counter Party Name

This is the name of the customer involved

User Def. Status

The status if the user defined elements

Event Date

The date on which the event took place

Seq. No

The sequence number of the event

Event Description

The description of the event

Contract Status

The status of the contract i.e., active, closed etc.

Maker ID

The identification number of the maker

Checker ID

the identification number of the checker

Reversed Seq. No.

The reversed sequence number

39.10 Core Exception Report

This section contains the following topics:

39.10.1 Generating Core Exception Report

This report gives details about core exception in ‘Core Exception’ screen. To invoke this screen, type ‘CSRPEXCP’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

The screen is as shown below:

From Date

Specify the start date of the report date range. The system will include the details of the record from this date.

To Date

Specify the end date of the report date range. The system will include the details of the record until this date.

Report For

Specify whether you want to generate the report for all the modules or selected modules alone. If you select ‘Selected Modules’, you need to specify the modules below.

Selected List

If you need to generate the report for selected modules, you need to indicate the modules here. Use the add button to add more modules.

39.10.2 Contents of 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, the branch date, the ID of the user who generated the report, the date and time at which it was generated and the modules covered in the report.

Body

You can find the following details in the body of the report:

Field Name

Field Description

Module

The module for which the report is being generated

Contract Ref No

The reference number of the contract being reported

Counter Party

The name of the counter party

Counter Party Name

The name of the counter party involved

Event Description

The description of the event

Exception

The description about the exception

39.11 Uncollected Funds Report

This section contains the following topics:

39.11.1 Generating Uncollected Funds Report

This report provides details of uncollected funds based on release date of the fund'. You can invoke this screen by typing 'ACRUNCOL' in the field at the top right corner of the application tool bar and clicking the adjoining arrow button.

Specify the following details.

Accounts

Select the account for which the report is to be generated. The options are:

Date option

Select the date for which report has to be generated:

From Date

Specify the From date.

To Date

Specify the To date.

39.11.2 Contents of Report

Header

The Header carries the title of the Report, information on the branch code, the branch date, the user ID, the module name, the date and time at which the report was generated and the page number of the report.

Body of the report

The details of the uncollected funds that would be displayed in the report are as follows:

Field Name

Field Description

Account

This is the account for which transaction details is being reported

Available Date

This indicates the available date

Transaction Ref­erence

This is the reference number of the transaction for which account has uncollected balance

Amount

This is the uncollected amount in the account

Total Amount

This is the total uncollected amount in the account

39.12 Account Revaluation Report

This section contains the following topics:

39.12.1 Generating Account Revaluation Report

This report gives details of the memo revaluation funds. You can invoke this screen by typing ‘ACRREVAL’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

Memo or Normal

Specify the type of account revaluation report.

39.12.2 Contents of Report

Header

The Header carries the title of the Report, information on the branch code, the branch date, the user ID, the module name, the date and time at which the report was generated and the page number of the report.

Body of the report

The details of the uncollected funds that would be displayed in the report are as follows:

Field Name

Field Description

Currency

This is the currency for which transaction details is being reported

Revaluation Rate

This is the revaluation rate

Account

This is the account for which transaction details is being reported

Description

This is the description provided

Account Revalued

This is the revalued account

Account Balance

This indicated the account balance

LCY Equivalent (before revaluation)

This indicates the amount equivalent to local currency before revaluation

LCY Equivalent (after revaluation)

This indicates the amount equivalent to local currency after revaluation

Profit/ Loss

This is the profit or loss incurred

Profit/ Loss Amount

This is the profit or loss amount

P&L Account

This is the profit or loss account

Currency

This is the currency for which transaction details is being reported

Rate

This is the revaluation rate

Category

This is the GL category

39.13 Accounts Movement Report

This section contains the following topics:

39.13.1 Generating Accounts Movement Report

This report gives details of the movement of the accounts for that particular day. You can invoke this screen by typing ‘ACRPMOVE’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

From Date

Specify the From Date from the option list.

To Date

Specify the To Date from the option list.

Account Number

Specify the account number from the option list.

Value Dated

Select if the report is value dated.

Booking Dated

Select if the report is booking dated.

Currency

Specify the currency from the option list.

Account Selection

Specify the type of account selection.

39.13.2 Contents of Report

Header

The Header carries the title of the Report, information on the branch code, the branch date, the user ID, the module name, the date and time at which the report was generated and the page number of the report.

Body of the report

The details of the uncollected funds that would be displayed in the report are as follows:

Field Name

Field Description

Account Number

This is the account number

Account Description

This is the brief description for the account

Account Currency

This is the currency of the account

Opening Balance

This is the opening balance of the account

FCY Amount

This is the opening balance of account in FCY

LCY Amount

This is the opening balance of account in LCY

Transaction Date

This is the transaction date

Transaction Description

This is a brief description of the transaction

Transaction Reference Num­ber

This is the reference number of the transaction posted to account

Value Date

This is the value date of transaction

FCY Amount

This is the amount of transaction in Foreign Cur­rency

Rate

This is the exchange rate for FCY and LCY

LCY Amount

This is the amount of transaction in Local Currency

Current Balance

This is the current balance in the account

39.14 Customer Details Report

This section contains the following topics:

39.14.1 Generating Customer Details Report

This report gives details of the customer and you can generate this report using the ‘Customer Details’ screen.

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

39.14.2 Contents of 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 branch, information on the branch date, the user ID, the module name, the date and time at which the report was generated and the page number of the report.

Body of the report

The details of the customer information details that would be displayed in the report are as follows

:

Field Name

Description

Customer Information

Customer

Customer Identification Number of the customer

Customer Name

Customer name

Address lines

Displays the address of the customer.

Country

The country the customer belongs to.

Nationality

The nationality of the customer.

Type

Type of the customer (individual or Corporate or Bank).

Unique ID Name

Displays the customer’s unique id name.

Unique ID Value

Displays the customer’s unique id value.

Creation Date

Displays the date of customer’s number creation.

Input By

The Login ID of the user that created the customer record.

Input Date and Time

The date the customer record was created.

Auth By

The Login ID of the user that has authorized the record.

Auth Date and Time

The date of the authorization.

Mod Number

Displays the number of times the record was modified.

Auth Stat

Displays the current status of the customer record.

Record

Displays the record status.

Exposure Country

Displays the exposure country details.

Frozen

Displays the frozen status of the customer’s account.

Local Branch

Displays the customer’s local branch details.

Whereabouts Unknown

Gives the customer’s details regarding the wherea­bouts.

Deceased

Indicates whether the customer is fit or deceased.

Short Name

Customer’s abbreviated name.

Liability

This is the customer Liability ID number for which credit facility granted to the customer.

Language

Language.

Category

Category of the customer of the bank.

 Professional Details

Designation

Indicates Designation

Employer

Indicates Employer

Status

Indicates Status

Tenure

Indicates Tenure

Address

Indicates Address

Email

Indicates Email

Fax

Indicates Fax

Phone

Indicates Phone

Telex

Indicates Telex

Home Value

Indicates Home Value

Insurance

Indicates Insurance

Loans

Indicates Loans

Expenses

Indicates Expenses

Income

Indicates Income

Previous Designation

Indicates Previous Designation

Previous Employer

Indicates Previous Employer

Rent

Indicates Rent

Ret Age

Indicates Ret Age

Credit Cards

Indicates Credit Cards

IE Currency

Indicates IE Currency

Salary

Indicates Salary

Corporate Details

National Id

Indicates National Id

Name

Indicates Name

Currency Of Amounts

Indicates Currency Of Amounts

Incorporation Country

Indicates Incorporation Country

Incorporation Date

Indicates Incorporation Date

Net worth

Indicates Net worth

Capital

Indicates Capital

Registered Address

Indicates Registered Address

Address 2

Indicates Address 2

Address 3

Indicates Address 3

Country

Indicates Country

Business

Indicates Business

Director Name

Indicates Director Name

 Personal Details

Prefix

Indicates Prefix

First Named

Indicates First Named

Middle Name

Indicates Middle Name

Last Name

Indicates Last Name

Date Of Birth

Indicates Date Of Birth

Sex

Indicates Sex

Domicile

Indicates Domicile

Line 2

Indicates Line 2

Line 3

Indicates Line 3

Domicile Cntry

Indicates Domicile Cntry

Minor

Indicates Minor

Legal Guard.

Indicates Legal Guard.

Passport Number

Indicates Passport Number

Issue Date

Indicates Issue Date

Expiry Date

Indicates Expiry Date

Permanent Address

Indicates Permanent Address

Address

Indicates Address

Country

Indicates Country

National Id

Indicates National Id

Phone

Indicates Phone

Telex

Indicates Telex

Email

Indicates Email

Fax

Indicates Fax

Domestic Details

Indicates Domestic Details

Accommodation

Indicates Accommodation

Dependent Child

Indicates Dependent Child

Dependent Other

Indicates Dependent Other

Education

Indicates Education

Marital Status

Indicates Marital Status

Spouse

Indicates Spouse

Spouse Employment Status

Indicates Spouse Employment Status

39.15 Customer Accounts Report

This section contains the following topics:

39.15.1 Generating Customer Accounts Report

This report gives details of the customer account and you can generate this report using the ‘Customer Accounts’ screen.

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

39.15.2 Contents of 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 branch, information on the branch date, the user ID, the module name, the date and time at which the report was generated and the page number of the report.

Body of the report

The details of the customer accounts details that would be displayed in the report are as follows:

Field Name

Field Description

Account Number

Details about customer account Number

Account Class

Details about account class

Account Description

Account Description

Opening Date

The opening date of the account.

Dormant

The account status as dormant

Frozen

Account status as frozen.

No Credits

Gives no credit status of the account number.

No Debits

Gives no debit status of the account number.

Stop Payments

Gives the accounts stop pay status.

Statement Cycle

Gives the account statement cycle.

Statement Day

Gives the account statement day.

Statement Type

Gives account statement type.

Alternate Account Number

Gives an alternative account number.

Branch Code

Gives the branch code.

Currency

Currency

Customer Number

Gives customer number.

Nominee1

Gives the first nominee details

Nominee2

Gives the second nominee details

Account Type

Gives the account type.

Dr GL

Gives all debit balances within a specific account class

Cr GL

Gives all credit balances within a specific account class.

Dr HO Line

In this, all accounts belonging to account class will report, if they move to the status being defined.

Cr HO Line

In this, all accounts belonging to account class will report, if they move to the status being defined.

Dr CB Line

This is a GL to which all debit accounts belonging to an account class should report to.

Cr CB Line

This is a GL to which all credit accounts belonging to an account class should report to.

ATM Facility

Availability of ATM facility.

Cheque Book Facility

Availability of cheque book facility.

Passbook Facility

Availability of passbook facility.

Previous Statement Date

Gives the date of the previous statement.

Previous Statement Balance

Gives the balance of the previous statement.

Previous Statement Number

Gives the number of the previous statement

TOD Limit

The temporary overdraft limit facility granted to the customer account

Sublimit

It the overdraft facility maximum permitted to this account associated and tracked against the line id maintained for the liability.

Limit Currency

Displays the currency code of the limit

TOD Limit Start Date

The start date for the temporary overdraft facility

TOD Limit End Date

The end date for the temporary overdraft facility.

Uncollected Funds Limit

The funds hit the account which are debited / credited to the account with effect from the mentioned value days

Line ID

The line code is associated with the liability ID against which the overdraft facility is being tracked.

Tanked Status

It is the status of the transaction that hit the account in a specific branch once the branch is marked for EOTI.

Account Balance

Gives the total account balance

Maker ID

The identification number of the maker

Maker Date Stamp

This is the date on which the contract was uploaded.

Checker ID

This is the Login ID of the user who authorized the product.

Checker Date Stamp

This is the date on which the product was authorized.

Mod Number

Displays the number of times the record was modified.

Record Stat

Displays the current status of the external account record.

Authorization Status

Displays the current authorization status of the record.

Joint Holder Code

Displays joint holder CIF ID

Joint Holder Description

Displays description of the joint holder

Joint Holder

Displays linked entities of the joint holder

39.16 Document Check List Report

This section contains the following topics:

39.16.1 Generating Document Check List Report

This report gives you the details of the customer account whose documents are pending for submission, expired, or about to expire.

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

Branch Code

Specify the branch code

Document Status

Specify the status of the document submitted by the customer from the adjoining option list. You can select one of the following:

Note

From Date

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

To Date

Specify the date till which details should be made available in the report. The system will include all customers 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.

39.16.2 Contents of the Report

Header

The Header carries the title of the report, information on the branch code, the ID of the user who generated the report, the date and time at which it was generated and the modules covered in the report.

Body of the Report

Field Name

Field Description

Branch Code

Current branch code

Customer Number

Customer identification number

Customer Name

Customer name

Customer Account Number

Customer account number

Document Type

Type of document

Expiry Date

Expiry date of the document

Expected Date of Submission

Expected date of document submission

Actual Submission Date

Actual document submission date

39.17 Memo Revaluation Report

This section contains the following topics:

39.17.1 Generating Memo Revaluation Report

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

39.17.2 Contents of Report

Header

The Header carries the title of the Report, information on the branch code, the branch date, the user ID, the module name, the date and time at which the report was generated and the page number of the report.

Body of the Report

Field Name

Field Description

Currency

This is the currency for which transaction details is being reported

Revaluation Rate

This is the revaluation rate

Account

This is the account for which transaction details is being reported

Description

This is the description provided

Account Revalued

This is the revalued account

Account Balance

This indicated the account balance

Lcy Equivalent (before reval)

This indicates the local currency before revaluation

Lcy Equivalent (after reval)

This indicates the local currency after revaluation

Profit/ Loss

This is the profit or loss incurred

Profit/ Loss Amount

This is the profit or loss amount

P&L Account

This is the profit or loss account

Currency

This is the currency for which transaction details is being reported

Rate

This is the revaluation rate

Category

This is the category

39.18 Black Listed During Contract Booking Report

This section contains the following topics:

39.18.1 Generating Black Listed During Contract Booking Report

You can invoke ‘Black Listed During Contract Booking Report’ screen by typing ‘CSRPBLCB’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

The screen is as shown below:

Date

Specify the date when the contract was black listed from the adjoining calendar.

39.18.2 Contents of the Report

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

Header

The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.

Body of the Report

Field Name

Field Description

Reference Number

Indicates the reference number

Customer Number

Indicates the customer number

Customer Name

This indicates the name of the customer

Nationality

Indicates the nationality of the customer

Unique ID Name

Indicates the unique identification name

RM Code

Indicates the relationship manager code

RM Name

Indicates the name of relationship manager

39.19 Black List Report During File Upload Report

This section contains the following topics:

39.19.1 Generating Black List Report During File Upload Report

You can invoke ‘Black List Report During File Upload’ screen by typing ‘CSRPBLUP’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

The screen is as shown below:

39.19.2 Contents of the Report

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

Header

The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.

Body of the Report

Field Name

Field Description

Customer Number

Indicates the customer number

Customer Name

This indicates the name of the customer

Nationality

Indicates the nationality of the customer

Unique ID Name

Indicates the unique identification name

Unique ID Value

Indicates the unique identification value

RM Code

Indicates the relationship manager code

RM Name

Indicates the name of relationship manager

39.20 Cheque Book Issued Report

This section contains the following topics:

39.20.1 Generating Cheque Book Issued Report

You can invoke ‘Cheque Book Issued Report’ screen by typing ‘CSRPCHB’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

The screen is as shown below:

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:

Date Range

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.

39.20.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 Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.

Body of the Report

Field Name

Field Description

Date of Issue

Indicates the date of issue

Issuing Channel

Indicates the Issuing Channel

Account Number

Indicates the account number

Account Currency

Indicates the account currency

Account Name

Indicates the account name

Serial Number

Indicates the serial number

Maker ID

Indicates the maker ID

Checker ID

Indicates the checker ID

39.21 Demand Draft Issued Report

This section contains the following topics:

39.21.1 Generating Demand Draft Issued Report

You can invoke ‘Demand Draft Issued Report’ screen by typing ‘CSRPDDRP’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

The screen is as shown below:

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:

39.21.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 Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.

Body of the Report

Field Name

Field Description

Account Number

Indicates the account number

Account Name

This indicates the name of the account

Currency

Indicates the currency of the account

Amount

Indicates the amount

Instrument Number

Indicates the instrument number

Description

Indicates the description of the demand draft

Cheque Number

Indicates the Cheque Number

Drawn On

Indicates the date when the DD was drawn

Input On

Indicates the date when the data was provided

Reference Number

Indicates the reference number

Maker ID

Indicates the identification of the maker of the record

Maker Date Stamp

Indicates the date when the record was created

Checker ID

Indicates the identification of the checker who author­ized the record

Checker Date Stamp

Indicates the date on which the record was authorized

39.22 PDC Input Report

This section contains the following topics:

39.22.1 Generating PDC Input Report

You can invoke ‘PDC Input Report’ screen by typing ‘CSRPPDC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

The screen is as shown below:

39.22.2 Contents of the Report

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

Header

The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.

Body of the Report

Field Name

Field Description

Account Number

Indicates the account number

Account Name

This indicates the name of the account

Currency

Indicates the currency of the account

Amount

Indicates the amount

Instrument Number

Indicates the instrument number

Bank Name

Indicates the name of the bank

Clearing Date

Indicates the date of clearing

Value Date

Indicates the value date of the demand draft

Maker ID

Indicates the identification of the maker of the record

Maker Date Stamp

Indicates the date when the record was created

Reference Number

Indicates the reference number

39.23 Temporary Overdraft Report

This section contains the following topics:

39.23.1 Generating Temporary Overdraft Report

You can invoke ‘Temporary Overdraft Report’ screen by typing ‘CSRTEMOD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

The screen is as shown below:

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:

Customer Type

Select the type of customer from the following options provided:

39.23.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 Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.

Body of the Report

Field Name

Field Description

Customer Account Number

Indicates the customer account number

Customer Name

This indicates the name of the customer

Customer Type

Indicates the type of customer

Account Description

Displays the description for the account

Branch

Indicates the branch of the account

Customer Number

Indicates the customer number

Account Class

Indicates the account class of the customer

Customer Category

Indicates the category to which customer belong to

MIS Code

Indicates the MIS code

Currency

Indicates the currency of the account

Holding Amount

Indicates the holding amount

LCY Opening Balance

Indicates the opening balance in local currency

ACY Opening Balance

Indicates the opening balance of the account cur­rency

ACY Available Balance

Indicates the available balance of the account cur­rency

ACY Current Balance

Indicates the current balance of the account cur­rency

Temp OD Since

Indicates the date when the temp OD was started

Overdraft Since

Indicates the date when the overdraft was started

Temp OD Debits Today

Indicates the day’s temp OD debits

Temp OD Credits Today

Indicates the day’s temp OD credits

39.24 Daily Sales Report

This section contains the following topics:

39.24.1 Generating Daily Sales Report

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

You can specify the following parameters here:

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.

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

Branch

Indicates Branch Code and Branch Name

Branch Date

Indicates Current Date of the Branch

User ID

Indicates User ID

Date & Time

Indicates the Date and Time when the report was generated

Module

Indicates module for which report is generated.

Body of the Report

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

Field Name

Field Description

Module

Indicates the module code

Outstanding Amount

Indicates the outstanding amount

Product Code

Indicates the product code

Customer ID

Indicates the customer ID

Customer Name

Indicates the name of the customer

Product Description

Indicates the product description

Account Number

Indicates Customer Account number

Booking Date

Indicates the date of booking

Branch Name

Indicates Branch Name

RM Code

Indicates the relationship manager code

DS Code

Indicates the DS code

39.25 Customer Restriction Utilization Report

This section contains the following topics:

39.25.1 Generating Customer Restriction Utilization Report

In this report, details of customer restrictions for a particular period is generated. You can invoke this screen by typing ‘CSRRSTRP’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

To generate the report, enter the following details:

Customer Number

Select the customer number from the adjoining option list. All customer numbers as maintained in the system are displayed.

Restriction Code

Select the restriction code from the adjoining option list. The restriction code as maintained in the ‘Restriction Code Maintenance’ screen is displayed.

Start Date

Specify the start date for which the data needs to be generated.

End Date

Specify the end date for which the data needs to generated.

39.25.2 Contents of the Report

The following details of the report are displayed:

Field Name

Field Description

Customer Number

Indicates the customer number.

Customer Name

Indicates the name of the customer.

Account Number

Indicates the account number of the customer.

Transaction Date

Indicates the date of the transaction.

Transaction Refer­ence Number

Indicates the reference number of the transaction.

Transaction Cur­rency

Indicates the currency of the transaction.

Transaction Amount

Indicates the transaction amount.

Transaction Cur­rency

Indicates the currency of the transaction amount.

Restriction Code

Indicates the Restriction Code for the transaction.

Restriction Descrip­tion

Indicates the description of the transaction.

Restriction Period

Indicates the restriction period

Restriction Amount

Indicates the restriction amount

Restriction Currency

Indicates the restriction currency

Start Date

Indicates the Start Date of the Report

End Date

Indicates the End Date of the Report

Utilized Limit

Indicates the utilized restriction amount.

39.26 Integrating Oracle Business Intelligence Enterprise Edition

Oracle Business Intelligence Enterprise Edition (OBIEE) can be integrated with the Oracle FLEXCUBE LCM application. This will enable you to invoke all OBIEE reports or dashboards from the LCM dashboard menu screen. To integrate OBIEE with the application refer to the following steps:

When the user logs into the application, the OBIEE report/dashboard is displayed in the LCM dashboard menu screen.

  1. Create a report or dashboard in OBIEE and name this report or dashboard using the function ID naming convention followed in Oracle FLEXCUBE.
  2. Create a new function ID in the
  3. ‘Function Description Maintenance’ screen (SMDFNDSC). The function ID created in this screen should be the same as the OBIEE report or dashboard name. For more information on creating a new function ID, refer to the section ‘Maintaining Function Descriptions’ in this User Manual.
  4. Create a role for this function ID in the ‘Role Maintenance’ screen (SMDROLDF) and add the function to this role. For more information on creating a role refer to the section ‘Defining a User Role’ in this User Manual.
  5. Add a user to this role in the ‘User Maintenance’ screen (SMDUSRDF). For more information on adding the user to a role, refer to the section ‘Defining and Maintaining System Users’ in this user manual.

In the following screen shot the ‘Show Dashboard’ and ‘Alerts on Home’ is displayed as Y which indicates the Alerts and Dashboard have been added to the home screen. These values are defaulted from the User Settings in the home screen

When the user logs into the application, the OBIEE report/dashboard is displayed in the ELCM dashboard menu screen.