客户发过来的表格会把以前错误的reimburesment信息一起发过来,我们手动修改
例如这次在检查完第一步之后出现一条有问题的信息这个以前reimburesment过
------------------------------------------------
439533320OCBC 007685Pod Life Pte Ltd 2013-08-05PODLIP1 12-0145 SD 5333A 1406
------------------------------------------------
在voucher_store_submission里查找submission_id为5333的数据
------------------------------------------------
53332012-11-27 16:37:36240001505330'10144129','10145777','505819','505821'NNULL
------------------------------------------------
找到requisition_id为5330
然后在voucher_purchase_requisition里找到requisition_id为5330的数据
------------------------------------------------
53302012-11-27 16:37:4015043405333
------------------------------------------------
找到reimburse_id 为4340
然后在voucher_reimburse里找到reimburse_id 为4340的数据
------------------------------------------------
43402012-12-21 23:59:5910OCBC0075792012-12-21 00:00:00NULLVenderNumber:PODLIP1 BatchNumber:12-0111 InvoiceNumber:SD 5333
------------------------------------------------
把cheque_no改为OCBC 007685 ,batch_number改为 12-0145