Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              UGSTAT FILE

REFERENCED BY

UG999

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

UGS-UPGRADE-ID       Alpha 20
Upgrade Id

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

UGS-TYPE             Alpha 2
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
Program              This field designates the program this
                     record was created by

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

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

UGS-WRITN            Numeric 12
Written              Records written.

UGS-DUPS             Numeric 12
Dups

UGS-UPDATED          Numeric 12
Updated

UGS-TIME             Numeric 8
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
Sequence Number

UGS-DATE-STAMP       Numeric 8  (yyyymmdd)
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)
Time Stamp           Contains the server time (hour, minute,
                     and second) when the record was last
                     changed.

UGS-USER             Alpha 10  (Lower Case)
User

                         UGSTAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UGSSET1   UPGRADE-ID                                             UG999
          SYSTEM-CD
          TYPE
          PROGRAM
          FILE-NAME

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

UGSSET3   UPGRADE-ID
          SYSTEM-CD
          PROGRAM
          TYPE
          FILE-NAME