msdyn_project EntityType

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_projects
Base Type
crmbaseentity
Display Name
Project
Primary Key
msdyn_projectid
Primary Key Attribute
msdyn_subject
Operations Supported
POST GET PATCH DELETE

Properties

Properties represent fields of data stored in the entity.Some properties are read-only.

Name Type Details
createdon Edm.DateTimeOffset

Date and time when the record was created.

Display Name: Created On

Read Only
exchangerate Edm.Decimal

Shows the exchange rate for the currency associated with the entity with respect to the base currency.

Display Name: Exchange Rate

Read Only
importsequencenumber Edm.Int32

Sequence number of the import that created this record.

Display Name: Import Sequence Number

modifiedon Edm.DateTimeOffset

Date and time when the record was modified.

Display Name: Modified On

Read Only
msdyn_actualdurationminutes Edm.Int32

Shows the actual duration of the project in minutes.

Display Name: Actual Duration

msdyn_actualend Edm.DateTimeOffset

Enter the actual end time of the project.

Display Name: Actual End

msdyn_actualhours Edm.Decimal

Shows the total actual hours of the project

Display Name: Actual Hours

msdyn_actualsales Edm.Decimal

Shows the actual sales value.

Display Name: Actual Sales

msdyn_actualsales_base Edm.Decimal

Shows the value of the actual sales in the base currency.

Display Name: Actual Sales (Base)

Read Only
msdyn_actualstart Edm.DateTimeOffset

Enter the actual start time of the project.

Display Name: Actual Start

msdyn_bulkgenerationstatus Edm.Int32

The status of the bulk generation operations running on the project entity. If no operation is running, the value is null.

Display Name: Bulk Generation Status

Default Options
Value Label
192350000 Processing
192350001 Failed
msdyn_calendarid Edm.String

Id of the calendar for the project.

Display Name: Calendar Id

msdyn_comments Edm.String

Enter the comments that are used to describe the current project status.

Display Name: Comments

msdyn_costconsumption Edm.Decimal

Shows the actual cost divided by the estimated cost at completion.

Display Name: Cost Consumption %

Read Only
Is Computed
msdyn_costestimateatcomplete Edm.Decimal

Sum of Actual Cost and Remaining cost

Display Name: Cost estimate at completion (EAC)

Read Only
Is Computed
msdyn_costestimateatcomplete_base Edm.Decimal

Value of the Cost estimate at completion (EAC) in base currency.

Display Name: Cost estimate at completion (EAC)(Base)

Read Only
Is Computed
msdyn_costperformence Edm.Int32

Display Name: Cost Performance

Read Only
Is Computed
Default Options
Value Label
192350000 On Budget
192350001 Over Budget
192350002 Under Budget
msdyn_costvariance Edm.Decimal

Variance between the estimated cost and the forecasted cost based on the estimate at completion (EAC).

Display Name: Cost Variance

Read Only
Is Computed
msdyn_costvariance_base Edm.Decimal

Shows the value of the cost variance in the base currency.

Display Name: Cost Variance (Base)

Read Only
Is Computed
msdyn_description Edm.String

Enter a description of the project.

Display Name: Description

msdyn_disablecreateofteammemberformanager Edm.Boolean

This is an internal field, mainly used during import so that we don't create a team member record for the project manager.

Display Name: Disable create of team member for project manager

Default Options
Value Label
1 Yes
0 No
msdyn_effortestimateatcompleteeac Edm.Double

Shows the total of actual hours and the remaining hours.

Display Name: Effort estimate at complete (EAC)

msdyn_exchangerate Edm.Decimal

Exchange rate for the currency associated with the project with respect to the base currency.

Display Name: Exchange Rate

msdyn_islinkedtomsprojectclient Edm.Boolean

Specifies if the project is linked to a project in MS Project

Display Name: Is Linked To MS Project Client

Default Options
Value Label
1 Yes
0 No
msdyn_istemplate Edm.Boolean

Shows if the project is a project template.

Display Name: Is Template

Default Options
Value Label
1 Yes
0 No
msdyn_linkeddocumenturl Edm.String

The URL for the linked document.

Display Name: Linked Document URL

msdyn_overallprojectstatus Edm.Int32

Describes the project status.

Display Name: Overall Project Status

Default Options
Value Label
1 Green
2 Yellow
3 Red
msdyn_plannedhours Edm.Decimal

Shows the total estimate hours of the project.

Display Name: Estimated Hours

msdyn_plannedsales Edm.Decimal

Shows the total planned sales.

Display Name: Planned Sales

