Our Colombia subsidiary is implementing a credit card along with a transaction feed. We are wondering how others deal with the requirement to include a merchant tax ID number at the entry level when the transaction arrives from a feed.

A simple list is maintained, with form fields for the vendor and tax ID on the various entry forms, but a transaction feed presents the possibility of a large number of vendor names.

Has anyone found a way to automate this? Is the Tax ID available from a Visa feed? I don't see it in the download of the transaction file.