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

 

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