Missing INVOICE_LINKED_TRANSACTION Table

Issue

The Fivetran Xero ERD lists the INVOICE_LINKED_TRANSACTION table. However, it's missing from the Schema tab of my connection overview page in Fivetran.

Environment

Connector: Xero

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your Xero connection page.
2. Select the Schema tab.
3. Select the checkbox next to the _BANK_LINKED_TRANSACTIONS table.
4. Click Save changes.
5. Repeat the steps 1-4 for the INVOICE_LINKED_TRANSACTION table.

Cause

We populate the INVOICE_LINKED_TRANSACTION table using data from the _BANK_LISTED_TRANSACTIONS table, which must be available for it to sync successfully. If it's not included in the connection's schema, the INVOICE_LINKED_TRANSACTION table doesn't appear.