CREATE COLUMN TABLE "IMCYC"."AWD3" ("AbsEntry" INTEGER CS_INT NOT NULL , "LineId" INTEGER CS_INT NOT NULL , "WTCode" NVARCHAR(4) NOT NULL , "KeyPart1" NVARCHAR(15) NOT NULL , "KeyPart2" NVARCHAR(15) NOT NULL , "DateFrom" LONGDATE CS_LONGDATE NOT NULL , "DateTo" LONGDATE CS_LONGDATE, "Rate" DECIMAL(21,6) CS_FIXED, "DetailType" NVARCHAR(2) NOT NULL , "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UpdateDate" LONGDATE CS_LONGDATE, "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , PRIMARY KEY INVERTED VALUE ("AbsEntry", "LineId", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."AWD3" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_AWD3_BP$','WTCode','KeyPart1','KeyPart2','DateFrom','DetailType','LogInstanc'));
CREATE UNIQUE INDEX "AWD3_BP" ON "IMCYC"."AWD3" ( "WTCode" ASC, "KeyPart1" ASC, "KeyPart2" ASC, "DateFrom" ASC, "DetailType" ASC, "LogInstanc" ASC )