<< Click to Display Table of Contents >> Available standard Catalogue fields |
The table below lists all standard fields of the *KT.DBF main database table of the Catalogue. All these fields are available for the feature that is discussed here, as well as any user defined Catalogue fields that have been added.
Please refer to the Database structure topic for more information about user defined fields in the Catalogue.
*KT.DBF (main table) |
|
---|---|
Field name |
Description |
INDEX |
Index |
BESCHREIB |
Short description |
EL_DATEN |
Electrical data |
HERSTELLER |
Manufacturer |
LIEFERANT |
Supplier |
TYPE |
Type number |
BESTELL_NR |
Ordering number |
EINZ_PREIS |
Price |
RABATT |
Discount |
BESTAND |
Quantity in stock |
MIN_MENGE |
Ordering limit |
BESTELL_ME |
Ordering quantity |
GEWICHT |
Mass/weight |
VORZUGSTYP |
Obsolete (not used) |
MODUL_ANZ |
Module |
BTTYP |
Obsolete (not used) |
BGRPNR |
Resource Category |
VERSCHL_GR |
Wear group |
FRAGE |
Obsolete (not used) |
UPDATE |
Update number |
E_NUMMER |
E-number |
PREIS_EINH |
Currency (unit for price, for instance "EUR") |
GEW_EINH |
Unit for mass (for instance "kg") |
MENGE_EINH |
Unit for quantity (for instance "pieces") |
DESTYPE |
Document type |