ACTWSEL FILE
The Activity Management Transaction Writer Select file stores transaction
writer report secondary values defined in AC55.1 (Transaction Writer).
REFERENCED BY
AC255 AC256
UPDATED BY
AC55.1 AC55.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AWS-TW-NAME Alpha 12 AC55.1 AC55.2
Tw Name The name that identifies the Transaction
Writer report.
AWS-OR-GROUP Alpha 1 AC55.1
Or Group 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.
AWS-MATRIX-CAT Alpha 12 AC55.1
Attribute Attribute name assigned to Activity
Management Transaction-type objects
(object type ACTVY). Attributes are used
in selection and sorting for the
Transaction Writer.
AWS-SEQ-NUMBER Numeric 6 AC55.1
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system.
AWS-FR-MX-VAL Alpha 32 AC55.1
From Attribute Value The beginning attribute value in an
attribute range.
AWS-TH-MX-VAL Alpha 32 AC55.1
Through Attribute The ending attribute value in an
Value attribute range.
ACTWSEL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AWSSET1 TW-NAME AC255 AC256
OR-GROUP AC55.1 AC55.2
MATRIX-CAT
SEQ-NUMBER
AWSSET2 MATRIX-CAT KeyChange
TW-NAME
OR-GROUP
SEQ-NUMBER
|
