任务描述

参考SQL:

SELECT
t2.OrderSourceName '订单来源渠道',t2.OrderSourceCountry '市场',
t3.DepartmentName '部门', bt.BusinessTeamName '小组',t2.SaleAdminName '销售',vtb.OrderSourceSKU '渠道SKU', tt.ASIN 'ASIN'
, case
vtb.OnShelfMode
when 1 then '一键上架'
when 2 then '草稿上架'
when 3 then '表格上架'
when 4 then '关联导入'
when 5 then '批量跟卖'
when 6 then '凤凰重刊'
end '刊登方式',
vtb.AddTime 'listing刊登时间',
t1.AddTime '首次备货时间',
t1.OrderCode '备库订单号'
FROM (
SELECT os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) AS ASIN,MIN(oi.ID) oiId,min(vtba.OrderSourceSKUID) OrderSourceSKUID
FROM dbo.RB_OrderInfo oi (NOLOCK)
INNER JOIN RB_OrderInfo_BeikuExpand ep (NOLOCK)
ON oi.CustomerID = ep.CustomerID
AND oi.OrderCode = ep.OrderCode
INNER JOIN dbo.RB_OrderList ol (nolock) ON ol.CustomerID=oi.CustomerID
AND ol.OrderCode=oi.OrderCode
LEFT OUTER JOIN RB_OrderSource (NOLOCK) os
ON oi.OrderSourceID = os.ID
AND oi.CustomerID = os.CustomerID
LEFT OUTER JOIN RB_Transport (NOLOCK) ts
ON oi.TransportID = ts.ID
AND oi.CustomerID = ts.CustomerID
LEFT JOIN dbo.RB_WareHouse (NOLOCK) wh
ON oi.CustomerID = wh.CustomerID
AND oi.WareHouseID = wh.ID
LEFT JOIN dbo.RB_WareHouse (NOLOCK) towh
ON oi.CustomerID = towh.CustomerID
AND oi.ToWareHouseID = towh.ID
LEFT JOIN RB_OrderInfo_Beiku (NOLOCK) beiku
ON beiku.CustomerID = oi.CustomerID
AND beiku.OrderCode = oi.OrderCode
LEFT JOIN RB_OrderInfo_BeikuExpand (NOLOCK) epo
ON epo.TransitOrderCode = oi.OrderCode
AND epo.CustomerID = oi.CustomerID
LEFT JOIN RB_RestockOrder_ApprovalExecutor (NOLOCK) ae
ON ae.CustomerId = oi.CustomerID
AND ae.OrderCode = oi.OrderCode
INNER JOIN RB_FBA_ShipmentInfo (NOLOCK) fbasi
ON oi.CustomerID = fbasi.CustomerID
AND fbasi.OrderSourceID = oi.OrderSourceID
AND oi.AmazonShipmentId = fbasi.ShipmentId
INNER JOIN dbo.RB_Amazon_Product_Base vtba (NOLOCK) ON vtba.CustomerID=oi.CustomerID
AND vtba.OrderSourceID =oi.OrderSourceID AND vtba.OrderSourceSKU = ol.SellerSKU
WHERE oi.CustomerID = 1
AND oi.IsStockOrder = 1
AND os.OrderSourceType = 1
AND towh.WareHouseType = 3
AND ep.OrderBuildType = 1
AND oi.IsSystem = 0
GROUP BY os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) )TT
INNER JOIN RB_OrderInfo t1 (nolock) ON t1.ID=tt.oiId
INNER JOIN dbo.RB_Amazon_Product_Base vtb (NOLOCK) ON vtb.OrderSourceSKUID=TT.OrderSourceSKUID
INNER JOIN dbo.RB_OrderSource t2 (nolock) ON t2.ID=vtb.OrderSourceID
LEFT JOIN RB_Admin rba WITH (NOLOCK)
ON rba.CustomerID = t2.CustomerID
AND rba.ID = t2.SaleAdminID
LEFT JOIN RB_BusinessTeam bt WITH (NOLOCK)
ON bt.CustomerID = t2.CustomerID
AND bt.ID = rba.BusinessTeamID
LEFT JOIN dbo.RB_Department t3 (nolock) ON t3.ID=rba.DepartmentID
WHERE vtb.OrderSourceSKUID>0

