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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IPYSET1
  1. CAL-DIMENSION
  2. MBR-TYPE
PrimaryACBP.1, ACBY.1, ACDL.1, ACDM.1, ACTD.2, ACTD.4, ACTD.5
IPYSET2
  1. MBR-TYPE
  2. CAL-DIMENSION
ACTD.1, ACTD.3

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACIAMBRACIACALDIM

One to many (3) — child tables

RelationTableRulesConditionField map
Aciambr PrACIAMBR
IPY-CAL-DIMENSION→MEM-MBR-DIMENSION
"PR"→MEM-MBR-TYPE
—→MEM-SEQUENCE
—→MEM-BUDGET-NBR
—→MEM-MBR-NAME
Aciambr YrACIAMBR
IPY-CAL-DIMENSION→MEM-MBR-DIMENSION
"YR"→MEM-MBR-TYPE
—→MEM-SEQUENCE
—→MEM-BUDGET-NBR
—→MEM-MBR-NAME
Aciambr YvACIAMBR
IPY-CAL-DIMENSION→MEM-MBR-DIMENSION
"YV"→MEM-MBR-TYPE
—→MEM-SEQUENCE
—→MEM-BUDGET-NBR
—→MEM-MBR-NAME

Programs

Updated by (2)

Referenced by (4)