Electronic structure of 3d transition metal compounds: systematic chemical trends and multiplet effects