JDE Reference

P4111

Interactive

Item Ledger Inquiry (Cardex) — review the full transaction history behind every inventory quantity movement

Module: 41 · Inventory Management
Lineage hook

Rows written by P4111 carry …PID = 'P4111' in their audit columns — a ready-made marker for isolating the records this program produced. See the audit-columns guide →

Boilerplate SQL

Databricks SQL

Starting point for querying the tables behind this program. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters
-- ============================================================
-- Program: P4111 Item Ledger Inquiry (Cardex) — review the full transaction history behind every inventory quantity movement
-- Purpose: Item Ledger Inquiry (Cardex) — review the full transaction history behind every inventory quantity movement — auto-generated boilerplate from program-table-map
-- Grain  : F4111 × F4102 — 1:N joins yield one row per detail line
-- Tables : F4111, F4102
-- Notes  : Auto-generated skeleton. Julian dates are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210). 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
  il.ILUKID AS "Unique key ID - the system-assigned surrogate key",
  ib.IBITM AS "Short item number - the internal numeric item key",
  TRIM(ib.IBMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)"
FROM <catalog>.<schema_data>.f4111 il
LEFT JOIN <catalog>.<schema_data>.f4102 ib
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
ORDER BY il.ILUKID;

2 parameters not filled: <catalog>, <schema_data>

Tables Used by This Program