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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AXXSET1ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORYPrimaryAC06.1, AC06.2, AC10.1, AC10.3, AC105, AC108, AC110, AC112 +22 more (list truncated in source)
AXXSET2ACTIVITY-GRP, ACCT-CATEGORY, ACTIVITYAC105, AC108
AXXSET4ACCT-CATEGORY, ACTIVITY-GRP, ACTIVITY—
AXXSET6ACTIVITY, ACTIVITY-GRP, ACCT-CATEGORYAC10.1, HAXX.1

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequiredAXX-ACCT-CATEGORY → AAX-ACCT-CATEGORY
AcactgrpACACTGRPRequiredAXX-ACTIVITY-GRP → AGP-ACTIVITY-GRP
AcactivityACACTIVITYNot RequiredAXX-ACTIVITY → ACV-ACTIVITY
AcamcodeACAMCODENot RequiredAXX-ACTIVITY → MCD-ACTIVITY, AXX-ACCT-CATEGORY → MCD-ACCT-CATEGORY
AcbudhdrACBUDHDRNot RequiredAXX-ACTIVITY-GRP → BDH-ACTIVITY-GRP, AXX-ACTIVITY → BDH-ACTIVITY, ACV-ACTIVE-BUD → BDH-BUDGET-NBR
AccatsumACCATSUMRequiredACV-STRUCTURE → SRS-STRUCTURE, AXX-SUM-ACCT-CAT → SRS-SUM-ACCT-CAT

One to many (9) — child tables

RelationTableRulesConditionField map
AcbrdndtlACBRDNDTLAXX-ACTIVITY-GRP → BRD-ACTIVITY-GRP, AXX-ACTIVITY → BRD-ACTIVITY, AXX-ACCT-CATEGORY → BRD-ACCT-CATEGORY, → BRD-BURDEN-CD, → BRD-POOL-NBR
AcbuddtlACBUDDTLAXX-ACTIVITY-GRP → BDT-ACTIVITY-GRP, AXX-ACTIVITY → BDT-ACTIVITY, ACV-ACTIVE-BUD → BDT-BUDGET-NBR, AXX-ACCT-CATEGORY → BDT-ACCT-CATEGORY, → BDT-FISCAL-YEAR
AccommitACCOMMITAXX-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
AccommitxACCOMMITXAXX-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
AcglacctACGLACCTAXX-ACTIVITY-GRP → AGA-ACTIVITY-GRP, AXX-ACTIVITY → AGA-ACTIVITY, AXX-ACCT-CATEGORY → AGA-ACCT-CATEGORY, → AGA-SEQ-NUMBER
AcmasterACMASTERAXX-ACTIVITY-GRP → MST-ACTIVITY-GRP, AXX-ACTIVITY → MST-ACTIVITY, AXX-ACCT-CATEGORY → MST-ACCT-CATEGORY, → MST-FISCAL-YEAR
Actrans CommitACTRANSAXX-ACTIVITY-GRP → ATN-ACTIVITY-GRP, AXX-ACTIVITY → ATN-ACTIVITY, AXX-ACCT-CATEGORY → ATN-ACCT-CATEGORY, → ATN-POSTING-DATE, → ATN-OBJ-ID
Actrans PostedACTRANSAXX-ACTIVITY-GRP → ATN-ACTIVITY-GRP, AXX-ACTIVITY → ATN-ACTIVITY, AXX-ACCT-CATEGORY → ATN-ACCT-CATEGORY, → ATN-POSTING-DATE, → ATN-OBJ-ID
Actrans ReleasACTRANSAXX-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)