Query ProjectsAnalysis
The Project Analysis a query that joins data from project ledger entries with project master data.
Properties
| Name | Value |
|---|---|
| QueryType | Normal |
| DataAccessIntent | ReadOnly |
| UsageCategory | ReportsAndAnalysis |
| Caption | Project Ad-hoc Analysis |
| AboutTitle | About Project Ad-hoc Analysis |
| AboutText | The Project Analysis a query that joins data from project ledger entries with project master data. |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| JobNo | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| PostingDate | JobLedgerEntry | Date | The Project Analysis a query that joins data from project ledger entries with project master data. |
| DocumentNo | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| DocumentDate | JobLedgerEntry | Date | The Project Analysis a query that joins data from project ledger entries with project master data. |
| Type | JobLedgerEntry | Enum Microsoft.Projects.Project.Journal."Job Journal Line Type" | The Project Analysis a query that joins data from project ledger entries with project master data. |
| No | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| Description | JobLedgerEntry | Text[100] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| Quantity | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| DirectUnitCostLCY | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| UnitCostLCY | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| TotalCostLCY | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| UnitPriceLCY | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| TotalPriceLCY | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ResourceGroupNo | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| UnitOfMeasureCode | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| JobPostingGroup | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| AmtToPostToGL | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| AmtPostedToGL | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| EntryType | JobLedgerEntry | Enum Microsoft.Projects.Project.Journal."Job Journal Line Entry Type" | The Project Analysis a query that joins data from project ledger entries with project master data. |
| JournalBatchName | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ReasonCode | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| TransactionType | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| TransportMethod | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| CountryRegionCode | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| GenBusPostingGroup | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| GenProdPostingGroup | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| EntryExitPoint | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ExternalDocumentNo | JobLedgerEntry | Code[35] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| AreaCode | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| TransactionSpecification | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| NoSeries | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| AdditionalCurrencyTotalCost | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| AdditionalCurrencyTotalPrice | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| AdditionalCurrencyLineAmount | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LineAmountLCY | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| UnitCost | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| TotalCost | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| UnitPrice | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| TotalPrice | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LineAmount | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LineDiscountAmount | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LineDiscountAmountLCY | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| CurrencyCode | JobLedgerEntry | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| CurrencyFactor | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LedgerEntryType | JobLedgerEntry | Enum Microsoft.Projects.Project.Ledger."Job Ledger Entry Type" | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LedgerEntryNo | JobLedgerEntry | Integer | The Project Analysis a query that joins data from project ledger entries with project master data. |
| SerialNo | JobLedgerEntry | Code[50] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LotNo | JobLedgerEntry | Code[50] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LineDiscountPercent | JobLedgerEntry | Decimal | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LineType | JobLedgerEntry | Enum Microsoft.Projects.Project.Job."Job Line Type" | The Project Analysis a query that joins data from project ledger entries with project master data. |
| GlobalDimension1Code | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| GlobalDimension2Code | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ShortcutDimension3Code | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ShortcutDimension4Code | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ShortcutDimension5Code | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ShortcutDimension6Code | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ShortcutDimension7Code | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| ShortcutDimension8Code | JobLedgerEntry | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| JobDescription | Job | Text[100] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| JobTaskNo | JobTask | Code[20] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| JobTaskDescription | JobTask | Text[100] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| WorkTypeCode | WorkType | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| WorkTypeDescription | WorkType | Text[100] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LocationCode | Location | Code[10] | The Project Analysis a query that joins data from project ledger entries with project master data. |
| LocationName | Location | Text[100] | The Project Analysis a query that joins data from project ledger entries with project master data. |