-- 保单
SELECT OrgID,BusinessManID,BusinessInternal,ChannelID,ChannelBrand,EntryTime from BOIPMain 
where OrgID = 'G5003006' AND SigningDate >= '2019-01-01' and SigningDate <= '2019-08-31'

UPDATE BOIPMain SET BusinessManID = 'U5000525' , BusinessInternal = 'U5000525', OrgID = 'G5003004', ChannelID = 'N0000005', ChannelBrand = 'A1000002' WHERE OrgID = 'G5003006' AND SigningDate >= '2019-01-01' and SigningDate <= '2019-08-31'

-- 结算单
SELECT OrgID,BusinessManID,BusinessInternal,ChannelBrand,ChannelID,* FROM BOExpenseSettlement 
where	OrgID = 'G5003006' AND EntryTime >= '2019-01-01' and EntryTime <= '2019-08-31'

UPDATE BOExpenseSettlement SET BusinessManID = 'U5000525' , BusinessInternal = 'U5000525', OrgID = 'G5003004', ChannelID = 'N0000005', ChannelBrand = 'A1000002' WHERE OrgID = 'G5003006' AND SigningDate >= '2019-01-01' and SigningDate <= '2019-08-31'
 
-- 投保单
SELECT OrgID,BusinessManID,BusinessInternal,ChannelBrand,ChannelID,* FROM BOIQApplication 
where OrgID = 'G5003006' AND EntryTime >= '2019-01-01' and EntryTime <= '2019-08-31'	

UPDATE BOIQApplication SET BusinessManID = 'U5000525' , BusinessInternal = 'U5000525', OrgID = 'G5003004', ChannelID = 'N0000005', ChannelBrand = 'A1000002' WHERE OrgID = 'G5003006' AND EntryTime >= '2019-01-01' and EntryTime <= '2019-08-31'

-- 保单费用结算
SELECT OrgID,BusinessManID,ChannelBrand,ChannelID,* from BONewExpenseSettlement 
where OrgID = 'G5003006' AND EntryTime >= '2019-01-01' and EntryTime <= '2019-08-31'

UPDATE BONewExpenseSettlement SET BusinessManID = 'U5000525' , OrgID = 'G5003004', ChannelID = 'N0000005', ChannelBrand = 'A1000002' WHERE OrgID = 'G5003006' AND SigningDate >= '2019-01-01' and SigningDate <= '2019-08-31'