Asset Delete Business Rules

Assets referenced in the following tables and fields are not be eligible for delete:

• tblAssetComponents.IDAssetChild (assets which are components of other assets)
• tblAssetDownTime.IDAsset (assets which have associated downtime)
• tblLocationHistory.IDAsset (assets with TMS Locator history)
• tblLocationHistoryArchive.IDAsset (assets with TMS Locator history)
• tblMaterialIssueItems.IDAsset (assets to which materials have been issued)
• tblMaterialReceiptItems.IDAsset (assets associated with material receipts)
• tblMaterialRequisitionItems.IDAsset (assets associated with requisition items)
• tblPOItems.IDAsset (assets associated with PO or BO items)
• tblTimeCharges.IDAsset (assets associated with time charges)
• tblWorkOrders.IDAsset (assets associated with work orders)
• tblWOProcedureReadings.IDAsset (assets associated with work order Procedure readings)
• tblDNITestInformation.IDAsset (assets associated with DNI tests)

Assets referenced in the following tables and fields can be removed.  The records referencing the asset will also be removed.

• tblAssetBillOfMaterials.IDAsset (assets with a bill of materials)
• tblAssetComponents.IDAssetParent (assets with components)
• tblAssetGroupList.IDAsset (assets which belong to an asset group)
• tblAssetRisks.IDAsset (assets with risk information entered)
• tblContacts.IDAsset (assets with contacts indicated)
• tblContractAssets.IDAsset (assets which belong to a contract)
• tblStatusChangeLog.IDAsset (assets with status change history)

Assets with PMs that meet the other requirements can be removed.  This requires the removal of the PM Schedule record and any related records (items) in tblPMExceptionRanges (exceptions), tblPMCalendar, tblPMAssignments (assignments), and tblPMProcedures (Procedures).

TMS pre-validates assets for deletion and indicates to you which assets will be deleted and which assets will not be deleted.