CREATE COLUMN TABLE "SBODEMODE"."JST1" ("AbsId" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT DEFAULT 0 NOT NULL , "WTCode" NVARCHAR(4), "BaseNum" INTEGER CS_INT DEFAULT -1, "BaseAbsId" INTEGER CS_INT, "BaseLine" INTEGER CS_INT, "LogInstanc" INTEGER CS_INT DEFAULT 0, "Rate" DECIMAL(21,6) CS_FIXED, "TdsRate" DECIMAL(21,6) CS_FIXED, "SurRate" DECIMAL(21,6) CS_FIXED, "CessRate" DECIMAL(21,6) CS_FIXED, "HscRate" DECIMAL(21,6) CS_FIXED, "TaxbleAmnt" DECIMAL(21,6) CS_FIXED, "TxblAmntSC" DECIMAL(21,6) CS_FIXED, "TxblAmntFC" DECIMAL(21,6) CS_FIXED, "Category" NVARCHAR(1), "Criteria" NVARCHAR(1), "Type" NVARCHAR(1), "RoundType" NVARCHAR(1), "BaseType" NVARCHAR(1), "Account" NVARCHAR(15), "TdsAcc" NVARCHAR(15), "SurAcc" NVARCHAR(15), "CessAcc" NVARCHAR(15), "HscAcc" NVARCHAR(15), "WTAmnt" DECIMAL(21,6) CS_FIXED, "WTAmntSC" DECIMAL(21,6) CS_FIXED, "WTAmntFC" 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, PRIMARY KEY ("AbsId", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "SBODEMODE"."JST1" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$AbsId$BaseNum$BaseAbsId$BaseLine$','AbsId','BaseNum','BaseAbsId','BaseLine'));
ALTER TABLE "SBODEMODE"."JST1" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$AbsId$WTCode$','AbsId','WTCode'));
CREATE INDEX "JST1_BASE_ENTRY" ON "SBODEMODE"."JST1" ( "AbsId" ASC, "BaseNum" ASC, "BaseAbsId" ASC, "BaseLine" ASC );
CREATE INDEX "JST1_WT_CODE" ON "SBODEMODE"."JST1" ( "AbsId" ASC, "WTCode" ASC )