| View Name: | svc_part_view2 |
| View Number: | 5651 |
| Group: | Support |
| Description: | Do not customize |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| description | part_num | description | Description of the product | |
| dev | site_part | dev | Row version number for mobile distribution purposes | |
| dom_is_service | part_num | dom_is_service | Indicates the part is a service part, if selected, sit_prt_role will be set when installed; i.e., 0=not a service, 1=a service, default=0 | |
| domain | part_num | domain | Name of the domain for the part num | |
| level_to_part | site_part | level_to_part | Relative installation hierarchy level to a part | |
| mod_level | mod_level | mod_level | Revision level | |
| mod_objid | mod_level | objid | Mod_level internal record number | |
| model_num | part_num | model_num | Marketing model number of the part; within family and line | |
| objid | site_part | objid | Part internal record number | |
| part_number | part_num | part_number | Part number/name | |
| partnum_objid | part_num | objid | Part_num internal record number | |
| serial_no | site_part | serial_no | Installed part serial number | |
| site_id | site | site_id | Unique site number assigned according to auto-numbering definition | |
| site_name | site | name | Site name | |
| site_objid | site | objid | Site internal record number |
Join From | Join To |
|---|---|
| (site_part).site_part2part_info | (mod_level).part_info2site_part |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| (sit_prt_role).prt_role2site_part | (site_part).part2sit_prt_role |
| (sit_prt_role).prt_role2site | (site).site2sit_prt_role |
| svc_part_view2 | |||