2022/8/11 9:58:39 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123159-163')
|
|
2022/8/11 9:58:39 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123159-163')
|
|
2022/8/11 17:36:17 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728')
|
|
2022/8/11 17:36:17 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728')
|
|
2022/8/11 17:36:18 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 17:36:18 ReportDataSet:0
|
|
2022/8/11 17:36:39 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728','12500117-5830')
|
|
2022/8/11 17:36:39 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728','12500117-5830')
|
|
2022/8/11 17:36:39 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 17:36:39 ReportDataSet:0
|
|
2022/8/11 17:37:18 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('12500063-5817','12500117-5830')
|
|
2022/8/11 17:37:18 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('12500063-5817','12500117-5830')
|
|
2022/8/11 17:37:18 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 17:37:18 ReportDataSet:0
|
|
2022/8/11 17:44:51 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2729')
|
|
2022/8/11 17:44:51 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2729')
|
|
2022/8/11 17:44:51 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 17:44:51 ReportDataSet:0
|
|
2022/8/11 17:45:07 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2729')
|
|
2022/8/11 17:45:07 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2729')
|
|
2022/8/11 17:45:07 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 17:45:07 ReportDataSet:0
|
|
2022/8/11 17:48:28 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728')
|
|
2022/8/11 17:48:28 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728')
|
|
2022/8/11 17:48:28 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 17:48:28 ReportDataSet:0
|
|
2022/8/11 17:56:08 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('12360550-2981','12481123-5304')
|
|
2022/8/11 17:56:09 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,p.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
JOIN Sc_PPBomBillMain p ON b.HSourceEntryID = p.HICMOEntryID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('12360550-2981','12481123-5304')
|
|
2022/8/11 17:56:09 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 17:56:09 ReportDataSet:0
|
|
2022/8/11 18:05:56 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,pm.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
left JOIN Sc_PPBomBillSub p ON b.HSourceEntryID = p.HInterID
|
left JOIN Sc_PPBomBillMain pm ON p.HInterID=pm.HInterID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2729','123865-3394')
|
|
2022/8/11 18:05:56 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,pm.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
left JOIN Sc_PPBomBillSub p ON b.HSourceEntryID = p.HInterID
|
left JOIN Sc_PPBomBillMain pm ON p.HInterID=pm.HInterID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2729','123865-3394')
|
|
2022/8/11 18:05:56 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 18:05:56 ReportDataSet:2
|
|
2022/8/11 18:49:18 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,pm.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
left JOIN Sc_PPBomBillSub p ON b.HSourceEntryID = p.HInterID
|
left JOIN Sc_PPBomBillMain pm ON p.HInterID=pm.HInterID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728','123371-2729')
|
|
2022/8/11 18:49:18 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,pm.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
left JOIN Sc_PPBomBillSub p ON b.HSourceEntryID = p.HInterID
|
left JOIN Sc_PPBomBillMain pm ON p.HInterID=pm.HInterID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728','123371-2729')
|
|
2022/8/11 18:50:49 select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,pm.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
left JOIN Sc_PPBomBillSub p ON b.HSourceEntryID = p.HInterID
|
left JOIN Sc_PPBomBillMain pm ON p.HInterID=pm.HInterID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728','123371-2729')
|
|
2022/8/11 18:50:49 打印sql:select b.HInterID,b.HEntryID,a.HDate as 日期,m.HNumber as 物料代码,m.HName as 物料名称,m.HModel as 规格型号,
|
b.HPieceQty as 件数,b.HQty as 数量,a.HBillNo as 领料单号,pm.HBillNo as 源单单号,b.HMaker 制单人,u.HName 计量单位
|
from Kf_ICStockBillMain a
|
left join KF_ICSTOCKBILLSUB_WMS b on b.HInterID=a.HInterID
|
left join Gy_Material m on b.HMaterID=m.HItemID
|
left join gy_unit u on m.HUnitID=u.HItemID
|
left JOIN Sc_PPBomBillSub p ON b.HSourceEntryID = p.HInterID
|
left JOIN Sc_PPBomBillMain pm ON p.HInterID=pm.HInterID
|
where convert(varchar(50),b.HInterID)+'-'+convert(varchar(50),b.HEntryID) in ('123371-2728','123371-2729')
|
|
2022/8/11 18:50:50 SqlConnStr:Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;
|
|
2022/8/11 18:50:50 ReportDataSet:2
|
