Xero - pre-existing Xero company IDs require clearing

--Problem: Xero ID could not be matched. Khaos Control support should clear this redundant Xero company ID from the database (XERO_EXPORTED for company record)

--Statement to confirm entries for company record

select * from xero_exported where source_type = 5 and source_id in (select company_id from company where company_code = 'AURORA')

--Statement to remove the entries (Will be regenerated)

/*delete from xero_exported where xexported_id =

(select min(xexported_id) from xero_exported where source_type = 5 and source_id in (select company_id from company where company_code = 'AURORA'))*/