|
|
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
Element: Mbr Dimension ACTD.4 ACTD.5
MEM-MBR-TYPE Alpha 2 ACDM.6 ACTD.2
Element: 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
Element: 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
Element: 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
Element: 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
Element: Member 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
Element: Last Closed Year
MEM-YEAR-2 Numeric 4 ACTD.5
Element: Last Closed Year
MEM-YEAR-AMT-PCT Alpha 1 ACTD.5
Element: Year Amt Pct A = Amount
P = Percent
MEM-PERIOD Numeric 2
Element: Last Closed PeThis is the current accounting period.
This field is updated by Period Closing
(GL199).
MEM-BUDGET-1 Numeric 3
Element: Budget 1
MEM-BUDGET-2 Numeric 3
Element: Budget 2
MEM-BUDGET-TYPE Alpha 1
Element: Budget Type A = Budget to Actual
B = Budget to Budget
MEM-BUD-AMT-PCT Alpha 1
Element: Bud Amt Pct A = Variance Amount
P = Variance Percent
MEM-BUD-VAR-AMT Signed 18.2
Element: Intl Amt
MEM-BUD-VAR-PCT Signed 7.4
Element: Bud Var Pct
MEM-RESOURCE-TYPE Alpha 1
Element: Resource Type The type of resource. Valid values
include:
P - AC Person
Q - Equipment
E - Employee
V - Vendor
A - Asset
MEM-RESOURCE-CLASS Alpha 3
Element: Resource Class
MEM-RESOURCE-CODE Alpha 10
Element: Resource Code The code identifying the resource
assigned to the activity or activity
group.
MEM-RESOURCE-COMP Numeric 4
Element: Resource Comp Resource 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.
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
|
