Yellow= Constant (BATT) 12V
Red=Accessory (Ignition switch) 12V
For testing, you could tie the red & yellow together on the head unit and connect to a standard CPU PS yellow on the molex (12v+) and obviously black to black.
I can't imagine why that wouldn't work.
Please let me know what you think of that unit, I'm eyeballing that one (because it swivels) and the motorized one made by "god knows who" (sold here at MP3car.com