Upgrade Module – Lawson UG tables and programs

Upgrade Module (UG) in Lawson S3 v10 MSP6 has 5 tables, 20 online screens and 3 batch programs.

Tables (5)

TablePrefixDescriptionPrimary keyFields
UGCHKLSTUGCUpgrade checklist filePATH, SYSTEM-CD, JOB-TYPE, SEQ19
UGPARAMUGPUpgrade ParameterSYSTEM, RELEASE, REL-LEVEL, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6, KEY7, KEY8, SEQ-NUMBER13
UGPARAMXUGXNo description in the Lawson data dictionaryMAIN-KEY, KEY1-AL-15, KEY2-N-15, KEY3-AL-15, KEY4-N-15, KEY5-AL-15, KEY6-N-15, KEY7-AL-15, KEY8-N-1510
UGSTATUGSUpgrade StatisticsPATH, UPGRADE-ID, RUN-GROUP, SYSTEM-CD, TYPE, PROGRAM, FILE-NAME17
UGZLOGUGZNo description in the Lawson data dictionaryLOGFILENAME, PRIMARYKEY2

Online screens (20)

ScreenDescriptionUpdatesReferences
UG00.1Upgrade Setup22
UG00.2Advanced Setup10
UG00.3Upgrade Setup - Database Connectivity11
UG00.4Backup/Clear/Restore Setup Data20
UG95.1Upgrade Status03
UG95.2Program Status01
UG95.3Clear Statistics12
UG95.4File Statistics03
UG99.1Upgrade Menu10
UG99.2Main Screen11
UG99.3Detail Screen02
UG99.4Run All02
UG99.6Utilities11
UG99.7Job Info02
UG99.8Job Info Edit10
XJOB.1Definition Screen01
XSYS.1System Call10
XUGP.1Upgrade Parameters01
XUGP.2Suite definitions10
XUGS.1Ugstat Maintenance11

Batch programs (3)

ProgramDescriptionUpdatesReferences
PO983PO Line Item UNSPSC23
UG990Submit REORG11
UG991Submit Java program11

Other tables used by Upgrade Module programs (4)

ITEMMAST, POCOMPANY, POLINE, PROCUREGRP