P4111

-- ============================================================
-- 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  : One row per F4111
-- Tables : F4111
-- 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.
-- Omitted: F4102 is cataloged for this program, but no verified join condition connects it to F4111, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  il.ILUKID AS "Unique key ID - the system-assigned surrogate key"
FROM <catalog>.<schema_data>.f4111 il
ORDER BY il.ILUKID;