F4961

-- ============================================================
-- Table  : F4961 One row per leg of a load - a depot-to-stop slice of the trip with scheduled versus confirmed weight, volume, and cube, plus scheduled and actual ship dates.
-- Purpose: Column-selected read of F4961 — auto-generated from field metadata
-- Grain  : One row per LLVMCU + LLLDNM + LLTRPL
-- 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
  TRIM(f.LLVMCU) AS "Trip depot business unit - first half of the load key.",
  f.LLLDNM AS "Load number - second half of the load key; join to F4960/F4961.",
  f.LLTRPL AS "Load leg number within the load.",
  f.LLORGN AS "Origin address book number the goods ship from.",
  TRIM(f.LLNMCU) AS "Shipment depot - the origin depot business unit.",
  f.LLSTSQ AS "Stop sequence position on the load.",
  f.LLSCWT AS "Scheduled load weight for the leg.",
  f.LLWTUM AS "Weight unit of measure.",
  f.LLSCVL AS "Scheduled volume in the volume UoM.",
  f.LLVLUM AS "Volume unit of measure.",
  f.LLSCCU AS "Scheduled cubes for the leg.",
  f.LLCVUM AS "Cubes unit of measure.",
  CASE WHEN f.LLLDDT IS NULL OR f.LLLDDT = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.LLLDDT AS INT) DIV 1000, 1, 1), CAST(f.LLLDDT AS INT) % 1000 - 1) END AS "Load confirm date - when the load was confirmed at the depot.",  -- CYYDDD Julian → DATE
  f.LLLDTM AS "Load confirm time (HHMMSS).",
  CASE WHEN f.LLLOAD IS NULL OR f.LLLOAD = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.LLLOAD AS INT) DIV 1000, 1, 1), CAST(f.LLLOAD AS INT) % 1000 - 1) END AS "Scheduled load date.",  -- CYYDDD Julian → DATE
  f.LLTMLS AS "Scheduled loading time (HHMMSS).",
  CASE WHEN f.LLPPDJ IS NULL OR f.LLPPDJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.LLPPDJ AS INT) DIV 1000, 1, 1), CAST(f.LLPPDJ AS INT) % 1000 - 1) END AS "Promised ship date.",  -- CYYDDD Julian → DATE
  f.LLPMDT AS "Scheduled ship time (HHMMSS).",
  CASE WHEN f.LLADDJ IS NULL OR f.LLADDJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.LLADDJ AS INT) DIV 1000, 1, 1), CAST(f.LLADDJ AS INT) % 1000 - 1) END AS "Actual ship date - the anchor for on-time-shipment analysis.",  -- CYYDDD Julian → DATE
  f.LLADTM AS "Actual ship time (HHMMSS)."
FROM <catalog>.<schema_data>.f4961 f
ORDER BY f.LLVMCU;