|
发表于 2009-4-12 10:38:18
|
显示全部楼层
'--下面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') |
|