يوجد مستندات تحويل بنكي حالتها ملغية ولها قيود نظاميه؟

edit

قم باستخدام الاستعلام التالي

 update r set requestType ='Delete',transStatus = 'Retry',reqProcessed=0,debtAgesProcessed=0 from LedgerTransReq r left join EntitySystemEntry e on e.targetId = r.originId

where (e.id is null or e.fileStatus = 'Cancelled') and r.requestType <> 'Delete'

update r set requestType ='Delete',transStatus = 'Retry',reqProcessed=0,debtAgesProcessed=0 from LedgerTransReq r left join EntitySystemEntry e on e.targetId = r.originId

where (e.id is null or e.fileStatus = 'Cancelled') and r.requestType <> 'Delete'