Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLTWHDR


                              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   Matrix attributes are selection
                       parameters used  to build a list of
                       objects (accounting  units). An
                       accounting unit list can be used for
                       reporting  and  processing objects.

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

GWH-HEAD-LAYOUT-2      Alpha 132  (Lower Case)                   GL55.1
Element: Head Layout 2

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

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).


                         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