Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Compact & Audit Database - Nominal

Datafile Software

Compact & Audit Database - Nominal

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 nominal account file). 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 transaction file – the journal clear down process will do this for you and running here could affect the transaction control numbers.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Ledger Enquiry Manager - Nominal
Viewed 1520 times since Wed, Jun 27, 2012
Multiple Updating - Update From Another Nominal - Nominal
Viewed 1592 times since Thu, Jun 28, 2012
Account Currency - 3 - Nominal - Database Profiles
Viewed 1435 times since Thu, Jun 28, 2012
Account Enquiry - Nominal
Viewed 1522 times since Wed, Jun 27, 2012
Standard Update – Sales and Purchase Ledgers - Nominal
Viewed 1179 times since Thu, Jun 28, 2012
Receipt Column Headings - Cashbook
Viewed 2069 times since Wed, Jun 27, 2012
Reverse Provisionals - Nominal
Viewed 1636 times since Wed, Jun 27, 2012
Automatic Postings - Cashbook
Viewed 1533 times since Wed, Jun 27, 2012
PREV-YR-TOT – Previous Year-1 Comparative Totals, PREV-YR-PER – Previous Year-1 Period Comparatives - Nominal
Viewed 1015 times since Wed, Jun 27, 2012
Nom/CB Accounts File – Full Screen Design (Premier only) - Cashbook
Viewed 1028 times since Thu, Jun 28, 2012