SNREVNODE – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S80
Primary key
BUD-OBJ-ID, SC-REV-NODE, REV-ACCT-TYPE
Fields
8
Updated by
3 programs
Referenced by
1 program

SNREVNODE is a Lawson Smart Notification table (prefix S80); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, SC-REV-NODE, REV-ACCT-TYPE (S80SET1). It is updated by SN60.2, SNFL.1 and SNGE.1 and referenced by SNRP.1. The table has 8 fields, 1 index and 0 documented relations.

About SNREVNODE

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the S80- 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
#S80-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.2, SNGE.1
#S80-SC-REV-NODE PK
SC_REV_NODE		Alpha 50 (Lower Case)—SN60.2, SNGE.1
#S80-REV-ACCT-TYPE PK
REV_ACCT_TYPE		Alpha 1—SN60.2, SNGE.1
#S80-REV-NODE-TYPE
REV_NODE_TYPE		Alpha 12 (Lower Case)—SNGE.1
#S80-SC-RECONCILE
SC_RECONCILE		Numeric 1—SNGE.1
#S80-SC-UPDATE-DATE
SC_UPDATE_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.SNGE.1
#S80-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
#S80-PARENT-BUS-UNT
PARENT_BUS_UNT		Alpha 50 (Lower Case)—SNGE.1

Indexes (1)

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
S80SET1
  1. BUD-OBJ-ID
  2. SC-REV-NODE
  3. REV-ACCT-TYPE
PrimarySN60.2, SNFL.1, SNGE.1, SNRP.1

Programs

Updated by (3)

Referenced by (1)