ODBC Driver for Sage 50 UK

Build 23.0.8839


Query Projects within Sage UK 50 Accounts.

Table Specific Information


The Projects table returns project information for a Sage 50 UK company dataset.

SELECT * FROM Projects


Name Type Description
ProjectUUID [KEY] String Project UUID
ProjectReference String Project Reference
TradingAccountReference String Project Reference2
Name String Project Name
Description String Project Description
Status String Project Status
StartDate Date Project Start Date
EndDate Date Project End Date
Currency String Project Currency
OperatingCompanyCurrency String Project OperatingCompany Currency
OperatingCompanyCurrencyExchangeRate Decimal Project OperatingCompany Currency Exchange Rate
OperatingCompanyCurrencyExchangeRateOperator String Project OperatingCompany Currency Exchange Rate Operator
CurrentCostBalance Decimal Project Current Cost Balance
LastCostTransactionDate Date Project Last Cost Transaction Date
CurrentRevenueBalance Decimal Project Current Revenue Balance
LastRevenueTransactionDate Date Project Last Revenue Transaction Date
CurrentCostBudget Decimal Project Current Cost Budget
CurrentRevenueBudget Decimal Project Current Revenue Budget
CurrentCommittedCostBalance Decimal Project Current Committed Cost Balance


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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839