8 AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAtGIR4s1JgEi7Qe8qlaV7EQAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAADF1EKSrgxgAWNrmLn9zG81JlsYzCpU7uVM7CtrR50SHQAAAAAOgAAAAAIAACAAAABlGCcTI5ufxFj9YjiSQDyMoz+mBlNG7LWJo6B3HlnD4zAAAAATxLm5sEkOYR/XmommI4jq/TzT2qsoZ0Bxlob19+kj5Rsn+QzMJmuyhuypnHpyHwZAAAAA/ZrkxYPbXue7+Rc7UiyOsSKCTn+OCFNqhghe1hUeccTnMQqY7Qty0qIxeR0gflAt8aI6cyZOjips1zVYaGcMiA 0 select convert(nvarchar(10), a.称重时间 ,120)[称重时间], 所属客户,渠道名称,实际派送渠道, AVG(DATEDIFF(hour,a.下单时间,a.称重时间)/24.0) as [客户平均出库时间], AVG(DATEDIFF(hour,a.称重时间,d.CreateTime)/24.0) as [内部平均出库时间], AVG(DATEDIFF(hour,a.称重时间,d.DepartTime)/24.0) as [操作-起飞平均时长] from BaseOrderInfo(nolock)a left join Logistics_BoxDetail(nolock)b on a.OrderId=b.OrderId left join logistics_box(nolock)c on c.Id=b.BoxId and c.IsDelete=0 left join Logistics_LadingBill(nolock)d on d.LadingBillNumber=c.LadingBillNumber and d.IsDeleted = 0 left join Logistics_Trace(nolock)e on e.OrderId=a.OrderId where a.称重时间>'2022-05-01' group by convert(nvarchar(10), a.称重时间 ,120), 所属客户,渠道名称,实际派送渠道; 936 false 2

0 [BASEETL_Internal_Operation_Timeliness] 936 false 3 false false TABLOCK,CHECK_CONSTRAINTS 2147483647

0 select convert(nvarchar(10), e.SignTime ,120)[签收时间], 所属客户,渠道名称,实际派送渠道, AVG(DATEDIFF(hour,d.ArrivalTime,e.onlinetime)/24.0) as [落地-上网时间], AVG(DATEDIFF(hour,e.OnlineTime,e.SignTime)/24.0) as [上网-签收时长] from BaseOrderInfo(nolock)a left join Logistics_BoxDetail(nolock)b on a.OrderId=b.OrderId left join logistics_box(nolock)c on c.Id=b.BoxId and c.IsDelete=0 left join Logistics_LadingBill(nolock)d on d.LadingBillNumber=c.LadingBillNumber and d.IsDeleted = 0 left join Logistics_Trace(nolock)e on e.OrderId=a.OrderId where e.SignTime>'2022-05-01' group by convert(nvarchar(10), e.SignTime ,120), 所属客户,渠道名称,实际派送渠道 936 false 2

0 [BASEETL_External_Operation_Timeliness] 936 false 3 false false TABLOCK,CHECK_CONSTRAINTS 2147483647

DataSourceViewID DataSourceViewID TableInfoObjectType Table DataSourceViewID DataSourceViewID TableInfoObjectType Table ]]>