And if I run your code - slightly changed since I don't have any "Transaction ID" columns - I get what I expect:
select table_name,column_name from information_schema.columns where column_name like '%ID%'
table_name column_name
CCr id
Stock Id
Stock ItemID
Folder DefaultPhotoID
Folder FolderID
Gallery FolderID
Gallery PhotoID
Invoices id
Managers ID
Managers ManagerID
ChatEvents Id
Salesman SalesID
So my best guess is that the name you are searching for is wrong: "TRansaction ID" may be "Transaction_ID" or "TransactionID"