Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACIAMBR


                              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