msdyn_plannedsales_base Edm.Decimal

Shows the value of the planned sales in the base currency.

Display Name: Planned Sales (Base)

Read Only
msdyn_progress Edm.Decimal

Shows the actual hours divided by effort at estimate.

Display Name: Progress %

msdyn_projectid Edm.Guid

Shows the entity instances.

Display Name: Project

msdyn_projectresourcerequirementsvisibletore Edm.Boolean

Indicates if the project resource requirements are visible to the resources assigned to the project.

Display Name: Project resource requirements visible to resources

Default Options
Value Label
1 Yes
0 No
msdyn_remainingcost Edm.Decimal

Shows the difference between the estimated cost and the actual cost.

Display Name: Remaining Cost

msdyn_remainingcost_base Edm.Decimal

Shows the value of the remaining cost in the base currency.

Display Name: Remaining Cost (Base)

Read Only
msdyn_remaininghours Edm.Double

Shows the difference between the estimate at completion (EAC) and the actual hours.

Display Name: Remaining Hours

msdyn_remainingsales Edm.Decimal

Shows the difference between estimated sales and the actual sales.

Display Name: Remaining Sales

msdyn_remainingsales_base Edm.Decimal

Shows the value of the remaining sales in the base currency.

Display Name: Remaining Sales (Base)

Read Only
msdyn_salesconsumption Edm.Decimal

Shows the actual sales divided by the estimated sales.

Display Name: Sales Consumption %

Read Only
Is Computed
msdyn_salesestimateatcompleteeac Edm.Decimal

Shows the total of actual and remaining sales.

Display Name: Sales Estimate At Complete (EAC)

Read Only
Is Computed
msdyn_salesestimateatcompleteeac_base Edm.Decimal

Value of the Sales Estimate At Complete (EAC) in base currency.

Display Name: Sales Estimate At Complete (EAC) (Base)

Read Only
Is Computed
msdyn_salesvariance Edm.Decimal

Shows the difference between the planned sales and the sales estimate at completion (EAC).

Display Name: Sales Variance

Read Only
Is Computed
msdyn_salesvariance_base Edm.Decimal

Shows the value of the sales variance in the base currency.

Display Name: Sales Variance (Base)

Read Only
Is Computed
msdyn_scheduleddurationminutes Edm.Int32

Shows the scheduled duration of the project, specified in minutes.

Display Name: Scheduled Duration

msdyn_scheduledend Edm.DateTimeOffset

Enter the scheduled end time of the project.

Display Name: Estimated Finish Date

msdyn_scheduledstart Edm.DateTimeOffset

Enter the scheduled start time of the project.

Display Name: Start Date

msdyn_scheduleperformance Edm.Int32

Describes the schedule performance of the project.

Display Name: Schedule Performance

Default Options
Value Label
192350000 On Time
192350001 Ahead
192350002 Behind
msdyn_schedulevariance Edm.Double

Shows the difference between the planned effort and the estimate at completion (EAC).

Display Name: Schedule Variance

msdyn_stagename Edm.String

Shows the stage of the project.

Display Name: Stage Name

msdyn_statusupdatedon Edm.DateTimeOffset

Shows the most recent update on a status field(comments or overall project status).

Display Name: Status Updated On

msdyn_subject Edm.String

Type the name of the custom entity.

Display Name: Name

msdyn_teamsize Edm.Int32

Shows the total number of team members assigned to this project

Display Name: Team Size

Read Only
Is Computed
msdyn_teamsize_date Edm.DateTimeOffset

Last Updated time of rollup field Team Size.

Display Name: Team Size (Last Updated On)

Read Only
msdyn_teamsize_state Edm.Int32

State of rollup field Team Size.

Display Name: Team Size (State)

Read Only
msdyn_totalactualcost Edm.Decimal

Shows the aggregated cost from actuals on the project.

Display Name: Actual Cost

msdyn_totalactualcost_base Edm.Decimal

Shows the value of the total actual cost in the base currency.

Display Name: Total Actual Cost (Base)

Read Only
msdyn_totalplannedcost Edm.Decimal

Shows the aggregate of the total planned cost of all the associated tasks.

Display Name: Estimated Cost

msdyn_totalplannedcost_base Edm.Decimal

Shows the value of the total planned cost in the base currency.

Display Name: Total Planned Cost (Base)

Read Only
msdyn_wbsduration Edm.Int32

Shows the work breakdown structure (WBS) duration in days.

Display Name: Duration

overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

processid Edm.Guid

Contains the id of the process associated with the entity.

Display Name: Process Id

statecode Edm.Int32

