TMS data cleanup
This page lists the TMS (Transportation) tables that can be cleaned up automatically: planning, freight calculations and on-board-computer (OBC) messages.
Use it to decide which tables to enable in the Data Cleanup Setup list. For how to configure and schedule cleanup, see Data Cleanup.
Tip
A record is only deleted once it is older than the retention period, measured on the table's date field. Always run Count Records before enabling automatic cleanup so you know exactly what will be removed.
Tables
| Table | What it contains | Kept for (default) | On by default? |
|---|---|---|---|
| 3PL APS Interface Message | Interface queue with the planning system (APS). | 3 Months | ✅ |
| TMS Calendar | Planning calendar entries. | 6 Months | ✅ |
| TMS Contract Strategy Log | Log of rating / contract-strategy evaluations. | 3 Months | — |
| TMS Calculation Entry | Freight-cost calculation results. | 1 Year | — |
| TMS Calculation Entry No. | Number buffer used while calculating freight costs. | 1 Day | — |
| TMS OBC Queue-Outbound | On-board-computer outbound message queue. | 3 Months | — |
| TMS OBC Queue-Inbound | On-board-computer inbound message queue. | 3 Months | — |
| TMS OBC Error | On-board-computer errors. | 3 Months | — |
| TMS OBC Warning | On-board-computer warnings. | 3 Months | — |
| TMS Resource Location Entry | Vehicle / driver location history. | 3 Months | — |
| TMS Event Log | Telematics / event log. | 1 Week | — |
| TMS Board Computer File Log | Board-computer file log. | 3 Months | — |
| TMS Board Computer Log | Board-computer message log. | 3 Months | — |
Back to Data Cleanup.