CREATE COLUMN TABLE "SBODEMODE"."CSI27" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "RelateType" INTEGER CS_INT DEFAULT -1, "RelateLine" INTEGER CS_INT DEFAULT -1, "GroupNum" INTEGER CS_INT DEFAULT -1, "LineTotal" DECIMAL(21,6) CS_FIXED, "LineTotalF" DECIMAL(21,6) CS_FIXED, "LineTotalS" DECIMAL(21,6) CS_FIXED, "InClassTyp" INTEGER CS_INT, "InClassCat" INTEGER CS_INT, "ExClassTyp" INTEGER CS_INT, "ExClassCat" INTEGER CS_INT, "VatCate" INTEGER CS_INT, "NetValue" DECIMAL(21,6) CS_FIXED, "NetValueFC" DECIMAL(21,6) CS_FIXED, "NetValueSC" DECIMAL(21,6) CS_FIXED, "VatAmount" DECIMAL(21,6) CS_FIXED, "VatAmFC" DECIMAL(21,6) CS_FIXED, "VatAmSC" DECIMAL(21,6) CS_FIXED, "WtPercCat" INTEGER CS_INT, "WtAmount" DECIMAL(21,6) CS_FIXED, "WtAmountFC" DECIMAL(21,6) CS_FIXED, "WtAmountSC" DECIMAL(21,6) CS_FIXED, "ObjectType" NVARCHAR(20) DEFAULT '165', "LogInstanc" INTEGER CS_INT DEFAULT 0, "WtCategory" NVARCHAR(1), "VATClassTy" INTEGER CS_INT, "VATClassCa" INTEGER CS_INT, "EBVatExCau" INTEGER CS_INT, "RecType" INTEGER CS_INT, "StampDutyC" INTEGER CS_INT, "OtherTaxCt" INTEGER CS_INT, "FeesCtegr" INTEGER CS_INT, PRIMARY KEY ("DocEntry", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "SBODEMODE"."CSI27" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$DocEntry$RelateType$RelateLine$GroupNum$','DocEntry','RelateType','RelateLine','GroupNum'));
CREATE INDEX "CSI27_RELATE_ROW" ON "SBODEMODE"."CSI27" ( "DocEntry" ASC, "RelateType" ASC, "RelateLine" ASC, "GroupNum" ASC )