objid | mod_level | objid | Part revision internal record number | 3 (UNIQUE) |
part_no | part_num | part_number | Part number/name | |
description | part_num | description | Maps to sales and mfg systems | |
mod_level | mod_level | mod_level | Revision level | |
family | part_num | family | Marketing product family the part belongs to; new user-defined pop up replaces relation to gbst_elm | |
line | part_num | line | Marketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm | |
part_type | part_num | part_type | User-defined pop up to denote a part type separate from the domain | |
domain | part_num | domain | Name of the domain for the part num | |
active | part_num | active | Active/inactive/obsolete | |
part_num_objid | part_num | objid | Part num internal record number | |
mod_active | mod_level | active | Active/inactive/obsolete | |
dom_serialno | part_num | dom_serialno | Domain'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_uniquesn | part_num | dom_uniquesn | For any given site, serial number must be unique for all part numbers; i.e., 0=no, 1=yes | |
dom_catalogs | part_num | dom_catalogs | Allow part to be included in BOMs; i.e., 0=no, 1=yes | |
dom_boms | part_num | dom_boms | Allow part to be included in BOMs; i.e., 0=no, 1=yes | |
dom_at_site | part_num | dom_at_site | Part may be installed at either site or under another part. 0=no, 1=yes | |
dom_at_parts | part_num | dom_at_parts | Domain allows parts to be installed under other parts in the Site Configuration Manager; i.e., 0=no, 1=yes | |
dom_at_domain | part_num | dom_at_domain | Bin must be included in another domain? 0=no, 1=yes | |
dom_pt_used_bom | part_num | dom_pt_used_bom | During parts-used transactions, force part installation to conform to BOM; i.e., 0=no, 1=yes | |
dom_pr_used_dom | part_num | dom_pt_used_dom | Apply domain rules during parts-used transactions; i.e., 0=no, 1=yes | |
model_num | part_num | model_num | Marketing model number of the part; within family and line | |
sn_track | part_num | sn_track | Track part for serialization; i.e., 0=by quantity, 1=by serial number | |
dom_pt_used_warn | part_num | dom_pt_used_warn | Warning for parts used | |
std_warranty | part_num | std_warranty | Defines length of standard warranty for part | |
incl_domain | part_num | incl_domain | Name of included domain | |
notes | part_num | notes | Comments about the part number | |
is_sppt_prog | part_num | is_sppt_prog | Indicates whether part is a support program; i.e., 0=physical part, 1=service part | |
unit_measure | part_num | unit_measure | Unit of measure for part number; e.g., roll, set, etc | |
dom_literature | part_num | dom_literature | Indicates whether part is a literature part; 0=no, 1=yes. Marketing collateral is an example of a literature part | |
dom_is_service | part_num | dom_is_service | Indicates 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_standalone | part_num | p_standalone | Indicates whether the part may receive standalone pricing; i.e.' 0=no, 1=yes, default=0 | |
p_as_parent | part_num | p_as_parent | Indicates whether the part may be priced with options under it; i.e., 0=no, 1=yes, default=0 | |
p_as_child | part_num | p_as_child | Indicates whether the part may be priced as an option; i.e., 0=no, 1=yes, default=0 | |
turn_ratio | part_stats | turn_ratio | Part usage for parts included in a cycle count profile | |
abc_code | part_stats | abc_code | ABC code classification for the mod_level | |
config_type | mod_level | config_type | Declares 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_res1 | part_num | x_res1 | Data Restriction field | |
x_res2 | part_num | x_res2 | Data Restriction field | |
x_res3 | part_num | x_res3 | Data Restriction field | |
x_res4 | part_num | x_res4 | Data Restriction field | |
x_res5 | part_num | x_res5 | Data Restriction field | |