JDBC Driver for Sage 50 UK

Build 22.0.8462

FinancialAccounts

Query Financial Accounts within Sage UK 50 Accounts.

Columns

Name Type Description
FinancialAccountUUID [KEY] String FinancialAccount UUID
NominalCode String FinancialAccount Nominal Code
AccountName String FinancialAccount Type
Currency String FinancialAccount Currency
Balance Decimal FinancialAccount Balance
PrimacyIndicator Boolean FinancialAccount Primacy Indicator

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