To remove an asset (largest one), we would have to check all of the following tables for possible corresponding records before we could actually remove the asset from Asset Master. There would be a need to incorporate business logic into the routines to determine what to do if things are not closed out, etc. For example: ?What if a project is not closed, do we remove? ?It believe it would be fine if the Site Id was abandoned and we knew there were no financial reporting to contend with, but if the Site Id is active, and the request was to only remove a specific UIC and the UIC had active assets, that could become an issue with financial reporting. Recommended solution: 1. Remove improvement depreciation rows associated with improvements associated with Asset 2. Remove improvement ancillary costs rows associated with improvements associated with Asset 3. Remove improvement acquisition rows associated with improvements associated with Asset 4. Remove improvement "Attachments" if they are permitted. 5. Remove improvements from CIP Asset 6. Remove improvement 7. Remove Work Orders 8. Possibly some FAST tables 9. Remove Maintenance Activity Master 10. Remove Due Out 11. Remove Due In 12. Remove Asset Ancillary Costs 13. Remove Asset "Attachments" 14. Remove Asset Utilization 15. Remove CIP Asset 16. Remove UII 17. Remove Depreciation 18. Remove Asset Acquisition 19. Remove Asset Master 20. Remove stuff from CFO tables.