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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 15—UG00.4
#UGX-KEY3-AL-15 PK
KEY3_AL_15		Alpha 15 (Lower Case)—UG00.4
#UGX-KEY4-N-15 PK
KEY4_N_15		Numeric 15—UG00.4
#UGX-KEY5-AL-15 PK
KEY5_AL_15		Alpha 15 (Lower Case)—UG00.4
#UGX-KEY6-N-15 PK
KEY6_N_15		Numeric 15—UG00.4
#UGX-KEY7-AL-15 PK
KEY7_AL_15		Alpha 15 (Lower Case)—UG00.4
#UGX-KEY8-N-15 PK
KEY8_N_15		Numeric 15—UG00.4
#UGX-DATA
DATA		Alpha 512 (Lower Case)—UG00.4

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
UGXSET1
  1. MAIN-KEY
  2. KEY1-AL-15
  3. KEY2-N-15
  4. KEY3-AL-15
  5. KEY4-N-15
  6. KEY5-AL-15
  7. KEY6-N-15
  8. KEY7-AL-15
  9. KEY8-N-15
Primary, KeyChangeUG00.1, UG00.4
UGXSET2
  1. MAIN-KEY
  2. KEY1-AL-15
  3. KEY3-AL-15
  4. KEY5-AL-15
  5. KEY7-AL-15
  6. KEY2-N-15
  7. KEY4-N-15
  8. KEY6-N-15
  9. KEY8-N-15
KeyChange—
UGXSET3
  1. MAIN-KEY
  2. KEY2-N-15
  3. KEY4-N-15
  4. KEY6-N-15
  5. KEY8-N-15
  6. KEY1-AL-15
  7. KEY3-AL-15
  8. KEY5-AL-15
  9. KEY7-AL-15
KeyChange—

Programs

Updated by (2)