SNBUDNAMES – No description in the Lawson data dictionary
- System
- Smart Notification (SN)
- Prefix
S09- Primary key
BUD-OBJ-ID,EXCHANGE-KEY- Fields
- 5
- Updated by
- 2 programs
- Referenced by
- 18 programs
SNBUDNAMES is a Lawson Smart Notification table (prefix S09); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, EXCHANGE-KEY (S09SET1); alternate indexes: S09SET2 and S09SET3. It is updated by SNFL.1 and SNFL.2 and referenced by SN120, SN130, SN70.3, SNAU.1, SNCT.1, SNCU.1, SNDA.1, SNEM.1 and 10 more. The table has 5 fields, 3 indexes and 0 documented relations.
About SNBUDNAMES
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the S09- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#S09-BUD-OBJ-ID PKBUD_OBJ_ID | Numeric 12 | This 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. | SNFL.1 |
#S09-EXCHANGE-KEY PKEXCHANGE_KEY | Numeric 3 | — | SNFL.1 |
#S09-EXCHANGE-TYPE SET3EXCHANGE_TYPE | Alpha 30 (Lower Case) | — | SNFL.1 |
#S09-ETL-TYPE SET3ETL_TYPE | Alpha 1 | —
| SNFL.1 |
#S09-FILE-NAME SET2FILE_NAME | Alpha 30 (Lower Case) | — | SNFL.1, SNFL.2 |
Indexes (3)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
S09SET1 |
| Primary | SN120, SN130, SN70.3, SNAU.1, SNCT.1, SNCU.1, SNDA.1, SNEM.1 +12 more | |
S09SET2 |
| KeyChange | — | |
S09SET3 |
| KeyChange | — |
Programs
Updated by (2)
Referenced by (18)
- SN120 Import to Budget and Planning
- SN130 Import to Back-Office
- SN70.3 Budgeting and Planning List
- SNAU.1 Build Planning Organization Structure
- SNCT.1 Headcount Categories
- SNCU.1 Headcount Categories
- SNDA.1 Build Planning Department Structure
- SNEM.1 Employees
- SNFT.1 CSV File Load
- SNGE.1 CSV File Load
- SNHC.1 Retrieve Employees
- SNOA.1 RETRIEVE ACTUALS
- SNOP.1 REVENUE PLANNED
- SNRA.1 RETRIEVE ACTUALS
- SNRP.1 REVENUE PLANNED
- SNSA.1 RETRIEVE ACTUALS
- SNSP.1 REVENUE PLANNED
- SNTY.1 Headcount Types