Status of the Project

Display Name: Project Status

Default Options
Value Label
0 Active
1 Inactive
statuscode Edm.Int32

Reason for the status of the Project

Display Name: Status Reason

Default Options
Value Label
1 Active
2 Inactive
timezoneruleversionnumber Edm.Int32

For internal use only.

Display Name: Time Zone Rule Version Number

traversedpath Edm.String

A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur.

Display Name: Traversed Path

utcconversiontimezonecode Edm.Int32

Time zone code that was in use when the record was created.

Display Name: UTC Conversion Time Zone Code

versionnumber Edm.Int64

Version Number

Display Name: Version Number

Read Only

Lookup Properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Retrieve data about lookup properties.

Name Single-valued navigation property Description
_createdby_value createdby

Unique identifier of the user who created the record.

_createdonbehalfby_value createdonbehalfby

Unique identifier of the delegate user who created the record.

_modifiedby_value modifiedby

Unique identifier of the user who modified the record.

_modifiedonbehalfby_value modifiedonbehalfby

Unique identifier of the delegate user who modified the record.

_msdyn_contractorganizationalunitid_value msdyn_ContractOrganizationalUnitId

Select the organizational unit sponsoring the project.

_msdyn_customer_value msdyn_customer

Enter the customer who the project is associated with.

_msdyn_projectmanager_value msdyn_projectmanager

Shows the project manager assigned to the project.

_msdyn_projectteamid_value msdyn_projectteamid

Select the Team associated with Project.

_msdyn_projecttemplate_value msdyn_ProjectTemplate

Select the project template behind the project.

_msdyn_salesorderid_value msdyn_salesorderid

Shows the contract for this project.

_msdyn_workhourtemplate_value msdyn_workhourtemplate

Select the work hour template used to create the project calendar.

_ownerid_value ownerid

Owner Id

_owningbusinessunit_value owningbusinessunit

Unique identifier for the business unit that owns the record

_owningteam_value owningteam

Unique identifier for the team that owns the record.

_owninguser_value owninguser

Unique identifier for the user that owns the record.

_stageid_value stageid

Contains the id of the stage where the entity is located.

_transactioncurrencyid_value transactioncurrencyid

