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. |