Infor LN & BaanFree referencePDF, Excel, Word exportInfor LNAll Infor LN and Baan tools

Infor LN Warehousing Tables Reference: whinh, whwmd and whinr

This reference lists the LN 10.x Warehousing tables in the wh package, from warehouse and item masters to warehousing orders, receipts, outbound advice, shipments, counts, adjustments and inventory transactions. Each row gives the key fields, the columns you query most and how the table joins back to the source order.

Download:

Table	Description	Key fields	Important columns	Joins to	Session	Notes
tcmcs003	Warehouses (general)	cwar	typw warehouse type, cadr address, comp financial company, wmsc WMS controlled, inep include in enterprise planning	Every cwar field in wh tables	tcmcs0503m000 Warehouses	Still the warehouse master in LN 10.x; whwmd200 adds the warehousing settings.
whwmd200	Warehouses (warehousing data)	cwar	site, sloc locations, binb blocked for inbound, bout blocked for outbound, bcyc block during cycle counting, reje quarantine inventory, qwrh quarantine warehouse	whwmd200.cwar = tcmcs003.cwar	whwmd2500m000 Warehouses	One session shows fields from both tcmcs003 and whwmd200.
whwmd210	Item data by warehouse	cwar, item	iwhs status, valm valuation method, omth order method, sups supply system, reop reorder point, supw supply warehouse	whwmd210.item = tcibd001.item	whwmd2510m000 Item Data by Warehouse	uidt decides whether item-level ordering data is used.
whwmd215	Warehouse - item inventory	cwar, item	qhnd on hand, qall allocated, qord on order, qblk blocked, qbpl blocked for planning	whwmd215.item = tcibd001.item	whwmd2515m000 Warehouse - Item Inventory	Fastest source for on-hand totals per warehouse.
whwmd300	Warehouse locations	cwar, loca	zone storage zone, loct location type, filo fixed location, oclo occupied, full location full, ball blocked for all transactions	whinr140.cwar, loca = whwmd300.cwar, loca	whwmd3500m000 Warehouse - Locations	Only used when the warehouse is location controlled.
whwmd400	Items - warehousing	item	locc location controlled, lttr lot tracking, srtr serial tracking, niwo allow negative inventory, obpr outbound method	whwmd400.item = tcibd001.item	whwmd4500m000 Items - Warehousing	Item settings valid in every warehouse.
whinh200	Warehousing orders (header)	oorg, orno, oset	oorg order origin, orno order, oset set, otyp warehousing order type, hsta header status, sfty/sfco ship-from type and code, stty/stco ship-to type and code, pddt planned delivery date, prdt planned receipt date	whinh200.orno = tdsls400.orno when the origin is a sales order; tdpur400.orno for purchase	whinh2100m000 Warehousing Orders	oorg tells you which source table orno belongs to; see the order types reference for origin values.
whinh210	Inbound order lines	oorg, orno, oset, pono, seqn	lsta status, item, qoro ordered quantity, orun unit, qord inventory quantity, cwar warehouse, sfbp ship-from BP, prdt planned receipt date	whinh210.oorg, orno, oset = whinh200.oorg, orno, oset	whinh2110m000 Inbound Order Lines	One line per expected receipt from the source order.
whinh220	Outbound order lines	oorg, orno, oset, pono, seqn	lsta status, item, qoro ordered quantity in order unit, qord ordered quantity in inventory unit, cwar warehouse, pddt planned delivery date, shrt shortage, cncl canceled	whinh220.oorg, orno, oset = whinh200.oorg, orno, oset; pono links to the source line	whinh2120m000 Outbound Order Lines	Released sales order lines arrive here before outbound advice.
whinh225	Outbound advice	oorg, orno, oset, pono, seqn, sern	sern advice, item, cwar warehouse, locf from location, clot lot, qads advised quantity, qadv advised in inventory unit, rlsd released, pckd picked, runn run, shpm shipment	whinh225.oorg, orno, oset, pono, seqn = whinh220 key	whinh4525m000 Outbound Advice	Shows which location and lot the system advised for picking.
whinh300	Shipment notices (ASN)	sfbp, shid	shid shipment, stat status, pddt planned delivery date, shdt shipping date, asnr supplier ASN, cpro carrier tracking number	whinh300.shid = whinh310.shid	whinh3100m000 Shipment Notices	Inbound ASNs from suppliers; receipts can be created from them.
whinh310	Warehouse receipts (header)	rcno	rcno receipt, sfbp ship-from BP, dino packing slip, crdt creation date, stat status, cwar warehouse, shid shipment	whinh310.rcno = whinh312.rcno	whinh3110m000 Warehouse Receipts Overview	One receipt can cover lines from several inbound orders.
whinh312	Warehouse receipt lines	rcno, rcln	orno order, oset set, pono line, seqn sequence, item, qrcr received quantity in receipt unit, qrec received quantity in inventory unit, idat inventory date, insp inspection, conf confirmed	whinh312.orno, pono = whinh210.orno, pono	whinh3512m100 Warehouse Receipt Lines	Confirming the receipt updates these lines and posts inventory.
whinh425	Shipping containers	load, cntr	cntr shipping container, cnst container status, pitm packaging item, huid handling unit, grwt gross weight, volm volume, cpro carrier tracking number	whinh430.cntr = whinh425.cntr	whinh4125m000 Shipping Containers	Used when shipments are loaded into containers.
whinh430	Shipments (header)	shpm	shst status, load load, cntr shipping container, huid handling unit, corn customer order, sfco ship-from code, stco ship-to code, carr carrier/LSP, cdat date confirmed	whinh430.shpm = whinh431.shpm; tdsls406.shpm = whinh430.shpm	whinh4130m000 Shipments	Confirming the shipment triggers the sales delivery in tdsls406.
whinh431	Shipment lines	shpm, pono	shst status, item, clot lot, serl serial number, qpic picked, qshp shipped quantity, qnsh not shipped quantity, grwt gross weight	whinh431.shpm = whinh430.shpm	whinh4131m000 Shipment Lines	Shipped versus not shipped quantity explains short shipments.
whinh250	Warehousing orders history	Same identifying fields as whinh200	Header values at the time the order was processed	whinh250.orno = whinh200.orno	whinh2550m000 Warehousing Orders History	Line history is in whinh260 (inbound) and whinh270 (outbound).
whinh500	Cycle counting orders	orno, cntn	cntn count number, cwar warehouse, odat order date, ccst status, prcc process count, rcyn reconciliation	whinh500.orno = whinh501.orno	whinh5100m000 Cycle Counting Orders	Each recount increments the count number.
whinh501	Cycle counting order lines	orno, cntn, pono	loca location, item, clot lot, qstp stock point inventory, qcnt actual inventory, qvrc variance in inventory unit, cadj reason for variance, cdat date of count	whinh501.item = tcibd001.item	whinh5101m000 Cycle Counting Order Lines	Variance qvrc is what posts as an inventory adjustment.
whinh520	Adjustment orders	orno	cwar warehouse, odat order date, adrn reason for adjustment, adst status, mnad manual adjustment	whinh520.orno = whinh521.orno	whinh5120m000 Adjustment Orders	Header for manual inventory corrections.
whinh521	Adjustment order lines	orno, pono	item, cwar warehouse, loca location, clot lot, qstp stock point inventory, qadj actual inventory, qvrc variance, adrn reason, adat adjustment date, prcd processed	whinh521.item = tcibd001.item	whinh5121m000 Adjustment Order Lines	Processed lines create inventory transactions in whinr110.
whinr100	Stock point transactions	cwar, loca, item, trdt (per stock point)	idat inventory date, trdt transaction date, kost transaction type, qstk quantity, koor order origin, qhnd inventory after transaction, clot lot, serl serial number	whinr100.item = tcibd001.item	whinr1500m000 Warehouse - Item - Stock Point Transactions	Location and lot level transaction trail.
whinr110	Inventory transactions by item and warehouse	item, cwar, trdt, seqn	koor type of order, orno order, pono line, srnb sequence, rcno receipt, shpm shipment, qstk quantity, kost transaction type, qhnd inventory after transaction	whinr110.orno = source order (tdsls400, tdpur400, tisfc001) depending on koor	whinr1510m000 Item - Warehouse - Inventory Transactions	Main audit trail for stock movements per item and warehouse.
whinr140	Stock point inventory	cwar, loca, item, clot, idat	qhnd on hand, qblk blocked, qlal allocated, qord on order, effn effectivity unit, trdt last transaction date, bout blocked for outbound, bcyc blocked for cycle counting	whinr140.cwar, loca = whwmd300.cwar, loca	whinr1540m000 Stock Point Inventory	Inventory by location, lot and inventory date.

