Bank_Accounts table

Column Type

Id

String

Url

URI

Type

String

View

String

Email

String

Account_Number

String

Current_Balance

Decimal

Unexplained_Transaction_Count

Integer

Name

String

Opening_Balance

Decimal

Manually_Added_Transaction_Count

Integer

Updated_At

Timestamp

Is_Personal

Boolean

Total_Count

Integer

Is_Primary

Boolean

Currency

String

Status

String

Marked_For_Review_Count

Integer

Latest_Activity_Date

String

Bank_Code

String

Created_At

Timestamp

Bank_Feed_Enabled

Boolean

Bank_Guess_Enabled

Boolean

Bank_Name

String

Sort_Code

String

Secondary_Sort_Code

String

Iban

String

Bic

String

Default_Property

String

Marked_For_Review_Category_Group_Counts

Array

Examples

SELECT
    Id,
    [Name],
    Current_Balance,
    Updated_At
FROM
    Bank_Accounts
WHERE
    Current_Balance < 10000

INSERT INTO
    Bank_Accounts (
        [Type],
        [Name],
        [Currency],
        [Is_Personal],
        [Is_Primary],
        [Status],
        [Bank_Name],
        [Opening_Balance],
        [Bank_Guess_Enabled],
        [Account_Number],
        [Sort_Code],
        [Secondary_Sort_Code],
        [Iban],
        [Bic]
    )
VALUES
    (
        'StandardBankAccount',
        'Barclays EUR',
        'EUR',
        'false',
        'false',
        'active',
        'Barclays Bank',
        '100000',
        'false',
        '223344557',
        '22-11-21',
        '22-11-22',
        'GB10 BUKB 111111223344557',
        'BUKBGB22'
    )
UPDATE Bank_Accounts
SET
    [Name] = 'Barclays EUR2'
WHERE
    [Name] = 'Barclays EUR'

DELETE FROM Bank_Accounts
WHERE
    [Name] = 'Barclays EUR2'