SNTYPE – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S18
Primary key
BUD-OBJ-ID, SC-HC-TYPE
Fields
6
Updated by
4 programs
Referenced by
4 programs

SNTYPE is a Lawson Smart Notification table (prefix S18); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, SC-HC-TYPE (S18SET1). It is updated by SN60.4, SN80.3, SNFL.1 and SNGE.1 and referenced by SN75.1, SNEM.1, SNHC.1 and SNTY.1. The table has 6 fields, 1 index and 0 documented relations.

About SNTYPE

No description in the Lawson data dictionary.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
S18-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.SN60.4, SN80.3, SNGE.1
S18-SC-HC-TYPE PK
SC_HC_TYPE
Alpha 50 (Lower Case)SN60.4, SN80.3, SNGE.1
S18-SC-DESCRIPTION
SC_DESCRIPTION
Alpha 100 (Lower Case)SN80.3, SNGE.1
S18-SC-RECONCILE
SC_RECONCILE
Numeric 1SNGE.1
S18-SC-UPDATE-DATE
SC_UPDATE_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.SNGE.1
S18-SC-UPDATE-TIME
SC_UPDATE_TIME
Numeric 8This field is updated automatically to indicate the time that the GL entry was created. It is system-maintained.SNGE.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
S18SET1BUD-OBJ-ID, SC-HC-TYPEPrimarySN60.4, SN75.1, SN80.3, SN80.4, SNEM.1, SNFL.1, SNGE.1, SNHC.1 +1 more

Programs

Updated by (4)

Referenced by (4)