CREATE TABLE [As400].[t_PACKL00F] (
    [CodStabilimento] CHAR (2)       NOT NULL,
    [ProgUDC]         CHAR (15)      NOT NULL,
    [CodParticolare]  CHAR (15)      NOT NULL,
    [CodContenitore]  CHAR (15)      NOT NULL,
    [MatrContenitore] CHAR (5)       NOT NULL,
    [Qta]             NUMERIC (5)    NOT NULL,
    [PesoNetto]       NUMERIC (7, 3) NOT NULL,
    [PesoLordo]       NUMERIC (7, 3) NOT NULL,
    [StaoPackList]    CHAR (1)       NOT NULL,
    [DataEntrata]     NUMERIC (8)    NOT NULL,
    [TipoAnagr]       CHAR (2)       NOT NULL,
    [CodAnagr]        CHAR (6)       NOT NULL
);


GO
CREATE NONCLUSTERED INDEX [i_update]
    ON [As400].[t_PACKL00F]([CodStabilimento] ASC, [ProgUDC] ASC, [CodParticolare] ASC, [CodContenitore] ASC, [MatrContenitore] ASC);

