Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTOTALS


                             ACTOTALS FILE

REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC30.1    AC30.2    AC30.3    AC32.1
AC37.1    AC490

UPDATED BY

AC35.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATO-TOTAL-NAME         Alpha 10                                  AC35.1
Element: Total Name    The name given to a total defined in
                       RA20(Ratio Totals).

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

ATO-FISCAL-YEAR        Numeric 4                                 AC35.1
Element: Year          Contains the fiscal year for the data
                       stored on this record.


ATO-COMPUTE-TYPE       Alpha 1                                   AC35.1
Element: Compute Type

ATO-BUDGET-FLAG        Alpha 1                                   AC35.1
Element: Budget Flag

ATO-BUDGET-NBR         Numeric 3                                 AC35.1
Element: Budget Nbr    The Budget Number field contains the
                       budget number.

ATO-AC-MATRIX-LIST     Alpha 12                                  AC35.1
Element: Ac Matrix ListActivity List.

ATO-ACTIVITY           Alpha 15                                  AC35.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.


ATO-FR-ACCT-CAT        Alpha 5                                   AC35.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

ATO-TH-ACCT-CAT        Alpha 5                                   AC35.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

ATO-GROUP              Alpha 15                                  AC35.1
Element: Group

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

ATO-COMPANY-GROUP      Alpha 12                                  AC35.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.

ATO-AU-MATRIX-LIST     Alpha 12                                  AC35.1
Element: Au Matrix List

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


ATO-AC-HEAD-NAME       Alpha 10                                  AC35.1
Element: Ac Head Name

                         ACTOTALS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATOSET1   TOTAL-NAME                                             AC121   AC123
                                                                 AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC30.1  AC30.2
                                                                 AC30.3  AC32.1
                                                                 AC35.1  AC37.1
                                                                 AC490