Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              BNSTOCK FILE

REFERENCED BY

HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BSK-STOCK-SYMBOL     Alpha 6
Stock Symbol

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

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

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

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


BSK-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

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

BSK-USER-ID          Alpha 10  (Lower Case)
User ID Name         Contains the user ID of the person who
                     last changed this record.

                         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