# Infor LN Warehousing Tables Reference: whinh, whwmd and whinr > Source: https://netray.co/tools/infor-ln-warehousing-tables-whinh-whwmd-whinr-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Table-by-table map of LN 10.x Warehousing: masters, warehouse orders, receipts, outbound advice, shipments, cycle counts, adjustments and inventory transactions. ## Category infor-ln ## Erp Infor LN ## Audience - LN developer - Warehouse systems analyst - ERP administrator ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Description **Key:** description **Type:** text #### Key fields **Key:** keys **Type:** text #### Important columns **Key:** columns **Type:** text #### Joins to **Key:** join **Type:** text #### Session **Key:** session **Type:** text #### Notes **Key:** notes **Type:** text **Rows:** **Table:** tcmcs003 **Description:** Warehouses (general) **Keys:** cwar **Columns:** typw warehouse type, cadr address, comp financial company, wmsc WMS controlled, inep include in enterprise planning **Join:** Every cwar field in wh tables **Session:** tcmcs0503m000 Warehouses **Notes:** Still the warehouse master in LN 10.x; whwmd200 adds the warehousing settings. **Table:** whwmd200 **Description:** Warehouses (warehousing data) **Keys:** cwar **Columns:** site, sloc locations, binb blocked for inbound, bout blocked for outbound, bcyc block during cycle counting, reje quarantine inventory, qwrh quarantine warehouse **Join:** whwmd200.cwar = tcmcs003.cwar **Session:** whwmd2500m000 Warehouses **Notes:** One session shows fields from both tcmcs003 and whwmd200. **Table:** whwmd210 **Description:** Item data by warehouse **Keys:** cwar, item **Columns:** iwhs status, valm valuation method, omth order method, sups supply system, reop reorder point, supw supply warehouse **Join:** whwmd210.item = tcibd001.item **Session:** whwmd2510m000 Item Data by Warehouse **Notes:** uidt decides whether item-level ordering data is used. **Table:** whwmd215 **Description:** Warehouse - item inventory **Keys:** cwar, item **Columns:** qhnd on hand, qall allocated, qord on order, qblk blocked, qbpl blocked for planning **Join:** whwmd215.item = tcibd001.item **Session:** whwmd2515m000 Warehouse - Item Inventory **Notes:** Fastest source for on-hand totals per warehouse. **Table:** whwmd300 **Description:** Warehouse locations **Keys:** cwar, loca **Columns:** zone storage zone, loct location type, filo fixed location, oclo occupied, full location full, ball blocked for all transactions **Join:** whinr140.cwar, loca = whwmd300.cwar, loca **Session:** whwmd3500m000 Warehouse - Locations **Notes:** Only used when the warehouse is location controlled. **Table:** whwmd400 **Description:** Items - warehousing **Keys:** item **Columns:** locc location controlled, lttr lot tracking, srtr serial tracking, niwo allow negative inventory, obpr outbound method **Join:** whwmd400.item = tcibd001.item **Session:** whwmd4500m000 Items - Warehousing **Notes:** Item settings valid in every warehouse. **Table:** whinh200 **Description:** Warehousing orders (header) **Keys:** oorg, orno, oset **Columns:** 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 **Join:** whinh200.orno = tdsls400.orno when the origin is a sales order; tdpur400.orno for purchase **Session:** whinh2100m000 Warehousing Orders **Notes:** oorg tells you which source table orno belongs to; see the order types reference for origin values. **Table:** whinh210 **Description:** Inbound order lines **Keys:** oorg, orno, oset, pono, seqn **Columns:** lsta status, item, qoro ordered quantity, orun unit, qord inventory quantity, cwar warehouse, sfbp ship-from BP, prdt planned receipt date **Join:** whinh210.oorg, orno, oset = whinh200.oorg, orno, oset **Session:** whinh2110m000 Inbound Order Lines **Notes:** One line per expected receipt from the source order. **Table:** whinh220 **Description:** Outbound order lines **Keys:** oorg, orno, oset, pono, seqn **Columns:** 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 **Join:** whinh220.oorg, orno, oset = whinh200.oorg, orno, oset; pono links to the source line **Session:** whinh2120m000 Outbound Order Lines **Notes:** Released sales order lines arrive here before outbound advice. **Table:** whinh225 **Description:** Outbound advice **Keys:** oorg, orno, oset, pono, seqn, sern **Columns:** 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 **Join:** whinh225.oorg, orno, oset, pono, seqn = whinh220 key **Session:** whinh4525m000 Outbound Advice **Notes:** Shows which location and lot the system advised for picking. **Table:** whinh300 **Description:** Shipment notices (ASN) **Keys:** sfbp, shid **Columns:** shid shipment, stat status, pddt planned delivery date, shdt shipping date, asnr supplier ASN, cpro carrier tracking number **Join:** whinh300.shid = whinh310.shid **Session:** whinh3100m000 Shipment Notices **Notes:** Inbound ASNs from suppliers; receipts can be created from them. **Table:** whinh310 **Description:** Warehouse receipts (header) **Keys:** rcno **Columns:** rcno receipt, sfbp ship-from BP, dino packing slip, crdt creation date, stat status, cwar warehouse, shid shipment **Join:** whinh310.rcno = whinh312.rcno **Session:** whinh3110m000 Warehouse Receipts Overview **Notes:** One receipt can cover lines from several inbound orders. **Table:** whinh312 **Description:** Warehouse receipt lines **Keys:** rcno, rcln **Columns:** 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 **Join:** whinh312.orno, pono = whinh210.orno, pono **Session:** whinh3512m100 Warehouse Receipt Lines **Notes:** Confirming the receipt updates these lines and posts inventory. **Table:** whinh425 **Description:** Shipping containers **Keys:** load, cntr **Columns:** cntr shipping container, cnst container status, pitm packaging item, huid handling unit, grwt gross weight, volm volume, cpro carrier tracking number **Join:** whinh430.cntr = whinh425.cntr **Session:** whinh4125m000 Shipping Containers **Notes:** Used when shipments are loaded into containers. **Table:** whinh430 **Description:** Shipments (header) **Keys:** shpm **Columns:** 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 **Join:** whinh430.shpm = whinh431.shpm; tdsls406.shpm = whinh430.shpm **Session:** whinh4130m000 Shipments **Notes:** Confirming the shipment triggers the sales delivery in tdsls406. **Table:** whinh431 **Description:** Shipment lines **Keys:** shpm, pono **Columns:** shst status, item, clot lot, serl serial number, qpic picked, qshp shipped quantity, qnsh not shipped quantity, grwt gross weight **Join:** whinh431.shpm = whinh430.shpm **Session:** whinh4131m000 Shipment Lines **Notes:** Shipped versus not shipped quantity explains short shipments. **Table:** whinh250 **Description:** Warehousing orders history **Keys:** Same identifying fields as whinh200 **Columns:** Header values at the time the order was processed **Join:** whinh250.orno = whinh200.orno **Session:** whinh2550m000 Warehousing Orders History **Notes:** Line history is in whinh260 (inbound) and whinh270 (outbound). **Table:** whinh500 **Description:** Cycle counting orders **Keys:** orno, cntn **Columns:** cntn count number, cwar warehouse, odat order date, ccst status, prcc process count, rcyn reconciliation **Join:** whinh500.orno = whinh501.orno **Session:** whinh5100m000 Cycle Counting Orders **Notes:** Each recount increments the count number. **Table:** whinh501 **Description:** Cycle counting order lines **Keys:** orno, cntn, pono **Columns:** 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 **Join:** whinh501.item = tcibd001.item **Session:** whinh5101m000 Cycle Counting Order Lines **Notes:** Variance qvrc is what posts as an inventory adjustment. **Table:** whinh520 **Description:** Adjustment orders **Keys:** orno **Columns:** cwar warehouse, odat order date, adrn reason for adjustment, adst status, mnad manual adjustment **Join:** whinh520.orno = whinh521.orno **Session:** whinh5120m000 Adjustment Orders **Notes:** Header for manual inventory corrections. **Table:** whinh521 **Description:** Adjustment order lines **Keys:** orno, pono **Columns:** item, cwar warehouse, loca location, clot lot, qstp stock point inventory, qadj actual inventory, qvrc variance, adrn reason, adat adjustment date, prcd processed **Join:** whinh521.item = tcibd001.item **Session:** whinh5121m000 Adjustment Order Lines **Notes:** Processed lines create inventory transactions in whinr110. **Table:** whinr100 **Description:** Stock point transactions **Keys:** cwar, loca, item, trdt (per stock point) **Columns:** idat inventory date, trdt transaction date, kost transaction type, qstk quantity, koor order origin, qhnd inventory after transaction, clot lot, serl serial number **Join:** whinr100.item = tcibd001.item **Session:** whinr1500m000 Warehouse - Item - Stock Point Transactions **Notes:** Location and lot level transaction trail. **Table:** whinr110 **Description:** Inventory transactions by item and warehouse **Keys:** item, cwar, trdt, seqn **Columns:** koor type of order, orno order, pono line, srnb sequence, rcno receipt, shpm shipment, qstk quantity, kost transaction type, qhnd inventory after transaction **Join:** whinr110.orno = source order (tdsls400, tdpur400, tisfc001) depending on koor **Session:** whinr1510m000 Item - Warehouse - Inventory Transactions **Notes:** Main audit trail for stock movements per item and warehouse. **Table:** whinr140 **Description:** Stock point inventory **Keys:** cwar, loca, item, clot, idat **Columns:** 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 **Join:** whinr140.cwar, loca = whwmd300.cwar, loca **Session:** whinr1540m000 Stock Point Inventory **Notes:** Inventory by location, lot and inventory date. **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How a sales order moves through the wh tables **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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 **Body:** 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. **Cta:** 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. **Faq:** #### Where is the Infor LN table list for warehousing? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms infor ln table list, infor ln table names, infor ln table structure, infor ln tables, whinh200 warehousing orders, whinh430 shipments table, whinr110 inventory transactions, whwmd215 inventory by warehouse --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json