| site_part_objid | site_part | objid | Installed part internal record nubmer | 3 (UNIQUE) |
| site_objid | site | objid | Site internal record number | |
| site_id | site | site_id | Unique site number assigned according to auto-numbering definition | |
| site_name | site | name | site name | |
| serial_no | site_part | serial_no | Installed part serial number | |
| warranty_end | site_part | warranty_date | Installed part warranty ending date | |
| part_num_objid | part_num | objid | Generic part internal record number | |
| part_number | part_num | part_number | Generic part number/name | |
| part_desc | part_num | description | Generic part description | |
| part_domain | part_num | domain | Name of the domain for the part num. See object prt_domain | |
| model_num | part_num | model_num | Marketing model number of the part; within family and line | |
| mod_level_objid | mod_level | objid | Part revision internal record number | |
| mod_level | mod_level | mod_level | Name of the part revision | |
| active | mod_level | active | Part revision status; i.e., Active/inactive/obsolete | |
| part_line | part_num | line | Marketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm | |
| part_family | part_num | family | Marketing product family the part belongs to; new user-defined pop up replaces relation to gbst_elm | |
| part_type | part_num | part_type | User-defined pop up to denote a part type separate from the domain | |
| part_status | part_num | active | Generic part status; i.e., active/inactive/obsolete | |
| p_standalone | part_num | p_standalone | Indicates whether the part MAY receive standalone pricing; i.e. 0=no, 1=yes, default=0 | |
| p_as_parent | part_num | p_as_parent | Indicates whether the part MAY be priced with options under it; i.e. 0=no, 1=yes, default=0 | |
| p_as_child | part_num | p_as_child | Indicates whether the part MAY be priced as an option; i.e. 0=no, 1=yes, default=0 | |
| install_date | site_part | install_date | Part installation date | |
| is_sppt_prog | part_num | is_sppt_prog | Indicates application category of the part: i.e., 0=physical part, 1=service part, 2=product literature | |
| site_part_qty | site_part | quantity | Installed part quantity; equal to 1 for serialized parts | |
| mod_eff_dt | mod_level | eff_date | The date the support program version becomes effective | |
| mod_exp_dt | mod_level | end_date | The date the support program version expires | |
| sn_track | part_num | sn_track | Track part for serialization; i.e., 0=by quantity, 1=by serial number | |
| role_name | bus_site_role | role_name | Name of the role | |
| role_objid | bus_site_role | objid | Internal record number | |
| org_id | bus_org | org_id | User-specified ID number of the organization | |
| org_name | bus_org | name | Name of the organization | |
| org_objid | bus_org | objid | Internal record number | |