Skip to content
SIMSTSize
Sign inGet started
Back to Tables registry

SalesTable

System job
Category
Not classified
Module
Not set
Reported by
None yet
System job
Yes
If Microsoft's optional archive feature is used, old rows of this table move to SalesTableHistory in the same SQL database. The live database stays in SQL; Dataverse is only optional cold storage.
D365 already has a system job that cleans this table. Prefer it over deleting rows by hand.

Recommendations

We are not Microsoft. Test in a sandbox first, confirm with your business that the data is not needed, and take a backup. Some actions cannot be undone.

No recommendations yet

Nobody has documented a method for this table that we could check against a source. That does not mean it is safe to delete rows: it means there is nothing to rely on yet. If you know a documented way, tell us and send the link.

What it holds

Sales order headers.

Editor's note

Standard routine: Sales and marketing > Periodic tasks > Clean up > Delete sales orders / Delete quotations / Delete return orders

Written by the site's editors. It is not one of the sourced recommendations above.

How big is it in your system?

Install the SIMS TSize model in D365 and send anonymous table sizes to a private project. You will see this table's size and how it changes over time.

Set up D365Create a client account