CREATE GLOBAL TEMPORARY ROW TABLE "SBODEMODE"."TmpPsar_Sales_An_Itm_Sng_Y_LC"  ( "DOCENTRY" NVARCHAR(20)  CS_STRING, "DOCNUM" NVARCHAR(20)  CS_STRING, "SLPCODE" NVARCHAR(20)  CS_STRING, "SLPNAME" NVARCHAR(155)  CS_STRING, "CARDCODE" NVARCHAR(20)  CS_STRING, "CARDNAME" NVARCHAR(200)  CS_STRING, "DOCDATE" LONGDATE CS_LONGDATE, "DOCDUEDATE" LONGDATE CS_LONGDATE, "ITEMCODE" NVARCHAR(50)  CS_STRING, "ITEMNAME" NVARCHAR(200)  CS_STRING, "QUANTITY" DECIMAL(21,6) CS_FIXED, "PRICE" DECIMAL(21,6) CS_FIXED, "SALES" DECIMAL(21,6) CS_FIXED, "GROSSPROFIT" DECIMAL(21,6) CS_FIXED, "GROSSPRCNT" DECIMAL(21,6) CS_FIXED, "PRICESYS" DECIMAL(21,6) CS_FIXED, "SALESSYS" DECIMAL(21,6) CS_FIXED, "GROSSPROFITSYS" DECIMAL(21,6) CS_FIXED, "GROSSPRCNTSYS" DECIMAL(21,6) CS_FIXED, "LINENUM" INT CS_INT, "SALESFORPRCNT" DECIMAL(21,6) CS_FIXED, "SALESFORPRCNTSYS" DECIMAL(21,6) CS_FIXED )  ON COMMIT PRESERVE ROWS 