Here is the list of constraints and how they affect the schedule:
As late as possible: Changes early dates to the values calculated by backward pass (sets early dates to the late dates)
Finish on: Changes early finish and late finish dates to the date selected
Finish on or after: Changes early finish date to the date selected
Finish on or before: Changes late finish to the date selected
Mandatory finish: Changes early and late finish dates to the selected date, and it overrides any network logic related with this activity. If you set the mandatory finish date to a non-working date, then early finish will be set to the earliest working day, but late finish date will stay in the selected date in mandatory finish constraint; this will cause negative float in the activity.
Mandatory start: The same as mandatory finish but affects the start dates.
Start on: Sets the early and late start dates to the selected date
Start on or after: Sets the early start date to the selected date
Start on or before: Sets the late start date to the selected date