| View Name: | prtnum2mod2shwgrp |
| View Number: | 343 |
| Group: | Product Mgr |
| Description: | Provides product number and revision information. Reserved; not used |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| shwgrp_objid | prtnum_cat | objid | Prtnum_cat internal record number | 3 (UNIQUE) |
| mod_objid | mod_level | objid | Part revision internal record number | |
| partnum_objid | part_num | objid | Part num internal record number | |
| part_number | part_num | part_number | Part number/name | |
| mod_level | mod_level | mod_level | Revision level |
| Join From | Join To |
|---|---|
| (prtnum_cat).prtnum_cat2part_info | (mod_level).part_info2prtnum_cat |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| prtnum2mod2shwgrp | |||