SNDEPT – No description in the Lawson data dictionary
- System
- Smart Notification (SN)
- Prefix
S10- Primary key
BUD-OBJ-ID,SC-DEPT-CODE- Fields
- 13
- Updated by
- 4 programs
- Referenced by
- 0 programs
SNDEPT is a Lawson Smart Notification table (prefix S10); no description in the lawson data dictionary. It is indexed by BUD-OBJ-ID, SC-DEPT-CODE (S10SET1); alternate indexes: S10SET2. It is updated by SN70.2, SNAU.1, SNFL.1 and SNGE.1. The table has 13 fields, 2 indexes and 0 documented relations.
About SNDEPT
No description in the Lawson data dictionary.
Fields (13)
Column = COBOL field name without the S10- 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 |
|---|---|---|---|
#S10-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. | SN70.2, SNAU.1, SNGE.1 |
#S10-SC-DEPT-CODE PKSC_DEPT_CODE | Alpha 50 (Lower Case) | — | SN70.2, SNAU.1, SNGE.1 |
#S10-SC-PARENT-CODESC_PARENT_CODE | Alpha 50 (Lower Case) | — | SNAU.1, SNGE.1 |
#S10-SC-DEPT-NAMESC_DEPT_NAME | Alpha 100 (Lower Case) | — | SNAU.1, SNGE.1 |
#S10-SC-DESCRIPTIONSC_DESCRIPTION | Alpha 100 (Lower Case) | — | SNAU.1, SNGE.1 |
#S10-SC-DEPT-TYPE SET2SC_DEPT_TYPE | Alpha 1 (Lower Case) | — | SN70.2, SNAU.1, SNGE.1 |
#S10-SC-OPEX-LINESC_OPEX_LINE | Alpha 100 (Lower Case) | — | SNAU.1, SNGE.1 |
#S10-SC-SALARY-OPSC_SALARY_OP | Alpha 15 (Lower Case) | — | SNAU.1, SNGE.1 |
#S10-SC-VALIDATESC_VALIDATE | Alpha 1 | — | SNAU.1, SNGE.1 |
#S10-SC-CURRENCYSC_CURRENCY | Alpha 100 (Lower Case) | — | SNAU.1, SNGE.1 |
#S10-SC-RECONCILESC_RECONCILE | Numeric 1 | — | SNAU.1, SNGE.1 |
#S10-SC-UPDATE-DATESC_UPDATE_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | SNGE.1 |
#S10-SC-UPDATE-TIMESC_UPDATE_TIME | Numeric 8 | This field is updated automatically to indicate the time that the GL entry was created. It is system-maintained. | SNGE.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
S10SET1 |
| Primary | SN70.2, SNAU.1, SNFL.1, SNGE.1 | |
S10SET2 |
| SNAU.1 |