任务描述
暂无
需求描述

需求路径：M-15695 FMS：余额精准核对项目-AMZ验收目标（责任人：林很）(1) · 钉钉文档 (dingtalk.com)

验收标准
暂无
历史记录  
  1. 2023-08-08 14:03:50, 由 周杰 创建。
  2. 2023-08-08 16:47:33, 由 张明磊 启动。
    修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2023-08-08 16:47:32"。
    修改了 任务状态，旧值为 "wait"，新值为 "doing"。
  3. 2023-08-08 17:43:31, 由 周杰 编辑。
    修改了 任务名称，区别为：
    001- 【后端】10套店铺数据逻辑测验
    001+ 【后端】已交易已结算(收入-费用)逻辑调整
    001- 【后端】10套店铺数据逻辑测验
    001+ 【后端】已交易已结算(收入-费用)逻辑调整
  4. 2023-08-09 11:27:56, 由 张明磊 添加备注。

    测算账号：

    SELECT
    api.CustomerID ,
    api.OrderSourceID ,
    api.DevIDSellerId ,
    api.AppIDMarketplaceId,
    os.OrderSourceCountry
    FROM
    RB_OrderSource_EbayAmazonAPI api ( NOLOCK )
    LEFT OUTER JOIN RB_OrderSource os WITH ( NOLOCK ) ON os.CustomerID = api.CustomerID 
    AND os.ID = api.OrderSourceID 
    WHERE
    os.ID in(12325, 15524, 15523, 15513, 15514, 15516, 15517, 15519, 15520, 15521, 15522, 15525, 15512, 15515, 15518, 15526, 16478, 16574, 17466, 18121)



    采集源数据：

    SELECT top 200 * from PaymentReports_IN (nolock) WHERE SellerId = 'A3AVQ528T7B264' and  MarketplaceId = 'A21TJRUUN4KGV' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_GB (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'A1F83G8C2ARO7P' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_DE (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'A1PA6795UKMFR9' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_IT (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'APJ6JRA9NG5V4' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_FR (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'A13V1IB3VIYZZH' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_ES (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'A1RKKUPIHCS9HS' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_PL (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'A1C3SOZRARQ6R3' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_SE (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'A2NODRKZP88ZB9' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_NL (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'A1805IZSGTT6HS' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_US (nolock) WHERE SellerId = 'A4ZM173VY1VFI' and  MarketplaceId = 'ATVPDKIKX0DER' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_CA (nolock) WHERE SellerId = 'A4ZM173VY1VFI' and  MarketplaceId = 'A2EUQ1WTGCTBG2' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_MX (nolock) WHERE SellerId = 'A4ZM173VY1VFI' and  MarketplaceId = 'A1AM78C64UM0Y8' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_AU (nolock) WHERE SellerId = 'A3PS6FNOWI5ENO' and  MarketplaceId = 'A39IBJ37TRP1C6' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_SA (nolock) WHERE SellerId = 'A16W7VZAROKXQD' and  MarketplaceId = 'A17E79C6D8DWNP' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_AE (nolock) WHERE SellerId = 'AZ7LC9QL7BXMO' and  MarketplaceId = 'A2VIGQ35RCS4UG' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_SG (nolock) WHERE SellerId = 'A20NNJ71L9IBC2' and  MarketplaceId = 'A19VAU5U5O7RUS' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_BR (nolock) WHERE SellerId = 'A4ZM173VY1VFI' and  MarketplaceId = 'A2Q3Y263D00KWC' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_TR (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'A33AVAJ2PDY3EV' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_BE (nolock) WHERE SellerId = 'A3TXUBTQ09KQLC' and  MarketplaceId = 'AMEN7PMS3EDWL' and RequestDate > '2023-08-01' ORDER BY id desc
    SELECT top 200 * from PaymentReports_JP (nolock) WHERE SellerId = 'A2LX3H3VVDAYB3' and  MarketplaceId = 'A1VC38T7YXB528' and RequestDate > '2023-08-01' ORDER BY id desc

  5. 2023-08-09 15:36:19, 由 张明磊 添加备注。

    初始化6月期初。5月期末

    UPDATE ifc_eventsverify_report_amazon ra
    INNER JOIN ordersource os ON ra.OrderSourceName = os.ordersource_name 
    SET ra.OrderSourceId = os.ordersource_id


    UPDATE
    ifc_eventsverify_report_amazon ra
    INNER JOIN ordersource os ON ra.OrderSourceId = os.ordersource_id
    INNER JOIN admin ad ON ad.AdminId = os.sale_admin_id
    INNER JOIN department de on ad.DepartmentId = de.DepartmentId
    INNER JOIN department dep on de.ParentId = dep.DepartmentId
    set ra.DepartmentId = dep.DepartmentId,ra.DepartmentName = dep.DepartmentName

  6. 2023-08-09 16:10:13, 由 张明磊 添加备注。

    修改币种：

    UPDATE ifc_eventsverify_report_amazon ra
    INNER JOIN Db_Irobotbox_Data t1 ON t1.OtherData = ra.Currency 
    AND t1.IsDelete =FALSE
    INNER JOIN Db_Irobotbox_Account_Configdata t2 ON t1.ID = t2.IrobotBoxDataID 
    AND t2.AccountBookID = 1 
    AND t2.IsDelete =FALSE
    INNER JOIN Db_Kingdee_Data t3 ON t3.ID = t2.KingdeeID 
    AND t2.AccountBookID = t3.AccountBookID 
    AND t1.BasicDataTypeID = 5
    INNER JOIN Db_Kingdee_Data t4 ON t4.FCYFORID = t3.KingdeeCode 
    AND t3.AccountBookID = t4.AccountBookID 
    AND t4.DataYear = '2023' 
    AND t4.DataMonth = '05' 
    SET ra.ExchangeRate = t4.FExchangeRate

  7. 2023-08-09 23:27:21, 由 张明磊 完成。
    修改了 总计消耗，旧值为 "0"，新值为 "8"。
    修改了 指派给 ，旧值为 "zhangminglei"，新值为 "zhoujie"。
    修改了 实际完成，旧值为 ""，新值为 "2023-08-09 23:26:28"。
    修改了 任务状态，旧值为 "doing"，新值为 "done"。
    修改了 预计剩余，旧值为 "8"，新值为 "0"。
    修改了 由谁完成，旧值为 ""，新值为 "zhangminglei"。

    已更改逻辑在正式环境匹配了数据，待后续核查数据问题

  8. 2023-08-10 18:03:53, 由 周杰 关闭。
    修改了 任务状态，旧值为 "done"，新值为 "closed"。
    修改了 指派给 ，旧值为 "zhoujie"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "zhoujie"。
    修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2023-08-10 18:03:53"。
    修改了 关闭原因，旧值为 ""，新值为 "done"。
    已完成
所属迭代 财务余额核对与金蝶对接V1
所属模块 /
相关需求 FMS：余额精准核对项目-AMZ验收目标
指派给 Closed 于 2023-08-10 18:03:53
任务类型 后端
任务标签 初始
开发组 多平台开发组
任务状态 已关闭
进度 100%
优先级 P2
关键词
抄送给
由谁创建 周杰 于 2023-08-08 14:03:50
由谁完成 张明磊 于 2023-08-09 23:26:28
由谁取消 暂无
由谁关闭 周杰 于 2023-08-10 18:03:53
关闭原因 已完成
最后编辑 周杰 于 2023-08-10 18:03:53
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 8工时
总计消耗 8工时
预计剩余 0工时
预计开始 2023-08-08
实际开始 2023-08-08
截止日期 2023-08-09