历史记录  
  1. 2022-08-31 09:22:53, 由 罗友军 创建。
  2. 2022-08-31 09:23:39, 由 罗友军 编辑。
    修改了 最初预计，旧值为 "0"，新值为 "6"。
    修改了 预计剩余，旧值为 "0"，新值为 "6"。
    修改了 任务描述，区别为：
    001- <img src="/zentao/file-read-213159.png" alt="" />
    001+
    002- <img src="/zentao/file-read-213160.png" alt="" />
    002+
    004- SELECTt2.OrderSourceName '订单来源渠道',t2.OrderSourceCountry '市场',t3.DepartmentName '部门', bt.BusinessTeamName '小组',t2.SaleAdminName '销售',vtb.OrderSourceSKU '渠道SKU', tt.ASIN 'ASIN', casevtb.OnShelfModewhen 1 then '一键上架'when 2 then '草稿上架'when 3 then '表格上架'when 4 then '关联导入'when 5 then '批量跟卖'when 6 then '凤凰重刊'end '刊登方式',vtb.AddTime 'listing刊登时间',t1.AddTime '首次备货时间',t1.OrderCode '备库订单号'FROM (SELECT os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) AS ASIN,MIN(oi.ID) oiId,min(vtba.OrderSourceSKUID) OrderSourceSKUIDFROM dbo.RB_OrderInfo oi (NOLOCK)INNER JOIN RB_OrderInfo_BeikuExpand ep (NOLOCK)ON oi.CustomerID = ep.CustomerIDAND oi.OrderCode = ep.OrderCodeINNER JOIN dbo.RB_OrderList ol (nolock) ON ol.CustomerID=oi.CustomerIDAND ol.OrderCode=oi.OrderCodeLEFT OUTER JOIN RB_OrderSource (NOLOCK) osON oi.OrderSourceID = os.IDAND oi.CustomerID = os.CustomerIDLEFT OUTER JOIN RB_Transport (NOLOCK) tsON oi.TransportID = ts.IDAND oi.CustomerID = ts.CustomerIDLEFT JOIN dbo.RB_WareHouse (NOLOCK) whON oi.CustomerID = wh.CustomerIDAND oi.WareHouseID = wh.IDLEFT JOIN dbo.RB_WareHouse (NOLOCK) towhON oi.CustomerID = towh.CustomerIDAND oi.ToWareHouseID = towh.IDLEFT JOIN RB_OrderInfo_Beiku (NOLOCK) beikuON beiku.CustomerID = oi.CustomerIDAND beiku.OrderCode = oi.OrderCodeLEFT JOIN RB_OrderInfo_BeikuExpand (NOLOCK) epoON epo.TransitOrderCode = oi.OrderCodeAND epo.CustomerID = oi.CustomerIDLEFT JOIN RB_RestockOrder_ApprovalExecutor (NOLOCK) aeON ae.CustomerId = oi.CustomerIDAND ae.OrderCode = oi.OrderCodeINNER JOIN RB_FBA_ShipmentInfo (NOLOCK) fbasiON oi.CustomerID = fbasi.CustomerIDAND fbasi.OrderSourceID = oi.OrderSourceIDAND oi.AmazonShipmentId = fbasi.ShipmentIdINNER JOIN dbo.RB_Amazon_Product_Base vtba (NOLOCK) ON vtba.CustomerID=oi.CustomerIDAND vtba.OrderSourceID =oi.OrderSourceID AND vtba.OrderSourceSKU = ol.SellerSKUWHERE oi.CustomerID = 1AND oi.IsStockOrder = 1AND os.OrderSourceType = 1AND towh.WareHouseType = 3AND ep.OrderBuildType = 1AND oi.IsSystem = 0GROUP BY os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) )TTINNER JOIN RB_OrderInfo t1 (nolock) ON t1.ID=tt.oiIdINNER JOIN dbo.RB_Amazon_Product_Base vtb (NOLOCK) ON vtb.OrderSourceSKUID=TT.OrderSourceSKUIDINNER JOIN dbo.RB_OrderSource t2 (nolock) ON t2.ID=vtb.OrderSourceIDLEFT JOIN RB_Admin rba WITH (NOLOCK)ON rba.CustomerID = t2.CustomerIDAND rba.ID = t2.SaleAdminIDLEFT JOIN RB_BusinessTeam bt WITH (NOLOCK)ON bt.CustomerID = t2.CustomerIDAND bt.ID = rba.BusinessTeamIDLEFT JOIN dbo.RB_Department t3 (nolock) ON t3.ID=rba.DepartmentIDWHERE vtb.OrderSourceSKUID&gt;0
    004+ SELECTt2.OrderSourceName '订单来源渠道',t2.OrderSourceCountry '市场',t3.DepartmentName '部门', bt.BusinessTeamName '小组',t2.SaleAdminName '销售',vtb.OrderSourceSKU '渠道SKU', tt.ASIN 'ASIN', casevtb.OnShelfModewhen 1 then '一键上架'when 2 then '草稿上架'when 3 then '表格上架'when 4 then '关联导入'when 5 then '批量跟卖'when 6 then '凤凰重刊'end '刊登方式',vtb.AddTime 'listing刊登时间',t1.AddTime '首次备货时间',t1.OrderCode '备库订单号'FROM (SELECT os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) AS ASIN,MIN(oi.ID) oiId,min(vtba.OrderSourceSKUID) OrderSourceSKUIDFROM dbo.RB_OrderInfo oi (NOLOCK)INNER JOIN RB_OrderInfo_BeikuExpand ep (NOLOCK)ON oi.CustomerID = ep.CustomerIDAND oi.OrderCode = ep.OrderCodeINNER JOIN dbo.RB_OrderList ol (nolock) ON ol.CustomerID=oi.CustomerIDAND ol.OrderCode=oi.OrderCodeLEFT OUTER JOIN RB_OrderSource (NOLOCK) osON oi.OrderSourceID = os.IDAND oi.CustomerID = os.CustomerIDLEFT OUTER JOIN RB_Transport (NOLOCK) tsON oi.TransportID = ts.IDAND oi.CustomerID = ts.CustomerIDLEFT JOIN dbo.RB_WareHouse (NOLOCK) whON oi.CustomerID = wh.CustomerIDAND oi.WareHouseID = wh.IDLEFT JOIN dbo.RB_WareHouse (NOLOCK) towhON oi.CustomerID = towh.CustomerIDAND oi.ToWareHouseID = towh.IDLEFT JOIN RB_OrderInfo_Beiku (NOLOCK) beikuON beiku.CustomerID = oi.CustomerIDAND beiku.OrderCode = oi.OrderCodeLEFT JOIN RB_OrderInfo_BeikuExpand (NOLOCK) epoON epo.TransitOrderCode = oi.OrderCodeAND epo.CustomerID = oi.CustomerIDLEFT JOIN RB_RestockOrder_ApprovalExecutor (NOLOCK) aeON ae.CustomerId = oi.CustomerIDAND ae.OrderCode = oi.OrderCodeINNER JOIN RB_FBA_ShipmentInfo (NOLOCK) fbasiON oi.CustomerID = fbasi.CustomerIDAND fbasi.OrderSourceID = oi.OrderSourceIDAND oi.AmazonShipmentId = fbasi.ShipmentIdINNER JOIN dbo.RB_Amazon_Product_Base vtba (NOLOCK) ON vtba.CustomerID=oi.CustomerIDAND vtba.OrderSourceID =oi.OrderSourceID AND vtba.OrderSourceSKU = ol.SellerSKUWHERE oi.CustomerID = 1AND oi.IsStockOrder = 1AND os.OrderSourceType = 1AND towh.WareHouseType = 3AND ep.OrderBuildType = 1AND oi.IsSystem = 0GROUP BY os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) )TTINNER JOIN RB_OrderInfo t1 (nolock) ON t1.ID=tt.oiIdINNER JOIN dbo.RB_Amazon_Product_Base vtb (NOLOCK) ON vtb.OrderSourceSKUID=TT.OrderSourceSKUIDINNER JOIN dbo.RB_OrderSource t2 (nolock) ON t2.ID=vtb.OrderSourceIDLEFT JOIN RB_Admin rba WITH (NOLOCK)ON rba.CustomerID = t2.CustomerIDAND rba.ID = t2.SaleAdminIDLEFT JOIN RB_BusinessTeam bt WITH (NOLOCK)ON bt.CustomerID = t2.CustomerIDAND bt.ID = rba.BusinessTeamIDLEFT JOIN dbo.RB_Department t3 (nolock) ON t3.ID=rba.DepartmentIDWHERE vtb.OrderSourceSKUID&gt;0
    001- <p><img src="/zentao/file-read-213159.png" alt="" /></p>
    001+ <p><img src="{213159.png}" alt="" /></p>
    002- <p><img src="/zentao/file-read-213160.png" alt="" /></p>
    002+ <p><img src="{213160.png}" alt="" /></p>
    004- <p>SELECT<br />t2.OrderSourceName '订单来源渠道',t2.OrderSourceCountry '市场',<br />t3.DepartmentName '部门', bt.BusinessTeamName '小组',t2.SaleAdminName '销售',vtb.OrderSourceSKU '渠道SKU', tt.ASIN 'ASIN'<br />, case<br />vtb.OnShelfMode<br />when 1 then '一键上架'<br />when 2 then '草稿上架'<br />when 3 then '表格上架'<br />when 4 then '关联导入'<br />when 5 then '批量跟卖'<br />when 6 then '凤凰重刊'<br />end '刊登方式',<br />vtb.AddTime 'listing刊登时间',<br />t1.AddTime '首次备货时间',<br />t1.OrderCode '备库订单号'<br />FROM (<br />SELECT os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) AS ASIN,MIN(oi.ID) oiId,min(vtba.OrderSourceSKUID) OrderSourceSKUID<br />FROM dbo.RB_OrderInfo oi (NOLOCK)<br />INNER JOIN RB_OrderInfo_BeikuExpand ep (NOLOCK)<br />ON oi.CustomerID = ep.CustomerID<br />AND oi.OrderCode = ep.OrderCode<br />INNER JOIN dbo.RB_OrderList ol (nolock) ON ol.CustomerID=oi.CustomerID<br />AND ol.OrderCode=oi.OrderCode<br />LEFT OUTER JOIN RB_OrderSource (NOLOCK) os<br />ON oi.OrderSourceID = os.ID<br />AND oi.CustomerID = os.CustomerID<br />LEFT OUTER JOIN RB_Transport (NOLOCK) ts<br />ON oi.TransportID = ts.ID<br />AND oi.CustomerID = ts.CustomerID<br />LEFT JOIN dbo.RB_WareHouse (NOLOCK) wh<br />ON oi.CustomerID = wh.CustomerID<br />AND oi.WareHouseID = wh.ID<br />LEFT JOIN dbo.RB_WareHouse (NOLOCK) towh<br />ON oi.CustomerID = towh.CustomerID<br />AND oi.ToWareHouseID = towh.ID<br />LEFT JOIN RB_OrderInfo_Beiku (NOLOCK) beiku<br />ON beiku.CustomerID = oi.CustomerID<br />AND beiku.OrderCode = oi.OrderCode<br />LEFT JOIN RB_OrderInfo_BeikuExpand (NOLOCK) epo<br />ON epo.TransitOrderCode = oi.OrderCode<br />AND epo.CustomerID = oi.CustomerID<br />LEFT JOIN RB_RestockOrder_ApprovalExecutor (NOLOCK) ae<br />ON ae.CustomerId = oi.CustomerID<br />AND ae.OrderCode = oi.OrderCode<br />INNER JOIN RB_FBA_ShipmentInfo (NOLOCK) fbasi<br />ON oi.CustomerID = fbasi.CustomerID<br />AND fbasi.OrderSourceID = oi.OrderSourceID<br />AND oi.AmazonShipmentId = fbasi.ShipmentId<br />INNER JOIN dbo.RB_Amazon_Product_Base vtba (NOLOCK) ON vtba.CustomerID=oi.CustomerID<br />AND vtba.OrderSourceID =oi.OrderSourceID AND vtba.OrderSourceSKU = ol.SellerSKU<br />WHERE oi.CustomerID = 1<br />AND oi.IsStockOrder = 1<br />AND os.OrderSourceType = 1<br />AND towh.WareHouseType = 3<br />AND ep.OrderBuildType = 1<br />AND oi.IsSystem = 0<br />GROUP BY os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) )TT<br />INNER JOIN RB_OrderInfo t1 (nolock) ON t1.ID=tt.oiId<br />INNER JOIN dbo.RB_Amazon_Product_Base vtb (NOLOCK) ON vtb.OrderSourceSKUID=TT.OrderSourceSKUID<br />INNER JOIN dbo.RB_OrderSource t2 (nolock) ON t2.ID=vtb.OrderSourceID<br />LEFT JOIN RB_Admin rba WITH (NOLOCK)<br />ON rba.CustomerID = t2.CustomerID<br />AND rba.ID = t2.SaleAdminID<br />LEFT JOIN RB_BusinessTeam bt WITH (NOLOCK)<br />ON bt.CustomerID = t2.CustomerID<br />AND bt.ID = rba.BusinessTeamID<br />LEFT JOIN dbo.RB_Department t3 (nolock) ON t3.ID=rba.DepartmentID<br />WHERE vtb.OrderSourceSKUID&gt;0<br /></p>
    004+ <p>SELECT<br />t2.OrderSourceName '订单来源渠道',t2.OrderSourceCountry '市场',<br />t3.DepartmentName '部门', bt.BusinessTeamName '小组',t2.SaleAdminName '销售',vtb.OrderSourceSKU '渠道SKU', tt.ASIN 'ASIN'<br />, case<br />vtb.OnShelfMode<br />when 1 then '一键上架'<br />when 2 then '草稿上架'<br />when 3 then '表格上架'<br />when 4 then '关联导入'<br />when 5 then '批量跟卖'<br />when 6 then '凤凰重刊'<br />end '刊登方式',<br />vtb.AddTime 'listing刊登时间',<br />t1.AddTime '首次备货时间',<br />t1.OrderCode '备库订单号'<br />FROM (<br />SELECT os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) AS ASIN,MIN(oi.ID) oiId,min(vtba.OrderSourceSKUID) OrderSourceSKUID<br />FROM dbo.RB_OrderInfo oi (NOLOCK)<br />INNER JOIN RB_OrderInfo_BeikuExpand ep (NOLOCK)<br />ON oi.CustomerID = ep.CustomerID<br />AND oi.OrderCode = ep.OrderCode<br />INNER JOIN dbo.RB_OrderList ol (nolock) ON ol.CustomerID=oi.CustomerID<br />AND ol.OrderCode=oi.OrderCode<br />LEFT OUTER JOIN RB_OrderSource (NOLOCK) os<br />ON oi.OrderSourceID = os.ID<br />AND oi.CustomerID = os.CustomerID<br />LEFT OUTER JOIN RB_Transport (NOLOCK) ts<br />ON oi.TransportID = ts.ID<br />AND oi.CustomerID = ts.CustomerID<br />LEFT JOIN dbo.RB_WareHouse (NOLOCK) wh<br />ON oi.CustomerID = wh.CustomerID<br />AND oi.WareHouseID = wh.ID<br />LEFT JOIN dbo.RB_WareHouse (NOLOCK) towh<br />ON oi.CustomerID = towh.CustomerID<br />AND oi.ToWareHouseID = towh.ID<br />LEFT JOIN RB_OrderInfo_Beiku (NOLOCK) beiku<br />ON beiku.CustomerID = oi.CustomerID<br />AND beiku.OrderCode = oi.OrderCode<br />LEFT JOIN RB_OrderInfo_BeikuExpand (NOLOCK) epo<br />ON epo.TransitOrderCode = oi.OrderCode<br />AND epo.CustomerID = oi.CustomerID<br />LEFT JOIN RB_RestockOrder_ApprovalExecutor (NOLOCK) ae<br />ON ae.CustomerId = oi.CustomerID<br />AND ae.OrderCode = oi.OrderCode<br />INNER JOIN RB_FBA_ShipmentInfo (NOLOCK) fbasi<br />ON oi.CustomerID = fbasi.CustomerID<br />AND fbasi.OrderSourceID = oi.OrderSourceID<br />AND oi.AmazonShipmentId = fbasi.ShipmentId<br />INNER JOIN dbo.RB_Amazon_Product_Base vtba (NOLOCK) ON vtba.CustomerID=oi.CustomerID<br />AND vtba.OrderSourceID =oi.OrderSourceID AND vtba.OrderSourceSKU = ol.SellerSKU<br />WHERE oi.CustomerID = 1<br />AND oi.IsStockOrder = 1<br />AND os.OrderSourceType = 1<br />AND towh.WareHouseType = 3<br />AND ep.OrderBuildType = 1<br />AND oi.IsSystem = 0<br />GROUP BY os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) )TT<br />INNER JOIN RB_OrderInfo t1 (nolock) ON t1.ID=tt.oiId<br />INNER JOIN dbo.RB_Amazon_Product_Base vtb (NOLOCK) ON vtb.OrderSourceSKUID=TT.OrderSourceSKUID<br />INNER JOIN dbo.RB_OrderSource t2 (nolock) ON t2.ID=vtb.OrderSourceID<br />LEFT JOIN RB_Admin rba WITH (NOLOCK)<br />ON rba.CustomerID = t2.CustomerID<br />AND rba.ID = t2.SaleAdminID<br />LEFT JOIN RB_BusinessTeam bt WITH (NOLOCK)<br />ON bt.CustomerID = t2.CustomerID<br />AND bt.ID = rba.BusinessTeamID<br />LEFT JOIN dbo.RB_Department t3 (nolock) ON t3.ID=rba.DepartmentID<br />WHERE vtb.OrderSourceSKUID&gt;0</p>
  3. 2022-09-01 08:40:00, 由 罗友军 编辑。
    修改了 截止日期，旧值为 "2022-08-31"，新值为 "2022-09-01"。
    修改了 最初预计，旧值为 "6"，新值为 "8"。
    修改了 预计剩余，旧值为 "6"，新值为 "8"。
    修改了 任务描述，区别为：
    001- <img src="/zentao/file-read-213159.png" alt="" />
    001+
    002- <img src="/zentao/file-read-213160.png" alt="" />
    002+
    001- <p><img src="/zentao/file-read-213159.png" alt="" /></p>
    001+ <p><img src="{213159.png}" alt="" /></p>
    002- <p><img src="/zentao/file-read-213160.png" alt="" /></p>
    002+ <p><img src="{213160.png}" alt="" /></p>
  4. 2022-09-01 10:53:11, 由 罗友军 编辑。
    修改了 任务描述，区别为：
    001- <img src="/zentao/file-read-213159.png" alt="" />
    001+
    002- <img src="/zentao/file-read-213160.png" alt="" />
    002+
    001- <p><img src="/zentao/file-read-213159.png" alt="" /></p>
    001+ <p><img src="{213159.png}" alt="" /></p>
    002- <p><img src="/zentao/file-read-213160.png" alt="" /></p>
    002+ <p><img src="{213160.png}" alt="" /></p>



    SELECT
    t2.OrderSourceName '订单来源渠道',t2.OrderSourceCountry '市场',
    t3.DepartmentName '部门', bt.BusinessTeamName '小组',t2.SaleAdminName '销售',vtb.OrderSourceSKU '渠道SKU', tt.ASIN 'ASIN'
    ,rp.sku '系统SKU' ,case
    rp.DevelopType
    when 1 then '自主开发'
    when 2 then '供应商后台'
    when 3 then '指定开发'
    when 4 then '智能选品'
    when 5 then '销售提报_FBA新品'
    end  'SKU开发类型'
    ,rpa.CheckTime 'SKU终审时间'
    ,rp.ProductNameCN '中文名称'
    ,rpb.BrandName '品牌名称'
    ,t1.OrderCode '首次到货FBA备库单号'
    ,TT.minAddTime '首次到货时间'
    ,(SELECT TOP 1  rsd.QuantityReceived FROM RB_FBA_ShipmentDetail rsd (nolock) WHERE rsd.CustomerID=1 AND rsd.ShipmentId =rsi.ShipmentId AND rsd.OrderSourceID = vtb.OrderSourceID
    AND rsd.SellerSKU = vtb.OrderSourceSKU ORDER BY rsd.AddTime ASC ) '首次到货数量'
    ,vtb.OrderSourceSkuOrderTime '渠道首单时间'
    ,vtb.AvgDailySales '估算销量'
    ,(SELECT  SUM(ros.ProductNum+ros.ProdutNumUpdate) FROM  RB_Report_OrderSettlement ros (nolock) WHERE ros.CustomerID =vtb.CustomerID AND ros.OrderSourceID = vtb.OrderSourceID
    AND ros.SellerSKU = vtb.OrderSourceSKU AND datediff(day,ISNULL(TT.minAddTime,'2025-01-01') ,ros.PayDate)>0 AND 
    datediff(day,ISNULL(TT.minAddTime,'2025-01-01') ,ros.PayDate)<31) '到货时间顺延30天销量'
    ,(SELECT  SUM(SalesPrice) FROM  RB_Report_OrderSettlement ros (nolock) WHERE ros.CustomerID =vtb.CustomerID AND ros.OrderSourceID = vtb.OrderSourceID
    AND ros.SellerSKU = vtb.OrderSourceSKU AND datediff(day,ISNULL(TT.minAddTime,'2025-01-01') ,ros.PayDate)>0 AND 
    datediff(day,ISNULL(TT.minAddTime,'2025-01-01') ,ros.PayDate)<31)  '到货时间顺延30天销售额'
    ,(SELECT  SUM(Profits) FROM  RB_Report_OrderSettlement ros (nolock) WHERE ros.CustomerID =vtb.CustomerID AND ros.OrderSourceID = vtb.OrderSourceID
    AND ros.SellerSKU = vtb.OrderSourceSKU AND datediff(day,ISNULL(TT.minAddTime,'2025-01-01') ,ros.PayDate)>0 AND 
    datediff(day,ISNULL(TT.minAddTime,'2025-01-01') ,ros.PayDate)<31) '到货时间顺延30天利润额'
    ,(SELECT  SUM(ros.ProductNum+ros.ProdutNumUpdate) FROM  RB_Report_OrderSettlement ros (nolock) WHERE ros.CustomerID =vtb.CustomerID AND ros.OrderSourceID = vtb.OrderSourceID
    AND ros.SellerSKU = vtb.OrderSourceSKU) '累计销量'
    ,(SELECT  SUM(SalesPrice) FROM  RB_Report_OrderSettlement ros (nolock) WHERE ros.CustomerID =vtb.CustomerID AND ros.OrderSourceID = vtb.OrderSourceID
    AND ros.SellerSKU = vtb.OrderSourceSKU) '累计销售额'
    ,(SELECT  SUM(Profits) FROM  RB_Report_OrderSettlement ros (nolock) WHERE ros.CustomerID =vtb.CustomerID AND ros.OrderSourceID = vtb.OrderSourceID
    AND ros.SellerSKU = vtb.OrderSourceSKU)  '累计毛利润'
    , case
    vtb.OnShelfMode
    when 1 then '一键上架'
    when 2 then '草稿上架'
    when 3 then '表格上架'
    when 4 then '关联导入'
    when 5 then '批量跟卖'
    when 6 then '凤凰重刊'
    end '刊登方式',
    vtb.AddTime 'listing刊登时间',
    t1.AddTime '首次备货时间',
    t1.OrderCode '备库订单号'
    FROM (
    SELECT os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) AS ASIN,MIN(oi.ID) oiId,min(vtba.OrderSourceSKUID) OrderSourceSKUID,
    MIN(fbasi.ID) minShipmentInfoId,MIN(ttfsd.AddTime) minAddTime
    FROM dbo.RB_OrderInfo oi (NOLOCK)
    INNER JOIN RB_OrderInfo_BeikuExpand ep (NOLOCK)
    ON oi.CustomerID = ep.CustomerID
    AND oi.OrderCode = ep.OrderCode
    INNER JOIN dbo.RB_OrderList ol (nolock) ON ol.CustomerID=oi.CustomerID
    AND ol.OrderCode=oi.OrderCode
    LEFT OUTER JOIN RB_OrderSource (NOLOCK) os
    ON oi.OrderSourceID = os.ID
    AND oi.CustomerID = os.CustomerID
    LEFT OUTER JOIN RB_Transport (NOLOCK) ts
    ON oi.TransportID = ts.ID
    AND oi.CustomerID = ts.CustomerID
    LEFT JOIN dbo.RB_WareHouse (NOLOCK) wh
    ON oi.CustomerID = wh.CustomerID
    AND oi.WareHouseID = wh.ID
    LEFT JOIN dbo.RB_WareHouse (NOLOCK) towh
    ON oi.CustomerID = towh.CustomerID
    AND oi.ToWareHouseID = towh.ID
    LEFT JOIN RB_OrderInfo_Beiku (NOLOCK) beiku
    ON beiku.CustomerID = oi.CustomerID
    AND beiku.OrderCode = oi.OrderCode
    LEFT JOIN RB_OrderInfo_BeikuExpand (NOLOCK) epo
    ON epo.TransitOrderCode = oi.OrderCode
    AND epo.CustomerID = oi.CustomerID
    LEFT JOIN RB_RestockOrder_ApprovalExecutor (NOLOCK) ae
    ON ae.CustomerId = oi.CustomerID
    AND ae.OrderCode = oi.OrderCode
    INNER JOIN RB_FBA_ShipmentInfo (NOLOCK) fbasi
    ON oi.CustomerID = fbasi.CustomerID
    AND fbasi.OrderSourceID = oi.OrderSourceID
    AND oi.AmazonShipmentId = fbasi.ShipmentId
    INNER JOIN dbo.RB_Amazon_Product_Base vtba (NOLOCK) ON vtba.CustomerID=oi.CustomerID
    AND vtba.OrderSourceID =oi.OrderSourceID AND vtba.OrderSourceSKU = ol.SellerSKU
    LEFT JOIN RB_FBA_ShipmentDetail ttfsd (NOLOCK) ON ttfsd.CustomerID = 1 AND ttfsd.OrderSourceID = vtba.OrderSourceID
    AND ttfsd.ShipmentId = fbasi.ShipmentId AND  ttfsd.SellerSKU = vtba.OrderSourceSKU
    WHERE oi.CustomerID = 1
    AND oi.IsStockOrder = 1
    AND os.OrderSourceType = 1
    AND towh.WareHouseType = 3
    AND ep.OrderBuildType = 1
    AND oi.IsSystem = 0
    GROUP BY os.OrderSourceCountry,TRIM(Replace(Replace(Replace(ol.ASIN,'\t',''),'\n',''),'\r','')) )TT
    INNER JOIN RB_OrderInfo t1 (nolock) ON t1.ID=tt.oiId
    INNER JOIN dbo.RB_Amazon_Product_Base vtb (NOLOCK) ON vtb.OrderSourceSKUID=TT.OrderSourceSKUID
    INNER JOIN dbo.RB_OrderSource t2 (nolock) ON t2.ID=vtb.OrderSourceID
    LEFT JOIN RB_Admin rba WITH (NOLOCK)
    ON rba.CustomerID = t2.CustomerID
    AND rba.ID = t2.SaleAdminID
    LEFT JOIN RB_BusinessTeam bt WITH (NOLOCK)
    ON bt.CustomerID = t2.CustomerID
    AND bt.ID = rba.BusinessTeamID
    LEFT JOIN dbo.RB_Department t3 (nolock) ON t3.ID=rba.DepartmentID
    LEFT JOIN dbo.RB_Product rp(nolock) ON rp.CustomerID = vtb.CustomerID AND rp.SKU = vtb.SKU
    LEFT JOIN dbo.RB_Product_Admin rpa (nolock) ON rpa.CustomerID = rp.CustomerID
    AND rpa.SKU=rp.SKU
    LEFT JOIN dbo.RB_Product_Brand rpb (nolock) ON rpb.CustomerID=rp.CustomerID AND rpb.ID = rp.BrandID
    LEFT JOIN RB_FBA_ShipmentInfo rsi (nolock) ON rsi.ID=tt.minShipmentInfoId AND rsi.CustomerID = 1 
    WHERE vtb.OrderSourceSKUID>0 AND vtb.CustomerID = 1  
  5. 2022-09-01 10:53:21, 由 罗友军 完成。
    修改了 总计消耗，旧值为 "0"，新值为 "8"。
    修改了 实际完成，旧值为 ""，新值为 "2022-09-01 10:53:18"。
    修改了 任务状态，旧值为 "wait"，新值为 "done"。
    修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2022-09-01 10:53:21"。
    修改了 预计剩余，旧值为 "8"，新值为 "0"。
    修改了 由谁完成，旧值为 ""，新值为 "luoyoujun"。
  6. 2023-03-23 18:31:23, 由 罗友军 关闭。
    修改了 任务状态，旧值为 "done"，新值为 "closed"。
    修改了 指派给 ，旧值为 "luoyoujun"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "luoyoujun"。
    修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2023-03-23 18:31:23"。
    修改了 关闭原因，旧值为 ""，新值为 "done"。
所属迭代 智能中心-智能刊登迭代
所属模块 /
相关需求 暂无
指派给 Closed 于 2023-03-23 18:31:23
任务类型 后端
任务标签 初始
开发组
任务状态 已关闭
进度 100%
优先级 P2
关键词
抄送给
由谁创建 罗友军 于 2022-08-31 09:22:53
由谁完成 罗友军 于 2022-09-01 10:53:18
由谁取消 暂无
由谁关闭 罗友军 于 2023-03-23 18:31:23
关闭原因 已完成
最后编辑 罗友军 于 2023-03-23 18:31:23
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 8工时
总计消耗 8工时
预计剩余 0工时
预计开始 0000-00-00
实际开始 2022-09-01
截止日期 2022-09-01