时间: 2021-07-08 11:28:13,049 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a173264f-1f24-4dea-a4a7-6724dc01c3e8] FROM [##f9ffc74807f84de5929fafae7f6b8ea5] ORDER BY Goods_no 时间: 2021-07-08 11:28:18,603 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a173264f-1f24-4dea-a4a7-6724dc01c3e8] FROM [##6810c121787849508f1759d7ddd2c526] ORDER BY Goods_no 时间: 2021-07-08 11:44:40,838 线程ID: 32 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##2548e26b90a349fe92650fc2484ee125] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-08 11:44:41,694 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3167e5027c9a4f909941b29bc4efabb3] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-08 11:44:41,918 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2548e26b90a349fe92650fc2484ee125] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3167e5027c9a4f909941b29bc4efabb3] 时间: 2021-07-08 11:44:42,145 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##04965489afd249028aad6f0302c47a16 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-08 11:44:42,176 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##04965489afd249028aad6f0302c47a16 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-08 11:44:42,220 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##04965489afd249028aad6f0302c47a16 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 = '退货' 时间: 2021-07-08 11:44:42,269 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##04965489afd249028aad6f0302c47a16 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-08 11:44:42,271 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##04965489afd249028aad6f0302c47a16 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-08 11:44:42,307 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2548e26b90a349fe92650fc2484ee125] (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 [##245358b8f2c94bd4afe237ddab19efb4] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-08 11:44:42,345 线程ID: 32 日志级别: 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.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##2548e26b90a349fe92650fc2484ee125 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 时间: 2021-07-08 11:45:11,301 线程ID: 27 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##3aa1ce8a240748d6b6f1236fa1f6cce9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-08 11:45:12,197 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a70d4017fa3c472a913f06c4335a6422] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-08 11:45:12,202 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3aa1ce8a240748d6b6f1236fa1f6cce9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a70d4017fa3c472a913f06c4335a6422] 时间: 2021-07-08 11:45:12,396 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##16a39a467a5e41afa43f2ed77fd05ad2 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-08 11:45:12,424 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##16a39a467a5e41afa43f2ed77fd05ad2 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-08 11:45:12,437 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##16a39a467a5e41afa43f2ed77fd05ad2 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 = '退货' 时间: 2021-07-08 11:45:12,483 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##16a39a467a5e41afa43f2ed77fd05ad2 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-08 11:45:12,485 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##16a39a467a5e41afa43f2ed77fd05ad2 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-08 11:45:12,510 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3aa1ce8a240748d6b6f1236fa1f6cce9] (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 [##77dfd0af7c9c46eba8c14084e80592ad] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-08 11:45:12,553 线程ID: 27 日志级别: 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.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##3aa1ce8a240748d6b6f1236fa1f6cce9 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 时间: 2021-07-08 11:47:01,375 线程ID: 27 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##aad55b6c984944b48c43f2279bf43337] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-08 11:47:02,200 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3b8bf1a130fe4f31a3deddc95090e012] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-08 11:47:02,204 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##aad55b6c984944b48c43f2279bf43337] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3b8bf1a130fe4f31a3deddc95090e012] 时间: 2021-07-08 11:47:02,419 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##bab6bc836b70466895693c0f96e6f633 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-08 11:47:02,471 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bab6bc836b70466895693c0f96e6f633 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-08 11:47:02,483 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##bab6bc836b70466895693c0f96e6f633 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 = '退货' 时间: 2021-07-08 11:47:02,526 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bab6bc836b70466895693c0f96e6f633 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-08 11:47:02,529 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bab6bc836b70466895693c0f96e6f633 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-08 11:47:02,555 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##aad55b6c984944b48c43f2279bf43337] (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 [##1d372d3fa5ff4066b587547900f0cacc] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-08 11:47:02,588 线程ID: 27 日志级别: 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 [渠道库存] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##aad55b6c984944b48c43f2279bf43337 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 ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice 时间: 2021-07-08 12:00:50,203 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a173264f-1f24-4dea-a4a7-6724dc01c3e8] FROM [##65902111a0d04d87ace7adfffdaa5b3c] ORDER BY Goods_no 时间: 2021-07-08 16:08:04,963 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[01591017-2fe0-4ab7-8c01-67ce335a6917] FROM Customer A INNER JOIN [##e5d6965468f64c4aae3b4ff5f6a89bb3] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID