

CREATE VIEW [External].[v_ExportDatiOdette]
AS

SELECT 
       [CampoUDC] AS [UDC] 
      ,[Campo1_2] AS [Campo1_2_Receiver]
      ,[CodMag]
      ,[Particolare]
      ,[Campo9_2] AS [Qta]
      ,[Campo11_2_2] AS [Imballo]
      ,[GrpBolla]
      ,[DataBolla]
      ,[NumBolla]

      --,[Campo2_2] AS [Campo2_2_Destination]
      --,[Campo3_2] AS [Campo3_2_DocNumber_Bolla]
      --,[Campo5_2] AS [Campo5_2_NetWeight]
      --,[Campo6_2] AS [Campo6_2_GrossWeight]
      --,[Campo7_2] AS [Campo7_2_Boxes_Colli]
      --,[Campo8_2] AS [Campo8_2_PartNumber]   -- Disegno
      --,[Campo13_2]   AS [Campo13_2_Data]
      --,[Campo15_2]   AS [Campo15_2_SerialNumber_ProgrOdette]
      --,[CodLista]

  FROM dbo.Odette

