Dispatch Ticket History Procedure

The Dispatch Ticket History Procedure (DIP_TICKETHISTORY) was implemented in Build 2.0.0.5.

Based on inputs to the procedure, the procedure returns virtually ALL header/detail fields from ARTPTKHD/DT, ARTTCKHD/DT, and ARTSLSHD/DT tables.

Sample Query

SELECT * FROM DIP_TICKETHISTORY
('Y','Y','Y','Y',:BEG_DATE,:END_DATE,:BEG_CUST,:END_CUST,NULL,NULL,NULL,NULL,NULL,NULL)

Inputs

Inputs (IN ORDER):

Input Field	Description
INCLUDE_CURRENT_TICKETS	Y/N, null = 'N', indicates to include non-exported tickets from ARTPTKHD/DT
INCLUDE_EXPORTED_TICKETS	Y/N, null = 'N', indicates to include exported tickets from ARTPTKHD/DT
INCLUDE_OFFICE_TICKETS	Y/N, null = 'N', indicates to include tickets from ARTTCKHD/DT
INCLUDE_INVOICED_TICKETS	Y/N, null = 'N', indicates to include invoiced tickets from ARTSLSHD/DT
BEGIN_TICKET_DATE	date in MM/DD/YY format, null = '01/01/1900'
END_TICKET_DATE	date in MM/DD/YY format, null = '12/31/9999'
BEGIN_CUST_NO	null = first customer
END_CUST_NO	null = last customer (or BEGIN_CUST_NO if BEGIN_CUST_NO is specified)
BEGIN_CUST_CLASS	null = first customer class
END_CUST_CLASS	null = last customer class (or BEGIN_CUST_CLASS if BEGIN_CUST_CLASS is specified)
BEGIN_PROD_CLASS	null = first product class
END_CUST_CLASS	null = last product class (or BEGIN_PROD_CLASS if BEGIN_PROD_CLASS is specified)
BEGIN_PLANT_NO	null = first DISPATCH plant (PLANT_TYPE = 'D')
END_PLANT_NO	null = last DISPATCH plant (or BEGIN_PLANT_NO if BEGIN_PLANT_NO is specified)

Outputs

Virutually every common field in ARTPTKHD/DT, ARTTCKHD/DT and ARTSLSHD/DT. Headers & Detail records are joined - there is no need to join on SESSION_NO, TRANS_NO. Records will arrive from the procedure automatically linked.