CREATE COLUMN TABLE "SBODEMODE"."RCT8" ("DocNum" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "InvType" NVARCHAR(20), "DocEntry" INTEGER CS_INT, "DocLine" INTEGER CS_INT, "ObjectType" NVARCHAR(20) DEFAULT '24', "LogInstanc" INTEGER CS_INT DEFAULT 0, "PaidEntry" INTEGER CS_INT, "PaidLine" INTEGER CS_INT, PRIMARY KEY ("DocNum", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "SBODEMODE"."RCT8" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$InvType$DocEntry$DocLine$','InvType','DocEntry','DocLine'));
ALTER TABLE "SBODEMODE"."RCT8" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$PaidEntry$PaidLine$','PaidEntry','PaidLine'));
CREATE INDEX "RCT8_INVOICE" ON "SBODEMODE"."RCT8" ( "InvType" ASC, "DocEntry" ASC, "DocLine" ASC );
CREATE INDEX "RCT8_PAYMENT" ON "SBODEMODE"."RCT8" ( "PaidEntry" ASC, "PaidLine" ASC )