SELECT
*
FROM
Bank_Transactions
WHERE
Id = '577790804'
SELECT
*
FROM
Bank_Transactions
WHERE
Bank_Account = 'https://api.freeagent.com/v2/bank_accounts/1555435'
INSERT INTO
Bank_Transaction_Explanations (
bank_transaction,
bank_account,
dated_on,
description,
category,
gross_value,
sales_tax_status,
sales_tax_rate
)
VALUES
(
'https://api.freeagent.com/v2/bank_transactions/577790779',
'https://api.freeagent.com/v2/bank_accounts/1555435',
'2024-11-26',
'FEE description.',
'https://api.freeagent.com/v2/categories/291',
-471,
'TAXABLE',
20
)
UPDATE Bank_Transaction_Explanations
SET
Description = 'New FEE description text.'
WHERE
Id = '532804092'
DELETE FROM Bank_Transaction_Explanations
WHERE
Id = '532762173'