Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SNBUDGET


                             SNBUDGET FILE

REFERENCED BY

SNEM.1    SNHC.1    SNOD.1    SN120     SN130     SN200
SN50.1    SN60.1    SN60.2    SN60.3    SN60.4    SN70.1
SN70.2    SN70.3    SN70.4    SN75.1    SN75.2    SNAU.1
SNCT.1    SNCU.1    SNDA.1    SNFT.1    SNGE.1    SNOA.1
SNOP.1    SNRA.1    SNRP.1    SNSA.1    SNSP.1    SNTY.1


UPDATED BY

SN40.1    SN80.2    SN80.3    SN85.1    SN85.2    SNFL.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

S01-BUD-OBJ-ID         Numeric 12                                SNFL.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

S01-BUDGET-NAME        Alpha 12                                  SNFL.1
Element: Budget Name   Name of the budget.  This is the unique
                       identifier of a budget.

S01-DESCRIPTION        Alpha 30  (Lower Case)                    SNFL.1
Element: Description   This field displays the description.

S01-NBR-OF-PERIODS     Numeric 3
Element: Nbr Of Periods

S01-SERVER-NAME        Alpha 40  (Lower Case)                    SNFL.1
Element: Server Name   The Server Name field contains the IP
                       address of the server to which you are
                       connecting. You can also specify a name
                       that has been associated with the server
                       (DNS name).

S01-SC-IMP-PATH        Alpha 100  (Lower Case)                   SNFL.1
Element: Import Path   This is the directory on the Lawson
                       Server where the Budget Architect will
                       create all ASCII files to be imported
                       into Pillar.

S01-SC-EXP-PATH        Alpha 100  (Lower Case)                   SNFL.1
Element: Export Path   This is the directory on the Lawson
                       Server where the Budget Architect will
                       search for ASCII files exported from
                       Pillar.

S01-BO-IMPORT-PATH     Alpha 100  (Lower Case)                   SNFL.1
Element: Import Path   This is the directory on the Lawson
                       Server where the Budget Architect will
                       create all ASCII files to be imported
                       into Pillar.

S01-BO-EXPORT-PATH     Alpha 100  (Lower Case)                   SNFL.1
Element: Export Path   This is the directory on the Lawson
                       Server where the Budget Architect will
                       search for ASCII files exported from
                       Pillar.

S01-CURR-YEAR          Numeric 4                                 SNFL.1
Element: Curr Year

S01-ACTIVE-STATUS      Alpha 1
Element: Active Status The status of the account. If Inactive,
                       no posting can be done to the account.


S01-FB-BUDGET-NBR      Numeric 3                                 SNFL.1
Element: Fb Budget Nbr

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

S01-SC-CORP-CODE       Alpha 50  (Lower Case)                    SNFL.1
Element: Sc Corp Code

S01-SC-RELEASE         Alpha 6  (Lower Case)                     SNFL.1
Element: Sc Release

S01-DEFAULT-CHART      Alpha 12                                  SNFL.1
Element: Chart Name    This is the name you assigned to the
                       chart of accounts when you defined your
                       company structure in the General Ledger
                       system.


S01-OPEX-LN-ATTR       Alpha 12
Element: Matrix Cat    Attribute name assigned to an object
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

S01-DEFAULT-OPEX       Alpha 32
Element: Mx Value      The attribute value.

S01-HEAD-CAT-OPT       Alpha 1                                   SN80.2  SNFL.1
Element: Head Cat Opt

S01-HEAD-CT-COMP       Numeric 4                                 SN80.2  SNFL.1
Element: 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.

S01-HEAD-CT-CO-GRP     Alpha 12                                  SN80.2  SNFL.1
Element: Company Group You can type or select a company group.
                       A company group represents one or more
                       companies.

                       If you select a company group, leave
                       the Company field blank.

S01-HEAD-CT-EMP-GP     Alpha 10                                  SN80.2  SNFL.1
Element: Group Name

S01-HEAD-TYPE-OPT      Alpha 1                                   SN80.3  SNFL.1
Element: Head Type Opt

S01-HEAD-TY-COMP       Numeric 4                                 SN80.3  SNFL.1
Element: 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.

S01-HEAD-TY-CO-GRP     Alpha 12                                  SN80.3  SNFL.1
Element: Company Group You can type or select a company group.
                       A company group represents one or more
                       companies.

                       If you select a company group, leave
                       the Company field blank.

S01-HEAD-TY-EMP-GP     Alpha 10                                  SN80.3  SNFL.1
Element: Group Name

S01-HC-ACT-COMP        Numeric 4                                 SN85.2
Element: 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.

S01-HC-ACT-CO-GRP      Alpha 12                                  SN85.2
Element: Company Group You can type or select a company group.
                       A company group represents one or more
                       companies.

                       If you select a company group, leave
                       the Company field blank.

