Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNSTOCK


                              BNSTOCK FILE

REFERENCED BY

BN107     BN207     BN223     BN23.1    BN33.2

UPDATED BY

BN07.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BSK-STOCK-SYMBOL       Alpha 6                                   BN07.1
Element: Stock Symbol

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

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

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

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

BSK-CURR-ND            Numeric 1                                 BN07.1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


BSK-DATE-STAMP         Numeric 8  (yyyymmdd)                     BN07.1
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)                       BN07.1
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

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

                         BNSTOCK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSKSET1   STOCK-SYMBOL  KeyChange                                BN07.1  BN107
                                                                 BN207   BN223
                                                                 BN23.1  BN33.2

                         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