imp_yunwei/直运业务先销后采的...

--直运业务如果得先做采购再做销售，如果先销后采这么改
select a.sourceid,a.poid,a.pono,a.* from salesDtl a where a.poid = '2000878405284927922'
where a.sono = 'SOS04794250012-S2'
where a.poid = '2000878405284927922'

--销售合同
update salesDtl a  set a.pono = 'SOS04794250012-P2'  where a.sono = 'SOS04794250012-S2'
update salesDtl a  set a.sourceid = '2000878405284927922' where a.sono = 'SOS04794250012-S2'
update salesDtl a  set a.poid = '2000878405284927922' where  a.sono = 'SOS04794250012-S2'

select a.id,a.* from purchaseDtl a  where a.pono = 'SOS04794250012-P2'

 ---销售订单
select a.poid,a.pono,a.* from sOrderDtl a where a.sono = 'SOS04794250012-S2'
update sOrderDtl a  set a.pono = 'SOS04794250012-P2' where a.sono = 'SOS04794250012-S2'
update sOrderDtl a  set a.poid = '2000878405284927922' where  a.sono = 'SOS04794250012-S2'

---放货
select  a.poid,a.pono,a.* from delivNotiDtl a where a.sono = 'SOS04794250012-S2'
update delivNotiDtl a  set a.pono = 'SOS04794250012-P2' where a.sono = 'SOS04794250012-S2'
update delivNotiDtl a  set a.poid = '2000878405284927922' where  a.sono = 'SOS04794250012-S2'