CREATE COLUMN TABLE "IMCYC"."ICD4" ("DocEntry" INTEGER CS_INT NOT NULL , "CounterNum" INTEGER CS_INT NOT NULL , "CounteType" INTEGER CS_INT DEFAULT 12 NOT NULL , "CounterId" INTEGER CS_INT NOT NULL , "CounteName" NVARCHAR(155), "LogIns" INTEGER CS_INT, "VisOrder" INTEGER CS_INT, PRIMARY KEY INVERTED VALUE ("DocEntry", "CounterNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."ICD4" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_ICD4_BUSINESS$','DocEntry','CounteType','CounterId'));
CREATE UNIQUE INDEX "ICD4_BUSINESS" ON "IMCYC"."ICD4" ( "DocEntry" ASC, "CounteType" ASC, "CounterId" ASC )