[Feature] explore removing references to the transactions table

[fivetran-jamie]

Is there an existing feature request for this?

• [X] I have searched the existing issues

Describe the Feature

we've confirmed that monetary values stored in non-transaction tables (orders, order_lines, etc) are reported in the shop currency, so perhaps we don't need to use the transaction table's exchange rate data to get order totals.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• [ ] Yes.
• [ ] Yes, but I will need assistance and will schedule time during your office hours for guidance.
• [ ] No.

Anything else?

No response