背景：现有进销存移除订单后，进入海外仓；而头程中无移除订单进入海外仓内容。因此造成部分数据无分摊逻辑。
需求（新增内容）：
现状流程
1.进销存 Removal Order 创建订单 ,
2.获取后台移除订单详情 removal order
参考：select top 10 * from RB_Report_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL order by id desc
Where [removal-order-type] = Return and [Status] =0
3. 根据 RB_Report_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL.order-id & SKU 创建 备库订单;
4. 所有仓库 增加 SKU
修正流程
1.进销存 Removal Order 创建订单 ,
2.获取后台移除订单详情 removal order
参考：select top 10 * from RB_Report_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL order by id desc
Where [removal-order-type] = Return and [Status] =0
3. 根据 RB_Report_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL.order-id & SKU 创建 备库订单;
4. 进销存创建备库订单包含 按 订单来源渠道 & 海外收货仓库 & 渠道SKU & SKU & 退货数量;
5. 头程 对应 进销存 移除单 (备考订单)，进行 亚马逊FBA订单扣除数量;
6. 头程 对应 进销存 移除单 (备考订单)，进行 海外收货仓库 数量增加.
测试环境：主干1商户
验证场景：
执行服务后移除订单数据将会进入到 调拨运费池管理里面
1、关联头程订单
2、对头程订单的剩余数量进行相应的扣减
如图：
202205061659825540--FBA发海外仓，移除订单
相关SQL条件
--Removal Order订单
select top 10 * from RB_Report_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL where CustomerID = 1 and OrderCode = '202205061659825540'
--DELETE RB_Report_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL where id = 25694
--订单表
SELECT * from RB_OrderInfo where OrderCode = ''
--运费池表
SELECT top 100 * from RB_WareHouse_Inventory_Transfer_Log where CustomerID = 1
SELECT DISTINCT oi.CustomerID,
oi.OrderCode,oi.WareHouseID,
ISNULL(tp.DefaultSupplierID, 0) AS TransportSupplierID
FROM RB_OrderInfo oi (NOLOCK)
LEFT JOIN RB_WareHouse_Inventory_Transfer_Log transferLog WITH (NOLOCK)
ON oi.CustomerID = transferLog.CustomerID
AND oi.OrderCode = transferLog.OrderCode
LEFT JOIN dbo.RB_WareHouse AS wh (NOLOCK)
ON wh.CustomerID = oi.CustomerID
AND oi.WareHouseID = wh.ID
LEFT JOIN dbo.RB_Transport AS tp (NOLOCK)
ON tp.CustomerID = oi.CustomerID
AND oi.TransportID = tp.ID
WHERE oi.IsStockOrder = 1
AND oi.OrderState = 2
AND wh.WareHouseType != 1
AND oi.ShipTime >= '2022-04-30 00:00:00.000'
AND oi.ShipTime < '2022-05-06 17:00:00.000'
AND transferLog.ID IS NULL
UNION
SELECT oi.CustomerID,
oi.OrderCode,oi.WareHouseID,
ISNULL(tp.DefaultSupplierID, 0) AS TransportSupplierID
FROM RB_OrderInfo oi (NOLOCK)
INNER JOIN RB_Order_MultiLegFee mf WITH (NOLOCK)
ON oi.CustomerID = mf.CustomerID
AND oi.OrderCode = mf.OrderCode
LEFT JOIN dbo.RB_WareHouse AS wh (NOLOCK)
ON wh.CustomerID = oi.CustomerID
AND oi.WareHouseID = wh.ID
LEFT JOIN dbo.RB_Transport AS tp (NOLOCK)
ON tp.CustomerID = oi.CustomerID
AND oi.TransportID = tp.ID
WHERE oi.IsStockOrder = 1
AND oi.OrderState = 2
AND wh.WareHouseType != 1
AND mf.IsCalculated = 0
AND mf.UpdateTime >= '2022-04-30 00:00:00.000'
AND mf.UpdateTime < '2022-05-06 17:00:00.000'
--补充进销存移除单头程
UNION
SELECT DISTINCT oi.CustomerID,
oi.OrderCode,oi.WareHouseID,
ISNULL(tp.DefaultSupplierID, 0) AS TransportSupplierID
FROM RB_OrderInfo oi (NOLOCK)
LEFT JOIN RB_WareHouse_Inventory_Transfer_Log transferLog WITH (NOLOCK)
ON oi.CustomerID = transferLog.CustomerID
AND oi.OrderCode = transferLog.OrderCode
LEFT JOIN dbo.RB_Transport AS tp (NOLOCK)
ON tp.CustomerID = oi.CustomerID
AND oi.TransportID = tp.ID
WHERE oi.IsStockOrder = 1
AND oi.OrderState = 2
AND oi.AddTime >= '2022-04-30 00:00:00.000'
AND oi.AddTime < '2022-05-07 17:00:00.000'
AND oi.OrderDescription LIKE '系统通过Removal Order订单%'
AND transferLog.ID IS NULL