Parts Database Data Record Structure
This is the structure of a database record in the main Bentley Substation parts database.
Field Name | Data Type | Field Size | Description |
---|---|---|---|
Part_Number | Text | 30 | Part number |
Category | Text | 50 | Description of part |
Manufacturer | Text | 30 | Manufacturer |
URL | Text | 255 | Hyperlink for part number |
Catalog_Number | Text | 30 | Catalog part number |
Supplier | Text | 50 | Supplier of part |
Part_Type | Text | 3 | Part type group |
Additional_Part | Text | 255 | Additional part numbers |
Percent_Spare | Floating Point | Percent of spare parts | |
Quantity_Per_Unit | Floating Point | Quantity in part number | |
Use_Unit | Text | 12 | Unit in which part is used |
Order_Unit | Text | 50 | Unit in which part is ordered |
Buying_Price | Floating Pint | Supplier's price | |
Selling_Price | Floating Point | Price charged to customer | |
Discount | Floating Point | Percent discount | |
Detailed_Description - Detailed_Description5 | Text | 128 | Extended descriptions of part |
X | Floating Point | X Dimension of device | |
Y | Floating Point | Y Dimension of device | |
Z | Floating Point | Z Dimension of device | |
Diameter | Floating Point | Diameter of part | |
Location | Text | 128 | Location of part |
Weight | Floating Point | Weight of part | |
Power_Consumption | Floating Point | Power consumption | |
Assembly_Time | Int16 | 32767 max. | Assembly time |
Wiring_Time | Int16 | 32767 max. | Wiring time |
Hour_Cost | Floating Point | Hourly labor cost | |
Date_Created | Data | 10 | Date part record was created |
Date_Modified | Date | 10 | Date part record was edited |
Device_Family | Text | 50 | Device family of part |
Attribute_Text | Text | 255 | Symbol attribute and value |
Single_Wire_Connection | Text | 128 | Conn. points for single wire |
Schematic_Symbol | Text | 128 | Symbol for schematics |
Layout_Symbol | Text | 128 | Symbol for panel layouts |
Wire_Diagram_Symbol | Text | 128 | Symbol for wiring diagram |
Hydraulic_Symbol | Text | 128 | Symbol for hydraulic dwgs |
Pneumatic_Symbol | Text | 128 | Symbol for pneumatic dwgs |
Single_Line_Symbol | Text | 128 | Symbol for single line dwgs |
Graphic_Plan_Symbol | Text | 128 | Symbol for terminal plans. |