發(fā)布時(shí)間:2024-11-18
銀行對(duì)賬單管理節(jié)點(diǎn),導(dǎo)入的時(shí)候是按照天覆蓋的,數(shù)據(jù)刪除只能通過(guò)數(shù)據(jù)庫(kù)刪除,前臺(tái)不能刪。
參照腳本:
--備份表 create table ebank_dzd20180603 as select * from ebank_dzd;
--刪除語(yǔ)句 delete from ebank_dzd where curacc='賬號(hào)' and TRANS_DATE>'開(kāi)始時(shí)間%' and TRANS_DATE<'結(jié)束時(shí)間%';
commit;
--舉例如下 :
delete from ebank_dzd where curacc='0200000319201946502' and TRANS_DATE>'2017-02-01%' and TRANS_DATE<'2017-02-28%';
commit;
客服電話:400-665-0028
關(guān)鍵字:用友財(cái)務(wù)軟件,暢捷通軟件,財(cái)務(wù)軟件,進(jìn)銷存軟件,U9官網(wǎng),用友U8,用友T1,用友T+,用友T3,用友T6,暢捷通好會(huì)計(jì),好生意,智+好業(yè)財(cái),用友培訓(xùn)服務(wù)售后公司,暢捷通運(yùn)營(yíng)培訓(xùn)服務(wù)公司
版權(quán)所有:用友暢捷通軟件 Copyright © 2024 All rights reserved.