F4945

-- ============================================================
-- Table  : F4945 One row per calculated freight charge on a shipment routing step or load - billable (customer) and payable (carrier) charges by rate name and charge code, as they stand before freight update moves them to history.
-- Purpose: Column-selected read of F4945 — auto-generated from field metadata
-- Grain  : One row per SCUK01
-- 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.SCUK01 AS "Internal unique key - the physical primary key of this table.",
  f.SCSHPN AS "Shipment number - the system-assigned key that groups order lines for transport; the same value lands on F4211.SDSHPN.",
  f.SCRSSN / POWER(10, 1) AS "Routing step number within the shipment.",  -- implied decimals: 1 (verify in F9210)
  TRIM(f.SCVMCU) AS "Trip depot business unit - first half of the load key; join to F4960.TMVMCU.",
  f.SCLDNM AS "Load number - second half of the load key; join to F4960/F4961.",
  f.SCDLNO AS "Delivery number, used when freight is charged at the delivery level.",
  f.SCOSEQ AS "Charge sequence number within the routing step.",
  f.SCRTNM AS "Rate name that produced this charge.",
  f.SCNMFC AS "National Motor Freight Classification used for LTL rating.",
  f.SCDSGP AS "Dispatch group - groups compatible products for transport.",
  f.SCFRT1 AS "Freight category code 1 used in rating.",
  f.SCFRT2 AS "Freight category code 2 used in rating.",
  f.SCCGC1 AS "Charge code classifying the freight charge (line haul, fuel surcharge...).",
  f.SCAG / POWER(10, 2) AS "Gross charge amount; 2 implied decimals.",  -- implied decimals: 2 (verify in F9210)
  f.SCBLPB AS "Charge direction: billable to the customer or payable to the carrier - always filter or group on this.",
  f.SCCRDC AS "Billing (to) currency code.",
  f.SCFAA / POWER(10, 2) AS "Gross charge amount in foreign currency; 2 implied decimals.",  -- implied decimals: 2 (verify in F9210)
  f.SCNAMF / POWER(10, 2) AS "Net charge amount in foreign currency; 2 implied decimals.",  -- implied decimals: 2 (verify in F9210)
  f.SCRTDQ / POWER(10, 4) AS "Quantity the rate was applied against; 4 implied decimals.",  -- implied decimals: 4 (verify in F9210)
  f.SCNAMT / POWER(10, 2) AS "Net charge amount after discounts; 2 implied decimals - the number to aggregate for freight spend.",  -- implied decimals: 2 (verify in F9210)
  f.SCUOM AS "Unit of measure of the transaction quantity.",
  f.SCRTGB AS "Rate basis the charge was computed on (weight, volume, pieces...).",
  f.SCCRCD AS "Transaction (from) currency code.",
  f.SCDOCO AS "Order number of the related order line - joins F4211.SDDOCO (or F4311 for inbound).",
  f.SCDCTO AS "Order type of the related order line.",
  f.SCKCOO AS "Order key company of the related order line.",
  f.SCLNID / POWER(10, 3) AS "Order line number; 3 implied decimals - matches F4211.SDLNID as stored.",  -- implied decimals: 3 (verify in F9210)
  f.SCOVFG AS "Manual override flag on the charge.",
  f.SCUKID AS "Internal unique key ID.",
  CASE WHEN f.SCEFTJ IS NULL OR f.SCEFTJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.SCEFTJ AS INT) DIV 1000, 1, 1), CAST(f.SCEFTJ AS INT) % 1000 - 1) END AS "Effective date of the rate used."  -- CYYDDD Julian → DATE
FROM <catalog>.<schema_data>.f4945 f
ORDER BY f.SCUK01;