CU*BASE Query: Q-Share (MEMBER1)

This Query is used to view information in the CU*BASE “MEMBER1” file. This file stores financial information used in tracking share and sub-share account types.

Specifications

File(s) used by this Query: MEMBER1

Access: Tool #813: Share/IRA Accounts (MEMBER1)

Records will be grouped according to Dividend Application, with each group sorted in ascending order by Account Base. After each Dividend Application group, the system will show a total, average, and count for all accounts in that group, with grand totals at the bottom of the report.

The following fields will be displayed in this Query:

Share Type
Corporate ID
IRA (indicates whether or not the account is an IRA account)
Branch Number
Account Number
Account Suffix
Current Balance
Average Balance (for the dividend period)
Accrued Dividend
Open Month, Open Day, Open Year
Joint Owner Names 1 and 2
GL Account Number

Sample Conditions

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

Description

Field

Test

Value

List all regular share accounts (Dividend Application “SH”) with a balance below $100.

AND

DIVAPL

CURBAL

'SH'

100.00

List all accounts opened during March, 1996.

AND

DTOMTH

DTOYR

Show all accounts for branches 01 and 02.

“OR” is used because an account can only belong to either one branch or the other, not both.

BRANCH