SNORGMAP – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S05
Primary key
BUD-OBJ-ID, SC-DEPT-CODE
Fields
11
Updated by
4 programs
Referenced by
7 programs

SNORGMAP is a Lawson Smart Notification table (prefix S05); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, SC-DEPT-CODE (S05SET1); alternate indexes: S05SET2. It is updated by SN70.2, SNAU.1, SNFL.1 and SNOM.1 and referenced by SN75.2, SNDA.1, SNEM.1, SNHC.1, SNOD.1, SNSA.1 and SNSP.1. The table has 11 fields, 2 indexes and 0 documented relations.

About SNORGMAP

No description in the Lawson data dictionary.

Fields (11)

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

Field / columnTypeDescription & valuesUpdated by
S05-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.2, SNOM.1
S05-SC-DEPT-CODE PK
SC_DEPT_CODE
Alpha 50 (Lower Case)SN70.2, SNOM.1
S05-SC-OPEX-LINE
SC_OPEX_LINE
Alpha 50 (Lower Case)SNOM.1
S05-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.2, SNOM.1
S05-ACCT-UNIT
ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.SN70.2, SNOM.1
S05-ACCT-UNIT-LIST
ACCT_UNIT_LIST
Alpha 12SN70.2, SNOM.1
S05-FB-COMPANY
FB_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.2, SNOM.1
S05-FB-ACCT-UNIT
FB_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.SN70.2, SNOM.1
S05-TEMPLATE-HEADC
TEMPLATE_HEADC
Alpha 15The name of the template the detail records are associated to.SN70.2
S05-TEMPLATE-HEADT
TEMPLATE_HEADT
Alpha 15The name of the template the detail records are associated to.SN70.2
S05-TEMPLATE-SPEND
TEMPLATE_SPEND
Alpha 15The name of the template the detail records are associated to.SN70.2

Indexes (2)

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

IndexKeysFlagsConditionUsed in
S05SET1BUD-OBJ-ID, SC-DEPT-CODEPrimarySN70.2, SN75.2, SNAU.1, SNDA.1, SNEM.1, SNFL.1, SNHC.1, SNOD.1 +3 more
S05SET2BUD-OBJ-ID, FB-COMPANY, FB-ACCT-UNIT, SC-DEPT-CODEKeyChange

Programs

Updated by (4)

Referenced by (7)