CREATE COLUMN TABLE "IMCYC"."OLCT" ("Code" INTEGER CS_INT NOT NULL , "Location" NVARCHAR(100) NOT NULL , "UserSign" SMALLINT CS_INT, "PanCirNo" NVARCHAR(32), "PanWardNo" NVARCHAR(32), "PanOfficer" NVARCHAR(32), "TanCirNo" NVARCHAR(32), "TanWardNo" NVARCHAR(32), "TanOfficer" NVARCHAR(32), "LstVatNo" NVARCHAR(100), "CstNo" NVARCHAR(100), "ExemptNo" NVARCHAR(100), "TanNo" NVARCHAR(100), "ServTaxNo" NVARCHAR(100), "AsseType" NVARCHAR(100), "CompType" NVARCHAR(100), "NatOfBiz" NVARCHAR(100), "TinNo" NVARCHAR(100), "PanNo" NVARCHAR(10), "RegType" NVARCHAR(2), "EccNo" NVARCHAR(40), "CeRegNo" NVARCHAR(40), "CeRange" NVARCHAR(60), "CeDivision" NVARCHAR(60), "CeComRate" NVARCHAR(60), "ManuCode" NVARCHAR(60), "Jurisd" NVARCHAR(60), "Street" NVARCHAR(100), "Block" NVARCHAR(100), "ZipCode" NVARCHAR(20), "City" NVARCHAR(100), "County" NVARCHAR(100), "Country" NVARCHAR(3), "State" NVARCHAR(3), "Building" NCLOB MEMORY THRESHOLD 1000, "SSIExmpt" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "SSIExmptSt" CHAR(1) CS_FIXEDSTRING DEFAULT 'E', "CitAddress" NVARCHAR(254), "CitCity" NVARCHAR(100), "CitPinCode" NVARCHAR(10), "OnHoldAct" NVARCHAR(15), "GSTRegnNo" NVARCHAR(15), "GSTRelevt" NVARCHAR(2) DEFAULT 'N', "GSTTDS" NVARCHAR(30), "GSTISD" NVARCHAR(30), "GSTType" INTEGER CS_INT, "VendorCode" NVARCHAR(15), "CstmerCode" NVARCHAR(15), "DropShip" NVARCHAR(8), "IngClrAc" NVARCHAR(15), "IntBrClrAc" NVARCHAR(15), PRIMARY KEY ("Code")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OLCT_LOCATION" ON "IMCYC"."OLCT" ( "Location" ASC )