SELECT TOP 45 T1._idrref, 
              T1._marked, 
              T1._number, 
              T1._date_time, 
              T1._posted
FROM
	dbo._document231 T1 WITH(nolock) 
		LEFT OUTER JOIN 
		(
		SELECT 
			T4.fld12108_type  AS Fld12108_TYPE, 
            T4.fld12108_rtref AS Fld12108_RTRef, 
            T4.fld12108_rrref  AS Fld12108_RRRef 
            Cast(Sum(T4.fld12112receipt_) AS NUMERIC(27, 2)) AS Fld12112Receipt_,
			Cast(Sum(T4.fld12112expense_) AS NUMERIC(27, 2)) AS Fld12112Expense_
		FROM
			dbo._accumrg12106 T4 WITH(nolock)
		GROUP BY
			T4.fld12108_type,
            T4.fld12108_rtref,
            T4.fld12108_rrref
		) T3 ON 
			( 0x08 = T3.fld12108_type 
				AND 0x000000E7 = T3.fld12108_rtref 
				AND T1._idrref = T3.fld12108_rrref )  

OBJECT:([TGNUT11].[dbo].[_AccumRg12106].[_AccumRg12106_ByDims12120_RTRN] AS [T5]), 
SEEK:(
[T5].[_Fld601]=[@P82] AND -- в этой базе всегда 0 (ноль)
[T5].[_Fld12108_TYPE]=0x08 AND 
[T5].[_Fld12108_RTRef]=0x000000E7 AND 
[T5].[_Fld12108_RRRef]=[TGNUT11].[dbo].[_Document231].[_IDRRef] as [T1].[_IDRRef]
) ORDERED FORWARD 

LEFT OUTER JOIN 
		(
		SELECT 

[T5].[_Fld12108_RRRef]=[TGNUT11].[dbo].[_Document231].[_IDRRef] as [T1].[_IDRRef]