BNSTKSPLT – No description in the Lawson data dictionary

System
Benefits (BN)
Prefix
BSP
Primary key
STOCK-SYMBOL, SPLIT-DATE
Fields
12
Updated by
1 program
Referenced by
2 programs

BNSTKSPLT is a Lawson Benefits table (prefix BSP); no description in the lawson data dictionary. It is indexed by STOCK-SYMBOL, SPLIT-DATE (BSPSET1); alternate indexes: BSPSET2. It is related 1:1 to BNSTOCK. It is updated by BN107 and referenced by BN07.1 and BN207. The table has 12 fields, 2 indexes and 1 documented relation.

About BNSTKSPLT

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the BSP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BSP-STOCK-SYMBOL PK
STOCK_SYMBOL		Alpha 6—BN107
#BSP-SPLIT-DATE PK
SPLIT_DATE		Numeric 8 (yyyymmdd)—BN107
#BSP-SPLIT-FROM
SPLIT_FROM		Numeric 3—BN107
#BSP-SPLIT-TO
SPLIT_TO		Numeric 3—BN107
#BSP-PRICE-FROM
PRICE_FROM		Signed 9.4——
#BSP-PRICE-TO
PRICE_TO		Signed 9.4——
#BSP-ROUND-METH
ROUND_METH		Alpha 1—
  • H High
  • L Low
  • N No Rounding
  • R Normal Rounding
BN107
#BSP-BEF-AFT-FLAG
BEF_AFT_FLAG		Alpha 1—
  • B Before
  • A After
BN107
#BSP-ROUND-TO
ROUND_TO		Signed 9.4—BN107
#BSP-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN107
#BSP-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN107
#BSP-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN107

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BSPSET1
  1. STOCK-SYMBOL
  2. SPLIT-DATE
PrimaryBN107, BN207
BSPSET2
  1. STOCK-SYMBOL
  2. SPLIT-DATE ↓
BN07.1, BN107

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BNSTOCKBNSTKSPLT

One to one (1) — lookups and parents

RelationTableRulesConditionField map
StockBNSTOCKRequired
BSP-STOCK-SYMBOL→BSK-STOCK-SYMBOL

Programs

Updated by (1)

Referenced by (2)