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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WDI-COMPANY PKCOMPANY | Numeric 4 | 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. | WH52.2 |
WDI-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | WH52.2 |
WDI-SHIPMENT-NBR PKSHIPMENT_NBR | Numeric 10 | This 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 PKLINE_NBR | Numeric 6 | This field contains the line number. | WH52.2 |
WDI-COMPONENT-SEQ PKCOMPONENT_SEQ | Numeric 3 | This field contains the record sequence number. | WH52.2 |
WDI-BIN PKBIN | Alpha 7 | This field contains a storage area for an item or any number of items. | WH52.2 |
WDI-LOT PKLOT | Alpha 10 | This field contains the identifier for the homogeneous quantity of material. | WH52.2 |
WDI-SUBLOT PKSUBLOT | Alpha 6 | This field contains the identifier for a detail breakdown of a lot number. | WH52.2 |
WDI-SERIAL PKSERIAL | Alpha 16 | — | WH52.2 |
WDI-UOM PKUOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | WH52.2 |
WDI-PROCESS-DATEPROCESS_DATE | Numeric 8 (yyyymmdd) | — | WH52.2 |
WDI-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | WH52.2 |
WDI-UOM-MULTUOM_MULT | Signed 13.7 | This field contains the multiplier for converting this unit of measure to the stock unit of measure. | WH52.2 |
WDI-QUANTITYQUANTITY | Signed 13.4 | This field contains the desired quantity. | WH52.2 |
WDI-CATCH-WT-QTYCATCH_WT_QTY | Signed 13.4 | This field contains the desired quantity. | WH52.2 |
Indexes (2)
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 |
|---|---|---|---|---|
WDISET1 | COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, BIN, LOT, SUBLOT, SERIAL, UOM | Primary | WH52.1, WH52.2, WH520 | |
WDISET2 | COMPANY, LOCATION, PROCESS-DATE, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, BIN, LOT, SUBLOT, SERIAL, UOM | — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Whshlinein | WHSHLINEIN | Required | WDI-COMPANY → WLI-COMPANY (WLISET1), WDI-LOCATION → WLI-LOCATION, WDI-SHIPMENT-NBR → WLI-SHIPMENT-NBR, WDI-LINE-NBR → WLI-LINE-NBR |