Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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