Enables all-trans-retinol dehydrogenase (NAD+) activity; androstan-3-alpha,17-beta-diol dehydrogenase (NAD+) activity; and androsterone dehydrogenase [NAD(P)+] activity. Involved in steroid metabolic process. Located in intracellular membrane-bounded organelle. [provided by Alliance of Genome Resources, Apr 2025]