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
select * from table_demand_site
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
demand_hdrdemand_hdrobjidDemand hdr internal record number 
demand_dtldemand_dtlobjidDemand_dlt internal record number 3 (UNIQUE)
part_modmod_levelobjidPart revision internal record number 
part_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
detail_numberdemand_dtldetail_numberThe part request number for the request 
details_datedemand_dtldetails_dateThe create date for the part request 
details_statusdemand_dtldetails_statusThe status for the detail 
demand_qtydemand_dtldemand_qtyThe order quantity 
shipped_qtydemand_dtlshipped_qtyThe quantity shipped 
movement_typedemand_dtlmovement_typeReserved; future 
site_objidsiteobjidSite internal record number 
part_domainpart_numdomainName of the part's domain 
statusgse_status(gbst_elm)titleStatus of the demand_dtl 17

Joins:

Join FromJoin 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_elmgse_status(gbst_elm).status2demand_dtl
(mod_level).part_info2part_num(part_num).part_num2mod_level
(demand_hdr).open_reqst2site(site).site2demand_hdr
My Recent Objects
demand_site      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user