P4112

-- ============================================================
-- Program: P4112 Inventory Issues — remove inventory from stock (for example to scrap or expense) with matching journal entries
-- Purpose: Inventory Issues — remove inventory from stock (for example to scrap or expense) with matching journal entries — 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: F41021, F0911, F4102, F4105 are cataloged for this program, but no verified join condition connects them to F4111, so they are 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;