Available standard Catalogue fields

<< Click to Display Table of Contents >>

Navigation:  Report Generator > Extended features > Catalogue data in connection lists >

Available standard Catalogue fields

Previous pageReturn to chapter overviewNext page

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