UGPARAMX – No description in the Lawson data dictionary

System
Upgrade Module (UG)
Prefix
UGX
Primary key
MAIN-KEY, KEY1-AL-15, KEY2-N-15, KEY3-AL-15, KEY4-N-15, KEY5-AL-15, KEY6-N-15, KEY7-AL-15, KEY8-N-15
Fields
10
Updated by
2 programs
Referenced by
0 programs

UGPARAMX is a Lawson Upgrade Module table (prefix UGX); no description in the lawson data dictionary. It is indexed by MAIN-KEY, KEY1-AL-15, KEY2-N-15, KEY3-AL-15, KEY4-N-15, KEY5-AL-15, KEY6-N-15, KEY7-AL-15, KEY8-N-15 (UGXSET1); alternate indexes: UGXSET2 and UGXSET3. It is updated by UG00.1 and UG00.4. The table has 10 fields, 3 indexes and 0 documented relations.

About UGPARAMX

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the UGX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
UGX-MAIN-KEY PK
MAIN_KEY
Alpha 30 (Lower Case)UG00.4
UGX-KEY1-AL-15 PK
KEY1_AL_15
Alpha 15 (Lower Case)UG00.4
UGX-KEY2-N-15 PK
KEY2_N_15
Numeric 15UG00.4
UGX-KEY3-AL-15 PK
KEY3_AL_15
Alpha 15 (Lower Case)UG00.4
UGX-KEY4-N-15 PK
KEY4_N_15
Numeric 15UG00.4
UGX-KEY5-AL-15 PK
KEY5_AL_15
Alpha 15 (Lower Case)UG00.4
UGX-KEY6-N-15 PK
KEY6_N_15
Numeric 15UG00.4
UGX-KEY7-AL-15 PK
KEY7_AL_15
Alpha 15 (Lower Case)UG00.4
UGX-KEY8-N-15 PK
KEY8_N_15
Numeric 15UG00.4
UGX-DATA
DATA
Alpha 512 (Lower Case)UG00.4

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
UGXSET1MAIN-KEY, KEY1-AL-15, KEY2-N-15, KEY3-AL-15, KEY4-N-15, KEY5-AL-15, KEY6-N-15, KEY7-AL-15, KEY8-N-15Primary, KeyChangeUG00.1, UG00.4
UGXSET2MAIN-KEY, KEY1-AL-15, KEY3-AL-15, KEY5-AL-15, KEY7-AL-15, KEY2-N-15, KEY4-N-15, KEY6-N-15, KEY8-N-15KeyChange
UGXSET3MAIN-KEY, KEY2-N-15, KEY4-N-15, KEY6-N-15, KEY8-N-15, KEY1-AL-15, KEY3-AL-15, KEY5-AL-15, KEY7-AL-15KeyChange

Programs

Updated by (2)