CREATE COLUMN TABLE "SBODEMODE"."WTD4" ("AbsEntry" INTEGER CS_INT NOT NULL , "LineId" INTEGER CS_INT NOT NULL , "WTCode" NVARCHAR(4) NOT NULL , "ItemCode" NVARCHAR(50) NOT NULL , "DateFrom" LONGDATE CS_LONGDATE NOT NULL , "DateTo" LONGDATE CS_LONGDATE, "DataSource" NVARCHAR(1) DEFAULT 'N', "UpdateDate" LONGDATE CS_LONGDATE, "LogInstanc" INTEGER CS_INT DEFAULT 0, PRIMARY KEY ("AbsEntry", "LineId")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "WTD4_ITEM" ON "SBODEMODE"."WTD4" ( "WTCode" ASC, "ItemCode" ASC, "DateFrom" ASC )