| 解决方案： |
--下面4条语句显示的数字为01331卡片的累计折旧，都手工－0.01
select dbltransindeprtcard from fa_cards where scardnum='01331'
select dbltransindeprtcard from fa_cards_detail where scardnum='01331'
select dblInputdeprtotal,dblMonthdeprtotal,dblDeprT6,dblDeprT7,dblDeprT8,
dblDeprT9,dblDeprT10,dblDeprT11,dblDeprT12 from fa_DeprTransactions where scardnum='01331'
select dblDeprT6,dblDeprT7,dblDeprT8,dblDeprT9,dblDeprT10,dblDeprT11,dblDeprT12 from fa_DeprTransactions_detail where scardnum='01331'
--下面语句显示的FA_TOTAL表该类别，该部门的累计折旧合计，分别－0.01。合计0的不要改
select dblYearDeprTotal,dblMonthDeprTotal,dblDeprTotal FROM fa_Total
WHERE sTypeNum = '0315' AND sDeptNum = '02012'
select dbltransindeprtcard from fa_cards where scardnum='01331'
select dbltransindeprtcard from fa_cards_detail where scardnum='01331'
select dblInputdeprtotal,dblMonthdeprtotal,dblDeprT6,dblDeprT7,dblDeprT8,
dblDeprT9,dblDeprT10,dblDeprT11,dblDeprT12 from fa_DeprTransactions where scardnum='01331'
select dblDeprT6,dblDeprT7,dblDeprT8,
dblDeprT9,dblDeprT10,dblDeprT11,dblDeprT12 from fa_DeprTransactions_detail where scardnum='01331'
--下面语句显示的FA_TOTAL表该类别，该部门的累计折旧合计，分别－0.01。合计0的不要改
select dblYearDeprTotal,dblMonthDeprTotal,dblDeprTotal
FROM fa_Total
WHERE sTypeNum = '0315' AND sDeptNum = '02012' |