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