| View Name: | fc_mod_level_view |
| View Number: | 4630 |
| Group: | Dovetail |
| Description: | Part Revisions and Replacements |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Custom |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | rev(mod_level) | objid | revision internal record number | 3 (UNIQUE) |
| part_objid | part_num | objid | Part num internal record number | |
| part_number | part_num | part_number | Part number | |
| rev_mod_level | rev(mod_level) | mod_level | part revision | |
| rev_active | rev(mod_level) | active | Active/inactive/obsolete | |
| part_description | part_num | description | part description | |
| part_active | part_num | active | Active/inactive/obsolete | |
| rev_replaces_date | rev(mod_level) | replaces_date | date that this part was replaced | |
| replaces_rev_objid | replaces_rev(mod_level) | objid | revision internal record number | |
| replaces_part_number | replaces_part(part_num) | part_number | Replaces Part Number | |
| replaces_rev_mod_level | replaces_rev(mod_level) | mod_level | Replaces Part Revision | |
| replaces_rev_active | replaces_rev(mod_level) | active | Active/inactive/obsolete | |
| replaces_rev_replaces_date | replaces_rev(mod_level) | replaces_date | date that this part was replaced | |
| replaced_rev_objid | replaced_rev(mod_level) | objid | revision internal record number | |
| replaced_part_number | replaced_part(part_num) | part_number | Replaced Part Number | |
| replaced_rev_mod_level | replaced_rev(mod_level) | mod_level | Replaced Part Revision | |
| replaced_rev_active | replaced_rev(mod_level) | active | Active/inactive/obsolete | |
| replaced_rev_replaced_date | replaced_rev(mod_level) | replaces_date | date that this part was replaced |
| Join From | Join To |
|---|---|
| replaces_rev(mod_level).part_info2part_num | OUTER replaces_part(part_num).part_num2mod_level |
| replaced_rev(mod_level).part_info2part_num | OUTER replaced_part(part_num).part_num2mod_level |
| rev(mod_level).replacedpn2mod_level | OUTER replaced_rev(mod_level).replacespn2mod_level |
| rev(mod_level).part_info2part_num | (part_num).part_num2mod_level |
| OUTER replaces_rev(mod_level).replacedpn2mod_level | rev(mod_level).replacespn2mod_level |
| fc_mod_level_view | |||