ACACCTCAT – Activity Account Categories

System
Activity Management (AC)
Prefix
AAX
Primary key
ACCT-CATEGORY
Fields
5
Updated by
2 programs
Referenced by
723 programs

ACACCTCAT is the Activity Account Categories table in Lawson Activity Management (prefix AAX). It is indexed by ACCT-CATEGORY (AAXSET1); alternate indexes: AAXSET2 and AAXSET4. It is related 1:M to ACACCTCATX. It is updated by AC05.1 and AC558 and referenced by AC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC06.1, AC06.2, AC07.1 and 715 more. The table has 5 fields, 3 indexes and 1 documented relation.

About ACACCTCAT

This file contains information on account categories from AC05.1 (Account Categories). In addition to the account category identifier, this file includes description and the category type. Use the Error suspense tab to identify the error suspense account category identifier.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
AAX-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Required. Account categories are groupings of costs, revenues, or accruals used for reporting and inquiries for activities in Project Accounting. 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.AC05.1, AC558
AAX-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the account category description.AC05.1, AC197, AC198, AC558
AAX-CATEGORY-TYPE
CATEGORY_TYPE		Alpha 1Required. This field defines the account category type: revenue, cost, accrual, or pass thru.
  • R Revenue
  • A Accrual
  • C Cost
  • P Pass Thru
AC05.1, AC558
AAX-TIME-EXP-FLAG
TIME_EXP_FLAG		Alpha 1—
  • T Time
  • E Expense
  • B Both
—
AAX-ES-ACCT-CAT-FL
ES_ACCT_CAT_FL		Alpha 1This is the error suspense account category flag. "Yes" identifies one account category as the error suspense account category.
  • Y Yes
  • N No
AC05.1

Indexes (3)

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

IndexKeysFlagsConditionUsed in
AAXSET1ACCT-CATEGORYPrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC05.1, AC05.2, AC05.3 +22 more (list truncated in source)
AAXSET2ACCT-CATEGORYSubsetWhere (ES-ACCT-CAT-FL = "Y")AC05.1, AC10.1, AC10.3, AC108, AC112, AC113, AC12.1, AC120 +22 more (list truncated in source)
AAXSET4CATEGORY-TYPE, ACCT-CATEGORYKeyChangeAC05.1, AC05.3, AC10.1, AC120, AC401, AC90.1, AC90.2, AC90.4 +10 more

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AcacctcatxACACCTCATXAAX-ACCT-CATEGORY → AXX-ACCT-CATEGORY, → AXX-ACTIVITY-GRP, → AXX-ACTIVITY

Programs

Updated by (2)

Referenced by (723)