4. Queries

The Queries module under the Menu Browser provides query functions for the following:

• Liabilities
• Liability History
• Facilities
• Utilizations
• Utilization Transactions
• Utilization Log
• Collateral Covenants
• Facility Covenants

This chapter contains the following sections:

• Section 4.1, "Liabilities Query"
• Section 4.2, "Liability History"
• Section 4.3, "Utilization Transaction Query"
• Section 4.4, "Covenants Queries"

4.1 Liabilities Query

The ‘Liability Query’ screen allows you to query for records based on the following parameters:

• Authorization Status
• Liability Number
• Liability Branch
• Record Status
• Liability Currency

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

 

 

You can use this screen to query the Facilities and the Utilizations Details for a Liability. To do this, choose the liability for which you want to view details by selecting the check box at the beginning of each row and clicking the ‘Facility Detail’ button. The ‘Facility Query’ screen with details of the facilities is displayed.

 

In the ‘Facility Query’ screen, choose the facility for which you want to view the utilization details by selecting the check box at the beginning of the row and clicking on the ‘Utilization Details’ button. The system displays the ‘Utilization Query’ screen containing details of the utilization, as shown below:

 

4.2 Liability History

The ‘Liability History Query’ screen allows you to query for records based on the following parameters:

• Authorization Status
• Liability Number
• Record Status
• Liability Branch

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

 

4.3 Utilization Transaction Query

The ‘Utilization Transaction Query’ screen allows you to query for records based on the following parameters:

• Liability Number
• Line Code
• Branch Code
• Customer Number
• Liability Branch
• Utilization Price
• Auth status
• Record Status

The total number of exposure for the customer can be viewed. It also shows the Sum of Amount Utilization in local currency/ branch currency.

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

 

4.4 Covenants Queries

You can perform the following queries for covenants in the system:

The ‘Facility Covenants Query’ allows you to query the covenants associated with a particular facility. Details including the line code, liability number, last revision date, notice days and so on for the covenant can be viewed.

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

 

The ‘Collateral Covenants Query’ allows you to query the covenants associated with a particular collateral. Details including the collateral code, liability number, last revision date, and notice days for the covenant can be viewed.

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