Skip to main content

Community

Please sign in to leave a comment.

Comments

2 comments

    Hey Paula, thanks for submitting this request! 

    If you don't mind, could you elaborate on your use case for including 'home currency' to the Fivetran schema? I definitely see how it could be valuable to have a reference for home currency within one of our tables, but I'm curious on if there is an additional solution rather than adding an additional column to the CURRENCY table. 

    Thanks Elan for your answer. 

    We need to figure out the consolidation currency for multiple QBO that use multicurrency. Currently, the only way to find it is to search for the currency_id that has an exchange_rate of 1 in the `journal_entry` table. 

    In QBO some journal entries (and other type of transactions such payment, purchase, etc) may have an exchange rate but they shouldn't be converted because the transaction was made in the consolidation currency.