This script is used for finding an account's disconnection date within Manitou.
SELECT transmitter_id, site_name, discontinued_date, last_event_date FROM ABMtransmitter WHERE (last_event_date <= "last_event_date") IF NO DISCONTINUED TRANSMITTERS TO BE INCLUDED AND current_status <> "disc" IF ONLY DISCONTINUED TRANSMITTERS TO BE INCLUDED AND current_status = "disc" IF DEALER ENTERED AND dealer IN (dealer_list) IF SUBSCRIBER ENTERED AND subscriber IN (subscriber_list) IF ORGANIZATION ENTERED AND organization IN (organization_list) IF SITE ENTERED AND site IN (site_list) IF TRANSMITTER ENTERED AND transmitter_id IN (transmitter_list)