Filter
Top Products
Maintenance Application 45
© 2005 TOSHIBA TEC AMERICA AMERICA RETAIL SYSTEMS, INC. R1.0a
option if you are certain that you understand SQL and are executing the correct command. By running
an SQL command you can inadvertently or even
s
everely damage
the data contained in the system
database tables. If you are unsure, you should not use this option, contact your Authorized TEC Dealer
for technical support.
This example shows the Maintenance application's "File" menu, "SQL command" option.
This option allows a programmer to either select an existing SQL command from the drop down list at
the top of the window or manually enter a new SQL command and execute it. It is also possible to
enter new commands, then save them to have them added to the existing list.
4.4.1 Item Options
Item Maintenance Utilities
The "PLU" desktop icon and the "PLU" menu's "Item" option both open the Item table programming
utility. Once open, the Maintenance application's "File" menu adapts to include options and utilities that
apply specifically to item table. The options and utilities are designed to work with item data entry and
programming integrity.
Item Table File Menu Options
Tests:
This option includes item tests that help control item data integrity, such as sub-department
links, items with no price and other tests, including:
PLU at zero price in level 1:
Items
should
have a price on level 1! This tests the item tables for any
items that do not have a price on price level 1, and opens a list box. If there are no items without a
price, the list is empty. If there are items without a price, you can double click an item to edit it right
away. You can then either edit or delete the item in question. Repeat the process until all items have
been dealt with.
NOTE:
Items can exist without a price. The Maintenance application will not stop you from creating an
item, then leaving the item table without entering a price.
No sub-department:
Items in the database
should
all be linked to a sub-department. Sub-
departments allow for selective reporting and item group programming. For more about sub-
departments, see the
Sub-department help
in this manual. Use this test to find any items that
are not