Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNSTOCK


                              BNSTOCK FILE

REFERENCED BY

HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BSK-STOCK-SYMBOL       Alpha 6
Element: Stock Symbol

BSK-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field displays the description.

BSK-MKT-VAL-DATE       Numeric 8  (yyyymmdd)
Element: Mkt Val Date

BSK-FAIR-MKT-VAL       Signed 9.4
Element: Fair Mkt Val

BSK-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

BSK-CURR-ND            Numeric 1
Account Currency
Code

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

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

BSK-USER-ID            Alpha 10  (Lower Case)
Element: User

                         BNSTOCK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSKSET1   STOCK-SYMBOL  KeyChange                                HR00.1  HR01.1
                                                                 PBIP.1  PR197

                         BNSTOCK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Currency       CUCODES      Not Required

                            BSK-CURRENCY-CODE    -> CUC-CURRENCY-CODE

                         BNSTOCK FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Options        BNSTKGNT

                            BSK-STOCK-SYMBOL     -> BSG-STOCK-SYMBOL
                                                    BSG-COMPANY
                                                    BSG-OPT-GRANT-NBR

Splits         BNSTKSPLT

                            BSK-STOCK-SYMBOL     -> BSP-STOCK-SYMBOL
                                                    BSP-SPLIT-DATE