ACIAMBR – The Activity Analyzer Members data file stores information about each member that has been defined by AC87.1 (Analyzer…

System
Activity Management (AC)
Prefix
MEM
Primary key
MBR-DIMENSION, MBR-TYPE, SEQUENCE, BUDGET-NBR, MBR-NAME
Fields
20
Updated by
4 programs
Referenced by
4 programs

ACIAMBR is the The Activity Analyzer Members data file stores information about each member that has been defined by AC87.1 (Analyzer… table in Lawson Activity Management (prefix MEM). It is indexed by MBR-DIMENSION, MBR-TYPE, SEQUENCE, BUDGET-NBR, MBR-NAME (MEMSET1); alternate indexes: MEMSET2. It is updated by ACDM.6, ACTD.2, ACTD.4 and ACTD.5 and referenced by ACBP.1, ACBU.1, ACBY.1 and ACDL.1. The table has 20 fields, 2 indexes and 0 documented relations.

About ACIAMBR

The Activity Analyzer Members data file stores information about each member that has been defined by AC87.1 (Analyzer Definition).

Fields (20)

Column = COBOL field name without the MEM- 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
#MEM-MBR-DIMENSION PK
MBR_DIMENSION		Alpha 50 (Lower Case)—ACDM.6, ACTD.2, ACTD.4, ACTD.5
#MEM-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
  • CU Currency
  • RS Resource
ACDM.6, ACTD.2, ACTD.4, ACTD.5
#MEM-SEQUENCE PK
SEQUENCE		Numeric 6The Sequence field show the sequence of a member as it is entered in either the Budget Member Names or Fiscal Year Variances subforms in AC87.1 (Financial OLAP Dimensions).ACDM.6, ACTD.2, ACTD.4, ACTD.5
#MEM-BUDGET-NBR PK
BUDGET_NBR		Numeric 3The Budget Number field contains the budget number.ACDM.6, ACTD.2, ACTD.4, ACTD.5
#MEM-MBR-NAME PK
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.ACDM.6, ACTD.2, ACTD.4, ACTD.5
#MEM-ALIAS-MBR-NAME SET2
ALIAS_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.ACDM.6, ACTD.2, ACTD.4, ACTD.5
#MEM-YEAR-1
YEAR_1		Numeric 4Contains the fiscal year for the data stored on this record.ACTD.5
#MEM-YEAR-2
YEAR_2		Numeric 4Contains the fiscal year for the data stored on this record.ACTD.5
#MEM-YEAR-AMT-PCT
YEAR_AMT_PCT		Alpha 1—
  • A Amount
  • P Percent
ACTD.5
#MEM-PERIOD
PERIOD		Numeric 2This is the current accounting period. This field is updated by Period Closing (GL199).—
#MEM-BUDGET-1
BUDGET_1		Numeric 3——
#MEM-BUDGET-2
BUDGET_2		Numeric 3——
#MEM-BUDGET-TYPE
BUDGET_TYPE		Alpha 1—
  • A Budget to Actual
  • B Budget to Budget
—
#MEM-BUD-AMT-PCT
BUD_AMT_PCT		Alpha 1—
  • A Variance Amount
  • P Variance Percent
—
#MEM-BUD-VAR-AMT
BUD_VAR_AMT		Signed 18.2——
#MEM-BUD-VAR-PCT
BUD_VAR_PCT		Signed 7.4——
#MEM-RESOURCE-TYPE
RESOURCE_TYPE		Alpha 1The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset—
#MEM-RESOURCE-CLASS
RESOURCE_CLASS		Alpha 3——
#MEM-RESOURCE-CODE
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.—
#MEM-RESOURCE-COMP
RESOURCE_COMP		Numeric 4Resource Company. Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.—

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
MEMSET1
  1. MBR-DIMENSION
  2. MBR-TYPE
  3. SEQUENCE
  4. BUDGET-NBR
  5. MBR-NAME
PrimaryACBP.1, ACBU.1, ACBY.1, ACDL.1, ACDM.4, ACDM.6, ACTD.1, ACTD.2 +3 more
MEMSET2
  1. MBR-DIMENSION
  2. ALIAS-MBR-NAME
KeyChange, SubsetWhere ALIAS-MBR-NAME != SpacesACDM.6, ACTD.2, ACTD.4

Programs

Updated by (4)

Referenced by (4)