Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

UGSTAT


                              UGSTAT FILE

                           Upgrade Statistics

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

UGS-PATH               Alpha 20  (Lower Case)
Element: Path

UGS-UPGRADE-ID         Alpha 10
Element: Upgrade Id

UGS-RUN-GROUP          Alpha 15
Element: Run Group     Run Group and Seq Number are the keys
                       to the file.  They should be used to
                       group records together for interfacing.

UGS-SYSTEM-CD          Alpha 2
Element: System Code   This field indicates on what system the
                       transaction originated.

UGS-TYPE               Alpha 2
Element: Type          This identifies whether this record is
                       created because of a picking
                       transaction, or because of a return.
                       Valid values are:
                           "IS" = Picking transaction.
                           "RR" = Return.
                        ~$1 VENDOR
                       The vendor's identification code.


UGS-PROGRAM            Alpha 5
Element: Program       This field designates the program this
                       record was created by

UGS-FILE-NAME          Alpha 30  (Lower Case)
Element: File Name

UGS-PROC-GROUP         Alpha 10
Element: Proc Group    Contains the processing group (head
                       process level).The processing group
                       identifies a group of process levels.

UGS-WRITN              Numeric 12
Element: Written       Records written.

UGS-DUPS               Numeric 12
Element: Dups

UGS-UPDATED            Numeric 12
Element: Updated

UGS-MESSAGE            Alpha 64  (Lower Case)
Element: Text Comment

UGS-TIME               Numeric 8
Element: Time          This field is updated automatically to
                       indicate the time that the GL entry was
                       created. It is system-maintained.

UGS-TIME-SEQ           Numeric 12
Element: Sequence Number

UGS-DATE-STAMP         Numeric 8  (yyyymmdd)
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

UGS-TIME-STAMP         Numeric 6  (hhmmss)
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

UGS-USER               Alpha 10  (Lower Case)
Element: User

                         UGSTAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UGSSET1   PATH
          UPGRADE-ID
          RUN-GROUP
          SYSTEM-CD
          TYPE
          PROGRAM
          FILE-NAME

UGSSET2   PATH          Subset
          UPGRADE-ID    Where TYPE != "T "
          RUN-GROUP
          SYSTEM-CD
          FILE-NAME
          TYPE
          PROGRAM

UGSSET3   PATH
          UPGRADE-ID
          RUN-GROUP
          SYSTEM-CD
          PROGRAM
          TYPE
          FILE-NAME

UGSSET4   PATH
          UPGRADE-ID
          RUN-GROUP
          SYSTEM-CD
          PROGRAM
          FILE-NAME
          TYPE