GLTWHDR

GL Transaction Writer Header

The General Ledger Transaction Writer file contains report parameters defined in GL55.1 (Transaction Writer) and inputs the parameters into GL256 (Transaction Writer Report) to process the report.

REFERENCED BY
GL255


UPDATED BY
GL256 GL55.1 GL55.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GWH-TW-NAME
Element: Name
Alpha 12
The name that identifies the report.
GL55.1 GL55.2
GWH-COMPLETE-FLAG
Element: Complete Flag
Alpha 1
Indicates if the record is complete.
Y = Complete
N = Incomplete
GL55.1
GWH-FOLDER-NAME
Element: Folder Name
Alpha 12
This is the name of a folder. Folders are defined in RW01.1 (Folder).
GL55.1 GL55.2
GWH-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The transaction writer report description.
GL55.1 GL55.2
GWH-COLM-SPACING
Element: Column Spacing
Numeric 2
The default value used for creating spaces between columns. Valid values are 0-99.
GL55.1
GWH-COLM-HEAD-OPT
Column Heading
Option
Alpha 1
Determines whether the two column heading lines are controlled manually or by the system (automatic).
A = Automatic
M = Manual
GL55.1
GWH-CSV-OUTPUT
Element: CSV Output
Alpha 1
A No value creates a 132-character wide report with up to two lines of detail per transaction. A Yes value creates a CSV file with two lines of detail strung into one line per transaction. The formatted heading line will be the first line of the CSV file.
GL55.1
GWH-SEARCH-METHOD
Element: Search Method
Alpha 1
The method used for transaction selection. S (System Control) enables the program to choose the best path and file based on the entered parameters. A (Account) uses the company, accounting unit, and account parameters. Only use this method if there are few accounts to be considered. C (Analysis Codes) uses analysis codes to select transactions to be included. H (Journal Header) uses the journal header file to select transactions to be included.
S = System Controlled
A = Account
C = User Attributes
H = Journal Header
GL55.1
GWH-LAST-RUN-DATE
Element: Last Run Date
Numeric 8 (yyyymmdd)
The last date the record was processed.
GL256 GL55.1
GL55.2
GWH-LAST-RUN-TIME
Element: Last Run Time
Numeric 6 (hhmmss)
The last time the record was processed.
GL256 GL55.1
GL55.2
GWH-COMPANY
Element: Company
Numeric 4
The company number as defined in GL10.1 (Company).
GL55.1
GWH-ACCT-UNIT
Element: Accounting Unit
Alpha 15
The valid accounting unit used in conjunction with the company field.
GL55.1
GWH-COMPANY-GROUP
Element: Company Group
Alpha 12
A valid company group. All accounting units within each of the companies in the group are included.
GL55.1
GWH-MATRIX-LIST
Element: Matrix List
Alpha 12
The Accounting unit list is one of the organizational parameter options as defined in MX10 (List) for object type ACCTU.
GL55.1
GWH-FR-ACCOUNT
Element: From Account
Numeric 6
The beginning account for a range of accounts.
GL55.1
GWH-TH-ACCOUNT
Element: To Account
Numeric 6
The ending account for a range of accounts.
GL55.1
GWH-ACCT-GROUP
Element: Account Group
Alpha 12
An account group as defined in RW40.3 (Account Group).
GL55.1
GWH-CHART-NAME
Element: Chart Name
Alpha 12
The name assigned to the chart of accounts when you defined your company structure in the General Ledger system.
GL55.1
GWH-SUMMARY-ACCT
Element: Summary Account
Alpha 12
The summary account used in conjunction with the chart name.
GL55.1
GWH-FR-SUB-ACCT
Element: From Subaccount
Numeric 4
The beginning subaccount for a range of subaccounts.
GL55.1
GWH-TH-SUB-ACCT
Element: Through Subaccount
Numeric 4
The ending subaccount for a range of subaccounts.
GL55.1
GWH-SUB-ACCT-GRP
Element: Subaccount Group
Alpha 12
A subaccount group as defined in RW40.4 (Subaccount Group).
GL55.1
GWH-LAST-SEQ-NBR
Element: Last Sequence Number
Numeric 6
The last transaction sequence number.
GL55.1
GWH-SORT-MX-CAT
Element: Sort Matrix Category
Alpha 12 Occurs 8 Times
There are up to eight matrix attributes for sorting the selected objects. It does not have to be a selection category to be a sort category. The sort is in ascending order.
GL55.1
GWH-HEAD-LAYOUT-1
Element: Head Layout 1
Alpha 132 (Lower Case)
The Header Layout line one.
GL55.1
GWH-HEAD-LAYOUT-2
Element: Head Layout 2
Alpha 132 (Lower Case)
The header layout line two.
GL55.1
GWH-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
GL55.1
GWH-ACCOUNT-LIST
Element: Account List
Alpha 12
The Account List is one of the Account parameter options as defined in MX10 (List) for object type ACCNT.
GL55.1
GWH-LEDGER
Element: Ledger
Alpha 15
The name that identifies the strategic ledger. The Ledger information is used to post Strategic ledger data using SL190 (Strategic Ledger Posting) or used for reporting in the OLAP environment using SL87 (Strategic Ledger Data Mart Setup).
GWH-LEVEL-GROUP
Element: Level Group
Alpha 12
The Level Group is one of the organizational parameter options as defined in RW40.1 (Level Group).
GL55.1


GLTWHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GWHSET1 TW-NAME
GL255 GL256
GL55.1 GL55.2
GWHSET2 FOLDER-NAME
TW-NAME
KeyChange
GL255


GLTWHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Folder GLCODES Required
"F"->GCD-RECORD-TYPE
GWH-FOLDER-NAME->GCD-FOLDER-NAME
Spaces->GCD-PROCESS-GROUP
Spaces->GCD-SYSTEM
Zeroes->GCD-COMPANY
Glchart GLCHART Not Required
GWH-CHART-NAME->GCH-CHART-NAME
Glchartsum GLCHARTSUM Not Required
GWH-CHART-NAME->GCS-CHART-NAME
GWH-SUMMARY-ACCT->GCS-SUMMARY-ACCT
Glnames GLNAMES Not Required
GWH-COMPANY->GLN-COMPANY
GWH-ACCT-UNIT->GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
GWH-COMPANY->GLS-COMPANY
Mxlisthdr MXLISTHDR Not Required
"ACCTU"->MLH-OBJ-TYPE
GWH-MATRIX-LIST->MLH-MATRIX-LIST
Mxobjcat MXOBJCAT Not Required
"GLTRN"->MOC-OBJ-TYPE
GWH-SORT-MX-CAT->MOC-MATRIX-CAT


GLTWHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Gltwlayout GLTWLAYOUT Delete Cascades
GWH-TW-NAME->GWL-TW-NAME
  GWL-LINE
  GWL-COLM-NBR
Gltwsel GLTWSEL Delete Cascades
GWH-TW-NAME->GWS-TW-NAME
  GWS-OR-GROUP
  GWS-MATRIX-CAT
  GWS-SEQ-NUMBER


File created: Thu Jun 09 02:14:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.