| View Name: | pr_hdr_site |
| View Number: | 4612 |
| Group: | Logistics |
| Description: | Joins part rquest header to site |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Custom |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | demand_hdr | objid | Part request header objid | 3 (UNIQUE) |
| header_date | demand_hdr | header_date | Part request creation date | |
| header_number | demand_hdr | header_number | Part request ID Number | |
| header_case_no | demand_hdr | header_case_no | Case/subcase ID number | |
| site_name | demand_hdr | site_name | Part request site name | |
| ship_city | demand_hdr | ship_city | PR header ship city | |
| priority | demand_hdr | priority | Part request priority | |
| request_status | demand_hdr | request_status | Part request request status | |
| ship_attn | demand_hdr | ship_attn | Ship to attn line 1 | |
| ship_attn2 | demand_hdr | ship_attn2 | Ship to attn line 2 | |
| x_res1 | site | x_res1 | Data Restriction field | |
| x_res2 | site | x_res2 | Data Restriction field | |
| x_res3 | site | x_res3 | Data Restriction field | |
| x_res4 | site | x_res4 | Data Restriction field | |
| x_res5 | site | x_res5 | Data Restriction field |
| Join From | Join To |
|---|---|
| (demand_hdr).open_reqst2site | (site).site2demand_hdr |
| pr_hdr_site | |||