CREATE COLUMN TABLE "IMCYC"."CSI5" ("AbsEntry" INTEGER CS_INT NOT NULL , "WTCode" NVARCHAR(4) NOT NULL , "Rate" DECIMAL(21,6) CS_FIXED, "TaxbleAmnt" DECIMAL(21,6) CS_FIXED, "TxblAmntSC" DECIMAL(21,6) CS_FIXED, "TxblAmntFC" DECIMAL(21,6) CS_FIXED, "WTAmnt" DECIMAL(21,6) CS_FIXED, "WTAmntSC" DECIMAL(21,6) CS_FIXED, "WTAmntFC" DECIMAL(21,6) CS_FIXED, "ApplAmnt" DECIMAL(21,6) CS_FIXED, "ApplAmntSC" DECIMAL(21,6) CS_FIXED, "ApplAmntFC" DECIMAL(21,6) CS_FIXED, "Category" CHAR(1) CS_FIXEDSTRING, "Criteria" CHAR(1) CS_FIXEDSTRING, "Account" NVARCHAR(15), "Type" CHAR(1) CS_FIXEDSTRING, "RoundType" CHAR(1) CS_FIXEDSTRING, "BaseType" CHAR(1) CS_FIXEDSTRING, "BaseAbsEnt" INTEGER CS_INT DEFAULT -1 NOT NULL , "BaseLine" INTEGER CS_INT, "BaseNum" INTEGER CS_INT DEFAULT -1, "LineNum" INTEGER CS_INT NOT NULL , "BaseRef" INTEGER CS_INT, "Status" CHAR(1) CS_FIXEDSTRING DEFAULT 'O', "TrgType" INTEGER CS_INT, "TrgAbsEntr" INTEGER CS_INT DEFAULT -1, "LogInstanc" INTEGER CS_INT DEFAULT 0, "ObjType" NVARCHAR(20) DEFAULT '165', "Doc1LineNo" INTEGER CS_INT DEFAULT -1 NOT NULL , "WtLineType" CHAR(1) CS_FIXEDSTRING DEFAULT 'D', "TxblCurr" NVARCHAR(3), "DtblCurr" NVARCHAR(3), "DtblRate" DECIMAL(21,6) CS_FIXED, "txblRate" DECIMAL(21,6) CS_FIXED, "DtblAmount" DECIMAL(21,6) CS_FIXED, "TdsAcc" NVARCHAR(15), "SurAcc" NVARCHAR(15), "CessAcc" NVARCHAR(15), "HscAcc" NVARCHAR(15), "TdsRate" DECIMAL(21,6) CS_FIXED, "SurRate" DECIMAL(21,6) CS_FIXED, "CessRate" DECIMAL(21,6) CS_FIXED, "HscRate" DECIMAL(21,6) CS_FIXED, "TdsBAmt" DECIMAL(21,6) CS_FIXED, "TdsBAmtSC" DECIMAL(21,6) CS_FIXED, "TdsBAmtFC" DECIMAL(21,6) CS_FIXED, "SurBAmt" DECIMAL(21,6) CS_FIXED, "SurBAmtSC" DECIMAL(21,6) CS_FIXED, "SurBAmtFC" DECIMAL(21,6) CS_FIXED, "CessBAmt" DECIMAL(21,6) CS_FIXED, "CessBAmtSC" DECIMAL(21,6) CS_FIXED, "CessBAmtFC" DECIMAL(21,6) CS_FIXED, "HscBAmt" DECIMAL(21,6) CS_FIXED, "HscBAmtSC" DECIMAL(21,6) CS_FIXED, "HscBAmtFC" DECIMAL(21,6) CS_FIXED, "TdsAmnt" DECIMAL(21,6) CS_FIXED, "TdsAmntSC" DECIMAL(21,6) CS_FIXED, "TdsAmntFC" DECIMAL(21,6) CS_FIXED, "SurAmnt" DECIMAL(21,6) CS_FIXED, "SurAmntSC" DECIMAL(21,6) CS_FIXED, "SurAmntFC" DECIMAL(21,6) CS_FIXED, "CessAmnt" DECIMAL(21,6) CS_FIXED, "CessAmntSC" DECIMAL(21,6) CS_FIXED, "CessAmntFC" DECIMAL(21,6) CS_FIXED, "HscAmnt" DECIMAL(21,6) CS_FIXED, "HscAmntSC" DECIMAL(21,6) CS_FIXED, "HscAmntFC" DECIMAL(21,6) CS_FIXED, "TdsAppl" DECIMAL(21,6) CS_FIXED, "TdsApplSC" DECIMAL(21,6) CS_FIXED, "TdsApplFC" DECIMAL(21,6) CS_FIXED, "SurAppl" DECIMAL(21,6) CS_FIXED, "SurApplSC" DECIMAL(21,6) CS_FIXED, "SurApplFC" DECIMAL(21,6) CS_FIXED, "CessAppl" DECIMAL(21,6) CS_FIXED, "CessApplSC" DECIMAL(21,6) CS_FIXED, "CessApplFC" DECIMAL(21,6) CS_FIXED, "HscAppl" DECIMAL(21,6) CS_FIXED, "HscApplSC" DECIMAL(21,6) CS_FIXED, "HscApplFC" DECIMAL(21,6) CS_FIXED, "BatchNum" INTEGER CS_INT, "InCSTCode" NVARCHAR(2), "OutCSTCode" NVARCHAR(2), "DpmWTApl" DECIMAL(21,6) CS_FIXED, "DpmWTAplSC" DECIMAL(21,6) CS_FIXED, "DpmWTAplFC" DECIMAL(21,6) CS_FIXED, "WTTypeId" INTEGER CS_INT, "LnBsAmt" DECIMAL(21,6) CS_FIXED, "LnBsAmtSC" DECIMAL(21,6) CS_FIXED, "LnBsAmtFC" DECIMAL(21,6) CS_FIXED, "LnCmTAmt" DECIMAL(21,6) CS_FIXED, "LnCmTAmtSC" DECIMAL(21,6) CS_FIXED, "LnCmTAmtFC" DECIMAL(21,6) CS_FIXED, "TDSType" CHAR(1) CS_FIXEDSTRING, "IgstAcc" NVARCHAR(15), "CgstAcc" NVARCHAR(15), "SgstAcc" NVARCHAR(15), "IgstAmnt" DECIMAL(21,6) CS_FIXED, "IgstAmntSC" DECIMAL(21,6) CS_FIXED, "IgstAmntFC" DECIMAL(21,6) CS_FIXED, "CgstAmnt" DECIMAL(21,6) CS_FIXED, "CgstAmntSC" DECIMAL(21,6) CS_FIXED, "CgstAmntFC" DECIMAL(21,6) CS_FIXED, "SgstAmnt" DECIMAL(21,6) CS_FIXED, "SgstAmntSC" DECIMAL(21,6) CS_FIXED, "SgstAmntFC" DECIMAL(21,6) CS_FIXED, "IgstRate" DECIMAL(21,6) CS_FIXED, "CgstRate" DECIMAL(21,6) CS_FIXED, "SgstRate" DECIMAL(21,6) CS_FIXED, "IgstBAmt" DECIMAL(21,6) CS_FIXED, "IgstBAmtSC" DECIMAL(21,6) CS_FIXED, "IgstBAmtFC" DECIMAL(21,6) CS_FIXED, "CgstBAmt" DECIMAL(21,6) CS_FIXED, "CgstBAmtSC" DECIMAL(21,6) CS_FIXED, "CgstBAmtFC" DECIMAL(21,6) CS_FIXED, "SgstBAmt" DECIMAL(21,6) CS_FIXED, "SgstBAmtSC" DECIMAL(21,6) CS_FIXED, "SgstBAmtFC" DECIMAL(21,6) CS_FIXED, "IgstAppl" DECIMAL(21,6) CS_FIXED, "IgstApplSC" DECIMAL(21,6) CS_FIXED, "IgstApplFC" DECIMAL(21,6) CS_FIXED, "CgstAppl" DECIMAL(21,6) CS_FIXED, "CgstApplSC" DECIMAL(21,6) CS_FIXED, "CgstApplFC" DECIMAL(21,6) CS_FIXED, "SgstAppl" DECIMAL(21,6) CS_FIXED, "SgstApplSC" DECIMAL(21,6) CS_FIXED, "SgstApplFC" DECIMAL(21,6) CS_FIXED, "UtgstAcc" NVARCHAR(15), "CsgstAcc" NVARCHAR(15), "UtgstAmt" DECIMAL(21,6) CS_FIXED, "UtgstAmtSC" DECIMAL(21,6) CS_FIXED, "UtgstAmtFC" DECIMAL(21,6) CS_FIXED, "CsgstAmt" DECIMAL(21,6) CS_FIXED, "CsgstAmtSC" DECIMAL(21,6) CS_FIXED, "CsgstAmtFC" DECIMAL(21,6) CS_FIXED, "UtgstRate" DECIMAL(21,6) CS_FIXED, "CsgstRate" DECIMAL(21,6) CS_FIXED, "UtgstBAmt" DECIMAL(21,6) CS_FIXED, "UtgstBAmtS" DECIMAL(21,6) CS_FIXED, "UtgstBAmtF" DECIMAL(21,6) CS_FIXED, "CsgstBAmt" DECIMAL(21,6) CS_FIXED, "CsgstBAmtS" DECIMAL(21,6) CS_FIXED, "CsgstBAmtF" DECIMAL(21,6) CS_FIXED, "UtgstAppl" DECIMAL(21,6) CS_FIXED, "UtgstApplS" DECIMAL(21,6) CS_FIXED, "UtgstApplF" DECIMAL(21,6) CS_FIXED, "CsgstAppl" DECIMAL(21,6) CS_FIXED, "CsgstApplS" DECIMAL(21,6) CS_FIXED, "CsgstApplF" DECIMAL(21,6) CS_FIXED, PRIMARY KEY INVERTED VALUE ("AbsEntry", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."CSI5" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_CSI5_SECONDERY$','AbsEntry','WTCode','BaseAbsEnt','Doc1LineNo'));
CREATE UNIQUE INDEX "CSI5_SECONDERY" ON "IMCYC"."CSI5" ( "AbsEntry" ASC, "WTCode" ASC, "BaseAbsEnt" ASC, "Doc1LineNo" ASC )