http://in.compucrete.com/index.php?action=history&feed=atom&title=Dispatch_Ticket_History_Procedure 2026-05-15T17:59:28Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Dispatch_Ticket_History_Procedure&diff=182&oldid=prev 2023-07-14T12:58:49Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

WikiAdmin http://in.compucrete.com/index.php?title=Dispatch_Ticket_History_Procedure&diff=181&oldid=prev 2017-01-10T00:01:38Z

<p>1 revision imported</p> <p><b>New page</b></p><div>The Dispatch Ticket History Procedure (DIP_TICKETHISTORY) was implemented in Build 2.0.0.5.<br /> <br /> Based on inputs to the procedure, the procedure returns virtually ALL header/detail fields from ARTPTKHD/DT, ARTTCKHD/DT, and ARTSLSHD/DT tables.<br /> <br /> === Sample Query ===<br /> &lt;PRE&gt;SELECT * FROM DIP_TICKETHISTORY<br /> ('Y','Y','Y','Y',:BEG_DATE,:END_DATE,:BEG_CUST,:END_CUST,NULL,NULL,NULL,NULL,NULL,NULL)<br /> &lt;/PRE&gt;<br /> <br /> ===Inputs===<br /> &lt;center&gt;Inputs ('''IN ORDER'''):&lt;/center&gt;<br /> <br /> {| border=&quot;3&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Input Field<br /> ! Description<br /> |-<br /> | INCLUDE_CURRENT_TICKETS<br /> | Y/N, null = 'N', indicates to include non-exported tickets from ARTPTKHD/DT<br /> |- <br /> | INCLUDE_EXPORTED_TICKETS<br /> | Y/N, null = 'N', indicates to include exported tickets from ARTPTKHD/DT<br /> |-<br /> | INCLUDE_OFFICE_TICKETS<br /> | Y/N, null = 'N', indicates to include tickets from ARTTCKHD/DT<br /> |-<br /> | INCLUDE_INVOICED_TICKETS<br /> | Y/N, null = 'N', indicates to include invoiced tickets from ARTSLSHD/DT<br /> |-<br /> | BEGIN_TICKET_DATE<br /> | date in MM/DD/YY format, null = '01/01/1900'<br /> |-<br /> | END_TICKET_DATE<br /> | date in MM/DD/YY format, null = '12/31/9999'<br /> |-<br /> | BEGIN_CUST_NO<br /> | null = first customer<br /> |-<br /> | END_CUST_NO<br /> | null = last customer (or BEGIN_CUST_NO if BEGIN_CUST_NO is specified)<br /> |-<br /> | BEGIN_CUST_CLASS<br /> | null = first customer class<br /> |-<br /> | END_CUST_CLASS<br /> | null = last customer class (or BEGIN_CUST_CLASS if BEGIN_CUST_CLASS is specified) <br /> |-<br /> | BEGIN_PROD_CLASS<br /> | null = first product class<br /> |-<br /> | END_CUST_CLASS<br /> | null = last product class (or BEGIN_PROD_CLASS if BEGIN_PROD_CLASS is specified) <br /> |-<br /> | BEGIN_PLANT_NO<br /> | null = first DISPATCH plant (PLANT_TYPE = 'D')<br /> |-<br /> | END_PLANT_NO<br /> | null = last DISPATCH plant (or BEGIN_PLANT_NO if BEGIN_PLANT_NO is specified) <br /> |-<br /> |}<br /> <br /> ===Outputs===<br /> Virutually every common field in ARTPTKHD/DT, ARTTCKHD/DT and ARTSLSHD/DT. Headers &amp; Detail records are joined - there is no need to join on SESSION_NO, TRANS_NO. Records will arrive from the procedure automatically linked.</div>

Intra>User