CREATE TABLE [As400].[t_XOGIX00F] (
    [XRPQLN] NUMERIC (6) NOT NULL,
    [XRPQLD] NUMERIC (8) NOT NULL,
    [XNRETI] CHAR (10)   NOT NULL,
    [XCDFOR] CHAR (6)    NOT NULL,
    [XCDTER] CHAR (6)    NOT NULL,
    [XCDPAR] CHAR (15)   NOT NULL,
    [XDTPRO] NUMERIC (8) NOT NULL,
    [XTRPRO] CHAR (5)    NOT NULL,
    [XQTPRO] NUMERIC (5) NOT NULL,
    [XDESMT] CHAR (3)    NOT NULL,
    [XMATSC] CHAR (1)    NOT NULL,
    [XBENQL] CHAR (1)    NOT NULL
);


GO
CREATE NONCLUSTERED INDEX [i_update]
    ON [As400].[t_XOGIX00F]([XRPQLN] ASC, [XRPQLD] ASC, [XNRETI] ASC);