时间: 2020-11-13 14:08:38,752 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[56f3463e-d597-4d62-bbc0-5aa848a95329] FROM Customer A INNER JOIN [##cad61bf440b74091b6912226fc4626ba] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2020-11-13 14:14:06,597 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[56f3463e-d597-4d62-bbc0-5aa848a95329] FROM Customer A INNER JOIN [##031f4d9f75454d58bbcddf428e0fcc92] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2020-11-13 15:54:38,919 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##4af254adc6034b5dae68bb6c09f2eb4e] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2020-11-13 15:54:39,132 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4af254adc6034b5dae68bb6c09f2eb4e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##8d1cf5a875e048ee945b5ad11bfdc2df] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2020-11-13 15:54:39,298 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4af254adc6034b5dae68bb6c09f2eb4e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##e223bf8740894811889883d9808132f5] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2020-11-13 15:54:39,921 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4af254adc6034b5dae68bb6c09f2eb4e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##282a028c63ac41fe8604a3205aa02e7a] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2020-11-13 15:54:41,089 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##4af254adc6034b5dae68bb6c09f2eb4e] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2020-11-13 15:54:41,090 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4af254adc6034b5dae68bb6c09f2eb4e SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2020-11-13 16:23:56,853 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH WarehouseData AS ( SELECT Warehouse_No FROM rightWare RS WHERE RS.Warehouse_No <> '全部' AND RS.UserNo = '001' UNION SELECT S.Warehouse_No FROM Warehouse S , rightWare RS WHERE RS.UserNo = '001' AND RS.Warehouse_No = '全部' ) SELECT * INTO ##2b73f632ece045d184392a3400e380ee FROM WarehouseData 时间: 2020-11-13 16:23:56,872 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域] ,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称] ,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人] ,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数] ,ShutOut AS [停用], Tag AS [虚拟仓] INTO tempdb.dbo.[1440ae39-6bc9-4f93-b827-267fe6aab957] FROM [##83c8825566774d1f9edc5f3625c25bc8] ORDER BY Warehouse_No 时间: 2020-11-13 16:57:08,503 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[56f3463e-d597-4d62-bbc0-5aa848a95329] FROM Customer A INNER JOIN [##f75694f3d6634061ab01ac1ff0547e2a] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2020-11-13 16:58:17,140 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##4f49f0508e334dd89403c452d628341b] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##4f49f0508e334dd89403c452d628341b] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##e0910932337d40f0b174cdf68114c80d] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2020-11-13 16:58:17,309 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##4f49f0508e334dd89403c452d628341b] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##4f49f0508e334dd89403c452d628341b] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##e0910932337d40f0b174cdf68114c80d] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2020-11-13 16:58:17,459 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##4f49f0508e334dd89403c452d628341b] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##4f49f0508e334dd89403c452d628341b] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##e0910932337d40f0b174cdf68114c80d] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2020-11-13 16:58:17,619 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##4f49f0508e334dd89403c452d628341b] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##4f49f0508e334dd89403c452d628341b] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##e0910932337d40f0b174cdf68114c80d] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2020-11-13 16:58:17,790 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##4f49f0508e334dd89403c452d628341b] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##4f49f0508e334dd89403c452d628341b] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##e0910932337d40f0b174cdf68114c80d] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2020-11-13 16:58:17,946 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0) FROM [##4f49f0508e334dd89403c452d628341b] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity FROM PuReceiptCompare A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##4f49f0508e334dd89403c452d628341b] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##e0910932337d40f0b174cdf68114c80d] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2020-11-13 16:58:18,113 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[78ea232a-18cd-42dd-8657-268e292721a7] FROM [##4f49f0508e334dd89403c452d628341b] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2020-11-13 17:03:17,064 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[17e44638-4cba-4263-a79b-4da955a6e269] FROM Customer A INNER JOIN [##58a8c3ba12cf453ab2a9d238c00939ed] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID