ACTWSEL – Activity Trans Writer Select
- System
- Activity Management (AC)
- Prefix
AWS- Primary key
TW-NAME,OR-GROUP,MATRIX-CAT,SEQ-NUMBER- Fields
- 6
- Updated by
- 2 programs
- Referenced by
- 2 programs
ACTWSEL is the Activity Trans Writer Select table in Lawson Activity Management (prefix AWS). It is indexed by TW-NAME, OR-GROUP, MATRIX-CAT, SEQ-NUMBER (AWSSET1). It is updated by AC55.1 and AC55.2 and referenced by AC255 and AC256. The table has 6 fields, 1 index and 0 documented relations.
About ACTWSEL
The Activity Management Transaction Writer Select file stores transaction writer report secondary values defined in AC55.1 (Transaction Writer).
Fields (6)
Column = COBOL field name without the AWS- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#AWS-TW-NAME PKTW_NAME | Alpha 12 | The name that identifies the Transaction Writer report. | AC55.1, AC55.2 |
#AWS-OR-GROUP PKOR_GROUP | Alpha 1 | This field determines how attribute information is grouped by creating an and/or condition. The "and" condition groups attributes, while the "or" condition separates "and" groups information for multiple attributes. Type the same character to group attributes with an "and" condition and a different character to group "or" conditions. The system interprets "and" conditions first. Note: The system identifies blank fields as a character. If you identify two attributes and type a character in this field for one attribute, the "or" condition defaults. For example, you want to compare totals for unreleased (0) transactions in period 12, released (1) transactions in period 12, and posted (5) transactions in period 12: FIELD VALUE RANGE OR GROUP -------------------------------------- Status 0-0 1 Period 12-12 1 Status 1-1 Period 12-12 Status 5-5 2 Period 12-12 2 The system looks at Trans Status 0-0 "and" Period 12-12 first, "or" Trans Status 1-1 "and" Period 12-12, "or" Trans Status 5-5 "and" Period 12-12. | AC55.1 |
#AWS-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | Attribute name assigned to Activity Management Transaction-type objects (object type ACTVY). Attributes are used in selection and sorting for the Transaction Writer. | AC55.1 |
#AWS-SEQ-NUMBER PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | AC55.1 |
#AWS-FR-MX-VALFR_MX_VAL | Alpha 32 | The beginning attribute value in an attribute range. | AC55.1 |
#AWS-TH-MX-VALTH_MX_VAL | Alpha 32 | The ending attribute value in an attribute range. | AC55.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AWSSET1 |
| Primary | AC255, AC256, AC55.1, AC55.2 |