Home » Categories » Solutions by Business Process » Finance » Job Costing |
Compact & Audit Database |
Article Number: 802 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 10:28 PM
|
Datafile Software Compact & Audit Database The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted (particularly in master files such as the Job and Cost Code files). New records are always added to the end of the file. Therefore, over a period of time, it is possible a file may appear full but there could be gaps in the middle where records were deleted. Using this option consolidates the active data and frees up space. This option effectively re-arranges all the active records so you must run the ‘Audit Pointers’ function after using this option. In addition you should not, in the normal course of events, use this option on the Job Transaction file – the cleardown processes will usually do this for you and running here could affect the transaction control numbers (see above). |
Attachments
![]() There are no attachments for this article.
|
Security and User Manager
Viewed 1715 times since Mon, Jun 25, 2012
Direct Job Costs
Viewed 2164 times since Mon, Jun 25, 2012
Expand Data Files
Viewed 1767 times since Mon, Jun 25, 2012
Stock Issues Header
Viewed 1820 times since Mon, Jun 25, 2012
Memo Facility Configuration
Viewed 1897 times since Mon, Jun 25, 2012
Job File ITEM Screen Design
Viewed 2322 times since Mon, Jun 25, 2012
Completing Time Sheet Input
Viewed 1853 times since Mon, Jun 25, 2012
Database Profiles
Viewed 1647 times since Mon, Jun 25, 2012
Transaction / Detail Enquiries
Viewed 2437 times since Mon, Jun 25, 2012
Link to Purchase Order Processing
Viewed 1754 times since Mon, Jun 25, 2012
|