Invoice ID, Transaction ID
Created by: artfulrobot
Both of these are unique in each of civicrm_contribution
and civicrm_contribution_recur
.
I had hoped to use the invoice_id
for the subscription but this won't work because it would lead to 2+ contributions being impossible(!)