CREATE COLUMN TABLE "SBODEMOPT"."AMDR1" ("OcrCode" NVARCHAR(8) NOT NULL , "PrcCode" NVARCHAR(8) NOT NULL , "PrcAmount" DECIMAL(21,6) CS_FIXED, "OcrTotal" DECIMAL(21,6) CS_FIXED, "Direct" NVARCHAR(1) DEFAULT 'N', "UserSign" SMALLINT CS_INT, "ValidFrom" LONGDATE CS_LONGDATE DEFAULT '19000101' NOT NULL , "ValidTo" LONGDATE CS_LONGDATE, "logInstanc" INTEGER CS_INT NOT NULL , "UserSign2" SMALLINT CS_INT, "updateDate" LONGDATE CS_LONGDATE, PRIMARY KEY ("OcrCode", "PrcCode", "ValidFrom", "logInstanc")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE INDEX "AMDR1_PROF_ID" ON "SBODEMOPT"."AMDR1" ( "PrcCode" ASC )