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 / columnTypeDescription & valuesUpdated by
ICY-CAT-DIMENSION PK
CAT_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-PREFIX
CAT_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-OPT
CAT_ALIAS_OPT
Alpha 1ACDM.3
ICY-GROUP
GROUP
Alpha 15ACDM.3
ICY-REVENUE-MBR
REVENUE_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-MBR
EXPENSE_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-MBR
ACCRUAL_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-MBR
FEE_MBR
Alpha 30 (Lower Case)
ICY-PASS-THRU-MBR
PASS_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-STRUCTURE
STRUCTURE
Alpha 15The name of the category structure.ACDM.3
ICY-CAT-VIEW-1
CAT_VIEW_1
Alpha 12
ICY-CAT-VIEW-2
CAT_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.

IndexKeysFlagsConditionUsed in
ICYSET1CAT-DIMENSIONPrimaryACBC.1, ACDL.1, ACDM.1, ACDM.3

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AccatgrpACCATGRPNot RequiredICY-GROUPCGP-CAT-GROUP

Programs

Updated by (1)

Referenced by (2)