CREATE COLUMN TABLE "SBODEMOPT"."AIT8" ("ItemCode" NVARCHAR(50) NOT NULL , "PeriodCat" NVARCHAR(10) NOT NULL , "DprArea" NVARCHAR(15) NOT NULL , "APC" DECIMAL(21,6) CS_FIXED, "APCHist" DECIMAL(21,6) CS_FIXED, "Quantity" DECIMAL(21,6) CS_FIXED, "OrDpAcc" DECIMAL(21,6) CS_FIXED, "UnDpAcc" DECIMAL(21,6) CS_FIXED, "SpDpKey1" NVARCHAR(2), "SpDpAcc1" DECIMAL(21,6) CS_FIXED, "SpDpKey2" NVARCHAR(2), "SpDpAcc2" DECIMAL(21,6) CS_FIXED, "SpDpKey3" NVARCHAR(2), "SpDpAcc3" DECIMAL(21,6) CS_FIXED, "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "ObjType" NVARCHAR(20) DEFAULT '4', "SalvageVal" DECIMAL(21,6) CS_FIXED, "OrDpAcc1" DECIMAL(21,6) CS_FIXED, "WriteUpAcc" DECIMAL(21,6) CS_FIXED, "IsMaSalVal" NVARCHAR(1) DEFAULT 'N', "AppreAcc" DECIMAL(21,6) CS_FIXED, PRIMARY KEY ("ItemCode", "PeriodCat", "DprArea", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 