JDBC Driver for Sage 50 UK

Build 22.0.8462

Projects

Query Projects within Sage UK 50 Accounts.

Table Specific Information

Select

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

SELECT * FROM Projects

Columns

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