Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTWSEL


                              ACTWSEL FILE

                      Activity Trans Writer Select

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
Element: Tw Name       The name that identifies the Transaction
                       Writer report.

AWS-OR-GROUP           Alpha 1                                   AC55.1
Element: 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
Element: 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 interfaced into the
                       Lawson system.

AWS-FR-MX-VAL          Alpha 32                                  AC55.1
Element: Attribute ValuThe beginning attribute value in an
                       attribute range.

AWS-TH-MX-VAL          Alpha 32                                  AC55.1
Element: Attribute ValuThe ending attribute value in an
                       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