| vend_part_obj | vendor_part | objid | Part internal record number | |
| 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 | |
| mod_lev_obj | mod_level | objid | Internal record number | |
| mod_level | mod_level | mod_level | Part revision internal record number | |
| vendor_rev | vendor_part | vendor_rev | Vendor site's part number revision level | |
| vendor_part_objid | vendor_part | objid | 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 | |
| price | price_inst | price | Price for a given product | |
| effective_date | price_inst | effective_date | Date the price instance becomes effective | |
| expire_date | price_inst | expire_date | Last date the price instance is effective | |
| prc_prog_name | price_prog | name | Name for the pricing program | |
| qty | price_qty | priced_qty | The quantity of the priced part being quoted | |
| objid | price_inst | objid | Price_inst internal record number | 3 (UNIQUE) |
| prc_prog_obj | price_prog | objid | Price program internal record number | |
| prc_qty_obj | price_qty | objid | Price_qty internal record number | |