
SELECT B.OrderSourceName,A.ID,A.CustomerId,A.OrderSourceId,A.CreateTime,A.UpdateTime,A.LazadaOrderID,A.LazadaOrderItemID,A.Details,A.SellerSKU,A.LazadaSku,A.Amount,A.VATAmount,A.WHTAmount,A.WHTIncludedInAmount,A.[StateMent],A.PaidStatus,A.OrderItemStatus,A.ShippingProvider,A.ShippingSpeed,A.ShipmentType,A.Reference,A.Comment,A.PaymentRefId,A.FeeName,A.TransactionDate,A.TransactionType,A.TransactionNumber
FROM RB_Lazada_TransactionDetail(NOLOCK) A INNER JOIN RB_OrderSource B(NOLOCK) ON A.OrderSourceId=B.ID
='2023-08-10' AND TransactionDate
ORDER BY TransactionDate ASC

Lazada费用下载去重逻辑调整:3H