Samuele Locatelli
16 lines
961 B
SQL
16 lines
961 B
SQL
CREATE TABLE [RawData].[XOGIX00F] (
|
|
[XRPQLN] NUMERIC (6) CONSTRAINT [DF_XOGIX00F_XRPQLN] DEFAULT ((0)) NOT NULL,
|
|
[XRPQLD] NUMERIC (8) CONSTRAINT [DF_XOGIX00F_XRPQLD] DEFAULT ((0)) NOT NULL,
|
|
[XNRETI] CHAR (10) CONSTRAINT [DF_XOGIX00F_XNRETI] DEFAULT ('') NOT NULL,
|
|
[XCDFOR] CHAR (6) CONSTRAINT [DF_XOGIX00F_XCDFOR] DEFAULT ('') NOT NULL,
|
|
[XCDTER] CHAR (6) CONSTRAINT [DF_XOGIX00F_XCDTER] DEFAULT ('') NOT NULL,
|
|
[XCDPAR] CHAR (15) CONSTRAINT [DF_XOGIX00F_XCDPAR] DEFAULT ('') NOT NULL,
|
|
[XDTPRO] NUMERIC (8) CONSTRAINT [DF_XOGIX00F_XDTPRO] DEFAULT ((0)) NOT NULL,
|
|
[XTRPRO] CHAR (5) CONSTRAINT [DF_XOGIX00F_XTRPRO] DEFAULT ('') NOT NULL,
|
|
[XQTPRO] NUMERIC (5) CONSTRAINT [DF_XOGIX00F_XQTPRO] DEFAULT ((0)) NOT NULL,
|
|
[XDESMT] CHAR (3) CONSTRAINT [DF_XOGIX00F_XDESMT] DEFAULT ('') NOT NULL,
|
|
[XMATSC] CHAR (1) CONSTRAINT [DF_XOGIX00F_XMATSC] DEFAULT ('') NOT NULL,
|
|
[XBENQL] CHAR (1) NOT NULL
|
|
);
|
|
|