AMIADIM – No description in the Lawson data dictionary
- System
- Asset Management (AM)
- Prefix
ADI- Primary key
DATA-MART-NAME- Fields
- 15
- Updated by
- 1 program
- Referenced by
- 9 programs
AMIADIM is a Lawson Asset Management table (prefix ADI); no description in the lawson data dictionary. It is indexed by DATA-MART-NAME (ADISET1). It is updated by AMDM.1 and referenced by AMAS.1, AMBK.1, AMCV.1, AMDL.1, AMLF.1, AMMD.1, AMME.1, AMPD.1 and 1 more. The table has 15 fields, 1 index and 0 documented relations.
About AMIADIM
No description in the Lawson data dictionary.
Fields (15)
Column = COBOL field name without the ADI- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#ADI-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | AMDM.1 |
#ADI-AST-DIMENSIONAST_DIMENSION | Alpha 50 (Lower Case) | — | AMDM.1 |
#ADI-BOOK-DIMENSIONBOOK_DIMENSION | Alpha 50 (Lower Case) | — | AMDM.1 |
#ADI-FYR-DIMENSIONFYR_DIMENSION | Alpha 50 (Lower Case) | The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind. | AMDM.1 |
#ADI-PRD-DIMENSIONPRD_DIMENSION | Alpha 50 (Lower Case) | The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind. | AMDM.1 |
#ADI-MEAS-DIMENSIONMEAS_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. | AMDM.1 |
#ADI-ORG-DIMENSIONORG_DIMENSION | Alpha 50 (Lower Case) | The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind. | AMDM.1 |
#ADI-CONV-DIMENSIONCONV_DIMENSION | Alpha 50 (Lower Case) | — | AMDM.1 |
#ADI-METH-DIMENSIONMETH_DIMENSION | Alpha 50 (Lower Case) | — | AMDM.1 |
#ADI-LIFE-DIMENSIONLIFE_DIMENSION | Alpha 50 (Lower Case) | — | AMDM.1 |
#ADI-DATA-LOADDATA_LOAD | Alpha 1 | — | AMDM.1 |
#ADI-START-DATESTART_DATE | Numeric 8 (yyyymmdd) | — | AMDM.1 |
#ADI-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The end date for this effort period. | AMDM.1 |
#ADI-MAINT-DATEMAINT_DATE | Numeric 8 (yyyymmdd) | The date last changed. | AMDM.1 |
#ADI-MAINT-TIMEMAINT_TIME | Numeric 6 (hhmmss) | — | AMDM.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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ADISET1 |
| Primary | AMAS.1, AMBK.1, AMCV.1, AMDL.1, AMDM.1, AMLF.1, AMMD.1, AMME.1 +2 more |
Programs
Updated by (1)
- AMDM.1 Asset Management Analysis Setup
Referenced by (9)
- AMAS.1 OLAP Dimension Retrieval Format
- AMBK.1 OLAP Dimension Retrieval Format
- AMCV.1 OLAP Dimension Retrieval Format
- AMDL.1 OLAP Data Load
- AMLF.1 OLAP Dimension Retrieval Format
- AMMD.1 OLAP Dimension Retrieval Format
- AMME.1 OLAP Dimension Retrieval Format
- AMPD.1 Olap Dimension Retrieval Format
- AMYR.1 Olap Dimension Retrieval Format