时间: 2021-03-09 13:47:10,399
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##47c793d517a148d6be873b12fae874b9 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice


    时间: 2021-03-09 13:47:17,702
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##dd649f58dc8544fb9b4f1a4006181ddd A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice


    时间: 2021-03-09 13:48:09,720
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], GS.Range AS [系列], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##cb383ef110474691b21e7bb8cb121118 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice


    时间: 2021-03-09 13:51:14,263
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], GS.Range AS [系列], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##c6f4f6cfe8e34f0eab976ed8226053d7 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice


    时间: 2021-03-09 13:51:16,871
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], GS.Range AS [系列], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##8e62d63b5cc04665a4fd23cfec003cc6 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice


    时间: 2021-03-09 13:51:26,393
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], GS.Range AS [系列], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##2c061dc791c54489a8697cf296d83737 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice


    时间: 2021-03-09 13:51:32,172
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], GS.Range AS [系列], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##393de1b1522647cc91d9b062e9571cf0 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, GS.Range, A.Long, GS.UnitPrice


    时间: 2021-03-09 13:52:02,630
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量
    , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量
    , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量
INTO [##4b89684d9be847b384bc07a4101b98c0]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-09 13:52:03,008
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4b89684d9be847b384bc07a4101b98c0] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##706eb421e8e742b9be007ef30f258073] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-09 13:52:07,549
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量
    , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量
    , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量
INTO [##bc62ee91f2e24cb093623b70c65c74f7]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-09 13:52:07,941
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##bc62ee91f2e24cb093623b70c65c74f7] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##cd313626f72043a99f318dc2bd491e89] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-09 13:52:19,655
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量
    , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量
    , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量
INTO [##37ddf5b74466482db411bab4fd141727]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-09 13:52:20,051
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##37ddf5b74466482db411bab4fd141727] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##1d0bceb9e1444512ac232780c5161762] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-09 13:52:53,593
  线程ID: 90
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量
    , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量
    , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量
INTO [##dd40b0a1531a4c2688b7377b8015211c]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-09 13:52:54,001
  线程ID: 90
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##dd40b0a1531a4c2688b7377b8015211c] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##a033922ef6884053bf1a8bd79df10efc] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-09 14:59:57,329
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量
    , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量
    , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量
INTO [##9699d1a6a1fe4113b1cbfc80fa41c193]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-09 14:59:57,725
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9699d1a6a1fe4113b1cbfc80fa41c193] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##66abe67a86a240e197a66122a25220a7] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-09 17:17:27,349
  线程ID: 40
日志级别: 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.[c660783e-576d-473b-ab9c-272d7df6e578]
FROM [##4f493bcd8ce24ce18e078fa7a917d0b3]
ORDER BY Goods_no


    时间: 2021-03-09 17:17:30,811
  线程ID: 63
日志级别: 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.[c660783e-576d-473b-ab9c-272d7df6e578]
FROM [##a8b3711aff7a4602a4a33a244184b29d]
ORDER BY Goods_no


    时间: 2021-03-09 17:26:20,948
  线程ID: 83
日志级别: 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.[c660783e-576d-473b-ab9c-272d7df6e578]
FROM [##74c9a0bd5ae74762b9416cab63a4ea2d]
ORDER BY Goods_no