View Name:ship_sum
View Number:3
Group:Logistics
Description:Displays queries in the query group. Used by form Shipments Query List (589)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_ship_sum
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidship_dtlobjidShip_dtl internal record number 3 (UNIQUE)
last_fulf_sndemand_dtllast_fulf_snLast fulfilled serial number for req detail 
shipped_snship_dtlserial_noShipped serial number for req detail 
ship_parts_objidship_partsobjidShip_parts internal record number 
ship_dateship_partsship_dateThe ship date for the parts 
waybillship_partswaybillThe waybill number 
ship_weightship_partstotal_weightThe total weight of the shipment 
rma_numberdemand_dtldetail_numberThe part request number for the request of the shipment 
part_numbership_dtlpart_numberPart number/name 
part_num_descship_dtldescriptionPart number, maps to sales and mfg systems 
shipped_qtydemand_dtlshipped_qtyThe quantity shipped 
serial_nodemand_dtlserial_noSerial number for the request 
site_nameship_partsship_to_nameLocal copy of the site name 
activitydemand_dtlactivityReserved; future 
conditionconditiontitlePart request condition 
statusgse_status(gbst_elm)titleReserved; not used 17
ownership_partsshipper_userShip Originator - login name 
titledemand_dtltitlePart request title 2
dtl_numdemand_dtldetail_numberRequest ID 
dtl_typedemand_dtlrequest_typeRequest types; i.e., 'depot repair', 'advance exchange', or 'return for credit 
dtl_datedemand_dtldetails_dateRequest date 
carriersitenameCarrier for shipment 
part_revship_dtlmod_levelName of the part revision, AKA part version 
dtl_objiddemand_dtlobjidInternal reference number of the part request 
ship_addressship_partsship_addressShip to address; line 1 
ship_address2ship_partsship_address2Ship to address; line 2 
ship_cityship_partsship_cityShip to city 
ship_stateship_partsship_stateShip to state 
ship_zipship_partsship_zipShip to zip code 
ship_piecesship_partspiecesNumber of pieces in the shipment 

Joins:

Join FromJoin To
(ship_dtl).ship_dtl2demand_dtl(demand_dtl).demand_dtl2ship_dtl
(demand_dtl).demand_dtl2condition(condition).condition2demand_dtl
(demand_dtl).dmnd_dtl_sts2gbst_elmgse_status(gbst_elm).status2demand_dtl
(ship_parts).carrier2vendorOUTER (site).carrier2ship_parts
(ship_dtl).ship_dtl2ship_parts(ship_parts).ship_parts2ship_dtl
My Recent Objects
ship_sum      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user