SNBUSUNIT – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S20
Primary key
BUD-OBJ-ID, BUS-UNIT-ID
Fields
19
Updated by
3 programs
Referenced by
1 program

SNBUSUNIT is a Lawson Smart Notification table (prefix S20); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, BUS-UNIT-ID (S20SET1); alternate indexes: S20SET2 and S20SET3. It is updated by SN120, SN70.1 and SNFL.1 and referenced by SNAU.1. The table has 19 fields, 3 indexes and 0 documented relations.

About SNBUSUNIT

No description in the Lawson data dictionary.

Fields (19)

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

Field / columnTypeDescription & valuesUpdated by
S20-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.1
S20-BUS-UNIT-ID PK
BUS_UNIT_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.1
S20-BUS-UNIT-CODE
BUS_UNIT_CODE		Alpha 50 (Lower Case)—SN70.1
S20-BUS-UNIT-NAME
BUS_UNIT_NAME		Alpha 60 (Lower Case)—SN70.1
S20-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.SN70.1
S20-CC-ATTRIBUTE
CC_ATTRIBUTE		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.1
S20-CC-VALUE
CC_VALUE		Alpha 32The attribute value.SN70.1
S20-RL-ATTRIBUTE
RL_ATTRIBUTE		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.—
S20-RL-VALUE
RL_VALUE		Alpha 32The attribute value.—
S20-MATRIX-VIEW
MATRIX_VIEW		Alpha 12The Attribute View field contains the accounting unit view being used for alternate roll-ups. Any posting accounting units listed in a view that is used for alternate roll-ups must also be included in one of the company, accounting, or company groups.SN70.1
S20-CODE-PREFIX
CODE_PREFIX		Alpha 5 (Lower Case)—SN70.1
S20-PREFIX-DELIM
PREFIX_DELIM		Alpha 1 (Lower Case)——
S20-CODE-OPTION
CODE_OPTION		Alpha 1—SN70.1
S20-NAME-OPTION
NAME_OPTION		Alpha 1—SN70.1
S20-OPEX-LN-ATTR
OPEX_LN_ATTR		Alpha 12—SN70.1
S20-OPEX-LN-VALUE
OPEX_LN_VALUE		Alpha 32The attribute value.—
S20-DEFAULT-OPEX
DEFAULT_OPEX		Alpha 60 (Lower Case)—SN70.1
S20-DFLT-SALARY-OP
DFLT_SALARY_OP		Alpha 15 (Lower Case)—SN70.1
S20-BUILD-STATUS
BUILD_STATUS		Alpha 1—SN120, SN70.1

Indexes (3)

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

IndexKeysFlagsConditionUsed in
S20SET1BUD-OBJ-ID, BUS-UNIT-IDPrimarySN70.1, SNFL.1
S20SET2BUD-OBJ-ID, BUS-UNIT-CODESN120, SN70.1, SNAU.1
S20SET3BUD-OBJ-ID, BUILD-STATUS, BUS-UNIT-IDKeyChangeSN120

Programs

Updated by (3)

Referenced by (1)