http://in.compucrete.com/index.php?action=history&feed=atom&title=Pour_Time_Variance_Actual_vs._Target
Pour Time Variance Actual vs. Target - Revision history
2026-05-15T17:06:04Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Pour_Time_Variance_Actual_vs._Target&diff=510&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T13:00:34Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-509:rev-510 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=Pour_Time_Variance_Actual_vs._Target&diff=509&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:02:09Z
<p>1 revision imported</p>
<p><b>New page</b></p><div>Query:<br />
<PRE><br />
select t.cust_no "Cust" ,t.job_po_loc "Job",t.ticket_no "Ticket",T.TRUCK_NO "Truck",<br />
tgt_begin_pour_dt,tgt_end_pour_dt,<br />
floor( .5+ (tgt_end_pour_dt-tgt_begin_pour_dt)*1440) "Tgt Pour Min", <br />
begin_pour_dt,end_pour_dt, floor (.5+ (end_pour_dt-begin_pour_dt )*1440) "Act Pour Min",<br />
floor (.5 + ((end_pour_dt-begin_pour_dt )- (tgt_end_pour_dt-tgt_begin_pour_dt) ) *1440) "Minutes Over"<br />
,l.load_size from artptkhd t<br />
inner join ditprjld l on t.order_session_no=l.order_session_no and t.order_trans_no=l.order_trans_no and l.load_no=t.order_load_no<br />
where status_col>6 and t.void_flag<>'Y' and floor (.5 + ((end_pour_dt-begin_pour_dt )- (tgt_end_pour_dt-tgt_begin_pour_dt) ) *1440) not between -10 and 10<br />
and t.ticket_date=:Report_Date<br />
order by t.cust_no,t.job_po_loc<br />
</PRE><br />
<br />
Field Break/Group<br />
Cust - 1/1<br />
Job - 2/2<br />
<br />
Format DateTimes as hh:mm<br />
Format Elapsed times as ##0<br />
<br />
See Also: [[Time Queries for Tickets and Sales History]]</div>
Intra>User