Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            VESTSCHDHD FILE

                        Vesting Schedule Header

The Vesting Schedule Header file contains information about vesting schedules.

BN03.1 (Vesting Schedule) is the primary program that updates this file.

REFERENCED BY

BN15.1    BN203     BN215

UPDATED BY

BN00.1    BN03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

VSH-COMPANY          Numeric 4                                   BN03.1
Company              Contains the company number. The number
                     correlates all information about the
                     company.

VSH-VEST-SCHED       Alpha 2                                     BN03.1
Schedule             Contains the code that represents the
                     vesting schedule.

VSH-DESC             Alpha 30  (Lower Case)                      BN03.1
Description          Contains the description of the vesting
                     schedule.

                         VESTSCHDHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VSHSET1   COMPANY                                                BN00.1  BN03.1
          VEST-SCHED                                             BN15.1  BN203
                                                                 BN215

                         VESTSCHDHD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            VSH-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            VSH-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

                         VESTSCHDHD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Vesting Detail VESTSCHDDT   Delete Restricted

                            VSH-COMPANY       -> VSD-COMPANY
                            VSH-VEST-SCHED    -> VSD-VEST-SCHED
                                                 VSD-SERV-YEARS