P4617

-- ============================================================
-- Program: P4617 Warehouse Movement Confirmations — the interactive application that confirms (or overrides and cancels) putaway, pick, and replenishment suggestions, committing the physical inventory moves
-- Purpose: Warehouse Movement Confirmations — the interactive application that confirms (or overrides and cancels) putaway, pick, and replenishment suggestions, committing the physical inventory moves — auto-generated boilerplate from program-table-map
-- Grain  : F4611 × F4600 — 1:N joins yield one row per detail line
-- Tables : F4611, F4600
-- 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: F4602, F41021, F4111 are cataloged for this program, but no verified join condition connects them to F4611, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.R2SGBT AS "Batch number grouping suggestions from one location-driver run; first half of the suggestion key.",
  h.R2SGSQ / POWER(10, 3) AS "Line sequence of the suggestion within its batch; second half of the suggestion key.",  -- implied decimals: 3 (verify in F9210)
  f4.R1RQSQ / POWER(10, 3) AS "Line sequence of the request within its batch; second half of the request key."  -- implied decimals: 3 (verify in F9210)
FROM <catalog>.<schema_data>.f4611 h
LEFT JOIN <catalog>.<schema_data>.f4600 f4
  ON f4.R1RQBT = h.R2RQBT
ORDER BY h.R2SGBT;