Database tables

The program description deals with the following:

• Remarks on Program function
• Remarks on Data fields
• Use Index to find the field details required.

Remarks on program function

The structure of the database classes can be shown with this program. The database classes are linked to Categories and Components.

Note:
Changes in the database classes are only possible after consultation with the MICROS Retail Support team.

---

Remarks on data fields

The following description deals with all available options for update of this basic data.

As with nearly all programs the following also applies here:

• The entry mask for this program may differ in your MICROS Retail OSCAR POS program. Some data fields may be missing.
• There may be defaults or firmly defined selection options for some data fields. These cannot be updated in the current program.
• Fields with enforced entry defined are to be found in the entry masks as are fields where entry is optional.
• If the data record is updated over several pages of entry masks, the dialog window is reached by clicking onto the appropriate button with <Mouse key 1>.
• The same procedure also applies to call up of another update program from this program.
• In some cases you may find so-called "Switches" which are activated or deactivated by the user with <Mouse key 1>, depending on the setting. Activated switches have a dark top, deactivated switches are lighter.

---

Table no.

Entry range permitted: numeric 1 - 9999

Enter the number of the database class to be viewed. If the number is not known, the data record can be selected with Search.

---

Name

Entry range permitted: alphanumeric max. 20 pos.

The name of the database class is displayed in this field. Please note that this name represents the internal designation of the file.

The German names of all files plus the respective list of all field names can be found under MICROS Retail OSCAR POS database tables.

---

Super table

Entry range permitted: numeric 1 - 9999

The name of the superior database table is shown in this field. Please note that this name represents an internal designation of the file.

---

Record length

Entry range permitted: numeric 1 - 9999

The record length for this database class is defined in this field.

---

Count fields

Entry range permitted: numeric 1 - 9999

The number of fields for this database class is defined here. A complete description of all fields of the respective database class plus the relevant field names can be found under MICROS Retail OSCAR POS database tables

---

Object length

Entry range permitted: numeric 1 - 9999

The object length for this database table is defined in this field.

---

Group

Entry range permitted: numeric 1 - 9999

This field shows the name of the superior group for this database table.

---

Category

Entry range permitted: alphanumeric max. 20 pos.

The linked category for the appropriate database table is shown in this field. MICROS Retail OSCAR POS database tables provides a list of all categories with the linked components.

---

Component

Entry range permitted: alphanumeric max. 20 pos.

This field shows the components of the relevant database table. MICROS Retail OSCAR POS database tables provides a list of all components together with the linked database classes.

---

Checksum

Entry range permitted: numeric 1 - 9999

This field shows the check sum for this database class.

---

Length

Entry range permitted: numeric 1 - 9999

---

Table number

Entry range permitted: numeric 1 - 9999

---

Abstract

Switch active: This file is an abstract database class.
Switch deactivated: This file is a real database class.

---

No storage

Switch active:
Switch deactivated:

---

No own file

Switch active:
Switch deactivated:

---

Own file

Switch active:
Switch deactivated:

---

Replace super

Switch active:
Switch deactivated:

---

Index

• Abstract
• Category
• Checksum
• Component
• Count fields
• Group
• Length
• Name
• No own file
• No storage
• Object length
• Own file
• Record length
• Replace super
• Super table
• Table no.
• Table number

---

MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin