Smart Notification – Lawson SN tables and programs
Smart Notification (SN) in Lawson S3 v10 MSP6 has 25 tables, 41 online screens and 4 batch programs.
Tables (25)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| SNACAMOUNT | SAT | No description in the Lawson data dictionary | ACTIVITY-GRP, ACTIVITY, SUMM-ACCT-CAT, ACCT-CATEGORY, ACCT-CAT-TYP, COMPANY, ACCT-UNIT, RESOURCE-COMP, RESOURCE-CODE, RESOURCE-TYPE | 33 |
| SNACTMAP | S07 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-ACT-CODE | 9 |
| SNATTACH | S33 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-DEPT-CODE, SC-TYPE, SC-CODE | 4 |
| SNAUDIT | S99 | No description in the Lawson data dictionary | BUD-OBJ-ID, EXCHANGE-KEY, UPDATE-DATE, UPDATE-TIME | 7 |
| SNBUDCAL | S30 | No description in the Lawson data dictionary | BUD-OBJ-ID, BUS-UNIT-ID, FISCAL-YEAR | 5 |
| SNBUDGET | S01 | Smart Notification Budget | BUD-OBJ-ID | 55 |
| SNBUDNAMES | S09 | No description in the Lawson data dictionary | BUD-OBJ-ID, EXCHANGE-KEY | 5 |
| SNBUSUNIT | S20 | No description in the Lawson data dictionary | BUD-OBJ-ID, BUS-UNIT-ID | 19 |
| SNCAT | S17 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-HC-CATEGORY | 7 |
| SNCATMAP | S15 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-HC-CATEGORY, BO-CATEGORY | 6 |
| SNCURRMAP | S35 | No description in the Lawson data dictionary | BUD-OBJ-ID, BO-CURR-CODE | 5 |
| SNDEPT | S10 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-DEPT-CODE | 13 |
| SNFLEXSEG | S12 | No description in the Lawson data dictionary | BUD-OBJ-ID, FLEX-SEG-TYPE, FLEX-SEGMENT | 4 |
| SNGLAMOUNT | SNA | No description in the Lawson data dictionary | COMPANY, ACCT-UNIT, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT | 28 |
| SNGLUNIT | SNU | No description in the Lawson data dictionary | COMPANY, ACCT-UNIT, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT | 28 |
| SNORGMAP | S05 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-DEPT-CODE | 11 |
| SNORGMAPDT | S06 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-DEPT-CODE, POSTING-CO, POSTING-AU | 4 |
| SNPARAM | SN1 | No description in the Lawson data dictionary | SN-PROCESS | 3 |
| SNREVMAP | S08 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-REV-NODE, REV-ACCT-TYPE | 18 |
| SNREVNODE | S80 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-REV-NODE, REV-ACCT-TYPE | 8 |
| SNSPENDACT | S40 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-ACT-CODE | 8 |
| SNTEMPLATE | S51 | Smart Notif Budget Template | BUD-OBJ-ID, TEMPLATE | 4 |
| SNTEMPLDTL | S52 | No description in the Lawson data dictionary | BUD-OBJ-ID, TEMPLATE, SC-CODE | 3 |
| SNTYPE | S18 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-HC-TYPE | 6 |
| SNTYPEMAP | S19 | No description in the Lawson data dictionary | BUD-OBJ-ID, SC-HC-TYPE, BO-TYPE | 5 |
Online screens (41)
| Screen | Description | Updates | References |
|---|---|---|---|
| SN01.1 | General Ledger Notification Parameters | 1 | 5 |
| SN02.1 | Activity Management Notification Parameters | 4 | 21 |
| SN40.1 | Currency Mapping | 2 | 3 |
| SN50.1 | Calendar Definition | 1 | 1 |
| SN60.1 | Spend Account Mapping | 3 | 5 |
| SN60.2 | Revenue Node Mapping | 2 | 6 |
| SN60.3 | Headcount Category Mapping | 2 | 5 |
| SN60.4 | Headcount Type Mapping | 2 | 5 |
| SN70.1 | Department Hierarchy | 1 | 4 |
| SN70.2 | Department Definitions | 2 | 5 |
| SN70.3 | Budgeting and Planning List | 0 | 2 |
| SN70.4 | Department Flex Segments | 1 | 2 |
| SN75.1 | Template Assignment | 1 | 5 |
| SN75.2 | Template Definition | 2 | 3 |
| SN80.1 | Headcount Category Build | 1 | 2 |
| SN80.2 | Build Category List | 4 | 11 |
| SN80.3 | Build Type List | 4 | 11 |
| SN80.4 | Headcount Type Build | 0 | 2 |
| SN85.1 | Planned Headcount | 1 | 4 |
| SN85.2 | Headcount Actuals | 1 | 4 |
| SNAC.1 | Activity Management Notification Update | 4 | 24 |
| SNAU.1 | Build Planning Organization Structure | 3 | 12 |
| SNCT.1 | Headcount Categories | 1 | 3 |
| SNCU.1 | Headcount Categories | 1 | 5 |
| SNDA.1 | Build Planning Department Structure | 0 | 5 |
| SNEM.1 | Employees | 1 | 20 |
| SNFL.1 | Budget Integration Definition | 21 | 24 |
| SNFL.2 | Exchange Audit | 1 | 1 |
| SNFT.1 | CSV File Load | 0 | 2 |
| SNGE.1 | CSV File Load | 5 | 2 |
| SNGL.1 | General Ledger Notification Update | 13 | 24 |
| SNHC.1 | Retrieve Employees | 1 | 15 |
| SNOA.1 | RETRIEVE ACTUALS | 2 | 18 |
| SNOD.1 | Organization Map Posting | 1 | 4 |
| SNOM.1 | Organization Map | 1 | 0 |
| SNOP.1 | REVENUE PLANNED | 11 | 16 |
| SNRA.1 | RETRIEVE ACTUALS | 2 | 19 |
| SNRP.1 | REVENUE PLANNED | 11 | 18 |
| SNSA.1 | RETRIEVE ACTUALS | 2 | 22 |
| SNSP.1 | REVENUE PLANNED | 11 | 18 |
| SNTY.1 | Headcount Types | 1 | 3 |
Batch programs (4)
Other tables used by Smart Notification programs (102)
ACACCTCAT, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE, ACASSIGN, ACBUDDTL, ACCALX, ACCATGRP, ACCATGRPX, ACCATMXVAL, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMITX, ACCONSOL, ACGRPMXVAL, ACMASTER, ACROLE, ACTRANS, ADDRDATA, AUMXVALUE, CMPUTE, CMPUTEAU, CUCODES, CURELAT, CUTABLE, CUTRANSL, DEPTCODE, EBCSVREC, EMPLOYEE, FBADJCODAU, FBADJCODE, FBCNTRLAU, FBCONTROL, FBDETAIL, FBDETAILAU, FBFNDHDRAU, FBFUNDHDR, FBHEADER, FBHEADERAU, FBHISTHDR, FBHSTHDRAU, FBINTBU, FBINTBUAU, FBSPREAD, FBSPREADAU, FBTRANS, FBTRANSAU, GLADDRESS, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCPYGRP, GLMASTER, GLNAMES, GLSYSTEM, GMAWARD, INSTCTRYCD, JOBCLASS, JOBCODE, MLCALMAP, MLCOLEDGER, MXCATDEF, MXELEMENT, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXOBJCAT, MXVIEWDTL, MXVIEWHDR, PAEMPPOS, PAJOBREQ, PAPOSITION, PERSGROUP, PGEMPLOYEE, PRSAGDTL, PRSYSTEM, RADEFINAU, RADEFINE, RATOTALAU, RATOTALS, RWDICT, RWFORMAT, RWFORMATAU, RWGRPDET, RWGRPDETAU, RWHEADAU, RWHEADER, RWREQSTAU, RWREQUEST, RWROWDET, RWROWDTAU, RWUSER, RWUSERAU, STRUCTURE, SYSTEMCODE, ULPOST, ULTOTALS