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 |
|
30 |
Full name |
|
70 |
Title |
|
30 |
Name 1 / Name 2 / Name 3 |
|
40 |
Street |
|
100 |
Zip code (City) |
|
30 |
City |
|
100 |
Zip code (P.O. box) |
|
30 |
P.O. box |
|
30 |
Country |
|
30 |
Phone |
|
50 |
Fax |
|
30 |
|
|
70 |
Customer number |
|
30 |
Description |
|
50 |
Tab "Assembly", table "tblAssembly"
Field |
Internal field designation |
Maximum length |
---|---|---|
Starting variant |
|
3 |
Part number |
|
255 |
Variant |
|
3 |
Tab "Drilling pattern", table "tblConstruction"
Field |
Internal field designation |
Maximum length |
---|---|---|
Name |
|
40 |
Description |
|
50 |
Tab "Doors", table "tblDoorPosition"
Field |
Internal field designation |
Maximum length |
---|---|---|
Part number |
|
255 |
Variant |
|
3 |
Tab "Cut-outs", table "tblDrillingPosition"
Field |
Internal field designation |
Maximum length |
---|---|---|
Outline name |
|
50 |
Tab "Free properties", table "tblFreeProperty"
Field |
Internal field designation |
Maximum length |
---|---|---|
Description |
|
25 |
Value |
|
200 |
Unit |
|
50 |
Tab "Function templates", table "tblFunctionTemplate"
Field |
Internal field designation |
Maximum length |
---|---|---|
Characteristic |
|
30 |
Connection point designation |
|
255 |
Connection point description |
|
255 |
Index 1 / Index 2 |
|
30 |
Designation |
|
30 |
Variant |
|
3 |
Plug designation |
|
30 |
Terminal 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 |
|
3 |
Part number |
|
255 |
Variant |
|
3 |
DT |
|
255 |
DT ID |
|
16 |
Tab "Mounting panels", table "tblMountingPanelPosition"
Field |
Internal field designation |
Maximum length |
---|---|---|
Part number |
|
255 |
Variant |
|
3 |
Tab "Technical data", table "tblPart"
Field |
Internal field designation |
Maximum length |
---|---|---|
(internal unique ID, used for the Data Portal) |
|
50 |
Group number |
|
10 |
Part group |
|
10 |
Function group |
|
30 |
Wearing part |
|
16 |
Spare part |
|
16 |
Lubrication / maintenance |
|
16 |
Service time |
|
16 |
Stress |
|
16 |
Procurement |
|
16 |
Macro |
|
255 |
Connection points |
|
40 |
Tab "Prices / Other", table "tblPart"
Field |
Internal field designation |
Maximum length |
---|---|---|
Quantity unit |
|
30 |
Certification: General |
|
50 |
Certification: UL |
|
50 |
Certification: VDE |
|
50 |
Tab "General", table "tblPart"
Field |
Internal field designation |
Maximum length |
---|---|---|
Part number |
|
255 |
ERP number |
|
255 |
Type number |
|
255 |
Manufacturer |
|
30 |
Supplier |
|
30 |
Order number |
|
255 |
Tab "Mounting data", table "tblPart"
Field |
Internal field designation |
Maximum length |
---|---|---|
Graphical macro (incl. directory) |
|
255 |
Image file |
|
255 |
Texture |
|
255 |
Tab "Accessories", table "tblPart"
Field |
Internal field designation |
Maximum length |
---|---|---|
Accessories |
|
1 |
Tab "Data for reports", table "tblPart"
Field |
Internal field designation |
Maximum length |
---|---|---|
Identifier for reports |
|
20 |
Tab "Mounting rails", table "tblSupportBarPosition"
Field |
Internal field designation |
Maximum length |
---|---|---|
Part number |
|
255 |
Variant |
|
3 |
Tab "Connection point pattern", table "tblTerminal"
Field |
Internal field designation |
Maximum length |
---|---|---|
Name |
|
40 |
Description |
|
50 |
Tab "Connection points", table "tblTerminalPosition"
Field |
Internal field designation |
Maximum length |
---|---|---|
Name |
|
20 |