Victoria Yudin has fixed asset table info for GP.
Dynamics GP Fixed Assets Table Info
General Ledger & FinancialsSQL & Data
Archived post from 2008. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.