Monday, April 16, 2007

Payment Correction

for Agnes: (Anna Romina Yalung's receipts)

update payment p set ornumber=CONCAT('0',ORNUMBER+30000,'T') where ornumber between '0738433T' and '0738609T' and payment_date='2007-04-03';
update artran p set docno=CONCAT('0',docno+30000,'T') where docno between '0738433T' and '0738609T' and docdate='2007-04-03';

No comments: