CREATE COLUMN TABLE "IMCYC"."OBGS" ("AbsId" INTEGER CS_INT NOT NULL , "Name" NVARCHAR(100) NOT NULL , "BaseId" INTEGER CS_INT, "InitRate" DECIMAL(21,6) CS_FIXED, "Locked" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FinancYear" LONGDATE CS_LONGDATE NOT NULL , "IsMain" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "RoundSys" SMALLINT CS_INT DEFAULT 0, "UserSign" SMALLINT CS_INT, "OcrCode" NVARCHAR(8), "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "PrjCode" NVARCHAR(20), PRIMARY KEY ("AbsId")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."OBGS" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_OBGS_SECOND$','Name','FinancYear'));
CREATE UNIQUE INDEX "OBGS_SECOND" ON "IMCYC"."OBGS" ( "Name" ASC, "FinancYear" ASC );
CREATE INDEX "OBGS_INTER_KEY" ON "IMCYC"."OBGS" ( "BaseId" ASC )