Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RWHEADER


                             RWHEADER FILE

                          Report Writer Header

This file maintains Report Writer header information for Account Rows, Level
Rows, or Both Type Rows, Level Group, Account Group, Subaccount Group, Total
Range, or User Class.


REFERENCED BY

AC34.1    ACVW.1    ATVW.1    CA10.1    CA10.7    GL256
GL55.1    RW00.1    RW00.2    RW100     RW20.5    RW20.6
RW240     RW260     RW298     RW299     RW70.1    GLAV.1
GLCV.1    GLDM.3    GLVW.1    SLVW.1    RW01.1    RW01.2
RW201     FB11.1    FB111     FB160     FB211     FB296
FB60.1    FB95.1    FB95.2    FB95.3    FB95.4    FB95.5
FB95.6    GL298     GL90.6    GL94.1    GL94.2    GL94.3
GL94.4    GL94.5    GL94.6    GL94.7    GL95.1    GL95.2
GL95.3    GL95.4    GL95.5    GL95.6    GL95.7    GL95.8
GL95.9    GL96.1    GL96.2    GL96.3    GL96.4    GL96.5
GL97.1    GL97.2    GL97.3    GL97.4    GL97.5    GL97.6
GL97.7    GL97.8    GL97.9    GL98.1    GL98.2    GL98.3
GL98.4    GL98.5    GL99.1    GL99.2    GL99.3    GL99.4
GL99.5    GL99.6    FB20.2    FB201     RW203     RW215


UPDATED BY

FB01.2    RW03.2    RW10.2    RW10.3    RW10.4    RW10.8
RW11.1    RW11.2    RW11.3    RW11.4    RW210     RW40.1
RW40.3    RW40.4    RW40.5    RW40.6    RW40.7    RW40.8
RW60.1    RW60.2    RW60.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RWH-HEAD-TYPE          Alpha 1                                   FB01.2  RW03.2
Element: Head Type     This field identifies if it is a Row      RW10.2  RW10.3
                       Type, User Class, Total Range, or Group.  RW10.4  RW11.1
                                                                 RW11.2  RW11.3
                                                                 RW40.6  RW40.7
                       G = Level, Acct or Subacct Group          RW40.8  RW60.2
                       R = Row File
                       T = Total Range
                       U = User Class
                       B = Budget User Class

RWH-HEAD-NAME          Alpha 12                                  FB01.2  RW03.2
Element: Head Name     This is the name of a level, account or   RW10.2  RW10.3
                       subaccount group; row name; total range;  RW10.4  RW10.8
                       or user class.                            RW11.1  RW11.2
                                                                 RW11.3  RW40.5
                                                                 RW40.6  RW40.7
                                                                 RW40.8  RW60.2
                                                                 RW60.3

RWH-RECORD-TYPE        Alpha 1                                   RW10.2  RW10.3
Element: Record Type   This field identifies the type of         RW10.4  RW11.1
                       record defined.                           RW11.2  RW11.3
                                                                 RW40.6  RW40.7
                       A = Accounts                              RW40.8  RW60.2
                       B = Both Levels and Accts
                       L = Levels
                       R = Total Ranges
                       S = Subaccounts

RWH-RECORD-TYPE-1      Derived
Element: Record Type 1 This field is used for drill around. It
                       displays the Record Type field values.


RWH-FOLDER-NAME        Alpha 12                                  RW10.2  RW10.3
Element: Folder Name   This is the folder name as defined in     RW10.4  RW10.8
                       RW01.1 (Folder).                          RW11.1  RW11.2
                                                                 RW11.3  RW40.5
                                                                 RW40.6  RW40.7
                                                                 RW40.8  RW60.2
                                                                 RW60.3

RWH-DESCRIPTION        Alpha 30  (Lower Case)                    FB01.2  RW03.2
Element: Header DescripThis is the folder description.           RW10.2  RW10.3
                                                                 RW10.4  RW10.8
                                                                 RW100   RW11.1
                                                                 RW11.2  RW11.3
                                                                 RW40.5  RW40.6
                                                                 RW40.7  RW40.8
                                                                 RW60.2  RW60.3

RWH-PERSON-RESP        Alpha 15  (Lower Case)                    RW100   RW40.6
Element: Person Resp   This is the name of the person
                       responsible for this record.


RWH-NBR-LINES          Numeric 6                                 RW10.2  RW10.3
Element: Nbr Lines     This is the number of detail lines.       RW10.4  RW11.4
                                                                 RW40.1  RW40.3
                                                                 RW40.4  RW60.1

RWH-LINE-NBR           Numeric 6                                 RW10.2  RW10.3
Element: Line Nbr      This is the detail line number.           RW10.4  RW11.4
                                                                 RW210   RW40.1
                                                                 RW40.3  RW40.4
                                                                 RW40.6  RW40.7
                                                                 RW40.8  RW60.1

                         RWHEADER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RWHSET1   HEAD-TYPE                                              AC34.1  ACVW.1
          HEAD-NAME                                              ATVW.1  CA10.1
          RECORD-TYPE                                            CA10.7  GL256
                                                                 GL55.1  RW00.1
                                                                 RW00.2  RW10.2
                                                                 RW10.3  RW10.4
                                                                 RW10.6  RW10.7
                                                                 RW10.8  RW100
                                                                 RW11.1  RW11.2
                                                                 RW11.3  RW11.4
                                                                 RW20.5  RW20.6
                                                                 RW210   RW240
                                                                 RW260   RW298
                                                                 RW299   RW40.1
                                                                 RW40.2  RW40.3
                                                                 ...

