CU*BASE Query: Q-SH/SD Transactions (TRANS1)

This Query is used to view information in the CU*BASE “TRANS1” file. This file shows current month transactions for share and share draft/checking accounts.

Specifications

File(s) used by this Query: TRANS1

Access: Tool #872: Transactions - SH/SD (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:

Transaction Date Automatic Reversal Flag
Corporate ID Transaction Origin Code
Dividend Application 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
Draft/Check Number

Sample Conditions

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

Description		Field	Test	Value
Show how many NSF fees were charged to member accounts during the past week (June 17-21).	AND AND	TRDESC TRDATE TRDATE	EQ GE LE	'NSF FEE' 061796 062196
Show any NSF type transactions, whether returns, fees, or reversals. The percent sign (%) can be used in situations like these when you want to see all descriptions that start with the characters 'NSF' followed by any other characters.		TRDESC	LIKE	'NSF%'
Show any transaction in the amount of $1,259.03.		TRAMTP	EQ	1259.03