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

–查询内码

select * from t_department where Fname like ‘%兰州分公司%’

–select Fdeptid,* from seorder where Fbillno like ‘%gxl140717038%’

–订单

update seorder set Fdeptid=8195 where Fbillno= ‘seord140717038’

–发货通知

–select Fdeptid,* from SEOutStock where Fbillno=‘seout007284’

update SEOutStock set Fdeptid=8195 where Fbillno=‘seout007284’

–销售出库

–select Fdeptid,* from icstockbill where Fbillno=‘xout006929’

update icstockbill set Fdeptid=8195 where Fbillno=‘xout006929’

–销售发票

–select Fdeptid,* from icsale where Fbillno=‘07222596’

update icsale set Fdeptid=8195 where Fbillno=‘072229596’

update t_RP_Contact set Fdepartment=8195 where Fnumber=‘072229596’