CREATE COLUMN TABLE "SBODEMOPT"."AINS" ("insID" INTEGER CS_INT NOT NULL , "customer" NVARCHAR(15), "custmrName" NVARCHAR(100), "contactCod" INTEGER CS_INT, "directCsmr" NVARCHAR(15), "drctCsmNam" NVARCHAR(100), "manufSN" NVARCHAR(36), "internalSN" NVARCHAR(36), "warranty" NVARCHAR(1) DEFAULT 'N', "wrrntyStrt" LONGDATE CS_LONGDATE, "wrrntyEnd" LONGDATE CS_LONGDATE, "responsVal" SMALLINT CS_INT, "responsUnt" NVARCHAR(1) DEFAULT 'D', "itemCode" NVARCHAR(50), "itemName" NVARCHAR(200), "itemGroup" SMALLINT CS_INT, "manufDate" LONGDATE CS_LONGDATE, "delivery" INTEGER CS_INT, "deliveryNo" INTEGER CS_INT, "invoice" INTEGER CS_INT, "invoiceNum" INTEGER CS_INT, "dlvryDate" LONGDATE CS_LONGDATE, "cntctPhone" NVARCHAR(20), "street" NVARCHAR(100), "block" NVARCHAR(100), "zip" NVARCHAR(20), "city" NVARCHAR(100), "county" NVARCHAR(100), "country" NVARCHAR(3), "state" NVARCHAR(3), "instLction" NVARCHAR(254), "contract" INTEGER CS_INT, "cntrctStrt" LONGDATE CS_LONGDATE, "cntrctEnd" LONGDATE CS_LONGDATE, "attachment" NCLOB MEMORY THRESHOLD 1000, "objType" NVARCHAR(20) DEFAULT '176', "logInstanc" INTEGER CS_INT NOT NULL , "userSign" SMALLINT CS_INT, "createDate" LONGDATE CS_LONGDATE, "userSign2" SMALLINT CS_INT, "updateDate" LONGDATE CS_LONGDATE, "Building" NCLOB MEMORY THRESHOLD 1000, "status" NVARCHAR(1) DEFAULT 'A', "replcIns" INTEGER CS_INT, "repByIns" INTEGER CS_INT, "technician" INTEGER CS_INT, "territory" INTEGER CS_INT, "AtcEntry" INTEGER CS_INT, "Transfered" NVARCHAR(1) DEFAULT 'N', "AddrType" NVARCHAR(100), "Instance" SMALLINT CS_INT DEFAULT 0, "StreetNo" NVARCHAR(100), "BPType" NVARCHAR(1) DEFAULT 'R', "OwnerCode" INTEGER CS_INT, "DPPStatus" NVARCHAR(1) DEFAULT 'N', "EncryptIV" NVARCHAR(100), PRIMARY KEY ("insID", "logInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 