Dynamics365 Table Entity Statecodes

When referencing the various record states, these are stored as a numerical value in the Dynamics tables. Here’s your cheat sheet!

---

Table/Entity	StateCode	StateCode Explanation	StatusCode	StatusCode Explanation
Account	0	Active	1	Active
	1	Inactive	2	Inactive
Activity (activitypointer)	0	Open	1	Open
	1	Completed	2	Completed
	2	Canceled	3	Canceled
	3	Scheduled	4	Scheduled
Appointment	0	Open	1	Free
			2	Tentative
	1	Completed	3	Completed
	2	Canceled	4	Canceled
	3	Scheduled	5	Busy
			6	Out of Office
Article (kbarticle)	1	Draft	1	Draft
	2	Unapproved	2	Unapproved
	3	Published	3	Published
Campaign	0	Active	0	Proposed
			1	Ready To Launch
			2	Launched
			3	Completed
			4	Canceled
			5	Suspended
Campaign Activity	0	Open	0	In Progress
			1	Proposed
			4	Pending
			5	System Aborted
			6	Completed
	1	Closed	2	Closed
	2	Canceled	3	Canceled
Campaign Response	0	Open	1	Open
	1	Closed	2	Closed
	2	Canceled	3	Canceled
Case (incident)	0	Active	1	In Progress
			2	On Hold
			3	Waiting for Details
			4	Researching
	1	Resolved	5	Problem Solved
	2	Canceled	6	Canceled
Case Resolution (incidentresolution, notcustomizable)	0	Open	1	Open
	1	Completed	2	Closed
	2	Canceled	3	Canceled
Contact	0	Active	1	Active
	1	Inactive	2	Inactive
Contract	0	Draft	1	Draft
	1	Invoiced	2	Invoiced
	2	Active	3	Active
	3	On Hold	4	On Hold
	4	Canceled	5	Canceled
	5	Expired	6	Expired
Contract Line (contractdetail)	0	Existing	1	New
	1	Renewed	2	Renewed
	2	Canceled	3	Canceled
	3	Expired	4	Expired
Currency (transactioncurrency)	0	Active	0	Active
	1	Inactive	1	Inactive
Discount (discounttype)	0	Active	100001	Active
	1	Inactive	100002	Inactive
E-mail	0	Open	1	Draft
			8	Failed
	1	Completed	2	Completed
			3	Sent
			4	Received
			6	Pending Send
			7	Sending
	2	Canceled	5	Canceled
Fax	0	Open	1	Open
	1	Completed	2	Completed
			3	Sent
			4	Received
	2	Canceled	5	Canceled
Invoice	0	Active	1	New
			2	Partially Shipped
			4	Billed
			5	Booked (applies to services)
			6	Installed (applies to services)
	1	Closed (deprecated)	3	Canceled (deprecated)
			7	Paid in Full (deprecated
	2	Paid	100001	Complete
			100002	Parial
	3	Canceled	100003	Canceled
Lead	0	Open	1	New
			2	Contacted
	1	Qualified	3	Qualified
	2	Disqualified	4	Lost
			5	Cannot Contact
			6	No Longer Interested
			7	Canceled
Letter	0	Open	1	Open
			2	Draft
	1	Completed	3	Received
			4	Sent
	2	Canceled	5	Canceled
Marketing List (list)	0	Active	0	Active
	1	Inactive	1	Inactive
Opportunity	0	Open	1	In Progress
			2	On Hold
	1	Won	3	Won
	2	Lost	4	Canceled
			5	Out-Sold
Order (salesorder)	0	Active	1	New
			2	Pending
	1	Submitted	3	In Progress
	2	Canceled	4	No Money
	3	Fulfilled	100001	Complete
			100002	Partial
	4	Invoiced	100003	Invoiced
Phone Call	0	Open	1	Open
	1	Completed	2	Made
			4	Received
	2	Canceled	3	Canceled
Price List (pricelevel)	0	Active	100001	Active
	1	Inactive	100002	Inactive
Product	0	Active	1	Active
	1	Inactive	2	Inactive
Quote	0	Draft	1	In Progress
	1	Active	2	In Progress
			3	Open
	2	Won	4	Won
			5	Out-Sold
	3	Closed	5	Lost
			6	Canceled
			7	Revised
Service Activity (serviceappointment)	0	Open	1	Requested
			2	Tentative
	1	Closed	8	Completed
	2	Canceled	9	Canceled
			10	No Show
	3	Scheduled	3	Pending
			4	Reserved
			6	In Progress
			7	Arrived
Task	0	Open	2	Not Started
			3	In Progress
			4	Waiting on someone else
			7	Deferred
	1	Completed	5	Completed
	2	Canceled	6	Canceled

---