SNFLEXSEG – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S12
Primary key
BUD-OBJ-ID, FLEX-SEG-TYPE, FLEX-SEGMENT
Fields
4
Updated by
2 programs
Referenced by
1 program

SNFLEXSEG is a Lawson Smart Notification table (prefix S12); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, FLEX-SEG-TYPE, FLEX-SEGMENT (S12SET1); alternate indexes: S12SET2. It is updated by SN70.4 and SNFL.1 and referenced by SNAU.1. The table has 4 fields, 2 indexes and 0 documented relations.

About SNFLEXSEG

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the S12- 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
#S12-BUD-OBJ-ID PK
BUD_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.SN70.4
#S12-FLEX-SEG-TYPE PK
FLEX_SEG_TYPE		Alpha 1—SN70.4
#S12-FLEX-SEGMENT PK
FLEX_SEGMENT		Alpha 100 (Lower Case)—SN70.4
#S12-MATRIX-CAT SET2
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.SN70.4

Indexes (2)

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
S12SET1
  1. BUD-OBJ-ID
  2. FLEX-SEG-TYPE
  3. FLEX-SEGMENT
PrimarySN70.4, SNAU.1, SNFL.1
S12SET2
  1. BUD-OBJ-ID
  2. FLEX-SEG-TYPE
  3. MATRIX-CAT
SN70.4

Programs

Updated by (2)

Referenced by (1)