# JD Edwards Inventory Tables: F41021 Item Location, F4111 Item Ledger, F4105 Item Cost

> Source: https://netray.co/tools/jde-inventory-tables-f41021-f4111-f4105-reference
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Reference for the JDE 9.2 inventory tables with key columns, the programs that maintain them, joins, and one row per F41021 quantity bucket explaining what drives it.

## Category

oracle

## Erp

JD Edwards EnterpriseOne

## Audience

- JDE developer
- Inventory analyst
- Distribution consultant
- Report writer

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### Table

**Key:** table

**Type:** text

#### Table name / column

**Key:** name

**Type:** text

#### Key columns

**Key:** keys

**Type:** text

#### Important columns or meaning

**Key:** important

**Type:** text

#### Maintained by

**Key:** maintained

**Type:** text

#### Joins to

**Key:** joins

**Type:** text

**Rows:**

#### Item Master

**Table:** F4101

**Keys:** IMITM

**Important:** IMLITM, IMAITM, IMDSC1, IMSTKT stocking type, IMLNTY line type, IMUOM1 primary UOM, IMGLPT G/L class, IMLOTS lot status

**Maintained:** Item Master (P4101)

**Joins:** F4102, F41021, F4111 on ITM

#### Item Branch File

**Table:** F4102

**Keys:** IBITM, IBMCU

**Important:** IBSTKT, IBLNTY, IBGLPT, IBROPI reorder point, IBROQI reorder quantity, IBSAFE safety stock, IBBUYR buyer, IBVEND supplier

**Maintained:** Item Branch/Plant (P41026)

**Joins:** F4101 on ITM; F41021 on ITM, MCU

#### Item Location File

**Table:** F41021

**Keys:** LIITM, LIMCU, LILOCN, LILOTN

**Important:** LIPBIN primary location P/S, LILOTS lot status, LIGLPT, LILRCJ last receipt date, quantity buckets below

**Maintained:** Updated by inventory, sales, purchasing and manufacturing transactions; reviewed in Item Availability (P41202)

**Joins:** F4102 on ITM, MCU; F4108 on ITM, MCU, LOTN; F4100 on MCU, LOCN

#### LIPQOH

**Table:** F41021

**Important:** Quantity on Hand - Primary units. Increased by receipts and completions, reduced by issues and shipments when inventory is relieved.

**Maintained:** P4112, P4113, P4114, P4312, P4205 or R42800

#### LIHCOM

**Table:** F41021

**Important:** Quantity - Hard Committed (sales lines committed to this location and lot).

**Maintained:** Sales order commitment, pick slip and ship confirm

#### LIPCOM

**Table:** F41021

**Important:** Quantity Soft Committed (sales lines committed at item and branch level, no location yet). Usually carried on the primary location record.

**Maintained:** Sales order entry

#### LIFCOM

**Table:** F41021

**Important:** Quantity on Future Commit (orders with a date beyond the commitment window).

**Maintained:** Sales order entry; Inventory Commitment (R42997) moves them into soft or hard commit

#### LIFUN1

**Table:** F41021

**Important:** Quantity - Work Order Soft Commit (parts lists attached to work orders).

**Maintained:** Work order parts list attachment

#### LIQOWO

**Table:** F41021

**Important:** Quantity - Work Order Hard Commit.

**Maintained:** Work order hard commitment of components

#### LIPREQ

**Table:** F41021

**Important:** Quantity on Purchase Order - primary units (open PO quantity due in).

**Maintained:** Purchase order entry and receipts

#### LIQWBO

**Table:** F41021

**Important:** Quantity on Work Order Receipt (open work order quantity expected).

**Maintained:** Work order entry and completions

#### LIPBCK

**Table:** F41021

**Important:** Quantity on Backorder.

**Maintained:** Sales order backorders

#### LIQTTR

**Table:** F41021

**Important:** Units - In Transit - Primary units.

**Maintained:** Receipt routing and transfer processing

#### LIQTIN

**Table:** F41021

**Important:** Units - In Inspection - Primary units.

**Maintained:** Receipt routing steps

#### LIQTO1 / LIQTO2

**Table:** F41021

**Important:** Units - In Operation 1 and 2 - Primary units (user defined receipt routing buckets).

**Maintained:** Receipt routing steps

#### LIQONL

**Table:** F41021

**Important:** Quantity - On Loan to Manufacturing.

