CREATE COLUMN TABLE "IMCYC"."POR12" ("DocEntry" INTEGER CS_INT NOT NULL , "TaxId0" NVARCHAR(100), "TaxId1" NVARCHAR(100), "TaxId2" NVARCHAR(100), "TaxId3" NVARCHAR(100), "TaxId4" NVARCHAR(100), "TaxId5" NVARCHAR(100), "TaxId6" NVARCHAR(100), "TaxId7" NVARCHAR(100), "TaxId8" NVARCHAR(100), "TaxId9" NVARCHAR(100), "State" NVARCHAR(3), "County" NVARCHAR(7), "Incoterms" NVARCHAR(3), "Vehicle" NVARCHAR(10), "VidState" NVARCHAR(3), "NfRef" NVARCHAR(254), "Carrier" NVARCHAR(15), "QoP" INTEGER CS_INT, "PackDesc" NVARCHAR(10), "Brand" NVARCHAR(20), "NoSU" INTEGER CS_INT, "NetWeight" DECIMAL(21,6) CS_FIXED, "GrsWeight" DECIMAL(21,6) CS_FIXED, "LogInstanc" INTEGER CS_INT DEFAULT 0, "ObjectType" NVARCHAR(20) DEFAULT '22', "TaxId10" NVARCHAR(100), "TransCat" NVARCHAR(100), "FormNo" NVARCHAR(100), "TaxId11" NVARCHAR(100), "StreetS" NVARCHAR(100), "BlockS" NVARCHAR(100), "BuildingS" NCLOB MEMORY THRESHOLD 1000, "CityS" NVARCHAR(100), "ZipCodeS" NVARCHAR(20), "CountyS" NVARCHAR(100), "StateS" NVARCHAR(3), "CountryS" NVARCHAR(3), "AddrTypeS" NVARCHAR(100), "StreetNoS" NVARCHAR(100), "StreetB" NVARCHAR(100), "BlockB" NVARCHAR(100), "BuildingB" NCLOB MEMORY THRESHOLD 1000, "CityB" NVARCHAR(100), "ZipCodeB" NVARCHAR(20), "CountyB" NVARCHAR(100), "StateB" NVARCHAR(3), "CountryB" NVARCHAR(3), "AddrTypeB" NVARCHAR(100), "StreetNoB" NVARCHAR(100), "ImpORExp" CHAR(1) CS_FIXEDSTRING, "Vat" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "AltCrdNamB" NVARCHAR(100), "AltTaxIdB" NVARCHAR(32), "Address2S" NVARCHAR(50), "Address3S" NVARCHAR(50), "Address2B" NVARCHAR(50), "Address3B" NVARCHAR(50), "MainUsage" INTEGER CS_INT, "GlbLocNumS" NVARCHAR(50), "GlbLocNumB" NVARCHAR(50), "CollectDT" NVARCHAR(20), "TransprtDT" LONGDATE CS_LONGDATE, "TransprtRS" NVARCHAR(100), "TaxId12" NVARCHAR(50), "TaxId13" NVARCHAR(100), "ImpExpNo" NVARCHAR(100), "ImpExpDate" LONGDATE CS_LONGDATE, "BpGSTType" INTEGER CS_INT, "BpGSTN" NVARCHAR(15), "BpStateCod" NVARCHAR(3), "BPStatGSTN" NVARCHAR(2), "LocGSTType" INTEGER CS_INT, "LocGSTN" NVARCHAR(15), "LocStatCod" NVARCHAR(3), "LocStaGSTN" NVARCHAR(2), "BpCountry" NVARCHAR(3), "OrigImpNo" NVARCHAR(100), "OrigImpDat" LONGDATE CS_LONGDATE, "ExportType" CHAR(1) CS_FIXEDSTRING DEFAULT 'E', "PortCode" NVARCHAR(100), PRIMARY KEY ("DocEntry")) UNLOAD PRIORITY 0  AUTO MERGE 