|
|
GLTWHDR FILE
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 Alpha 12 GL55.1 GL55.2
Element: Name The name that identifies the report.
GWH-COMPLETE-FLAG Alpha 1 GL55.1
Element: Complete Flag Indicates if the record is complete.
Y = Complete
N = Incomplete
GWH-FOLDER-NAME Alpha 12 GL55.1 GL55.2
Element: Folder Name This is the name of a folder. Folders
are defined in RW01.1 (Folder).
GWH-DESCRIPTION Alpha 30 (Lower Case) GL55.1 GL55.2
Element: Description The transaction writer report
description.
GWH-COLM-SPACING Numeric 2 GL55.1
Element: Column SpacingThe default value used for creating
spaces between columns. Valid values are
0-99.
GWH-COLM-HEAD-OPT Alpha 1 GL55.1
Column Heading Determines whether the two column
Option heading lines are controlled manually or
by the system (automatic).
A = Automatic
M = Manual
GWH-CSV-OUTPUT Alpha 1 GL55.1
Element: CSV Output 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.
GWH-SEARCH-METHOD Alpha 1 GL55.1
Element: Search Method 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
GWH-LAST-RUN-DATE Numeric 8 (yyyymmdd) GL256 GL55.1
Element: Last Run Date The last date the record was processed. GL55.2
GWH-LAST-RUN-TIME Numeric 6 (hhmmss) GL256 GL55.1
Element: Last Run Time The last time the record was processed. GL55.2
GWH-COMPANY Numeric 4 GL55.1
Element: Company The company number as defined in GL10.1
(Company).
GWH-ACCT-UNIT Alpha 15 GL55.1
Element: Accounting UniThe valid accounting unit used in
conjunction with the company field.
GWH-COMPANY-GROUP Alpha 12 GL55.1
Element: Company Group A valid company group. All accounting
units within each of the companies in
the group are included.
GWH-MATRIX-LIST Alpha 12 GL55.1
Element: Matrix List The Accounting unit list is one of the
organizational parameter options as
defined in MX10 (List) for object type
ACCTU.
GWH-FR-ACCOUNT Numeric 6 GL55.1
Element: From Account The beginning account for a range of
accounts.
GWH-TH-ACCOUNT Numeric 6 GL55.1
Element: To Account The ending account for a range of
accounts.
GWH-ACCT-GROUP Alpha 12 GL55.1
Element: Account Group An account group as defined in RW40.3
(Account Group).
GWH-CHART-NAME Alpha 12 GL55.1
Element: Chart Name The name assigned to the chart of
accounts when you defined your company
structure in the General Ledger system.
GWH-SUMMARY-ACCT Alpha 12 GL55.1
Element: Summary AccounThe summary account used in conjunction
with the chart name.
GWH-FR-SUB-ACCT Numeric 4 GL55.1
Element: From SubaccounThe beginning subaccount for a range of
subaccounts.
GWH-TH-SUB-ACCT Numeric 4 GL55.1
Element: Through SubaccThe ending subaccount for a range of
subaccounts.
GWH-SUB-ACCT-GRP Alpha 12 GL55.1
Element: Subaccount GroA subaccount group as defined in RW40.4
(Subaccount Group).
GWH-LAST-SEQ-NBR Numeric 6 GL55.1
Element: Last Sequence The last transaction sequence number.
GWH-SORT-MX-CAT Alpha 12 Occurs 8 Times GL55.1
Element: Sort Matrix CaThere 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.
GWH-HEAD-LAYOUT-1 Alpha 132 (Lower Case) GL55.1
Element: Head Layout 1 The Header Layout line one.
GWH-HEAD-LAYOUT-2 Alpha 132 (Lower Case) GL55.1
Element: Head Layout 2 The header layout line two.
GWH-CURRENCY-CODE Alpha 5 GL55.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
GWH-ACCOUNT-LIST Alpha 12 GL55.1
Element: Account List The Account List is one of the Account
parameter options as defined in MX10
(List) for object type ACCNT.
GWH-LEDGER Alpha 15
Element: Ledger 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 Alpha 12 GL55.1
Element: Level Group The Level Group is one of the
organizational parameter options as
defined in RW40.1 (Level Group).
GLTWHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GWHSET1 TW-NAME GL255 GL256
GL55.1 GL55.2
GWHSET2 FOLDER-NAME KeyChange GL255
TW-NAME
GLTWHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
