Expired Account Enquiry Function - Fields Description

At this function, user will come across various fields or columns that needs to be maintained with relevant data.

The descriptions of the respective field or column, are as follows:-

Expired Accounts (Panel)

<Expired Accounts Search Criteria> (Sub-Panel)

From Branch

This is the starting branch code of a range of branch codes to search for the relevant expired or expiring accounts.

To Branch

This is the ending branch code of a range of branch codes to search for the relevant expired or expiring accounts.

Expire From

This is the starting date of a range of account expiry dates to search for the relevant expired or expiring accounts.

Expire To

This is the ending date of a range of account expiry dates to search for the relevant expired or expiring accounts.

<Summary of Search Results> (Sub-Panel)

No.of Account

This is the total number of accounts found based on the selected range of branch codes.

Note: This field will be displayed after system have successfully retrieved the search results.

No.of Expired Account

This is the total number of expired accounts based on the selected range of branch codes and range of expired dates.

Note: This field will be displayed after system have successfully retrieved the search results.

% Expired

This is the total number of expired accounts (in percentage) based on the selected range of expired account dates and range of branch codes, over the total number of accounts found.

Note: This field will be displayed after system have successfully retrieved the search results.

Total Gross Balance

This is the total credit facility accounts' gross outstanding amount (in base currency), e.g., total of interest and principal balance amount including all other charges, deductible items' amount and penalty interest on late payment (that must be accounted as the credit facility debtor) of the selected credit facility accounts found, based on the selected range of branch codes and range of expired account dates.

Note: This field will be displayed after system have successfully retrieved the search results.

Total Gross Balance Expired

This is the total expired credit facility accounts' gross outstanding amount (in base currency), e.g., total of interest and principal balance amount including all other charges, deductible items' amount and penalty interest on late payment (that must be accounted as the credit facility debtor) of the selected credit facility accounts found, based on the selected range of branch codes and range of expired account dates.

Note: This field will be displayed after system have successfully retrieved the search results.

% of Balance Expired

This is the total expired credit facility accounts' gross balance over the total credit facility accounts' gross balance found, based on the selected range of branch codes and range of account expired dates.

Note: This field will be displayed after system have successfully retrieved the search results.

  • This panel will be displayed upon the function screen opened.

  • The purpose of this panel is for user to do the followings:-

    • Input the relevant search criteria for the search of the relevant records.

    • View the summary of the search results, based on the selected range of branch codes and range of credit facility expired dates.

<By Branch and Product>(Sub-panel)

Branch

This is the code of the respective branch created in system of which the respective credit facility account has parked for service.

Product

This is code and name of a product of certain credit facility accounts found, based on the selected range of branch codes and range of credit facility expired dates.

No.of Account

This is the total number of accounts found based on the selected range of branch codes, segregated by the branch codes, and product codes.

No.of Expired Account

This is the total number of expired accounts based on the selected range of branch codes and range of expired dates, segregated by the branch codes, and product codes.

% of Expired Acct

This is the total number of expired accounts (in percentage) based on the selected range of expired account dates and range of branch codes, over the total number of accounts found, segregated by the branch codes, and product codes.

Gross Balance

This is the total credit facility accounts' gross outstanding amount (in base currency), e.g., total of interest and principal balance amount including all other charges, deductible items' amount and penalty interest on late payment (that must be accounted as the credit facility debtor) of the selected credit facility accounts found, based on the selected range of branch codes and range of expired account dates, segregated by the branch codes, and product codes..

Gross Balance(Expired)

This is the total expired credit facility accounts' gross outstanding amount (in base currency), e.g., total of interest and principal balance amount including all other charges, deductible items' amount and penalty interest on late payment (that must be accounted as the related credit facility debtor) of the credit facility accounts found, based on the selected range of branch codes and range of expired account dates segregated by the branch codes, and product codes..

% of Gross Balance

This refers to the total gross outstanding balance amount (in base currency) in percentage for the accounts that have expired or are expiring on a certain expiry date in the respective branch over the the total Gross Balance.

  • This panel will be displayed after user has clicked once on the Search button.

  • The purpose of this panel is to display the breakdowns of credit facility accounts found within the selected range of branch codes and range of expiry dates, by branch codesd and product codes.

Expired Account Details (Panel)

Account List (Panel)

Branch

This is the code and name of the respective branch created in system where credit facility accounts are parked for service.

Account List (Sub-Panel)

Expiry Date

Credit account expiry date is the last date that the respective borrower can still enjoy the credit facility in his or her credit account.

Account No.

This is the unique reference number of the respective credit facility account in system.

Name

This is the customer name of the main account holder in the credit facility account.

Product

This is code and name of credit facility product in the respective account.

Ccy

This is the product currency code, e.g., MYR.

Gross Balance

This is the credit facility account' gross outstanding amount (in base currency), e.g., total of interest and principal balance amount including all other charges, deductible items' amount and penalty interest on late payment (that must be accounted as the credit facility debtor).

Gross Balance(Base)

This is the expired credit facility account' gross outstanding amount (in base currency), e.g., total of interest and principal balance amount including all other charges, deductible items' amount and penalty interest on late payment (that must be accounted as the credit facility debtor).

  • This panel will be displayed after user has clicked once on the Details button of a record by branch code and product code.

  • The purpose of this panel is to display the breakdowns of each record of branch and product record by the list of related credit facility accounts.