R46140

-- ============================================================
-- Program: R46140 Batch Putaway Request — the batch job that creates putaway requests in bulk for received or completed items instead of generating them one at a time at receipt entry
-- Purpose: Batch Putaway Request — the batch job that creates putaway requests in bulk for received or completed items instead of generating them one at a time at receipt entry — auto-generated boilerplate from program-table-map
-- Grain  : One row per F4600
-- Tables : 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: F43121, F41021, F46010 are cataloged for this program, but no verified join condition connects them to F4600, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.R1RQBT AS "Batch number grouping requests created in the same run; first half of the request key.",
  h.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>.f4600 h
ORDER BY h.R1RQBT;