CU*BASE Query: Q-Collections - Overline (COLL)

This Query is used to view information contained in the CU*BASE “COLL” file. This file stores collections information and this Query is designed to show all loans where the current balance is higher than the credit limit.

Specifications

File(s) used by this Query: COLL

Access: Tool #228: Collections (COLL) - Overline Accounts

Records will be sorted alphabetically by member name. A grand total and count will be shown at the bottom of the report.

The following fields will be displayed in this Query:

Member Name
Account Base
Account Suffix
Current Balance
Overline Balance
Branch Number
Last Contact Date
Last Transaction Date
Corporate ID
Status

Sample Conditions

The following table lists a few sample conditions which can be used in the Collections - Overline Query.

· IMPORTANT: Notice the default condition that is already entered for this Query. Because this condition is important to perform the Query properly, be sure to leave it as is and add any other conditions below it.

Description

Field

Test

Value

Show all accounts that are at least $25.00 or more over the approved credit limit.

AND

CMRTYP

CMOVER

'O'

25.00