Why are there millions of records in this table?
This table has a very important function if you are using APM EAM to track Maintenance costs. This is a relator table used for slicing and dicing the costs so you can see which transactions go in to making up the totals. Each Resource Transaction has multiple relationships, to the following cost buckets X each applicable financial period by which costs are tracked:
• Cost types
• Parent assets (up the hierarchy)
• Parent asset lives
Purging Resource Transactions or the HIERARCHY1COST table means that you would not be able to rebuild cost accounting if costs were questioned.