| View Name: | eco_products |
| View Number: | 5151 |
| Group: | Logistics |
| Description: | Used by ECO Header - Product Tab (8401) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| hdr_objid | eco_hdr | objid | ECO header internal record number | |
| eff_start_date | eco_hdr | start_date | Start date of ECO header | |
| eff_end_date | eco_hdr | end_date | End Date of ECO header | |
| eco_status | eco_hdr | status | Status of ECO header | |
| apply_mod_level | apply_mod(mod_level) | mod_level | Part revision | |
| apply_mod_objid | apply_mod(mod_level) | objid | Internal record number of the Applies To part | |
| apply_part_num | apply_part(part_num) | part_number | Part Number | |
| result_mod_level | result_mod(mod_level) | mod_level | Part revision | |
| result_mod_objid | result_mod(mod_level) | objid | Internal record number of the Results In part | |
| result_part_num | result_part(part_num) | part_number | Part Number | |
| objid | eco_mod_role | objid | Eco_mod_role internal record nubmer | 3 (UNIQUE) |
| role_name | eco_mod_role | role_name | Name of the role | |
| eco_code | eco_hdr | eco_code | ECO code; defaulted from a numbering scheme |
| Join From | Join To |
|---|---|
| (eco_mod_role).applies2mod_level | apply_mod(mod_level).applies2eco_mod_role |
| (eco_mod_role).result2mod_level | result_mod(mod_level).result2eco_mod_role |
| (eco_mod_role).eco_mod_role2eco_hdr | (eco_hdr).hdr2eco_mod_role |
| result_mod(mod_level).part_info2part_num | result_part(part_num).part_num2mod_level |
| apply_mod(mod_level).part_info2part_num | apply_part(part_num).part_num2mod_level |
| eco_products | |||