CREATE COLUMN TABLE "SBODEMOPT"."OTCN" ("AbsEntry" INTEGER CS_INT NOT NULL , "CCDNum" NVARCHAR(40) NOT NULL , "Date" LONGDATE CS_LONGDATE, "CustTerm" NVARCHAR(15), "CntrOrigin" NVARCHAR(3), "DirectImp" NVARCHAR(1) DEFAULT 'N' NOT NULL , "CardCode" NVARCHAR(15), PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OTCN_CCD" ON "SBODEMOPT"."OTCN" ( "CCDNum" ASC, "DirectImp" ASC )