CREATE COLUMN TABLE "SBODEMODE"."RCT2" ("DocNum" INTEGER CS_INT NOT NULL , "InvoiceId" INTEGER CS_INT NOT NULL , "DocEntry" INTEGER CS_INT, "SumApplied" DECIMAL(21,6) CS_FIXED, "AppliedFC" DECIMAL(21,6) CS_FIXED, "AppliedSys" DECIMAL(21,6) CS_FIXED, "InvType" NVARCHAR(20) DEFAULT '13', "DocRate" DECIMAL(21,6) CS_FIXED, "Flags" INTEGER CS_INT DEFAULT 0, "IntrsStat" NVARCHAR(1) DEFAULT 'U', "DocLine" INTEGER CS_INT DEFAULT 0, "vatApplied" DECIMAL(21,6) CS_FIXED, "vatAppldFC" DECIMAL(21,6) CS_FIXED, "vatAppldSy" DECIMAL(21,6) CS_FIXED, "selfInv" NVARCHAR(1) DEFAULT 'N', "ObjType" NVARCHAR(20) DEFAULT '24', "LogInstanc" INTEGER CS_INT DEFAULT 0, "Dcount" DECIMAL(21,6) CS_FIXED, "DcntSum" DECIMAL(21,6) CS_FIXED, "DcntSumFC" DECIMAL(21,6) CS_FIXED, "DcntSumSy" DECIMAL(21,6) CS_FIXED, "BfDcntSum" DECIMAL(21,6) CS_FIXED, "BfDcntSumF" DECIMAL(21,6) CS_FIXED, "BfDcntSumS" DECIMAL(21,6) CS_FIXED, "BfNetDcnt" DECIMAL(21,6) CS_FIXED, "BfNetDcntF" DECIMAL(21,6) CS_FIXED, "BfNetDcntS" DECIMAL(21,6) CS_FIXED, "PaidSum" DECIMAL(21,6) CS_FIXED, "ExpAppld" DECIMAL(21,6) CS_FIXED, "ExpAppldFC" DECIMAL(21,6) CS_FIXED, "ExpAppldSC" DECIMAL(21,6) CS_FIXED, "Rounddiff" DECIMAL(21,6) CS_FIXED, "RounddifFc" DECIMAL(21,6) CS_FIXED, "RounddifSc" DECIMAL(21,6) CS_FIXED, "InstId" SMALLINT CS_INT DEFAULT 1, "WtAppld" DECIMAL(21,6) CS_FIXED, "WtAppldFC" DECIMAL(21,6) CS_FIXED, "WtAppldSC" DECIMAL(21,6) CS_FIXED, "LinkDate" LONGDATE CS_LONGDATE, "AmtDifPst" LONGDATE CS_LONGDATE, "PaidDpm" NVARCHAR(1) DEFAULT 'N', "DpmPosted" NVARCHAR(1), "ExpVatSum" DECIMAL(21,6) CS_FIXED, "ExpVatSumF" DECIMAL(21,6) CS_FIXED, "ExpVatSumS" DECIMAL(21,6) CS_FIXED, "IsRateDiff" NVARCHAR(1) DEFAULT 'N', "WtInvCatS" DECIMAL(21,6) CS_FIXED, "WtInvCatSF" DECIMAL(21,6) CS_FIXED, "WtInvCatSS" DECIMAL(21,6) CS_FIXED, "OcrCode" NVARCHAR(8), "DocTransId" INTEGER CS_INT, "MIEntry" INTEGER CS_INT DEFAULT 0, "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "IsSelected" NVARCHAR(1) DEFAULT 'N', "WTOnHold" DECIMAL(21,6) CS_FIXED, "WTOnhldPst" DECIMAL(21,6) CS_FIXED, "baseAbs" INTEGER CS_INT, "MIType" NVARCHAR(20), "DocSubType" NVARCHAR(2) DEFAULT '--', "SpltPmtVAT" NVARCHAR(1) DEFAULT 'N', "EncryptIV" NVARCHAR(100), "WTSum" DECIMAL(21,6) CS_FIXED, "WTSumFC" DECIMAL(21,6) CS_FIXED, "WTSumSC" DECIMAL(21,6) CS_FIXED, "SelOrder" INTEGER CS_INT, PRIMARY KEY ("DocNum", "InvoiceId")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "SBODEMODE"."RCT2" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$DocTransId$DocLine$','DocTransId','DocLine'));
CREATE INDEX "RCT2_JDT" ON "SBODEMODE"."RCT2" ( "DocTransId" ASC, "DocLine" ASC )