WHSHLDTLIN – No description in the Lawson data dictionary

System
Warehouse (WH)
Prefix
WDI
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, BIN, LOT, SUBLOT, SERIAL, UOM
Fields
15
Updated by
2 programs
Referenced by
0 programs

WHSHLDTLIN is a Lawson Warehouse table (prefix WDI); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, BIN, LOT, SUBLOT, SERIAL, UOM (WDISET1); alternate indexes: WDISET2. It is related 1:1 to WHSHLINEIN. It is updated by WH52.2 and WH520. The table has 15 fields, 2 indexes and 1 documented relation.

About WHSHLDTLIN

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the WDI- 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
#WDI-COMPANY PK
COMPANY		Numeric 4Identifies 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.WH52.2
#WDI-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.WH52.2
#WDI-SHIPMENT-NBR PK
SHIPMENT_NBR		Numeric 10This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.WH52.2
#WDI-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.WH52.2
#WDI-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the record sequence number.WH52.2
#WDI-BIN PK
BIN		Alpha 7This field contains a storage area for an item or any number of items.WH52.2
#WDI-LOT PK
LOT		Alpha 10This field contains the identifier for the homogeneous quantity of material.WH52.2
#WDI-SUBLOT PK
SUBLOT		Alpha 6This field contains the identifier for a detail breakdown of a lot number.WH52.2
#WDI-SERIAL PK
SERIAL		Alpha 16—WH52.2
#WDI-UOM PK
UOM		Alpha 4This field contains the valid stock unit of measure for this item.WH52.2
#WDI-PROCESS-DATE SET2
PROCESS_DATE		Numeric 8 (yyyymmdd)—WH52.2
#WDI-UPDATE-TIME
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.WH52.2
#WDI-UOM-MULT
UOM_MULT		Signed 13.7This field contains the multiplier for converting this unit of measure to the stock unit of measure.WH52.2
#WDI-QUANTITY
QUANTITY		Signed 13.4This field contains the desired quantity.WH52.2
#WDI-CATCH-WT-QTY
CATCH_WT_QTY		Signed 13.4This field contains the desired quantity.WH52.2

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
WDISET1
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. LINE-NBR
  5. COMPONENT-SEQ
  6. BIN
  7. LOT
  8. SUBLOT
  9. SERIAL
  10. UOM
PrimaryWH52.1, WH52.2, WH520
WDISET2
  1. COMPANY
  2. LOCATION
  3. PROCESS-DATE
  4. SHIPMENT-NBR
  5. LINE-NBR
  6. COMPONENT-SEQ
  7. BIN
  8. LOT
  9. SUBLOT
  10. SERIAL
  11. UOM
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
WhshlineinWHSHLINEINRequired
WDI-COMPANY→WLI-COMPANY (WLISET1)
WDI-LOCATION→WLI-LOCATION
WDI-SHIPMENT-NBR→WLI-SHIPMENT-NBR
WDI-LINE-NBR→WLI-LINE-NBR

Programs

Updated by (2)