Attribute (database fields)

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 fields for all Classes can be displayed with this program.

Note:
Changes to database Class can only be done after consultation with the MICROS Retail Deutschland 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 whose attributes (database fields) are to be viewed. If the number is not known, the data record can be selected with Search.

---

Attribute

Entry range permitted: numeric 1 - 9999

Enter the number of the attribute which is 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.

Enter the name of the attribute which is to be viewed. If the name is not known, the data record can be selected with Search.

---

Type name

Entry range permitted: alphanumeric max. 20 pos.

The type for this attribute is shown here.

The following attribute types are stored in the MICROS Retail OSCAR POS database:

• C = char
• c = unsigned char
• S = short
• s = unsigned short
• I = integer
• i = unsigned integer
• L = long
• l = unsigned long
• f = float
• d = double
• 2 = String
• 3 = Fixed point
• 4 = Date (ASCII date format "YYMMDD" with year, month, day
• 5 = Time (ASCII time format "HHMMSS" with hours, minutes, seconds
• 6 = Void array

---

Binary length

Entry range permitted: numeric 1 - 9999

The binary length for this attribute is shown in this field.

---

Decimal digits

Entry range permitted: numeric 1 - 99999

The number of decimal places for this attribute is shown in this field.

---

Offset

Entry range permitted: numeric 1 - 99999

The offset (binary) for this attribute is shown in this field.

---

ASCII length

Entry range permitted: numeric 1 - 99999

The ASCII length for this attribute is shown in this field.

---

Super table

Entry range permitted: numeric 1 - 9999

The number of the super table linked to this attribute is shown in this field.

---

Default val.

Entry range permitted: alphanumeric max. 20 pos.

The default value for this attribute is shown in this field.

---

Minimum

Entry range permitted: alphanumeric max. 20 pos.

The minimum value permitted for this attribute is shown in this field.

---

Maximum

Entry range permitted: alphanumeric max. 20 pos.

The maximum value permitted for this attribute is shown in this field.

---

Domain

Entry range permitted: numeric 1 - 9999

The domain class linked to this attribute is shown in this field.

---

Preset with zero

Switch active: The default is 0.
Switch deactivated: No default 0 for this Class field.

---

No storage

Switch active: This attribute is not saved in the database
Switch deactivated: This attribute is saved in the database

---

Set function

Entry range permitted: alphanumeric max. 20 pos.

---

Get function

Entry range permitted: alphanumeric max. 20 pos.

---

Index

• ASCII length
• Attribute
• Binary length
• Decimal digits
• Default val.
• Domain
• Get function
• Maximum
• Minimum
• Name
• No storage
• Offset
• Preset with zero
• Set function
• Table no.
• Table no.
• Type name

---

MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin