Wednesday, April 25, 2007

Payment Corrections

For Agnes:
(Joel's fault)
update payment p set ornumber=concat('0',ornumber+713450,'T') where ornumber between '0079271T' and '0079278T' and payment_date='2007-04-23'
update artran p set docno=concat('0',docno+713450,'T') where docno between '0079271T' and '0079278T' and docdate='2007-04-23'
update payment p set ornumber=concat('0',ornumber-7134500,'T') where ornumber between '7927229T' and '7927342T' and payment_date='2007-04-23'
update artran p set docno=concat('0',docno-7134500,'T') where docno between '7927229T' and '7927342T' and docdate='2007-04-23'

Soc's fault?
change from Wtax to FinalVAT: 64.84 pd_id=1369248, o.r.# 0006202B

No comments: