View Name:repair_sum
View Number:221
Group:Logistics
Description:Contains repair information about parts on a part request. Used on third frame of part request form
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_repair_sum
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objiddemand_hdrobjidDemand hdr internal record number 
details_objiddemand_dtlobjidDemand_dlt internal record number 3 (UNIQUE)
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_hdrdemand_typeReserved; not used 
request_statusdemand_hdrrequest_statusStatus of the request 
order_qtydemand_dtldemand_qtyThe orderquantity 
activitydemand_dtlactivityReserved; future 
required_datedemand_dtlnext_dateThe date required 
details_statusdemand_dtldetails_statusThe status for the detail 
part_numpart_numdescriptionMaps to sales and mfg systems 
details_datedemand_dtldetails_dateThe create date for the part request 
part_serial_nopart_instpart_serial_noFor serial tracked parts, the serial number of the part 

Joins:

Join FromJoin To
(demand_dtl).demand_dtl2demand_hdr(demand_hdr).demand_hdr2demand_dtl
(part_inst).n_part_inst2part_mod(mod_level).n_part_info2part_inst
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
repair_sum      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user