CREATE TABLE [dbo].[AS400_BatchConsumoMP] (
    [ProgUDC]      CHAR (10)     NOT NULL,
    [UDC]          NVARCHAR (50) NOT NULL,
    [DataPrelFus]  NUMERIC (8)   NOT NULL,
    [TurnoPrelFus] NVARCHAR (50) NOT NULL,
    [DestLega]     NVARCHAR (50) NULL,
    [DestTerz]     NVARCHAR (50) NULL,
    [DataInvioAs]  DATETIME      NULL,
    CONSTRAINT [PK_AS400_BatchPrelievoMP] PRIMARY KEY CLUSTERED ([ProgUDC] ASC) WITH (FILLFACTOR = 95)
);


GO
CREATE NONCLUSTERED INDEX [i_UDC]
    ON [dbo].[AS400_BatchConsumoMP]([UDC] ASC) WITH (FILLFACTOR = 95);