File Maintenance Utility

181

Follow the selection process for the tables to re-index, or, in most cases, use the "select all" option from the utility's "Edit" menu. Once the tables are selected, press the "Re-index" button at the bottom of the utility window. The re-indexing process does not affect the table data, or harm the database in any way.

Why and How to use the Pack Command

NOTE: The Pack command is only required if your installation is using the "Paradox" type of database. MSSQL databases do not require "Packing". This process occurs on a regular basis, run internally by Symphony Pro. You should not normally have to run the Pack command. It is described here to explain why it exists as a utility.

When records are deleted from a Paradox data table, the record is really just emptied of any values. The physical space the record occupied in the table remains. During normal use, the data tables are added to and have records removed on a regular basis, taking more space than actually required. The "Pack" operation seeks and removes these spaces from the Paradox table structure, diminishing the table to include only the records that contain data. This process occurs on a regular basis, run internally by L-BOSS. You should not normally have to run the Pack command.

13 Glossary

Glossary of Terms

Back End: The office terminals or stations that run Symphony Pro, used for the management aspects of the store, controlling the data for the front end.

Category: A user defined key that items can link to for combining items either for reporting or global modifications.

CID: Cash in Drawer, but often used to describe any tender type that accumulates in a POS drawer.

Command File: Executable file that contains proprietary Symphony Pro commands, along with SQL code used to interact with the database. Command files in Symphony Pro often use a ".sql" file extension.

Compute: Calculate or re-calculate data to give a total, often required after entering inventory quantities, in order to re-establish the correct number after sales.

Count: In terms of inventory, the physical counting of items. Inventory tracking must start with a count to establish the real quantity for items in the sales process.

Declaration: The act of counting and entering the in drawer amounts for all tender types at the end of a cashier's shift. The declaration is used to report Over / Short amounts by cashier.

Deploy: Prepare to send; place information in an outbox, or in a target inbox.

Electronic Journal: In the front end terminal, an electronic version of a register tape, used to store ALL transaction details tracked by a front end terminal.

© 2005 TOSHIBA TEC AMERICA AMERICA RETAIL SYSTEMS, INC. R1.0a

Page 183
Image 183
Toshiba Electric Keyboard File Maintenance Utility 181, Why and How to use the Pack Command, Glossary of Terms