BNSTOCK – No description in the Lawson data dictionary

System: Benefits (BN)
Prefix: BSK
Primary key: STOCK-SYMBOL
Fields: 9
Updated by: 1 program
Referenced by: 5 programs

BNSTOCK is a Lawson Benefits table (prefix BSK); no description in the lawson data dictionary. It is indexed by STOCK-SYMBOL (BSKSET1). It is related 1:1 to CUCODES and 1:M to BNSTKGNT and BNSTKSPLT. It is updated by BN07.1 and referenced by BN107, BN207, BN223, BN23.1 and BN33.2. The table has 9 fields, 1 index and 3 documented relations.

About BNSTOCK

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the BSK- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`BSK-STOCK-SYMBOL` PK STOCK_SYMBOL	Alpha 6	—	BN07.1
`BSK-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	BN07.1
`BSK-MKT-VAL-DATE` MKT_VAL_DATE	Numeric 8 (yyyymmdd)	—	BN07.1
`BSK-FAIR-MKT-VAL` FAIR_MKT_VAL	Signed 9.4	—	BN07.1
`BSK-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BN07.1
`BSK-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BN07.1
`BSK-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN07.1
`BSK-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN07.1
`BSK-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN07.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`BSKSET1`	`STOCK-SYMBOL`	Primary, KeyChange		BN07.1, BN107, BN207, BN223, BN23.1, BN33.2

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Currency	CUCODES	Not Required		`BSK-CURRENCY-CODE` → `CUC-CURRENCY-CODE`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (1)

BN07.1 Stock Definition

Referenced by (5)

BN107 Stock Splits Update
BN207 Stock Listing
BN223 Stock Option Grant Listing
BN23.1 Stock Option Grant
BN33.2 Employee Stock Option Grant