2022/4/11 15:03:20 '1000630100090','1000630100091'
|
|
2022/4/11 15:03:20 select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 15:03:20 打印sql:select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 15:03:20 ReportDataSet:2
|
|
2022/4/11 15:53:03 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=6146
|
|
2022/4/11 15:53:03 ReportDataSet:1
|
|
2022/4/11 15:54:24 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=6147
|
|
2022/4/11 15:54:24 ReportDataSet:1
|
|
2022/4/11 15:54:34 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=6147
|
|
2022/4/11 15:54:34 ReportDataSet:1
|
|
2022/4/11 15:56:05 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=6147
|
|
2022/4/11 15:56:05 ReportDataSet:1
|
|
2022/4/11 15:58:23 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=6147
|
|
2022/4/11 15:58:23 ReportDataSet:1
|
|
2022/4/11 16:00:17 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=6100
|
|
2022/4/11 16:00:17 ReportDataSet:1
|
|
2022/4/11 16:00:53 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=5969
|
|
2022/4/11 16:00:53 ReportDataSet:1
|
|
2022/4/11 16:49:01 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=6146
|
|
2022/4/11 16:49:01 ReportDataSet:1
|
|
2022/4/11 16:49:02 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=6147
|
|
2022/4/11 16:49:02 ReportDataSet:1
|
|
2022/4/11 16:49:57 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=5969
|
|
2022/4/11 16:49:57 ReportDataSet:1
|
|
2022/4/11 16:49:57 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=5970
|
|
2022/4/11 16:49:57 ReportDataSet:1
|
|
2022/4/11 16:50:47 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=5970
|
|
2022/4/11 16:50:47 ReportDataSet:1
|
|
2022/4/11 16:50:47 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID=5971
|
|
2022/4/11 16:50:47 ReportDataSet:1
|
|
2022/4/11 16:54:16 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID in ('5974','5973')
|
|
2022/4/11 16:54:16 ReportDataSet:2
|
|
2022/4/11 16:54:58 打印sql:select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HBarCode 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID in ('5974')
|
|
2022/4/11 16:54:58 ReportDataSet:1
|
|
2022/4/11 20:04:06 '1000630100090','1000630100091'
|
|
2022/4/11 20:04:06 select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 20:04:06 打印sql:select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 20:04:06 ReportDataSet:2
|
|
2022/4/11 20:04:41 '1000630100090','1000630100091'
|
|
2022/4/11 20:04:41 select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 20:04:41 打印sql:select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 20:04:41 ReportDataSet:2
|
|
2022/4/11 20:04:49 '1000630100090','1000630100091','1000630100098','1000630100095'
|
|
2022/4/11 20:04:49 select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091','1000630100098','1000630100095')
|
|
2022/4/11 20:04:49 打印sql:select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091','1000630100098','1000630100095')
|
|
2022/4/11 20:04:49 ReportDataSet:4
|
|
2022/4/11 20:06:36 '1000630100090','1000630100091'
|
|
2022/4/11 20:06:36 select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 20:06:36 打印sql:select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 20:06:36 ReportDataSet:2
|
|
2022/4/11 20:46:02 '1000630100090','1000630100091'
|
|
2022/4/11 20:46:02 select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 20:46:02 打印sql:select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
|
from Sc_ICMOBillMain a
|
left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer c on a.HCusID=c.HItemID
|
left join Gy_Unit u on a.HUnitID=u.HItemID
|
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
|
2022/4/11 20:46:04 ReportDataSet:2
|
