SNTEMPLDTL – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S52
Primary key
BUD-OBJ-ID, TEMPLATE, SC-CODE
Fields
3
Updated by
6 programs
Referenced by
4 programs

SNTEMPLDTL is a Lawson Smart Notification table (prefix S52); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, TEMPLATE, SC-CODE (S52SET1); alternate indexes: S52SET2. It is updated by SN60.1, SN75.1, SN75.2, SN80.2, SN80.3 and SNFL.1 and referenced by SNDA.1, SNEM.1, SNHC.1 and SNSA.1. The table has 3 fields, 2 indexes and 0 documented relations.

About SNTEMPLDTL

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the S52- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
S52-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.SN75.1
S52-TEMPLATE PK
TEMPLATE
Alpha 15The name of the template the detail records are associated to.SN75.1
S52-SC-CODE PK
SC_CODE
Alpha 50 (Lower Case)SN75.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
S52SET1BUD-OBJ-ID, TEMPLATE, SC-CODEPrimarySN75.1, SN75.2, SNDA.1, SNEM.1, SNFL.1, SNHC.1, SNSA.1
S52SET2BUD-OBJ-ID, SC-CODE, TEMPLATESN60.1, SN80.2, SN80.3

Programs

Updated by (6)

Referenced by (4)