ebay费用数据中心拉取，先从RB_Ebay_Account_Fee（CustomerID+OrderSourceID+OrderLineItemID+TransactionID）中匹配关联itemid和title，没有匹配到再调用Ebay订单接口，获取ItemID和Title。

一、创建的表

见附件：Ebay交易报告下载-金蝶4期计划.sql 

二、创建索引

见附件：Ebay交易报告下载-金蝶4期计划.sql 

三、配置Job服务

Ebay账号费用报告-KIS：Task_Ebay_Account_Fee_KIS

四、配置自定义报表导出

SELECT 
a.FeeTypeLevel1 AS 费用类型,
a.FeeTypeLevel2 AS 二级费用类型,
a.FeeTypeLevel3 AS 三级费用类型,
a.TransactionDate AS 交易日期,
a.OrderId AS 订单号,
a.TransactionID 交易编号,
a.SalesRecordReference 参考编号,
a.SKU 系统SKU,
a.ItemID 物品编号,
a.Title  产品标题,
a.PayoutId PayoutId,
a.QuantityShipped 产品数量,
a.AmountCurrencyID 原币,
a.AmountValue 原币金额,
a.ConvertedFromCurrencyID 转换币,
a.ConvertedFromRate 汇率,
a.ConvertedFromValue 转换币金额,
a.Memo 备注项
FROM RB_Ebay_Account_Fee_KIS (NOLOCK) a
LEFT JOIN RB_OrderSource (NOLOCK) c ON a.CustomerID = c.CustomerID AND a.OrderSourceID = c.ID
LEFT JOIN (select OrderSourceSKU,CustomerID,OrderSourceID,max(SKU)SKU from RB_Product_OrderSourceSKU (nolock) group by  OrderSourceSKU,CustomerID,OrderSourceID)pss ON a.CustomerID = pss.CustomerID AND a.SellerSKU = pss.OrderSourceSKU AND a.OrderSourceID = pss.OrderSourceID  
LEFT JOIN dbo.RB_Admin ra (NOLOCK) ON c.SaleAdminID = ra.ID 
LEFT JOIN dbo.RB_Product p (NOLOCK) ON p.SKU = pss.SKU AND p.CustomerID = pss.CustomerID
LEFT JOIN dbo.RB_Product_Admin pra (NOLOCK) ON p.SKU = pra.SKU AND p.CustomerID = pra.CustomerID
LEFT JOIN dbo.E_Country ec (NOLOCK) ON c.OrderSourceCountry=ec.Shorthand
LEFT JOIN dbo.E_Currency cy (nolock) on a.AmountCurrencyID=cy.Currency
WHERE  
a.CustomerID = @CustomerID
AND a.OrderSourceID IN (SELECT ID FROM dbo.RB_OrderSource WITH (NOLOCK) WHERE OrderSourceType = 2 AND CustomerID = @CustomerID)
AND a.TransactionDate>=@startdate and a.TransactionDate<=@enddate AND  {{ a.OrderSourceID IN (@OrderSourceName) }}

五、SVN提交

任务 33030, Ebay交易报告下载-金蝶4期计划

任务 33030, Ebay交易报告下载-金蝶4期计划-代码重构了一下：