CREATE COLUMN TABLE "SBODEMODE"."CSV23" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "AssetCode" NVARCHAR(50), "Status" NVARCHAR(1) DEFAULT 'O', "Remarks" NVARCHAR(100), "Amount" DECIMAL(21,6) CS_FIXED, "AmountSC" DECIMAL(21,6) CS_FIXED, "SerialNo" NVARCHAR(30), "VisOrder" INTEGER CS_INT NOT NULL , "LogInstanc" INTEGER CS_INT DEFAULT 0, "ObjectType" NVARCHAR(20) DEFAULT '166', PRIMARY KEY ("DocEntry", "LineNum", "VisOrder")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "SBODEMODE"."CSV23" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$DocEntry$LineNum$AssetCode$','DocEntry','LineNum','AssetCode'));
CREATE INDEX "CSV23_ASSETS" ON "SBODEMODE"."CSV23" ( "DocEntry" ASC, "LineNum" ASC, "AssetCode" ASC )