F4906

-- ============================================================
-- Table  : F4906 One row per carrier - the transportation attributes (SCAC code, auto-pay, performance rating) hung off an address book number that acts as a carrier.
-- Purpose: Column-selected read of F4906 — auto-generated from field metadata
-- Grain  : One row per CMCARS
-- 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.CMCARS AS "Carrier number - the address book number (F0101.ABAN8) this carrier record extends.",
  f.CMSCAC AS "Standard Carrier Alpha Code - the industry ID, useful for matching external freight data.",
  f.CMCAMD AS "Auto-pay flag - Y means freight update creates the carrier voucher automatically without a matched invoice.",
  f.CMSTFT AS "Shipment tracking type for this carrier.",
  f.CMRFQ1 AS "Reference number qualifier 1 used for tracking.",
  f.CMRFQ2 AS "Reference number qualifier 2 used for tracking.",
  f.CMRNDN AS "Rounding rule applied when rating this carrier.",
  f.CMDWFC AS "Dimensional weight factor for parcel-style rating.",
  f.CMRSLA AS "Y/N - carrier is eligible for automatic route selection.",
  f.CMPFSD AS "Whether payable freight posts at summary or detail level.",
  f.CMPRFM AS "Carrier performance rating."
FROM <catalog>.<schema_data>.f4906 f
ORDER BY f.CMCARS;