ACIAMBR FILE
The Activity Analyzer Members data file stores information about each member
that has been defined by AC87.1 (Analyzer Definition).
REFERENCED BY
ACBP.1 ACBU.1 ACBY.1 ACDL.1
UPDATED BY
ACDM.6 ACTD.2 ACTD.4 ACTD.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MEM-MBR-DIMENSION Alpha 50 (Lower Case) ACDM.6 ACTD.2
Mbr Dimension ACTD.4 ACTD.5
MEM-MBR-TYPE Alpha 2 ACDM.6 ACTD.2
Member Type The Member Type field specifies the ACTD.4 ACTD.5
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
MEM-SEQUENCE Numeric 6 ACDM.6 ACTD.2
Sequence The Sequence field show the sequence of ACTD.4 ACTD.5
a member as it is entered in either the
Budget Member Names or Fiscal Year
Variances subforms in AC87.1 (Financial
OLAP Dimensions).
MEM-BUDGET-NBR Numeric 3 ACDM.6 ACTD.2
Budget Number The Budget Number field contains the ACTD.4 ACTD.5
budget number.
MEM-MBR-NAME Alpha 30 (Lower Case) ACDM.6 ACTD.2
Member Name The Member Name field contains the ACTD.4 ACTD.5
user-defined member name for the income
statement member. This name can contain
up to 30 characters of any kind.
MEM-ALIAS-MBR-NAME Alpha 30 (Lower Case) ACDM.6 ACTD.2
Alias Mbr Name The Alias Member Name field contains ACTD.4 ACTD.5
the alias name for the member. This name
can contain up to 30 characters of any
kind.
MEM-YEAR-1 Numeric 4 ACTD.5
Year 1
MEM-YEAR-2 Numeric 4 ACTD.5
Year 2
MEM-YEAR-AMT-PCT Alpha 1 ACTD.5
Year Amt Pct A = Amount
P = Percent
MEM-PERIOD Numeric 2
Last Closed Period This is the current accounting period.
This field is updated by Period Closing
(GL199).
MEM-BUDGET-1 Numeric 3
Budget 1
MEM-BUDGET-2 Numeric 3
Budget 2
MEM-BUDGET-TYPE Alpha 1
Budget Type A = Budget to Actual
B = Budget to Budget
MEM-BUD-AMT-PCT Alpha 1
Bud Amt Pct A = Variance Amount
P = Variance Percent
MEM-BUD-VAR-AMT Signed 15.2
Bud Var Amt
MEM-BUD-VAR-PCT Signed 7.4
Bud Var Pct
MEM-RESOURCE-TYPE Alpha 1
Resource Type
MEM-RESOURCE-CLASS Alpha 3
Resource Class
MEM-RESOURCE-CODE Alpha 10
Resource Code
ACIAMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MEMSET1 MBR-DIMENSION ACBP.1 ACBU.1
MBR-TYPE ACBY.1 ACDL.1
SEQUENCE ACDM.4 ACDM.6
BUDGET-NBR ACTD.1 ACTD.2
MBR-NAME ACTD.3 ACTD.4
ACTD.5
MEMSET2 MBR-DIMENSION KeyChange, Subset ACDM.6 ACTD.2
ALIAS-MBR-NAMEWhere ALIAS-MBR-NAME != Spaces ACTD.4
|
