IACUSTUSRS – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IUU
Primary key
LOGIN
Fields
5
Updated by
2 programs
Referenced by
1 program

IACUSTUSRS is a Lawson Analytic Architect table (prefix IUU); no description in the lawson data dictionary. It is indexed by LOGIN (IUUSET1); alternate indexes: IUUSET2. It is related 1:1 to IACUSTOMER and 1:M to IACUSTMART. It is updated by IA90.1 and IA90.3 and referenced by IA99.1. The table has 5 fields, 2 indexes and 2 documented relations.

About IACUSTUSRS

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the IUU- 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
#IUU-LOGIN PK
LOGIN		Alpha 30 (Lower Case)—IA90.3
#IUU-OLAP-PASSWORD
OLAP_PASSWORD		Alpha 25 (Lower Case)—IA90.3
#IUU-USER-TYPE
USER_TYPE		Alpha 1—
  • A Administrator
  • D Designer
  • U User
IA90.3
#IUU-E-MAIL-ADDRESS
E_MAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.—
#IUU-ASP-CUSTOMER SET2
ASP_CUSTOMER		Numeric 9—IA90.3

Indexes (2)

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
IUUSET1
  1. LOGIN
Primary, KeyChangeIA90.3, IA99.1
IUUSET2
  1. ASP-CUSTOMER
  2. LOGIN
KeyChangeIA90.1, IA90.3, IA90.4

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
IACUSTOMERIACUSTMARTIACUSTUSRS

One to one (1) — lookups and parents

RelationTableRulesConditionField map
IacustomerIACUSTOMERRequired
IUU-ASP-CUSTOMER→ICE-ASP-CUSTOMER

One to many (1) — child tables

RelationTableRulesConditionField map
IacustmartIACUSTMART
IUU-LOGIN→IUM-LOGIN
—→IUM-ASP-CUSTOMER
—→IUM-DATA-MART-NAME

Programs

Updated by (2)

Referenced by (1)