| objid | vendor_part | objid | Vendor part internal record number | 3 (UNIQUE) |
| vendor_part_no | vendor_part | vendor_part_no | Vendor's part number | |
| site_id | site | site_id | Unique site number assigned according to auto-numbering definition | |
| site_obj | site | objid | Site internal record number | |
| site_name | site | name | Site name | |
| description | part_num | description | Description of the product | |
| mod_lev_obj | mod_level | objid | Part revision internal record number | |
| mod_level | mod_level | mod_level | Name of the part revision | |
| vendor_rev | vendor_part | vendor_rev | Vendor site's part number revision level | |
| vendor_part_objid | vendor_part | objid | Vendor part internal record number | |
| role_name | vendor_part | role_name | Role played by the vendor for the part, e.g., supplier, repair vendor, exchange vendor etc | |
| warranty | vendor_part | warranty | Warranty length in days for the role | |
| avg_cost | vendor_part | avg_cost | Part's average cost | |
| part_number | part_num | part_number | Part number/name | |
| part_num_description | part_num | description | Description of the product | |
| lead_time | vendor_part | lead_time | Lead time for the role in seconds | |
| avg_lead_time | vendor_part | avg_lead_time | Part's average lead time for the role in seconds | |
| preference | vendor_part | preference | Vender preference | |
| part_status | vendor_part | part_status | Vendor part status | |