ACACCTCATX – Account Category Detail

System
Activity Management (AC)
Prefix
AXX
Primary key
ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY
Fields
10
Updated by
9 programs
Referenced by
467 programs

ACACCTCATX is the Account Category Detail table in Lawson Activity Management (prefix AXX). It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY (AXXSET1); alternate indexes: AXXSET2, AXXSET4 and AXXSET6. It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY, ACAMCODE, ACBUDHDR and ACCATSUM and 1:M to ACBRDNDTL, ACBUDDTL, ACCOMMIT, ACCOMMITX, ACGLACCT, ACMASTER and ACTRANS. It is updated by AC06.1, AC06.2, AC10.1, AC105, AC108, AC110, AC120, AC300 and 1 more and referenced by AC112, AC113, AC12.1, AC121, AC123, AC127, AC128, AC130 and 459 more. The table has 10 fields, 4 indexes and 15 documented relations.

About ACACCTCATX

This file includes detailed override information on account categories from AC06.1 (Override Account Categories). This form (AC06) and file are only utilized if the parameters assigned to the category structure need to be overridden. The records can only be added for posting level activities. This file allows override on account category status (to inactivate), Billing, Revenue, T&M, Captialization, and markup percentages.

Fields (10)

Column = COBOL field name without the AXX- 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
#AXX-ACTIVITY-GRP PK
ACTIVITY_GRP
Alpha 15Required. This is the activity group for the account category.AC06.1, AC06.2, AC105, AC110, AC120, AC560
#AXX-ACTIVITY PK
ACTIVITY
Alpha 15Identifies the posting level activity for which override edits exist for account category detail.AC06.1, AC06.2, AC105, AC110, AC120, AC560
#AXX-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 Lawson Project Accounting application. 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. The error suspense account category is automatically assigned to all activities.AC06.1, AC06.2, AC105
#AXX-BILLABLE-FLAG
BILLABLE_FLAG
Alpha 1This flag indicates whether an account category is billable.
  • Y Billable
  • N Non-billable
AC06.1, AC06.2, AC105
#AXX-CAPITAL-FLAG
CAPITAL_FLAG
Alpha 1This flag indicates whether an account category is to be capitalized.
  • Y Yes
  • N No
AC06.1, AC06.2, AC105
#AXX-MARK-UP-PCT
MARK_UP_PCT
Signed 5.2This field indicates the percentage of markup for billing. If an account category is billable, a mark-up percentage can be established. A rate schedule is for labor transactions only. Mark-up percentages will increase the amount by the percent entered.AC06.1, AC06.2, AC105
#AXX-REVENUE-FLAG
REVENUE_FLAG
Alpha 1This flag identifies whether an activity/account category is eligible for revenue recognition.
  • Y Yes
  • N No
AC06.1, AC06.2, AC105
#AXX-TM-FLAG
TM_FLAG
Alpha 1This flag indicates whether this account category represents time (labor) or materials for T&M processing.
  • M Materials
  • T Time
AC06.1, AC06.2, AC105
#AXX-SUM-ACCT-CAT
SUM_ACCT_CAT
Alpha 5Identifies the summary account category the detail account category is assigned to in the category structure (lowest summary level account category in the structure).AC06.1, AC06.2, AC105, AC108
#AXX-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The account category status. Valid values are "A" Active and "I" Inactive.
  • A Active
  • I Inactive
AC06.1, AC06.2, AC105

Indexes (4)

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
AXXSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. ACCT-CATEGORY
PrimaryAC06.1, AC06.2, AC10.1, AC10.3, AC105, AC108, AC110, AC112 +22 more (list truncated in source)
AXXSET2
  1. ACTIVITY-GRP
  2. ACCT-CATEGORY
  3. ACTIVITY
AC105, AC108
AXXSET4
  1. ACCT-CATEGORY
  2. ACTIVITY-GRP
  3. ACTIVITY
—
AXXSET6
  1. ACTIVITY
  2. ACTIVITY-GRP
  3. ACCT-CATEGORY
