SNCATMAP – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S15
Primary key
BUD-OBJ-ID, SC-HC-CATEGORY, BO-CATEGORY
Fields
6
Updated by
3 programs
Referenced by
0 programs

SNCATMAP is a Lawson Smart Notification table (prefix S15); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, SC-HC-CATEGORY, BO-CATEGORY (S15SET1); alternate indexes: S15SET2. It is updated by SN60.3, SN80.2 and SNFL.1. The table has 6 fields, 2 indexes and 0 documented relations.

About SNCATMAP

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the S15- 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
#S15-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.3, SN80.2
#S15-SC-HC-CATEGORY PK
SC_HC_CATEGORY		Alpha 50 (Lower Case)—SN60.3, SN80.2
#S15-SC-SAL-ACCT
SC_SAL_ACCT		Alpha 50 (Lower Case)——
#S15-BO-CATEGORY PK
BO_CATEGORY		Alpha 12Contains the user-defined code that represents a position in the company.SN60.3, SN80.2
#S15-HEAD-CAT-OPT
HEAD_CAT_OPT		Alpha 1—SN60.3, SN80.2
#S15-COMPANY
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.SN60.3, SN80.2

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
S15SET1
  1. BUD-OBJ-ID
  2. SC-HC-CATEGORY
  3. BO-CATEGORY
PrimarySN60.3, SN80.2, SNFL.1
S15SET2
  1. BUD-OBJ-ID
  2. BO-CATEGORY
  3. SC-HC-CATEGORY
KeyChangeSN60.3

Programs

Updated by (3)