CREATE GLOBAL TEMPORARY ROW TABLE "SBODEMODE"."TMP_IVSR_SupInterReq_TotalLcZeroPQNotZero"  ( "MessageID" INT CS_INT NOT NULL, "DocEntry" INT CS_INT, "TransType" INT CS_INT, "DocLineNum" SMALLINT CS_INT, "Quantity" DECIMAL(21,6) CS_FIXED, "EffectQty" DECIMAL(21,6) CS_FIXED, "LocType" SMALLINT CS_INT, "LocCode" NVARCHAR(8)  CS_STRING, "TotalLC" DECIMAL(21,6) CS_FIXED, "TotalFC" DECIMAL(21,6) CS_FIXED, "TotalSC" DECIMAL(21,6) CS_FIXED, "BaseAbsEnt" INT CS_INT, "BaseType" INT CS_INT, "BaseCurr" NVARCHAR(3)  CS_STRING, "Currency" NVARCHAR(3)  CS_STRING, "AccumType" INT CS_INT, "ActionType" INT CS_INT, "ExpensesLC" DECIMAL(21,6) CS_FIXED, "ExpensesFC" DECIMAL(21,6) CS_FIXED, "ExpensesSC" DECIMAL(21,6) CS_FIXED, "DocDueDate" LONGDATE CS_LONGDATE, "ItemCode" NVARCHAR(50)  CS_STRING, "BPCardCode" NVARCHAR(15)  CS_STRING, "DocDate" LONGDATE CS_LONGDATE, "DocRate" DECIMAL(21,6) CS_FIXED, "Comment" NVARCHAR(254)  CS_STRING, "JrnlMemo" NVARCHAR(50)  CS_STRING, "Ref1" NVARCHAR(11)  CS_STRING, "Ref2" NVARCHAR(11)  CS_STRING, "BaseLine" SMALLINT CS_INT, "SnBType" INT CS_INT, "CreateTime" SMALLINT CS_INT, "DataSource" NVARCHAR  CS_STRING, "CreateDate" LONGDATE CS_LONGDATE, "OcrCode" NVARCHAR(8)  CS_STRING, "OcrCode2" NVARCHAR(8)  CS_STRING, "OcrCode3" NVARCHAR(8)  CS_STRING, "OcrCode4" NVARCHAR(8)  CS_STRING, "OcrCode5" NVARCHAR(8)  CS_STRING, "DocPrice" DECIMAL(21,6) CS_FIXED, "CardName" NVARCHAR(200)  CS_STRING, "Dscription" NVARCHAR(100)  CS_STRING, "TreeType" NVARCHAR  CS_STRING, "ApplObj" INT CS_INT, "AppObjAbs" INT CS_INT, "AppObjType" NVARCHAR  CS_STRING, "AppObjLine" SMALLINT CS_INT, "BASE_REF" NVARCHAR(11)  CS_STRING, "TransSeqRf" INT CS_INT, "LayerIDRef" INT CS_INT, "VersionNum" NVARCHAR(13)  CS_STRING, "PriceRate" DECIMAL(21,6) CS_FIXED, "PriceCurr" NVARCHAR(3)  CS_STRING, "DocTotal" DECIMAL(21,6) CS_FIXED, "Price" DECIMAL(21,6) CS_FIXED, "CIShbQty" DECIMAL(21,6) CS_FIXED, "SubLineNum" INT CS_INT, "PrjCode" NVARCHAR(20)  CS_STRING, "SlpCode" SMALLINT CS_INT, "TaxDate" LONGDATE CS_LONGDATE, "UseDocPric" NVARCHAR  CS_STRING, "VendorNum" NVARCHAR(17)  CS_STRING, "SerialNum" NVARCHAR(17)  CS_STRING, "BlockNum" NVARCHAR(100)  CS_STRING, "ImportLog" NVARCHAR(20)  CS_STRING, "Location" INT CS_INT, "DocPrcRate" DECIMAL(21,6) CS_FIXED, "DocPrcCurr" NVARCHAR(3)  CS_STRING, "CgsOcrCod" NVARCHAR(8)  CS_STRING, "CgsOcrCod2" NVARCHAR(8)  CS_STRING, "CgsOcrCod3" NVARCHAR(8)  CS_STRING, "CgsOcrCod4" NVARCHAR(8)  CS_STRING, "CgsOcrCod5" NVARCHAR(8)  CS_STRING, "BSubLineNo" INT CS_INT, "AppSubLine" INT CS_INT, "UserSign" SMALLINT CS_INT, "SysRate" DECIMAL(21,6) CS_FIXED, "ExFromRpt" NVARCHAR  CS_STRING, "Ref3" NVARCHAR(11)  CS_STRING, "EnSetCost" NVARCHAR  CS_STRING, "RetCost" DECIMAL(21,6) CS_FIXED, "DocAction" INT CS_INT, "UseShpdGd" NVARCHAR  CS_STRING, "AddTotalLC" DECIMAL(21,6) CS_FIXED, "AddExpLC" DECIMAL(21,6) CS_FIXED, "IsNegLnQty" NVARCHAR  CS_STRING, "StgSeqNum" INT CS_INT, "StgEntry" INT CS_INT, "StgDesc" NVARCHAR(100)  CS_STRING )  ON COMMIT PRESERVE ROWS 