重现步骤

[步骤]


[结果]


[期望]






SELECT TOP 100 AmountAfterDiscount,OptionId,* FROM RB_Crawler_Coupang_ReportSettlementBarcodeFee WITH(NOLOCK) WHERE CustomerID=1 and id>=13  ORDER BY ID DESC;
SELECT OrderDescription,OrderSourceOtherDebits/ExchangeRMB/1.1 平台其他支出,*
FROM RB_Report_OrderSettlement WITH(NOLOCK) WHERE CustomerID=1 AND OrderSourceType = 73 AND AddTime >'2026-08-17'
and  OrderDescription like '【Coupang】【附加服务费费用对接】%' ;
select
  IsDelete,OrderSourceID,UPDATETIME,OrderSourceSKU,SKU,NewBusinessAdminid,NewBusinessAdminName,BusinessAdminID,BusinessAdminName,IsFBA,*
from 
RB_Product_OrderSourceSKU
where 
OrderSourceID IN ('23774',
'30970')
and 
OrderSourceSKU in ('95303886348')

历史记录  
  1. 2026-08-18 11:11:11, 由 曾倩 创建。
  2. 2026-08-18 11:57:59, 由 李忠红 解决,方案为 程序BUG 。
    修改了 解决方案,旧值为 "",新值为 "code"。
    修改了 解决版本,旧值为 "",新值为 "trunk"。
    修改了 解决日期,旧值为 "",新值为 "2026-08-18 11:57:42"。
    修改了 指派给 ,旧值为 "lizhonghong",新值为 "zengqian"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "lizhonghong"。
  3. 2026-08-24 09:41:26, 由 曾倩 编辑。
    修改了 开发责任人,旧值为 "",新值为 "lizhonghong"。
    修改了 测试责任人,旧值为 "",新值为 "zengqian"。
    修改了 解决时效 ,旧值为 "0",新值为 "0.78"。
    修改了 重现步骤 ,区别为:
    010- SELECT TOP 100 AmountAfterDiscount,OptionId,* FROM RB_Crawler_Coupang_ReportSettlementBarcodeFee WITH(NOLOCK) WHERE CustomerID=1 and id>=13 ORDER BY ID DESC;SELECT OrderDescription,OrderSourceOtherDebits/ExchangeRMB/1.1 平台其他支出,*FROM RB_Report_OrderSettlement WITH(NOLOCK) WHERE CustomerID=1 AND OrderSourceType = 73 AND AddTime >'2026-08-17'and OrderDescription like '【Coupang】【附加服务费费用对接】%' ; select IsDelete,OrderSourceID,UPDATETIME,OrderSourceSKU,SKU,NewBusinessAdminid,NewBusinessAdminName,BusinessAdminID,BusinessAdminName,IsFBA,*from RB_Product_OrderSourceSKU where OrderSourceID IN ('23774','30970') and OrderSourceSKU in ('95303886348')
    010+ SELECT TOP 100 AmountAfterDiscount,OptionId,* FROM RB_Crawler_Coupang_ReportSettlementBarcodeFee WITH(NOLOCK) WHERE CustomerID=1 and id>=13 ORDER BY ID DESC;SELECT OrderDescription,OrderSourceOtherDebits/ExchangeRMB/1.1 平台其他支出,*FROM RB_Report_OrderSettlement WITH(NOLOCK) WHERE CustomerID=1 AND OrderSourceType = 73 AND AddTime >'2026-08-17'and OrderDescription like '【Coupang】【附加服务费费用对接】%' ; select IsDelete,OrderSourceID,UPDATETIME,OrderSourceSKU,SKU,NewBusinessAdminid,NewBusinessAdminName,BusinessAdminID,BusinessAdminName,IsFBA,*from RB_Product_OrderSourceSKU where OrderSourceID IN ('23774','30970') and OrderSourceSKU in ('95303886348')
    010- <p>SELECT TOP 100 AmountAfterDiscount,OptionId,* FROM RB_Crawler_Coupang_ReportSettlementBarcodeFee WITH(NOLOCK) WHERE CustomerID=1 and id&gt;=13 ORDER BY ID DESC;<br />SELECT OrderDescription,OrderSourceOtherDebits/ExchangeRMB/1.1 平台其他支出,*<br />FROM RB_Report_OrderSettlement WITH(NOLOCK) WHERE CustomerID=1 AND OrderSourceType = 73 AND AddTime &gt;'2026-08-17'<br />and OrderDescription like '【Coupang】【附加服务费费用对接】%' ;<br /><span><span> </span>select</span><br /> IsDelete,OrderSourceID,UPDATETIME,OrderSourceSKU,SKU,NewBusinessAdminid,NewBusinessAdminName,BusinessAdminID,BusinessAdminName,IsFBA,*<br />from<br /><span><span> </span>RB_Product_OrderSourceSKU</span><br /><span><span> </span>where</span><br /><span><span> </span>OrderSourceID IN ('23774',</span><br />'30970')<br /><span><span> </span>and</span><br /><span><span> </span>OrderSourceSKU in ('95303886348')</span><br /></p>
    010+ <p>SELECT TOP 100 AmountAfterDiscount,OptionId,* FROM RB_Crawler_Coupang_ReportSettlementBarcodeFee WITH(NOLOCK) WHERE CustomerID=1 and id&gt;=13 ORDER BY ID DESC;<br />SELECT OrderDescription,OrderSourceOtherDebits/ExchangeRMB/1.1 平台其他支出,*<br />FROM RB_Report_OrderSettlement WITH(NOLOCK) WHERE CustomerID=1 AND OrderSourceType = 73 AND AddTime &gt;'2026-08-17'<br />and OrderDescription like '【Coupang】【附加服务费费用对接】%' ;<br /><span><span> </span>select</span><br /> IsDelete,OrderSourceID,UPDATETIME,OrderSourceSKU,SKU,NewBusinessAdminid,NewBusinessAdminName,BusinessAdminID,BusinessAdminName,IsFBA,*<br />from<br /><span><span> </span>RB_Product_OrderSourceSKU</span><br /><span><span> </span>where</span><br /><span><span> </span>OrderSourceID IN ('23774',</span><br />'30970')<br /><span><span> </span>and</span><br /><span><span> </span>OrderSourceSKU in ('95303886348')</span></p>
  4. 2026-08-24 09:41:28, 由 曾倩 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "zengqian",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "zengqian"。
    修改了 关闭日期,旧值为 "",新值为 "2026-08-24 09:41:28"。
所属项目 技术中心-需求池
所属模块 财务   财务管理
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 财务管理中心
影响功能
开发责任人 李忠红
测试责任人 曾倩
解决时效 0.78
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2026-08-24 09:41:28
截止日期 2026-08-18
上线时间 0000-00-00 00:00:00
上线时效 -1
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 曾倩 于 2026-08-18 11:11:11
影响环境 测试环境-测试反馈
由谁解决 李忠红 于 2026-08-18 11:57:42
解决版本 主干
解决方案 程序BUG
由谁关闭 曾倩 于 2026-08-24 09:41:28
最后修改 曾倩 于 2026-08-24 09:41:28
相关Bug