i'd add it as custom field on the transaction and ...
# suitescript
c
i'd add it as custom field on the transaction and update it on create/edit and just pull that field into the search. May be a conversion method but not that I am aware of.