Table Updates/Inserts/Deletes

Use this section to learn about database table modifications when you export asset disposals.

Costpoint inserts and updates records in the Export Asset Disposals tables when you perform the following:

• Perform an asset selection
• Add assets to the list or delete assets from the list
• Edit selected records via the Modify/View Data for Export button
• Click Save Batch or Preview, or when you select Export Asset Disposals or Print/Export Asset Disposals options on the Default Action drop-down list.

The records will be inserted into the application's tables with the Batch ID as part of each record for saved batches for all of these except for Process, so that all data will be identifiable and retrievable for processing into an export file or deleting from consideration. The records for a particular batch are deleted from the application's tables when you execute:

• File/Delete with a Batch ID on the screen that has records in the application's tables with the Batch ID from the screen on them
• Process
• Retrieve Batch, then remove all records from the Range List and asset selection, and click Save Batch with the Batch ID still on the screen.