The embodiments of the invention relates to a transportation management system. Specifically the embodiments of the invention relate to a system and process for generating shipment orders, freight orders and tours automatically from planned transportation activity data. The process reduces planned transportation activity to a set of frames having minimal data to reduce processing time. The frames are then evaluated for soft and hard constraints to identify a set of shipment orders, freight orders and tours. The shipment orders, freight orders and tours are then augmented from the frame state to include the necessary data.