View Name:req_demand
View Number:5332
Group:Logistics
Description:Replaces view req_sum (238) for database retrieval. Used by forms Product Detail Dialog (502) and Part Request Header (501). Avoid adding additional fields from tables: user (20), gbst_elm (79) and view part_mod_v (5333) as performance will degrade
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objiddemand_dtlobjidDemand_dlt internal record number 3 (UNIQUE)
hdr_objiddemand_hdrobjidDemand hdr internal record number 
part_mod_objidmod_levelobjidPart revision internal record number 
owner_objiduserobjidUser owner of the request 
gbst_status_objidgbst_elmobjidStatus gbst_elm internal record number 
rma_numberdemand_dtldetail_numberThe part request number for the request 
request_typedemand_dtldemand_subtypeReserved; future 
order_qtydemand_dtldemand_qtyThe part request order quantity 
activitydemand_dtlactivityReserved; future 
required_datedemand_dtlnext_dateThe date required 
details_statusdemand_dtlrequest_statusStatus of the request 
details_typedemand_dtlrequest_typeType displayed in WIP and queue forms 
details_datedemand_dtldetails_dateThe create date for the part request 
serial_nodemand_dtlserial_noSerial number for the request 
shipped_qtydemand_dtlshipped_qtyThe quantity shipped 
backorder_qtydemand_dtlbackorder_qtyReserved; future 
conditionconditiontitlePart request condition 7
fulfilled_qtydemand_dtlfulfilled_qtyQuantify fulfilled (moved) against the part request) 
picked_qtydemand_dtlpicked_qtyQuantify picked (reserved for a fulfill) against the part request) 
received_qtydemand_dtlreceived_qtyQuantify received (from a fulfill) against the part request) 

Joins:

Join FromJoin To
(demand_dtl).demand_dtl2demand_hdr(demand_hdr).demand_hdr2demand_dtl
(demand_dtl).demand_dtl2condition(condition).condition2demand_dtl
(demand_dtl).demand_dtl_owner2user(user).curr_owner2demand_dtl
(demand_dtl).dmnd_dtl_sts2gbst_elm(gbst_elm).status2demand_dtl
(demand_dtl).demand_dtl2part_info(mod_level).part_info2demand_dtl
My Recent Objects
req_demand