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