--销售收入，利润表缺失订单数据4204个订单 DECLARE @Start_SettlementDate datetime = '2023-06-01' DECLARE @End_SettlementDate datetime = '2023-06-30' --DECLARE @OrderSourceID int = 11890 SELECT AmazonOrderId,sum(CurrencyAmount) as '明细销售收入' FROM RB_Amazon_ListFinancialEvents WHERE CustomerID = 1 --AND t1OrderSourceID = 6942 AND PostedDate >= @Start_SettlementDate AND PostedDate <= @End_SettlementDate AND AmazonOrderId != '' AND AmazonOrderId IS NOT NULL AND SellerSKU != '' AND SellerSKU IS NOT NULL --AND OrderSourceID = @OrderSourceID AND FinancialEventType = 'ShipmentEvents' AND ShipmentItemType = 'ItemChargeList' AND EventDetailType = 'Principal' and amazonorderid not in ( SELECT ClientOrderCode from RB_Report_OrderSettlement(nolock) WHERE CustomerID = 1 -- AND {{ ShipTime >= @StartTime }} -- AND {{ ShipTime <= @EndTime }} -- AND {{ paytime >= @Start_payTime }} -- AND {{ paytime <= @End_payTime }} AND SettlementDate >= @Start_SettlementDate AND SettlementDate <= @End_SettlementDate -- AND {{ OrderCode = @OrderCode }} AND OrderSourceType = 1 --AND OrderSourceID = @OrderSourceID AND ClientOrderCode is not NULL and ClientOrderCode != '' and SellerSKU is not null and SellerSKU != '') GROUP BY AmazonOrderId ORDER BY '明细销售收入' desc