做GVMS Reimburesment Impor异常的处理

客户发过来的表格会把以前错误的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