About the Electrical Catalog Database Structure

Understand the structure of the catalog database used by the Electrical Catalog Browser.

Important: The fields must remain in this order in the database records.

Catalog Tables

Field Name	Width	Description
CATALOG	60	Catalog number.
MANUFACTURER	24	Manufacturer code; abbreviations are allowed.
DESCRIPTION	150	Generic description.
TYPE	100	Generic type (field name varies based on table name).
RATING	100	Generic rating (field name varies based on table name).
MISCELLANEOUS1	100	First miscellaneous text field (header cell is based on the component family).
MISCELLANEOUS2	100	Second miscellaneous text field (header cell is based on the component family).
ASSEMBLYCODE	60	Code to flag that this item has subassembly items. Spaces are allowed. Use a semi-colon, ";", to separate multiple codes. To define a quantity for a subassembly item, prefix the code with the quantity followed by a comma, ",". For example, an ASSEMBLYCODE value of: 2,NOBLOCK;3,NCBLOCK, would add the following: 2 of the subassembly item with the code name "NOBLOCK" in the ASSEMBLYLIST field 3 of the subassembly item with the code name of "NCBLOCK" in the ASSEMBLYLIST field
ASSEMBLYLIST	24	Code to flag as a subassembly item of a main item. The value must match the ASSEMBLYCODE value of the main catalog item exactly.
ASSEMBLYQUANTITY	8	Subassembly quantity (blank = quantity of 1).
USER1	100	Field #1 for other information.
USER2	100	Field #2 for other information.
USER3	100	Field #3 for other information.
TEXTVALUES	255	Optional user-defined RATING/miscellaneous attribute values.
WEBLINK	255	Associate .pdf files or Web URL to component.
WDBLKNAM	60	AutoCAD Electrical block name minus the first character of the block name since the first character is the orientation of block (H= Horizontal, V= Vertical).
SYMBOL2D	255	Schematic symbols associated to the catalog value that can be inserted from the Catalog Browser. Multiple symbol names are separated by a comma.
SYMBOL3D	255	3D parts associated to the catalog value that can be inserted from the Catalog Browser in Inventor using the AutoCAD Electrical add-in. Multiple part names are separated by a comma.

Note: Only the CATALOG, MANUFACTURER, DESCRIPTION, and ASSEMBLYCODE fields are assigned as iProperties when a part is inserted in Inventor through the Electrical Catalog Browser.