R47131

-- ============================================================
-- Program: R47131 EDI Inbound Purchase Order Change Edit/Update — the batch processor that applies customer order changes (X12 860) to existing sales orders, comparing staged change records against the open order before updating it
-- Purpose: EDI Inbound Purchase Order Change Edit/Update — the batch processor that applies customer order changes (X12 860) to existing sales orders, comparing staged change records against the open order before updating it — auto-generated boilerplate from program-table-map
-- Grain  : F4201 × F4211 — 1:N joins yield one row per detail line
-- Tables : F4201, F4211
-- 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.
-- ============================================================
SELECT
  h.SHKCOO AS "Order key company - disambiguates order numbers across companies",
  h.SHDOCO AS "Order number",
  h.SHDCTO 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)
FROM <catalog>.<schema_data>.f4201 h
LEFT JOIN <catalog>.<schema_data>.f4211 d
  ON d.SDDOCO = h.SHDOCO
 AND d.SDKCOO = h.SHKCOO
 AND d.SDDCTO = h.SHDCTO
WHERE
  h.SHKCOO = '<KCOO>'
  AND h.SHDOCO = <DOCO>
  AND h.SHDCTO = '<DCTO>'
ORDER BY h.SHKCOO;