RWHSET2   FOLDER-NAME   KeyChange                                RW01.1  RW01.2
          HEAD-TYPE                                              RW201   RW260
          HEAD-NAME
          RECORD-TYPE

RWHSET3   HEAD-NAME                                              AC34.1  FB11.1
          HEAD-TYPE                                              FB111   FB160
          RECORD-TYPE                                            FB211   FB296
                                                                 FB60.1  FB95.1
                                                                 FB95.2  FB95.3
                                                                 FB95.4  FB95.5
                                                                 FB95.6  GL298
                                                                 GL55.1  GL90.6
                                                                 GL94.1  GL94.2
                                                                 GL94.3  GL94.4
                                                                 GL94.5  GL94.6
                                                                 GL94.7  GL95.1
                                                                 GL95.2  GL95.3
                                                                 GL95.4  GL95.5
                                                                 GL95.6  GL95.7
                                                                 ...

RWHSET4   FOLDER-NAME   KeyChange, Subset                        RW240
          RECORD-TYPE   Where HEAD-TYPE = "G"
          HEAD-NAME

RWHSET5   FOLDER-NAME   KeyChange, Subset                        RW11.1  RW11.2
          HEAD-NAME     Where HEAD-TYPE = "R"                    RW11.3  RW210
          RECORD-TYPE

RWHSET6   FOLDER-NAME   KeyChange, Subset                        RW260
          HEAD-NAME     Where HEAD-TYPE = "T"
          RECORD-TYPE

RWHSET7   RECORD-TYPE   KeyChange, Subset                        RW210
          FOLDER-NAME   Where HEAD-TYPE = "R"
          HEAD-NAME

RWHSET8   HEAD-TYPE                                              RW210   RW298
          RECORD-TYPE
          HEAD-NAME

RWHSET9   HEAD-TYPE                                              FB01.1  FB01.2
          HEAD-NAME                                              FB20.2  FB201
                                                                 GL256   RW01.1
                                                                 RW01.2  RW03.1
                                                                 RW03.2  RW10.2
                                                                 RW10.3  RW10.4
                                                                 RW11.1  RW11.2
                                                                 RW11.3  RW201
                                                                 RW203   RW215

                         RWHEADER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Folder         GLCODES      Required

                            "F"                -> GCD-RECORD-TYPE
                            RWH-FOLDER-NAME    -> GCD-FOLDER-NAME
                            Spaces             -> GCD-PROCESS-GROUP
                            Spaces             -> GCD-SYSTEM
                            Zeroes             -> GCD-COMPANY

                         RWHEADER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account Group  RWGRPDET     Delete Cascades
                            Valid When RWH-HEAD-TYPE = "G"

                            "A"                -> RGD-RECORD-TYPE
                            RWH-HEAD-NAME      -> RGD-HEAD-NAME
                                                  RGD-RANGE-NUMBER

Buduser Class  RWUSER
                            Valid When RWH-HEAD-TYPE = "B"

                            RWH-HEAD-NAME      -> RWU-USER-CLASS
                                                  RWU-USERNAME

Fbheader       FBHEADER
                            Valid When RWH-HEAD-TYPE = "B"

                            RWH-HEAD-NAME      -> FBH-USER-CLASS
                                                  FBH-COMPANY
                                                  FBH-FISCAL-YEAR
                                                  FBH-BUDGET-NBR

Level Group    RWGRPDET     Delete Cascades
                            Valid When RWH-HEAD-TYPE = "G"

                            "L"                -> RGD-RECORD-TYPE
                            RWH-HEAD-NAME      -> RGD-HEAD-NAME
                                                  RGD-RANGE-NUMBER

Row Request    RWREQUEST    Delete Restricted
                            Valid When RWH-HEAD-TYPE = "R"

                            RWH-HEAD-NAME      -> RWR-ROW-FILE-NAME
                                                  RWR-REQUEST-NAME

Rowdetail      RWROWDET     Delete Cascades
                            Valid When RWH-HEAD-TYPE = "R"

                            RWH-RECORD-TYPE    -> RRD-RECORD-TYPE
                            RWH-HEAD-NAME      -> RRD-HEAD-NAME
                                                  RRD-LINE-NBR

Rwfolder       GLCODES      Delete Restricted
                            Valid When RWH-HEAD-TYPE = "U"

                            RWH-HEAD-NAME      -> GCD-USER-CLASS
                                                  GCD-FOLDER-NAME

Subacct Group  RWGRPDET     Delete Cascades
                            Valid When RWH-HEAD-TYPE = "G"

                            "S"                -> RGD-RECORD-TYPE
                            RWH-HEAD-NAME      -> RGD-HEAD-NAME
                                                  RGD-RANGE-NUMBER

Total Ranges   RWROWDET     Delete Cascades
                            Valid When RWH-HEAD-TYPE = "T"

                            "R"                -> RRD-RECORD-TYPE
                            RWH-HEAD-NAME      -> RRD-HEAD-NAME
                                                  RRD-LINE-NBR

User Class     RWUSER       Delete Cascades
                            Valid When RWH-HEAD-TYPE = "U"

                            RWH-HEAD-NAME      -> RWU-USER-CLASS
                                                  RWU-USERNAME