View Name:demand_vue
View Number:50
Group:Logistics
Description:Displays Part Request information. Used by form Contact More Info (713)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_demand_vue
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 

Joins:

Join FromJoin 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
My Recent Objects
demand_vue      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user