K3后台修改销售模块（销售订单 发货通知单 销售出库单 销售发票）业务员名称语句

select fitemid,* from t_emp where fname='张三'--通过姓名查找业务员内码

------如下语句为更改销售发票数据---------------------------------------------------------------------------------------------------------------

select top 2 * from ICSale where Fbillno='139513468'

update ICSale set fempid='159508' where Fbillno='139513468'

------如下语句为更改销售出库数据---------------------------------------------------------------------------------------------------------------

select * from icstockbill where Fbillno='XOUT012621'

update icstockbill set fempid='159508' where Fbillno='XOUT012621'

------如下语句为更改发货通知单数据-------------------------------------------------------------------------------------------

select * from SEOutStock where fbillno='SEOUT012758'

update SEOutStock set fempid='159508' where fbillno='SEOUT012758'

--------如下语句为更改销售订单数据----------------------------------------------------------------------------------------------

select * from seorder where fbillno='MH150908107'

update seorder set fempid='159508' where fbillno='SEORD16101801'