Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNSTKGNT


                             BNSTKGNT FILE

REFERENCED BY

BN223     BN234     BN33.1    BN33.2    BN33.3    BN33.4
BN533     BN534     HR170     HR70.1    BN07.1

UPDATED BY

BN107     BN137     BN23.1    HR00.1    HR01.1    PBIP.1
PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BSG-COMPANY            Numeric 4                                 BN23.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

BSG-OPT-GRANT-NBR      Alpha 10                                  BN23.1
Element: Opt Grant Nbr

BSG-OPTION-TYPE        Alpha 2                                   BN23.1
Element: Option Type   1 = Incentive Stock Option
                       2 = Non-Qualified
                       3 = Stock Appreciation Rights

BSG-STOCK-SYMBOL       Alpha 6                                   BN23.1
Element: Stock Symbol

BSG-GROUP-NAME         Alpha 10                                  BN23.1
Element: Group Name

BSG-SHARES-AVAIL       Numeric 12                                BN107   BN23.1
Element: Shares Avail

BSG-GRANT-DATE         Numeric 8  (yyyymmdd)                     BN23.1
Element: Grant Date

BSG-GRANT-PRICE        Signed 9.4                                BN107   BN23.1
Element: Grant Price

BSG-EXP-DATE           Numeric 8  (yyyymmdd)                     BN23.1
Element: Expiration Date

BSG-VEST-SCHED         Alpha 2                                   BN23.1
Element: Schedule

BSG-OPT-VEST-FROM      Alpha 2                                   BN23.1
Element: Opt Vest From 1 = Grant Date
                       2 = Hire Date
                       3 = Adjusted Hire Date
                       4 = Anniversary Date
                       5 = Seniority Date
                       6 = BN Date 1
                       7 = BN Date 2
                       8 = BN Date 3
                       9 = BN Date 4
                       10 = BN Date 5

BSG-VEST-FROM          Numeric 8  (yyyymmdd)                     BN23.1
Element: Vest From

BSG-VEST-AS-OF-DT      Numeric 8  (yyyymmdd)                     BN23.1
Element: Vest As Of Dt

BSG-ACTIVE-FLAG        Alpha 1                                   BN23.1
Element: Status        The Active flag of the credit card
                       type.
                       A = Active
                       I = Inactive

BSG-VEST-TYPE          Alpha 1                                   BN23.1
Element: Vest Type     1 = Annual
                       2 = Semi-Annual
                       3 = Quarterly
                       4 = Monthly
                       5 = Daily

BSG-FORFEIT-FLAG       Alpha 1                                   BN23.1
Element: Forfeit Flag  N = No
                       Y = Yes

BSG-WEB-AVAILABLE      Alpha 1                                   BN23.1
Element: Web Available N = No
                       Y = Yes

BSG-WEB-AVAIL-SUPV     Alpha 1                                   BN23.1
Element: Web Avail Supv1 = Not Available
                       2 = Direct Supervisor
                       3 = Indirect Supervisor
                       4 = Direct;Indirect Supervisor
                       " " = Not applicable

BSG-WORKFLOW-FLAG      Alpha 1                                   BN23.1
Element: Workflow      This field determines whether you are
                       using a Workflow system for approving
                       journal entries.

                       N = No
                       Y = Yes

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

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

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

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

BSG-CURR-ND            Numeric 1                                 BN23.1
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

BSG-BASE-GNT-PRICE     Signed 9.4                                BN107   BN23.1
Element: Base Gnt Price

BSG-EXPIRED-FLAG       Alpha 1                                   BN23.1
Element: Expired Flag  N = No
                       Y = Yes

BSG-EXER-WORKFLOW      Alpha 1                                   BN23.1
Element: Exer Workflow N = No
                       Y = Yes

BSG-BASE-CURRENCY      Alpha 5
Element: Base Currency The company base currency.

BSG-BASE-ND            Numeric 1
Base Number Of         The number of decimal positions defined
Decimals               for the company base currency.

BSG-VEST-TERM          Alpha 1                                   BN23.1
Element: Vest Term     N = No
                       Y = Yes

BSG-FAIR-MKT-VAL       Signed 9.4                                BN107   BN23.1
Element: Fair Mkt Val

BSG-BASE-FR-MKT-VL     Signed 9.4                                BN107   BN23.1
Element: Base Fr Mkt Vl

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

                         BNSTKGNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSGSET1   COMPANY                                                BN137   BN223
          OPT-GRANT-NBR                                          BN23.1  BN234
                                                                 BN33.1  BN33.2
                                                                 BN33.3  BN33.4
                                                                 BN533   BN534
                                                                 HR00.1  HR01.1
                                                                 HR170   HR70.1
                                                                 PBIP.1  PR197

BSGSET2   STOCK-SYMBOL  KeyChange                                BN07.1  BN107
          COMPANY
          OPT-GRANT-NBR

                         BNSTKGNT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Base Currency  CUCODES      Required

                            BSG-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            BSG-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required

                            BSG-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Stock          BNSTOCK      Required

                            BSG-STOCK-SYMBOL     -> BSK-STOCK-SYMBOL

Vesting        VESTSCHDHD   Required
                            When BSG-VEST-SCHED != Spaces

                            BSG-COMPANY          -> VSH-COMPANY
                            BSG-VEST-SCHED       -> VSH-VEST-SCHED

                         BNSTKGNT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Emp Exer       BNEMPEXER
                            Valid When BXR- = BSG-

                            BSG-COMPANY          -> BXR-COMPANY
                            BSG-OPT-GRANT-NBR    -> BXR-OPT-GRANT-NBR
                                                    BXR-STOCK-CTF
                                                    BXR-EXERCISE-DATE
                                                    BXR-EMPLOYEE
                                                    BXR-SEQ-NBR

Emp Grant      BNEMPGRNT

                            BSG-COMPANY          -> BEG-COMPANY
                            BSG-OPT-GRANT-NBR    -> BEG-OPT-GRANT-NBR
                                                    BEG-EMPLOYEE
                                                    BEG-STOCK-CTF