Request:

Add account_id field to Xero tables invoice_line_item and credit_note_line_item, in addition to the already existing account_code field.

Background:

In Xero, Accounts have an internal id, a code and a name. This is reflected in Fivetran's ERD schema for the Account table.

Xero allows users to edit accounts codes and names - resulting in accounts that have changesd their codes but still have the same internal id. As a result, in the Xero web UI, users viewing historical invoices, credit, and journals will immediately see the new codes instead of the old codes. 

This does not trigger changes to historical documents such as invoices and credit notes, seeing as the associated account hasn't changed (only its code changed). And seeing as no actual changes are triggered by Xero in this case, Fivetran will not pick it up.

The challenge is that on the invoice_line_item and credit_note_line_item tables, Fivetran only stores the account_code and not the account id - meaning that this change will not be reflected in the destination, unless a user will manually initiate a full resync of all Xero data.

This can be resolved by adding the account id field to those two tables, allowing people to manually join to the account table (which does reflect the changes).