**Maintained:** Manufacturing loan transactions

#### LIQTRI / LIQTRO

**Table:** F41021

**Important:** Quantity Inbound and Outbound - Warehouse (warehouse management putaway and pick requests).

**Maintained:** Warehouse Management

#### LIOT1P / LIOT2P / LIOT1A

**Table:** F41021

**Important:** Quantity 1 and 2 - Other primary units; Quantity - Other Purchasing 1. Buckets that branch constants can add or subtract.

**Maintained:** Configurable buckets; check your branch availability definition

#### Availability (P41202)

**Table:** F41021

**Important:** Available = on hand minus the commitments and adds you choose in the Item Availability Definition of Branch/Plant Constants (P41001), e.g. less soft, hard and future commits, plus PO receipts if selected.

**Maintained:** Defined per branch/plant in P41001

#### Item Ledger File (cardex)

**Table:** F4111

**Keys:** ILUKID

**Important:** ILITM, ILMCU, ILLOCN, ILLOTN, ILDOC, ILDCT, ILKCO, ILDOCO/ILDCTO/ILKCOO order, ILTRDJ, ILDGL, ILTRQT quantity, ILUNCS, ILPAID extended cost, ILTREX, ILGLPT, ILICU batch

**Maintained:** Written by every inventory transaction; viewed in Item Ledger Inquiry (CARDEX) (P4111)

**Joins:** F0911 on ILDOC, ILDCT, ILKCO, ILDGL, ILJELN; F4211 or F4311 on order keys

#### ILTRQT sign

**Table:** F4111

**Important:** Positive for quantity into the location (receipts, completions, transfers in), negative for quantity out (issues, shipments, transfers out).

#### Item Cost File

**Table:** F4105

**Keys:** COITM, COMCU, COLOCN, COLOTN, COLEDG

**Important:** COLEDG cost method, COUNCS unit cost (4 decimals), COCSIN costing selection - inventory, COCSPO costing selection - purchasing

**Maintained:** Cost Revisions (P4105)

**Joins:** F4102 on ITM, MCU

#### COLEDG cost method codes (UDC 40/CM)

**Table:** F4105

**Important:** 01 Last In, 02 Weighted Average, 07 Standard. Codes 01 to 19 are reserved by JD Edwards.

**Maintained:** UDC 40/CM

#### Lot Master

**Table:** F4108

**Keys:** IOLOTN, IOITM, IOMCU

**Important:** IOLOTS lot status, IOMMEJ expiration date, IOVEND supplier, IORLOT supplier lot, IOLOTP potency, IOLOTG grade, IOBBDJ best before, IOSBDJ sell by

**Maintained:** Lot Master (P4108)

**Joins:** F41021 on ITM, MCU, LOTN

#### Location Master

**Table:** F4100

**Keys:** LMMCU, LMLOCN

**Important:** LMAISL aisle, LMBIN bin, location level and warehouse attributes used by putaway and picking

**Maintained:** Location Master (P4100)

**Joins:** F41021 on MCU, LOCN

#### Inventory Constants

**Table:** F41001

**Keys:** CIMCU

**Important:** Location format, symbols for item numbers, item availability definition, G/L interface flags per branch/plant

**Maintained:** Branch/Plant Constants (P41001)

**Joins:** F4102 and F41021 on MCU

#### Item Units of Measure Conversion Factors

**Table:** F41002

**Keys:** UMMCU, UMITM, UMUM, UMRUM

**Important:** UMCONV conversion factor (7 decimals), UMCNV1 factor to primary, UMUSTR UOM structure

**Maintained:** Item Units of Measure from Item Master or Item Branch

**Joins:** F4101 on ITM; UMMCU is blank unless UOM conversion by branch is on

#### Item Cross Reference File

**Table:** F4104

**Keys:** IVITM, IVXRT, IVAN8, IVCITM, IVEXDJ, IVCIRV

**Important:** IVXRT cross-reference type, IVCITM customer or supplier item number, IVEFTJ effective, IVEXDJ expired

**Maintained:** Item Cross Reference (P4104)

**Joins:** F4101 on ITM; F0101 on AN8

#### Item History

**Table:** F4115

**Keys:** IHITM, IHMCU, IHFY

**Important:** Period sales quantities and amounts by fiscal year, used for sales history and forecasting

**Maintained:** Updated by Sales Update (R42800)

