P4116

-- ============================================================
-- Program: P4116 Item Reclassifications — reclassify inventory from one item number, lot, or location to another
-- Purpose: Item Reclassifications — reclassify inventory from one item number, lot, or location to another — 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, F4108, F4102 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;