The Detailed Product Template governs the appearance of the product when it's displayed on its own individual page, although the page may also contain Related Products if the user wishes. Basically, the Detailed Product Template is the layout and design, the look and feel of the full Product display.
The Detailed Product Template is constructed with a combination of HTML, CSS, and special keywords.