Revision history  [back]

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

enter code here
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'