F4942

-- ============================================================
-- Table  : F4942 One row per order line per shipment routing step - the bridge between order detail and the shipment, carrying the line's shipped quantity, weight, volume, and value.
-- Purpose: Column-selected read of F4942 — auto-generated from field metadata
-- Grain  : One row per ISSHPN + ISRSSN + ISDOCO + ISDCTO + ISKCOO + ISLNID
-- 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.ISSHPN AS "Shipment number - the system-assigned key that groups order lines for transport; the same value lands on F4211.SDSHPN.",
  f.ISRSSN / POWER(10, 1) AS "Routing step number within the shipment.",  -- implied decimals: 1 (verify in F9210)
  f.ISDOCO AS "Order number of the related order line - joins F4211.SDDOCO (or F4311 for inbound).",
  f.ISDCTO AS "Order type of the related order line.",
  f.ISKCOO AS "Order key company of the related order line.",
  f.ISLNID / POWER(10, 3) AS "Order line number; 3 implied decimals - matches F4211.SDLNID as stored.",  -- implied decimals: 3 (verify in F9210)
  f.ISWGTS / POWER(10, 4) AS "Shipment weight in the weight UoM; stored with 4 implied decimals - divide by 10,000.",  -- implied decimals: 4 (verify in F9210)
  f.ISWTUM AS "Weight unit of measure.",
  f.ISSCVL AS "Scheduled volume in the volume UoM.",
  f.ISVLUM AS "Volume unit of measure.",
  f.ISITM AS "Short item number; join to F4101.IMITM.",
  f.ISSOQS AS "Quantity shipped on this order line.",
  f.ISUOM AS "Unit of measure of the transaction quantity.",
  f.ISPRP1 AS "Commodity class of the item.",
  f.ISNMFC AS "National Motor Freight Classification used for LTL rating.",
  f.ISDSGP AS "Dispatch group - groups compatible products for transport.",
  f.ISHZDC AS "Hazardous material class or division.",
  f.ISFRT1 AS "Freight category code 1 used in rating.",
  f.ISFRT2 AS "Freight category code 2 used in rating.",
  f.ISAEXP / POWER(10, 2) AS "Extended sales value of the goods being shipped; 2 implied decimals.",  -- implied decimals: 2 (verify in F9210)
  f.ISFEA / POWER(10, 2) AS "Extended sales value in the foreign currency; 2 implied decimals.",  -- implied decimals: 2 (verify in F9210)
  f.ISCRCD AS "Transaction (from) currency code.",
  f.ISECST / POWER(10, 2) AS "Extended cost of the goods being shipped; 2 implied decimals.",  -- implied decimals: 2 (verify in F9210)
  f.ISCUMS AS "Cumulative quantity shipped."
FROM <catalog>.<schema_data>.f4942 f
WHERE
  f.ISSHPN = <SHPN>
  -- AND f.ISDOCO = <DOCO>
  -- AND f.ISDCTO = '<DCTO>'
  -- AND f.ISKCOO = '<KCOO>'
ORDER BY f.ISSHPN;