CU*BASE Query: Collateral Inquiry

The Member Collateral Inquiry tool uses IBM Query to produce a display showing loan collateral records associated with member loan accounts. This Query produces a detailed list showing each individual collateral record, including description and estimated value information. It can be especially helpful for cross-referencing a VIN (Vehicle ID Number) with a loan account.

Specifications

File(s) used by this Query: CLML

Access: Tool #224: Collateral/VIN# Lookup (CLML)

The list will be sorted by account number.

Sample Conditions

Following are some sample conditions which could be used when running the Collateral Inquiry:

Description

Field

Test

Value

Show collateral information for Vehicle Identification Number (VIN) 1234567ABC12345

CLID

'1234567ABC12345'

Show all collateral records for loan account 7533-770

AND

ACCTBS

ACTTYP

7533

770