P4915

-- ============================================================
-- Program: P4915 Work With Shipments — the interactive workbench for reviewing, revising, routing, rating, and approving shipments after order entry creates them
-- Purpose: Work With Shipments — the interactive workbench for reviewing, revising, routing, rating, and approving shipments after order entry creates them — auto-generated boilerplate from program-table-map
-- Grain  : F4215 × F4941, F4211 — 1:N joins yield one row per detail line
-- Tables : F4215, F4941, 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.XHSHPN AS "Shipment number - the system-assigned key that groups order lines for transport; the same value lands on F4211.SDSHPN.",
  f.RSRSSN / POWER(10, 1) AS "Routing step number within the shipment.",  -- implied decimals: 1 (verify in F9210)
  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)
FROM <catalog>.<schema_data>.f4215 h
LEFT JOIN <catalog>.<schema_data>.f4941 f
  ON f.RSSHPN = h.XHSHPN
LEFT JOIN <catalog>.<schema_data>.f4211 d
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
ORDER BY h.XHSHPN;