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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment