ACIACALDIM – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
IPY
Primary key
CAL-DIMENSION, MBR-TYPE
Fields
7
Updated by
2 programs
Referenced by
4 programs

ACIACALDIM is a Lawson Activity Management table (prefix IPY); no description in the lawson data dictionary. It is indexed by CAL-DIMENSION, MBR-TYPE (IPYSET1); alternate indexes: IPYSET2. It is related 1:M to ACIAMBR. It is updated by ACTD.1 and ACTD.3 and referenced by ACBP.1, ACBY.1, ACDL.1 and ACDM.1. The table has 7 fields, 2 indexes and 3 documented relations.

About ACIACALDIM

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
IPY-CAL-DIMENSION PK
CAL_DIMENSION		Alpha 50 (Lower Case)—ACTD.1, ACTD.3
IPY-MBR-TYPE PK
MBR_TYPE		Alpha 2The Member Type field specifies the member type. Valid values are:
  • BD Budget
  • BV Budget Variance
  • CH Alternate Chart
  • FY Fiscal Year
  • PD Period
  • PY Period Year-to-Date
  • QR Quarter
  • QY Quarter Year-to-Date
  • SA Subaccount
  • VW View
  • YV Year Variance
  • YR Year
ACTD.1, ACTD.3
IPY-MEMBER-PREFIX
MEMBER_PREFIX		Alpha 5 (Lower Case)The Member Prefix field contains a unique prefix to differentiate the dimension name from other like-named dimensions. This user-defined name can contain up to five characters of any kind.ACTD.1, ACTD.3
IPY-LTD-MBR-NAME
LTD_MBR_NAME		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.ACTD.3
IPY-PTD-FLAG
PTD_FLAG		Alpha 1—ACTD.1
IPY-BEG-BAL-MBR
BEG_BAL_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.ACTD.1
IPY-ALIAS-OPTION
ALIAS_OPTION		Alpha 1—ACTD.1, ACTD.3

Indexes (2)

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

IndexKeysFlagsConditionUsed in
IPYSET1CAL-DIMENSION, MBR-TYPEPrimaryACBP.1, ACBY.1, ACDL.1, ACDM.1, ACTD.2, ACTD.4, ACTD.5
IPYSET2MBR-TYPE, CAL-DIMENSIONACTD.1, ACTD.3

Relations

One to many (3) — child tables

RelationTableRulesConditionField map
Aciambr PrACIAMBRIPY-CAL-DIMENSION → MEM-MBR-DIMENSION, "PR" → MEM-MBR-TYPE, → MEM-SEQUENCE, → MEM-BUDGET-NBR, → MEM-MBR-NAME
Aciambr YrACIAMBRIPY-CAL-DIMENSION → MEM-MBR-DIMENSION, "YR" → MEM-MBR-TYPE, → MEM-SEQUENCE, → MEM-BUDGET-NBR, → MEM-MBR-NAME
Aciambr YvACIAMBRIPY-CAL-DIMENSION → MEM-MBR-DIMENSION, "YV" → MEM-MBR-TYPE, → MEM-SEQUENCE, → MEM-BUDGET-NBR, → MEM-MBR-NAME

Programs

Updated by (2)

Referenced by (4)