Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RWDRILL


                              RWDRILL FILE

                        Report Writer Drill Down

This file contains drill down detail information calculated by RW100 (Report
Generation).


REFERENCED BY

RW80.1

UPDATED BY

RW00.1    RW100

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RDD-REQUEST-NAME       Alpha 12                                  RW100
Element: Request Name  This is the name that identifies the
                       report.


RDD-LINE-NBR           Numeric 6                                 RW100
Element: Line Number   This field contains the row line
                       number.


RDD-COL-POSITION       Numeric 3                                 RW100
Element: Column PositioThis field indicates the column
                       position.


RDD-FR-COMPANY         Numeric 4                                 RW100
Element: From Company  This is the beginning company for the
                       company range.


RDD-TH-COMPANY         Numeric 4                                 RW100
Element: Through CompanThis is the ending company for the
                       company range.


RDD-FR-VAR-LEVELS      Alpha 30                                  RW100
Element: From Variable This is the beginning variable level
                       for the range.


RDD-TH-VAR-LEVELS      Alpha 30                                  RW100
Through Variable       This is the ending variable level for
Level                  the range.


RDD-FR-ACCOUNT         Numeric 6                                 RW100
Element: From Account  This is the beginning account for a
                       range of accounts.


RDD-TH-ACCOUNT         Numeric 6                                 RW100
Element: Through Account

RDD-FR-SUB-ACCT        Numeric 4                                 RW100
Element: From SubaccounThis is the beginning subaccount for a
                       range of subaccounts.


RDD-TH-SUB-ACCT        Numeric 4                                 RW100
Element: Through SubaccThis is the ending subaccount for a
                       range of subaccounts.


RDD-LVL-GRP-TYPE       Alpha 1                                   RW100
Element: Level Group TyThis is the level group included in a
                       row line when defining a Level Type
                       (RW10.3) or Both Type (RW10.4) of row

                       L = Level Group
                       C = Company Group
                       M = Accounting Unit Matrix List

RDD-LEVEL-GROUP        Alpha 12                                  RW100
Element: Level Group   This is the name that identifies the
                       level group as defined in RW40.1 (Level
                       Group).


RDD-ACCT-GROUP         Alpha 12                                  RW100
Element: Account Group This is the name that identifies the
                       account group as defined in RW40.3
                       (Account Group).


RDD-SUB-ACCT-GRP       Alpha 12                                  RW100
Element: Subaccount GroThis is the name that identifies the
                       subaccount group as defined in RW40.4
                       (Subaccount Group).


RDD-OVD-ACCTUNIT       Alpha 15 Occurs 4 Times                   RW100
Element: Accounting UniThis is the accounting unit you are
                       including in a row line for a Level Type
                       or Both Type row.


RDD-PREV-COL-POS       Numeric 3                                 RW100
Previous Column        This field indicates the previous
Position               column position.


RDD-CASE-CODE          Alpha 44                                  RW100
Element: Case Code     The case code is a representation of a
                       dictionary item used to execute and
                       process the item. The code is composed
                       of a series of alphanumeric codes that
                       describe attributes of the dictionary
                       item.


RDD-RUN-YEAR-CODE      Alpha 1                                   RW100
Element: Run Year Code This field defines the run year code.

RDD-RUN-YEAR           Numeric 4                                 RW100
Element: Run Year

RDD-ACCT-PERIOD        Numeric 2                                 RW100
Element: Accounting PerThis is the current period.

RDD-BAL-TYPE           Alpha 1                                   RW100
Element: Balance Type  This field lets you include the net
                       balance, only the debit balance, or only
                       the credit balance on the row file.


RDD-AMOUNT             Currency 15.2                             RW100
Element: Amount        This is the amount for this accounting
                       period for the specified record.


RDD-CHART-NAME         Alpha 12                                  RW100
Element: Chart Name    This is the name you assigned to the
                       chart of accounts when you defined your
                       company structure in the Lawson General
                       Ledger system.


RDD-SUMRY-ACCT-ID      Numeric 6                                 RW100
Element: Summary AccounThe summary account name as defined in
                       GL00.1 (Chart of Accounts).


RDD-ACCOUNT-LIST       Alpha 12                                  RW100
Element: Account List

RDD-CLM-LVL-GROUP      Alpha 12                                  RW100
Element: Column Level GThis is the level group name for a
                       column override.


RDD-CLM-FR-VAR-LVL     Alpha 30                                  RW100
Column From            This is the beginning variable level
Variable Level         range for a column override.


RDD-CLM-TH-VAR-LVL     Alpha 30                                  RW100
Column Through         This is the ending variable level range
Variable Level         for a column override.


RDD-LEDGER             Alpha 15                                  RW100
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).


                         RWDRILL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RDDSET1   REQUEST-NAME                                           RW00.1  RW100
          LINE-NBR                                               RW80.1
          COL-POSITION