View Name:site_svc_itm
View Number:5182
Group:Support
Description:Used for Entitlement checking. Used by forms Incoming Call (8110), Select Contract (9180) and My Clarify (12000)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_site_svc_itm
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcontr_itmobjidContract item internal record number 3 (UNIQUE)
contr_idcontractidContract ID number 
sch_idcontr_scheduleschedule_idContract schedule ID number 
line_nocontr_itmline_noContract item line number 
site_idsitesite_idSite ID number 
site_namesitenameName of the site 
site_objidsiteobjidSite internal record number 
quantitycontr_itmquantityContracted/Quoted quantity of the part 
start_datecontr_itmstart_dateThe starting date for the line item 
end_datecontr_itmend_dateThe ending date for the line item 
conditionconditiontitleThe condition of the contract 
line_no_txtcontr_itmline_no_txtDsiplays line number text of contr_itm 
sch_objidcontr_scheduleobjidSchedule internal record number 
contr_objidcontractobjidContract internal record number 

Joins:

Join FromJoin To
(contr_itm).covered_by2site(site).covered_by2contr_itm
(contr_itm).contr_itm2contr_schedule(contr_schedule).schedule2contr_itm
(contr_schedule).schedule2contract(contract).contract2contr_schedule
(contract).contract2condition(condition).condition2contract
My Recent Objects
site_svc_itm      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user