-- WorkOrderTime Full Query
-- Source: JDESTAGE.F31122_VIEW
-- Destination: WorkOrderTime_Curr
-- Schedule: Mass/Daily/Hourly

SELECT wot.UNIQUEKEYIDINTERNAL_WTUKID AS UniqueID,
       TRIM(wot.COSTCENTERALT_WTMMCU) AS BranchCode,
       wot.DOCUMENTORDERINVOICEE_WTDOCO AS WorkOrderNumber,
       wot.SEQUENCENOOPERATIONS_WTOPSQ AS StepNumber,
       wot.ADDRESSNUMBER_WTAN8 AS AddressNumber,
       wot.DTFORGLANDVOUCH1_WTDGL AS GlDate,
       wot.DATEUPDATED_WTUPMJ AS DateUpdated,
       wot.TIMEOFDAY_WTTDAY AS TimeUpdated
  FROM JDESTAGE.F31122_VIEW wot