Thank you all for your insights!

I suspect that my colleague and I have reached a 'syntax impasse' on this one.

And whilst ordinarily I would agree SSCarpel Tunnel

- in this instance we are excluding specific transaction types, (so even in a 'not exists')

would we not have to bolt on the list of excluded codes?