RWDRILL – Report Writer Drill Down

System
General Ledger (GL)
Prefix
RDD
Primary key
REQUEST-NAME, LINE-NBR, COL-POSITION
Fields
30
Updated by
2 programs
Referenced by
1 program

RWDRILL is the Report Writer Drill Down table in Lawson General Ledger (prefix RDD). It is indexed by REQUEST-NAME, LINE-NBR, COL-POSITION (RDDSET1). It is updated by RW00.1 and RW100 and referenced by RW80.1. The table has 30 fields, 1 index and 0 documented relations.

About RWDRILL

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

Fields (30)

Column = COBOL field name without the RDD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RDD-REQUEST-NAME PK
REQUEST_NAME		Alpha 12This is the name that identifies the report.RW100
#RDD-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the row line number.RW100
#RDD-COL-POSITION PK
COL_POSITION		Numeric 3This field indicates the column position.RW100
#RDD-FR-COMPANY
FR_COMPANY		Numeric 4This is the beginning company for the company range.RW100
#RDD-TH-COMPANY
TH_COMPANY		Numeric 4This is the ending company for the company range.RW100
#RDD-FR-VAR-LEVELS
FR_VAR_LEVELS		Alpha 30This is the beginning variable level for the range.RW100
#RDD-TH-VAR-LEVELS
TH_VAR_LEVELS		Alpha 30This is the ending variable level for the range.RW100
#RDD-FR-ACCOUNT
FR_ACCOUNT		Numeric 6This is the beginning account for a range of accounts.RW100
#RDD-TH-ACCOUNT
TH_ACCOUNT		Numeric 6This 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
FR_SUB_ACCT		Numeric 4This is the beginning subaccount for a range of subaccounts.RW100
#RDD-TH-SUB-ACCT
TH_SUB_ACCT		Numeric 4This is the ending subaccount for a range of subaccounts.RW100
#RDD-LVL-GRP-TYPE
LVL_GRP_TYPE		Alpha 1This 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
LEVEL_GROUP		Alpha 12This is the name that identifies the level group as defined in RW40.1 (Level Group).RW100
#RDD-ACCT-GROUP
ACCT_GROUP		Alpha 12This is the name that identifies the account group as defined in RW40.3 (Account Group).RW100
#RDD-SUB-ACCT-GRP
SUB_ACCT_GRP		Alpha 12This is the name that identifies the subaccount group as defined in RW40.4 (Subaccount Group).RW100
#RDD-OVD-ACCTUNIT
OVD_ACCTUNIT		Alpha 15 Occurs 4 Times ×4This is the accounting unit you are including in a row line for a Level Type or Both Type row.RW100
#RDD-PREV-COL-POS
PREV_COL_POS		Numeric 3This field indicates the previous column position.RW100
#RDD-CASE-CODE
CASE_CODE		Alpha 44The 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
RUN_YEAR_CODE		Alpha 1This field defines the run year code.RW100
#RDD-RUN-YEAR
RUN_YEAR		Numeric 4This field defines the run year.RW100
#RDD-ACCT-PERIOD
ACCT_PERIOD		Numeric 2This is the current period.RW100
#RDD-BAL-TYPE
BAL_TYPE		Alpha 1This field lets you include the net balance, only the debit balance, or only the credit balance on the row file.RW100
#RDD-AMOUNT
AMOUNT		Signed 18.2This is the amount for this accounting period for the specified record.RW100
#RDD-CHART-NAME
CHART_NAME		Alpha 12This 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
SUMRY_ACCT_ID		Numeric 6The summary account name as defined in GL00.1 (Chart of Accounts).RW100
#RDD-ACCOUNT-LIST
ACCOUNT_LIST		Alpha 12This is the name that identifies the account list as defined in MX10 (List) for object type ACCNT.RW100
#RDD-CLM-LVL-GROUP
CLM_LVL_GROUP		Alpha 12This is the level group name for a column override.RW100
#RDD-CLM-FR-VAR-LVL
CLM_FR_VAR_LVL		Alpha 30This is the beginning variable level range for a column override.RW100
#RDD-CLM-TH-VAR-LVL
CLM_TH_VAR_LVL		Alpha 30This is the ending variable level range for a column override.RW100
#RDD-LEDGER
LEDGER		Alpha 15The 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

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RDDSET1
  1. REQUEST-NAME
  2. LINE-NBR
  3. COL-POSITION
PrimaryRW00.1, RW100, RW80.1

Programs

Updated by (2)

Referenced by (1)