This chapter contains the following sections:
This section contains the following topics:
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.
The contents of this report are discussed under the following heads:
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.
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 Description |
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 transaction. |
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. |
This section contains the following topics:
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.
The contents of this report are discussed under the following heads:
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.
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 Description |
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 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. |
This section contains the following topic:
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.
The contents of the cash flow report are discussed under the following heads:
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.
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 specified period. |
Net Flow |
Indicates the net flow |
Currency |
Indicates the currency of the transaction |
The Cash Flow summary report summarizes the details of cash flow for particular Accounts or Account Classes.
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.
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 |
This section contains the following topics:
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’.
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.
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 Number |
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. |
This section contains the following topics:
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.
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.
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. |
This section contains the following topics:
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.
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 .
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. |
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. |
This section contains the following topics:
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.
The contents of the report are discussed under the following heads:
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.
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 |
This section contains the following topics:
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:
The contents of account closing confirmation have been discussed under the following heads:
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.
You can find the following details in the body of the report:
Field Name |
Field Description |
Client Number |
The account number of the client |
This section contains the following topics:
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.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
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.
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 |
This section contains the following topics:
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.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
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.
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 |
This section contains the following topics:
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.
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.
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 Reference |
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 |
This section contains the following topics:
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.
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.
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 |
This section contains the following topics:
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.
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.
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 Number |
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 Currency |
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 |
This section contains the following topics:
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.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
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.
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 whereabouts. |
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 |
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 |
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 |
This section contains the following topics:
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.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
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.
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 |
This section contains the following topics:
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.
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.
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 |
This section contains the following topics:
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.
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.
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 |
This section contains the following topics:
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.
The contents of the report are discussed under the following heads:
The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.
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 |
This section contains the following topics:
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:
The contents of the report are discussed under the following heads:
The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.
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 |
This section contains the following topics:
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:
From Date
Specify a valid date from when you wish to generate the report from the adjoining calendar.
To Date
Specify a valid date till when you wish to generate the report from the adjoining calendar.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.
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 |
This section contains the following topics:
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:
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.
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 authorized the record |
Checker Date Stamp |
Indicates the date on which the record was authorized |
This section contains the following topics:
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:
The contents of the report are discussed under the following heads:
The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.
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 |
This section contains the following topics:
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:
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
The header carries the Report Name, Branch, Branch Date, User Id, Module, Run Date and Time.
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 currency |
ACY Available Balance |
Indicates the available balance of the account currency |
ACY Current Balance |
Indicates the current balance of the account currency |
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 |
This section contains the following topics:
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.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
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. |
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 |
This section contains the following topics:
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.
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 Reference Number |
Indicates the reference number of the transaction. |
Transaction Currency |
Indicates the currency of the transaction. |
Transaction Amount |
Indicates the transaction amount. |
Transaction Currency |
Indicates the currency of the transaction amount. |
Restriction Code |
Indicates the Restriction Code for the transaction. |
Restriction Description |
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. |
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.
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.