IATIMEMBR – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IAB
Primary key
DIMENSION-NAME, MBR-TIME-TYPE, MEMBER-NAME
Fields
3
Updated by
1 program
Referenced by
0 programs

IATIMEMBR is a Lawson Analytic Architect table (prefix IAB); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME, MBR-TIME-TYPE, MEMBER-NAME (IABSET1). It is updated by IATB.1. The table has 3 fields, 1 index and 0 documented relations.

About IATIMEMBR

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the IAB- 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
#IAB-DIMENSION-NAME PK
DIMENSION_NAME
Alpha 50 (Lower Case)The Dimension Name field contains the name of the Time dimension. This user-defined field can contain up to 50 characters of any kind.IATB.1
#IAB-MBR-TIME-TYPE PK
MBR_TIME_TYPE
Alpha 1The Member Time Type field specifies the type of time member. Valid values are:
  • Y Years
  • P Periods
  • Q Quarters
  • W Weeks
IATB.1
#IAB-MEMBER-NAME PK
MEMBER_NAME
Alpha 50 (Lower Case)The Member Name field contains the name of the time member.IATB.1

Indexes (1)

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
IABSET1
  1. DIMENSION-NAME
  2. MBR-TIME-TYPE
  3. MEMBER-NAME
PrimaryIATB.1

Programs

Updated by (1)