CREATE COLUMN TABLE "IMCYC"."OBAL" ("AbsEntry" INTEGER CS_INT NOT NULL , "ItemCode" NVARCHAR(50) NOT NULL , "WhsCode" NVARCHAR(8) NOT NULL , "PeriodID" INTEGER CS_INT NOT NULL , "EvalSystem" CHAR(1) CS_FIXEDSTRING DEFAULT 'W' NOT NULL , "DtSorting" CHAR(1) CS_FIXEDSTRING DEFAULT 'P' NOT NULL , "LayerID" INTEGER CS_INT DEFAULT -1 NOT NULL , "CreateDate" LONGDATE CS_LONGDATE, PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 0  AUTO MERGE ;
ALTER TABLE "IMCYC"."OBAL" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_OBAL_SECONDARY$','ItemCode','WhsCode','PeriodID','EvalSystem','DtSorting','LayerID'));
CREATE UNIQUE INDEX "OBAL_SECONDARY" ON "IMCYC"."OBAL" ( "ItemCode" ASC, "WhsCode" ASC, "PeriodID" ASC, "EvalSystem" ASC, "DtSorting" ASC, "LayerID" ASC )