Shows the currency associated with the entity.

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name Type Partner
createdby systemuser lk_msdyn_project_createdby
createdonbehalfby systemuser lk_msdyn_project_createdonbehalfby
modifiedby systemuser lk_msdyn_project_modifiedby
modifiedonbehalfby systemuser lk_msdyn_project_modifiedonbehalfby
msdyn_ContractOrganizationalUnitId msdyn_organizationalunit msdyn_organizationalunit_project
msdyn_customer account msdyn_account_msdyn_project_Customer
msdyn_projectmanager systemuser msdyn_systemuser_msdyn_project_projectmanager
msdyn_projectteamid team msdyn_team_msdyn_project_projectteamid
msdyn_ProjectTemplate msdyn_project msdyn_msdyn_project_msdyn_project_ProjectTemplate
msdyn_salesorderid salesorder msdyn_salesorder_msdyn_project_salesorderid
msdyn_workhourtemplate msdyn_workhourtemplate msdyn_msdyn_workhourtemplate_msdyn_project_workhourtemplate
ownerid principal owner_msdyn_project
owningbusinessunit businessunit business_unit_msdyn_project
owningteam team team_msdyn_project
owninguser systemuser user_msdyn_project
stageid processstage processstage_msdyn_project
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_project

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name Type Partner
bpf_msdyn_project_msdyn_bpf_665e73aa18c247d886bfc50499c73b82 msdyn_bpf_665e73aa18c247d886bfc50499c73b82 bpf_msdyn_projectid
msdyn_msdyn_project_bookableresourcebooking_projectid bookableresourcebooking msdyn_projectid
msdyn_msdyn_project_bookableresourcebookingheader_projectid bookableresourcebookingheader msdyn_projectid
msdyn_msdyn_project_invoicedetail_Project invoicedetail msdyn_Project
msdyn_msdyn_project_msdyn_actual_Project msdyn_actual msdyn_Project
msdyn_msdyn_project_msdyn_contractlinescheduleofvalue_project msdyn_contractlinescheduleofvalue msdyn_project
msdyn_msdyn_project_msdyn_estimate_Project msdyn_estimate msdyn_Project
msdyn_msdyn_project_msdyn_estimateline_Project msdyn_estimateline msdyn_Project
msdyn_msdyn_project_msdyn_expense_Project msdyn_expense msdyn_Project
msdyn_msdyn_project_msdyn_fact_Project msdyn_fact msdyn_Project
msdyn_msdyn_project_msdyn_invoicelinetransaction_Project msdyn_invoicelinetransaction msdyn_Project
msdyn_msdyn_project_msdyn_journal_DefaultProject msdyn_journal msdyn_DefaultProject
msdyn_msdyn_project_msdyn_journalline_Project msdyn_journalline msdyn_Project
msdyn_msdyn_project_msdyn_opportunitylinetransaction_Project msdyn_opportunitylinetransaction msdyn_Project
msdyn_msdyn_project_msdyn_orderlinetransaction_Project msdyn_orderlinetransaction msdyn_Project
msdyn_msdyn_project_msdyn_project_ProjectTemplate msdyn_project msdyn_ProjectTemplate
msdyn_msdyn_project_msdyn_projectapproval_Project msdyn_projectapproval msdyn_Project
msdyn_msdyn_project_msdyn_projectpricelist_Project msdyn_projectpricelist msdyn_Project
msdyn_msdyn_project_msdyn_projecttask_project msdyn_projecttask msdyn_project
msdyn_msdyn_project_msdyn_projecttaskdependency_Project msdyn_projecttaskdependency msdyn_Project
msdyn_msdyn_project_msdyn_projectteam_project msdyn_projectteam msdyn_project
msdyn_msdyn_project_msdyn_projecttransactioncategory_Project msdyn_projecttransactioncategory msdyn_Project
msdyn_msdyn_project_msdyn_quotelinetransaction_Project msdyn_quotelinetransaction msdyn_Project
msdyn_msdyn_project_msdyn_resourceassignment_projectid msdyn_resourceassignment msdyn_projectid
msdyn_msdyn_project_msdyn_timeentry_project msdyn_timeentry msdyn_project
msdyn_msdyn_project_opportunityproduct_Project opportunityproduct msdyn_Project
msdyn_msdyn_project_quotedetail_Project quotedetail msdyn_Project
msdyn_msdyn_project_salesorderdetail_Project salesorderdetail msdyn_Project
msdyn_project_Annotations annotation objectid_msdyn_project
msdyn_project_AsyncOperations asyncoperation regardingobjectid_msdyn_project
msdyn_project_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_project
msdyn_project_connections1 connection record1id_msdyn_project
msdyn_project_connections2 connection record2id_msdyn_project
msdyn_project_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_project
msdyn_project_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_project
msdyn_project_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_project
msdyn_project_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_project
msdyn_project_ProcessSession processsession regardingobjectid_msdyn_project
msdyn_project_QueueItems queueitem objectid_msdyn_project
msdyn_project_resourcerequirement msdyn_resourcerequirement msdyn_projectid
msdyn_project_SharePointDocumentLocations sharepointdocumentlocation regardingobjectid_msdyn_project
msdyn_project_SyncErrors syncerror regardingobjectid_msdyn_project

Operations

The following operations can be used with the msdyn_project entity type.

Name Binding
GrantAccess Not Bound
IsValidStateTransition Not Bound
ModifyAccess Not Bound
msdyn_AutoGenerateProjectTeam Entity
msdyn_CopyProject Entity
msdyn_CopyRelatedProjectEntitiesFromTemplate Entity
msdyn_CopyWbsToProject Entity
msdyn_CreateTaskBasedEstimatesForProject Entity
msdyn_CreateTemplateFromProject Entity
msdyn_FetchProjectCalendarWorkHours Entity
msdyn_GetEstimatesforProject Entity
msdyn_GetProjectCurrencies Entity
msdyn_JoinProjectTeam Entity
msdyn_MoveProject Entity
msdyn_MSProject_ExportToProject Entity
msdyn_MSProject_LinkToProject Entity
msdyn_MSProject_PublishToExistingProject Entity
msdyn_MSProject_ReadFromExistingProject Entity
msdyn_MSProject_UnlinkFromProject Entity
msdyn_UpdateAllEstimatesForProject Entity
RetrievePrincipalAccess Not Bound
RetrieveSharedPrincipalsAndAccess Not Bound
RevokeAccess Not Bound

Solutions

The following solutions include the msdyn_project entity type.

Name Description
Project Service Automation Microsoft Dynamics 365 for Project Service Automation is an end-to-end solution that helps sales and delivery teams engage customers and deliver billable projects on time and within budget. Project Service gives you the tools you need to: Estimate, quote, and contract work; Plan and assign resources; Enable team collaboration; Capture time, expense, and progress data for real-time insights and accurate invoicing.

See Also