SLTWSEL FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SWS-REPORT-NAME Alpha 20
Report Name
SWS-OR-GROUP Alpha 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.
SWS-SEQ-NUMBER Numeric 6
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system.
SWS-MATRIX-CAT Alpha 12
Attribute Attribute name assigned to an object
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
SWS-FR-MX-VAL Alpha 32
From Attribute Value Lower limit value of matrix category.
SWS-TH-MX-VAL Alpha 32
Through Attribute Upper limit value of matrix category.
Value Blank will default From Value.
SLTWSEL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SWSSET1 REPORT-NAME KeyChange
OR-GROUP
MATRIX-CAT
SEQ-NUMBER
SWSSET2 MATRIX-CAT KeyChange
REPORT-NAME
OR-GROUP
SEQ-NUMBER
|
