WipProject
Represents WIP project records within a WIP period, capturing financial metrics such as contract values, cost estimates, earned revenue, billings, and project manager forecast data.
Columns
| Name | Type | ReadOnly | Description |
| assignedEntity_Href | String | True |
The URL of the entity assigned to this WIP project. |
| assignedEntity_Id | String | False |
The Id of the entity assigned to this WIP project. |
| assignedEntity_Key | String | False |
The system-assigned key of the entity assigned to this WIP project. |
| assignedEntity_Name | String | True |
The name of the entity assigned to this WIP project. |
| auditCreatedBy | String | True |
The user who created the WIP project record. |
| auditCreatedDateTime | Datetime | True |
The date and time when the WIP project record was created. |
| auditModifiedBy | String | True |
The user who last modified the WIP project record. |
| auditModifiedDateTime | Datetime | True |
The date and time when the WIP project record was last modified. |
| basedOnPrimaryForecast | Bool | False |
Indicates whether this WIP project record is based on the primary forecast. |
| cfoForecastContractValue | Decimal | False |
The CFO forecast contract value for this WIP project. |
| cfoForecastCostAtCompletion | Decimal | False |
The CFO forecast total cost at completion for this WIP project. |
| cfoForecastCostToComplete | Decimal | False |
The CFO forecast remaining cost to complete this WIP project. |
| cfoForecastGrossProfitAtCompletion | Decimal | False |
The CFO forecast gross profit at completion for this WIP project. |
| cfoForecastGrossProfitMarginPercent | String | False |
The CFO forecast gross profit margin percentage for this WIP project. |
| cfoForecastLastUpdatedDate | Datetime | False |
The date and time when the CFO forecast was last updated for this WIP project. |
| cfoForecastPercentComplete | String | False |
The CFO forecast percentage of completion for this WIP project. |
| class_Href | String | True |
The URL of the class associated with this WIP project. |
| class_Id | String | False |
The Id of the class associated with this WIP project. |
| class_Key | String | False |
The system-assigned key of the class associated with this WIP project. |
| class_Name | String | True |
The name of the class associated with this WIP project. |
| contractVarianceAmount | Decimal | False |
The variance between the project manager forecast and CFO forecast contract values for this WIP project. |
| costAtCompletionVariance | Decimal | False |
The variance between the estimated cost at completion and the CFO forecast cost at completion for this WIP project. |
| createdFromEntity_Href | String | True |
The URL of the entity from which this WIP project was created. |
| createdFromEntity_Id | String | False |
The Id of the entity from which this WIP project was created. |
| createdFromEntity_Key | String | False |
The system-assigned key of the entity from which this WIP project was created. |
| createdFromEntity_Name | String | True |
The name of the entity from which this WIP project was created. |
| currentPeriodBillingAmount | Decimal | False |
The total billing amount for the current WIP period. |
| currentPeriodCostAmount | Decimal | False |
The total cost amount incurred during the current WIP period. |
| currentPeriodEarnedProfitAmount | Decimal | False |
The earned profit amount for the current WIP period. |
| currentPeriodEarnedRevenueAmount | Decimal | False |
The earned revenue amount for the current WIP period. |
| customer_Href | String | True |
The URL of the customer associated with this WIP project. |
| customer_Id | String | False |
The Id of the customer associated with this WIP project. |
| customer_Key | String | False |
The system-assigned key of the customer associated with this WIP project. |
| customer_Name | String | True |
The name of the customer associated with this WIP project. |
| department_Href | String | True |
The URL of the department associated with this WIP project. |
| department_Id | String | False |
The Id of the department associated with this WIP project. |
| department_Key | String | False |
The system-assigned key of the department associated with this WIP project. |
| department_Name | String | True |
The name of the department associated with this WIP project. |
| earnedProfitToDateAmount | Decimal | False |
The cumulative earned profit to date for this WIP project. |
| earnedToDateAmount | Decimal | False |
The cumulative earned revenue amount to date for this WIP project. |
| endOfPriorYearEarnedProfit | Decimal | False |
The earned profit amount as of the end of the prior fiscal year for this WIP project. |
| endOfPriorYearEarnedToDateAmount | Decimal | False |
The cumulative earned revenue amount as of the end of the prior fiscal year for this WIP project. |
| estimatedCostAtCompletion | Decimal | False |
The estimated total cost at completion for this WIP project. |
| estimatedCostToComplete | Decimal | False |
The estimated remaining cost to complete this WIP project. |
| estimatedCostToDateAmount | Decimal | False |
The estimated cumulative cost to date for this WIP project. |
| estimatedPercentComplete | String | False |
The estimated percentage of completion for this WIP project. |
| glPostedDate | Date | True |
The date on which the WIP project entry was posted to the general ledger. |
| grossProfitPercentOfContract | String | False |
The gross profit as a percentage of the total contract value for this WIP project. |
| grossProfitPercentOfCost | String | False |
The gross profit as a percentage of the total cost for this WIP project. |
| grossProfitVarianceAmount | Decimal | False |
The variance in gross profit between forecast values for this WIP project. |
| hasAnomaly | Bool | True |
Indicates whether this WIP project has a detected anomaly. |
| href | String | True |
The URL of the WIP project resource. |
| id | String | False |
The unique identifier of the WIP project record. |
| isBillingsComplete | Bool | False |
Indicates whether all billings for this WIP project are complete. |
| isCostsComplete | Bool | False |
Indicates whether all costs for this WIP project are complete. |
| isFinalized | Bool | False |
Indicates whether this WIP project has been finalized. |
| jobToDateBillings | Decimal | False |
The cumulative billings from project inception to date. |
| jobToDateCosts | Decimal | False |
The cumulative costs incurred from project inception to date. |
| jobToDateOverBillingAmount | Decimal | False |
The over-billing amount accumulated from project inception to date. |
| jobToDateOverbillingAmount | Decimal | False |
The alternate overbilling amount accumulated from project inception to date. |
| jobToDateUnderBillingAmount | Decimal | False |
The under-billing amount accumulated from project inception to date. |
| jobToDateUnderbillingAmount | Decimal | False |
The alternate underbilling amount accumulated from project inception to date. |
| key [KEY] | String | False |
The system-assigned key that uniquely identifies the WIP project record. |
| location_Href | String | True |
The URL of the location associated with this WIP project. |
| location_Id | String | False |
The Id of the location associated with this WIP project. |
| location_Key | String | False |
The system-assigned key of the location associated with this WIP project. |
| location_Name | String | True |
The name of the location associated with this WIP project. |
| manager_Href | String | True |
The URL of the manager associated with this WIP project. |
| manager_Id | String | False |
The Id of the manager associated with this WIP project. |
| manager_Key | String | False |
The system-assigned key of the manager associated with this WIP project. |
| manager_Name | String | True |
The name of the manager associated with this WIP project. |
| notes | String | False |
The notes or comments recorded on this WIP project. |
| overUnderBillingAmount | Decimal | False |
The net over or under billing amount for this WIP project. |
| pendingEstimatesAmount | Decimal | False |
The total amount of pending cost estimates for this WIP project. |
| periodEndDate | Date | False |
The end date of the WIP period associated with this WIP project. |
| priorYearsProfit | Decimal | False |
The cumulative profit earned in prior fiscal years for this WIP project. |
| projectManagerForecastContractValue | Decimal | False |
The project manager forecast contract value for this WIP project. |
| projectManagerForecastCostAtCompletion | Decimal | False |
The project manager forecast total cost at completion for this WIP project. |
| projectManagerForecastCostToComplete | Decimal | False |
The project manager forecast remaining cost to complete this WIP project. |
| projectManagerForecastLastUpdatedDate | Datetime | False |
The date and time when the project manager forecast was last updated for this WIP project. |
| projectManagerForecastPercentComplete | String | False |
The project manager forecast percentage of completion for this WIP project. |
| projectStatus_Href | String | True |
The URL of the project status associated with this WIP project. |
| projectStatus_Id | String | False |
The Id of the project status associated with this WIP project. |
| projectStatus_Key | String | False |
The system-assigned key of the project status associated with this WIP project. |
| projectType_Href | String | True |
The URL of the project type associated with this WIP project. |
| projectType_Id | String | False |
The Id of the project type associated with this WIP project. |
| projectType_Key | String | False |
The system-assigned key of the project type associated with this WIP project. |
| project_Description | String | True |
The description of the project associated with this WIP project. |
| project_EndDate | Date | True |
The end date of the project associated with this WIP project. |
| project_Href | String | True |
The URL of the project associated with this WIP project. |
| project_Id | String | False |
The Id of the project associated with this WIP project. |
| project_Key | String | False |
The system-assigned key of the project associated with this WIP project. |
| project_Name | String | True |
The name of the project associated with this WIP project. |
| project_ProjectCurrency | String | False |
The project currency of the project associated with this WIP project. |
| project_StartDate | Date | True |
The start date of the project associated with this WIP project. |
| project_Status | String | True |
The current status of the project associated with this WIP project. |
| remainingBacklogAmount | Decimal | False |
The remaining backlog amount for this WIP project, representing uninvoiced contracted revenue. |
| remainingProfit | Decimal | False |
The remaining profit expected upon completion of this WIP project. |
| totalContractValue | Decimal | False |
The total contract value for this WIP project. |
| totalGrossProfitEstimatedAtCompletion | Decimal | False |
The total estimated gross profit at completion for this WIP project. |
| wipPeriod_Href | String | True |
The URL of the WIP period associated with this WIP project. |
| wipPeriod_Id | String | False |
The Id of the WIP period associated with this WIP project. |
| wipPeriod_Key | String | False |
The system-assigned key of the WIP period associated with this WIP project. |
| wipPeriod_PeriodName | String | True |
The period name of the WIP period associated with this WIP project. |
| wipPeriod_WipCostBreakdownLevel | String | True |
The cost breakdown level of the WIP period associated with this WIP project. |
| yearToDateBillingAmount | Decimal | False |
The total billing amount for the current fiscal year to date. |
| yearToDateCostAmount | Decimal | False |
The total cost amount incurred for the current fiscal year to date. |
| yearToDateEarnedProfitAmount | Decimal | False |
The earned profit amount for the current fiscal year to date. |
| yearToDateEarnedRevenueAmount | Decimal | False |
The earned revenue amount for the current fiscal year to date. |
| ListAggregate_ForecastDetails | String | False |
The aggregate list of forecast details associated with this WIP project. |