ACOVERRIDE – This file will contain a record for each record created in the assignment files ACGLACCT, ACBRDNDTL, and ACEMPEXPX.

System
Activity Management (AC)
Prefix
ACQ
Primary key
RECORD-TYPE, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, AC-KEY-FIELD
Fields
5
Updated by
9 programs
Referenced by
3 programs

ACOVERRIDE is the This file will contain a record for each record created in the assignment files ACGLACCT, ACBRDNDTL, and ACEMPEXPX. table in Lawson Activity Management (prefix ACQ). It is indexed by RECORD-TYPE, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, AC-KEY-FIELD (ACQSET1). It is updated by AC00.1, AC07.1, AC08.3, AC10.1, AC105, AC110, AC120, AC300 and 1 more and referenced by AC207, AC261 and ACAC.1. The table has 5 fields, 1 index and 0 documented relations.

About ACOVERRIDE

This file will contain a record for each record created in the assignment files ACGLACCT, ACBRDNDTL, and ACEMPEXPX.

Fields (5)

Column = COBOL field name without the ACQ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ACQ-RECORD-TYPE PK
RECORD_TYPE
Alpha 1Identifies the record type. Valid values include: 1 - ACGLACCT 2 - ACBRDNDTL 3 - ACEMPEXPX
  • 1 ACGLACCT
  • 2 ACBRDNDTL
AC07.1, AC105, AC110, AC61.1
#ACQ-ACTIVITY-GRP PK
ACTIVITY_GRP
Alpha 15The activity group is the overall project.AC07.1, AC105, AC110, AC120, AC61.1
#ACQ-ACTIVITY PK
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.AC07.1, AC105, AC110, AC120, AC61.1
#ACQ-ACCT-CATEGORY PK
ACCT_CATEGORY
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 thruAC07.1, AC105, AC110, AC61.1
#ACQ-AC-KEY-FIELD PK
AC_KEY_FIELD
Alpha 60AC07.1, AC105, AC110, AC61.1

Indexes (1)

Keys are listed in index order; marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ACQSET1
  1. RECORD-TYPE
  2. ACTIVITY-GRP
  3. ACTIVITY
  4. ACCT-CATEGORY
  5. AC-KEY-FIELD
PrimaryAC00.1, AC07.1, AC08.3, AC10.1, AC105, AC110, AC120, AC207 +4 more

Programs

Updated by (9)

Referenced by (3)