CREATE COLUMN TABLE "IMCYC"."DLN23" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "AssetCode" NVARCHAR(50), "Status" CHAR(1) CS_FIXEDSTRING 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 '15', PRIMARY KEY INVERTED VALUE ("DocEntry", "LineNum", "VisOrder")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."DLN23" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$DocEntry$LineNum$AssetCode$','DocEntry','LineNum','AssetCode'));
CREATE INDEX "DLN23_ASSETS" ON "IMCYC"."DLN23" ( "DocEntry" ASC, "LineNum" ASC, "AssetCode" ASC )