SELECT A.FISCAL_YEAR, 'LeaseRev & Fees'Category,left(A.VAR_LEVELS,2) as Division,  A.COMPANY as Company,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_01]+[RPT1_CR_AMT_01])*-1,0) else round(sum([BASE_DB_AMT_01]+[BASE_CR_AMT_01])*-1,0) end) AS Period1,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_02]+[RPT1_CR_AMT_02])*-1,0) else round(sum([BASE_DB_AMT_02]+[BASE_CR_AMT_02])*-1,0) end) AS Period2,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_03]+[RPT1_CR_AMT_03])*-1,0) else round(sum([BASE_DB_AMT_03]+[BASE_CR_AMT_03])*-1,0) end) AS Period3,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_04]+[RPT1_CR_AMT_04])*-1,0) else round(sum([BASE_DB_AMT_04]+[BASE_CR_AMT_04])*-1,0) end) AS Period4,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_05]+[RPT1_CR_AMT_05])*-1,0) else round(sum([BASE_DB_AMT_05]+[BASE_CR_AMT_05])*-1,0) end) AS Period5,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_06]+[RPT1_CR_AMT_06])*-1,0) else round(sum([BASE_DB_AMT_06]+[BASE_CR_AMT_06])*-1,0) end) AS Period6,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_07]+[RPT1_CR_AMT_07])*-1,0) else round(sum([BASE_DB_AMT_07]+[BASE_CR_AMT_07])*-1,0) end) AS Period7,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_08]+[RPT1_CR_AMT_08])*-1,0) else round(sum([BASE_DB_AMT_08]+[BASE_CR_AMT_08])*-1,0) end) AS Period8,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_09]+[RPT1_CR_AMT_09])*-1,0) else round(sum([BASE_DB_AMT_09]+[BASE_CR_AMT_09])*-1,0) end) AS Period9,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_10]+[RPT1_CR_AMT_10])*-1,0) else round(sum([BASE_DB_AMT_10]+[BASE_CR_AMT_10])*-1,0) end) AS Period10,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_11]+[RPT1_CR_AMT_11])*-1,0) else round(sum([BASE_DB_AMT_11]+[BASE_CR_AMT_11])*-1,0) end) AS Period11,
(select case [COMPANY] when 50 then round(sum([RPT1_DB_AMT_12]+[RPT1_CR_AMT_12])*-1,0) else round(sum([BASE_DB_AMT_12]+[BASE_CR_AMT_12])*-1,0) end) AS Period12
FROM [dbo].[CUAMOUNT]  A
WHERE (([FISCAL_YEAR] between @start and @end
	AND( ((A.[ACCT_UNIT]) between '0001' and '1999')  or  ((A.[ACCT_UNIT]) between '6000' and '6999') or ((A.[ACCT_UNIT]) like 'H%') )
	AND ((A.ACCOUNT) between 3000 and 3199)))
	and [AMT_TYPE] = 2
group by A.FISCAL_YEAR, left(A.VAR_LEVELS,2), A.COMPANY