Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RWDICT


                              RWDICT FILE

                        Report Writer Dictionary

This file contains the dictionary names to be used in the Report Writer
system. The dictionary names are predetermined by Lawson and are loaded by
running RW590 (Data Dictionary Load) when the Lawson General Ledger system is
installed.


REFERENCED BY

FB141     GL292     GL293     GL294     GL95.4    GL99.1
RW100     RW20.1    RW20.2    RW205     RW50.1    SNGL.1


UPDATED BY

RW590     RW591

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RWD-DICT-NAME          Alpha 6                                   RW590   RW591
Element: Dictionary NamThis is the name of the dictionary
                       item.


RWD-DESCRIPTION        Alpha 30  (Lower Case)                    RW590   RW591
Dictionary             This is the dictionary item
Description            description.


RWD-REQUIREMENTS       Alpha 60  (Lower Case)                    RW590   RW591
Element: Requirements  Occurs 5 Times
                       This field contains additional
                       description and examples.


RWD-LENGTH             Numeric 2                                 FB141   GL292
Element: Item Length   This is the default size of the           GL293   GL294
                       dictionary item.                          GL95.4  GL99.1
                                                                 RW20.1  RW20.2
                                                                 RW590   RW591
                                                                 SNGL.1

RWD-CASE1              Numeric 2                                 RW590   RW591
Element: Case1         This field is used to direct the
                       processing of General Ledger dictionary
                       items.

                       01 = Positive Literal
                       02 = Negative Literal
                       03 = Alpha Dictnry Name (Hdr & Row)
                       04 = Numeric Dictionary Name
                       05 = Alpha Dictnry Name (Hdr Only)
                       06 = Alpha Dictnry Name (Date Time)
                       07 = Character String

RWD-CASE2              Numeric 2                                 RW590   RW591
Element: Case2         This field is used to direct the
                       processing of General Ledger dictionary
                       items.

                       01 = Column Value
                       02 = Amount Glmaster
                       03 = Unit Glunits
                       04 = Budget Fbdetail
                       05 = Total Ratotals
                       06 = Currency Cuamount
                       08 = Units Fbdetail
                       09 = Rpt Currency Cuamount
                       10
                       11
                       12
                       13
                       14
                       15
                       16
                       17
                       18
                       19
                       20
                       21
                       22
                       23
                       24
                       25
                       26
                       50
                       51
                       52
                       53
                       54
                       55
                       56
                       57
                       58
                       59

RWD-CASE3              Numeric 2                                 RW590   RW591
Element: Case3         This field is used to direct the
                       processing of General Ledger dictionary
                       items.

                       01 = Last Year Value
                       02 = Current Year Value
                       03 = Next Year Value
                       00
                       05 = Previous Year Value
                       06
                       07
                       08
                       09
                       10

RWD-CASE4              Numeric 2                                 RW590   RW591
Element: Case4         This field is used to direct the
                       processing of General Ledger dictionary
                       items.

                       01 = Current Period Value
                       02 = Specified Period Value
                       03 = Beginning Balance
                       04 = Year to Date Value
                       05 = Year Total Value
                       06 = Previous Period Value
                       07 = Current Quarter Value
                       08 = Specified Quarter Value
                       09 = Quarter-to-Date Value
                       10 = Life-to-Date
                       11
                       12
                       13
                       14
                       15
                       16
                       17
                       18
                       19
                       20
                       21

RWD-CASE1-NBR          Derived
Element: Case Number 1 This field is used for drill around. It
                       displays the Case Number 1 field values.



RWD-CASE2-NBR          Derived
Element: Case Number 2 This field is used for drill around. It
                       displays the Case Number 2 field values.



RWD-CASE3-NBR          Derived
Element: Case Number 3 This field is used for drill around. It
                       displays the Case Number 3 field values.



RWD-CASE4-NBR          Derived
Element: Case Number 4 This field is used for drill around. It
                       displays the Case Number 4 field values.



                         RWDICT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RWDSET1   DICT-NAME                                              FB141   GL292
                                                                 GL293   GL294
                                                                 GL95.4  GL99.1
                                                                 RW100   RW20.1
                                                                 RW20.2  RW205
                                                                 RW50.1  RW590
                                                                 RW591   SNGL.1