STRUCTURE – Category Structure

System
Activity Management (AC)
Prefix
SRE
Primary key
STRUCTURE
Fields
6
Updated by
4 programs
Referenced by
152 programs

STRUCTURE is the Category Structure table in Lawson Activity Management (prefix SRE). It is indexed by STRUCTURE (SRESET1). It is related 1:1 to STRUCBOD and 1:M to ACCATSUM and ACCATSUMX. It is updated by AC08.1, AC08.2, AC08.4 and AC558 and referenced by AC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC05.2, AC05.3, AC10.1 and 144 more. The table has 6 fields, 1 index and 3 documented relations.

About STRUCTURE

The category structure provides the ability to create a set of account categories. The category structure is assigned to an activity group. All account categories assigned to the structure are available for posting. The Category Structure is added and maintained via AC08. The category structure includes summary accounts, making up to 9 levels of summarization available in reports. At summary level 1, a single summary account category will represent each category type to used in the structure (Costs, Revenue, Accrual, Fee and Pass Thru). The detail account categories assigned to the category structure contain the edit flags (billing, revenue, markup, etc.). Posting activities requiring parameters differnt than those in the category structure can be added using the Account Category Assignment form (AC06).

Fields (6)

Column = COBOL field name without the SRE- 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
#SRE-STRUCTURE PK
STRUCTURE		Alpha 15The name of the category structure.AC08.2, AC08.4, AC558
#SRE-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC08.2, AC08.4, AC558
#SRE-LAST-SEQ-NBR-A
LAST_SEQ_NBR_A		Numeric 6Identifies the last sequence number used. Ensures the record is unique.AC08.1, AC558
#SRE-LAST-SEQ-NBR-C
LAST_SEQ_NBR_C		Numeric 6Identifies the last sequence number used. Ensures the record is unique.AC08.1, AC558
#SRE-LAST-SEQ-NBR-P
LAST_SEQ_NBR_P		Numeric 6Identifies the last sequence number used. Ensures the record is unique.AC08.1, AC558
#SRE-LAST-SEQ-NBR-R
LAST_SEQ_NBR_R		Numeric 6Identifies the last sequence number used. Ensures the record is unique.AC08.1, AC558

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
SRESET1
  1. STRUCTURE
PrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC05.2, AC05.3, AC08.1 +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)
STRUCBODACCATSUMACCATSUMXSTRUCTURE

One to one (1) — lookups and parents

RelationTableRulesConditionField map
StrucbodSTRUCBODNot Required, Delete Cascades
SRE-STRUCTURE→YCH-STRUCTURE

One to many (2) — child tables

RelationTableRulesConditionField map
AccatsumACCATSUM
SRE-STRUCTURE→SRS-STRUCTURE
—→SRS-SUM-ACCT-CAT
AccatsumxACCATSUMX
SRE-STRUCTURE→SRX-STRUCTURE
—→SRX-ACCT-CATEGORY

Programs

Updated by (4)

Referenced by (152)