VESTSCHDHD – Vesting Schedule Header
- System
- Benefits (BN)
- Prefix
VSH- Primary key
COMPANY,VEST-SCHED- Fields
- 3
- Updated by
- 2 programs
- Referenced by
- 8 programs
VESTSCHDHD is the Vesting Schedule Header table in Lawson Benefits (prefix VSH). It is indexed by COMPANY, VEST-SCHED (VSHSET1). It is related 1:1 to BNCOMPANY and PRSYSTEM and 1:M to VESTSCHDDT. It is updated by BN00.1 and BN03.1 and referenced by BN137, BN15.1, BN203, BN215, BN223, BN23.1, BN33.1 and BN33.2. The table has 3 fields, 1 index and 3 documented relations.
About VESTSCHDHD
The Vesting Schedule Header file contains information about vesting schedules. BN03.1 (Vesting Schedule) is the primary program that updates this file.
Fields (3)
Column = COBOL field name without the VSH- 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 |
|---|---|---|---|
#VSH-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. The number correlates all information about the company. | BN03.1 |
#VSH-VEST-SCHED PKVEST_SCHED | Alpha 2 | Contains the code that represents the vesting schedule. | BN03.1 |
#VSH-DESCDESC | Alpha 30 (Lower Case) | Contains the description of the vesting schedule. | BN03.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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
VSHSET1 |
| Primary | BN00.1, BN03.1, BN137, BN15.1, BN203, BN215, BN223, BN23.1 +2 more |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | BNCOMPANY | Required |
| |||||||
| Company Name | PRSYSTEM | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Vesting Detail | VESTSCHDDT | Delete Restricted |
|