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.

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

IndexKeysFlagsConditionUsed in
SRESET1STRUCTUREPrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC05.2, AC05.3, AC08.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
StrucbodSTRUCBODNot Required, Delete CascadesSRE-STRUCTURE → YCH-STRUCTURE

One to many (2) — child tables

RelationTableRulesConditionField map
AccatsumACCATSUMSRE-STRUCTURE → SRS-STRUCTURE, → SRS-SUM-ACCT-CAT
AccatsumxACCATSUMXSRE-STRUCTURE → SRX-STRUCTURE, → SRX-ACCT-CATEGORY

Programs

Updated by (4)

Referenced by (152)