因歷史原因，導入資料時漏寫了一個表施符。導致fa_total的某些字段計算不準往声。出現(xiàn)對賬不平的情況，一定要查清原因戳吝，再針對具體情況寫計算語句浩销，網上很多對賬不平的例子都不能通用。
U8前臺的對賬工具除了計算fa_total表外骨坑，還會合計折舊表撼嗓，卡片明細表等等。
insert into fa_total select FG.sDeptNum as sDeptNum, FG.sTypeNum as sTypeNum, 1, COUNT(CASE WHEN sOrgDisposeID NOT LIKE '2%' OR sOrgDisposeID IS NULL THEN FF.sCardNum END) as lMonthCount,COUNT(CASE WHEN sOrgDisposeID NOT LIKE '2%' OR sOrgDisposeID IS NULL THEN FF.sCardNum END) aslCount ,sum(case when (FG.sOrgDisposeID NOT like '2%' OR FG.sOrgDisposeID IS NULL) then FF.dblPeriodValue else 0 end ) as dblYearValue,sum(dblPeriodDeprTotal) as dblYearDeprTotal,sum(CASE WHEN FF.dblDepr0 <> 0 AND (FG.sOrgDisposeID NOT like '2%' OR sOrgDisposeID IS NULL) THEN (FF.dblMonthValue) ELSE 0 END) as dblLastAccrualValue, sum(CASE WHEN FG.sOrgDisposeID NOT like '2%' OR sOrgDisposeID IS NULL THEN dbldepr0 ELSE 0 END) as dblLastDepr,sum(case when (FG.sOrgDisposeID NOT like '2%' OR sOrgDisposeID IS NULL) and FG.dStartdate >= '2016-12-1' and FG.dStartdate <= '2016-12-31' then FF.dblMonthValue1 else 0 end ) as dblLastAddValue,sum(case when FG.sOrgDisposeID like '2%' and ((FG.dTransDate >= '2016-12-1' and FG.dTransDate <= '2016-12-31') or (FG.dDisposeDate >= '2016-12-1' and FG.dDisposeDate <= '2016-12-31')) then dblValue else 0 end) as dblLastDecValue,0,0,0,0,ISNULL(sum(dblMonthValue1),0) as dblMonthValue,sum(FF.dblMonthValue1) as dblValue,ISNULL(sum(dblMonthDeprTotal),0) as dblMonthDeprTotal,ISNULL(sum(dblDeprT1),0) as dblDeprTotal,0,0 ,0 ,0,0,0 ,2017
from TempCardid580 FH left join fa_Cards FG on FH.sCardID = FG.sCardID INNER JOIN fa_DeprTransactions FF ON FF.sCardNum = FH.sCardNum
where FG.sCardNum in (select FG.sCardNum from TempCardid580)
group by FG.sDeptNum,FG.sTypeNum,FF.iyear
order by FG.sDeptNum```