Bank_Account table

Column Type

Account_Id

String

Account_Name

String

Account_Code

String

Currency_Id

String

Currency_Code

String

Currency_Symbol

String

Price_Precision

Number

Account_Type

String

Account_Number

String

Uncategorized_Transactions

Number

Total_Unprinted_Checks

Number

Is_Active

Boolean

Is_Feeds_Subscribed

Boolean

Is_Feeds_Active

Boolean

Balance

Number

Bank_Balance

Number

Bcy_Balance

Number

Bank_Name

String

Routing_Number

String

Is_Primary_Account

Boolean

Is_Paypal_Account

Boolean

Description

String

Refresh_Status_Code

String

Feeds_Last_Refresh_Date

Date

Service_Id

String

Is_System_Account

Boolean

Is_Show_Warning_For_Feeds_Refresh

Boolean

Can_Access_All_Branches

Boolean

Last_Import_Duplicate_Count

Number

Can_Show_In_Ze

Boolean

Sort_Code

String

Latest_Transaction_Date

Date

Iban_Number

String

Is_Direct_Paypal

Boolean

Can_Show_Paypal_Direct_Integ_Banner

Boolean

Can_Access_All_Locations

Boolean

Payout_Bank_Name

String

Partner_Bank_Source

String

Feed_Status

String

Migrate_To_Partner_Bank

String

Institution_Id

String

Institution_Name

String

Is_Pdf_Password_Stored

Boolean

Partner_Bank_Source_Formatted

String

Is_Feeds_Owner

Boolean

Consent_Info_Consent_Remaining_Days

String

Consent_Info_Is_Consent_Expired

String

Is_Beta_Feed

Boolean

Swift_Code

String

Examples

INSERT INTO
    Bank_Account (
        Account_Name,
        Account_Type,
        Account_Number,
        Routing_Number,
        currency_code
    )
VALUES
    (
        'Test COOP Account',
        'bank',
        '80000009823',
        '123456789',
        'GBP'
    )
UPDATE Bank_Account
SET
    Account_Name = 'COOP Account'
WHERE
    Account_Id = '576438000000114002'
DELETE FROM Bank_Account
WHERE
    Account_Id = '576438000000114002'