Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNSTKSPLT


                             BNSTKSPLT FILE

REFERENCED BY

BN207     BN07.1

UPDATED BY

BN107

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BSP-STOCK-SYMBOL       Alpha 6                                   BN107
Element: Stock Symbol

BSP-SPLIT-DATE         Numeric 8  (yyyymmdd)                     BN107
Element: Split Date

BSP-SPLIT-FROM         Numeric 3                                 BN107
Element: Split From

BSP-SPLIT-TO           Numeric 3                                 BN107
Element: Split To

BSP-PRICE-FROM         Signed 9.4
Element: Price From

BSP-PRICE-TO           Signed 9.4
Element: Price To

BSP-ROUND-METH         Alpha 1                                   BN107
Element: Rounding MethoH = High
                       L = Low
                       N = No Rounding
                       R = Normal Rounding

BSP-BEF-AFT-FLAG       Alpha 1                                   BN107
Element: Before/After  B = Before
                       A = After

BSP-ROUND-TO           Signed 9.4                                BN107
Element: Round To

BSP-DATE-STAMP         Numeric 8  (yyyymmdd)                     BN107
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

BSP-TIME-STAMP         Numeric 6  (hhmmss)                       BN107
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

BSP-USER-ID            Alpha 10  (Lower Case)                    BN107
Element: User          Contains the user ID of the person who
                       last changed this record.

                         BNSTKSPLT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSPSET1   STOCK-SYMBOL                                           BN107   BN207
          SPLIT-DATE

BSPSET2   STOCK-SYMBOL                                           BN07.1  BN107
          SPLIT-DATE*

                         BNSTKSPLT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Stock          BNSTOCK      Required

                            BSP-STOCK-SYMBOL    -> BSK-STOCK-SYMBOL