CREATE ROW TABLE "IMCYC"."ODBN"  ( "ItemCode" NVARCHAR(50)  CS_STRING, "SysNumber" INT CS_INT, "DistNumber" NVARCHAR(36)  CS_STRING, "MnfSerial" NVARCHAR(36)  CS_STRING, "LotNumber" NVARCHAR(36)  CS_STRING, "ExpDate" LONGDATE CS_LONGDATE, "MnfDate" LONGDATE CS_LONGDATE, "InDate" LONGDATE CS_LONGDATE, "GrntStart" LONGDATE CS_LONGDATE, "GrntExp" LONGDATE CS_LONGDATE, "CreateDate" LONGDATE CS_LONGDATE, "Location" NVARCHAR(100)  CS_STRING, "Status" CHAR(1) CS_FIXEDSTRING DEFAULT '0', "Notes" NCLOB  MEMORY THRESHOLD 1000  , "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UserSign" SMALLINT CS_INT, "Transfered" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Instance" SMALLINT CS_INT DEFAULT 0, "AbsEntry" INT CS_INT NOT NULL, "ObjType" NVARCHAR(20)  CS_STRING, "itemName" NVARCHAR(100)  CS_STRING, "LogInstanc" INT CS_INT, "UserSign2" SMALLINT CS_INT, "UpdateDate" LONGDATE CS_LONGDATE, "CostTotal" DECIMAL(21,6) CS_FIXED, "Quantity" DECIMAL(21,6) CS_FIXED, "QuantOut" DECIMAL(21,6) CS_FIXED, "PriceDiff" DECIMAL(21,6) CS_FIXED, "Balance" DECIMAL(21,6) CS_FIXED, "TrackingNt" INT CS_INT, "TrackiNtLn" INT CS_INT, "SumDec" SMALLINT CS_INT, PRIMARY KEY ( "AbsEntry" ) ) 