ACTOTALS – Activity Total Names

System
Activity Management (AC)
Prefix
ATO
Primary key
TOTAL-NAME
Fields
16
Updated by
1 program
Referenced by
14 programs

ACTOTALS is the Activity Total Names table in Lawson Activity Management (prefix ATO). It is indexed by TOTAL-NAME (ATOSET1). It is updated by AC35.1 and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 6 more. The table has 16 fields, 1 index and 0 documented relations.

About ACTOTALS

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the ATO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ATO-TOTAL-NAME PK
TOTAL_NAME		Alpha 10The name given to a total defined in RA20(Ratio Totals).AC35.1
ATO-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC35.1
ATO-FISCAL-YEAR
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.AC35.1
ATO-COMPUTE-TYPE
COMPUTE_TYPE		Alpha 1—AC35.1
ATO-BUDGET-FLAG
BUDGET_FLAG		Alpha 1—AC35.1
ATO-BUDGET-NBR
BUDGET_NBR		Numeric 3The Budget Number field contains the budget number.AC35.1
ATO-AC-MATRIX-LIST
AC_MATRIX_LIST		Alpha 12Activity List.AC35.1
ATO-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC35.1
ATO-FR-ACCT-CAT
FR_ACCT_CAT		Alpha 5Account 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 thruAC35.1
ATO-TH-ACCT-CAT
TH_ACCT_CAT		Alpha 5Account 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 thruAC35.1
ATO-GROUP
GROUP		Alpha 15—AC35.1
ATO-COMPANY
COMPANY		Numeric 4Identifies 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.AC35.1
ATO-COMPANY-GROUP
COMPANY_GROUP		Alpha 12You 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.AC35.1
ATO-AU-MATRIX-LIST
AU_MATRIX_LIST		Alpha 12—AC35.1
ATO-ACCT-UNIT
ACCT_UNIT		Alpha 15The 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.AC35.1
ATO-AC-HEAD-NAME
AC_HEAD_NAME		Alpha 10—AC35.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ATOSET1TOTAL-NAMEPrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +7 more

Programs

Updated by (1)

Referenced by (14)