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 |
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) |
|
||||
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 |
|
||||
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). |
|
||||
MEM-BUDGET-NBR Element: Budget Nbr | Numeric 3 The Budget Number field contains the budget number. |
|
||||
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. |
|
||||
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. |
|
||||
MEM-YEAR-1 Element: Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||||
MEM-YEAR-2 Element: Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||||
MEM-YEAR-AMT-PCT Element: Year Amt Pct | Alpha 1 A = Amount P = Percent |
|
||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MEMSET1 |
MBR-DIMENSION MBR-TYPE SEQUENCE BUDGET-NBR MBR-NAME |
|
| ||||||||||||||||||
MEMSET2 |
MBR-DIMENSION ALIAS-MBR-NAME |
|
|
All trademarks and registered trademarks are the property of their
respective owners.