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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BSPSET1STOCK-SYMBOL, SPLIT-DATEPrimaryBN107, BN207
BSPSET2STOCK-SYMBOL, SPLIT-DATE*BN07.1, BN107

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
StockBNSTOCKRequiredBSP-STOCK-SYMBOL → BSK-STOCK-SYMBOL

Programs

Updated by (1)

Referenced by (2)