WHSHLINEIN – No description in the Lawson data dictionary

System: Warehouse (WH)
Prefix: WLI
Primary key: COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR
Fields: 27
Updated by: 2 programs
Referenced by: 0 programs

WHSHLINEIN is a Lawson Warehouse table (prefix WLI); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR (WLISET1); alternate indexes: WLISET2. It is related 1:1 to WHSHPMNTIN and 1:M to WHSLCRTNIN. It is updated by WH52.1 and WH520. The table has 27 fields, 2 indexes and 2 documented relations.

About WHSHLINEIN

No description in the Lawson data dictionary.

Fields (27)

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

Field / column	Type	Description & values	Updated by
`WLI-COMPANY` PK COMPANY	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.1
`WLI-LOCATION` PK LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	WH52.1
`WLI-SHIPMENT-NBR` PK SHIPMENT_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.1
`WLI-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the line number.	WH52.1
`WLI-PROCESS-DATE` PROCESS_DATE	Numeric 8 (yyyymmdd)	—	WH52.1
`WLI-UPDATE-TIME` UPDATE_TIME	Numeric 6	This field contains the system time when the record was updated.	WH52.1
`WLI-ITEM` ITEM	Alpha 32	This field contains the item identifier.	WH52.1
`WLI-LINE-TYPE` LINE_TYPE	Alpha 1	This field contains the type of inventory on this line.	WH52.1
`WLI-STOCK-UOM` STOCK_UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	WH52.1
`WLI-TRAN-UOM` TRAN_UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	WH52.1
`WLI-TRAN-UOM-MULT` TRAN_UOM_MULT	Signed 13.7	This field contains the multiplier for converting this unit of measure to the stock unit of measure.	WH52.1
`WLI-IN-PROCESS-QTY` IN_PROCESS_QTY	Signed 13.4	This field contains the desired quantity.	WH52.1
`WLI-SHIPPED-QTY` SHIPPED_QTY	Signed 13.4	This field contains the desired quantity.	WH52.1
`WLI-CATCH-WT-QTY` CATCH_WT_QTY	Signed 13.4	This field contains the desired quantity.	WH52.1
`WLI-PRE-ASMBLD-KIT` PRE_ASMBLD_KIT	Signed 13.4	—	WH52.1
`WLI-DETAIL-QTY` DETAIL_QTY	Signed 13.4	This field contains the desired quantity.	WH52.1
`WLI-DTL-CTW-QTY` DTL_CTW_QTY	Signed 13.4	This field contains the desired quantity.	WH52.1
`WLI-UNIT-COST` UNIT_COST	Signed 18.5	—	WH52.1
`WLI-WEIGHT` WEIGHT	Signed 9.3	This field contains the unit weight of the item based on the stocking UOM.	WH52.1
`WLI-CUBIC-FEET` CUBIC_FEET	Signed 9.3	This field contains the unit cubic feet of the item based on the stocking UOM.	WH52.1
`WLI-MSDS-DT` MSDS_DT	Numeric 8 (yyyymmdd)	This date is the date that a new Material Safety Data Sheet should be sent from the vendor.	WH52.1
`WLI-GLBL-LINE-TYPE` GLBL_LINE_TYPE	Alpha 15	—	WH52.1
`WLI-WHL-USR-FLD-01` WHL_USR_FLD_01	Alpha 20	—	WH52.1
`WLI-WHL-USR-FLD-02` WHL_USR_FLD_02	Alpha 20	—	WH52.1
`WLI-WHL-USR-FLD-03` WHL_USR_FLD_03	Alpha 20	—	WH52.1
`WLI-WHL-USR-FLD-04` WHL_USR_FLD_04	Alpha 20	—	WH52.1
`WLI-WHL-USR-FLD-05` WHL_USR_FLD_05	Alpha 20	—	WH52.1

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
`WLISET1`	`COMPANY`, `LOCATION`, `SHIPMENT-NBR`, `LINE-NBR`	Primary		WH52.1, WH52.2, WH52.3, WH520
`WLISET2`	`COMPANY`, `LOCATION`, `PROCESS-DATE`, `SHIPMENT-NBR`, `LINE-NBR`			—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Whshpmntin	WHSHPMNTIN	Required		`WLI-COMPANY` → `WSI-COMPANY (WSISET1)`, `WLI-LOCATION` → `WSI-LOCATION`, `WLI-SHIPMENT-NBR` → `WSI-SHIPMENT-NBR`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Whslcrtnin	WHSLCRTNIN			`WLI-COMPANY` → `WCL-COMPANY`, `WLI-LOCATION` → `WCL-LOCATION`, `WLI-SHIPMENT-NBR` → `WCL-SHIPMENT-NBR`, `WLI-LINE-NBR` → `WCL-SHIP-LINE-NBR`, → `WCL-CARTON-NBR`

Programs

Updated by (2)

WH52.1 Shipment Interface Maintenance
WH520 Batch Feedback Interface