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’