View Name:req_sum
View Number:238
Group:Logistics
Description:Queries in the query group. No longer use by forms Part Request Details (502). Still used only as an in-memory data store in conjunction with views 5332 and 5333
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 
request_datedemand_hdrheader_dateThe create date for the request header 
case_id_numberdemand_hdrheader_case_noThe case or subcase optionally related to the request 
rma_numberdemand_dtldetail_numberThe part request number for the request 
site_namedemand_hdrsite_nameLocal copy of the site name 
part_numberpart_numpart_numberPart number/name 
request_typedemand_dtldemand_subtypeReserved; future 
request_statusdemand_hdrrequest_statusStatus of the request 
order_qtydemand_dtldemand_qtyThe 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 
part_numpart_numdescriptionMaps to sales and mfg systems 
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 
part_mod_lmod_levelmod_levelRevision level 
conditionconditiontitlePart request condition 7
statusgse_status(gbst_elm)titleStatus of the part request 17
owneruserlogin_nameUser login name 
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) 
domainpart_numdomainName of the domain for the part num. See object prt_domain 
cond_objidconditionobjidPart request condition internal record number 
cond_codeconditionconditionPart request condition code 
owner_objiduserobjidUser owner of the part request internal record number 
header_numberdemand_hdrheader_numberheader_number 
orig_iddemand_dtlorig_idIf originated from another demand_dtl, the originating part request's detail_number (see relation demand_dtl.child_dtl2demand_dtl) 

Joins:

Join FromJoin To
(demand_dtl).demand_dtl2demand_hdr(demand_hdr).demand_hdr2demand_dtl
(demand_dtl).demand_dtl_owner2user(user).curr_owner2demand_dtl
(demand_dtl).demand_dtl2condition(condition).condition2demand_dtl
(demand_dtl).dmnd_dtl_sts2gbst_elmgse_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
My Recent Objects
req_sum