ACIAMBR

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
Element: Mbr Dimension
Alpha 50 (Lower Case)
ACDM.6 ACTD.2
ACTD.4 ACTD.5
MEM-MBR-TYPE
Element: Mbr Type
Alpha 2
The 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
Element: Sequence
Numeric 6
The 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
Element: Budget Nbr
Numeric 3
The Budget Number field contains the budget number.
ACDM.6 ACTD.2
ACTD.4 ACTD.5
MEM-MBR-NAME
Element: 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
Element: 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
Element: Year
Numeric 4
Contains the fiscal year for the data stored on this record.
ACTD.5
MEM-YEAR-2
Element: Year
Numeric 4
Contains the fiscal year for the data stored on this record.
ACTD.5
MEM-YEAR-AMT-PCT
Element: Year Amt Pct
Alpha 1

A = Amount
P = Percent
ACTD.5
MEM-PERIOD
Element: Period
Numeric 2
This is the current accounting period. This field is updated by Period Closing (GL199).
MEM-BUDGET-1
Element: Budget 1
Numeric 3
MEM-BUDGET-2
Element: Budget 2
Numeric 3
MEM-BUDGET-TYPE
Element: Budget Type
Alpha 1

A = Budget to Actual
B = Budget to Budget
MEM-BUD-AMT-PCT
Element: Bud Amt Pct
Alpha 1

A = Variance Amount
P = Variance Percent
MEM-BUD-VAR-AMT
Element: Intl Amt
Signed 18.2
MEM-BUD-VAR-PCT
Element: Bud Var Pct
Signed 7.4
MEM-RESOURCE-TYPE
Element: Resource Type
Alpha 1
The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset
MEM-RESOURCE-CLASS
Element: Resource Class
Alpha 3
MEM-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group.
MEM-RESOURCE-COMP
Element: Resource Comp
Numeric 4
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
MBR-TYPE
SEQUENCE
BUDGET-NBR
MBR-NAME
ACBP.1 ACBU.1
ACBY.1 ACDL.1
ACDM.4 ACDM.6
ACTD.1 ACTD.2
ACTD.3 ACTD.4
ACTD.5
MEMSET2 MBR-DIMENSION
ALIAS-MBR-NAME
KeyChange, Subset
WhereALIAS-MBR-NAME !=Spaces
ACDM.6 ACTD.2
ACTD.4


File created: Thu Jun 09 02:03:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.