One thing I've spotted is that 2 Additional Fields have been created for the same purpose:

At initial glance, I would estimate 50% of the templates use the first one, and 50% use the second one.  As you can see one is AlphaNumeric, the other is numbers only (and sometimes external refs include letters as well as numbers)

We need to standardise and only use one of these fields across all templates.  However, we currently have approximate 100 active templates.  Is there any way of seeing which templates a particular Additional Field is used in?  Could this be done by a query report?

Eg:, Output would look something like

Additional Field Name Template(s)

Ext Reference Number Template 1

Template 2

Template 8

-------------------------------------------------------

Ext. Reference Template 3

Template 4

etc

etc