Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLRPTDEF


                             GLRPTDEF FILE

                          GL Report Definition

This file contains report parameters defined in Ledger Report Setup (GL50.1)
and inputs the parameters into GL290 (General Ledger Report) for report
processing.


REFERENCED BY

GL250

UPDATED BY

GL110     GL290     GL50.1    GL50.2    GL50.4    GL50.5

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLR-COMPANY            Numeric 4                                 GL110   GL50.1
Element: Company       The company number as defined in GL10.1   GL50.2  GL50.5
                       (Company).


GLR-REPORT-NAME        Alpha 20                                  GL50.1  GL50.2
Element: Report Name   The name that identifies the report.      GL50.5

GLR-DESCRIPTION        Alpha 30  (Lower Case)                    GL50.2  GL50.5
Element: Description   The report description.

GLR-CREATOR            Alpha 15                                  GL50.2  GL50.5
Element: Creator       The ID for the person that created the
                       report.


GLR-LAST-RUN-DATE      Numeric 8  (yyyymmdd)                     GL290   GL50.5
Element: Last Run Date Displays the last date the report was
                       run.


GLR-PRIMARY-SORT       Numeric 1                                 GL50.2
Element: Primary Sort  The primary report sort order.
                       1 = Levels, Account, Subacct
                       2 = Acct Unit, Account, Subacct
                       3 = Account, Subacct, Levels
                       4 = Account, Subacct, Acct Unit

GLR-TRANS-TYPE         Alpha 1                                   GL290   GL50.2
Element: Transaction TyDetermines if amounts or units are
                       processed in each transaction.
                       A = Amounts
                       B = Both Amounts and Units
                       U = Units

GLR-ACCT-ACTIVITY      Alpha 1                                   GL50.2
Element: Account ActiviDetermines the type of account activity
                       to be included in the report.

                       A = All Accounts
                       B = Beg Balance and Trans Activity
                       T = Transaction Activity Only

GLR-COMPLETE-FLAG      Alpha 1                                   GL50.1
Element: Complete Flag Indicates if the record is complete.
                       Y = Complete Record

GLR-LAST-ITEM-SEQ      Numeric 4                                 GL50.4
Element: Last Item SequThe last item sequence number.

GLR-TRN-DTL-SLECT      Numeric 2 Occurs 31 Times                 GL50.1
Element: Transaction DeIndicates the order that transaction
                       detail is selected.


GLR-SORT-ORDER         Numeric 1 Occurs 4 Times                  GL50.1  GL50.2
Element: Sort Order    The report sort order.
                       3 = 3rd Sort
                       4 = 4th Sort
                       5 = 5th Sort
                       6 = 6th Sort

GLR-PRT-TOTAL-FLG      Alpha 1 Occurs 3 Times                    GL50.1
Element: Print Total FlIndicates if totals are printed in the
                       report.

                       X = Print Total

GLR-PG-BREAK-FLAG      Alpha 1 Occurs 2 Times                    GL50.1
Element: Page Break FlaIndicates if page breaks occur at the
                       variable or account level.

                       X = Page Break

GLR-RUNNING-BAL        Alpha 1                                   GL50.2
Element: Running BalancIndicates if running balances are
                       included in the report.

                       Y = Yes
                       N = No

                         GLRPTDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLRSET1   COMPANY                                                GL110   GL250
          REPORT-NAME                                            GL290   GL50.1
                                                                 GL50.2  GL50.4
                                                                 GL50.5

                         GLRPTDEF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        GLSYSTEM     Required

                            GLR-COMPANY        -> GLS-COMPANY

                         GLRPTDEF FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Selection      GLRPTSEL

                            GLR-COMPANY        -> GRS-COMPANY
                            GLR-REPORT-NAME    -> GRS-REPORT-NAME
                                                  GRS-OR-GROUP
                                                  GRS-ITEM-NUMBER
                                                  GRS-SEQUENCE-NBR