Where is the "OPPORTUNITY_ID" field in the OPPORTUNITIES table?

There is no "OPPORTUNITY_ID" field in the OPPORTUNITIES table. Instead we have the "TRANSACTION_ID". This links to the OPPORTUNITY_LINES table as follows:

SELECT * FROM OPPORTUNITIES AS A, OPPORTUNITY_LINES AS B
WHERE A.TRANSACTION_ID = B.OPPORTUNITY_ID