APPLICTYPE – Application Type

System
Analytic Architect (IA)
Prefix
IAA
Primary key
APPLIC-TYPE
Fields
10
Updated by
5 programs
Referenced by
13 programs

APPLICTYPE is the Application Type table in Lawson Analytic Architect (prefix IAA). It is indexed by APPLIC-TYPE (IAASET1). It is related 1:M to OLAPDBM. It is updated by CB590, IA01.1, IA01.3, IA100 and IASV.1 and referenced by IA05.1, IA05.3, IA10.1, IA10.2, IA11.1, IA11.3, IA120, IA13.1 and 5 more. The table has 10 fields, 1 index and 1 documented relation.

About APPLICTYPE

The Data Mart Type (APPLICTYPE) file stores the names of the Lawson applications that can be requested to supply information to the data mart. The information in this file comes from IA100 (Data Mart Type Load) or IA01.1 (Data Mart Types). The Lawson data marts currently available are: FIN = Financial Data Mart FND = Daily Reporting Data Mart AC = Activity Data Mart CMP = Compensation Data Mart SA = Sales Performance Data Mart CX = Case Carts Data Mart PO = Purchasing Data Mart WO = Work Order Data Mart

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
IAA-APPLIC-TYPE PK
APPLIC_TYPE		Alpha 3The Application Type file stores the names of the Lawson applications that can be requested to supply information to the OLAP database. The Lawson applications that are currently OLAP-ready are:
  • FIN Financial Analyzer
  • FND Daily Financial Analyzer
  • SA Sales Analyzer
  • CX Case Cart Analyzer
  • PO Purchasing Analyzer
  • WO Work Order Analyzer
CB590, IA01.1, IA01.3, IA100, IASV.1
IAA-DESCRIPTION
DESCRIPTION		Alpha 40 (Lower Case)The Description field contains a description of the data mart type.CB590, IA01.1, IA01.3, IA100, IASV.1
IAA-DEFN-PROGRAM
DEFN_PROGRAM		Alpha 5The Data Mart Setup Program field contains the name of the program that provides the dimensions, members, and data selection parameters required by the data mart.CB590, IA01.1, IA01.3, IA100, IASV.1
IAA-META-PROGRAM
META_PROGRAM		Alpha 6The Outline Build Program field contains the name of the program that the Analytic Architect system calls to supply the outline (description of the data) to the data mart. This may be the same program as the data values load program.IA01.1, IA01.3, IA100, IASV.1
IAA-EDIT-PROGRAM
EDIT_PROGRAM		Alpha 6—IA100
IAA-DATA-PROGRAM
DATA_PROGRAM		Alpha 6The Data Values Load program is the program that the Analytic Architect system calls to supply the data values to the data mart. This may be the same program as the Outline Build program.CB590, IA01.1, IA01.3, IA100, IASV.1
IAA-APPLIC-OWNER
APPLIC_OWNER		Alpha 1The Application Owner field specifies the owner of the application that is supplying data to the data mart. Valid values are:
  • L Lawson
  • U User-defined
CB590, IA01.1, IA01.3, IA100, IASV.1
IAA-DATA-INC-LOAD
DATA_INC_LOAD		Alpha 1The Incremental Data Load field specifies whether incremental data loads are allowed for the specified data mart type. Valid values are:
  • Y Yes
  • N No
CB590, IA01.1, IA01.3, IA100, IASV.1
IAA-ALLOW-MOVE
ALLOW_MOVE		Alpha 1The Allow Move field indicates whether the Outline Dimension Move window is accessible for this data mart type. The Outline Dimension Move window lets you specify the dimension that, in the outline, precedes the dimension that you are moving. Valid values are:
  • Y Yes
  • N No; Default value.
CB590, IA01.1, IA01.3, IA100, IASV.1
IAA-DATA-LOAD-NAME
DATA_LOAD_NAME		Alpha 12 (Lower Case)The Data Source Name field contains the unique name for the source containing the data values you are loading. You can define multiple data sources for a single data mart. Examples of data sources are programs or rules files. This user-defined name can contain up to 12 characters of any kind.CB590, IA01.1, IA01.3, IA100, IASV.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
IAASET1APPLIC-TYPEPrimaryCB590, IA01.1, IA01.3, IA05.1, IA05.3, IA10.1, IA10.2, IA100 +11 more

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
OlapdbmOLAPDBMIAA-APPLIC-TYPE → ODB-APPLIC-TYPE, → ODB-DATA-MART-NAME

Programs

Updated by (5)

Referenced by (13)