Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACTSTRUC FILE

REFERENCED BY

GLDM.1    GLDM.3    GLDX.1    GLOP.1    IFBA.1

UPDATED BY

IFAS.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ATD-USER-DIM-NAME    Alpha 50  (Lower Case)                      IFAS.1
User Dim Name        The User Dimension Name is the name
                     associated with the dimension in the
                     data mart outline. This user-defined
                     name can contain up to 50 alphanumeric
                     characters. For example, you might name
                     a dimension Fiscal Year or Organization.


ATD-ACT-PREFIX       Alpha 5  (Lower Case)                       IFAS.1
Act Prefix           The Accounts Prefix field contains a
                     unique prefix name that differentiates
                     the members in the Accounts dimension
                     with similar members in other
                     dimensions. This name can contain up to
                     five characters of any kind.


ATD-ACT-ALIAS-OPT    Alpha 1                                     IFAS.1
Act Alias Opt        The Accounts Alias Option field
                     contains the value that represents the
                     alias name for the members of this
                     dimension.

                     Value values are:
                     1  = Account, subaccount, and
                     description of subaccount; Default
                     value.
                     2 = Account and subaccount
                     3 = Description of subaccount



ATD-BAL-MBR-NAME     Alpha 30  (Lower Case)                      IFAS.1
Bal Mbr Name         The Balance Sheet Member Name field
                     contains the user-defined name of the
                     balance sheet member. This name can
                     contain up to 30 characters of any kind.



ATD-INC-MBR-NAME     Alpha 30  (Lower Case)                      IFAS.1
Inc Mbr Name         The Income Statement Member Name field
                     contains the user-defined name of the
                     income statement member. The name can
                     contain up to 30 characters of any kind.



ATD-ACCT-ROLLUP      Alpha 1                                     IFAS.1
Acct Rollup          The Account Rollup field determines
                     whether or not the outline contains an
                     account member with subaccount children,
                     which are rolled up when the database is
                     calculated.

                     Valid values are:
                     Y = Yes
                     N = No


ATD-CHART-NAME       Alpha 12                                    IFAS.1
Chart Name           This is the name you assigned to the
                     chart of accounts when you defined your
                     company structure in the General Ledger
                     system.


ATD-CHART-SECTION    Alpha 1                                     IFAS.1
Chart Section        The chart section.

ATD-ACT-SIGN-OPT     Alpha 1
Act Sign Opt         The Sign Reversal field determines if
                     amounts and budget amounts in the income
                     statement accounts are loaded with the
                     sign reversed.

                     Valid values are:
                     Y = Yes
                     N = No


                         ACTSTRUC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATDSET1   USER-DIM-NAME                                          GLDM.1  GLDM.3
                                                                 GLDX.1  GLOP.1
                                                                 IFAS.1  IFBA.1