Physical tables are t + table code + company number (twhinh200100). SQL columns use t_ on SQL Server and t$ on Oracle. Tables and fields were checked against the LN 10.x online help for the sessions listed; quantities in whinh tables come in both order unit and inventory unit, so check the unit field next to each quantity. Order origin values for oorg are covered in the separate warehousing order types reference.

Need an inventory reconciliation query for LN?

Tell us your LN release and database and we will review a whwmd215 versus whinr140 reconciliation for your warehouses.

Optional. The tool and every export work without this. No spam.

Was this tool useful?

How a sales order moves through the wh tables

When a sales order line is released, LN creates a warehousing order header in whinh200 with origin and order number, and an outbound line in whinh220. Generating outbound advice writes whinh225 with the advised location and lot. Releasing the advice and picking leads to a shipment in whinh430 with lines in whinh431. Confirming the shipment posts inventory transactions to whinr110 and whinr100, reduces whwmd215 and whinr140, and writes the actual delivery line tdsls406 in Sales. Inbound works the same way in reverse: whinh210 lines, receipt header whinh310 and receipt lines whinh312.

Outbound: whinh200, whinh220, whinh225, whinh430, whinh431
Inbound: whinh300 (ASN), whinh210, whinh310, whinh312
Inventory: whwmd215 totals, whinr140 by stock point, whinr110 transactions

