CU*BASE Query: Q-Closed LOC (ACHIST6)

This Query is used to view information contained in the CU*BASE “ACHIST6” file. This file stores information about closed line-of-credit and open-end loan accounts.

Specifications

File(s) used by this Query: ACHIST6

Access: Tool #217: Closed LOC Accounts (ACHIST6)

Records will be grouped by loan category and branch. After each group, the system will show a total, average and count for all accounts within that group, with grand totals at the bottom of the report.

The following fields will be displayed in this Query:

Branch Number
Payment Amount
Loan Category
Payment Frequency
Processing Type
Variable Interest Rate Code
Account Base
GL Account Number
Account Suffix
Write Off Indicator
Current Balance
YTD Interest Paid
Interest Due
Partial Payments
Unpaid Fine
Delinquent Balance
Payoff Balance
Purpose Code
Disbursement Limit
Security Code
Available Credit (conting. liability)
Open Month, Open Day, Open Year
Interest Rate
Closed Month, Closed Day, Closed Year

Sample Conditions

The following table lists a few sample conditions which can be used in the Closed LOC Query.

Description

Field

Test

Value

Show all accounts closed during the month of May, 1996.

AND

CLOSMO

CLOSYR