精細(xì)管理 · 敏捷經(jīng)營(yíng) · 快速應(yīng)用
規(guī)范流程 · 提升效益
規(guī)范管理 · 精細(xì)理財(cái)
| 自動(dòng)編號(hào): | 2329 | 產(chǎn)品版本: | U8.52 |
| 產(chǎn)品模塊: | 固定資產(chǎn) | 所屬行業(yè): | 通用 |
| 適用產(chǎn)品: | 8.52 | 關(guān) 鍵 字: | 折舊表二無(wú)累計(jì)折舊數(shù) |
| 問(wèn)題名稱: | 折舊表二無(wú)累計(jì)折舊數(shù) | ||
| 問(wèn)題現(xiàn)象: | 折舊表二無(wú)累計(jì)折舊數(shù) | ||
| 原因分析: | 軟件開發(fā)問(wèn)題 | ||
| 解決方案: | CREATE trigger luofatotal on fa_total for insert,update
as
begin
UPDATE fa_Cards
SET dblTransInDeprTCard = fa_total.dbldeprtotal
FROM fa_cards, fa_total
WHERE (fa_cards.sdeptnum = fa_total.sdeptnum) AND (fa_cards.stypenum = fa_total.stypenum)
end
| ||