R49115

-- ============================================================
-- Program: R49115 Transportation Bill of Lading — the batch print job that produces bill of lading documents for confirmed shipments, with options for delivery instructions and shipment attachments
-- Purpose: Transportation Bill of Lading — the batch print job that produces bill of lading documents for confirmed shipments, with options for delivery instructions and shipment attachments — auto-generated boilerplate from program-table-map
-- Grain  : One row per F4215
-- Tables : F4215
-- 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: F4211, F4101 are cataloged for this program, but no verified join condition connects them to F4215, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.XHSHPN AS "Shipment number - the system-assigned key that groups order lines for transport; the same value lands on F4211.SDSHPN."
FROM <catalog>.<schema_data>.f4215 h
WHERE
  h.XHSHPN = <SHPN>
ORDER BY h.XHSHPN;