Hi N2G,
To me, a motivation letter is one that you often have to write when applying to a University, especially for postgraduate courses (MSc/MA/PhD etc.).
It should mention why you are interested in a certain course/research topic, explain why you are a good candidate and why you should be chosen, and point out what the benefits for your future career are.
It's a bit like advertising yourself!