CU*BASE Query: Q-LN/LOC Transactions (TRANS2)

This Query is used to view information in the CU*BASE “TRANS2” file. This file shows currentmonth transactions for loan and line-of-credit accounts.

Specifications

File(s) used by this Query: TRANS2

Access: Tool #871: Transactions - LN/OC (TRANS2)

Records will be grouped according to dividend application, transaction type and transaction code, with each group sorted in date order. After each group, the system will show a total and count for all transactions in that group, with grand totals at the bottom of the report.

The following fields will be displayed in this Query:

Loan Category Draft/Check Number
Transaction Date Transaction Reversal Flag
Corporate ID Transaction Origin Code
Transaction Type Primary GL Account Number (member)
Transaction Code Offset GL Account Number
Account Number CU Employee ID
Account Suffix Transaction Branch Number
Transaction Amount Member Branch Number
Interest Due Paid Processing Date
Principal Paid Amount Processing Time
Resulting Balance Transfer Account Number
Transaction Sequence Number Transfer Account Suffix
Transaction Description

Sample Conditions

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

Description

Field

Test

Value

Show all transactions posted yesterday (August 14) that were offset to the GL suspense account 870.07.

AND

PRDATE

GLACSS

960814

870.07

Show any transaction in the amount of $1,259.03.

TRAMTP

1259.03