CU*BASE Query: Q-Closed Loan (ACHIST5)

This Query is used to view information contained in the CU*BASE “ACHIST5” file. This file stores information about closed loan accounts.

Specifications

File(s) used by this Query: ACHIST5

Access: Tool #216: Closed Loan Accounts (ACHIST5)

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 Total Payments

  • Loan Category Payments Left

  • Processing Type GL Account #

  • Account Base  Write Off Indicator

  • Account Suffix YTD Interest Paid

  • Current Balance Last Pmt Month, Day, and Year

  • Interest Due Partial Payments

  • Unpaid Fine Delinquent Balance

  • Payoff Balance Purpose Code

  • Interest Rate Security Code

  • Payment Amount Open Month, Open Day, Open Year

  • Payment Frequency Closed Month, Closed Day, Closed Year

  • Variable Interest Rate Code

Sample Conditions

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

Description

 

Field

Test

Value

Show all car loans (purpose code “11”) which were paid off and closed in the past three months.

 

AND

AND

LNTYPE

CLOSMO

CLOSYR

EQ

GE

GE

'11'

06

96

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

 

AND

CLOSMO

CLOSYR

EQ

EQ

05

96

 

Clickherefor complete instructions on navigating around the “Display Report” screen or using the available buttons.