View Name:scm_vw
View Number:5735
Group:Product Mgr
Description:Used by form Site Configuration Mgr (683), Reinstall Parts (687), Contract <ID> (731), Contract Details (732), Contract Service (777), New Parent Case (423), Incoming Call (8110), Part Used (690) and others
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidsite_partobjidPart internal record number 3 (UNIQUE)
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 
level_to_partsite_partlevel_to_partRelative level to a part in an installed part hierarchy 
selected_prdsite_partselected_prdSelected product 
level_to_binsite_partlevel_to_binRelative level to a bin 
bin_objidsite_partbin_objidLocally stored product bin ID 
site_objidsite_partsite_objidSite internal record number 
inst_objidsite_partinst_objidInstalled part internal record number 
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 included domain 
dom_literaturepart_numdom_literatureIndicates the part is a literature part; 0=no, 1=yes. Marketing collateral is an example of a literature part 
dom_is_servicepart_numdom_is_serviceIndicates the part is a service part, if selected, sit_prt_role will be set when installed; i.e., 0=not a service, 1=a service 
site_part_indsite_partsite_part_indUsed for read-only installed part 
part_statussite_partpart_statusSite Configuration installed part status 
activemod_levelactiveActive/inactive/obsolete 

Joins:

Join FromJoin To
(site_part).site_part2part_info(mod_level).part_info2site_part
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
scm_vw