ACCATSUMX – Account Category Summ Detail

System
Activity Management (AC)
Prefix
SRX
Primary key
STRUCTURE, ACCT-CATEGORY
Fields
13
Updated by
8 programs
Referenced by
597 programs

ACCATSUMX is the Account Category Summ Detail table in Lawson Activity Management (prefix SRX). It is indexed by STRUCTURE, ACCT-CATEGORY (SRXSET1); alternate indexes: SRXSET2, SRXSET3 and SRXSET4. It is related 1:1 to ACACCTCAT, ACCATSUM, ACCTSMXBOD and STRUCTURE and 1:M to ACACCTCATX, ACCATMXVAL, ACCATMXVDT, MXLISTMBR and ACCATSUM. It is updated by AC08.2, AC08.3, AC08.4, AC08.5, AC08.7, AC108, AC558 and AC708 and referenced by AC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC05.1, AC05.2, AC05.3 and 589 more. The table has 13 fields, 4 indexes and 9 documented relations.

About ACCATSUMX

This file contains all account categories assigned to the summary account cateogries in the category structure. This file is maintained via AC08.3 (Account Category Detail).

Fields (13)

Column = COBOL field name without the SRX- 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
#SRX-STRUCTURE PK
STRUCTURE		Alpha 15The name of the category structure.AC08.3, AC08.4, AC08.5, AC558
#SRX-SUM-ACCT-CAT SET2 SET4
SUM_ACCT_CAT		Alpha 5The name of the summary account category.AC08.3, AC08.5, AC08.7, AC108, AC558
#SRX-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 thruAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +12 more
#SRX-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the detail account category. Valid values include: A - Active I - Inactive
  • A Active
  • I Inactive
AC08.3, AC08.5, AC558
#SRX-BILLABLE-FLAG
BILLABLE_FLAG		Alpha 1This flag indicates whether an account category is billable. The default is No.
  • Y Yes
  • N No
AC08.3, AC08.5, AC558
#SRX-CAPITAL-FLAG
CAPITAL_FLAG		Alpha 1This flag indicates whether an account category is to be capitalized.
  • Y Yes
  • N No
AC08.3, AC08.5, AC558
#SRX-REVENUE-FLAG
REVENUE_FLAG		Alpha 1This flag identifies whether an account category is eligible for revenue recognition.
  • Y Yes
  • N No
AC08.3, AC08.5, AC558
#SRX-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
AC08.3, AC08.5, AC558
#SRX-MARK-UP-PCT
MARK_UP_PCT		Signed 5.2This field indicates the percentage of markup for billing. If an account category is billable, a markup percentage can be established. A rate scheudled is for labor transactions only. Markup percentages will increase teh cost amount by the percentage entered.AC08.3, AC08.5, AC558
#SRX-NEW-SUM-CAT
NEW_SUM_CAT		Alpha 5The name of the summary account category.AC08.5, AC08.7, AC108
#SRX-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.AC08.5, AC08.7, AC108
#SRX-UPD-USR-ID
UPD_USR_ID		Alpha 10This field is used to store the login id of the person who entered the record.AC08.5, AC08.7, AC108
#SRX-OBJ-ID SET3
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AC08.3, AC08.4, AC08.5, AC558, AC708

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
SRXSET1
  1. STRUCTURE
  2. ACCT-CATEGORY
PrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC05.1, AC05.2, AC05.3 +22 more (list truncated in source)
SRXSET2
  1. STRUCTURE
  2. SUM-ACCT-CAT
  3. ACCT-CATEGORY
KeyChangeAC08.1, AC08.3, AC08.5, AC08.6, AC08.7, AC108, AC208, AC295 +22 more (list truncated in source)
SRXSET3
  1. OBJ-ID
  2. STRUCTURE
  3. ACCT-CATEGORY
KeyChangeAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
SRXSET4
  1. ACCT-CATEGORY
  2. STRUCTURE
  3. SUM-ACCT-CAT
KeyChangeAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
SRX-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AccatsumACCATSUMRequired
SRX-STRUCTURE→SRS-STRUCTURE
SRX-SUM-ACCT-CAT→SRS-SUM-ACCT-CAT
AcctsmxbodACCTSMXBODNot Required, Delete Cascades
SRX-STRUCTURE→YAG-STRUCTURE
SRX-ACCT-CATEGORY→YAG-ACCT-CATEGORY
StructureSTRUCTURERequired
SRX-STRUCTURE→SRE-STRUCTURE

One to many (5) — child tables

RelationTableRulesConditionField map
AcacctcatxACACCTCATX
SRX-ACCT-CATEGORY→AXX-ACCT-CATEGORY
—→AXX-ACTIVITY-GRP
—→AXX-ACTIVITY
AccatmxvalACCATMXVAL
SRX-OBJ-ID→AJB-OBJ-ID
—→AJB-MATRIX-CAT
AccatmxvdtACCATMXVDT
SRX-OBJ-ID→MXB-OBJ-ID
—→MXB-MATRIX-CAT
—→MXB-EFFECTIVE-DATE
MxlistmbrMXLISTMBR
"ACCAT"→MLM-OBJ-TYPE
SRX-OBJ-ID→MLM-OBJ-ID
—→MLM-MATRIX-LIST
Sum Act DetailACCATSUM
SRX-STRUCTURE→SRS-STRUCTURE
—→SRS-SUM-ACCT-CAT

Programs

Updated by (8)

Referenced by (597)