时间: 2025-04-04 12:33:33,800 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##dd87141711d549be9b69e97c1d744b1f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 12:33:34,239 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##beb21757ae514bd1b05bad8d6f22efee] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-04 12:33:34,242 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dd87141711d549be9b69e97c1d744b1f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##beb21757ae514bd1b05bad8d6f22efee] 时间: 2025-04-04 12:33:34,305 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a667bf8dacb849a0834487aa591ccd88 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-04 12:33:34,308 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a667bf8dacb849a0834487aa591ccd88 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-04 12:33:34,312 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a667bf8dacb849a0834487aa591ccd88 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2025-04-04 12:33:34,345 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a667bf8dacb849a0834487aa591ccd88 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-04 12:33:34,348 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a667bf8dacb849a0834487aa591ccd88 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-04 12:33:34,352 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dd87141711d549be9b69e97c1d744b1f] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##c923d3448c41465c8e5ea8096a41cb18] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-04 12:33:34,373 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[20f145ec-18ce-4770-8a47-d2d45cc03f7b] FROM ##dd87141711d549be9b69e97c1d744b1f A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2025-04-04 12:33:45,105 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##6e9ff0e993074c89b063db3fb19849a5] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 12:33:45,531 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##29a34ffa617e4d28ad1dd319a40fd405] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-04 12:33:45,532 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6e9ff0e993074c89b063db3fb19849a5] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##29a34ffa617e4d28ad1dd319a40fd405] 时间: 2025-04-04 12:33:45,594 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8bcb41f026bc44a2bac68fd035572a3e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-04 12:33:45,596 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8bcb41f026bc44a2bac68fd035572a3e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-04 12:33:45,598 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8bcb41f026bc44a2bac68fd035572a3e a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2025-04-04 12:33:45,633 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8bcb41f026bc44a2bac68fd035572a3e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-04 12:33:45,635 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8bcb41f026bc44a2bac68fd035572a3e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-04 12:33:45,638 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6e9ff0e993074c89b063db3fb19849a5] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##cfee294f57944b76984e4c2b5f0e82e2] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-04 12:33:45,642 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[20f145ec-18ce-4770-8a47-d2d45cc03f7b] FROM ##6e9ff0e993074c89b063db3fb19849a5 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2025-04-04 14:48:03,772 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##fb8a170f705a445f91bc43e27056cfbd] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 14:48:04,174 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##de4f37e34db74eda85d1b6c459bb9a45] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-04 14:48:04,177 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##fb8a170f705a445f91bc43e27056cfbd] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##de4f37e34db74eda85d1b6c459bb9a45] 时间: 2025-04-04 14:48:04,234 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##078c00268f3b4775bcd04921cfe409aa a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-04 14:48:04,237 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##078c00268f3b4775bcd04921cfe409aa SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-04 14:48:04,240 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##078c00268f3b4775bcd04921cfe409aa a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2025-04-04 14:48:04,267 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##078c00268f3b4775bcd04921cfe409aa SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-04 14:48:04,270 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##078c00268f3b4775bcd04921cfe409aa SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-04 14:48:04,274 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##fb8a170f705a445f91bc43e27056cfbd] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##3e3e68e29d2047239bfd713b124f1904] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-04 14:48:04,277 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[3d3ed6e2-39e2-464b-9d2a-31fd01b0e2a7] FROM ##fb8a170f705a445f91bc43e27056cfbd A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2025-04-04 14:48:31,926 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##88847854360d4d82896ecc5d01229843] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 14:48:32,317 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a28e851e03fd4563a23693bed9ba9779] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-04 14:48:32,319 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##88847854360d4d82896ecc5d01229843] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a28e851e03fd4563a23693bed9ba9779] 时间: 2025-04-04 14:48:32,377 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##26ad0a1b985949e3a7d2aa99dcbb3767 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-04 14:48:32,380 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##26ad0a1b985949e3a7d2aa99dcbb3767 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-04 14:48:32,383 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##26ad0a1b985949e3a7d2aa99dcbb3767 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2025-04-04 14:48:32,420 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##26ad0a1b985949e3a7d2aa99dcbb3767 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-04 14:48:32,422 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##26ad0a1b985949e3a7d2aa99dcbb3767 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-04 14:48:32,426 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##88847854360d4d82896ecc5d01229843] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##5340ae853eb7484b92c4607ef3d9a7fa] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-04 14:48:32,431 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[3d3ed6e2-39e2-464b-9d2a-31fd01b0e2a7] FROM ##88847854360d4d82896ecc5d01229843 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2025-04-04 14:48:33,693 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##5762d6448de547bab6c02a2d42047299] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 14:48:34,079 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##43ff547ce375441a8c24772edf5dbba8] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-04 14:48:34,080 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5762d6448de547bab6c02a2d42047299] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##43ff547ce375441a8c24772edf5dbba8] 时间: 2025-04-04 14:48:34,138 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##79571613e65e45bda8c576b0ad9be66b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-04 14:48:34,140 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##79571613e65e45bda8c576b0ad9be66b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-04 14:48:34,142 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##79571613e65e45bda8c576b0ad9be66b a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2025-04-04 14:48:34,168 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##79571613e65e45bda8c576b0ad9be66b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-04 14:48:34,169 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##79571613e65e45bda8c576b0ad9be66b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-04 14:48:34,173 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5762d6448de547bab6c02a2d42047299] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##705fa669eaa94430a9dee35875777d2c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-04 14:48:34,177 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[3d3ed6e2-39e2-464b-9d2a-31fd01b0e2a7] FROM ##5762d6448de547bab6c02a2d42047299 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2025-04-04 14:48:49,617 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##896be404eac648f6a1c3b9a07f39838e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 14:48:49,989 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##5145419b56774796984c80076fc13aba] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-04 14:48:49,991 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##896be404eac648f6a1c3b9a07f39838e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5145419b56774796984c80076fc13aba] 时间: 2025-04-04 14:48:50,046 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b74fd5f0cc224cb98c4e182c2954ee33 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-04 14:48:50,048 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b74fd5f0cc224cb98c4e182c2954ee33 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-04 14:48:50,050 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b74fd5f0cc224cb98c4e182c2954ee33 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2025-04-04 14:48:50,081 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b74fd5f0cc224cb98c4e182c2954ee33 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-04 14:48:50,082 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b74fd5f0cc224cb98c4e182c2954ee33 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-04 14:48:50,086 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##896be404eac648f6a1c3b9a07f39838e] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##2f854cb494ba427a80b9695e1f30a00b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-04 14:48:50,091 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[0f5a198e-425c-4c75-9568-eda834c90daf] FROM ##896be404eac648f6a1c3b9a07f39838e A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2025-04-04 15:27:13,543 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##c930fc2a729a43c681ce987cfb3d1bdf] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 15:27:13,557 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##c930fc2a729a43c681ce987cfb3d1bdf Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##c930fc2a729a43c681ce987cfb3d1bdf] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No ORDER BY A.Goods_No 时间: 2025-04-04 15:27:21,021 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##4d9b492a3f254fc3827d6d4e03dca574] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 15:27:21,111 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4d9b492a3f254fc3827d6d4e03dca574] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##c1d0dfe8d6974c078c7d6537192df475] 时间: 2025-04-04 15:27:21,116 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##4d9b492a3f254fc3827d6d4e03dca574 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##4d9b492a3f254fc3827d6d4e03dca574] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) ORDER BY A.Goods_No 时间: 2025-04-04 15:27:27,795 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##721b6a36859c4549938f35a4cf757c49] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 15:27:27,887 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##721b6a36859c4549938f35a4cf757c49] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##969ebf1a210b42bd93e71e59a8131361] 时间: 2025-04-04 15:27:27,957 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##721b6a36859c4549938f35a4cf757c49] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##a3d9be7827b54d2aa90cce8afd31d0ed] 时间: 2025-04-04 15:27:28,028 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##721b6a36859c4549938f35a4cf757c49] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##d2b5c2fc2f9448b69940bc9b5d552487] 时间: 2025-04-04 15:27:28,031 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##721b6a36859c4549938f35a4cf757c49 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##721b6a36859c4549938f35a4cf757c49] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) ORDER BY A.Goods_No 时间: 2025-04-04 16:57:32,584 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##296f070eb1b748daa45fb54f9005042e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 16:57:33,007 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4eff4b3b470f4e658068ac3b89ac6ecd] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-04 16:57:33,009 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##296f070eb1b748daa45fb54f9005042e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4eff4b3b470f4e658068ac3b89ac6ecd] 时间: 2025-04-04 16:57:33,069 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2cabfef161db43529b05eefc0b5f95fb a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-04 16:57:33,072 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2cabfef161db43529b05eefc0b5f95fb SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-04 16:57:33,074 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2cabfef161db43529b05eefc0b5f95fb a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2025-04-04 16:57:33,105 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2cabfef161db43529b05eefc0b5f95fb SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-04 16:57:33,107 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2cabfef161db43529b05eefc0b5f95fb SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-04 16:57:33,111 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##296f070eb1b748daa45fb54f9005042e] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##ec77bdd57ff346c580a2dbbd2476af94] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-04 16:57:33,115 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[aa892191-4b7b-43b7-ba06-10bb6b0d83b6] FROM ##296f070eb1b748daa45fb54f9005042e A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2025-04-04 19:42:21,969 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##c9323e64189c435b91a0ba2997e6a298] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:42:22,049 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c9323e64189c435b91a0ba2997e6a298] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##9c4b6e52f32347c69cab0ebcf382b43e] 时间: 2025-04-04 19:42:22,106 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c9323e64189c435b91a0ba2997e6a298] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##7cc81410ce104610bf1ff28697ae341f] 时间: 2025-04-04 19:42:22,163 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c9323e64189c435b91a0ba2997e6a298] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##e9d6d5b15db74876ae76c3407fb1c3b0] 时间: 2025-04-04 19:42:22,166 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##c9323e64189c435b91a0ba2997e6a298 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##c9323e64189c435b91a0ba2997e6a298] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) ORDER BY A.Goods_No 时间: 2025-04-04 19:42:35,100 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##6b1be848a4bf4f2887bf25a78430dbfa] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:42:35,184 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6b1be848a4bf4f2887bf25a78430dbfa] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##da7ff4b16578485289cb69905817300c] 时间: 2025-04-04 19:42:35,238 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6b1be848a4bf4f2887bf25a78430dbfa] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##516ae709d8564e3a9a12539115a01e9c] 时间: 2025-04-04 19:42:35,298 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6b1be848a4bf4f2887bf25a78430dbfa] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##58249f2d2f7b4acbae0caa6c53b920d2] 时间: 2025-04-04 19:42:35,302 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##6b1be848a4bf4f2887bf25a78430dbfa Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], A.Customer_ID AS [渠道编号] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##6b1be848a4bf4f2887bf25a78430dbfa] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No, A.Customer_ID HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) ORDER BY A.Goods_No, A.Customer_ID 时间: 2025-04-04 19:42:36,404 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##5c6b963b48a442499b2a21c9c389feaf] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:42:36,487 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5c6b963b48a442499b2a21c9c389feaf] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##8b6e74ad59054e5981793c8e24f92080] 时间: 2025-04-04 19:42:36,549 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5c6b963b48a442499b2a21c9c389feaf] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##c3eb4a24a5cc4efd8c57cded8b8cca05] 时间: 2025-04-04 19:42:36,610 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5c6b963b48a442499b2a21c9c389feaf] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##e48ca9cb53b2431c8f3504eac3c06c43] 时间: 2025-04-04 19:42:36,613 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##5c6b963b48a442499b2a21c9c389feaf Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], A.Customer_ID AS [渠道编号] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##5c6b963b48a442499b2a21c9c389feaf] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No, A.Customer_ID HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) ORDER BY A.Goods_No, A.Customer_ID 时间: 2025-04-04 19:44:10,178 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##ddfce94c0b3e47a5aecabdf52e898808] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:44:10,275 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ddfce94c0b3e47a5aecabdf52e898808] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##889d3d39c79e49d9a2bd324260d7ef95] 时间: 2025-04-04 19:44:10,340 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ddfce94c0b3e47a5aecabdf52e898808] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##4dd00cb6d6514e6d9d3441a7da0afb4a] 时间: 2025-04-04 19:44:10,402 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ddfce94c0b3e47a5aecabdf52e898808] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##3fe4949e697f4321a6982e0984ffe92b] 时间: 2025-04-04 19:44:10,405 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##ddfce94c0b3e47a5aecabdf52e898808 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##ddfce94c0b3e47a5aecabdf52e898808] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No, A.Customer_ID, CT.Abbrev HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) ORDER BY A.Goods_No, A.Customer_ID, CT.Abbrev 时间: 2025-04-04 19:44:19,151 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##22754a09c06d4be1af2eaa73d8949db6] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:44:19,231 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##22754a09c06d4be1af2eaa73d8949db6] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##e03498a643b54bfda8a2f844ea7d3fcb] 时间: 2025-04-04 19:44:19,298 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##22754a09c06d4be1af2eaa73d8949db6] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##942c1c7500b94f1d9902e48ea2488b9e] 时间: 2025-04-04 19:44:19,364 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##22754a09c06d4be1af2eaa73d8949db6] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##49bd5afbd9c84c19b44a6358b5dd74d4] 时间: 2025-04-04 19:44:19,402 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##22754a09c06d4be1af2eaa73d8949db6] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##64d16d8c6f1c4100a60692234a2c3c35] 时间: 2025-04-04 19:44:19,405 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##22754a09c06d4be1af2eaa73d8949db6 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##22754a09c06d4be1af2eaa73d8949db6] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No, A.Customer_ID, CT.Abbrev HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY A.Goods_No, A.Customer_ID, CT.Abbrev 时间: 2025-04-04 19:44:20,451 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##250ba9bd683c4451b44c185b5bccd764] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:44:20,547 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##250ba9bd683c4451b44c185b5bccd764] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##994d61276922443991f6a796f4fc94ea] 时间: 2025-04-04 19:44:20,613 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##250ba9bd683c4451b44c185b5bccd764] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##3892c6e561844a3a9dd6c027fd4e07ee] 时间: 2025-04-04 19:44:20,683 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##250ba9bd683c4451b44c185b5bccd764] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##32c31c8003ba4ebb80e06c535c7d2033] 时间: 2025-04-04 19:44:20,718 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##250ba9bd683c4451b44c185b5bccd764] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##530f66ef37bc45caa4cc2c337ed026ad] 时间: 2025-04-04 19:44:20,722 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##250ba9bd683c4451b44c185b5bccd764 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##250ba9bd683c4451b44c185b5bccd764] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No, A.Customer_ID, CT.Abbrev HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY A.Goods_No, A.Customer_ID, CT.Abbrev 时间: 2025-04-04 19:44:21,516 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##c33feee5c96743b0b4aa689e4301c3ad] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:44:21,595 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c33feee5c96743b0b4aa689e4301c3ad] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##2abd62bafb594ed89705a2facf536ddb] 时间: 2025-04-04 19:44:21,655 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c33feee5c96743b0b4aa689e4301c3ad] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##7d85d7dfd5e4499297f9e2f9fbae435e] 时间: 2025-04-04 19:44:21,715 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c33feee5c96743b0b4aa689e4301c3ad] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##84e2f57b3feb41c7b0440699cb1908c3] 时间: 2025-04-04 19:44:21,751 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c33feee5c96743b0b4aa689e4301c3ad] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##fb39e110eb9a4a1d99c147f1f1848590] 时间: 2025-04-04 19:44:21,755 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##c33feee5c96743b0b4aa689e4301c3ad Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##c33feee5c96743b0b4aa689e4301c3ad] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY A.Goods_No, A.Customer_ID, CT.Abbrev HAVING (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY A.Goods_No, A.Customer_ID, CT.Abbrev 时间: 2025-04-04 19:44:56,076 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##a985ccd5e6cd42c29f813be4c236a146] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:44:56,522 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##7086b7dccedd4f4c9b42831412303eef] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-04 19:44:56,524 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a985ccd5e6cd42c29f813be4c236a146] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7086b7dccedd4f4c9b42831412303eef] 时间: 2025-04-04 19:44:56,590 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##bf3f41a4584a46418c8c4d987a6b52b1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-04 19:44:56,592 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bf3f41a4584a46418c8c4d987a6b52b1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-04 19:44:56,593 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##bf3f41a4584a46418c8c4d987a6b52b1 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2025-04-04 19:44:56,628 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bf3f41a4584a46418c8c4d987a6b52b1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-04 19:44:56,630 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bf3f41a4584a46418c8c4d987a6b52b1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-04 19:44:56,633 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a985ccd5e6cd42c29f813be4c236a146] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##e682d72a4e6b4f82b3b3c2f86ddbcb91] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-04 19:44:56,638 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[aa892191-4b7b-43b7-ba06-10bb6b0d83b6] FROM ##a985ccd5e6cd42c29f813be4c236a146 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2025-04-04 19:45:04,427 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) AS [累计销售#生意额], CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##e06a233930e449d2b7e5dfef207cd988] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-04 19:45:04,835 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d9e134cbb0d04ae683271629cea804f8] 时间: 2025-04-04 19:45:04,893 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##c80c569dee444ca091b588083ec11ff5] 时间: 2025-04-04 19:45:04,947 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##85be1462a07e4799bc6665682b423daf] 时间: 2025-04-04 19:45:05,016 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道收货#S1], 渠道收货#数量, 渠道收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##10bd618f4fed4e42aefe19d9432ba708] 时间: 2025-04-04 19:45:05,095 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, 第一次到货日期) SELECT Customer_ID, Goods_No, ColorID, Long, 第一次到货日期 FROM [##accaa5c165dd4bb1bf4d8d14c7920b4c] 时间: 2025-04-04 19:45:05,151 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道退货#S1], 渠道退货#数量, 渠道退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##8db759da4acb4eb0a7679d1b8f11ceb9] 时间: 2025-04-04 19:45:05,212 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道调出#S1], 渠道调出#数量, 渠道调出#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##b4b15b4608fc4fd28a88feed7607dbc5] 时间: 2025-04-04 19:45:05,274 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道调入#S1], 渠道调入#数量, 渠道调入#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##f63cd8e29eae4f53b469f8b0f50b533e] 时间: 2025-04-04 19:45:05,324 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道损益#S1], 渠道损益#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5b7af757a88b45f68a1a954cba442b15] 时间: 2025-04-04 19:45:05,403 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##905596ce521f47b4bb5a41d8fd08c393] 时间: 2025-04-04 19:45:05,463 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##d73d9346d97d4d499419a37b42eb8e67] 时间: 2025-04-04 19:45:05,525 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##16f7ec483ed549c093212410f87fc57f] 时间: 2025-04-04 19:45:05,563 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##8d4be7e9892b4428abe9c4c65d511112] 时间: 2025-04-04 19:45:05,603 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上退货#S1], [渠道销售#线上退货#数量], [渠道销售#线上退货#生意额], [渠道销售#线上退货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##77ec86fd58fa428b91e097d7bff79361] 时间: 2025-04-04 19:45:05,684 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [累计销售#S1], [累计销售#数量],[累计销售#生意额], [累计销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##b49d52d8019347ad860a078d61932877] 时间: 2025-04-04 19:45:06,027 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e06a233930e449d2b7e5dfef207cd988] (Customer_ID, Goods_No, ColorID, Long, [在途库存#S1], [在途库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##def08bbb9d0f4e72b9dc8a3f81638944] 时间: 2025-04-04 19:45:06,041 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e06a233930e449d2b7e5dfef207cd988] SET 期末库存#数量 = ISNULL(期初库存#数量,0) + ISNULL(渠道采购收货#数量,0) - ISNULL(渠道采购退货#数量,0) + ISNULL(渠道收货#数量,0) - ISNULL(渠道退货#数量,0) - ISNULL(渠道调出#数量,0) + ISNULL(渠道调入#数量,0) - ISNULL(渠道损益#数量,0) - ISNULL(渠道销售#正常销售#数量,0) - ISNULL(渠道销售#线上发货#数量,0) - ISNULL(渠道销售#线上退货#数量,0), [期末库存#S1] = ISNULL([期初库存#S1], 0) + ISNULL(渠道采购收货#S1,0) - ISNULL(渠道采购退货#S1,0) + ISNULL(渠道收货#S1,0) - ISNULL(渠道退货#S1,0) - ISNULL(渠道调出#S1,0) + ISNULL(渠道调入#S1,0) - ISNULL(渠道损益#S1,0) - ISNULL(渠道销售#正常销售#S1,0) - ISNULL(渠道销售#线上发货#S1,0) - ISNULL(渠道销售#线上退货#S1,0) 时间: 2025-04-04 19:45:06,045 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e06a233930e449d2b7e5dfef207cd988] SET 库存合计#数量 = ISNULL(期末库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([期末库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2025-04-04 19:45:06,160 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Customer_ID] AS Customer_ID INTO [##0c2f71c402fd41649c103bd5c59e9833] FROM [##e06a233930e449d2b7e5dfef207cd988] 时间: 2025-04-04 19:45:06,163 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Goods_No] AS Goods_No, [ColorID] AS ColorID INTO [##7470b126fdf0492690171cb14a030624] FROM [##e06a233930e449d2b7e5dfef207cd988] 时间: 2025-04-04 19:45:06,230 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##e06a233930e449d2b7e5dfef207cd988 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], SUM([渠道销售#正常销售#S1]) AS [渠道销售#正常销售#S1], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售#数量], SUM([渠道销售#正常销售#数量] * GS.UnitPrice) AS [渠道销售#正常销售#吊牌额], SUM([渠道销售#正常销售#数量] * GDP.DpPriceByRetail) AS [渠道销售#正常销售#渠道吊牌额], SUM([渠道销售#正常销售#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#正常销售#零售额], SUM([渠道销售#正常销售#生意额]) AS [渠道销售#正常销售#生意额], SUM([渠道销售#正常销售#结算额]) AS [渠道销售#正常销售#结算额], SUM([渠道销售#预售自提#S1]) AS [渠道销售#预售自提#S1], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提#数量], SUM([渠道销售#预售自提#数量] * GS.UnitPrice) AS [渠道销售#预售自提#吊牌额], SUM([渠道销售#预售自提#数量] * GDP.DpPriceByRetail) AS [渠道销售#预售自提#渠道吊牌额], SUM([渠道销售#预售自提#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#预售自提#零售额], SUM([渠道销售#预售自提#生意额]) AS [渠道销售#预售自提#生意额], SUM([渠道销售#预售自提#结算额]) AS [渠道销售#预售自提#结算额], SUM([渠道销售#预售直发#S1]) AS [渠道销售#预售直发#S1], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发#数量], SUM([渠道销售#预售直发#数量] * GS.UnitPrice) AS [渠道销售#预售直发#吊牌额], SUM([渠道销售#预售直发#数量] * GDP.DpPriceByRetail) AS [渠道销售#预售直发#渠道吊牌额], SUM([渠道销售#预售直发#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#预售直发#零售额], SUM([渠道销售#预售直发#生意额]) AS [渠道销售#预售直发#生意额], SUM([渠道销售#预售直发#结算额]) AS [渠道销售#预售直发#结算额], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], SUM([渠道销售#线上发货#S1]) AS [渠道销售#线上发货#S1], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货#数量], SUM([渠道销售#线上发货#数量] * GS.UnitPrice) AS [渠道销售#线上发货#吊牌额], SUM([渠道销售#线上发货#数量] * GDP.DpPriceByRetail) AS [渠道销售#线上发货#渠道吊牌额], SUM([渠道销售#线上发货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#线上发货#零售额], SUM([渠道销售#线上发货#生意额]) AS [渠道销售#线上发货#生意额], SUM([渠道销售#线上发货#结算额]) AS [渠道销售#线上发货#结算额], SD.Tin_Date AS [到店日期], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], DC.ColorGroup AS [颜色组], A.Long AS [内长], SUM([期初库存#S1]) AS [期初库存#S1], SUM([期初库存#数量]) AS [期初库存#数量], SUM([期初库存#数量] * GS.UnitPrice) AS [期初库存#吊牌额], SUM([期初库存#数量] * GDP.DpPriceByRetail) AS [期初库存#渠道吊牌额], SUM([期初库存#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [期初库存#零售额], SUM([渠道采购收货#S1]) AS [渠道采购收货#S1], SUM([渠道采购收货#数量]) AS [渠道采购收货#数量], SUM([渠道采购收货#数量] * GS.UnitPrice) AS [渠道采购收货#吊牌额], SUM([渠道采购收货#数量] * GDP.DpPriceByRetail) AS [渠道采购收货#渠道吊牌额], SUM([渠道采购收货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道采购收货#零售额], SUM([渠道采购收货#金额]) AS [渠道采购收货#金额], SUM([渠道采购退货#S1]) AS [渠道采购退货#S1], SUM([渠道采购退货#数量]) AS [渠道采购退货#数量], SUM([渠道采购退货#数量] * GS.UnitPrice) AS [渠道采购退货#吊牌额], SUM([渠道采购退货#数量] * GDP.DpPriceByRetail) AS [渠道采购退货#渠道吊牌额], SUM([渠道采购退货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道采购退货#零售额], SUM([渠道采购退货#金额]) AS [渠道采购退货#金额], SUM([渠道收货#S1]) AS [渠道收货#S1], SUM([渠道收货#数量]) AS [渠道收货#数量], SUM([渠道收货#数量] * GS.UnitPrice) AS [渠道收货#吊牌额], SUM([渠道收货#数量] * GDP.DpPriceByRetail) AS [渠道收货#渠道吊牌额], SUM([渠道收货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道收货#零售额], SUM([渠道收货#金额]) AS [渠道收货#金额], SUM([渠道退货#S1]) AS [渠道退货#S1], SUM([渠道退货#数量]) AS [渠道退货#数量], SUM([渠道退货#数量] * GS.UnitPrice) AS [渠道退货#吊牌额], SUM([渠道退货#数量] * GDP.DpPriceByRetail) AS [渠道退货#渠道吊牌额], SUM([渠道退货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道退货#零售额], SUM([渠道退货#金额]) AS [渠道退货#金额], SUM([渠道调出#S1]) AS [渠道调出#S1], SUM([渠道调出#数量]) AS [渠道调出#数量], SUM([渠道调出#数量] * GS.UnitPrice) AS [渠道调出#吊牌额], SUM([渠道调出#数量] * GDP.DpPriceByRetail) AS [渠道调出#渠道吊牌额], SUM([渠道调出#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道调出#零售额], SUM([渠道调出#金额]) AS [渠道调出#金额], SUM([渠道调入#S1]) AS [渠道调入#S1], SUM([渠道调入#数量]) AS [渠道调入#数量], SUM([渠道调入#数量] * GS.UnitPrice) AS [渠道调入#吊牌额], SUM([渠道调入#数量] * GDP.DpPriceByRetail) AS [渠道调入#渠道吊牌额], SUM([渠道调入#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道调入#零售额], SUM([渠道调入#金额]) AS [渠道调入#金额], SUM([渠道损益#S1]) AS [渠道损益#S1], SUM([渠道损益#数量]) AS [渠道损益#数量], SUM([渠道损益#数量] * GS.UnitPrice) AS [渠道损益#吊牌额], SUM([渠道损益#数量] * GDP.DpPriceByRetail) AS [渠道损益#渠道吊牌额], SUM([渠道损益#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道损益#零售额], SUM([渠道销售#线上退货#S1]) AS [渠道销售#线上退货#S1], SUM([渠道销售#线上退货#数量]) AS [渠道销售#线上退货#数量], SUM([渠道销售#线上退货#数量] * GS.UnitPrice) AS [渠道销售#线上退货#吊牌额], SUM([渠道销售#线上退货#数量] * GDP.DpPriceByRetail) AS [渠道销售#线上退货#渠道吊牌额], SUM([渠道销售#线上退货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#线上退货#零售额], SUM([渠道销售#线上退货#生意额]) AS [渠道销售#线上退货#生意额], SUM([渠道销售#线上退货#结算额]) AS [渠道销售#线上退货#结算额], SUM([累计销售#S1]) AS [累计销售#S1], SUM([累计销售#数量]) AS [累计销售#数量], SUM([累计销售#数量] * GS.UnitPrice) AS [累计销售#吊牌额], SUM([累计销售#数量] * GDP.DpPriceByRetail) AS [累计销售#渠道吊牌额], SUM([累计销售#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [累计销售#零售额], SUM([累计销售#生意额]) AS [累计销售#生意额], SUM([累计销售#结算额]) AS [累计销售#结算额], SUM([期末库存#S1]) AS [期末库存#S1], SUM([期末库存#数量]) AS [期末库存#数量], SUM([期末库存#数量] * GS.UnitPrice) AS [期末库存#吊牌额], SUM([期末库存#数量] * GDP.DpPriceByRetail) AS [期末库存#渠道吊牌额], SUM([期末库存#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [期末库存#零售额], SUM([在途库存#S1]) AS [在途库存#S1], SUM([在途库存#数量]) AS [在途库存#数量], SUM([在途库存#数量] * GS.UnitPrice) AS [在途库存#吊牌额], SUM([在途库存#数量] * GDP.DpPriceByRetail) AS [在途库存#渠道吊牌额], SUM([在途库存#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [在途库存#零售额], SUM([库存合计#S1]) AS [库存合计#S1], SUM([库存合计#数量]) AS [库存合计#数量], SUM([库存合计#数量] * GS.UnitPrice) AS [库存合计#吊牌额], SUM([库存合计#数量] * GDP.DpPriceByRetail) AS [库存合计#渠道吊牌额], SUM([库存合计#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [库存合计#零售额], ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail) AS [零售价], convert(varchar,min(第一次到货日期),23) AS [第一次到货日期], GS.UnitPrice AS [吊牌价], GDP.DpPriceByRetail AS [渠道吊牌价], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[fea790d1-8b27-45ad-8bfc-ef9e6897c873] FROM [##e06a233930e449d2b7e5dfef207cd988] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No INNER JOIN vGoodsDpPrice GDP ON A.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No LEFT JOIN [##ffd0a2e92e1744cebbe7d62f917a741a] CP ON A.Customer_ID = CP.Customer_ID AND A.Goods_No = CP.Goods_No LEFT JOIN [##d99a461522cb4374bce8af0c924f1079] CPC ON A.Customer_ID = CPC.Customer_ID AND A.Goods_No = CPC.Goods_No AND A.ColorID = CPC.ColorID GROUP BY A.Goods_No, A.Customer_ID, CT.Abbrev, SD.Tin_Date, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Long, ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail), GS.UnitPrice, GDP.DpPriceByRetail HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR SUM([渠道采购收货#金额]) <> 0 OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR SUM([渠道采购退货#金额]) <> 0 OR (ISNULL(SUM([渠道收货#S1]), 0) <> 0) OR SUM([渠道收货#金额]) <> 0 OR (ISNULL(SUM([渠道退货#S1]), 0) <> 0) OR SUM([渠道退货#金额]) <> 0 OR (ISNULL(SUM([渠道调出#S1]), 0) <> 0) OR SUM([渠道调出#金额]) <> 0 OR (ISNULL(SUM([渠道调入#S1]), 0) <> 0) OR SUM([渠道调入#金额]) <> 0 OR (ISNULL(SUM([渠道损益#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR SUM([渠道销售#正常销售#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR SUM([渠道销售#预售直发#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) OR SUM([渠道销售#预售自提#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) OR SUM([渠道销售#线上发货#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#线上退货#S1]), 0) <> 0) OR SUM([渠道销售#线上退货#生意额]) <> 0 OR (ISNULL(SUM([累计销售#S1]), 0) <> 0) OR SUM([累计销售#生意额]) <> 0 OR (ISNULL(SUM([在途库存#S1]), 0) <> 0) ORDER BY A.Goods_No, A.Customer_ID, CT.Abbrev, SD.Tin_Date, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Long, ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail), GS.UnitPrice, GDP.DpPriceByRetail