CREATE COLUMN TABLE "IMCYC"."TRS1" ("AbsEntry" INTEGER CS_INT NOT NULL , "ObjType" NVARCHAR(20), "LineID" INTEGER CS_INT NOT NULL , "ApDocType" NVARCHAR(20) NOT NULL , "ApDocEntry" INTEGER CS_INT NOT NULL , "ApDocOrdNo" INTEGER CS_INT DEFAULT -1 NOT NULL , "ApDocAdRef" INTEGER CS_INT DEFAULT -1, "MeansType" INTEGER CS_INT DEFAULT -1 NOT NULL , "PayLineID" INTEGER CS_INT DEFAULT -1 NOT NULL , "PayDocType" INTEGER CS_INT DEFAULT -1 NOT NULL , "PayDocEntr" INTEGER CS_INT DEFAULT -1 NOT NULL , PRIMARY KEY INVERTED VALUE ("AbsEntry", "LineID")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."TRS1" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_TRS1_SECONDARY$','AbsEntry','ApDocType','ApDocEntry','ApDocOrdNo','MeansType','PayLineID','PayDocType','PayDocEntr'));
CREATE UNIQUE INDEX "TRS1_SECONDARY" ON "IMCYC"."TRS1" ( "AbsEntry" ASC, "ApDocType" ASC, "ApDocEntry" ASC, "ApDocOrdNo" ASC, "MeansType" ASC, "PayLineID" ASC, "PayDocType" ASC, "PayDocEntr" ASC )