Data Retention and Purging
WMS transactional data (such as orders, shipments, inventory etc.) are normally retained for at least 12 months. Beyond that time frame, data that has been “processed” may be purged from the WMS database, to better manage system performance.
- “Processed” refers to data in statuses such as “Shipped”, “Completed”, “Canceled” etc. where no further processing is possible
- Unprocessed data (such as open orders or unused inventory) is never purged regardless of the time frame
- Since WMS is an execution system, with transactional data generally created by external systems such as ERPs, and interfaced into WMS, there is no archiving of purged data. Customers wanting to save such data can use the multiple data extraction mechanisms to extract and save the data. Refer to the WMS Data Extraction Guide.
- Note that there are many internal tables in which WMS creates records during normal processing, that are automatically purged on a more frequent basis. Users normally never see this data. These are unrelated to WMS transactional entities like orders, shipments, inventory etc.