CU*BASE Query: Q-CD Transactions (TRANS3)

This Query is used to view information in the CU*BASE “TRANS3” file. This file shows current month transactions for certificate (CD) accounts.

Specifications

File(s) used by this Query: TRANS3

Access: Tool #870: Transactions - CD (TRANS1)

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:

Application Type Transaction Reversal Flag
Transaction Date Transaction Origin
Corporate ID Primary GL Account Number (member)
Transaction Type Offset GL Account Number
Transaction Code CU Employee ID
Account Number Transaction Branch Number
Account Suffix Member Branch Number
Transaction Amount Processing Date
Resulting Balance Processing Time
Transaction Sequence # Transfer Account Number
Transaction Description Transfer Account Suffix

Sample Conditions

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

Description

Field

Test

Value

Show any transactions posted after 5:00 p.m. last Tuesday (June 19).

AND

PRTIME

PRDATE

170000

960619

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

TRAMTP

1259.03