F4611

-- ============================================================
-- Table  : F4611 One row per system-generated movement suggestion answering an F4600 request: the proposed from/to location, quantity, cube and weight charged, and wave/task assignment.
-- Purpose: Column-selected read of F4611 — auto-generated from field metadata
-- Grain  : One row per R2SGBT + R2SGSQ
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. 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.
-- ============================================================
SELECT
  f.R2SGBT AS "Batch number grouping suggestions from one location-driver run; first half of the suggestion key.",
  f.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)
  f.R2TYFL AS "Movement type of the suggestion: 1 = putaway, 2 = pick, 3 = replenishment. Hard-coded values, not UDC-validated.",
  f.R2RQBT AS "Batch number of the F4600 request this suggestion answers.",
  f.R2RQSQ / POWER(10, 3) AS "Sequence of the F4600 request this suggestion answers.",  -- implied decimals: 3 (verify in F9210)
  f.R2PWAV AS "Wave number grouping pick suggestions released and worked together.",
  f.R2PTSK AS "Warehouse task number assigned to the suggestion; task headers live in F4601.",
  TRIM(f.R2MCU) AS "Branch/plant (warehouse) where the movement happens.",
  f.R2KCOO AS "Company portion of the originating order key.",
  f.R2DOCO AS "Originating order/document number behind the movement.",
  f.R2DCTO AS "Order type of the originating document.",
  f.R2LNID / POWER(10, 3) AS "Line number on the originating order.",  -- implied decimals: 3 (verify in F9210)
  f.R2ITM AS "Short item number being moved.",
  f.R2LITM AS "Second (external) item number.",
  f.R2UOM1 AS "Primary unit of measure of the item.",
  f.R2TQTY AS "Total suggested quantity in primary UOM.",
  f.R2CUBE / POWER(10, 2) AS "Cubic volume this suggestion occupies — what the capacity engine charged against the location.",  -- implied decimals: 2 (verify in F9210)
  f.R2WEIT / POWER(10, 2) AS "Weight this suggestion occupies at the location.",  -- implied decimals: 2 (verify in F9210)
  f.R2LDFS AS "Sequence of the F4602 location-detail row stock moves from.",
  f.R2FLOC AS "Suggested from-location.",
  f.R2FLOT AS "Lot/serial number moving from.",
  f.R2TLOC AS "Suggested to-location — the system's answer to a putaway or replenishment request.",
  f.R2TLOT AS "Lot/serial number at the destination.",
  f.R2EQTY AS "Container code assumed for the movement.",
  f.R2MPUT AS "Movement-instruction table (F46095 rule set) that produced this suggestion; useful for auditing why stock went where it did.",
  f.R2PUTP AS "Process mode assigned by process selection (F46093).",
  f.R2PSTB AS "Lifecycle status of the suggestion (UDC 46/PS; suggestions move through the 3xx range — created, printed, confirmed). Pairs with the request status on F4600.",
  f.R2PZON AS "Putaway zone of the suggested location.",
  f.R2KZON AS "Picking zone of the suggested location.",
  f.R2ZONR AS "Replenishment zone of the suggested location.",
  f.R2PRIO AS "Processing priority carried from the request.",
  f.R2PHAS AS "Phase flag for two-phase movements (interim staging move vs. final move).",
  CASE WHEN f.R2DTCR IS NULL OR f.R2DTCR = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.R2DTCR AS INT) DIV 1000, 1, 1), CAST(f.R2DTCR AS INT) % 1000 - 1) END AS "Date the suggestion was created.",  -- CYYDDD Julian → DATE
  CASE WHEN f.R2DTPT IS NULL OR f.R2DTPT = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.R2DTPT AS INT) DIV 1000, 1, 1), CAST(f.R2DTPT AS INT) % 1000 - 1) END AS "Date move tags/documents were printed.",  -- CYYDDD Julian → DATE
  f.R2UKID AS "Internal unique key of the suggestion.",
  f.R2CKID AS "Unique key of the confirmed record this suggestion produced on confirmation.",
  f.R2SHPN AS "Shipment number for outbound picks.",
  f.R2LDNM AS "Load number for outbound picks.",
  f.R2LPNUF AS "License plate stock moves from.",
  f.R2LPNUT AS "License plate at the destination."
FROM <catalog>.<schema_data>.f4611 f
ORDER BY f.R2SGBT;