JDE Reference
F41021
masterAlso in JDE WorldItem location — on-hand, committed, and inbound quantities by item, branch, location, and lot
Module: 41 · Inventory ManagementColumn prefix: LI
What the badges mean
- Superseded
- Superseded — a newer table has replaced it, but older scripts still read this one.
- Also in JDE World
- Also present in JDE World A9.x on the same table name.
- master
- Data class: what the table holds — master data, transaction documents, control/setup values, history, or a workfile.
- Read/write access
- Access mode: how the paired program reads or writes this table — R (read), W (write), or R/W (both).
No lifecycle badge means the table is current and not documented in JDE World. In field listings, K marks a primary-key field.
Used in the library
Fields
26 fields · 4 key
26 fields.
| Key | Field | Alias | Description | Type | Length | Flags |
|---|---|---|---|---|---|---|
| Primary key | LIITM | ITM | Short item number - the internal numeric item key | Numeric | 8 | |
| Primary key | LIMCU | MCU | Business unit / branch plant (right-justified, space-padded to 12) | String | 12 | |
| Primary key | LILOCN | LOCN | Storage location within the branch plant | String | 20 | |
| Primary key | LILOTN | LOTN | Lot or serial number | String | 30 | |
| LIPBIN | PBIN | Flags the primary location for the item at this branch | Character | 1 | ||
| LIGLPT | GLPT | G/L class code for this location (overrides branch/item value) | String | 4 | ||
| LILOTS | LOTS | Lot status code - blank means approved | Character | 1 | ||
| LILRCJ | LRCJ | Date of last receipt into this location | Numeric (DD type: Date) | 6 | ||
| LIPQOH | PQOH | Quantity on hand in primary UOM | Numeric | 15 | ||
| LIPBCK | PBCK | Quantity on backorder | Numeric | 15 | ||
| LIPREQ | PREQ | Quantity on open purchase orders | Numeric | 15 | ||
| LIQWBO | QWBO | Quantity expected from open work orders | Numeric | 15 | ||
| LIOT1P | OT1P | Other quantity 1 (primary UOM) | Numeric | 15 | ||
| LIOT2P | OT2P | Other quantity 2 (primary UOM) | Numeric | 15 | ||
| LIOT1A | OT1A | Other purchasing quantity 1 | Numeric | 15 | ||
| LIHCOM | HCOM | Quantity hard committed to specific locations/lots | Numeric | 15 | ||
| LIPCOM | PCOM | Quantity soft committed by sales/work orders | Numeric | 15 | ||
| LIFCOM | FCOM | Quantity committed to future dated orders | Numeric | 15 | ||
| LIFUN1 | FUN1 | Quantity soft committed to work orders | Numeric | 15 | ||
| LIQOWO | QOWO | Quantity hard committed to work orders | Numeric | 15 | ||
| LIQTTR | QTTR | Quantity in transit between branches | Numeric | 15 | ||
| LIQTIN | QTIN | Quantity in inspection | Numeric | 15 | ||
| LIQONL | QONL | Quantity on loan to manufacturing | Numeric | 15 | ||
| LIQTRI | QTRI | Inbound warehouse-management quantity | Numeric | 15 | ||
| LIQTRO | QTRO | Outbound warehouse-management quantity | Numeric | 15 | ||
| LINCDJ | NCDJ | Next cycle count date | Numeric (DD type: Date) | 6 |
Field provenance: hand-curated.
Boilerplate SQL
Starting point for reading F41021 on Databricks — Julian dates, implied decimals, and padded strings are already converted. Set your Unity Catalog location and filter values below; they’re substituted into the SQL and the copy button.
Query parameters
4 parameters not filled: <catalog>, <schema_data>, <ITM>, <MCU>
-- ============================================================
-- Table : F41021 Item location — on-hand, committed, and inbound quantities by item, branch, location, and lot
-- Purpose: Column-selected read of F41021 — auto-generated from field metadata
-- Grain : One row per LIITM + LIMCU + LILOCN + LILOTN
-- Notes : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
loc.LIITM AS "Short item number - the internal numeric item key",
TRIM(loc.LIMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)",
loc.LILOCN AS "Storage location within the branch plant",
loc.LILOTN AS "Lot or serial number",
loc.LIPBIN AS "Flags the primary location for the item at this branch",
loc.LIGLPT AS "G/L class code for this location (overrides branch/item value)",
loc.LILOTS AS "Lot status code - blank means approved",
CASE WHEN loc.LILRCJ IS NULL OR loc.LILRCJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(loc.LILRCJ AS INT) DIV 1000, 1, 1), CAST(loc.LILRCJ AS INT) % 1000 - 1) END AS "Date of last receipt into this location", -- CYYDDD Julian → DATE
loc.LIPQOH AS "Quantity on hand in primary UOM",
loc.LIPBCK AS "Quantity on backorder",
loc.LIPREQ AS "Quantity on open purchase orders",
loc.LIQWBO AS "Quantity expected from open work orders",
loc.LIOT1P AS "Other quantity 1 (primary UOM)",
loc.LIOT2P AS "Other quantity 2 (primary UOM)",
loc.LIOT1A AS "Other purchasing quantity 1",
loc.LIHCOM AS "Quantity hard committed to specific locations/lots",
loc.LIPCOM AS "Quantity soft committed by sales/work orders",
loc.LIFCOM AS "Quantity committed to future dated orders",
loc.LIFUN1 AS "Quantity soft committed to work orders",
loc.LIQOWO AS "Quantity hard committed to work orders",
loc.LIQTTR AS "Quantity in transit between branches",
loc.LIQTIN AS "Quantity in inspection",
loc.LIQONL AS "Quantity on loan to manufacturing",
loc.LIQTRI AS "Inbound warehouse-management quantity",
loc.LIQTRO AS "Outbound warehouse-management quantity",
CASE WHEN loc.LINCDJ IS NULL OR loc.LINCDJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(loc.LINCDJ AS INT) DIV 1000, 1, 1), CAST(loc.LINCDJ AS INT) % 1000 - 1) END AS "Next cycle count date" -- CYYDDD Julian → DATE
FROM <catalog>.<schema_data>.f41021 loc
WHERE
loc.LIITM = <ITM>
-- AND loc.LIMCU = '<MCU>'
ORDER BY loc.LIITM;Verified September 2026
Relationships
Diagram of 1-hop neighbors — join details below. UDC decode edges point coded fields at their F0005 lookup.
Join details
ON f41021.LIITM = f4101.IMITM
Programs That Use This Table
R read · W write · R/W read + write
Primary programs
- P4112Inventory Issues — remove inventory from stock (for example to scrap or expense) with matching journal entriesRead/write accessInteractive
- P4113Inventory Transfers — move inventory between locations or branch/plants, recording both sides of the movementRead/write accessInteractive
- P4114Inventory Adjustments — correct on-hand quantity discrepancies (cycle count variances, damage, initial loads)Read/write accessInteractive
- P4116Item Reclassifications — reclassify inventory from one item number, lot, or location to anotherRead/write accessInteractive
- P41202Item Availability — inquire on on-hand, committed, and available quantities by item, branch, location, and lotRead accessInteractive
- R42995Repost Active Sales Orders — rebuild inventory commitments and open order totals when sales order and item location files disagreeRead/write accessBatch UBE
Secondary programs
- P3111Work Order Parts List — the screen for reviewing and revising the components attached to a specific work order, including substitutions and commitment changes.Read/write accessInteractive
- P31113Work Order Inventory Issues — the screen that issues component material to a work order, relieving on-hand inventory and writing IM transactions to the item ledger.Read/write accessInteractive
- P31114Work Order Completions — the screen that records finished goods coming off a work order, moving completed quantity into on-hand inventory and updating order status.Read/write accessInteractive
- P4101Item Master — the interactive application that creates and maintains F4101 itemsRead/write accessInteractive
- P41026Item Branch/Plant — assign items to branch/plants and maintain branch-level item attributes and locationsRead/write accessInteractive
- P4108Lot Master — maintain lot records, statuses, and dates for lot- and serial-controlled inventoryRead accessInteractive
- P4205Shipment Confirmation — confirm that ordered goods have shipped, updating order lines and inventory commitmentsRead/write accessInteractive
- P4210Sales Order Entry — the interactive application that creates and maintains F4201/F4211 ordersRead/write accessInteractive
- P42117Backorder Release — release backordered sales order lines when inventory becomes availableRead/write accessInteractive
- P4312PO Receipts — record receipt of goods against purchase orders, updating on-hand inventory and creating receiver recordsRead/write accessInteractive
- P43214Purchase Receipts Inquiry — review open and historical receipt records and reverse receipts when neededRead/write accessInteractive
- P4600Request Inquiry — the interactive application for reviewing putaway, picking, and replenishment requests, checking their status, and creating or canceling suggestions manuallyRead accessInteractive
- P4602Location Detail Maintenance — the interactive application for reviewing and correcting location detail records: what is stored in each warehouse location, in which units of measure, and how much capacity is committedRead accessInteractive
- P4617Warehouse Movement Confirmations — the interactive application that confirms (or overrides and cancels) putaway, pick, and replenishment suggestions, committing the physical inventory movesRead/write accessInteractive
- R31410Order Processing — the batch job that attaches the parts list and routing to work orders, commits inventory, and prints shop floor paperwork in one pass.Read/write accessBatch UBE
- R46140Batch Putaway Request — the batch job that creates putaway requests in bulk for received or completed items instead of generating them one at a time at receipt entryRead accessBatch UBE
- R46171Location Selection Driver — the batch engine that processes open putaway, picking, and replenishment requests and creates location suggestions using movement instructions, item profiles, and location capacityRead accessBatch UBE
More Inventory Management tables
- F4104Item cross-reference: links internal item numbers to external identifiers such as customer or supplier part numbers, substitutes, and replacements, keyed by cross-reference type.
- F4105Item cost table: one row per item, branch, location, lot, and cost method carrying the unit cost used to value inventory and purchasing transactions.
- F4108Lot master: one row per lot or serial number by item and branch, holding lot status, grade, potency, supplier lot linkage, and the full set of lot control dates.
- F4111Item ledger (Cardex) — every inventory movement with quantity, cost, and links back to source documents
- F4100Warehouse location master: one row per storage location within a branch/plant, defining physical attributes plus putaway, pick, and replenishment behavior.
- F41001Branch/plant inventory constants: the per-branch switchboard for item number symbols, location formatting, costing methods, commitment rules, and G/L interface options.