Yes, you can add a text type field to transactions for sure.
I suspect you want to enforce the filling in of this when you delete?
If so you could write a User Event script and deploy to transactions that runs beforeSubmit, on DELETE and checks that field.
If it's empty, thrown an error to prevent the record saving.
Just be careful you do mean ALL transactions though, you might want to only deploy that script to certain types 😉