Parts Management: Field Designations and Field Lengths of the Parts Fields

The following tables list all the text fields present in the parts management and their maximum lengths:

Tab "Address", table "tblAddress"

Field	Internal field designation	Maximum length
Short name	shortName	30
Full name	longName	70
Title	title	30
Name 1 / Name 2 / Name 3	name1 / name2 / name3	40
Street	street	100
Zip code (City)	ziptown	30
City	town	100
Zip code (P.O. box)	zippobox	30
P.O. box	poBox	30
Country	state	30
Phone	phone	50
Fax	fax	30
E-mail	email	70
Customer number	number	30
Description	description	50

Tab "Assembly", table "tblAssembly"

Field	Internal field designation	Maximum length
Starting variant	parentvariant	3
Part number	partnr	255
Variant	variant	3

Tab "Drilling pattern", table "tblConstruction"

Field	Internal field designation	Maximum length
Name	name	40
Description	designation	50

Tab "Doors", table "tblDoorPosition"

Field	Internal field designation	Maximum length
Part number	partnr	255
Variant	variant	3

Tab "Cut-outs", table "tblDrillingPosition"

Field	Internal field designation	Maximum length
Outline name	outlinename	50

Tab "Free properties", table "tblFreeProperty"

Field	Internal field designation	Maximum length
Description	description	25
Value	val	200
Unit	unit	50

Tab "Function templates", table "tblFunctionTemplate"

Field	Internal field designation	Maximum length
Characteristic	characteristics	30
Connection point designation	connectionDesignation	255
Connection point description	connectionDescription	255
Index 1 / Index 2	idx1 / idx2	30
Designation	terminalNr	30
Variant	variant	3
Plug designation	nesteddevicetag	30
Terminal description	description	30

Note:

The fields in the Part selection group box are listed here since they are fields in this tab, however they internally come from the table "tblVariant".

Tab "Module", table "tblModule"

Field	Internal field designation	Maximum length
Starting variant	parentvariant	3
Part number	partnr	255
Variant	variant	3
DT	devicetag	255
DT ID	moduleid	16

Tab "Mounting panels", table "tblMountingPanelPosition"

Field	Internal field designation	Maximum length
Part number	partnr	255
Variant	variant	3

Tab "Technical data", table "tblPart"

Field	Internal field designation	Maximum length
(internal unique ID, used for the Data Portal)	uniqueid	50
Group number	groupnumber	10
Part group	piecetype	10
Function group	functiongroup	30
Wearing part	wear	16
Spare part	spare	16
Lubrication / maintenance	maintenance	16
Service time	lifetime	16
Stress	stress	16
Procurement	usage	16
Macro	groupsymbolmacro	255
Connection points	terminal	40

Tab "Prices / Other", table "tblPart"

Field	Internal field designation	Maximum length
Quantity unit	quantityunit	30
Certification: General	certificate	50
Certification: UL	certificate_UL	50
Certification: VDE	certificate_VDE	50

Tab "General", table "tblPart"

Field	Internal field designation	Maximum length
Part number	partnr	255
ERP number	erpnr	255
Type number	typenr	255
Manufacturer	manufacturer	30
Supplier	supplier	30
Order number	ordernr	255

Tab "Mounting data", table "tblPart"

Field	Internal field designation	Maximum length
Graphical macro (incl. directory)	graphicmacro	255
Image file	picturefile	255
Texture	ecabinetmacro	255

Tab "Accessories", table "tblPart"

Field	Internal field designation	Maximum length
Accessories	isaccessory	1

Tab "Data for reports", table "tblPart"

Field	Internal field designation	Maximum length
Identifier for reports	reportid	20

Tab "Mounting rails", table "tblSupportBarPosition"

Field	Internal field designation	Maximum length
Part number	partnr	255
Variant	variant	3

Tab "Connection point pattern", table "tblTerminal"

Field	Internal field designation	Maximum length
Name	name	40
Description	designation	50

Tab "Connection points", table "tblTerminalPosition"

Field	Internal field designation	Maximum length
Name	name	20