CREATE COLUMN TABLE "IMCYC"."BAL1" ("AbsEntry" INTEGER CS_INT NOT NULL , "Instance" INTEGER CS_INT NOT NULL , "OBDate" LONGDATE CS_LONGDATE, "InAmount" DECIMAL(21,6) CS_FIXED, "InQty" DECIMAL(21,6) CS_FIXED, "OutQty" DECIMAL(21,6) CS_FIXED, "InAmntLWA" DECIMAL(21,6) CS_FIXED, "InQtyLWA" DECIMAL(21,6) CS_FIXED, "LastTrnsID" INTEGER CS_INT, "WasPrevOB" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CreateDate" LONGDATE CS_LONGDATE, "UpdateDate" LONGDATE CS_LONGDATE, "CrossPRev" DECIMAL(21,6) CS_FIXED, "WasUpdPrCB" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', PRIMARY KEY INVERTED VALUE ("AbsEntry", "Instance")) UNLOAD PRIORITY 0  AUTO MERGE 