ACRANGEDTL – Activity Total Range Detail
- System
- Activity Management (AC)
- Prefix
RDT- Primary key
AC-HEAD-NAME,LINE-NBR- Fields
- 11
- Updated by
- 2 programs
- Referenced by
- 11 programs
ACRANGEDTL is the Activity Total Range Detail table in Lawson Activity Management (prefix RDT). It is indexed by AC-HEAD-NAME, LINE-NBR (RDTSET1). It is related 1:1 to MXLISTHDR, ACACTIVITY, ACCATGRP, ACRANGEHDR, GLCPYGRP, GLNAMES and GLSYSTEM. It is updated by AC36.1 and AC36.2 and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 3 more. The table has 11 fields, 1 index and 8 documented relations.
About ACRANGEDTL
No description in the Lawson data dictionary.
Fields (11)
Column = COBOL field name without the RDT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
RDT-AC-HEAD-NAME PKAC_HEAD_NAME | Alpha 10 | — | AC36.1 |
RDT-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | AC36.1 |
RDT-AC-MATRIX-LISTAC_MATRIX_LIST | Alpha 12 | Activity List. | AC36.1 |
RDT-ACTIVITYACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | AC36.1 |
RDT-FR-ACCT-CATFR_ACCT_CAT | Alpha 5 | Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru | AC36.1 |
RDT-TH-ACCT-CATTH_ACCT_CAT | Alpha 5 | Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru | AC36.1 |
RDT-GROUPGROUP | Alpha 15 | — | AC36.1 |
RDT-COMPANYCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | AC36.1 |
RDT-COMPANY-GROUPCOMPANY_GROUP | Alpha 12 | You can type or select a company group. A company group represents one or more companies. If you select a company group, leave the Company field blank. | AC36.1 |
RDT-AU-MATRIX-LISTAU_MATRIX_LIST | Alpha 12 | — | AC36.1 |
RDT-ACCT-UNITACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | AC36.1 |
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 |
|---|---|---|---|---|
RDTSET1 | AC-HEAD-NAME, LINE-NBR | Primary | AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Ac Mxlisthdr | MXLISTHDR | Not Required | "ACTVY" → MLH-OBJ-TYPE, RDT-AC-MATRIX-LIST → MLH-MATRIX-LIST | |
| Acactivity | ACACTIVITY | Not Required | RDT-ACTIVITY → ACV-ACTIVITY | |
| Accatgrp | ACCATGRP | Not Required | RDT-GROUP → CGP-CAT-GROUP | |
| Acrangehdr | ACRANGEHDR | Required | RDT-AC-HEAD-NAME → RHD-AC-HEAD-NAME | |
| Au Mxlisthdr | MXLISTHDR | Not Required | "ACCTU" → MLH-OBJ-TYPE, RDT-AU-MATRIX-LIST → MLH-MATRIX-LIST | |
| Glcpygrp | GLCPYGRP | Not Required | RDT-COMPANY-GROUP → GCG-COMPANY-GROUP | |
| Glnames | GLNAMES | Not Required | RDT-COMPANY → GLN-COMPANY, RDT-ACCT-UNIT → GLN-ACCT-UNIT | |
| Glsystem | GLSYSTEM | Not Required | RDT-COMPANY → GLS-COMPANY |