Dynamics 365 Project Service Automation: List of all Primary Keys, Primary Fields and option sets

PSA version referenced: 3.11

Figuring out Primary Keys, Primary Fields and option set values in Dynamics 365 Project Service Automation sometimes takes a bit of time and effort. While there are some sources out these such as the Web API Reference and the Entity Reference, it makes life easier to have all relevant PSA entities and option sets easily available from a single source. This post will list all Primary Key + Primary Field pairs and option sets for PSA, excluding Business Process Flows and deprecated entities. I’ve used the Web API Reference as a source of PSA entities. If you’re not familiar with what Primary Keys and Primary Fields are, see the following two posts:
Understanding CRM Metadata: PrimaryKey and PrimaryField
Tip #1176: Handling the Primary Field

While the tables on this post are enabled for search and horizontal scrolling, using the original Excel files I’ve created may be easier and more convenient. They can be downloaded from the links below:
Primary Key + Primary Field pairs
PSA’s option sets

The Primary Key + Primary Field pairs are in the table below. A table with PSA’s option sets is found here.

PSA Primary Keys and Primary Fields

Entity Display NameEntity Logical NameLogical NameSchema NameDisplay NameAttribute Type
AccountaccountaccountidAccountIdAccountUniqueidentifier
AccountaccountnameNameAccount NameString
Account Project Price Listmsdyn_accountpricelistmsdyn_accountpricelistidmsdyn_accountpricelistIdAccount Price ListUniqueidentifier
Account Project Price Listmsdyn_accountpricelistmsdyn_descriptionmsdyn_descriptionDescriptionString
Actualmsdyn_actualmsdyn_actualidmsdyn_actualIdActualUniqueidentifier
Actualmsdyn_actualmsdyn_descriptionmsdyn_descriptionDescriptionString
Batch Jobmsdyn_batchjobmsdyn_batchjobidmsdyn_batchjobIdBatch JobUniqueidentifier
Batch Jobmsdyn_batchjobmsdyn_namemsdyn_nameNameString
Bookable ResourcebookableresourcebookableresourceidBookableResourceIdBookable ResourceUniqueidentifier
Bookable ResourcebookableresourcenameNameNameString
Bookable Resource BookingbookableresourcebookingbookableresourcebookingidBookableResourceBookingIdBookable Resource BookingUniqueidentifier
Bookable Resource BookingbookableresourcebookingnameNameNameString
Bookable Resource Booking HeaderbookableresourcebookingheaderbookableresourcebookingheaderidBookableResourceBookingHeaderIdBookable Resource Booking HeaderUniqueidentifier
Bookable Resource Booking HeaderbookableresourcebookingheadernameNameNameString
Bookable Resource CategorybookableresourcecategorybookableresourcecategoryidBookableResourceCategoryIdResource CategoryUniqueidentifier
Bookable Resource CategorybookableresourcecategorynameNameNameString
Bookable Resource Category AssnbookableresourcecategoryassnbookableresourcecategoryassnidBookableResourceCategoryAssnIdResource Category AssnUniqueidentifier
Bookable Resource Category AssnbookableresourcecategoryassnnameNameNameString
Bookable Resource CharacteristicbookableresourcecharacteristicbookableresourcecharacteristicidBookableResourceCharacteristicIdBookable Resource CharacteristicUniqueidentifier
Bookable Resource CharacteristicbookableresourcecharacteristicnameNameNameString
Booking StatusbookingstatusbookingstatusidBookingStatusIdBooking StatusUniqueidentifier
Booking StatusbookingstatusnameNameNameString
CharacteristiccharacteristiccharacteristicidCharacteristicIdCharacteristicUniqueidentifier
CharacteristiccharacteristicnameNameNameString
ContactcontactcontactidContactIdContactUniqueidentifier
ContactcontactfullnameFullNameFull NameString
Contact Price Listmsdyn_contactpricelistmsdyn_contactpricelistidmsdyn_contactpricelistIdContact Price ListUniqueidentifier
Contact Price Listmsdyn_contactpricelistmsdyn_descriptionmsdyn_descriptionDescriptionString
Delegationmsdyn_delegationmsdyn_delegationidmsdyn_delegationIdDelegationUniqueidentifier
Delegationmsdyn_delegationmsdyn_namemsdyn_nameNameString
Estimatemsdyn_estimatemsdyn_estimateidmsdyn_estimateIdEstimateUniqueidentifier
Estimatemsdyn_estimatemsdyn_descriptionmsdyn_descriptionDescriptionString
Estimate Linemsdyn_estimatelinemsdyn_estimatelineidmsdyn_estimatelineIdEstimate LineUniqueidentifier
Estimate Linemsdyn_estimatelinemsdyn_descriptionmsdyn_descriptionDescriptionString
Expensemsdyn_expensemsdyn_expenseidmsdyn_expenseIdExpenseUniqueidentifier
Expensemsdyn_expensemsdyn_namemsdyn_nameExpense PurposeString
Expense Categorymsdyn_expensecategorymsdyn_expensecategoryidmsdyn_expensecategoryIdExpense CategoryUniqueidentifier
Expense Categorymsdyn_expensecategorymsdyn_namemsdyn_nameNameString
Expense Receiptmsdyn_expensereceiptmsdyn_expensereceiptidmsdyn_expensereceiptIdExpense ReceiptUniqueidentifier
Expense Receiptmsdyn_expensereceiptmsdyn_descriptionmsdyn_descriptionDescriptionString
Factmsdyn_factmsdyn_factidmsdyn_factIdFactUniqueidentifier
Factmsdyn_factmsdyn_namemsdyn_nameNameString
Field Computationmsdyn_fieldcomputationmsdyn_fieldcomputationidmsdyn_fieldcomputationIdField ComputationUniqueidentifier
Field Computationmsdyn_fieldcomputationmsdyn_namemsdyn_nameNameString
Integration Jobmsdyn_integrationjobmsdyn_integrationjobidmsdyn_integrationjobIdIntegration JobUniqueidentifier
Integration Jobmsdyn_integrationjobmsdyn_namemsdyn_nameNameString
Integration Job Detailmsdyn_integrationjobdetailmsdyn_integrationjobdetailidmsdyn_integrationjobdetailIdIntegration Job DetailUniqueidentifier
Integration Job Detailmsdyn_integrationjobdetailmsdyn_namemsdyn_nameNameString
InvoiceinvoiceinvoiceidInvoiceIdInvoiceUniqueidentifier
InvoiceinvoicenameNameNameString
Invoice Frequencymsdyn_invoicefrequencymsdyn_invoicefrequencyidmsdyn_invoicefrequencyIdInvoice FrequencyUniqueidentifier
Invoice Frequencymsdyn_invoicefrequencymsdyn_namemsdyn_nameNameString
Invoice Frequency Detailmsdyn_invoicefrequencydetailmsdyn_invoicefrequencydetailidmsdyn_invoicefrequencydetailIdInvoice Frequency DetailUniqueidentifier
Invoice Frequency Detailmsdyn_invoicefrequencydetailmsdyn_namemsdyn_nameNameString
Invoice LineinvoicedetailinvoicedetailidInvoiceDetailIdInvoice ProductUniqueidentifier
Invoice LineinvoicedetailinvoicedetailnameInvoiceDetailNameNameString
Invoice Line Detailmsdyn_invoicelinetransactionmsdyn_invoicelinetransactionidmsdyn_invoicelinetransactionIdInvoice Line DetailUniqueidentifier
Invoice Line Detailmsdyn_invoicelinetransactionmsdyn_descriptionmsdyn_descriptionDescriptionString
Journalmsdyn_journalmsdyn_journalidmsdyn_journalIdJournalUniqueidentifier
Journalmsdyn_journalmsdyn_descriptionmsdyn_descriptionDescriptionString
Journal Linemsdyn_journallinemsdyn_journallineidmsdyn_journallineIdJournal LineUniqueidentifier
Journal Linemsdyn_journallinemsdyn_descriptionmsdyn_descriptionDescriptionString
LeadleadleadidLeadIdLeadUniqueidentifier
LeadleadfullnameFullNameNameString
OpportunityopportunityopportunityidOpportunityIdOpportunityUniqueidentifier
OpportunityopportunitynameNameTopicString
Opportunity LineopportunityproductopportunityproductidOpportunityProductIdOpportunity ProductUniqueidentifier
Opportunity LineopportunityproductopportunityproductnameOpportunityProductNameNameString
Opportunity Project Price Listmsdyn_opportunitypricelistmsdyn_opportunitypricelistidmsdyn_opportunitypricelistIdOpportunity Price ListUniqueidentifier
Opportunity Project Price Listmsdyn_opportunitypricelistmsdyn_descriptionmsdyn_descriptionDescriptionString
OrdersalesordersalesorderidSalesOrderIdOrderUniqueidentifier
OrdersalesordernameNameNameString
Order LinesalesorderdetailsalesorderdetailidSalesOrderDetailIdOrder ProductUniqueidentifier
Order LinesalesorderdetailsalesorderdetailnameSalesOrderDetailNameNameString
Organizational Unitmsdyn_organizationalunitmsdyn_organizationalunitidmsdyn_organizationalunitIdOrganizational UnitUniqueidentifier
Organizational Unitmsdyn_organizationalunitmsdyn_namemsdyn_nameNameString
Post Configurationmsdyn_postconfigmsdyn_postconfigidmsdyn_PostConfigIdPost ConfigurationUniqueidentifier
Post Configurationmsdyn_postconfigmsdyn_entitydisplaynamemsdyn_EntityDisplayNameEntity Display NameString
Post Rule Configurationmsdyn_postruleconfigmsdyn_postruleconfigidmsdyn_PostRuleConfigIdPost Rule Configuration IdUniqueidentifier
Post Rule Configurationmsdyn_postruleconfigmsdyn_namemsdyn_nameNameString
Price ListpricelevelpricelevelidPriceLevelIdPrice ListUniqueidentifier
Price ListpricelevelnameNameNameString
Process Notesmsdyn_processnotesmsdyn_processnotesidmsdyn_processnotesIdProcess NotesUniqueidentifier
Process Notesmsdyn_processnotesmsdyn_namemsdyn_nameNameString
ProductproductproductidProductIdProductUniqueidentifier
ProductproductnameNameNameString
Projectmsdyn_projectmsdyn_projectidmsdyn_projectIdProjectUniqueidentifier
Projectmsdyn_projectmsdyn_subjectmsdyn_subjectNameString
Project Approvalmsdyn_projectapprovalmsdyn_projectapprovalidmsdyn_projectapprovalIdApprovalsTableUniqueidentifier
Project Approvalmsdyn_projectapprovalmsdyn_namemsdyn_nameNameString
Project Contract Line Detailmsdyn_orderlinetransactionmsdyn_orderlinetransactionidmsdyn_orderlinetransactionIdProject contract line estimateUniqueidentifier
Project Contract Line Detailmsdyn_orderlinetransactionmsdyn_descriptionmsdyn_descriptionDescriptionString
Project Contract Line Invoice Schedulemsdyn_contractlineinvoiceschedulemsdyn_contractlineinvoicescheduleidmsdyn_contractlineinvoicescheduleIdProject Contract Line Invoice ScheduleUniqueidentifier
Project Contract Line Invoice Schedulemsdyn_contractlineinvoiceschedulemsdyn_namemsdyn_nameNameString
Project Contract Line Milestonemsdyn_contractlinescheduleofvaluemsdyn_contractlinescheduleofvalueidmsdyn_contractlinescheduleofvalueIdProject Contract Line MilestoneUniqueidentifier
Project Contract Line Milestonemsdyn_contractlinescheduleofvaluemsdyn_namemsdyn_nameMilestone NameString
Project Contract Line Resource Categorymsdyn_orderlineresourcecategorymsdyn_orderlineresourcecategoryidmsdyn_orderlineresourcecategoryIdProject Contract Line Resource CategoryUniqueidentifier
Project Contract Line Resource Categorymsdyn_orderlineresourcecategorymsdyn_descriptionmsdyn_descriptionDescriptionString
Project Contract Line Transaction Categorymsdyn_orderlinetransactioncategorymsdyn_orderlinetransactioncategoryidmsdyn_orderlinetransactioncategoryIdProject Contract Line Transaction CategoryUniqueidentifier
Project Contract Line Transaction Categorymsdyn_orderlinetransactioncategorymsdyn_descriptionmsdyn_descriptionDescriptionString
Project Contract Line Transaction Classificationmsdyn_orderlinetransactionclassificationmsdyn_orderlinetransactionclassificationidmsdyn_orderlinetransactionclassificationIdProject Contract Line Transaction ClassificationUniqueidentifier
Project Contract Line Transaction Classificationmsdyn_orderlinetransactionclassificationmsdyn_descriptionmsdyn_descriptionDescriptionString
Project Contract Project Price Listmsdyn_orderpricelistmsdyn_orderpricelistidmsdyn_orderpricelistIdProject Contract Price ListUniqueidentifier
Project Contract Project Price Listmsdyn_orderpricelistmsdyn_descriptionmsdyn_descriptionDescriptionString
Project Parametermsdyn_projectparametermsdyn_projectparameteridmsdyn_projectparameterIdProject ParameterUniqueidentifier
Project Parametermsdyn_projectparametermsdyn_descriptionmsdyn_descriptionDescriptionString
Project Parameter Price Listmsdyn_projectparameterpricelistmsdyn_projectparameterpricelistidmsdyn_projectparameterpricelistIdProject Parameter Price ListUniqueidentifier
Project Parameter Price Listmsdyn_projectparameterpricelistmsdyn_descriptionmsdyn_descriptionDescriptionString
Project Price Listmsdyn_projectpricelistmsdyn_projectpricelistidmsdyn_projectpricelistIdProject Price ListUniqueidentifier
Project Price Listmsdyn_projectpricelistmsdyn_descriptionmsdyn_descriptionDescriptionString
Project Service Approvalmsdyn_approvalactivityidActivityIdActivityUniqueidentifier
Project Service Approvalmsdyn_approvalsubjectSubjectSubjectString
Project Taskmsdyn_projecttaskmsdyn_projecttaskidmsdyn_projecttaskIdProject taskUniqueidentifier
Project Taskmsdyn_projecttaskmsdyn_subjectmsdyn_subjectProject Task NameString
Project Task Dependencymsdyn_projecttaskdependencymsdyn_projecttaskdependencyidmsdyn_projecttaskdependencyIdProject Task DependencyUniqueidentifier
Project Task Dependencymsdyn_projecttaskdependencymsdyn_descriptionmsdyn_descriptionDescriptionString
Project Task Status Usermsdyn_projecttaskstatususermsdyn_projecttaskstatususeridmsdyn_projecttaskstatususerIdProject Task Status UserUniqueidentifier
Project Task Status Usermsdyn_projecttaskstatususermsdyn_namemsdyn_nameNameString
Project Team Membermsdyn_projectteammsdyn_projectteamidmsdyn_projectteamIdProject TeamUniqueidentifier
Project Team Membermsdyn_projectteammsdyn_namemsdyn_namePosition NameString
QuotequotequoteidQuoteIdQuoteUniqueidentifier
QuotequotenameNameNameString
Quote LinequotedetailquotedetailidQuoteDetailIdQuote ProductUniqueidentifier
Quote LinequotedetailquotedetailnameQuoteDetailNameNameString
Quote Line Analytics Breakdownmsdyn_quotelineanalyticsbreakdownmsdyn_quotelineanalyticsbreakdownidmsdyn_quotelineanalyticsbreakdownIdQuote Line Analytics BreakdownUniqueidentifier
Quote Line Analytics Breakdownmsdyn_quotelineanalyticsbreakdownmsdyn_namemsdyn_nameNameString
Quote Line Detailmsdyn_quotelinetransactionmsdyn_quotelinetransactionidmsdyn_quotelinetransactionIdQuote Line DetailUniqueidentifier
Quote Line Detailmsdyn_quotelinetransactionmsdyn_descriptionmsdyn_descriptionDescriptionString
Quote Line Invoice Schedulemsdyn_quotelineinvoiceschedulemsdyn_quotelineinvoicescheduleidmsdyn_quotelineinvoicescheduleIdQuote Line Invoice ScheduleUniqueidentifier
Quote Line Invoice Schedulemsdyn_quotelineinvoiceschedulemsdyn_namemsdyn_nameNameString
Quote Line Milestonemsdyn_quotelinescheduleofvaluemsdyn_quotelinescheduleofvalueidmsdyn_quotelinescheduleofvalueIdQuote Line Schedule Of ValueUniqueidentifier
Quote Line Milestonemsdyn_quotelinescheduleofvaluemsdyn_namemsdyn_nameNameString
Quote Line Resource Categorymsdyn_quotelineresourcecategorymsdyn_quotelineresourcecategoryidmsdyn_quotelineresourcecategoryIdQuote Line Resource CategoryUniqueidentifier
Quote Line Resource Categorymsdyn_quotelineresourcecategorymsdyn_descriptionmsdyn_descriptionDescriptionString
Quote Line Transaction Categorymsdyn_quotelinetransactioncategorymsdyn_quotelinetransactioncategoryidmsdyn_quotelinetransactioncategoryIdQuote Line Transaction CategoryUniqueidentifier
Quote Line Transaction Categorymsdyn_quotelinetransactioncategorymsdyn_descriptionmsdyn_descriptionDescriptionString
Quote Line Transaction Classificationmsdyn_quotelinetransactionclassificationmsdyn_quotelinetransactionclassificationidmsdyn_quotelinetransactionclassificationIdQuote Line Transaction ClassificationUniqueidentifier
Quote Line Transaction Classificationmsdyn_quotelinetransactionclassificationmsdyn_descriptionmsdyn_descriptionDescriptionString
Quote Project Price Listmsdyn_quotepricelistmsdyn_quotepricelistidmsdyn_quotepricelistIdQuote Price ListUniqueidentifier
Quote Project Price Listmsdyn_quotepricelistmsdyn_descriptionmsdyn_descriptionDescriptionString
Rating ModelratingmodelratingmodelidRatingModelIdRating ModelUniqueidentifier
Rating ModelratingmodelnameNameNameString
Rating ValueratingvalueratingvalueidRatingValueIdRating ValueUniqueidentifier
Rating ValueratingvaluenameNameNameString
Requirement Resource Categorymsdyn_requirementresourcecategorymsdyn_requirementresourcecategoryidmsdyn_requirementresourcecategoryIdRequirement Resource CategoryUniqueidentifier
Requirement Resource Categorymsdyn_requirementresourcecategorymsdyn_namemsdyn_nameNameString
Resource Assignmentmsdyn_resourceassignmentmsdyn_resourceassignmentidmsdyn_resourceassignmentIdResource AssignmentUniqueidentifier
Resource Assignmentmsdyn_resourceassignmentmsdyn_namemsdyn_nameNameString
Resource Requestmsdyn_resourcerequestmsdyn_resourcerequestidmsdyn_resourcerequestIdResource RequestUniqueidentifier
Resource Requestmsdyn_resourcerequestmsdyn_namemsdyn_nameEntity NameString
Resource Requirementmsdyn_resourcerequirementmsdyn_resourcerequirementidmsdyn_resourcerequirementIdResource RequirementUniqueidentifier
Resource Requirementmsdyn_resourcerequirementmsdyn_namemsdyn_nameNameString
Resource Requirement Detailmsdyn_resourcerequirementdetailmsdyn_resourcerequirementdetailidmsdyn_resourcerequirementdetailIdResource Requirement DetailUniqueidentifier
Resource Requirement Detailmsdyn_resourcerequirementdetailmsdyn_namemsdyn_nameNameString
Result Cachemsdyn_mlresultcachemsdyn_mlresultcacheidmsdyn_mlresultcacheIdResult CacheUniqueidentifier
Result Cachemsdyn_mlresultcachemsdyn_namemsdyn_nameNameString
Role competency requirementmsdyn_rolecompetencyrequirementmsdyn_rolecompetencyrequirementidmsdyn_rolecompetencyrequirementIdRole competency requirementUniqueidentifier
Role competency requirementmsdyn_rolecompetencyrequirementmsdyn_namemsdyn_nameNameString
Role Pricemsdyn_resourcecategorypricelevelmsdyn_resourcecategorypricelevelidmsdyn_resourcecategorypricelevelIdResource Category PriceUniqueidentifier
Role Pricemsdyn_resourcecategorypricelevelmsdyn_descriptionmsdyn_descriptionDescriptionString
Role Utilizationmsdyn_roleutilizationmsdyn_roleutilizationidmsdyn_roleutilizationIdRole UtilizationUniqueidentifier
Role Utilizationmsdyn_roleutilizationmsdyn_namemsdyn_nameNameString
TasktaskactivityidActivityIdTaskUniqueidentifier
TasktasksubjectSubjectSubjectString
Time Entrymsdyn_timeentrymsdyn_timeentryidmsdyn_timeentryIdTime EntryUniqueidentifier
Time Entrymsdyn_timeentrymsdyn_descriptionmsdyn_descriptionDescriptionString
Time Off Calendarmsdyn_timeoffcalendarmsdyn_timeoffcalendaridmsdyn_timeoffcalendarIdTime Off CalendarUniqueidentifier
Time Off Calendarmsdyn_timeoffcalendarmsdyn_namemsdyn_nameNameString
Transaction Categorymsdyn_transactioncategorymsdyn_transactioncategoryidmsdyn_transactioncategoryIdTransaction CategoryUniqueidentifier
Transaction Categorymsdyn_transactioncategorymsdyn_namemsdyn_nameNameString
Transaction Category Classificationmsdyn_transactioncategoryclassificationmsdyn_transactioncategoryclassificationidmsdyn_transactioncategoryclassificationIdTransaction Category ClassificationUniqueidentifier
Transaction Category Classificationmsdyn_transactioncategoryclassificationmsdyn_namemsdyn_nameNameString
Transaction Category Hierarchy Elementmsdyn_transactioncategoryhierarchyelementmsdyn_transactioncategoryhierarchyelementidmsdyn_transactioncategoryhierarchyelementIdTransaction Category Hierarchy ElementUniqueidentifier
Transaction Category Hierarchy Elementmsdyn_transactioncategoryhierarchyelementmsdyn_namemsdyn_nameNameString
Transaction Category Pricemsdyn_transactioncategorypricelevelmsdyn_transactioncategorypricelevelidmsdyn_transactioncategorypricelevelIdTransaction Category PriceUniqueidentifier
Transaction Category Pricemsdyn_transactioncategorypricelevelmsdyn_descriptionmsdyn_descriptionDescriptionString
Transaction Connectionmsdyn_transactionconnectionmsdyn_transactionconnectionidmsdyn_transactionconnectionIdTransaction ConnectionUniqueidentifier
Transaction Connectionmsdyn_transactionconnectionmsdyn_namemsdyn_nameNameString
Transaction Originmsdyn_transactionoriginmsdyn_transactionoriginidmsdyn_transactionoriginIdTransaction OriginUniqueidentifier
Transaction Originmsdyn_transactionoriginmsdyn_namemsdyn_nameNameString
Transaction Typemsdyn_transactiontypemsdyn_transactiontypeidmsdyn_transactiontypeIdTransaction Type IdUniqueidentifier
Transaction Typemsdyn_transactiontypemsdyn_namemsdyn_nameNameString
UsersystemusersystemuseridSystemUserIdUserUniqueidentifier
UsersystemuserfullnameFullNameFull NameString
User Work Historymsdyn_userworkhistorymsdyn_userworkhistoryidmsdyn_userworkhistoryIdUser Work HistoryUniqueidentifier
User Work Historymsdyn_userworkhistorymsdyn_namemsdyn_nameNameString
Work templatemsdyn_workhourtemplatemsdyn_workhourtemplateidmsdyn_workhourtemplateIdWork TemplateUniqueidentifier
Work templatemsdyn_workhourtemplatemsdyn_namemsdyn_nameNameString

Leave a Reply

Your email address will not be published. Required fields are marked *