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

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                                 RW590   RW591
Element: Item Length   This is the default size of the
                       dictionary item.


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)

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
                       49 = Activity Acmaster

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

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

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