CREATE COLUMN TABLE "IMCYC"."TSH1" ("AbsEntry" INTEGER CS_INT NOT NULL , "LineID" INTEGER CS_INT NOT NULL , "Date" LONGDATE CS_LONGDATE, "ActType" INTEGER CS_INT, "LaborItem" NVARCHAR(50), "StartTime" INTEGER CS_INT, "EndTime" INTEGER CS_INT, "Workorder" INTEGER CS_INT, "WorAbs" INTEGER CS_INT, "ServCall" INTEGER CS_INT, "CostCenter" NVARCHAR(8), "FiProject" NVARCHAR(20), "Location" INTEGER CS_INT, "GPSData" NVARCHAR(50), "Branch" INTEGER CS_INT, "Break" INTEGER CS_INT, "NonBillTm" INTEGER CS_INT, "EffectTm" INTEGER CS_INT, "BillableTm" INTEGER CS_INT, "FullDay" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "LogInstanc" INTEGER CS_INT DEFAULT 0, PRIMARY KEY INVERTED VALUE ("AbsEntry", "LineID")) UNLOAD PRIORITY 5  AUTO MERGE 