The user_external_id of a transaction inserted using the API and then deleted in the UI will remain in the database. Retrying to insert the transaction via the API will fail due to incorrect handling of duplicate user_external_ids with the following error: "Key (user_external_id, asset_id, account_id)=(1234567891234567891, 12345, 12345) already exists."