View Name:svc_part_view
View Number:5100
Group:Product Mgr
Description:Part number and rev for the installed Service part; used by form Installed Services (620)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidsite_partobjidPart internal record number 
partnum_objidpart_numobjidPart num internal record number 
mod_objidmod_levelobjidPart revision internal record number 
part_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
descriptionpart_numdescriptionPart maps to sales and mfg systems 
serial_nosite_partserial_noInstalled part serial number 
quantitysite_partquantityInstalled part quantity; equal to 1 for serialized parts 
domainpart_numdomainName of the domain for the part num 
dom_serialnopart_numdom_serialnoDomain's degree of uniqueness of part serial number; i.e., 0=no serial numbers, tracked only by quantity, 1=unique serial numbers across all part numbers, 2=unique serial numbers only within a part number, 3=serial numbers don't need to be unique 
dom_uniquesnpart_numdom_uniquesnFor any given site, serial number must be unique for all part numbers; i.e., 0=no, 1=yes 
dom_catalogspart_numdom_catalogsAllow part to be included in BOMs; i.e., 0=no, 1=yes 
dom_bomspart_numdom_bomsAllow part to be included in BOMs; i.e., 0=no, 1=yes 
dom_at_sitepart_numdom_at_sitePart may be installed at either site or under another part. 0=no, 1=yes 
dom_at_partspart_numdom_at_partsDomain allows parts to be installed under other parts in the Site Configuration Manager; i.e., 0=no, 1=yes 
dom_at_domainpart_numdom_at_domainBin must be included in another domain? 0=no, 1=yes 
dom_pt_used_bompart_numdom_pt_used_bomDuring parts-used transactions, force part installation to conform to BOM; i.e., 0=no, 1=yes 
dom_pt_used_dompart_numdom_pt_used_domApply domain rules during parts-used transactions; i.e., 0=no, 1=yes 
selected_prdsite_partselected_prdSelected product 
instance_namesite_partinstance_namePart name 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
warranty_datesite_partwarranty_datePart warranty end date 
dir_site_objidsite_partdir_site_objidSite at which the part is installed. Derived from all_site_part2site. Not applicable to parts installed at more than one site 
sn_trackpart_numsn_trackTrack part for serialization; i.e., 0=by quantity, 1=by serial number 
incl_domainpart_numincl_domainName of the part's included domain 
role_objidsit_prt_roleobjidInternal record number of the sit_prt_role 3 (UNIQUE)
role_namesit_prt_rolerole_nameName of the role 
role_focus_typesit_prt_rolefocus_typeObject type ID of the role-player; i.e., 15=an installed part's role, 52=a site's role 
role_activesit_prt_roleactiveIndicates whether the site part role is active; i.e., 0=inactive, 1=active 
site_namesitenameSite name 
site_idsitesite_idUnique site number assigned according to auto-numbering definition 
site_objidsiteobjidSite internal record number 
instance_idsite_partinstance_idInstalled part unique instnace id 
config_typemod_levelconfig_typeDeclares Configurator constraints for the part: i.e., 0=not to be configured, 1=configure as a product, 2=configure as an option, default=0 
invoice_nosite_partinvoice_noInstalled part invoice number 
part_statussite_partpart_statusSite Configuration installed part status. This is a user-defined popup with default name PART_STATUS 
familypart_numfamilyMarketing product family the part belongs to. This is a user-defined popup with default name FAMILY and level name lev1 
part_typepart_numpart_typeAssigns a part type (separate from a domain). This is from a user-defined popup with default name PART_TYPE 
struct_typepart_numstruct_typeThe record type of the object; i.e., 0=service contract, 1=sales item, 2=eOrder, 3=shopping list 

Joins:

Join FromJoin To
(site_part).site_part2part_info(mod_level).part_info2site_part
(mod_level).part_info2part_num(part_num).part_num2mod_level
(sit_prt_role).prt_role2site_part(site_part).part2sit_prt_role
(sit_prt_role).prt_role2site(site).site2sit_prt_role
My Recent Objects
svc_part_view