R42995

-- ============================================================
-- Program: R42995 Repost Active Sales Orders — rebuild inventory commitments and open order totals when sales order and item location files disagree
-- Purpose: Repost Active Sales Orders — rebuild inventory commitments and open order totals when sales order and item location files disagree — auto-generated boilerplate from program-table-map
-- Grain  : F4211 × F4201 — 1:N joins yield one row per detail line
-- Tables : F4211, F4201
-- 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 is cataloged for this program, but no verified join condition connects it to F4211, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  d.SDKCOO AS "Order key company - disambiguates order numbers across companies",
  d.SDDOCO AS "Order number",
  d.SDDCTO AS "Order type code (SO, ST, CO, ...)",
  d.SDLNID / POWER(10, 3) AS "Order line number, stored x1000 (3 implied decimals)",  -- implied decimals: 3 (verify in F9210)
  d.SDDSC1 AS "Description line 1"
FROM <catalog>.<schema_data>.f4211 d
LEFT JOIN <catalog>.<schema_data>.f4201 h
  ON h.SHDOCO = d.SDDOCO
 AND h.SHKCOO = d.SDKCOO
 AND h.SHDCTO = d.SDDCTO
WHERE
  d.SDKCOO = '<KCOO>'
  AND d.SDDOCO = <DOCO>
  AND d.SDDCTO = '<DCTO>'
ORDER BY d.SDKCOO;