**Joins:** F4102 on ITM, MCU

**Notes:** Quantities in F41021 and F4111 are stored with implied decimals set by each data item's display decimals in the data dictionary, so check the DD before dividing. Business unit columns (LIMCU, ILMCU, COMCU) are right justified 12 character strings. Program numbers shown are the standard 9.2 applications; your site may run custom versions.

## Content

**Intro:** A working map of the JD Edwards EnterpriseOne 9.2 inventory tables: item master, item branch, item location balances, the F4111 cardex, cost, lot, location and UOM tables. Each F41021 quantity column has its own row so you can see what moves it before you build an availability report.

**Sections:**

#### How to use it

**Body:** Search a column alias such as LIHCOM or a table such as F4105 and read across: key columns, the important fields, the program that maintains the data and the usual join. Use the F41021 rows when an availability number on a report does not match Item Availability (P41202). The usual cause is that the report subtracts a bucket that the branch's availability definition does not, or the other way round. Export the table to Excel and keep it next to your SQL while you write the joins.

#### Where availability comes from

**Body:** F41021 holds one row per item, branch, location and lot, with separate quantity buckets: on hand, hard committed, soft committed, future committed, work order soft and hard commits, on PO, on work order receipt, in transit, in inspection and others. P41202 does not store availability. It calculates it from these buckets using the Item Availability Definition in Branch/Plant Constants (P41001), where you choose which quantities subtract (for example soft, hard and future commits) and which add (for example PO receipts). Two branches can legitimately show different availability for the same buckets.

**Bullets:**

- Soft commits usually sit on the primary location row (LIPBIN = P)
- Hard commits sit on the specific location and lot
- Future commits move to soft or hard via R42997

#### Worked example

**Body:** Item 1001 in branch M30, primary location, lot blank: LIPQOH 500, LIHCOM 120, LIPCOM 80, LIFCOM 40, LIPREQ 300. If P41001 subtracts hard, soft and future commits and does not add PO receipts, availability is 500 - 120 - 80 - 40 = 260. If the definition also adds quantity on PO, it becomes 560. To prove the on-hand figure, sum ILTRQT in F4111 for the same item, branch, location and lot; the total should equal LIPQOH unless history has been purged or a repost is needed.

#### Gotchas

**Body:** Do not join on LITM: use the short item number ITM. Remember that F4105 holds several rows per item and branch, one per cost method, and COCSIN flags the one used for inventory and sales costing. Weighted average costs (02) change as transactions post, so recompute margins from F4111 rather than from today's F4105 cost. F41002 rows are only branch specific when UOM conversion by branch is switched on in the system constants.

**Cta:** If you want buyers and planners to ask JD Edwards stock and availability questions in plain English, answered from F41021 and F4111 on your own servers, we can build that.

**Faq:**

#### What is the F41021 table in JDE?

**Answer:** F41021 is the Item Location File. It holds one row per item, branch/plant, location and lot with on hand and all commitment and incoming quantity buckets such as LIPQOH, LIHCOM, LIPCOM, LIFCOM, LIPREQ and LIQWBO. Its primary key is LIITM, LIMCU, LILOCN and LILOTN.

#### What is the item branch table in JDE?

**Answer:** F4102 is the Item Branch File, keyed by IBITM and IBMCU. It holds branch-specific settings such as stocking type, G/L class, buyer, supplier, reorder point, reorder quantity and safety stock. It is maintained in Item Branch/Plant (P41026) and joins to F4101 on the short item number.

#### What is the JDE F4111 table?

**Answer:** F4111 is the Item Ledger File, also called the cardex. Every inventory transaction writes a row with item, branch, location, lot, document number and type, transaction date, GL date, quantity (ILTRQT) and extended cost (ILPAID). Its unique key is ILUKID. You review it in Item Ledger Inquiry (P4111).

#### How is item availability calculated in JDE?

**Answer:** Item Availability (P41202) starts with on hand from F41021 and subtracts or adds the buckets selected in the Item Availability Definition of Branch/Plant Constants (P41001), for example hard, soft and future commits subtracted and PO receipts optionally added. The setting is per branch/plant, so check it before comparing reports.

## Search terms

f41021 table in jde, jde f4111 table, item location table jde, jde item branch table, item branch table in jde, item availability in jde, jde f4105 cost method, jde f4108 lot master

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json