JDE Reference

P4108

Interactive

Lot Master — maintain lot records, statuses, and dates for lot- and serial-controlled inventory

Module: 41 · Inventory Management
Lineage hook

Rows written by P4108 carry …PID = 'P4108' 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: P4108 Lot Master — maintain lot records, statuses, and dates for lot- and serial-controlled inventory
-- Purpose: Lot Master — maintain lot records, statuses, and dates for lot- and serial-controlled inventory — auto-generated boilerplate from program-table-map
-- Grain  : F4108 × F4102, F41021 — 1:N joins yield one row per detail line
-- Tables : F4108, F4102, F41021
-- 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
  h.IOLOTN AS "Lot or serial number identifying the specific lot of stock.",
  h.IOITM AS "Short internal item number (8-digit numeric key).",
  TRIM(h.IOMCU) AS "Branch/plant (business unit); stored right-justified with leading blanks.",
  h.IOLDSC AS "Free-text description of the lot.",
  loc.LILOCN AS "Storage location within the branch plant"
FROM <catalog>.<schema_data>.f4108 h
LEFT JOIN <catalog>.<schema_data>.f4102 ib
  ON ib.IBITM = h.IOITM
 AND ib.IBMCU = h.IOMCU
LEFT JOIN <catalog>.<schema_data>.f41021 loc
  ON loc.LIITM = h.IOITM
 AND loc.LIMCU = h.IOMCU
 AND loc.LILOTN = h.IOLOTN
WHERE
  h.IOITM = <ITM>
  AND h.IOMCU = '<MCU>'
ORDER BY h.IOITM;

4 parameters not filled: <catalog>, <schema_data>, <ITM>, <MCU>

Tables Used by This Program