CREATE COLUMN TABLE "IMCYC"."OCRP" ("CrTypeCode" SMALLINT CS_INT NOT NULL , "CrTypeName" NVARCHAR(30) NOT NULL , "CreditCard" SMALLINT CS_INT, "DueTerms" NVARCHAR(8), "MinCredit" DECIMAL(21,6) CS_FIXED, "MinToPay" DECIMAL(21,6) CS_FIXED, "MaxValid" DECIMAL(21,6) CS_FIXED, "InstalMent" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Locked" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UserSign" SMALLINT CS_INT, PRIMARY KEY ("CrTypeCode")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OCRP_NAME" ON "IMCYC"."OCRP" ( "CrTypeName" ASC );
CREATE INDEX "OCRP_CRED_CODE" ON "IMCYC"."OCRP" ( "CreditCard" ASC );
CREATE INDEX "OCRP_INSTALMENT" ON "IMCYC"."OCRP" ( "InstalMent" ASC )