IACUSTOMER – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
ICE
Primary key
ASP-CUSTOMER
Fields
10
Updated by
3 programs
Referenced by
2 programs

IACUSTOMER is a Lawson Analytic Architect table (prefix ICE); no description in the lawson data dictionary. It is indexed by ASP-CUSTOMER (ICESET1); alternate indexes: ICESET2. It is related 1:1 to IAASPGROUP and 1:M to IACUSTMART and IACUSTUSRS. It is updated by IA90.1, IA90.3 and IA90.4 and referenced by IA199 and IA99.1. The table has 10 fields, 2 indexes and 3 documented relations.

About IACUSTOMER

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the ICE- 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
#ICE-ASP-CUSTOMER PK
ASP_CUSTOMER		Numeric 9—IA90.1
#ICE-NAME
NAME		Alpha 30 (Lower Case)Displays the company description.IA90.1
#ICE-DATABASE-TYPE
DATABASE_TYPE		Alpha 1——
#ICE-NBR-OF-MARTS
NBR_OF_MARTS		Numeric 4—IA90.1
#ICE-NBR-OF-USERS
NBR_OF_USERS		Numeric 4—IA90.1
#ICE-SERVER-NAME
SERVER_NAME		Alpha 40 (Lower Case)The Server Name field contains the IP address of the server to which you are connecting. You can also specify a name that has been associated with the server (DNS name).IA90.1
#ICE-MAXIMUM-VALUES
MAXIMUM_VALUES		Numeric 15——
#ICE-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.IA90.1
#ICE-HOME-DIRECTORY
HOME_DIRECTORY		Alpha 100 (Lower Case)—IA90.1
#ICE-ASP-GROUP SET2
ASP_GROUP		Alpha 10—IA90.1

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
ICESET1
  1. ASP-CUSTOMER
Primary, KeyChangeIA90.1, IA90.3, IA90.4, IA99.1
ICESET2
  1. ASP-GROUP
  2. ASP-CUSTOMER
KeyChangeIA199, IA90.2

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
IaaspgroupIAASPGROUPRequired
ICE-ASP-GROUP→IAG-ASP-GROUP

One to many (2) — child tables

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

Programs

Updated by (3)

Referenced by (2)