ACIACATDIM – No description in the Lawson data dictionary
- System
- Activity Management (AC)
- Prefix
ICY- Primary key
CAT-DIMENSION- Fields
- 12
- Updated by
- 1 program
- Referenced by
- 2 programs
ACIACATDIM is a Lawson Activity Management table (prefix ICY); no description in the lawson data dictionary. It is indexed by CAT-DIMENSION (ICYSET1). It is related 1:1 to ACCATGRP. It is updated by ACDM.3 and referenced by ACBC.1 and ACDL.1. The table has 12 fields, 1 index and 1 documented relation.
About ACIACATDIM
No description in the Lawson data dictionary.
Fields (12)
Column = COBOL field name without the ICY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ICY-CAT-DIMENSION PKCAT_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. | ACDM.3 |
ICY-CAT-PREFIXCAT_PREFIX | Alpha 5 (Lower Case) | The Type Prefix field contains a unique prefix name that differentiates the members in the Type dimension with similar members in other dimensions. This prefix can contain up to five characters of any kind. | ACDM.3 |
ICY-CAT-ALIAS-OPTCAT_ALIAS_OPT | Alpha 1 | — | ACDM.3 |
ICY-GROUPGROUP | Alpha 15 | — | ACDM.3 |
ICY-REVENUE-MBRREVENUE_MBR | Alpha 30 (Lower Case) | The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind. | ACDM.3 |
ICY-EXPENSE-MBREXPENSE_MBR | Alpha 30 (Lower Case) | The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind. | ACDM.3 |
ICY-ACCRUAL-MBRACCRUAL_MBR | Alpha 30 (Lower Case) | The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind. | ACDM.3 |
ICY-FEE-MBRFEE_MBR | Alpha 30 (Lower Case) | — | — |
ICY-PASS-THRU-MBRPASS_THRU_MBR | Alpha 30 (Lower Case) | The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind. | ACDM.3 |
ICY-STRUCTURESTRUCTURE | Alpha 15 | The name of the category structure. | ACDM.3 |
ICY-CAT-VIEW-1CAT_VIEW_1 | Alpha 12 | — | — |
ICY-CAT-VIEW-2CAT_VIEW_2 | Alpha 12 | — | — |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ICYSET1 | CAT-DIMENSION | Primary | ACBC.1, ACDL.1, ACDM.1, ACDM.3 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Accatgrp | ACCATGRP | Not Required | ICY-GROUP → CGP-CAT-GROUP |
Programs
Updated by (1)
- ACDM.3 Account Category Dimension Definition