JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8479

BankAccounts

Query BankAccounts in Sage Business Cloud Accounting.

Table Specific Information

Query the available BankAccounts

Select

The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince,DeletedSince,ExcludeStripe columns. The driver processes other filters client-side within the driver.

  • UpdatedOrCreatedSince supports the '=' operator.
  • DeletedSince supports the '=' operator.
  • ExcludeStripe supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM BankAccounts WHERE UpdatedOrCreatedSince='2019-10-02T11:46:53Z'
SELECT * FROM BankAccounts WHERE DeletedSince='2019-10-02T11:46:53Z'
SELECT * FROM BankAccounts WHERE ExcludeStripe='false'

Insert

  • Create a simple bank account.

    INSERT INTO  [Addresses] (BankAccountTypeId, Balance, AccountName) VALUES ('2', '0.0', 'test')

Update

Updates are performed based on Id.

UPDATE BankAccounts SET BankAccountTypeId='SAVINGS' WHERE Id='80b34e32b85a46c39a71c3627d577fa2'

Delete

You must specify the Id of the BankAccounts to delete it.

DELETE FROM BankAccounts WHERE id ='80b34e32b85a46c39a71c3627d577fa2' 

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

BankAccountTypeId String False

The unique identifier for the item

使用できる値は次のとおりです。CHECKING, SAVINGS, CREDIT_CARD, CASH_IN_HAND, LOAN, OTHER

Balance String False

The bank account balance

CreatedAt Datetime True

The datetime when the item was created

SortCode String False

The sort code

Iban String False

The iban

Bic String False

The bic

AccountName String False

The account name

AccountNumber String False

The account number

MainContactId String False

The fax number of the contact

DefaultPaymentMethodId String False

PaymentMethods.Id

The unique identifier for the item

Deletable Bool False

Indicates whether or not the bank account can be deleted

LedgerAccountId String False

LedgerAccounts.Id

The unique identifier for the item

MainAddressId String False

Addresses.Id

The unique identifier for the item

DeletedAt Datetime True

The datetime when the item was deleted

Editable Bool False

Indicates whether or not the bank account can be edited

DisplayedAs String False

The name of the resource

JournalCodeId String False

JournalCodes.Id

The unique identifier for the item

NominalCode Int False

The nominal code of the bank account

LegacyId Int False

The legacy ID for the item

UpdatedAt Datetime True

The datetime when the item was last updated

DeletedSince Datetime True

ExcludeStripe Boolean True

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479