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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
RDD-REQUEST-NAME PKREQUEST_NAME | Alpha 12 | This is the name that identifies the report. | RW100 |
RDD-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the row line number. | RW100 |
RDD-COL-POSITION PKCOL_POSITION | Numeric 3 | This field indicates the column position. | RW100 |
RDD-FR-COMPANYFR_COMPANY | Numeric 4 | This is the beginning company for the company range. | RW100 |
RDD-TH-COMPANYTH_COMPANY | Numeric 4 | This is the ending company for the company range. | RW100 |
RDD-FR-VAR-LEVELSFR_VAR_LEVELS | Alpha 30 | This is the beginning variable level for the range. | RW100 |
RDD-TH-VAR-LEVELSTH_VAR_LEVELS | Alpha 30 | This is the ending variable level for the range. | RW100 |
RDD-FR-ACCOUNTFR_ACCOUNT | Numeric 6 | This is the beginning account for a range of accounts. | RW100 |
RDD-TH-ACCOUNTTH_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-ACCTFR_SUB_ACCT | Numeric 4 | This is the beginning subaccount for a range of subaccounts. | RW100 |
RDD-TH-SUB-ACCTTH_SUB_ACCT | Numeric 4 | This is the ending subaccount for a range of subaccounts. | RW100 |
RDD-LVL-GRP-TYPELVL_GRP_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
| RW100 |
RDD-LEVEL-GROUPLEVEL_GROUP | Alpha 12 | This is the name that identifies the level group as defined in RW40.1 (Level Group). | RW100 |
RDD-ACCT-GROUPACCT_GROUP | Alpha 12 | This is the name that identifies the account group as defined in RW40.3 (Account Group). | RW100 |
RDD-SUB-ACCT-GRPSUB_ACCT_GRP | Alpha 12 | This is the name that identifies the subaccount group as defined in RW40.4 (Subaccount Group). | RW100 |
RDD-OVD-ACCTUNITOVD_ACCTUNIT | Alpha 15 Occurs 4 Times ×4 | This is the accounting unit you are including in a row line for a Level Type or Both Type row. | RW100 |
RDD-PREV-COL-POSPREV_COL_POS | Numeric 3 | This field indicates the previous column position. | RW100 |
RDD-CASE-CODECASE_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-CODERUN_YEAR_CODE | Alpha 1 | This field defines the run year code. | RW100 |
RDD-RUN-YEARRUN_YEAR | Numeric 4 | This field defines the run year. | RW100 |
RDD-ACCT-PERIODACCT_PERIOD | Numeric 2 | This is the current period. | RW100 |
RDD-BAL-TYPEBAL_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-AMOUNTAMOUNT | Signed 18.2 | This is the amount for this accounting period for the specified record. | RW100 |
RDD-CHART-NAMECHART_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-IDSUMRY_ACCT_ID | Numeric 6 | The summary account name as defined in GL00.1 (Chart of Accounts). | RW100 |
RDD-ACCOUNT-LISTACCOUNT_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-GROUPCLM_LVL_GROUP | Alpha 12 | This is the level group name for a column override. | RW100 |
RDD-CLM-FR-VAR-LVLCLM_FR_VAR_LVL | Alpha 30 | This is the beginning variable level range for a column override. | RW100 |
RDD-CLM-TH-VAR-LVLCLM_TH_VAR_LVL | Alpha 30 | This is the ending variable level range for a column override. | RW100 |
RDD-LEDGERLEDGER | 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 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RDDSET1 | REQUEST-NAME, LINE-NBR, COL-POSITION | Primary | RW00.1, RW100, RW80.1 |
Programs
Updated by (2)
Referenced by (1)
- RW80.1 Drill Around