...
Travel Date provided (is mandatory)
Date is today or in the future
Flight number provided
Yes
Infer other fields > by looking at shuttle booking history (at least 5 bookings prior to today)
Destination
Direction of Travel
Flight Time
No
Destination must be provided
compare with lookup table for this customer
Terminal must be provided
yes - use lookup for terminal
no - default terminal setting
Flight time must be provided
Direction of Travel must be provided
Will need a lookup table that converts text provided to direction
PAX
if not provided then use default value (1)
Excess Bags
Only if provided
Passenger name options
Single field
combine Fname / Lname fields
Passenger phone
may not be provided
passenger email
may not be provided
Address
May be provided line by line
May be provided in a single field > decompose
Hotel name may be provided
Look up in customer name fields (all customers) > use address found
May not be provided = use customer address on the booking
External Reference
May not be provided
Inbound Delegate company > always the customer used
...