SELECT ap_form_44342.id as er_id,ap_form_44342.element_76,ap_form_49773.id as destruct_id, ap_form_43256.id as truck_id,ap_form_44342.element_3,ap_form_44342.id, ap_form_44342.element_3 as status,Inetforms.ap_form_43256.*,ap_form_43256.element_134 as tsl_wtn,Inetforms.ap_form_49773.cert_link,ap_form_49773.id as deconstruct_id,ap_form_49773.element_3 as deconstruct_status,ap_form_49773.element_88,ap_form_49773.element_134, ap_form_43256.element_154_1 as check_voided,ap_form_43256.element_151,ap_form_43256.element_155 as voided_pic, ap_form_43256.element_156 as voided_number FROM Inetforms.ap_form_43256 LEFT JOIN Inetforms.ap_form_49773 ON Inetforms.ap_form_49773.element_76 = Inetforms.ap_form_43256.id LEFT JOIN Inetforms.ap_form_44342 ON ap_form_44342.element_76 = ap_form_43256.id WHERE ap_form_43256.element_1 = 4 AND DATE_FORMAT( ap_form_43256.date_created, '%Y-%m-%d' ) >='2024-04-06'

Outbound

	TO
Created By	Date	Status	Commodity	Ship To:	Net Weight	Weight Ticket	Carrier	Driver	Sale	Lot #	Notes	View Lab Results	View BOL	Edit Entry	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	Voided Weight Ticket	Voided Weight Ticket Number	BOL

SELECT ap_form_44342.id as er_id,ap_form_44342.element_76,ap_form_49773.id as destruct_id, ap_form_43256.id as truck_id,ap_form_44342.element_3,ap_form_44342.id, ap_form_44342.element_3 as status,Inetforms.ap_form_43256.*,ap_form_43256.element_134 as tsl_wtn,Inetforms.ap_form_49773.cert_link,ap_form_49773.id as deconstruct_id,ap_form_49773.element_3 as deconstruct_status,ap_form_49773.element_88,ap_form_49773.element_134, ap_form_43256.element_154_1 as check_voided,ap_form_43256.element_151,ap_form_43256.element_155 as voided_pic, ap_form_43256.element_156 as voided_number FROM Inetforms.ap_form_43256 LEFT JOIN Inetforms.ap_form_49773 ON Inetforms.ap_form_49773.element_76 = Inetforms.ap_form_43256.id LEFT JOIN Inetforms.ap_form_44342 ON ap_form_44342.element_76 = ap_form_43256.id WHERE ap_form_43256.element_1 = 5 AND DATE_FORMAT( ap_form_44342.date_created, '%Y-%m-%d' ) >='2024-04-06'

	TO
Created By	Date	Status	Commodity	Ship To:	Net Weight	Weight Ticket	Carrier	Driver	Release	Lot #	Notes	View Lab Results	View BOL	Edit Entry	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	Voided Weight Ticket	Voided Weight Ticket Number	BOL

	TO
Created By	Date	Status	Commodity	Ship To:	Net Weight	Weight Ticket	Carrier	Driver	Notes	View Lab Results	View BOL	Edit Entry	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	Voided Weight Ticket	Voided Weight Ticket Number	BOL

	TO
Created By	Date	Status	Commodity	Ship To:	Net Weight	Weight Ticket	Carrier	Driver	Tank #	Release Number	Notes	View Lab Results	View BOL	Edit Entry	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	Voided Weight Ticket	Voided Weight Ticket Number	BOL

	TO
Created By	Date	Status	Commodity	Ship To:	Net Weight	Weight Ticket	Carrier	Driver	Pile	Notes	Incoming Weight Cert	Incoming Gross	Incoming Tare	Incoming Net	View Lab Results	View BOL	Edit Entry	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	Voided Weight Ticket	Voided Weight Ticket Number	BOL

	TO
View Lab Results	Date	View BOL	Edit Entry	Created By	Status	Commodity	Ship To:	Net Weight	Weight Ticket	Carrier	Driver	Release	Notes	Incoming Weight Cert	Incoming Gross	Incoming Tare	Incoming Net	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	Voided Weight Ticket	Voided Weight Ticket Number	BOL

	TO
Created By	Date	Status	Commodity	Ship To:	Net Weight	Weight Ticket	Carrier	Driver	Tanker	Notes	Time In	Time Out	Incoming Weight Cert	Incoming Gross	Incoming Tare	Incoming Net	View Lab Results	View BOL	Edit Entry	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	Voided Weight Ticket	Voided Weight Ticket Number	BOL

	TO
Created By	Date	Status	Origin	Destination	Net Weight	Weight Ticket	Carrier	Driver	Tank	Notes	View Lab Results	View BOL	Edit Entry	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	Voided Weight Ticket	Voided Weight Ticket Number	BOL

	TO
Created By	Date	Status	Commodity	Ship From:	Net Weight	Weight Ticket	Carrier	Driver	Pickup	Trailer	Notes	View Lab Results	View BOL	Edit Entry	Certificate of Destruction	Weight Cert File	Incoming Weight Cert File	Seal	BOL	Voided Weight Ticket	Voided Weight Ticket Number