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.
UPDATED BY
GL256 | GL55.1 | GL55.2 | GL255 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
GWH-TW-NAME Element: Name | Alpha 12 The name that identifies the report. |
|
||||
GWH-COMPLETE-FLAG Element: Complete Flag | Alpha 1 Indicates if the record is complete. Y = Complete N = Incomplete |
|
||||
GWH-FOLDER-NAME Element: Folder Name | Alpha 12 This is the name of a folder. Folders are defined in RW01.1 (Folder). |
|
||||
GWH-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The transaction writer report description. |
|
||||
GWH-COLM-SPACING Element: Column Spacing | Numeric 2 The default value used for creating spaces between columns. Valid values are 0-99. |
|
||||
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 |
|
||||
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. |
|
||||
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 |
|
||||
GWH-LAST-RUN-DATE Element: Last Run Date | Numeric 8 (yyyymmdd) The last date the record was processed. |
|
||||
GWH-LAST-RUN-TIME Element: Last Run Time | Numeric 6 (hhmmss) The last time the record was processed. |
|
||||
GWH-COMPANY Element: Company | Numeric 4 The company number as defined in GL10.1 (Company). |
|
||||
GWH-ACCT-UNIT Element: Accounting Unit | Alpha 15 The valid accounting unit used in conjunction with the company field. |
|
||||
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. |
|
||||
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. |
|
||||
GWH-FR-ACCOUNT Element: From Account | Numeric 6 The beginning account for a range of accounts. |
|
||||
GWH-TH-ACCOUNT Element: To Account | Numeric 6 The ending account for a range of accounts. |
|
||||
GWH-ACCT-GROUP Element: Account Group | Alpha 12 An account group as defined in RW40.3 (Account Group). |
|
||||
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. |
|
||||
GWH-SUMMARY-ACCT Element: Summary Account | Alpha 12 The summary account used in conjunction with the chart name. |
|
||||
GWH-FR-SUB-ACCT Element: From Subaccount | Numeric 4 The beginning subaccount for a range of subaccounts. |
|
||||
GWH-TH-SUB-ACCT Element: Through Subaccount | Numeric 4 The ending subaccount for a range of subaccounts. |
|
||||
GWH-SUB-ACCT-GRP Element: Subaccount Group | Alpha 12 A subaccount group as defined in RW40.4 (Subaccount Group). |
|
||||
GWH-LAST-SEQ-NBR Element: Last Sequence Number | Numeric 6 The last transaction sequence number. |
|
||||
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. |
|
||||
GWH-HEAD-LAYOUT-1 Element: Head Layout 1 | Alpha 132 (Lower Case) The Header Layout line one. |
|
||||
GWH-HEAD-LAYOUT-2 Element: Head Layout 2 | Alpha 132 (Lower Case) The header layout line two. |
|
||||
GWH-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.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. |
|
||||
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). |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GWHSET1 |
TW-NAME |
|
| ||||||||||
GWHSET2 |
FOLDER-NAME TW-NAME |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Folder | GLCODES |
Required
| |||||||||||||||
Glchart | GLCHART |
Not Required
| |||||||||||||||
Glchartsum | GLCHARTSUM |
Not Required
| |||||||||||||||
Glnames | GLNAMES |
Not Required
| |||||||||||||||
Glsystem | GLSYSTEM |
Not Required
| |||||||||||||||
Mxlisthdr | MXLISTHDR |
Not Required
| |||||||||||||||
Mxobjcat | MXOBJCAT |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Gltwlayout | GLTWLAYOUT |
Delete Cascades
| ||||||||||||
Gltwsel | GLTWSEL |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.