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

GT

EQ

170000

960619

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

 

TRAMTP

EQ

1259.03

 

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