https://alidocs.dingtalk.com/i/nodes/YQBnd5ExVEwXEnODujP4B55j8yeZqMmz?utm_scene=team_space

[步骤]

[结果]

[期望]

select
OrderSourceID,Ordercode,shipdate,checkdate,
--CheckDate,
sum(SalesPrice/ExchangeRMB) '销售收入',
sum(TransportPay/ExchangeRMB) '运费收入',
sum(SalesRefunds/ExchangeRMB) '退款金额',
sum(PromotionRebates/ExchangeRMB) '促销折扣',
sum(OtherCredits/ExchangeRMB) '其他收入',
sum(Tax/ExchangeRMB) '税费收入',
sum(MarketplaceFacilitatorTax/ExchangeRMB) '扣除客户支付税费',
sum(Incomes/ExchangeRMB) '总收入',
sum(CommisionFee/ExchangeRMB) '佣金',
sum(FBATransactionFees/ExchangeRMB) 'FBA操作费',
sum(OrderSourceOtherDebits/ExchangeRMB) '平台其他支出',
sum(CostOfAdvertising/ExchangeRMB) '广告费',
sum(BuyPrice/ExchangeRMB) '采购成本',
sum(PackagedCost/ExchangeRMB) '包装成本',
sum(PackageFees/ExchangeRMB) '本地仓运费',
sum(OverSeasShipFees/ExchangeRMB) '海外仓运费',
sum(FirstLegFees/ExchangeRMB) '头程运费',
sum(TariffFees/ExchangeRMB) '进口关税',
sum(ExchangeLost/ExchangeRMB) '汇率折损',
sum(CostOfStorageFee/ExchangeRMB) '仓储费',
sum(CustomStorageFee/ExchangeRMB) '海外仓仓租',
sum(ImportFee/ExchangeRMB) '人工导入费',
sum(BreakageFee/ExchangeRMB) '报损费',
sum(Expenses/ExchangeRMB) '总支出',
sum(Profits/ExchangeRMB) '总利润'
from RB_Finance_Settlement_V2(NOLOCK)
where CustomerID=1
--and checkdate>='2024-11-01'
--and checkdate<'2024-11-11'
--and checkdate>='2024-11-01'
AND Ordercode in ('202411081109187850649')
group by OrderSourceID,shipdate,checkdate,Ordercode