CREATE COLUMN TABLE "SBODEMOPT"."CTR1" ("ContractID" INTEGER CS_INT NOT NULL , "Line" INTEGER CS_INT NOT NULL , "ManufSN" NVARCHAR(36), "InternalSN" NVARCHAR(36), "ItemCode" NVARCHAR(50), "ItemName" NVARCHAR(200), "ItemGroup" SMALLINT CS_INT, "StartDate" LONGDATE CS_LONGDATE, "EndDate" LONGDATE CS_LONGDATE, "ItmGrpName" NVARCHAR(20), "InsID" INTEGER CS_INT, "TermDate" LONGDATE CS_LONGDATE, "LogInstanc" INTEGER CS_INT, "EncryptIV" NVARCHAR(100), PRIMARY KEY ("ContractID", "Line")) UNLOAD PRIORITY 5  AUTO MERGE 