Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SCNSTRUCX


                             SCNSTRUCX FILE

REFERENCED BY

GLOP.1    IFBS.1

UPDATED BY

IFSS.2    IFSS.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SCX-SCN-DIMENSION      Alpha 50  (Lower Case)                    IFSS.2  IFSS.3
Organization
Dimensioin Name

SCX-MBR-TYPE           Alpha 2                                   IFSS.2  IFSS.3
Element: Member Type   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

SCX-SEQUENCE           Numeric 6                                 IFSS.2  IFSS.3
Element: Sequence      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).

SCX-BUDGET-NBR         Numeric 3                                 IFSS.2  IFSS.3
Element: Budget Number The Budget Number field contains the
                       budget number.

SCX-MBR-NAME           Alpha 30  (Lower Case)                    IFSS.3
Element: Member Name   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.

SCX-ALIAS-MBR-NAME     Alpha 30  (Lower Case)                    IFSS.2  IFSS.3
Element: Member Name

SCX-BUD-AMT-PCT        Alpha 1                                   IFSS.3
Element: Bud Amt Pct

SCX-BUDGET-TYPE        Alpha 1                                   IFSS.3
Element: Budget Type

SCX-BUDGET-1           Numeric 3                                 IFSS.3
Element: Ytd Bud

SCX-BUDGET-2           Numeric 3                                 IFSS.3
Element: Ytd Bud

SCX-CURRENCY-TYPE      Alpha 1                                   IFSS.2
Element: Currency Type This field identifies the type of
                       currency included. You can select Base
                       currency or Transaction currency.


SCX-CURRENCY-CODE      Alpha 5                                   IFSS.2
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

SCX-TRAN-CURRENCY      Alpha 5                                   IFSS.2
To Company Base
Currency

                         SCNSTRUCX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SCXSET1   SCN-DIMENSION                                          GLOP.1  IFBS.1
          MBR-TYPE                                               IFSS.1  IFSS.2
          SEQUENCE                                               IFSS.3
          BUDGET-NBR
          MBR-NAME

SCXSET2   SCN-DIMENSION KeyChange, Subset                        IFSS.2  IFSS.3
          ALIAS-MBR-NAMEWhere ALIAS-MBR-NAME != Spaces