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