AMIAMEADIM – This file contains the measures which shall be output to the AM data mart.

System
Asset Management (AM)
Prefix
IMD
Primary key
MEAS-DIMENSION
Fields
26
Updated by
1 program
Referenced by
3 programs

AMIAMEADIM is the This file contains the measures which shall be output to the AM data mart. table in Lawson Asset Management (prefix IMD). It is indexed by MEAS-DIMENSION (IMDSET1). It is updated by AM88.3 and referenced by AMDL.1, AMDM.1 and AMME.1. The table has 26 fields, 1 index and 0 documented relations.

About AMIAMEADIM

This file contains the measures which shall be output to the AM data mart. A flag is provided for each measure to allow the operator to choose the measures needed.

Fields (26)

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

Field / columnTypeDescription & valuesUpdated by
IMD-MEAS-DIMENSION PK
MEAS_DIMENSION
Alpha 50 (Lower Case)The Measures Dimension Name field contains the user-defined name for the Measures dimension. This name can contain up to 30 characters of any kind.AM88.3
IMD-BA-COST-MEMBER
BA_COST_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-BA-COST-FLAG
BA_COST_FLAG
Alpha 1AM88.3
IMD-TR-COST-MEMBER
TR_COST_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-TR-COST-FLAG
TR_COST_FLAG
Alpha 1AM88.3
IMD-BASIS-MEMBER
BASIS_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-BASIS-FLAG
BASIS_FLAG
Alpha 1AM88.3
IMD-BK-VAL-MEMBER
BK_VAL_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-BK-VAL-FLAG
BK_VAL_FLAG
Alpha 1AM88.3
IMD-DEP-EXP-MEMBER
DEP_EXP_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-DEP-EXP-FLAG
DEP_EXP_FLAG
Alpha 1AM88.3
IMD-YTD-DEP-MEMBER
YTD_DEP_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-YTD-DEP-FLAG
YTD_DEP_FLAG
Alpha 1AM88.3
IMD-LTD-DEP-MEMBER
LTD_DEP_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-LTD-DEP-FLAG
LTD_DEP_FLAG
Alpha 1AM88.3
IMD-SA-COST-MEMBER
SA_COST_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-SA-COST-FLAG
SA_COST_FLAG
Alpha 1AM88.3
IMD-PROCEED-MEMBER
PROCEED_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-PROCEED-FLAG
PROCEED_FLAG
Alpha 1AM88.3
IMD-DSP-DEP-MEMBER
DSP_DEP_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-DSP-DEP-FLAG
DSP_DEP_FLAG
Alpha 1AM88.3
IMD-GN-LS-MEMBER
GN_LS_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-GN-LS-FLAG
GN_LS_FLAG
Alpha 1AM88.3
IMD-DF-GNLS-MEMBER
DF_GNLS_MEMBER
Alpha 50 (Lower Case)AM88.3
IMD-DF-GNLS-FLAG
DF_GNLS_FLAG
Alpha 1AM88.3
IMD-DEF-MEASURE
DEF_MEASURE
Alpha 3This field defines the measure which shall be defaulted into the measures dimension for the AM data mart.
  • BCC Base Currency Cost
  • TCC Transaction Currency Cost
  • BAS Basis
  • BVL Book Value
  • DEP Period Depreciation
  • YTD Year to date depreciation
  • LTD Life to date depreciation
  • COS Disposal Expense
  • PRO Proceeds
  • DDE Disposal Depreciation
  • GAL Gain/Loss
  • DGL Deferred Gain/Loss
AM88.3

Indexes (1)

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

IndexKeysFlagsConditionUsed in
IMDSET1MEAS-DIMENSIONPrimaryAM88.3, AMDL.1, AMDM.1, AMME.1

Programs

Updated by (1)

Referenced by (3)