Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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
Request Name         This is the name that identifies the
                     report.


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


RDD-COL-POSITION     Numeric 3                                   RW100
Column Position      This field indicates the column
                     position.


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


RDD-TH-COMPANY       Numeric 4                                   RW100
Through Company      This is the ending company for the
                     company range.


RDD-FR-VAR-LEVELS    Alpha 30                                    RW100
From Variable Level  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
From Account         This is the beginning account for a
                     range of accounts.


RDD-TH-ACCOUNT       Numeric 6                                   RW100
Through Account      This is the ending account for a range
                     of accounts.

RDD-FR-SUB-ACCT      Numeric 4                                   RW100
From Subaccount      This is the beginning subaccount for a
                     range of subaccounts.


RDD-TH-SUB-ACCT      Numeric 4                                   RW100
Through Subaccount   This is the ending subaccount for a
                     range of subaccounts.


RDD-LVL-GRP-TYPE     Alpha 1                                     RW100
Level Group Type     This 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
Level Group          This is the name that identifies the
                     level group as defined in RW40.1 (Level
                     Group).


RDD-ACCT-GROUP       Alpha 12                                    RW100
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
Subaccount Group     This is the name that identifies the
                     subaccount group as defined in RW40.4
                     (Subaccount Group).


RDD-OVD-ACCTUNIT     Alpha 15 Occurs 4 Times                     RW100
Accounting Unit      This 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
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
Run Year Code        This field defines the run year code.

RDD-RUN-YEAR         Numeric 4                                   RW100
Run Year

RDD-ACCT-PERIOD      Numeric 2                                   RW100
Accounting Period    This is the current period.

RDD-BAL-TYPE         Alpha 1                                     RW100
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
Amount               This is the amount for this accounting
                     period for the specified record.


RDD-CHART-NAME       Alpha 12                                    RW100
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
Summary Account ID   The summary account name as defined in
                     GL00.1 (Chart of Accounts).


RDD-ACCOUNT-LIST     Alpha 12                                    RW100
Account List

RDD-CLM-LVL-GROUP    Alpha 12                                    RW100
Column Level Group   This 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
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