F4801T

-- ============================================================
-- Table  : F4801T Work order tag — one row per work order (same key as F4801) holding manufacturing extensions: line/cell, shift, planned cost buckets, secondary quantities, and production-number fields
-- Purpose: Column-selected read of F4801T — auto-generated from field metadata
-- Grain  : One row per WADOCO
-- 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.WADOCO AS "Work order number — sole primary key and the 1:1 join to F4801",
  f.WALINE AS "Production line or cell the order runs on — used by rate schedules and lean flows",
  f.WAMWDH AS "Scheduling bucket for the line (month/week/day/shift)",
  f.WASHFT AS "Shift code the order is scheduled to",
  f.WASRCN AS "Serialized-components flag — whether component serial tracking applies to this order",
  f.WALEDG AS "Cost method used to value the order (e.g. 07 standard)",
  CASE WHEN f.WAATST IS NULL OR f.WAATST = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.WAATST AS INT) DIV 1000, 1, 1), CAST(f.WAATST AS INT) % 1000 - 1) END AS "Actual start date (Julian CYYDDD) — compare to the planned start on F4801 for start-schedule adherence",  -- CYYDDD Julian → DATE
  f.WACRCD AS "Transaction currency code for order amounts",
  f.WAOTAM / POWER(10, 2) AS "Actual other (non-labor, non-material) cost; 2 implied decimals — completes the actuals triplet with F4801 LBAM/MTAM",  -- implied decimals: 2 (verify in F9210)
  f.WAPRJM AS "Project number for ETO/project manufacturing orders",
  f.WASQOR AS "Quantity ordered in the secondary unit of measure (dual-UOM items)",
  f.WASRNK / POWER(10, 2) AS "Shrink factor applied to the order quantity; 2 implied decimals",  -- implied decimals: 2 (verify in F9210)
  f.WASSOQ AS "Quantity completed in the secondary unit of measure",
  f.WAUOM2 AS "Secondary unit of measure for dual-UOM items",
  f.WAVFWO AS "Firm flag — a firmed order is protected from MRP replan messages",
  f.WAVEND AS "Supplier address number — relevant on outside-processing orders",
  f.WASEQN AS "Scheduling sequence number within the line/plan",
  f.WAPLMR / POWER(10, 2) AS "Planned material cost; 2 implied decimals",  -- implied decimals: 2 (verify in F9210)
  f.WAPLLB / POWER(10, 2) AS "Planned labor cost; 2 implied decimals",  -- implied decimals: 2 (verify in F9210)
  f.WAPLOS / POWER(10, 2) AS "Planned other cost; 2 implied decimals",  -- implied decimals: 2 (verify in F9210)
  f.WABGTC / POWER(10, 2) AS "Budgeted cost for the order; 2 implied decimals",  -- implied decimals: 2 (verify in F9210)
  f.WATOEM / POWER(10, 2) AS "Total estimated cost; 2 implied decimals",  -- implied decimals: 2 (verify in F9210)
  f.WATOPL / POWER(10, 2) AS "Total planned cost; 2 implied decimals — planned vs. estimated vs. actual gives the full cost bridge",  -- implied decimals: 2 (verify in F9210)
  f.WAOACM / POWER(10, 2) AS "Original committed amount; 2 implied decimals",  -- implied decimals: 2 (verify in F9210)
  f.WARACM / POWER(10, 2) AS "Remaining committed amount; 2 implied decimals",  -- implied decimals: 2 (verify in F9210)
  f.WAPMPN AS "Production number (long form) — ties supply to specific demand in production-number-controlled flows",
  f.WAPNS AS "Production number short — numeric surrogate for PMPN"
FROM <catalog>.<schema_data>.f4801t f
WHERE
  f.WADOCO = <DOCO>
ORDER BY f.WADOCO;