CU*BASE Query: Q-Journal Hist - Desc. (GLHIST)

This Query is used to view information contained in the CU*BASE “GLHIST” file. This file stores all General Ledger transaction activity.

Specifications

File(s) used by this Query: GLHIST

Access: Tool 420: Journal History by Description (GLHIST)

Records will be sorted and grouped by J/E description. After each group, the system will show a total and count for all entries within that group, with grand totals at the bottom of the report.

The following fields will be displayed in this Query:

Corporate ID
Effective Post Date
Journal Entry ID
Journal Entry ID #
Branch Number
GL Account Number
Debit Amount
Credit Amount
Net Posted Amount
Journal Entry Description
Post Flag
Year-End Close Indicator

Sample Conditions

The following table lists a few sample conditions which can be used in the Journal Hist - Desc. Query.

Description	Field	Test	Value
Show all journal entries posted to the month of June, 1996.	JEDT	RANGE	960601 960701
Show all journal entries with “FA” as the J/E ID.	JEID	EQ	'FA'