3：核心代码部分：

4：获取本地仓库存：
select  SUM(whp.GoodNum) from RB_Product(nolock) p  
LEFT JOIN RB_WareHouse_Product whp WITH ( NOLOCK ) ON whp.SKU = p.SKU
                                                      AND whp.CustomerID = p.CustomerID
                                                      AND whp.WareHouseID = (CASE p.DefaultLocalWarehouse WHEN 0 THEN 5312 WHEN NULL THEN 5312
  ELSE p.DefaultLocalWarehouse END) 
  AND EXISTS (SELECT 1 FROM RB_WareHouse(NOLOCK) WHERE whp.WareHouseID =RB_WareHouse.ID  
   AND whp.CustomerID = RB_WareHouse.CustomerID 
   AND RB_WareHouse.WareHouseType = 1) 
   where p.SKU  in ('2633984','16542204') 

   and p.customerid=1 
   group by p.SKU

5：获取近2个月的平均采购天数
SELECT CASE WHEN a.FirstPutTime IS NULL THEN ''
             ELSE DATEDIFF(DD, a.AddTime, a.FirstPutTime)
        END AS ActualArrivalDays ,
a.sku as sku
FROM RB_Procurement_Detail  a WITH(NOLOCK) 
                                    INNER JOIN @tb_SKUs  tmp
                                   on a.SKU=tmp.Id
                                   where a.CustomerID=@CustomerID  AND a.FirstPutTime IS NOT NULL and  a.AddTime>=@startTime AND a.AddTime<=@endTime  GROUP BY a.SKU, a.AddTime, a.FirstPutTime


6：平均采购天数，向上取整，如果平均天数是1.1 取2，  1.7取2，   1.3也需要向上取整取2

7：涉及任务调度：
AmazonTransferFbaJob-ToFbaExecute
AmazonTransferFbaJob-AllExecute
AmazonFbaNormalStockJob_OrderSourceId