Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PWACTVY


                              PWACTVY FILE

REFERENCED BY

PW110     PW510

UPDATED BY

PW90.1    PWI2.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAX-RUN-GRP            Alpha 10
Element: Base Name

PAX-ACTIVITY-GRP       Alpha 15
Element: Activity Grp

PAX-ACTIVITY-1         Alpha 15
Element: Activity

PAX-ACTIVITY-2         Alpha 15
Element: Activity

PAX-ACTIVITY-3         Alpha 15
Element: Activity

PAX-ACTIVITY-4         Alpha 15
Element: Activity

PAX-ACTIVITY-5         Alpha 15
Element: Activity

PAX-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description

PAX-COMPANY            Numeric 4
Element: Company

PAX-ACCT-UNIT          Alpha 15
Element: Acct Unit

PAX-ACCOUNT            Numeric 6
Element: Account

PAX-SUB-ACCT           Numeric 4
Element: Sub Acct

PAX-USR-STATUS         Alpha 2
Element: Usr Status

PAX-LONG-DESC          Alpha 60  (Lower Case)
Element: Long Desc

PAX-POSTING-FLAG       Alpha 1
Element: Posting Flag

PAX-BILLABLE-FLAG      Alpha 1
Element: Billable

PAX-CURRENCY-CODE      Alpha 5
Element: Currency Code

PAX-NEW-DETAIL-1       Numeric 15                                PW90.1  PWI2.1
Element: New Detail 1

PAX-NEW-DETAIL-2       Numeric 15                                PW90.1  PWI2.1
Element: New Detail 2

PAX-NEW-DETAIL-3       Numeric 15                                PW90.1  PWI2.1
Element: New Detail 3

PAX-NEW-DETAIL-4       Numeric 15                                PW90.1  PWI2.1
Element: New Detail 4

PAX-NEW-DETAIL-5       Numeric 15                                PW90.1  PWI2.1
Element: New Detail 5

PAX-NEW-LEVELS         Alpha 30                                  PW90.1  PWI2.1
Element: New Levels

PAX-ACCT-CATEGORY      Alpha 5
Element: Acct Category

PAX-WRKAC-ID           Numeric 10
Element: Numeric 1

PAX-PROJ-START-DT      Numeric 8  (yyyymmdd)
Element: Date

PAX-PROJ-FINISH-DT     Numeric 8  (yyyymmdd)
Element: Date

PAX-INTRF-STATUS       Numeric 10
Element: Intrf Status

PAX-MATRIX-CAT-1       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-1         Alpha 32
Element: Mx Value 1

PAX-MATRIX-CAT-2       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-2         Alpha 32
Element: Mx Value 2

PAX-MATRIX-CAT-3       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-3         Alpha 32
Element: Mx Value

PAX-MATRIX-CAT-4       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-4         Alpha 32
Element: Mx Value

PAX-MATRIX-CAT-5       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-5         Alpha 32
Element: Mx Value

PAX-MATRIX-CAT-6       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-6         Alpha 32
Element: Mx Value

PAX-MATRIX-CAT-7       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-7         Alpha 32
Element: Mx Value

PAX-MATRIX-CAT-8       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-8         Alpha 32
Element: Mx Value

PAX-MATRIX-CAT-9       Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-9         Alpha 32
Element: Mx Value

PAX-MATRIX-CAT-10      Alpha 12
Element: Matrix Cat

PAX-MX-VALUE-10        Alpha 32
Element: Mx Value

                         PWACTVY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAXSET1   RUN-GRP                                                PW110   PW510
          ACTIVITY-GRP                                           PW90.1  PWI2.1
          ACTIVITY-1
          ACTIVITY-2
          ACTIVITY-3
          ACTIVITY-4
          ACTIVITY-5

PAXSET2   ACTIVITY-GRP                                           PW110   PW510
          ACTIVITY-1                                             PW90.1  PWI2.1
          ACTIVITY-2
          ACTIVITY-3
          ACTIVITY-4
          ACTIVITY-5
          RUN-GRP