PSA option sets

PSA version referenced: 3.11

Click here to navigate back to the previous page with Primary Keys and Primary Fields.

PSA option sets

Entity Display Name	Entity Logical Name	Logical Name	Schema Name	Display Name	Attribute Type	Additional data
Account	account	accountcategorycode	AccountCategoryCode	Category	Picklist	1: Preferred Customer 2: Standard Default: N/A
Account	account	accountclassificationcode	AccountClassificationCode	Classification	Picklist	1: Default Value Default: 1
Account	account	accountratingcode	AccountRatingCode	Account Rating	Picklist	1: Default Value Default: 1
Account	account	address1_addresstypecode	Address1_AddressTypeCode	Address 1: Address Type	Picklist	1: Bill To 2: Ship To 3: Primary 4: Other Default: N/A
Account	account	address1_freighttermscode	Address1_FreightTermsCode	Address 1: Freight Terms	Picklist	1: FOB 2: No Charge Default: N/A
Account	account	address1_shippingmethodcode	Address1_ShippingMethodCode	Address 1: Shipping Method	Picklist	1: Airborne 2: DHL 3: FedEx 4: UPS 5: Postal Mail 6: Full Load 7: Will Call Default: N/A
Account	account	address2_addresstypecode	Address2_AddressTypeCode	Address 2: Address Type	Picklist	1: Default Value Default: 1
Account	account	address2_freighttermscode	Address2_FreightTermsCode	Address 2: Freight Terms	Picklist	1: Default Value Default: 1
Account	account	address2_shippingmethodcode	Address2_ShippingMethodCode	Address 2: Shipping Method	Picklist	1: Default Value Default: 1
Account	account	businesstypecode	BusinessTypeCode	Business Type	Picklist	1: Default Value Default: 1
Account	account	customersizecode	CustomerSizeCode	Customer Size	Picklist	1: Default Value Default: 1
Account	account	customertypecode	CustomerTypeCode	Relationship Type	Picklist	1: Competitor 2: Consultant 3: Customer 4: Investor 5: Partner 6: Influencer 7: Press 8: Prospect 9: Reseller 10: Supplier 11: Vendor 12: Other Default: N/A
Account	account	industrycode	IndustryCode	Industry	Picklist	1: Accounting 2: Agriculture and Non-petrol Natural Resource Extraction 3: Broadcasting Printing and Publishing 4: Brokers 5: Building Supply Retail 6: Business Services 7: Consulting 8: Consumer Services 9: Design, Direction and Creative Management 10: Distributors, Dispatchers and Processors 11: Doctor's Offices and Clinics 12: Durable Manufacturing 13: Eating and Drinking Places 14: Entertainment Retail 15: Equipment Rental and Leasing 16: Financial 17: Food and Tobacco Processing 18: Inbound Capital Intensive Processing 19: Inbound Repair and Services 20: Insurance 21: Legal Services 22: Non-Durable Merchandise Retail 23: Outbound Consumer Service 24: Petrochemical Extraction and Distribution 25: Service Retail 26: SIG Affiliations 27: Social Services 28: Special Outbound Trade Contractors 29: Specialty Realty 30: Transportation 31: Utility Creation and Distribution 32: Vehicle Retail 33: Wholesale Default: N/A
Account	account	msdyn_travelchargetype	msdyn_TravelChargeType	Travel Charge Type	Picklist	690970000: Hourly 690970001: Mileage 690970002: Fixed 690970003: None Default: 690970003
Account	account	ownershipcode	OwnershipCode	Ownership	Picklist	1: Public 2: Private 3: Subsidiary 4: Other Default: N/A
Account	account	paymenttermscode	PaymentTermsCode	Payment Terms	Picklist	1: Net 30 2: 2% 10, Net 30 3: Net 45 4: Net 60 Default: N/A
Account	account	preferredappointmentdaycode	PreferredAppointmentDayCode	Preferred Day	Picklist	0: Sunday 1: Monday 2: Tuesday 3: Wednesday 4: Thursday 5: Friday 6: Saturday Default: N/A
Account	account	preferredappointmenttimecode	PreferredAppointmentTimeCode	Preferred Time	Picklist	1: Morning 2: Afternoon 3: Evening Default: N/A
Account	account	preferredcontactmethodcode	PreferredContactMethodCode	Preferred Method of Contact	Picklist	1: Any 2: Email 3: Phone 4: Fax 5: Mail Default: 1
Account	account	shippingmethodcode	ShippingMethodCode	Shipping Method	Picklist	1: Default Value Default: 1
Account	account	territorycode	TerritoryCode	Territory Code	Picklist	1: Default Value Default: 1
Bookable Resource	bookableresource	msdyn_endlocation	msdyn_EndLocation	End Location	Picklist	690970002: Location Agnostic 690970000: Resource Address 690970001: Organizational Unit Address Default: 690970002
Bookable Resource	bookableresource	msdyn_generictype	msdyn_GenericType	Generic Type (Deprecated)	Picklist	690970000: Service Center Default: N/A
Bookable Resource	bookableresource	msdyn_pooltype	msdyn_PoolType	Pool Type	MultiSelect OptionSet	192350000: Account 192350001: Contact 192350002: User 192350003: Equipment 192350004: Facility Default: N/A
Bookable Resource	bookableresource	msdyn_startlocation	msdyn_StartLocation	Start Location	Picklist	690970002: Location Agnostic 690970000: Resource Address 690970001: Organizational Unit Address Default: 690970002
Bookable Resource	bookableresource	resourcetype	ResourceType	Resource Type	Picklist	1: Generic 2: Contact 3: User 4: Equipment 5: Account 6: Crew 7: Facility 8: Pool Default: 3
Bookable Resource Booking	bookableresourcebooking	bookingtype	BookingType	Booking Type	Picklist	2: Liquid 1: Solid Default: 1
Bookable Resource Booking	bookableresourcebooking	msdyn_bookingmethod	msdyn_BookingMethod	Booking Method	Picklist	690970005: System - Agreement Schedule 690970001: Schedule Board 690970002: Mobile 690970003: Manual 690970004: Schedule Assistant Default: 690970003
Bookable Resource Booking	bookableresourcebooking	msdyn_worklocation	msdyn_WorkLocation	Work Location	Picklist	690970000: Onsite 690970001: Facility 690970002: Location Agnostic Default: N/A
Bookable Resource Booking Header	bookableresourcebookingheader	msdyn_bookingtype	msdyn_BookingType	Booking Type	Picklist	1: Solid 2: Liquid Default: 1
Bookable Resource Category	bookableresourcecategory	msdyn_billingtype	msdyn_billingtype	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Bookable Resource Characteristic	bookableresourcecharacteristic	msdyn_approvalstatus	msdyn_approvalstatus	Approval status	Picklist	192350000: Saved 192350001: Pending Approval 192350002: Rejected 192350003: Approved 192350004: Recalled Default: 192350003
Booking Status	bookingstatus	msdyn_committype	msdyn_committype	Commit Type	Picklist	192350004: Canceled 192350000: None 192350001: Hard Book 192350002: Soft Book 192350003: Proposed Default: N/A
Booking Status	bookingstatus	msdyn_fieldservicestatus	msdyn_FieldServiceStatus	Field Service Status	Picklist	690970000: Scheduled 690970001: Traveling 690970003: In Progress 690970002: On Break 690970004: Completed 690970005: Canceled Default: N/A
Booking Status	bookingstatus	msdyn_serviceappointmentstatus	msdyn_ServiceAppointmentStatus	ServiceAppointment Status	Picklist	3: Pending 4: Reserved 6: In Progress 7: Arrived 8: Completed 9: Canceled 10: No Show Default: N/A
Booking Status	bookingstatus	status	Status	Status	Picklist	1: Proposed 2: Committed 3: Canceled Default: 1
Characteristic	characteristic	characteristictype	CharacteristicType	Characteristic Type	Picklist	1: Skill 2: Certification Default: 1
Contact	contact	accountrolecode	AccountRoleCode	Role	Picklist	1: Decision Maker 2: Employee 3: Influencer Default: N/A
Contact	contact	address1_addresstypecode	Address1_AddressTypeCode	Address 1: Address Type	Picklist	1: Bill To 2: Ship To 3: Primary 4: Other Default: N/A
Contact	contact	address1_freighttermscode	Address1_FreightTermsCode	Address 1: Freight Terms	Picklist	1: FOB 2: No Charge Default: N/A
Contact	contact	address1_shippingmethodcode	Address1_ShippingMethodCode	Address 1: Shipping Method	Picklist	1: Airborne 2: DHL 3: FedEx 4: UPS 5: Postal Mail 6: Full Load 7: Will Call Default: N/A
Contact	contact	address2_addresstypecode	Address2_AddressTypeCode	Address 2: Address Type	Picklist	1: Default Value Default: 1
Contact	contact	address2_freighttermscode	Address2_FreightTermsCode	Address 2: Freight Terms	Picklist	1: Default Value Default: 1
Contact	contact	address2_shippingmethodcode	Address2_ShippingMethodCode	Address 2: Shipping Method	Picklist	1: Default Value Default: 1
Contact	contact	address3_addresstypecode	Address3_AddressTypeCode	Address 3: Address Type	Picklist	1: Default Value Default: N/A
Contact	contact	address3_freighttermscode	Address3_FreightTermsCode	Address 3: Freight Terms	Picklist	1: Default Value Default: N/A
Contact	contact	address3_shippingmethodcode	Address3_ShippingMethodCode	Address 3: Shipping Method	Picklist	1: Default Value Default: N/A
Contact	contact	customersizecode	CustomerSizeCode	Customer Size	Picklist	1: Default Value Default: 1
Contact	contact	customertypecode	CustomerTypeCode	Relationship Type	Picklist	1: Default Value Default: 1
Contact	contact	educationcode	EducationCode	Education	Picklist	1: Default Value Default: 1
Contact	contact	familystatuscode	FamilyStatusCode	Marital Status	Picklist	1: Single 2: Married 3: Divorced 4: Widowed Default: N/A
Contact	contact	gendercode	GenderCode	Gender	Picklist	1: Male 2: Female Default: N/A
Contact	contact	haschildrencode	HasChildrenCode	Has Children	Picklist	1: Default Value Default: 1
Contact	contact	leadsourcecode	LeadSourceCode	Lead Source	Picklist	1: Default Value Default: 1
Contact	contact	msdyn_orgchangestatus	msdyn_orgchangestatus	Org Change Status	Picklist	0: No 1: Yes 2: Ignore Default: 0
Contact	contact	paymenttermscode	PaymentTermsCode	Payment Terms	Picklist	1: Net 30 2: 2% 10, Net 30 3: Net 45 4: Net 60 Default: N/A
Contact	contact	preferredappointmentdaycode	PreferredAppointmentDayCode	Preferred Day	Picklist	0: Sunday 1: Monday 2: Tuesday 3: Wednesday 4: Thursday 5: Friday 6: Saturday Default: N/A
Contact	contact	preferredappointmenttimecode	PreferredAppointmentTimeCode	Preferred Time	Picklist	1: Morning 2: Afternoon 3: Evening Default: 1
Contact	contact	preferredcontactmethodcode	PreferredContactMethodCode	Preferred Method of Contact	Picklist	1: Any 2: Email 3: Phone 4: Fax 5: Mail Default: 1
Contact	contact	shippingmethodcode	ShippingMethodCode	Shipping Method	Picklist	1: Default Value Default: 1
Contact	contact	territorycode	TerritoryCode	Territory	Picklist	1: Default Value Default: 1
Invoice	invoice	msdyn_ordertype	msdyn_OrderType	Type	Picklist	192350000: Item based 690970002: Service-Maintenance Based 192350001: Work based Default: 192350000
Invoice	invoice	msdyn_projectinvoicestatus	msdyn_projectinvoicestatus	Project Invoice Status	Picklist	192350000: Draft 192350001: In Review 192350002: Confirmed 192350003: Invoice Paid Default: 192350000
Invoice	invoice	paymenttermscode	PaymentTermsCode	Payment Terms	Picklist	1: Net 30 2: 2% 10, Net 30 3: Net 45 4: Net 60 Default: N/A
Invoice	invoice	pricingerrorcode	PricingErrorCode	Pricing Error	Picklist	0: None 1: Detail Error 2: Missing Price Level 3: Inactive Price Level 4: Missing Quantity 5: Missing Unit Price 6: Missing Product 7: Invalid Product 8: Missing Pricing Code 9: Invalid Pricing Code 10: Missing UOM 11: Product Not In Price Level 12: Missing Price Level Amount 13: Missing Price Level Percentage 14: Missing Price 15: Missing Current Cost 16: Missing Standard Cost 17: Invalid Price Level Amount 18: Invalid Price Level Percentage 19: Invalid Price 20: Invalid Current Cost 21: Invalid Standard Cost 22: Invalid Rounding Policy 23: Invalid Rounding Option 24: Invalid Rounding Amount 25: Price Calculation Error 26: Invalid Discount Type 27: Discount Type Invalid State 28: Invalid Discount 29: Invalid Quantity 30: Invalid Pricing Precision 31: Missing Product Default UOM 32: Missing Product UOM Schedule 33: Inactive Discount Type 34: Invalid Price Level Currency 35: Price Attribute Out Of Range 36: Base Currency Attribute Overflow 37: Base Currency Attribute Underflow 38: Transaction currency is not set for the product price list item Default: 0
Invoice	invoice	prioritycode	PriorityCode	Priority	Picklist	1: Default Value Default: 1
Invoice	invoice	shippingmethodcode	ShippingMethodCode	Shipping Method	Picklist	1: Airborne 2: DHL 3: FedEx 4: UPS 5: Postal Mail 6: Full Load 7: Will Call Default: N/A
Invoice	invoice	shipto_freighttermscode	ShipTo_FreightTermsCode	Ship To Freight Terms	Picklist	1: Default Value Default: 1
Invoice	invoice	skippricecalculation	SkipPriceCalculation	Skip Price Calculation	Picklist	0: DoPriceCalcAlways 1: SkipPriceCalcOnRetrieve Default: 0
Invoice Line	invoicedetail	invoicestatecode	InvoiceStateCode	Invoice Status	Picklist	Default: N/A
Invoice Line	invoicedetail	msdyn_billingmethod	msdyn_BillingMethod	Billing Method	Picklist	192350000: Time and Material 192350001: Fixed Price Default: N/A
Invoice Line	invoicedetail	msdyn_linetype	msdyn_LineType	Line Type	Picklist	690970000: Project Service Line 690970001: Field Service Line Default: 690970001
Invoice Line	invoicedetail	pricingerrorcode	PricingErrorCode	Pricing Error	Picklist	0: None 1: Detail Error 2: Missing Price Level 3: Inactive Price Level 4: Missing Quantity 5: Missing Unit Price 6: Missing Product 7: Invalid Product 8: Missing Pricing Code 9: Invalid Pricing Code 10: Missing UOM 11: Product Not In Price Level 12: Missing Price Level Amount 13: Missing Price Level Percentage 14: Missing Price 15: Missing Current Cost 16: Missing Standard Cost 17: Invalid Price Level Amount 18: Invalid Price Level Percentage 19: Invalid Price 20: Invalid Current Cost 21: Invalid Standard Cost 22: Invalid Rounding Policy 23: Invalid Rounding Option 24: Invalid Rounding Amount 25: Price Calculation Error 26: Invalid Discount Type 27: Discount Type Invalid State 28: Invalid Discount 29: Invalid Quantity 30: Invalid Pricing Precision 31: Missing Product Default UOM 32: Missing Product UOM Schedule 33: Inactive Discount Type 34: Invalid Price Level Currency 35: Price Attribute Out Of Range 36: Base Currency Attribute Overflow 37: Base Currency Attribute Underflow 38: Transaction currency is not set for the product price list item Default: 0
Invoice Line	invoicedetail	producttypecode	ProductTypeCode	Product type	Picklist	1: Product 2: Bundle 3: Required Bundle Product 4: Optional Bundle Product 5: Project-based Service Default: 1
Invoice Line	invoicedetail	propertyconfigurationstatus	PropertyConfigurationStatus	Property Configuration	Picklist	0: Edit 1: Rectify 2: Not Configured Default: 2
Invoice Line	invoicedetail	shipto_freighttermscode	ShipTo_FreightTermsCode	Freight Terms	Picklist	1: FOB 2: No Charge Default: N/A
Invoice Line	invoicedetail	skippricecalculation	SkipPriceCalculation	Skip Price Calculation	Picklist	0: DoPriceCalcAlways 1: SkipPriceCalcOnCreate 2: SkipPriceCalcOnUpdate Default: 0
Lead	lead	address1_addresstypecode	Address1_AddressTypeCode	Address 1: Address Type	Picklist	1: Default Value Default: 1
Lead	lead	address1_shippingmethodcode	Address1_ShippingMethodCode	Address 1: Shipping Method	Picklist	1: Default Value Default: 1
Lead	lead	address2_addresstypecode	Address2_AddressTypeCode	Address 2: Address Type	Picklist	1: Default Value Default: 1
Lead	lead	address2_shippingmethodcode	Address2_ShippingMethodCode	Address 2: Shipping Method	Picklist	1: Default Value Default: 1
Lead	lead	budgetstatus	BudgetStatus	Budget	Picklist	0: No Committed Budget 1: May Buy 2: Can Buy 3: Will Buy Default: N/A
Lead	lead	industrycode	IndustryCode	Industry	Picklist	1: Accounting 2: Agriculture and Non-petrol Natural Resource Extraction 3: Broadcasting Printing and Publishing 4: Brokers 5: Building Supply Retail 6: Business Services 7: Consulting 8: Consumer Services 9: Design, Direction and Creative Management 10: Distributors, Dispatchers and Processors 11: Doctor's Offices and Clinics 12: Durable Manufacturing 13: Eating and Drinking Places 14: Entertainment Retail 15: Equipment Rental and Leasing 16: Financial 17: Food and Tobacco Processing 18: Inbound Capital Intensive Processing 19: Inbound Repair and Services 20: Insurance 21: Legal Services 22: Non-Durable Merchandise Retail 23: Outbound Consumer Service 24: Petrochemical Extraction and Distribution 25: Service Retail 26: SIG Affiliations 27: Social Services 28: Special Outbound Trade Contractors 29: Specialty Realty 30: Transportation 31: Utility Creation and Distribution 32: Vehicle Retail 33: Wholesale Default: N/A
Lead	lead	initialcommunication	InitialCommunication	Initial Communication	Picklist	0: Contacted 1: Not Contacted Default: N/A
Lead	lead	leadqualitycode	LeadQualityCode	Rating	Picklist	1: Hot 2: Warm 3: Cold Default: 2
Lead	lead	leadsourcecode	LeadSourceCode	Lead Source	Picklist	1: Advertisement 2: Employee Referral 3: External Referral 4: Partner 5: Public Relations 6: Seminar 7: Trade Show 8: Web 9: Word of Mouth 10: Other Default: N/A
Lead	lead	msdyn_leadgrade	msdyn_LeadGrade	Lead Grade	Picklist	0: Grade A 1: Grade B 2: Grade C 3: Grade D Default: N/A
Lead	lead	msdyn_leadscoretrend	msdyn_LeadScoreTrend	Lead Score Trend	Picklist	0: Improving 1: Steady 2: Declining 3: Not enough info Default: N/A
Lead	lead	msdyn_ordertype	msdyn_ordertype	Type	Picklist	192350001: Work based 192350000: Item based 690970002: Service-Maintenance Based Default: N/A
Lead	lead	need	Need	Need	Picklist	0: Must have 1: Should have 2: Good to have 3: No need Default: N/A
Lead	lead	preferredcontactmethodcode	PreferredContactMethodCode	Preferred Method of Contact	Picklist	1: Any 2: Email 3: Phone 4: Fax 5: Mail Default: 1
Lead	lead	prioritycode	PriorityCode	Priority	Picklist	1: Default Value Default: 1
Lead	lead	purchaseprocess	PurchaseProcess	Purchase Process	Picklist	0: Individual 1: Committee 2: Unknown Default: N/A
Lead	lead	purchasetimeframe	PurchaseTimeFrame	Purchase Timeframe	Picklist	0: Immediate 1: This Quarter 2: Next Quarter 3: This Year 4: Unknown Default: N/A
Lead	lead	salesstage	SalesStage	Sales Stage	Picklist	0: Qualify Default: N/A
Lead	lead	salesstagecode	SalesStageCode	Sales Stage Code	Picklist	1: Default Value Default: 1
Actual	msdyn_actual	msdyn_adjustmentstatus	msdyn_AdjustmentStatus	Adjustment Status ID	Picklist	192350000: In Process 192350001: Adjusted 192350002: Unadjustable Default: N/A
Actual	msdyn_actual	msdyn_amountmethod	msdyn_AmountMethod	Amount Method ID	Picklist	690970000: Tax Calculation 192350000: Multiply Quantity By Price 192350001: Fixed Price 192350002: Multiply Basis Quantity By Price 192350003: Multiply Basis Amount By Percent Default: 192350000
Actual	msdyn_actual	msdyn_billingstatus	msdyn_BillingStatus	Billing status	Picklist	690970000: Work order closed - posted 192350000: Unbilled Sales Created 192350001: Customer Invoice Created 192350002: Customer Invoice Posted 192350003: Canceled 192350004: Ready to Invoice Default: N/A
Actual	msdyn_actual	msdyn_billingtype	msdyn_BillingType	Billing type ID	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Actual	msdyn_actual	msdyn_customertype	msdyn_CustomerType	Customer type ID	Picklist	192350001: Account 192350002: Contact Default: 192350001
Actual	msdyn_actual	msdyn_journaltype	msdyn_JournalType	Journal Type	Picklist	690970000: Working Hours 690970001: Break 690970002: Travel 690970003: Overtime 690970004: Business Closure Default: N/A
Actual	msdyn_actual	msdyn_producttype	msdyn_ProductType	Product Type	Picklist	690970000: Inventory 690970001: Non-Inventory 690970002: Service Default: N/A
Actual	msdyn_actual	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Class	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Actual	msdyn_actual	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: N/A
Actual	msdyn_actual	msdyn_vendortype	msdyn_VendorType	Vendor Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Actual	msdyn_actual	msdyn_worklocation	msdyn_WorkLocation	Work Location	Picklist	690970000: Onsite 690970001: Facility 690970002: Location Agnostic Default: N/A
Project Service Approval	msdyn_approval	community	Community	Social Channel	Picklist	1: Facebook 2: Twitter 0: Other Default: N/A
Project Service Approval	msdyn_approval	deliveryprioritycode	DeliveryPriorityCode	Delivery Priority	Picklist	0: Low 1: Normal 2: High Default: 1
Project Service Approval	msdyn_approval	instancetypecode	InstanceTypeCode	Recurring Instance Type	Picklist	0: Not Recurring 1: Recurring Master 2: Recurring Instance 3: Recurring Exception 4: Recurring Future Exception Default: 0
Project Service Approval	msdyn_approval	msdyn_approvalstatus	msdyn_approvalstatus	Approval Status	Picklist	192350000: Saved 192350001: Pending Approval 192350002: Rejected 192350003: Approved 192350004: Recalled Default: 192350001
Project Service Approval	msdyn_approval	prioritycode	PriorityCode	Priority	Picklist	0: Low 1: Normal 2: High Default: 1
Batch Job	msdyn_batchjob	msdyn_frequency	msdyn_frequency	Frequency	Picklist	0: Daily 1: Monthly Default: N/A
Batch Job	msdyn_batchjob	msdyn_jobtype	msdyn_JobType	Job Type	Picklist	867380000: None 867380001: Training 867380005: Waiting 867380006: Idle Default: 867380000
Batch Job	msdyn_batchjob	msdyn_operationtype	msdyn_operationtype	Operation Type	Picklist	0: None 1: Create 2: Update 3: Delete Default: 0
Project Contract Line Invoice Schedule	msdyn_contractlineinvoiceschedule	msdyn_invoicerunstatus	msdyn_InvoiceRunStatus	Invoice Status	Picklist	192350000: Not Run 192350001: Run Successful 192350002: Run Failed Default: 192350000
Project Contract Line Milestone	msdyn_contractlinescheduleofvalue	msdyn_invoicestatus	msdyn_Invoicestatus	Invoice Status	Picklist	192350000: Not Ready for invoicing 192350001: Ready for invoicing 192350002: Customer invoice created 192350003: Customer invoice posted Default: N/A
Project Contract Line Milestone	msdyn_contractlinescheduleofvalue	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Class	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: 192350003
Project Contract Line Milestone	msdyn_contractlinescheduleofvalue	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: 192350004
Delegation	msdyn_delegation	msdyn_type	msdyn_type	Type	Picklist	192350000: Time Entry 192350001: Expense Default: N/A
Estimate	msdyn_estimate	msdyn_estimateheadertype	msdyn_estimateheadertype	Estimate Header Type	Picklist	192350000: Resource based estimate 192350001: Activity based estimate 192350002: Assignment based estimate 192350003: Custom estimate Default: 192350003
Estimate Line	msdyn_estimateline	msdyn_amountmethod	msdyn_AmountMethod	Amount Method	Picklist	690970000: Tax Calculation 192350000: Multiply Quantity By Price 192350001: Fixed Price 192350002: Multiply Basis Quantity By Price 192350003: Multiply Basis Amount By Percent Default: 192350000
Estimate Line	msdyn_estimateline	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Estimate Line	msdyn_estimateline	msdyn_customertype	msdyn_CustomerType	Customer Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Estimate Line	msdyn_estimateline	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Class	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Estimate Line	msdyn_estimateline	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: N/A
Estimate Line	msdyn_estimateline	msdyn_vendortype	msdyn_VendorType	Vendor Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Expense	msdyn_expense	msdyn_expensestatus	msdyn_ExpenseStatus	Expense Status	Picklist	192350000: Draft 192350001: Submitted 192350002: Approved 192350003: Rejected 192350004: Posted 192350005: Paid 192350006: Recall Requested Default: 192350000
Expense	msdyn_expense	msdyn_targetexpensestatus	msdyn_targetExpenseStatus	Target Expense Status	Picklist	192350000: Draft 192350001: Submitted 192350002: Approved 192350003: Rejected 192350004: Posted 192350005: Paid 192350006: Recall Requested Default: 192350000
Expense Category	msdyn_expensecategory	msdyn_expensetype	msdyn_ExpenseType	Expense Type	Picklist	192350001: Car Rental 192350002: Meal 192350003: Airline 192350004: Entertainment 192350005: Gift 192350006: Conference 192350007: Miscellaneous 192350008: Mileage 192350009: Per diem 192350000: Hotel Default: N/A
Expense Category	msdyn_expensecategory	msdyn_receiptrequired	msdyn_ReceiptRequired	Receipt Required	Picklist	192350000: Optional 192350001: Mandatory Default: 192350000
Fact	msdyn_fact	msdyn_customertype	msdyn_CustomerType	Customer Type	Picklist	192350001: Account 192350002: Contact Default: N/A
Fact	msdyn_fact	msdyn_facttype	msdyn_FactType	Fact Type	Picklist	192350000: Actual 192350001: Estimate Default: N/A
Fact	msdyn_fact	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Fact	msdyn_fact	msdyn_vendortype	msdyn_VendorType	Vendor Type	Picklist	192350001: Account 192350002: Contact Default: N/A
Field Computation	msdyn_fieldcomputation	msdyn_computedfield	msdyn_ComputedField	Computed Transaction Field	Picklist	192350001: Quantity Default: 192350001
Integration Job	msdyn_integrationjob	msdyn_status	msdyn_Status	Status	Picklist	192350000: Waiting 192350001: Ready 192350002: Skipped 192350003: Processing 192350004: Succeeded 192350005: Failed Default: 192350001
Integration Job	msdyn_integrationjob	msdyn_type	msdyn_Type	Type	Picklist	192350000: MS Project Client Default: N/A
Invoice Frequency	msdyn_invoicefrequency	msdyn_daysofrun	msdyn_daysofrun	Setup of runs	Picklist	192350000: Day of period 192350001: Weekday of period Default: 192350001
Invoice Frequency	msdyn_invoicefrequency	msdyn_period	msdyn_period	Period	Picklist	192350000: Weekly 192350001: Monthly 192350002: Biweekly Default: 192350001
Invoice Frequency	msdyn_invoicefrequency	msdyn_runspermonth	msdyn_runspermonth	Runs per period	Picklist	1: 1 2: 2 3: 3 4: 4 Default: 1
Invoice Frequency Detail	msdyn_invoicefrequencydetail	msdyn_dayofmonth	msdyn_dayofmonth	Day of month	Picklist	192350001: 1 192350002: 2 192350003: 3 192350004: 4 192350005: 5 192350006: 6 192350007: 7 192350008: 8 192350009: 9 192350010: 10 192350011: 11 192350012: 12 192350013: 13 192350014: 14 192350015: 15 192350016: 16 192350017: 17 192350018: 18 192350019: 19 192350020: 20 192350021: 21 192350022: 22 192350023: 23 192350024: 24 192350025: 25 192350026: 26 192350027: 27 192350028: 28 192350029: 29 192350030: 30 192350031: 31 Default: 192350001
Invoice Frequency Detail	msdyn_invoicefrequencydetail	msdyn_occurrenceofweekday	msdyn_occurrenceofweekday	Occurrence of weekday	Picklist	192350000: First 192350001: Second 192350002: Third 192350003: Fourth 192350004: Last Default: N/A
Invoice Frequency Detail	msdyn_invoicefrequencydetail	msdyn_weekday	msdyn_weekday	Weekday	Picklist	192350000: Sunday 192350001: Monday 192350002: Tuesday 192350003: Wednesday 192350004: Thursday 192350005: Friday 192350006: Saturday Default: N/A
Invoice Line Detail	msdyn_invoicelinetransaction	msdyn_amountmethod	msdyn_AmountMethod	Amount Method	Picklist	690970000: Tax Calculation 192350000: Multiply Quantity By Price 192350001: Fixed Price 192350002: Multiply Basis Quantity By Price 192350003: Multiply Basis Amount By Percent Default: 192350000
Invoice Line Detail	msdyn_invoicelinetransaction	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Invoice Line Detail	msdyn_invoicelinetransaction	msdyn_customertype	msdyn_CustomerType	Customer Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Invoice Line Detail	msdyn_invoicelinetransaction	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Class	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Invoice Line Detail	msdyn_invoicelinetransaction	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: 192350006
Invoice Line Detail	msdyn_invoicelinetransaction	msdyn_vendortype	msdyn_VendorType	Vendor Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Journal	msdyn_journal	msdyn_journaltype	msdyn_JournalType	Journal Type	Picklist	192350000: Entry 192350001: Time Correction 192350002: Expense Correction Default: 192350000
Journal Line	msdyn_journalline	msdyn_amountmethod	msdyn_AmountMethod	Amount Method	Picklist	690970000: Tax Calculation 192350000: Multiply Quantity By Price 192350001: Fixed Price 192350002: Multiply Basis Quantity By Price 192350003: Multiply Basis Amount By Percent Default: 192350000
Journal Line	msdyn_journalline	msdyn_billingstatus	msdyn_BillingStatus	Billing Status	Picklist	690970000: Work order closed - posted 192350000: Unbilled Sales Created 192350001: Customer Invoice Created 192350002: Customer Invoice Posted 192350003: Canceled 192350004: Ready to Invoice Default: N/A
Journal Line	msdyn_journalline	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Journal Line	msdyn_journalline	msdyn_customertype	msdyn_CustomerType	Customer Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Journal Line	msdyn_journalline	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Class	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Journal Line	msdyn_journalline	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: N/A
Journal Line	msdyn_journalline	msdyn_vendortype	msdyn_VendorType	Vendor Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Opportunity Line Resource Category (Deprecated)	msdyn_opportunitylineresourcecategory	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Opportunity Line Transaction Category (Deprecated)	msdyn_opportunitylinetransactioncategory	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Opportunity Line Transaction Classification (Deprecated)	msdyn_opportunitylinetransactionclassificatio	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Opportunity Line Transaction Classification (Deprecated)	msdyn_opportunitylinetransactionclassificatio	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Project Contract Line Resource Category	msdyn_orderlineresourcecategory	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Project Contract Line Resource Category	msdyn_orderlineresourcecategory	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Project Contract Line Detail	msdyn_orderlinetransaction	msdyn_amountmethod	msdyn_AmountMethod	Amount Method	Picklist	690970000: Tax Calculation 192350000: Multiply Quantity By Price 192350001: Fixed Price 192350002: Multiply Basis Quantity By Price 192350003: Multiply Basis Amount By Percent Default: 192350000
Project Contract Line Detail	msdyn_orderlinetransaction	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Project Contract Line Detail	msdyn_orderlinetransaction	msdyn_customertype	msdyn_CustomerType	Customer Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Project Contract Line Detail	msdyn_orderlinetransaction	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Class	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Project Contract Line Detail	msdyn_orderlinetransaction	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: 192350004
Project Contract Line Detail	msdyn_orderlinetransaction	msdyn_vendortype	msdyn_VendorType	Vendor Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Project Contract Line Transaction Category	msdyn_orderlinetransactioncategory	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Project Contract Line Transaction Category	msdyn_orderlinetransactioncategory	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Project Contract Line Transaction Classification	msdyn_orderlinetransactionclassification	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Project Contract Line Transaction Classification	msdyn_orderlinetransactionclassification	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Type	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Project	msdyn_project	msdyn_bulkgenerationstatus	msdyn_BulkGenerationStatus	Bulk Generation Status	Picklist	192350000: Processing 192350001: Failed Default: N/A
Project	msdyn_project	msdyn_costperformence	msdyn_CostPerformence	Cost Performance	Picklist	192350000: On Budget 192350001: Over Budget 192350002: Under Budget Default: N/A
Project	msdyn_project	msdyn_overallprojectstatus	msdyn_overallprojectstatus	Overall Project Status	Picklist	1: Green 2: Yellow 3: Red Default: N/A
Project	msdyn_project	msdyn_scheduleperformance	msdyn_scheduleperformance	Schedule Performance	Picklist	192350000: On Time 192350001: Ahead 192350002: Behind Default: N/A
Project Approval	msdyn_projectapproval	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Project Approval	msdyn_projectapproval	msdyn_entrytype	msdyn_EntryType	Entry Type	Picklist	0: Time 1: Expense Default: N/A
Project Approval	msdyn_projectapproval	msdyn_recordstage	msdyn_recordstage	Record Stage	Picklist	3: Pending 0: Submitted 1: Rejected 2: Approved 4: Recall Requested 5: Recall Request Approved 6: Recall Request Rejected Default: 0
Project Parameter	msdyn_projectparameter	msdyn_resourceallocationmode	msdyn_resourceallocationmode	Resource allocation mode	Picklist	1: Centralized 2: Hybrid Default: 2
Project Task	msdyn_projecttask	msdyn_aggregationdirection	msdyn_AggregationDirection	Aggregation Direction	Picklist	0: Upstream 1: Downstream 2: Both Default: N/A
Project Task Dependency	msdyn_projecttaskdependency	msdyn_linktype	msdyn_LinkType	Link Type	Picklist	192350000: Finish-to-Start 192350001: Start-to-Start 192350002: Finish-to-Finish 192350004: Start-to-Finish Default: 192350000
Project Task Status User	msdyn_projecttaskstatususer	msdyn_projecttaskstatusindicator	msdyn_projecttaskstatusindicator	Project Task Status Indicator	Picklist	192350000: Green 192350001: Yellow 192350002: Red 192350003: None Default: N/A
Project Team Member	msdyn_projectteam	msdyn_allocationmethod	msdyn_allocationmethod	Allocation method	Picklist	192350000: None 192350001: Full Capacity 192350004: Percentage Capacity 192350003: By Hours - Distribute evenly 192350005: By Hours - Front load Default: 192350001
Project Team Member	msdyn_projectteam	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Project Team Member	msdyn_projectteam	msdyn_membershipstatus	msdyn_MembershipStatus	Membership Status (Deprecated in v3.0)	Picklist	1: Requested 2: Assigned 3: Declined Default: 2
Quote Line Analytics Breakdown	msdyn_quotelineanalyticsbreakdown	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Quote Line Analytics Breakdown	msdyn_quotelineanalyticsbreakdown	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Class	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Quote Line Analytics Breakdown	msdyn_quotelineanalyticsbreakdown	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: N/A
Quote Line Resource Category	msdyn_quotelineresourcecategory	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Quote Line Resource Category	msdyn_quotelineresourcecategory	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Quote Line Milestone	msdyn_quotelinescheduleofvalue	msdyn_invoicestatus	msdyn_invoicestatus	Invoice Status	Picklist	192350000: Not Ready for invoicing 192350001: Ready for invoicing 192350002: Customer invoice created 192350003: Customer invoice posted Default: N/A
Quote Line Detail	msdyn_quotelinetransaction	msdyn_amountmethod	msdyn_AmountMethod	Amount calculation method	Picklist	690970000: Tax Calculation 192350000: Multiply Quantity By Price 192350001: Fixed Price 192350002: Multiply Basis Quantity By Price 192350003: Multiply Basis Amount By Percent Default: 192350000
Quote Line Detail	msdyn_quotelinetransaction	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Quote Line Detail	msdyn_quotelinetransaction	msdyn_customertype	msdyn_CustomerType	Customer Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Quote Line Detail	msdyn_quotelinetransaction	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Class	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Quote Line Detail	msdyn_quotelinetransaction	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: 192350004
Quote Line Detail	msdyn_quotelinetransaction	msdyn_vendortype	msdyn_VendorType	Vendor Type	Picklist	192350001: Account 192350002: Contact Default: 192350001
Quote Line Transaction Category	msdyn_quotelinetransactioncategory	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Quote Line Transaction Category	msdyn_quotelinetransactioncategory	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Quote Line Transaction Classification	msdyn_quotelinetransactionclassification	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: 192350001
Quote Line Transaction Classification	msdyn_quotelinetransactionclassification	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Resource Assignment	msdyn_resourceassignment	msdyn_committype	msdyn_CommitType	Commit Type (Deprecated in v3.0)	Picklist	192350004: Canceled 192350000: None 192350001: Hard Book 192350002: Soft Book 192350003: Proposed Default: 192350001
Role Price	msdyn_resourcecategorypricelevel	msdyn_pricecalculation	msdyn_pricecalculation	Price Calculation	Picklist	192350000: Price per unit 192350001: At cost 192350002: Markup percentage Default: 192350000
Resource Requirement	msdyn_resourcerequirement	msdyn_allocationmethod	msdyn_allocationmethod	Allocation Method	Picklist	192350000: None 192350001: Full capacity 192350004: Percentage capacity 192350003: Distribute evenly 192350005: Front load Default: 192350000
Resource Requirement	msdyn_resourcerequirement	msdyn_pooltype	msdyn_PoolType	Pool Type	MultiSelect OptionSet	192350000: Account 192350001: Contact 192350002: User 192350003: Equipment 192350004: Facility Default: N/A
Resource Requirement	msdyn_resourcerequirement	msdyn_resourcetype	msdyn_resourcetype	Resource Type	MultiSelect OptionSet	1: Generic 2: Contact 3: User 4: Equipment 5: Account 6: Crew 7: Facility 8: Pool Default: N/A
Resource Requirement	msdyn_resourcerequirement	msdyn_type	msdyn_type	Type	Picklist	192350000: New 192350001: Extend Default: 192350000
Resource Requirement	msdyn_resourcerequirement	msdyn_worklocation	msdyn_WorkLocation	Work Location	Picklist	690970000: Onsite 690970001: Facility 690970002: Location Agnostic Default: 690970000
Role competency requirement	msdyn_rolecompetencyrequirement	msdyn_characteristictype	msdyn_characteristictype	Bookable Characteristic Type	Picklist	1: Skill 2: Certification Default: 1
Time Entry	msdyn_timeentry	msdyn_entrystatus	msdyn_entryStatus	Entry Status	Picklist	192350000: Draft 192350001: Returned 192350002: Approved 192350003: Submitted 192350004: Recall Requested Default: 192350000
Time Entry	msdyn_timeentry	msdyn_relateditemtype	msdyn_relatedItemType	Related item type	Picklist	192350000: None 192350001: Resource Booking 192350002: Resource Assignment 192350100: Exchange Appointments Default: 192350000
Time Entry	msdyn_timeentry	msdyn_targetentrystatus	msdyn_targetEntryStatus	Target Entry Status	Picklist	192350000: Draft 192350001: Returned 192350002: Approved 192350003: Submitted 192350004: Recall Requested Default: 192350000
Time Entry	msdyn_timeentry	msdyn_type	msdyn_type	Type	Picklist	192350000: Work 192350001: Absence 192350002: Vacation Default: 192350000
Transaction Category	msdyn_transactioncategory	msdyn_billingtype	msdyn_BillingType	Billing Type	Picklist	192350000: Non Chargeable 192350001: Chargeable 192350002: Complimentary 192350003: Not Available Default: N/A
Transaction Category Classification	msdyn_transactioncategoryclassification	msdyn_transactionclassification	msdyn_transactionclassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Transaction Category Price	msdyn_transactioncategorypricelevel	msdyn_pricecalculation	msdyn_pricecalculation	Price Calculation	Picklist	192350000: Price per unit 192350001: At cost 192350002: Markup percentage Default: 192350001
Transaction Type	msdyn_transactiontype	msdyn_transactionclassification	msdyn_TransactionClassification	Transaction Classification	Picklist	690970000: Commission 690970001: Additional 690970002: Tax 192350000: Time 192350001: Expense 192350002: Material 192350003: Milestone 192350004: Fee Default: N/A
Transaction Type	msdyn_transactiontype	msdyn_transactiontypecode	msdyn_TransactionTypeCode	Transaction Type Code	Picklist	192350000: Cost 192350004: Project Contract 192350005: Unbilled Sales 192350006: Billed Sales 192350007: Resourcing Unit Cost 192350008: Inter-Organizational Sales Default: 192350000
Opportunity	opportunity	budgetstatus	BudgetStatus	Budget	Picklist	0: No Committed Budget 1: May Buy 2: Can Buy 3: Will Buy Default: N/A
Opportunity	opportunity	initialcommunication	InitialCommunication	Initial Communication	Picklist	0: Contacted 1: Not Contacted Default: N/A
Opportunity	opportunity	msdyn_forecastcategory	msdyn_forecastcategory	Forecast category	Picklist	100000001: Pipeline (low confidence) 100000002: Best case (moderate confidence) 100000003: Committed (high confidence) 100000004: Omitted (exclude from forecast) Default: 100000001
Opportunity	opportunity	msdyn_opportunitygrade	msdyn_OpportunityGrade	Opportunity Grade	Picklist	0: Grade A 1: Grade B 2: Grade C 3: Grade D Default: N/A
Opportunity	opportunity	msdyn_opportunityscoretrend	msdyn_OpportunityScoreTrend	Opportunity Score Trend	Picklist	0: Improving 1: Steady 2: Declining 3: Not enough info Default: N/A
Opportunity	opportunity	msdyn_ordertype	msdyn_OrderType	Order Type	Picklist	192350000: Item based 690970002: Service-Maintenance Based 192350001: Work based Default: 192350000
Opportunity	opportunity	need	Need	Need	Picklist	0: Must have 1: Should have 2: Good to have 3: No need Default: N/A
Opportunity	opportunity	opportunityratingcode	OpportunityRatingCode	Rating	Picklist	1: Hot 2: Warm 3: Cold Default: 2
Opportunity	opportunity	pricingerrorcode	PricingErrorCode	Pricing Error	Picklist	0: None 1: Detail Error 2: Missing Price Level 3: Inactive Price Level 4: Missing Quantity 5: Missing Unit Price 6: Missing Product 7: Invalid Product 8: Missing Pricing Code 9: Invalid Pricing Code 10: Missing UOM 11: Product Not In Price Level 12: Missing Price Level Amount 13: Missing Price Level Percentage 14: Missing Price 15: Missing Current Cost 16: Missing Standard Cost 17: Invalid Price Level Amount 18: Invalid Price Level Percentage 19: Invalid Price 20: Invalid Current Cost 21: Invalid Standard Cost 22: Invalid Rounding Policy 23: Invalid Rounding Option 24: Invalid Rounding Amount 25: Price Calculation Error 26: Invalid Discount Type 27: Discount Type Invalid State 28: Invalid Discount 29: Invalid Quantity 30: Invalid Pricing Precision 31: Missing Product Default UOM 32: Missing Product UOM Schedule 33: Inactive Discount Type 34: Invalid Price Level Currency 35: Price Attribute Out Of Range 36: Base Currency Attribute Overflow 37: Base Currency Attribute Underflow 38: Transaction currency is not set for the product price list item Default: 0
Opportunity	opportunity	prioritycode	PriorityCode	Priority	Picklist	1: Default Value Default: 1
Opportunity	opportunity	purchaseprocess	PurchaseProcess	Purchase Process	Picklist	0: Individual 1: Committee 2: Unknown Default: N/A
Opportunity	opportunity	purchasetimeframe	PurchaseTimeframe	Purchase Timeframe	Picklist	0: Immediate 1: This Quarter 2: Next Quarter 3: This Year 4: Unknown Default: N/A
Opportunity	opportunity	salesstage	SalesStage	Sales Stage	Picklist	0: Qualify 1: Develop 2: Propose 3: Close Default: N/A
Opportunity	opportunity	salesstagecode	SalesStageCode	Process Code	Picklist	1: Default Value Default: 1
Opportunity	opportunity	skippricecalculation	SkipPriceCalculation	Skip Price Calculation	Picklist	0: DoPriceCalcAlways 1: SkipPriceCalcOnRetrieve Default: 0
Opportunity	opportunity	timeline	TimeLine	Timeline	Picklist	0: Immediate 1: This Quarter 2: Next Quarter 3: This Year 4: Not known Default: N/A
Opportunity Line	opportunityproduct	msdyn_billingmethod	msdyn_BillingMethod	Billing Method	Picklist	192350000: Time and Material 192350001: Fixed Price Default: N/A
Opportunity Line	opportunityproduct	msdyn_linetype	msdyn_LineType	Line Type	Picklist	690970000: Project Service Line 690970001: Field Service Line Default: N/A
Opportunity Line	opportunityproduct	opportunitystatecode	OpportunityStateCode	Opportunity Status	Picklist	Default: N/A
Opportunity Line	opportunityproduct	pricingerrorcode	PricingErrorCode	Pricing Error	Picklist	0: None 1: Detail Error 2: Missing Price Level 3: Inactive Price Level 4: Missing Quantity 5: Missing Unit Price 6: Missing Product 7: Invalid Product 8: Missing Pricing Code 9: Invalid Pricing Code 10: Missing UOM 11: Product Not In Price Level 12: Missing Price Level Amount 13: Missing Price Level Percentage 14: Missing Price 15: Missing Current Cost 16: Missing Standard Cost 17: Invalid Price Level Amount 18: Invalid Price Level Percentage 19: Invalid Price 20: Invalid Current Cost 21: Invalid Standard Cost 22: Invalid Rounding Policy 23: Invalid Rounding Option 24: Invalid Rounding Amount 25: Price Calculation Error 26: Invalid Discount Type 27: Discount Type Invalid State 28: Invalid Discount 29: Invalid Quantity 30: Invalid Pricing Precision 31: Missing Product Default UOM 32: Missing Product UOM Schedule 33: Inactive Discount Type 34: Invalid Price Level Currency 35: Price Attribute Out Of Range 36: Base Currency Attribute Overflow 37: Base Currency Attribute Underflow 38: Transaction currency is not set for the product price list item Default: 0
Opportunity Line	opportunityproduct	producttypecode	ProductTypeCode	Product type	Picklist	1: Product 2: Bundle 3: Required Bundle Product 4: Optional Bundle Product 5: Project-based Service Default: 1
Opportunity Line	opportunityproduct	propertyconfigurationstatus	PropertyConfigurationStatus	Property Configuration	Picklist	0: Edit 1: Rectify 2: Not Configured Default: 2
Opportunity Line	opportunityproduct	skippricecalculation	SkipPriceCalculation	Skip Price Calculation	Picklist	0: DoPriceCalcAlways 1: SkipPriceCalcOnCreate 2: SkipPriceCalcOnUpdate Default: 0
Price List	pricelevel	freighttermscode	FreightTermsCode	Freight Terms	Picklist	1: Default Value Default: 1
Price List	pricelevel	msdyn_entity	msdyn_Entity	Entity	Picklist	192350000: Organization 192350001: Customer 192350002: Sales document 192350003: Project Default: 192350000
Price List	pricelevel	msdyn_module	msdyn_Module	Context	Picklist	192350000: Cost 192350001: Purchase 192350002: Sales Default: 192350002
Price List	pricelevel	paymentmethodcode	PaymentMethodCode	Payment Method	Picklist	1: Default Value Default: 1
Price List	pricelevel	shippingmethodcode	ShippingMethodCode	Shipping Method	Picklist	1: Default Value Default: 1
Product	product	msdyn_fieldserviceproducttype	msdyn_FieldServiceProductType	Field Service Product Type	Picklist	690970000: Inventory 690970001: Non-Inventory 690970002: Service Default: N/A
Product	product	productstructure	ProductStructure	Product Structure	Picklist	1: Product 2: Product Family 3: Product Bundle Default: 1
Product	product	producttypecode	ProductTypeCode	Product Type	Picklist	1: Sales Inventory 2: Miscellaneous Charges 3: Services 4: Flat Fees Default: 1
Quote	quote	freighttermscode	FreightTermsCode	Freight Terms	Picklist	1: FOB 2: No Charge Default: N/A
Quote	quote	msdyn_competitive	msdyn_Competitive	Competitive	Picklist	192350000: Customer Budget Not Available 192350001: Within Customer Expectations 192350002: Outside Customer Expectations Default: 192350000
Quote	quote	msdyn_estimatedbudget	msdyn_EstimatedBudget	Estimated Budget	Picklist	192350000: Budget Estimate Not Available 192350001: Within Customer Budget 192350002: Exceeds Customer Budget Default: 192350000
Quote	quote	msdyn_estimatedschedule	msdyn_EstimatedSchedule	Estimated Schedule	Picklist	192350000: Schedule Not Available 192350001: Estimated To Finish Early 192350002: Estimated To Finish Late 192350003: Estimated To Finish On Schedule Default: 192350000
Quote	quote	msdyn_feasible	msdyn_feasible	Feasibility	Picklist	192350000: Feasibility Not Available 192350001: Feasible 192350002: Not Feasible Default: 192350000
Quote	quote	msdyn_ordertype	msdyn_OrderType	Order Type	Picklist	192350000: Item based 690970002: Service-Maintenance Based 192350001: Work based Default: 192350000
Quote	quote	msdyn_profitability	msdyn_Profitability	Profitability	Picklist	192350000: Profitability Not Available 192350001: Profitable 192350002: Not Profitable Default: 192350000
Quote	quote	paymenttermscode	PaymentTermsCode	Payment Terms	Picklist	1: Net 30 2: 2% 10, Net 30 3: Net 45 4: Net 60 Default: N/A
Quote	quote	pricingerrorcode	PricingErrorCode	Pricing Error	Picklist	0: None 1: Detail Error 2: Missing Price Level 3: Inactive Price Level 4: Missing Quantity 5: Missing Unit Price 6: Missing Product 7: Invalid Product 8: Missing Pricing Code 9: Invalid Pricing Code 10: Missing UOM 11: Product Not In Price Level 12: Missing Price Level Amount 13: Missing Price Level Percentage 14: Missing Price 15: Missing Current Cost 16: Missing Standard Cost 17: Invalid Price Level Amount 18: Invalid Price Level Percentage 19: Invalid Price 20: Invalid Current Cost 21: Invalid Standard Cost 22: Invalid Rounding Policy 23: Invalid Rounding Option 24: Invalid Rounding Amount 25: Price Calculation Error 26: Invalid Discount Type 27: Discount Type Invalid State 28: Invalid Discount 29: Invalid Quantity 30: Invalid Pricing Precision 31: Missing Product Default UOM 32: Missing Product UOM Schedule 33: Inactive Discount Type 34: Invalid Price Level Currency 35: Price Attribute Out Of Range 36: Base Currency Attribute Overflow 37: Base Currency Attribute Underflow 38: Transaction currency is not set for the product price list item Default: 0
Quote	quote	shippingmethodcode	ShippingMethodCode	Shipping Method	Picklist	1: Airborne 2: DHL 3: FedEx 4: UPS 5: Postal Mail 6: Full Load 7: Will Call Default: N/A
Quote	quote	shipto_freighttermscode	ShipTo_FreightTermsCode	Ship To Freight Terms	Picklist	1: Default Value Default: N/A
Quote	quote	skippricecalculation	SkipPriceCalculation	Skip Price Calculation	Picklist	0: DoPriceCalcAlways 1: SkipPriceCalcOnRetrieve Default: 0
Quote Line	quotedetail	msdyn_billingmethod	msdyn_BillingMethod	Billing Method	Picklist	192350000: Time and Material 192350001: Fixed Price Default: N/A
Quote Line	quotedetail	msdyn_linetype	msdyn_LineType	Line Type	Picklist	690970000: Project Service Line 690970001: Field Service Line Default: N/A
Quote Line	quotedetail	pricingerrorcode	PricingErrorCode	Pricing Error	Picklist	0: None 1: Detail Error 2: Missing Price Level 3: Inactive Price Level 4: Missing Quantity 5: Missing Unit Price 6: Missing Product 7: Invalid Product 8: Missing Pricing Code 9: Invalid Pricing Code 10: Missing UOM 11: Product Not In Price Level 12: Missing Price Level Amount 13: Missing Price Level Percentage 14: Missing Price 15: Missing Current Cost 16: Missing Standard Cost 17: Invalid Price Level Amount 18: Invalid Price Level Percentage 19: Invalid Price 20: Invalid Current Cost 21: Invalid Standard Cost 22: Invalid Rounding Policy 23: Invalid Rounding Option 24: Invalid Rounding Amount 25: Price Calculation Error 26: Invalid Discount Type 27: Discount Type Invalid State 28: Invalid Discount 29: Invalid Quantity 30: Invalid Pricing Precision 31: Missing Product Default UOM 32: Missing Product UOM Schedule 33: Inactive Discount Type 34: Invalid Price Level Currency 35: Price Attribute Out Of Range 36: Base Currency Attribute Overflow 37: Base Currency Attribute Underflow 38: Transaction currency is not set for the product price list item Default: 0
Quote Line	quotedetail	producttypecode	ProductTypeCode	Product type	Picklist	1: Product 2: Bundle 3: Required Bundle Product 4: Optional Bundle Product 5: Project-based Service Default: 1
Quote Line	quotedetail	propertyconfigurationstatus	PropertyConfigurationStatus	Property Configuration	Picklist	0: Edit 1: Rectify 2: Not Configured Default: 2
Quote Line	quotedetail	quotestatecode	QuoteStateCode	Quote Status	Picklist	Default: N/A
Quote Line	quotedetail	shipto_freighttermscode	ShipTo_FreightTermsCode	Freight Terms	Picklist	1: FOB 2: No Charge Default: N/A
Quote Line	quotedetail	skippricecalculation	SkipPriceCalculation	Skip Price Calculation	Picklist	0: DoPriceCalcAlways 1: SkipPriceCalcOnCreate 2: SkipPriceCalcOnUpdate Default: 0
Rating Model	ratingmodel	msdyn_ratableentity	msdyn_RatableEntity	Ratable Entity	Picklist	192350000: None 192350001: Skill Default: 192350000
Order	salesorder	freighttermscode	FreightTermsCode	Freight Terms	Picklist	1: FOB 2: No Charge Default: N/A
Order	salesorder	msdyn_ordertype	msdyn_ordertype	Order Type	Picklist	192350000: Item based 690970002: Service-Maintenance Based 192350001: Work based Default: 192350000
Order	salesorder	msdyn_psastate	msdyn_PSAState	Contract Status	Picklist	192350000: Draft 192350001: On hold 192350002: Active 192350003: Closed Default: 192350000
Order	salesorder	msdyn_psastatusreason	msdyn_PSAStatusReason	Contract Status Reason	Picklist	192350000: Draft 192350001: In review 192350002: On hold 192350003: Confirmed 192350004: Completed 192350005: Lost 192350006: Abandoned Default: 192350000
Order	salesorder	paymenttermscode	PaymentTermsCode	Payment Terms	Picklist	1: Net 30 2: 2% 10, Net 30 3: Net 45 4: Net 60 Default: N/A
Order	salesorder	pricingerrorcode	PricingErrorCode	Pricing Error	Picklist	0: None 1: Detail Error 2: Missing Price Level 3: Inactive Price Level 4: Missing Quantity 5: Missing Unit Price 6: Missing Product 7: Invalid Product 8: Missing Pricing Code 9: Invalid Pricing Code 10: Missing UOM 11: Product Not In Price Level 12: Missing Price Level Amount 13: Missing Price Level Percentage 14: Missing Price 15: Missing Current Cost 16: Missing Standard Cost 17: Invalid Price Level Amount 18: Invalid Price Level Percentage 19: Invalid Price 20: Invalid Current Cost 21: Invalid Standard Cost 22: Invalid Rounding Policy 23: Invalid Rounding Option 24: Invalid Rounding Amount 25: Price Calculation Error 26: Invalid Discount Type 27: Discount Type Invalid State 28: Invalid Discount 29: Invalid Quantity 30: Invalid Pricing Precision 31: Missing Product Default UOM 32: Missing Product UOM Schedule 33: Inactive Discount Type 34: Invalid Price Level Currency 35: Price Attribute Out Of Range 36: Base Currency Attribute Overflow 37: Base Currency Attribute Underflow 38: Transaction currency is not set for the product price list item Default: 0
Order	salesorder	prioritycode	PriorityCode	Priority	Picklist	1: Default Value Default: 1
Order	salesorder	shippingmethodcode	ShippingMethodCode	Shipping Method	Picklist	1: Airborne 2: DHL 3: FedEx 4: UPS 5: Postal Mail 6: Full Load 7: Will Call Default: N/A
Order	salesorder	shipto_freighttermscode	ShipTo_FreightTermsCode	Ship To Freight Terms	Picklist	1: Default Value Default: 1
Order	salesorder	skippricecalculation	SkipPriceCalculation	Skip Price Calculation (For Internal Use)	Picklist	0: DoPriceCalcAlways 1: SkipPriceCalcOnRetrieve Default: 0
Order Line	salesorderdetail	msdyn_billingmethod	msdyn_BillingMethod	Billing Method	Picklist	192350000: Time and Material 192350001: Fixed Price Default: N/A
Order Line	salesorderdetail	msdyn_billingstatus	msdyn_BillingStatus	Billing Status	Picklist	690970000: Work order closed - posted 192350000: Unbilled Sales Created 192350001: Customer Invoice Created 192350002: Customer Invoice Posted 192350003: Canceled 192350004: Ready to Invoice Default: N/A
Order Line	salesorderdetail	msdyn_linetype	msdyn_LineType	Line Type	Picklist	690970000: Project Service Line 690970001: Field Service Line Default: N/A
Order Line	salesorderdetail	pricingerrorcode	PricingErrorCode	Pricing Error	Picklist	0: None 1: Detail Error 2: Missing Price Level 3: Inactive Price Level 4: Missing Quantity 5: Missing Unit Price 6: Missing Product 7: Invalid Product 8: Missing Pricing Code 9: Invalid Pricing Code 10: Missing UOM 11: Product Not In Price Level 12: Missing Price Level Amount 13: Missing Price Level Percentage 14: Missing Price 15: Missing Current Cost 16: Missing Standard Cost 17: Invalid Price Level Amount 18: Invalid Price Level Percentage 19: Invalid Price 20: Invalid Current Cost 21: Invalid Standard Cost 22: Invalid Rounding Policy 23: Invalid Rounding Option 24: Invalid Rounding Amount 25: Price Calculation Error 26: Invalid Discount Type 27: Discount Type Invalid State 28: Invalid Discount 29: Invalid Quantity 30: Invalid Pricing Precision 31: Missing Product Default UOM 32: Missing Product UOM Schedule 33: Inactive Discount Type 34: Invalid Price Level Currency 35: Price Attribute Out Of Range 36: Base Currency Attribute Overflow 37: Base Currency Attribute Underflow 38: Transaction currency is not set for the product price list item Default: 0
Order Line	salesorderdetail	producttypecode	ProductTypeCode	Product type	Picklist	1: Product 2: Bundle 3: Required Bundle Product 4: Optional Bundle Product 5: Project-based Service Default: 1
Order Line	salesorderdetail	propertyconfigurationstatus	PropertyConfigurationStatus	Property Configuration	Picklist	0: Edit 1: Rectify 2: Not Configured Default: 2
Order Line	salesorderdetail	salesorderstatecode	SalesOrderStateCode	Order Status	Picklist	Default: N/A
Order Line	salesorderdetail	shipto_freighttermscode	ShipTo_FreightTermsCode	Freight Terms	Picklist	1: FOB 2: No Charge Default: N/A
Order Line	salesorderdetail	skippricecalculation	SkipPriceCalculation	Skip Price Calculation	Picklist	0: DoPriceCalcAlways 1: SkipPriceCalcOnCreate 2: SkipPriceCalcOnUpdate Default: 0
User	systemuser	accessmode	AccessMode	Access Mode	Picklist	0: Read-Write 1: Administrative 2: Read 3: Support User 4: Non-interactive 5: Delegated Admin Default: 0
User	systemuser	address1_addresstypecode	Address1_AddressTypeCode	Address 1: Address Type	Picklist	1: Default Value Default: 1
User	systemuser	address1_shippingmethodcode	Address1_ShippingMethodCode	Address 1: Shipping Method	Picklist	1: Default Value Default: 1
User	systemuser	address2_addresstypecode	Address2_AddressTypeCode	Address 2: Address Type	Picklist	1: Default Value Default: 1
User	systemuser	address2_shippingmethodcode	Address2_ShippingMethodCode	Address 2: Shipping Method	Picklist	1: Default Value Default: 1
User	systemuser	caltype	CALType	License Type	Picklist	0: Professional 1: Administrative 2: Basic 3: Device Professional 4: Device Basic 5: Essential 6: Device Essential 7: Enterprise 8: Device Enterprise 9: Sales 10: Service 11: Field Service 12: Project Service Default: 0
User	systemuser	emailrouteraccessapproval	EmailRouterAccessApproval	Primary Email Status	Picklist	0: Empty 1: Approved 2: Pending Approval 3: Rejected Default: 0
User	systemuser	incomingemaildeliverymethod	IncomingEmailDeliveryMethod	Incoming Email Delivery Method	Picklist	0: None 1: Microsoft Dynamics 365 for Outlook 2: Server-Side Synchronization or Email Router 3: Forward Mailbox Default: 1
User	systemuser	invitestatuscode	InviteStatusCode	Invitation Status	Picklist	0: Invitation Not Sent 1: Invited 2: Invitation Near Expired 3: Invitation Expired 4: Invitation Accepted 5: Invitation Rejected 6: Invitation Revoked Default: 0
User	systemuser	outgoingemaildeliverymethod	OutgoingEmailDeliveryMethod	Outgoing Email Delivery Method	Picklist	0: None 1: Microsoft Dynamics 365 for Outlook 2: Server-Side Synchronization or Email Router Default: 1
User	systemuser	preferredaddresscode	PreferredAddressCode	Preferred Address	Picklist	1: Mailing Address 2: Other Address Default: 1
User	systemuser	preferredemailcode	PreferredEmailCode	Preferred Email	Picklist	1: Default Value Default: 1
User	systemuser	preferredphonecode	PreferredPhoneCode	Preferred Phone	Picklist	1: Main Phone 2: Other Phone 3: Home Phone 4: Mobile Phone Default: 1
Task	task	prioritycode	PriorityCode	Priority	Picklist	0: Low 1: Normal 2: High Default: 1