任务描述
暂无
需求描述

需求路径：M-? FMS：LAZADA-SG站点发货时预估8%消费税（责任人：林很） · 钉钉文档 (dingtalk.com)

验收标准
暂无
历史记录  
  1. 2023-07-13 10:28:16, 由 夏宇 创建。
  2. 2023-07-14 14:25:12, 由 夏宇 添加备注。

  3. 2023-07-17 15:53:12, 由 夏宇 添加备注。

    202307171540834159


  4. 2023-07-17 16:23:20, 由 夏宇 启动。
    修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2023-07-17 16:23:12"。
    修改了 预计剩余，旧值为 "7"，新值为 "0.01"。
    修改了 任务状态，旧值为 "wait"，新值为 "doing"。
  5. 2023-07-17 16:23:51, 由 夏宇 添加备注。
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 1, .0000, N'', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '193934105', 0, '系统', '1', '2023-06-16 02:02:22.883', 'SGD', 5.3511001, '11974177', 7.1847995, N'143916Y0PNV1D2', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 2, .0000, N'', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '193934105', 0, '系统', '1', '2023-06-16 02:02:22.883', 'SGD', 5.3511001, '11974177', 7.1847995, N'143916Y0PNV1D2', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES (1, '202306152358145364927', 23, .0000, N'9', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '193934105', 0, '系统', '0', '2023-06-16 02:02:22.883', 'SGD', 5.3511001, '11974177', 7.1847995, N'143916Y0PNV1D2', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 48, .0000, N'20', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '193934105', 0, '系统', '1', '2023-06-16 02:02:22.883', 'SGD', 5.3511001, '11974177', 7.1847995, N'143916Y0PNV1D2', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES (1, '202306152358145364927', 41, .0000, N'28', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '193934105', 0, '系统', '0', '2023-06-16 02:02:22.883', 'RMB', 1.0000000, '11974177', 7.1847995, N'143916Y0PNV1D2', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES (1, '202306152358145364927', 40, .0000, N'46', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '193934105', 0, '系统', '0', '2023-06-16 02:02:22.883', 'SGD', 5.3511001, '11974177', 7.1847995, N'143916Y0PNV1D2', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES (1, '202306152358145364927', 40, .0000, N'18', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '193934105', 0, '系统', '0', '2023-06-16 02:02:22.883', 'RMB', 1.0000000, '11974177', 7.1847995, N'143916Y0PNV1D2', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 67, .0000, N'16', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '193934105', 0, '系统', '0', '2023-06-16 02:02:22.883', 'RMB', 1.0000000, '11974177', 7.1847995, N'143916Y0PNV1D2', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 1, 5.6000, N'8', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '194188695', 0, '系统', '1', '2023-06-19 16:52:58.723', 'SGD', 5.3511001, '3492093', 7.1847995, N'', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 2, 1.0000, N'8', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '194188695', 0, '系统', '1', '2023-06-19 16:52:58.723', 'SGD', 5.3511001, '3492093', 7.1847995, N'', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 23, -.3400, N'8', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '194188695', 0, '系统', '1', '2023-06-19 16:52:58.723', 'SGD', 5.3511001, '3492093', 7.1847995, N'', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES (1, '202306152358145364927', 48, -.4620, N'20', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '194188695', 0, '系统', '1', '2023-06-19 16:52:58.723', 'SGD', 5.3511001, '3492093', 7.1847995, N'', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES (1, '202306152358145364927', 41, -11.6700, N'27', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '194188695', 0, '系统', '1', '2023-06-19 16:52:58.723', 'RMB', 1.0000000, '3492093', 7.1847995, N'', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 40, -1.0000, N'8', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '194188695', 0, '系统', '1', '2023-06-19 16:52:58.723', 'SGD', 5.3511001, '3492093', 7.1847995, N'', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    -- INSERT INTO [RB_Product_Fee] ( [CustomerID], [OrderCode], [OperateType], [OperateFee], [Memo], [OperateTime], [LastOperateFee], [LastMemo], [LastUpdateTime], [IsConfirm], [ConfirmTime], [RelateID], [AdminID], [AdminName], [IsTrue], [AddTime], [Currency], [ExchangeRMB], [SKU], [USD_ExchangeRMB], [SellerSKU], [GroupSKU], [OrderSourceID], [OrderItemId], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime]) VALUES ( 1, '202306152358145364927', 40, -.7900, N'8', '2023-06-15 23:50:58.000', NULL, NULL, NULL, '0', '2023-06-15 23:50:58.000', '194188695', 0, '系统', '1', '2023-06-19 16:52:58.723', 'SGD', 5.3511001, '3492093', 7.1847995, N'', '', 7861, '101356152926169', NULL, NULL, '2023-06-22 22:19:18.723');
    --

    SELECT OrderSourceId,* FROM RB_Product_Fee WHERE OrderCode='202306152358145364927'
    UPDATE RB_Product_Fee set OrderSourceId='8464'  WHERE OrderCode='202306152358145364927'
    UPDATE  RB_Product_Fee set SKU='1375887' WHERE OrderCode='202306152358145364927' AND RelateID='194188695'

    -- INSERT INTO [RB_Lazada_TransactionDetail] ( [CustomerId], [OrderSourceId], [CreateTime], [UpdateTime], [LazadaOrderID], [LazadaOrderItemID], [Details], [SellerSKU], [LazadaSku], [Amount], [VATAmount], [WHTAmount], [WHTIncludedInAmount], [StateMent], [PaidStatus], [OrderItemStatus], [ShippingProvider], [ShippingSpeed], [ShipmentType], [Reference], [Comment], [PaymentRefId], [FeeName], [TransactionDate], [TransactionType], [TransactionNumber]) VALUES ( 1, 7861, '2023-06-22 22:16:56.603', '2023-06-22 22:16:56.603', '101356152826169', '101356152926169', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'143916Y0PNV1D2', N'2159765580_SGAMZ-12308494591', -1.0000, .0000, .0000, N'No', N'19 Jun 2023 - 25 Jun 2023', N'Not paid', N'Delivered', N'LGS-FM40', N'standard', N'Dropshipping', N'101356152926169', NULL, NULL, N'Domestic Shipping fees', '2023-06-22', N'Orders-Logistics', N'101356152926169');
    -- INSERT INTO [RB_Lazada_TransactionDetail] ( [CustomerId], [OrderSourceId], [CreateTime], [UpdateTime], [LazadaOrderID], [LazadaOrderItemID], [Details], [SellerSKU], [LazadaSku], [Amount], [VATAmount], [WHTAmount], [WHTIncludedInAmount], [StateMent], [PaidStatus], [OrderItemStatus], [ShippingProvider], [ShippingSpeed], [ShipmentType], [Reference], [Comment], [PaymentRefId], [FeeName], [TransactionDate], [TransactionType], [TransactionNumber]) VALUES ( 1, 7861, '2023-06-22 22:16:56.603', '2023-06-22 22:16:56.603', '101356152826169', '101356152926169', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'143916Y0PNV1D2', N'2159765580_SGAMZ-12308494591', -.7900, .0000, .0000, N'No', N'19 Jun 2023 - 25 Jun 2023', N'Not paid', N'Delivered', N'LGS-FM40', N'standard', N'Dropshipping', N'101356152926169', NULL, NULL, N'International Shipping fees', '2023-06-22', N'Orders-Logistics', N'101356152926169');
    -- INSERT INTO [RB_Lazada_TransactionDetail] ( [CustomerId], [OrderSourceId], [CreateTime], [UpdateTime], [LazadaOrderID], [LazadaOrderItemID], [Details], [SellerSKU], [LazadaSku], [Amount], [VATAmount], [WHTAmount], [WHTIncludedInAmount], [StateMent], [PaidStatus], [OrderItemStatus], [ShippingProvider], [ShippingSpeed], [ShipmentType], [Reference], [Comment], [PaymentRefId], [FeeName], [TransactionDate], [TransactionType], [TransactionNumber]) VALUES ( 1, 7861, '2023-06-22 22:16:56.603', '2023-06-22 22:16:56.603', '101356152826169', '101356152926169', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'143916Y0PNV1D2', N'2159765580_SGAMZ-12308494591', -.3400, .0000, .0000, N'No', N'19 Jun 2023 - 25 Jun 2023', N'Not paid', N'Delivered', N'LGS-FM40', N'standard', N'Dropshipping', N'101356152926169', NULL, NULL, N'Commission', '2023-06-22', N'Orders-Lazada Fees', N'101356152926169');
    -- INSERT INTO [RB_Lazada_TransactionDetail] ( [CustomerId], [OrderSourceId], [CreateTime], [UpdateTime], [LazadaOrderID], [LazadaOrderItemID], [Details], [SellerSKU], [LazadaSku], [Amount], [VATAmount], [WHTAmount], [WHTIncludedInAmount], [StateMent], [PaidStatus], [OrderItemStatus], [ShippingProvider], [ShippingSpeed], [ShipmentType], [Reference], [Comment], [PaymentRefId], [FeeName], [TransactionDate], [TransactionType], [TransactionNumber]) VALUES ( 1, 7861, '2023-06-22 22:16:56.603', '2023-06-22 22:16:56.603', '101356152826169', '101356152926169', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'143916Y0PNV1D2', N'2159765580_SGAMZ-12308494591', -.1300, .0000, .0000, N'No', N'19 Jun 2023 - 25 Jun 2023', N'Not paid', N'Delivered', N'LGS-FM40', N'standard', N'Dropshipping', N'101356152926169', NULL, NULL, N'Payment Fee', '2023-06-22', N'Orders-Lazada Fees', N'101356152926169');
    -- INSERT INTO [RB_Lazada_TransactionDetail] ( [CustomerId], [OrderSourceId], [CreateTime], [UpdateTime], [LazadaOrderID], [LazadaOrderItemID], [Details], [SellerSKU], [LazadaSku], [Amount], [VATAmount], [WHTAmount], [WHTIncludedInAmount], [StateMent], [PaidStatus], [OrderItemStatus], [ShippingProvider], [ShippingSpeed], [ShipmentType], [Reference], [Comment], [PaymentRefId], [FeeName], [TransactionDate], [TransactionType], [TransactionNumber]) VALUES ( 1, 7861, '2023-06-22 22:16:56.603', '2023-06-22 22:16:56.603', '101356152826169', '101356152926169', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'143916Y0PNV1D2', N'2159765580_SGAMZ-12308494591', 1.0000, .0000, .0000, N'No', N'19 Jun 2023 - 25 Jun 2023', N'Not paid', N'Delivered', N'LGS-FM40', N'standard', N'Dropshipping', N'101356152926169', NULL, NULL, N'Shipping Fee (Paid By Customer)', '2023-06-22', N'Orders-Logistics', N'101356152926169');
    -- INSERT INTO [RB_Lazada_TransactionDetail] ( [CustomerId], [OrderSourceId], [CreateTime], [UpdateTime], [LazadaOrderID], [LazadaOrderItemID], [Details], [SellerSKU], [LazadaSku], [Amount], [VATAmount], [WHTAmount], [WHTIncludedInAmount], [StateMent], [PaidStatus], [OrderItemStatus], [ShippingProvider], [ShippingSpeed], [ShipmentType], [Reference], [Comment], [PaymentRefId], [FeeName], [TransactionDate], [TransactionType], [TransactionNumber]) VALUES ( 1, 7861, '2023-06-22 22:16:56.603', '2023-06-22 22:16:56.603', '101356152826169', '101356152926169', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'143916Y0PNV1D2', N'2159765580_SGAMZ-12308494591', 5.6000, .0000, .0000, N'No', N'19 Jun 2023 - 25 Jun 2023', N'Not paid', N'Delivered', N'LGS-FM40', N'standard', N'Dropshipping', N'101356152926169', NULL, NULL, N'Item Price Credit', '2023-06-22', N'Orders-Sales', N'101356152926169');
    -- INSERT INTO [RB_Lazada_TransactionDetail] ( [CustomerId], [OrderSourceId], [CreateTime], [UpdateTime], [LazadaOrderID], [LazadaOrderItemID], [Details], [SellerSKU], [LazadaSku], [Amount], [VATAmount], [WHTAmount], [WHTIncludedInAmount], [StateMent], [PaidStatus], [OrderItemStatus], [ShippingProvider], [ShippingSpeed], [ShipmentType], [Reference], [Comment], [PaymentRefId], [FeeName], [TransactionDate], [TransactionType], [TransactionNumber]) VALUES ( 1, 7861, '2023-06-22 22:16:56.603', '2023-06-22 22:16:56.603', '101356152826169', '101356152926169', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'143916Y0PNV1D2', N'2159765580_SGAMZ-12308494591', -.4800, .0000, .0000, N'No', N'19 Jun 2023 - 25 Jun 2023', N'Not paid', N'Delivered', N'LGS-FM40', N'standard', N'Dropshipping', N'101356152926169', NULL, NULL, N'GST on Imported Low-Value Goods', '2023-06-22', N'Orders-Lazada Fees', N'101356152926169');


    SELECT * FROM RB_Lazada_TransactionDetail WHERE LazadaOrderID='101356152826169'
    UPDATE RB_Lazada_TransactionDetail set OrderSourceId='8464'  WHERE LazadaOrderID='101356152826169'
    --
    -- INSERT INTO [RB_OrderInfo] ([CustomerID], [OrderCode], [MainOrderCode], [OrderSourceID], [ClientOrderCode], [SellerOrderId], [ClientUserAccount], [Email], [MemberID], [DropShippingType], [RecommendMemberID], [SourceUrl], [IP], [AddTime], [PayerId], [Token], [TransactionId], [PaymentType], [ChooseTransport], [TransportID], [WareHouseID], [ToWareHouseID], [Currency], [ExchangeRMB], [ExchangeUSD], [TransportPay], [IsPay], [PayTime], [TotalPrice], [OtherPayPrice], [ProductTotalPrice], [CouponCode], [CouponMinusPrice], [VipType], [VipDiscount], [DiscountMinusPrice], [RefundType], [RefundPrice], [AddPayPrice], [ReturnIntegral], [OtherMemo], [ShipMemo], [OrderDescription], [FirstName], [LastName], [Sex], [PayCountry], [Country], [Province], [City], [Address], [PostCode], [Telephone], [OrderState], [OrderStatus], [ErrorLogType], [CheckErrorLog], [CheckOrderTime], [PurchaseType], [ProblemType], [ServiceAdminID], [ServiceAdminName], [SKUNumber], [ProductNumber], [ProductVolume], [ProductWeight], [SKUs], [ParameterIDs], [OptionsIDs], [ProductNumbers], [NoUseStock], [AmazonShipmentId], [TrackNumbers], [PickupTime], [ShipTime], [UpdatePlatformTime], [FeedSubmissionId], [TrackNumberTemp], [TempShipTime], [DownLoadUpdateTime], [IsExport], [ExportTime], [SalesRecordNumber], [IsPriority], [IsFirstDeliver], [UpdateTime], [IsFBAOrder], [IsStockOrder], [PaypalAccount], [DispatchUpdatePlatformTime], [OldOrderInfoID], [IsSystem], [PackagedIDs], [MergeOrderCode], [IsTogeInvoice], [AddOrderReasonType], [CarrierCodeValue], [CarrierCodeText], [ShareType], [ShareCustomerID], [IsSynchronous], [SynchronousTime], [ShareOrderCode], [SynTrackNumbersTime], [SynUpdateTime], [IsAccount], [AccountTime], [ShareTotalPrice], [LastCDKTime], [ISsynchOverseas], [HouseNumber], [CommentType], [AmazonDestinationFulfillmentCenterId], [IsCheckBlackUser], [PromotionDiscountAmount], [PromotionIdAll], [ShippingService], [PaypalFee], [ReviewReason], [SyncOverseasTime], [Address1], [Address2], [Address3], [RefundPaypalFee], [IsOrderUpdateTran], [IsMessage], [OrderTreeId], [CompanyName], [FBA_CarrierName], [OverDay], [LogisticsOrderNo], [OperatorID], [OperatorName], [PaymentMethods], [ReceiverBusiness], [LatestShipDate], [LatestDeliveryDate], [IsHadEmail], [EMPSDeliveryState], [MarkDeliveryState], [IsASingleInTheEnd], [IsTaxFree], [LogisticsOrderNo1], [FBA_TransportName], [SellerUserID], [CancelText], [CancelValue], [IsFBATransit], [PromotionType], [SaveTrackNumbersTime], [IsBiSycnComplete], [BiSycnCompleteTime], [IsFBABarCodes], [cbIsFBABarCodes], [NewTrackTime], [District], [Encrypted], [AddressHash], [SenderTaxNumber], [CabinetNO], [ThrowingRate], [ExtendedInfo], [ConsumptionNumber], [Oaid], [DemandState], [OvertimeTagType], [IsHadBlueTag]) VALUES ( 1, '202306152358145364927', '', 8464, '101356152826169', '101356152826169', N'', '', 0, 0, 0, '', '127.0.0.1', '2023-06-15 23:58:29.840', N'', '', '', 21, 0, 3035, 5312, 0, 'SGD', 5.3511001, 1.3426771, 1.0000, '1', '2023-06-15 23:50:58.000', 6.6000, .0000, 5.6000, '', .0000, 0, .0000, .0000, 0, .0000, .0000, 0, 'MIXEDCARD', N'', N'', N'Danilo Ong', N'', 1, 'SG', 'SG', N'Singapore', N'Singapore', N'545 CHOA CHU KANG STREET 52,#02-04', N'680545', '6597771033', 2, 0, 0, NULL, NULL, 2, 0, 0, '', 2, 1, 165.0000, 29.0000, '11974177,3492093', N'', N'', '0,1', 0, '', N'LXBSG000039287276', '2000-01-01 00:00:00.000', '2023-06-19 16:24:27.350', '2023-06-16 06:02:39.910', 0, N'LXBSG000039287276', NULL, '2023-06-15 23:51:06.000', '0', '2023-06-16 05:48:23.243', 0, 0, '0', '2023-06-19 16:24:27.350', '0', '0', '', '2023-06-16 06:02:35.817', 0, '0', 'D42115385', NULL, 0, 0, NULL, NULL, 0, 0, '0', NULL, NULL, NULL, NULL, '0', NULL, .0000, '2023-06-16 06:02:38.753', 0, '', 0, NULL, NULL, .0000, '', N'', .0000, 0, NULL, N'545 CHOA CHU KANG STREET 52,#02-04', N'', N'', .0000, 0, 0, NULL, N'', NULL, 0, '', 0, N'', '', '', '2023-06-17 23:50:58.000', NULL, '0', 0, 4, '0', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-16 06:02:40.130', NULL, NULL, NULL, NULL, 1686865708054, N'', 0, '251O16O53O119O227O53O98O121O65O227O120O204O7O9O156O45O54O24O226O207O222O189O62O123O36O166O81O68O40O183O180O246O88O253O159O11O184O92O97O79O88O49O102O28O43O210O251O115O160O29O48O95O213O100O40O128O224O215O133O215O230O44O243O140O', N'', N'', .95, NULL, NULL, '', NULL, NULL, '0');



    INSERT INTO [RB_OrderList] ( [CustomerID], [OrderCode], [P_S_Code], [ProductType], [SKU], [ParameterIDs], [OptionsIDs], [ParameterValues], [Standard], [ProductNum], [ProductNumUpdate], [PurchaseNum], [PurchaseType], [ProblemType], [ProductPrice], [ShippingPrice], [BuyPrice], [ActivityID], [ActivityName], [ActivityMinusPrice], [ClientSKU], [OrderItemId], [ASIN], [SellerSKU], [ItemTitle], [ItemTitleCn], [ItemMemo], [MemberID], [CookieValue], [IP], [AddTime], [GroupSKU], [GroupProductNum], [GroupProductPrice], [P_Code_Build], [P_Code_Time], [OldOrderListID], [LockNum], [LockTime], [SharePrice], [ItemListingType], [CommentType], [CheckAdminID], [CheckAdminName], [AssignDevelopAdminID], [AssignDevelopAdminName], [BuyerID], [BuyerName], [EditAdminID], [EditAdminName], [ImageAdminID], [ImageAdminName], [BusinessAdminID], [BusinessAdminName], [SellerType], [IsFBA], [ItemSite], [RefundPrincipalAmount], [RefundShippingAmount], [PromotionDiscount], [PromotionId], [AmazonDeliveryStatus], [AmazonCompeteRemark], [BusinessTeamID], [BusinessTeamName], [DevelopAdminID], [DevelopAdminName], [Marks], [GroupShippingPrice], [GroupProductNumUpdate], [LockGroupProductNum], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime], [ExtendedInfo], [StockAdminID], [StockAdminName], [DemandNormalNum], [GroupDemandNormalNum]) VALUES (  1, '202306152358145364927', '', 0, '11974177', N'', N'', N'', N'', 1, -1, 0, 0, 0, 5.6000, 1.0000, 11.4000, 0, N'', .0000, '', '', 'FP034511130236375', N'143916Y0PNV1D2', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'', N'{"ProductMainImage":"https://sg-live.slatic.net/p/fe950d299731b3535fd7518f3c4450e7.jpg","ProductDetailUrl":"https://www.lazada.sg/products/i2159765580-s12308494591.html?urlFlag=true&mp=1"}', 0, '', '', '2023-06-15 23:58:29.840', '', 0, .0000, NULL, '2023-06-16 10:32:04.127', 0, 0, NULL, .0000, NULL, 0, NULL, NULL, 0, '', 8197, '冯运新', 6289, '宋紫荆', 5754, '卢丽萍', 0, '系统管理员', NULL, '0', '', .0000, .0000, .0000, '', 0, '', 0, N'', 5326, N'徐雯雯', NULL, .0000, 0, NULL, NULL, NULL, '2023-06-19 10:12:05.767', NULL, NULL, NULL, NULL, NULL);
    INSERT INTO [RB_OrderList] ( [CustomerID], [OrderCode], [P_S_Code], [ProductType], [SKU], [ParameterIDs], [OptionsIDs], [ParameterValues], [Standard], [ProductNum], [ProductNumUpdate], [PurchaseNum], [PurchaseType], [ProblemType], [ProductPrice], [ShippingPrice], [BuyPrice], [ActivityID], [ActivityName], [ActivityMinusPrice], [ClientSKU], [OrderItemId], [ASIN], [SellerSKU], [ItemTitle], [ItemTitleCn], [ItemMemo], [MemberID], [CookieValue], [IP], [AddTime], [GroupSKU], [GroupProductNum], [GroupProductPrice], [P_Code_Build], [P_Code_Time], [OldOrderListID], [LockNum], [LockTime], [SharePrice], [ItemListingType], [CommentType], [CheckAdminID], [CheckAdminName], [AssignDevelopAdminID], [AssignDevelopAdminName], [BuyerID], [BuyerName], [EditAdminID], [EditAdminName], [ImageAdminID], [ImageAdminName], [BusinessAdminID], [BusinessAdminName], [SellerType], [IsFBA], [ItemSite], [RefundPrincipalAmount], [RefundShippingAmount], [PromotionDiscount], [PromotionId], [AmazonDeliveryStatus], [AmazonCompeteRemark], [BusinessTeamID], [BusinessTeamName], [DevelopAdminID], [DevelopAdminName], [Marks], [GroupShippingPrice], [GroupProductNumUpdate], [LockGroupProductNum], [IsBiSycnComplete], [BiSycnCompleteTime], [UpdateTime], [ExtendedInfo], [StockAdminID], [StockAdminName], [DemandNormalNum], [GroupDemandNormalNum]) VALUES ( 1, '202306152358145364927', '', 0, '3492093', N'', N'', N'', N'', 1, 0, 0, 4, 0, 5.5000, .0000, 11.6700, 0, N'', .0000, '', '101356152926169', 'FP034511130236375', N'', N'UNOMOR 2pcs Trigger Finger Splint Broken Finger Brace Adjustable Finger Protector Finger Straightener Sleeves', N'', NULL, 0, '', '193934105', '2023-06-19 10:12:04.797', '', 0, .0000, NULL, '2023-06-19 10:42:50.210', 0, 0, '2023-06-19 11:59:05.083', .0000, '', 0, NULL, NULL, 921, '邓小青', 8197, '冯运新', 2141, '沈嘉燕', 1025, '李尚辉', 3166, '王浩.lazada', NULL, '0', '', .0000, .0000, .0000, '', 0, '', 199, N'Lazada销售组', 921, N'邓小青', NULL, .0000, 0, NULL, NULL, NULL, '2023-06-19 10:12:04.797', NULL, NULL, NULL, NULL, NULL);


    SELECT  * FROM  RB_OrderInfo  WHERE OrderCode='202306152358145364927'
    SELECT top 10 * FROM RB_OrderList  WHERE OrderCode='202306152358145364927'
    -- UPDATE  RB_OrderList set SKU='1375887' WHERE OrderCode='202306152358145364927'AND ID=622869


    2.税费存入订单产品表（RB_orderlist ,ActivityMinusPrice 字段）

    SELECT ol.ActivityMinusPrice,ol.*
    FROM RB_OrderList ol WITH(NOLOCK)
    WHERE ol.CustomerID=1

    and ol.OrderCode='202307171540834159'


  6. 2023-07-17 16:24:35, 由 夏宇 完成。
    修改了 总计消耗，旧值为 "0"，新值为 "0.01"。
    修改了 实际完成，旧值为 ""，新值为 "2023-07-17 16:24:00"。
    修改了 任务状态，旧值为 "doing"，新值为 "done"。
    修改了 预计剩余，旧值为 "0.01"，新值为 "0"。
    修改了 由谁完成，旧值为 ""，新值为 "xiayu"。

  7. 2023-07-22 10:07:22, 由 夏宇 关闭。
    修改了 任务状态，旧值为 "done"，新值为 "closed"。
    修改了 指派给 ，旧值为 "xiayu"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "xiayu"。
    修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2023-07-22 10:07:22"。
    修改了 关闭原因，旧值为 ""，新值为 "done"。
所属迭代 技术研发中心 7月第3版本（2023年）
所属模块 /
相关需求 FMS：LAZADA-SG站点发货时预估8%消费税
指派给 Closed 于 2023-07-22 10:07:22
任务类型 测试
任务标签 初始
开发组
任务状态 已关闭
进度 100%
优先级 P3
关键词
抄送给
由谁创建 夏宇 于 2023-07-13 10:28:16
由谁完成 夏宇 于 2023-07-17 16:24:00
由谁取消 暂无
由谁关闭 夏宇 于 2023-07-22 10:07:22
关闭原因 已完成
最后编辑 夏宇 于 2023-07-22 10:07:22
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 7工时
总计消耗 0.01工时
预计剩余 0工时
预计开始 2023-07-13
实际开始 2023-07-17
截止日期 2023-07-20