ACIAMBR FILE
Activity Analyzer Members
The Activity Analyzer Members data file stores information about each member
that has been defined by AC87.1 (Analyzer Definition).
REFERENCED BY
ACBA.1 ACBP.1 ACBS.1 ACBU.1 ACBY.1 ACDL.1
UPDATED BY
AC87.1 AC87.2 AC87.3 AC87.4 AC87.5 AC87.6
AC87.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MEM-APPLIC-NAME Alpha 8 (Lower Case) AC87.1 AC87.2
Application Name The Application Name is the name of the AC87.3 AC87.4
application that describes the database AC87.5 AC87.6
names it contains. This user-defined AC87.7
name can contain up to eight characters.
The first letter of the name must be
capitalized.
MEM-DATABASE-NAME Alpha 8 (Lower Case) AC87.1 AC87.2
Database Name The Database Name is the name of the AC87.3 AC87.4
database that is stored within the OLAP AC87.5 AC87.6
application. Each application may AC87.7
contain more than one database. This
user-defined name can contain up to
eight characters. The first letter of
the name must be capitalized.
MEM-DIMENSION Alpha 3 AC87.1 AC87.2
Dimension The Dimension field specifies the AC87.3 AC87.4
dimension for the record. AC87.5 AC87.6
AC87.7
Valid values are:
ACT = Account
FYR = Fiscal Year
ORG = Organization
PRD = Period
SAC = Subaccount
SCN = Scenario TYP = Type
FYT
ACV
CAT
RES
UOM
MEM-MBR-TYPE Alpha 2 AC87.1 AC87.2
Member Type The Member Type field specifies the AC87.3 AC87.4
member type. AC87.5 AC87.6
AC87.7
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
MEM-SEQUENCE Numeric 6 AC87.1 AC87.2
Sequence The Sequence field show the sequence of AC87.3 AC87.4
a member as it is entered in either the AC87.5 AC87.6
Budget Member Names or Fiscal Year AC87.7
Variances subforms in AC87.1 (Financial
OLAP Dimensions).
MEM-BUDGET-NBR Numeric 3 AC87.1 AC87.2
Budget Number The Budget Number field contains the AC87.3 AC87.4
budget number. AC87.5 AC87.6
AC87.7
MEM-MBR-NAME Alpha 30 (Lower Case) AC87.1 AC87.2
Member Name The Member Name field contains the AC87.3 AC87.4
user-defined member name for the income AC87.5 AC87.6
statement member. This name can contain AC87.7
up to 30 characters of any kind.
MEM-ALIAS-MBR-NAME Alpha 30 (Lower Case) AC87.1 AC87.2
Alias Mbr Name The Alias Member Name field contains AC87.3 AC87.4
the alias name for the member. This name AC87.5 AC87.6
can contain up to 30 characters of any AC87.7
kind.
MEM-YEAR-1 Numeric 4 AC87.5
Year 1
MEM-YEAR-2 Numeric 4 AC87.5
Year 2
MEM-YEAR-AMT-PCT Alpha 1 AC87.5
Year Amt Pct
MEM-PERIOD Numeric 2
Last Closed Period The Period field is the current
accounting period. This field is updated
by GL199 (Period Closing).
MEM-BUDGET-1 Numeric 3 AC87.4
Budget 1
MEM-BUDGET-2 Numeric 3 AC87.4
Budget 2
MEM-BUDGET-TYPE Alpha 1 AC87.4
Budget Type
MEM-BUD-AMT-PCT Alpha 1 AC87.4
Bud Amt Pct
MEM-BUD-VAR-AMT Signed 15.2
Bud Var Amt
MEM-BUD-VAR-PCT Signed 7.4
Bud Var Pct
ACIAMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MEMSET1 APPLIC-NAME AC87.1 AC87.2
DATABASE-NAME AC87.3 AC87.4
DIMENSION AC87.5 AC87.6
MBR-TYPE AC87.7 ACBA.1
SEQUENCE ACBP.1 ACBS.1
BUDGET-NBR ACBU.1 ACBY.1
MBR-NAME ACDL.1
MEMSET2 APPLIC-NAME Subset AC87.2 AC87.3
DATABASE-NAME Where ALIAS-MBR-NAME != Spaces AC87.6 AC87.7
DIMENSION
ALIAS-MBR-NAME
|