SNREVMAP – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
S08
Primary key
BUD-OBJ-ID, SC-REV-NODE, REV-ACCT-TYPE
Fields
18
Updated by
2 programs
Referenced by
2 programs

SNREVMAP is a Lawson Smart Notification table (prefix S08); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, SC-REV-NODE, REV-ACCT-TYPE (S08SET1); alternate indexes: S08SET2. It is updated by SN60.2 and SNFL.1 and referenced by SNRA.1 and SNRP.1. The table has 18 fields, 2 indexes and 0 documented relations.

About SNREVMAP

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the S08- 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
#S08-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
#S08-SC-REV-NODE PK
SC_REV_NODE		Alpha 50 (Lower Case)—SN60.2
#S08-REV-ACCT-TYPE PK
REV_ACCT_TYPE		Alpha 1—
  • C Cost of Sales
  • R Revenue
SN60.2
#S08-REV-NODE-TYPE
REV_NODE_TYPE		Alpha 12 (Lower Case)Rollup Price-VolumeSN60.2
#S08-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.2
#S08-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.SN60.2
#S08-ACCT-UNIT-LIST
ACCT_UNIT_LIST		Alpha 12—SN60.2
#S08-CHART-NAME
CHART_NAME		Alpha 12This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.SN60.2
#S08-SUMMARY-ACCT
SUMMARY_ACCT		Alpha 12——
#S08-SUMRY-ACCT-ID
SUMRY_ACCT_ID		Numeric 6You can work with the summary account you defined in chart of accounts.SN60.2
#S08-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.SN60.2
#S08-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.SN60.2
#S08-ACCOUNT-LIST
ACCOUNT_LIST		Alpha 12—SN60.2
#S08-FB-COMPANY SET2
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.SN60.2
#S08-FB-ACCT-UNIT SET2
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.SN60.2
#S08-FB-ACCOUNT SET2
FB_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.SN60.2
#S08-FB-SUB-ACCOUNT SET2
FB_SUB_ACCOUNT		Numeric 4This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.SN60.2
#S08-PARENT-BUS-UNT
PARENT_BUS_UNT		Alpha 50 (Lower Case)—SN60.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
S08SET1
  1. BUD-OBJ-ID
  2. SC-REV-NODE
  3. REV-ACCT-TYPE
PrimarySN60.2, SNFL.1, SNRA.1, SNRP.1
S08SET2
  1. BUD-OBJ-ID
  2. FB-COMPANY
  3. FB-ACCT-UNIT
  4. FB-ACCOUNT
  5. FB-SUB-ACCOUNT
  6. SC-REV-NODE
  7. REV-ACCT-TYPE
KeyChange—

Programs

Updated by (2)

Referenced by (2)