Worked example: stock on hand with location detail

For a warehouse-level total, read whwmd215 by cwar and item: qhnd minus qall minus qblk gives a quick free quantity. For a location report, read whinr140 for the same warehouse and group by loca, clot and idat, then join whwmd300 on cwar and loca for the location type and zone. If the two totals disagree, look at blocked and allocated quantities first, then at stock points created by open inbound or outbound processing. For movements over a period, read whinr110 by item and warehouse between two transaction dates and sum qstk by transaction type kost.

Gotchas and version notes

whinh200 is keyed by order origin, order number and set, so joining on orno alone mixes sales, purchase, production and transfer orders that share a number series. Always filter on oorg too. Receipt lines are in whinh312 under the receipt header whinh310. Warehouse master data is split: general fields in tcmcs003 and warehousing settings in whwmd200, both shown in whwmd2500m000. Quantity fields come in pairs (order or receipt unit and inventory unit), so pick the inventory unit column for totals.

How to check a column in your system

Open the session in the Session column, zoom on the field and use field help to see the table and field name. For index definitions and the complete column list, check the table definition in your data dictionary. Location-controlled and lot-controlled warehouses fill whinr140 and whinr100 with more detail than non-controlled ones, so test reports on both kinds. Also check how many companies share the warehouse tables before you build cross-company stock reports, and remember that history tables such as whinh250 grow fast on busy sites, so filter them by date.

Frequently Asked Questions

Where is the Infor LN table list for warehousing?

Warehousing tables start with wh. whwmd holds master data (warehouses, item data by warehouse, locations, inventory totals), whinh holds warehousing orders, receipts, outbound advice, shipments, counts and adjustments, and whinr holds inventory transactions and stock point inventory. This page lists 24 of them with keys, columns and joins.

What are the Infor LN table names for shipments?

Shipments are whinh430 (header, session whinh4130m000) and whinh431 (lines, session whinh4131m000). Shipping containers are whinh425. The shipment number shpm also appears on outbound advice whinh225, on sales actual delivery lines tdsls406 and on invoice lines cisli310, which makes it the main link between warehouse and sales.

How is the warehousing order linked to the sales order?

whinh200 and its lines carry the order origin oorg, the order number orno and a set oset. When the origin is a sales order, orno equals tdsls400.orno and the line number on whinh220 corresponds to the sales line. Filter on the origin as well as the number, because other order types can use the same number.

Which table holds inventory transactions in Infor LN?

whinr110, shown in Item - Warehouse - Inventory Transactions (whinr1510m000), holds the transactions per item and warehouse with the type of order, order number, line, receipt or shipment, quantity and inventory after the transaction. whinr100 holds the same movements at stock point level, with location, lot and serial number.

If your warehouse team wants to ask LN where stock is, what shipped and what is blocked in plain English on your own servers, we can set that up read-only over these tables.

Talk to an Expert Explore More Free Tools