Best UI approach to align the column titles of reports

I would like to know what the best approach is to align header columns according to their data type.

I haven't found any Human Design Interface articles explaining this.

Should the header column follow the same alignment that its data values uses?

Example header columns following the data type alignment

If yes, I would like to see some trustworthy references.