View Name:partnum_view
View Number:332
Group:Product Mgr
Description:Part Rev and its Part Number; used by forms Select Part Numbers (610), Part Number (611), Installed Part (672), Installed Part (674), Catalog (682), ECO Detail (8401), Upgrade Item (8407), Alternate Parts (8414)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidmod_levelobjidPart revision internal record number 3 (UNIQUE)
part_nopart_numpart_numberPart number/name 
descriptionpart_numdescriptionMaps to sales and mfg systems 
mod_levelmod_levelmod_levelRevision level 
familypart_numfamilyMarketing product family the part belongs to; new user-defined pop up replaces relation to gbst_elm 
linepart_numlineMarketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm 
part_typepart_numpart_typeUser-defined pop up to denote a part type separate from the domain 
domainpart_numdomainName of the domain for the part num 
activepart_numactiveActive/inactive/obsolete 
part_num_objidpart_numobjidPart num internal record number 
mod_activemod_levelactiveActive/inactive/obsolete 
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_pr_used_dompart_numdom_pt_used_domApply domain rules during parts-used transactions; i.e., 0=no, 1=yes 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
sn_trackpart_numsn_trackTrack part for serialization; i.e., 0=by quantity, 1=by serial number 
dom_pt_used_warnpart_numdom_pt_used_warnWarning for parts used 
std_warrantypart_numstd_warrantyDefines length of standard warranty for part 
incl_domainpart_numincl_domainName of included domain 
notespart_numnotesComments about the part number 
is_sppt_progpart_numis_sppt_progIndicates whether part is a support program; i.e., 0=physical part, 1=service part 
unit_measurepart_numunit_measureUnit of measure for part number; e.g., roll, set, etc 
dom_literaturepart_numdom_literatureIndicates whether 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 
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 
turn_ratiopart_statsturn_ratioPart usage for parts included in a cycle count profile 
abc_codepart_statsabc_codeABC code classification for the mod_level 
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 
x_res1part_numx_res1Data Restriction field 
x_res2part_numx_res2Data Restriction field 
x_res3part_numx_res3Data Restriction field 
x_res4part_numx_res4Data Restriction field 
x_res5part_numx_res5Data Restriction field 

Joins:

Join FromJoin To
(mod_level).part_info2part_num(part_num).part_num2mod_level
(mod_level).part_info2part_statsOUTER (part_stats).part_stats2part_info
My Recent Objects
partnum_view