JDBC Driver for Sage 50 UK

Build 22.0.8462

BankAccounts

Query BankAccounts within Sage UK 50 Accounts.

Table Specific Information

Select

The BankAccounts table returns the bank accounts for a Sage 50 UK company dataset.

SELECT * FROM BankAccounts

Columns

Name Type Description
BankAccountUUID [KEY] String BankAccount UUID
TradingAccountUUID String BankAccount Trading Account UUID
Type String BankAccount Type
TradingAccountReference String BankAccount Reference to the associated Trading Account
Name String BankAccount Name
BranchIdentifier String BankAccount Branch Identifier
AccountNumber String BankAccount Account Number
IBANNumber String BankAccount IBAN Number
BICSwiftCode String BankAccount BIC Swift Code
RollNumber String BankAccount Roll Number
Currency String BankAccount Currency
OperatingCompanyCurrency String BankAccount OperatingCompany Currency
Website String BankAccount Web site
CompanyReference String BankAccount Company Reference. Example values: 'Operating Company Bank Account', 'Supplier Bank Account', 'Customer Bank Account'
PaymentAllowedFlag Boolean BankAccount Payment Allowed Flag
ReceiptAllowedFlag Boolean BankAccount Receipt Allowed Flag
Reference2 String BankAccount Reference2
Balance Decimal BankAccount Balance
Limit Decimal BankAccount Limit
PrimacyIndicator Boolean BankAccount Primacy Indicator
PostalAddressUUID String BankAccount PostalAddress UUID
PostalAddressActive Boolean BankAccount PostalAddress Active Flag
PostalAddressTradingAccountReference String BankAccount PostalAddress Reference
PostalAddressName String BankAccount PostalAddress Name
PostalAddressDescription String BankAccount PostalAddress Description
PostalAddressAddress1 String BankAccount PostalAddress Address 1
PostalAddressAddress2 String BankAccount PostalAddress Address 2
PostalAddressAddress3 String BankAccount PostalAddress Address 3
PostalAddressAddress4 String BankAccount PostalAddress Address 4
PostalAddressTownCity String BankAccount PostalAddress TownCity
PostalAddressCounty String BankAccount PostalAddress County
PostalAddressStateRegion String BankAccount PostalAddress StateRegion
PostalAddressZipPostCode String BankAccount PostalAddress ZipPost Code
PostalAddressCountry String BankAccount PostalAddress Country
PostalAddressPrimacyIndicator Boolean BankAccount PostalAddress Primacy Indicator
PostalAddressType String BankAccount PostalAddress Type

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Updated Datetime An input used internally to filter records updated at a specific datetime.

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