View Name:c_sppt_ent
View Number:5099
Group:Sales Mgr
Description:Displays support entitlement info. Used by forms Incoming Call (IC) (8110), Support Program <ID> (9151) and Select Support Program form (9154)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
sp_objidpart_numobjidGeneric part internal record number 
mod_objidmod_levelobjidGeneric part revision internal record number 
sp_idpart_numpart_numberPart number/name of the generic part 
sp_notespart_numnotesComments about the generic part 
sp_descpart_numdescriptionDescription of the part 
prog_typepart_numprog_typeIf support program, indicates whether program is site-based or product-based; i.e., 0=product, 1=site, default=0 
is_sppt_progpart_numis_sppt_progIndicates application category of the part: i.e., 0=physical part, 1=service part, 2=product literature 
p_standalonepart_nump_standaloneIndicates whether the part MAY receive standalone pricing; i.e. 0=no, 1=yes, default=0 
p_as_parentpart_nump_as_parentIndicates whether the part MAY be priced with options under it; i.e. 0=no, 1=yes, default=0 
p_as_childpart_nump_as_childIndicates whether the part MAY be priced as an option; i.e. 0=no, 1=yes, default=0 
mod_activemod_levelactiveActive/inactive/obsolete 
mod_eff_datemod_leveleff_dateThe date the support program version becomes effective 
mod_end_datemod_levelend_dateThe date the support program version expires 
ent_typeentitlementtypeThe type of service 
delivery_typeentitlementdelivery_typeHow consumption of the service is measured: i.e., 0=by unit (e.g., incident); 1=by duration (e.g., month) 
categoryentitlementcategoryService category; i.e., 0=product-based, 1=site-based, 2=stand alone 
resp_timeentitlementresponse_timeThe committed response time for the entitlement in seconds 
cov_hr_titlewk_work_hrtitleName of the business calendar which has the entitled service hours 
cov_hr_descwk_work_hrdescriptionDetailed description of the business calendar which has the entitled service hours 
objidentitlementobjidEntitlement internat record number 3 (UNIQUE)
ctgry_nameentitlementctgry_nameTranslates category 

Joins:

Join FromJoin To
(mod_level).part_info2part_num(part_num).part_num2mod_level
(entitlement).service2mod_level(mod_level).service2entitlement
(entitlement).entitlement2wk_work_hrOUTER (wk_work_hr).wk_work_hr2entitlement
My Recent Objects
c_sppt_ent