S01-HC-ACT-EMP-GP      Alpha 10                                  SN85.2
Element: Group Name

S01-HC-ACT-HEADS       Alpha 1                                   SN85.2
Element: Head Cat Opt

S01-HC-ACT-COUNTS      Alpha 1                                   SN85.2
Element: Head Cat Opt  1 = Primary Position
                       2 = All Positions

S01-HC-PLN-COMP        Numeric 4                                 SN85.1
Element: 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.

S01-HC-PLN-CO-GRP      Alpha 12                                  SN85.1
Element: Company Group You can type or select a company group.
                       A company group represents one or more
                       companies.

                       If you select a company group, leave
                       the Company field blank.

S01-HC-PLN-EMP-GP      Alpha 10                                  SN85.1
Element: Group Name

S01-HC-PLN-SUM-OPT     Alpha 1                                   SN85.1
Element: Head Cat Opt

S01-HC-PLN-CONCAT      Alpha 1                                   SN85.1
Element: Head Cat Opt

S01-HC-PLN-ACCESS      Alpha 1                                   SN85.1
Element: Head Cat Opt

S01-HC-PLN-REQ-PRE     Alpha 5  (Lower Case)                     SN85.1
Element: Member Prefix The Member Prefix field contains a
                       unique prefix to differentiate the
                       dimension name from other like-named
                       dimensions.  This user-defined name can
                       contain up to five characters of any
                       kind.

S01-HC-PLN-HEADS       Alpha 1                                   SN85.1
Element: Head Cat Opt

S01-HC-PLN-COUNTS      Alpha 1                                   SN85.1
Element: Head Cat Opt

S01-DEFAULT-CAT        Alpha 50  (Lower Case)                    SNFL.1
Element: Sc Dept Code

S01-DEFAULT-TYPE       Alpha 50  (Lower Case)                    SNFL.1
Element: Sc Dept Code

S01-DEFAULT-HR-AU      Alpha 50  (Lower Case)                    SNFL.1
Element: Sc Dept Code

S01-OTHER-CO           Numeric 4                                 SNFL.1
Element: 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.

S01-OTHER-AU           Alpha 15                                  SNFL.1
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


S01-OTHER-LIST         Alpha 12                                  SNFL.1
Element: Matrix List   Attribute categories are selection
                       parameters used to build a list of
                       objects (accounting units). Attribute
                       categories and values are the basis of
                       the selection and sorting. A attribute
                       list can then be used for reporting on
                       and processing objects.


S01-OTHER-SUM-ACT      Alpha 12                                  SNFL.1
Element: Summary Acct

S01-OTHER-ACT-LIST     Alpha 12                                  SNFL.1
Element: Matrix List   Attribute categories are selection
                       parameters used to build a list of
                       objects (accounting units). Attribute
                       categories and values are the basis of
                       the selection and sorting. A attribute
                       list can then be used for reporting on
                       and processing objects.


S01-TAXES-CO           Numeric 4                                 SNFL.1
Element: 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.

S01-TAXES-AU           Alpha 15                                  SNFL.1
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


S01-TAXES-LIST         Alpha 12                                  SNFL.1
Element: Matrix List   Attribute categories are selection
                       parameters used to build a list of
                       objects (accounting units). Attribute
                       categories and values are the basis of
                       the selection and sorting. A attribute
                       list can then be used for reporting on
                       and processing objects.


S01-TAXES-SUM-ACT      Alpha 12                                  SNFL.1
Element: Summary Acct

S01-TAXES-ACT-LIST     Alpha 12                                  SNFL.1
Element: Matrix List   Attribute categories are selection
                       parameters used to build a list of
                       objects (accounting units). Attribute
                       categories and values are the basis of
                       the selection and sorting. A attribute
                       list can then be used for reporting on
                       and processing objects.


S01-CURRENCY-TABLE     Alpha 12                                  SN40.1
Element: Currency Table

S01-TRANSL-CODE        Alpha 2                                   SN40.1
Element: Transl Code

                         SNBUDGET FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

S01SET1   BUD-OBJ-ID                                             SNEM.1  SNFL.1
                                                                 SNHC.1  SNOD.1

S01SET2   BUDGET-NAME                                            SN120   SN130
                                                                 SN200   SN40.1
                                                                 SN50.1  SN60.1
                                                                 SN60.2  SN60.3
                                                                 SN60.4  SN70.1
                                                                 SN70.2  SN70.3
                                                                 SN70.4  SN75.1
                                                                 SN75.2  SN80.1
                                                                 SN80.2  SN80.3
                                                                 SN80.4  SN85.1
                                                                 SN85.2  SNAU.1
                                                                 SNCT.1  SNCU.1
                                                                 SNDA.1  SNEM.1
                                                                 SNFL.1  SNFL.2
                                                                 SNFT.1  SNGE.1
                                                                 ...