Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SNACAMOUNT


                            SNACAMOUNT FILE

UPDATED BY

SNAC.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SAT-ACTIVITY-GRP       Alpha 15                                  SNAC.1
Element: Activity Grp  The activity group is the overall
                       project.

SAT-ACTIVITY           Alpha 15                                  SNAC.1
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


SAT-SUMM-ACCT-CAT      Alpha 5                                   SNAC.1
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

SAT-ACCT-CATEGORY      Alpha 5                                   SNAC.1
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

SAT-COMPANY            Numeric 4
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.

SAT-ACCT-UNIT          Alpha 15
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.


SAT-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.

SAT-RESOURCE-CODE      Alpha 10
Element: Resource Code The code identifying the resource
                       assigned to the activity or activity
                       group.

SAT-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

SAT-CUR-PRD-AMOUNT     Signed 18.2                               SNAC.1
Element: Intl Amt

SAT-CUR-PRD-COMMIT     Signed 18.2                               SNAC.1
Element: Intl Amt

SAT-CUR-AMT-COMMIT     Signed 18.2                               SNAC.1
Element: Intl Amt

SAT-CUR-PRD-BUDGET     Signed 18.2                               SNAC.1
Element: Intl Amt

SAT-PRV-PRD-AMOUNT     Signed 18.2
Element: Intl Amt

SAT-PRV-PRD-COMMIT     Signed 18.2
Element: Intl Amt

SAT-PRV-AMT-COMMIT     Signed 18.2
Element: Intl Amt

SAT-PRV-PRD-BUDGET     Signed 18.2
Element: Intl Amt

SAT-LTD-AMT            Signed 18.2                               SNAC.1
Element: Intl Amt

SAT-LTD-BUDGET         Signed 18.2                               SNAC.1
Element: Intl Amt

SAT-LTD-COMMIT-AMT     Derived
Element: Ltd Commit Amt

SAT-YTD-AMT            Signed 18.2                               SNAC.1
Element: Intl Amt

SAT-YTD-BUDGET         Signed 18.2                               SNAC.1
Element: Intl Amt

SAT-YTD-COMMIT-AMT     Derived
Element: Ytd Commit Amt

SAT-PRD-RNG-AMT        Signed 18.2
Element: Intl Amt

SAT-PRD-RNG-BUDGET     Signed 18.2
Element: Intl Amt

SAT-RNG-COMMIT-AMT     Derived
Element: Rng Commit Amt

SAT-ROLE               Alpha 12
Element: Role          The code that identifies a role that a
                       resource has in relation to activities.

SAT-AU-DEPTH           Numeric 1
Element: Level Depth   The number of variable levels
                       pertaining
                       to this record.


SAT-ACTIVITY-DEPTH     Numeric 1                                 SNAC.1
Element: Level Depth   The number of variable levels
                       pertaining
                       to this record.


SAT-ACTIVITY-DESCR     Alpha 30  (Lower Case)                    SNAC.1
Element: Description   This field displays the description.

SAT-ACCT-CAT-DESC      Alpha 30  (Lower Case)                    SNAC.1
Element: Description   This field displays the description.

SAT-ACCT-CAT-TYP       Alpha 1                                   SNAC.1
Element: Category Type This Field is used to set up the
                       default category type for the
                       Distribution File.
                       (EEDISTRIB)

SAT-PARENT-ACTVY       Alpha 15                                  SNAC.1
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


                         SNACAMOUNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SATSET1   ACTIVITY-GRP                                           SNAC.1
          ACTIVITY
          SUMM-ACCT-CAT
          ACCT-CATEGORY
          ACCT-CAT-TYP
          COMPANY
          ACCT-UNIT
          RESOURCE-COMP
          RESOURCE-CODE
          RESOURCE-TYPE

SATSET2   ACTIVITY-GRP  Subset
          ACTIVITY      Where  ACCT-CATEGORY = Spaces
          SUMM-ACCT-CAT And  ((ACCT-CAT-TYP  = "R" )
          ACCT-CATEGORY Or    (ACCT-CAT-TYP  = "C" ))
          COMPANY
          ACCT-UNIT
          RESOURCE-COMP
          RESOURCE-CODE
          RESOURCE-TYPE

                         SNACAMOUNT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cost           SNACAMOUNT   Not Required

                            SAT-ACTIVITY-GRP     -> SAT-ACTIVITY-GRP  (SATSET1)
                            SAT-ACTIVITY         -> SAT-ACTIVITY
                            "COST"               -> SAT-SUMM-ACCT-CAT
                            Spaces               -> SAT-ACCT-CATEGORY
                            "C"                  -> SAT-ACCT-CAT-TYP
                            SAT-COMPANY          -> SAT-COMPANY
                            SAT-ACCT-UNIT        -> SAT-ACCT-UNIT
                            SAT-RESOURCE-COMP    -> SAT-RESOURCE-COMP
                            SAT-RESOURCE-CODE    -> SAT-RESOURCE-CODE
                            SAT-RESOURCE-TYPE    -> SAT-RESOURCE-TYPE

Revenue        SNACAMOUNT   Not Required

                            SAT-ACTIVITY-GRP     -> SAT-ACTIVITY-GRP
                            SAT-ACTIVITY         -> SAT-ACTIVITY
                            "REV"                -> SAT-SUMM-ACCT-CAT
                            Spaces               -> SAT-ACCT-CATEGORY
                            "R"                  -> SAT-ACCT-CAT-TYP
                            Zeroes               -> SAT-COMPANY
                            SAT-ACCT-UNIT        -> SAT-ACCT-UNIT
                            SAT-RESOURCE-COMP    -> SAT-RESOURCE-COMP
                            SAT-RESOURCE-CODE    -> SAT-RESOURCE-CODE
                            SAT-RESOURCE-TYPE    -> SAT-RESOURCE-TYPE