| View Name: | demand_site |
| View Number: | 5194 |
| Group: | Sales Mgr |
| Description: | Used internally to select for Part Requests by site |
| 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 |
|---|---|---|---|---|
| demand_dtl | demand_dtl | objid | Demand_dlt internal record number | 3 (UNIQUE) |
| demand_hdr | demand_hdr | objid | Demand hdr internal record number | |
| demand_qty | demand_dtl | demand_qty | The order quantity | |
| detail_number | demand_dtl | detail_number | The part request number for the request | |
| details_date | demand_dtl | details_date | The create date for the part request | |
| details_status | demand_dtl | details_status | The status for the detail | |
| mod_level | mod_level | mod_level | Revision level | |
| movement_type | demand_dtl | movement_type | Reserved; future | |
| part_domain | part_num | domain | Name of the part's domain | |
| part_mod | mod_level | objid | Part revision internal record number | |
| part_number | part_num | part_number | Part number/name | |
| shipped_qty | demand_dtl | shipped_qty | The quantity shipped | |
| site_objid | site | objid | Site internal record number | |
| status | gse_status(gbst_elm) | title | Status of the demand_dtl | 17 |
Join From | Join To |
|---|---|
| (demand_dtl).demand_dtl2demand_hdr | (demand_hdr).demand_hdr2demand_dtl |
| (demand_dtl).demand_dtl2part_info | (mod_level).part_info2demand_dtl |
| (demand_dtl).dmnd_dtl_sts2gbst_elm | gse_status(gbst_elm).status2demand_dtl |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| (demand_hdr).open_reqst2site | (site).site2demand_hdr |
| demand_site | |||