Query "Project Planning Analysis"
The Project Planning Analysis is a query that joins data from project planning lines with project master data.
Properties
| Name | Value |
|---|---|
| QueryType | Normal |
| DataAccessIntent | ReadOnly |
| UsageCategory | ReportsAndAnalysis |
| Caption | Project Planning Analysis |
| AboutTitle | About Project Planning Analysis |
| AboutText | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| JobNo | JobPlanLine | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobTaskNo | JobPlanLine | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| LineNo | JobPlanLine | Integer | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| LineType | JobPlanLine | Enum Microsoft.Projects.Project.Planning."Job Planning Line Line Type" | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| PlanningDate | JobPlanLine | Date | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobPlanLineDocumentNo | JobPlanLine | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| Type | JobPlanLine | Enum Microsoft.Projects.Project.Planning."Job Planning Line Type" | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| TypeNo | JobPlanLine | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| WorkTypeCode | JobPlanLine | Code[10] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| Quantity | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| UnitOfMeasureCode | JobPlanLine | Code[10] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| UnitCost | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| TotalCost | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| UnitPrice | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| TotalPrice | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| LineDiscountAmount | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| LineAmount | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| TotalCostLCY | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| UnitPriceLCY | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| TotalPriceLCY | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| LineDiscountAmountLCY | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| LineAmountLCY | JobPlanLine | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobDesc | Job | Text[100] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| BillToCustNo | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| BillToName | Job | Text[100] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| BillToCountry | Job | Text[30] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| BillToCountryRegionCode | Job | Code[10] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| StartingDate | Job | Date | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| EndingDate | Job | Date | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| Status | Job | Enum Microsoft.Projects.Project.Job."Job Status" | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| PersonResponsible | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| GlobalDim1Code | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| GlobalDim2Code | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobPostingGroup | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| CustDiscGroup | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| CustPriceGroup | Job | Code[10] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| LocationCode | Job | Code[10] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| BinCode | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobWIPMethod | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| BillToContactNo | Job | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| BillToContact | Job | Text[100] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| ExDocNo | Job | Code[35] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobTaskDesc | JobTask | Text[100] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobTaskType | JobTask | Enum Microsoft.Projects.Project.Job."Job Task Type" | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| WIPTotal | JobTask | Option | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobTaskPostingGroup | JobTask | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobTaskWIPMethod | JobTask | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| DocumentType | JobPlanLineInv | Enum Microsoft.Projects.Project.Planning."Job Planning Line Invoice Document Type" | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| JobPlanLineInvDocNo | JobPlanLineInv | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| QuantityTransferred | JobPlanLineInv | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| InvoicedDate | JobPlanLineInv | Date | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| InvAmountLCY | JobPlanLineInv | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| InvCostAmtLCY | JobPlanLineInv | Decimal | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| ItemDescription | Item | Text[100] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| ItemCategoryCode | Item | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| ResourceName | Resource | Text[100] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| ResourceGroupNo | Resource | Code[20] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |
| GLAccName | GLAccount | Text[100] | The Project Planning Analysis is a query that joins data from project planning lines with project master data. |