SNBUDNAMES – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S09
Primary key
BUD-OBJ-ID, EXCHANGE-KEY
Fields
5
Updated by
2 programs
Referenced by
18 programs

SNBUDNAMES is a Lawson Smart Notification table (prefix S09); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, EXCHANGE-KEY (S09SET1); alternate indexes: S09SET2 and S09SET3. It is updated by SNFL.1 and SNFL.2 and referenced by SN120, SN130, SN70.3, SNAU.1, SNCT.1, SNCU.1, SNDA.1, SNEM.1 and 10 more. The table has 5 fields, 3 indexes and 0 documented relations.

About SNBUDNAMES

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
S09-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.SNFL.1
S09-EXCHANGE-KEY PK
EXCHANGE_KEY		Numeric 3—SNFL.1
S09-EXCHANGE-TYPE
EXCHANGE_TYPE		Alpha 30 (Lower Case)—SNFL.1
S09-ETL-TYPE
ETL_TYPE		Alpha 1—
  • I Import
  • E Export
SNFL.1
S09-FILE-NAME
FILE_NAME		Alpha 30 (Lower Case)—SNFL.1, SNFL.2

Indexes (3)

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

IndexKeysFlagsConditionUsed in
S09SET1BUD-OBJ-ID, EXCHANGE-KEYPrimarySN120, SN130, SN70.3, SNAU.1, SNCT.1, SNCU.1, SNDA.1, SNEM.1 +12 more
S09SET2BUD-OBJ-ID, FILE-NAME, EXCHANGE-KEYKeyChange—
S09SET3BUD-OBJ-ID, ETL-TYPE, EXCHANGE-TYPEKeyChange—

Programs

Updated by (2)

Referenced by (18)