Item tables – Toshiba Electric Keyboard User Manual

Page 54

Symphony Pro User Manual 2.0.2.15

Statistics: A utility to verify item programming and links to other item tables.

4.6.1

Item Tables

Item Table Tabs and Fields

The item related tables are separated into "tabs" containing PLU information. Each tab displays
different aspects of PLU programming. The help pages under the "Item Table" topic explain the PLU
fields in order of the tabs. The item maintenance screens are divided into tabs to make viewing
simpler. The top portion of the screen is consistent to all tabs. This includes the item number, the main
item description, the active price and the next price. The Quick tab is a shortcut to fields that are also
found on other tabs in the PLU set-up screen.

The relational nature of the Symphony database is easy to understand when you are working in the
PLU maintenance. You may create item 1 as Oreo cookies, attached to sub-department 10 and with a
price of 2.39 as in the example below. You have therefore added a record to the object table (item
0000000000001), but you have also added a record to the POS table (the sub-department link, tax
status, and register flags), and you have added a price record to the Price table. You now have one
record in each of the 3 tables. When you want to add a second price level for Oreo cookies you do not
create a new item, you only add a new price on level 2. So you will have 2 price records but only one
object record and only one POS record. The same would be true in the cost table if you have more
than one supplier for product 1. Multiple cost records can be associated with the item. The PLU
information centres on the object table. It is the the table that contains the unique identifier for each
product in the system.