AC10.1, HAXX.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTGRPACACTIVITYACAMCODEACBUDHDRACCATSUMACBRDNDTLACBUDDTLACCOMMITACCOMMITXACGLACCTACMASTERACTRANSACACCTCATX

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
AXX-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
AXX-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYNot Required
AXX-ACTIVITY→ACV-ACTIVITY
AcamcodeACAMCODENot Required
AXX-ACTIVITY→MCD-ACTIVITY
AXX-ACCT-CATEGORY→MCD-ACCT-CATEGORY
AcbudhdrACBUDHDRNot Required
AXX-ACTIVITY-GRP→BDH-ACTIVITY-GRP
AXX-ACTIVITY→BDH-ACTIVITY
ACV-ACTIVE-BUD→BDH-BUDGET-NBR
AccatsumACCATSUMRequired
ACV-STRUCTURE→SRS-STRUCTURE
AXX-SUM-ACCT-CAT→SRS-SUM-ACCT-CAT

One to many (9) — child tables

RelationTableRulesConditionField map
AcbrdndtlACBRDNDTL
AXX-ACTIVITY-GRP→BRD-ACTIVITY-GRP
AXX-ACTIVITY→BRD-ACTIVITY
AXX-ACCT-CATEGORY→BRD-ACCT-CATEGORY
—→BRD-BURDEN-CD
—→BRD-POOL-NBR
AcbuddtlACBUDDTL
AXX-ACTIVITY-GRP→BDT-ACTIVITY-GRP
AXX-ACTIVITY→BDT-ACTIVITY
ACV-ACTIVE-BUD→BDT-BUDGET-NBR
AXX-ACCT-CATEGORY→BDT-ACCT-CATEGORY
—→BDT-FISCAL-YEAR
AccommitACCOMMIT
AXX-ACTIVITY-GRP→MIT-ACTIVITY-GRP
AXX-ACTIVITY→MIT-ACTIVITY
AXX-ACCT-CATEGORY→MIT-ACCT-CATEGORY
—→MIT-FISCAL-YEAR
—→MIT-PERIOD
—→MIT-SYSTEM
—→MIT-COMPANY
—→MIT-CURRENCY-CODE
AccommitxACCOMMITX
AXX-ACTIVITY-GRP→MIX-ACTIVITY-GRP
AXX-ACTIVITY→MIX-ACTIVITY
AXX-ACCT-CATEGORY→MIX-ACCT-CATEGORY
—→MIX-FISCAL-YEAR
—→MIX-PERIOD
—→MIX-SYSTEM
—→MIX-COMPANY
—→MIX-CURRENCY-CODE
—→MIX-ATN-OBJ-ID
AcglacctACGLACCT
AXX-ACTIVITY-GRP→AGA-ACTIVITY-GRP
AXX-ACTIVITY→AGA-ACTIVITY
AXX-ACCT-CATEGORY→AGA-ACCT-CATEGORY
—→AGA-SEQ-NUMBER
AcmasterACMASTER
AXX-ACTIVITY-GRP→MST-ACTIVITY-GRP
AXX-ACTIVITY→MST-ACTIVITY
AXX-ACCT-CATEGORY→MST-ACCT-CATEGORY
—→MST-FISCAL-YEAR
Actrans CommitACTRANS
AXX-ACTIVITY-GRP→ATN-ACTIVITY-GRP
AXX-ACTIVITY→ATN-ACTIVITY
AXX-ACCT-CATEGORY→ATN-ACCT-CATEGORY
—→ATN-POSTING-DATE
—→ATN-OBJ-ID
Actrans PostedACTRANS
AXX-ACTIVITY-GRP→ATN-ACTIVITY-GRP
AXX-ACTIVITY→ATN-ACTIVITY
AXX-ACCT-CATEGORY→ATN-ACCT-CATEGORY
—→ATN-POSTING-DATE
—→ATN-OBJ-ID
Actrans ReleasACTRANS
AXX-ACTIVITY-GRP→ATN-ACTIVITY-GRP
AXX-ACTIVITY→ATN-ACTIVITY
AXX-ACCT-CATEGORY→ATN-ACCT-CATEGORY
—→ATN-POSTING-DATE
—→ATN-OBJ-ID

Programs

Updated by (9)

Referenced by (467)