Saturday, April 14, 2007

O.R.# correction etc

Soc told me Mang Efren repeated a batch of O.R.#'s which he'd already issued on 04/11:

update payment set ornumber=concat('00',ornumber+13,'B') where ornumber between '0052871B' and '0052882B' and payment_date='2007-04-12'

update artran set docno=concat('00',docno+13,'B') where docno between '0052871B' and '0052882B' and docdate='2007-04-12'

Subtracted Php10,000 from O.R.# 0053178B.


For Agnes:
Inserted details for a cancelled O.R.:

insert into payment_details values (null,1334289,1732418,20,9.78,0,0,0,0,NULL,NULL,NULL,20070402171034,"",NULL,2047610,'2007-02-19',NULL,NULL,0,0,864405,3)

Changed O.R.# from 9743626T to 0743626T.

No comments: