update LedgerJournalTrans set Voucher = 'GL_JV-000003645' where Voucher = 'GL_JV-000003640'

delete from crt.TABLEREPLICATIONLOG delete from crt.UPLOADSESSION

update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052141'update RetailTransactionTable SET entryStatus= '0' where RECEIPTID = '010102300420052142'update RetailTransactionTable SET entryStatus= '0' where REC

update ProdTable set ProdStatus ='5' where ProdId = 'PRO-005523'

SELECT T1.ACCOUNTINGDATE, T1.SUBLEDGERVOUCHER, T3.JOURNALNUMBER, T2.LEDGERACCOUNT, T2.TRANSACTIONCURRENCYAMOUNT AS [Amount in Cuuency], T2.ACCOUNTINGCURRENCYAMOUNT AS [amount in sar], T2.TRANSACTIONCURRENCYCODE AS Currency, T2.TEXT AS Description