RWDRILL

Report Writer Drill Down

This file contains drill down detail information calculated by RW100 (Report Generation).
UPDATED BY
RW00.1 RW100 RW80.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RDD-REQUEST-NAME
Element: Request Name
Alpha 12
This is the name that identifies the report.
RW100
RDD-LINE-NBR
Element: Line Number
Numeric 6
This field contains the row line number.
RW100
RDD-COL-POSITION
Element: Column Position
Numeric 3
This field indicates the column position.
RW100
RDD-FR-COMPANY
Element: From Company
Numeric 4
This is the beginning company for the company range.
RW100
RDD-TH-COMPANY
Element: Through Company
Numeric 4
This is the ending company for the company range.
RW100
RDD-FR-VAR-LEVELS
Element: From Variable Level
Alpha 30
This is the beginning variable level for the range.
RW100
RDD-TH-VAR-LEVELS
Through Variable
Level
Alpha 30
This is the ending variable level for the range.
RW100
RDD-FR-ACCOUNT
Element: From Account
Numeric 6
This is the beginning account for a range of accounts.
RW100
RDD-TH-ACCOUNT
Element: Through Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
RW100
RDD-FR-SUB-ACCT
Element: From Subaccount
Numeric 4
This is the beginning subaccount for a range of subaccounts.
RW100
RDD-TH-SUB-ACCT
Element: Through Subaccount
Numeric 4
This is the ending subaccount for a range of subaccounts.
RW100
RDD-LVL-GRP-TYPE
Element: Level Group Type
Alpha 1
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
RW100
RDD-LEVEL-GROUP
Element: Level Group
Alpha 12
This is the name that identifies the level group as defined in RW40.1 (Level Group).
RW100
RDD-ACCT-GROUP
Element: Account Group
Alpha 12
This is the name that identifies the account group as defined in RW40.3 (Account Group).
RW100
RDD-SUB-ACCT-GRP
Element: Subaccount Group
Alpha 12
This is the name that identifies the subaccount group as defined in RW40.4 (Subaccount Group).
RW100
RDD-OVD-ACCTUNIT
Element: Accounting Unit
Alpha 15 Occurs 4 Times
This is the accounting unit you are including in a row line for a Level Type or Both Type row.
RW100
RDD-PREV-COL-POS
Previous Column
Position
Numeric 3
This field indicates the previous column position.
RW100
RDD-CASE-CODE
Element: Case Code
Alpha 44
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.
RW100
RDD-RUN-YEAR-CODE
Element: Run Year Code
Alpha 1
This field defines the run year code.
RW100
RDD-RUN-YEAR
Element: Run Year
Numeric 4
This field defines the run year.
RW100
RDD-ACCT-PERIOD
Element: Accounting Period
Numeric 2
This is the current period.
RW100
RDD-BAL-TYPE
Element: Balance Type
Alpha 1
This field lets you include the net balance, only the debit balance, or only the credit balance on the row file.
RW100
RDD-AMOUNT
Element: Amount
Signed 18.2
This is the amount for this accounting period for the specified record.
RW100
RDD-CHART-NAME
Element: Chart Name
Alpha 12
This is the name you assigned to the chart of accounts when you defined your company structure in the Lawson General Ledger system.
RW100
RDD-SUMRY-ACCT-ID
Element: Summary Account ID
Numeric 6
The summary account name as defined in GL00.1 (Chart of Accounts).
RW100
RDD-ACCOUNT-LIST
Element: Account List
Alpha 12
This is the name that identifies the account list as defined in MX10 (List) for object type ACCNT.
RW100
RDD-CLM-LVL-GROUP
Element: Column Level Group
Alpha 12
This is the level group name for a column override.
RW100
RDD-CLM-FR-VAR-LVL
Column From
Variable Level
Alpha 30
This is the beginning variable level range for a column override.
RW100
RDD-CLM-TH-VAR-LVL
Column Through
Variable Level
Alpha 30
This is the ending variable level range for a column override.
RW100
RDD-LEDGER
Element: Ledger
Alpha 15
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).
RW100


RWDRILL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RDDSET1 REQUEST-NAME
LINE-NBR
COL-POSITION
RW00.1 RW100
RW80.1


File created: Wed Jun 08 20:48:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.