| View Name: | dem_part_v |
| View Number: | 262 |
| Group: | Logistics |
| Description: | Part information for part request details |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | demand_dtl | objid | Demand_dlt internal record number | 3 (UNIQUE) |
| part_number | part_num | part_number | Part number/name | |
| mod_level | mod_level | mod_level | Revision level | |
| demand_qty | demand_dtl | demand_qty | The order quantity | |
| shipped_qty | demand_dtl | shipped_qty | The quantity shipped | |
| details_date | demand_dtl | details_date | The create date for the part request | |
| detail_number | demand_dtl | detail_number | The part request number for the request | |
| details_status | demand_dtl | details_status | The status for the detail |
| Join From | Join To |
|---|---|
| (demand_dtl).demand_dtl2demand_hdr | (demand_hdr).demand_hdr2demand_dtl |
| (demand_dtl).demand_dtl2part_info | (mod_level).part_info2demand_dtl |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| dem_part_v | |||