一订单已经出货,状态为CLOSED,但是却发现salesperson写错了,改成正确的过程如下:
(1)从数据库中找到正确的SALESPERSON的ID
select SALESREP_ID
from oe_order_headers_all
where order_number = 2907000301
/*2907000301为该SALESPERSON的ID */
(2)修改ID
update oe_order_headers_all
set salesrep_id = 100000041
where order_number = 2907000147
[@more@]一订单已经出货,状态为CLOSED,但是却发现salesperson写错了,改成正确的过程如下:
(1)从数据库中找到正确的SALESPERSON的ID
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/729410/viewspace-905946/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/729410/viewspace-905946/