Enables oxidoreductase activity, acting on the aldehyde or oxo group of donors, NAD or NADP as acceptor. Acts upstream of or within carnitine metabolic process. Located in cytosol. Is expressed in several structures, including alimentary system; cranium; eye; metanephros; and nervous system. Orthologous to human ALDH9A1 (aldehyde dehydrogenase 9 family member A1). [provided by Alliance of Genome Resources, Apr 2022]