Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

UGCHKLST


                             UGCHKLST FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

UGC-JOB-TYPE           Alpha 10  (Lower Case)
Element: Job Type

UGC-SEQ                Numeric 3
Element: Sequence NumbeThis field contains the record sequence
                       number.

UGC-UPG-OBJECT         Alpha 14  (Lower Case)
Element: Upg Object

UGC-BATCH-INT          Alpha 1
Tax Distrib. Flag -
Tax Code 1

UGC-SRC-TRG            Alpha 1
Tax Distrib. Flag -
Tax Code 1

UGC-HAS-PARMS          Alpha 1
Tax Distrib. Flag -
Tax Code 1

UGC-IS-REQUIRED        Alpha 1
Tax Distrib. Flag -
Tax Code 1

UGC-EXCLUDE-IF         Alpha 2
Element: System Code

UGC-INCLUDE-IF         Alpha 2
Element: System Code

UGC-MISC1              Alpha 2
Element: System Code

UGC-MISC2              Alpha 2
Element: System Code

UGC-MISC3              Alpha 16
Element: Misc

UGC-PREREQ-GRP         Alpha 2
Element: System Code

UGC-PREREQ-SEQ         Numeric 3
Element: Sequence Number

UGC-PREREQ-TYPE        Alpha 1
Tax Distrib. Flag -
Tax Code 1

UGC-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field displays the description.

                         UGCHKLST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UGCSET1   PATH
          SYSTEM-CD
          JOB-TYPE
          SEQ

UGCSET2   PATH          Subset
          PREREQ-GRP    Where (PREREQ-GRP != Spaces )
          PREREQ-SEQ

UGCSET3   PATH
          UPG-OBJECT
          SYSTEM-CD
          JOB-TYPE
          SEQ

UGCSET4   PATH          Subset
          SYSTEM-CD     Where (SYSTEM-CD = Spaces )
          JOB-TYPE
          SEQ

UGCSET5   PATH          Subset
          UPG-OBJECT    Where (JOB-TYPE = "match     " )