| View Name: | wipelm_dtl |
| View Number: | 58 |
| Group: | Support |
| Description: | Selects part request details for WIPbin presentation |
| 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 |
|---|---|---|---|---|
| age | condition | wipbin_time | Age of part request in seconds | 6 |
| clarify_state | condition | condition | State of part request | 8 |
| condition | condition | title | Part request condition | 7 |
| condition_code | condition | condition | Code number for part request condition | |
| elm_objid | demand_dtl | objid | Demand_dlt internal record number | 3 (UNIQUE) |
| id_number | demand_dtl | detail_number | Part request object ID Number | 4 |
| mod_level | mod_level | mod_level | Revision level of part request | 40 |
| owner | user | objid | Part request owner's internal record number | |
| part_number | part_num | part_number | Part number of part request | 39 |
| priority | demand_dtl | priority | Part request Priority; from part request header priority | 35 |
| quantity | demand_dtl | demand_qty | Quantity of part request | 41 |
| status | gse_status(gbst_elm) | title | Part request status | 17 |
| title | demand_dtl | title | Part request title | 2 |
| wip_objid | wipbin | objid | WIPbin internal record number | 18 |
| x_res1 | part_num | x_res1 | Data Restriction field | |
| x_res2 | part_num | x_res2 | Data Restriction field | |
| x_res3 | part_num | x_res3 | Data Restriction field | |
| x_res4 | part_num | x_res4 | Data Restriction field | |
| x_res5 | part_num | x_res5 | Data Restriction field |
Join From | Join To |
|---|---|
| (demand_dtl).demand_dtl2condition | (condition).condition2demand_dtl |
| (demand_dtl).demand_dtl_wip2wipbin | (wipbin).wipbin2demand_dtl |
| (demand_dtl).dmnd_dtl_sts2gbst_elm | gse_status(gbst_elm).status2demand_dtl |
| (demand_dtl).demand_dtl2part_info | (mod_level).part_info2demand_dtl |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| (demand_dtl).demand_dtl_owner2user | (user).curr_owner2demand_dtl |
| wipelm_dtl | |||