objid | site_part | objid | Part internal record number | |
partnum_objid | part_num | objid | Part num internal record number | |
mod_objid | mod_level | objid | Part revision internal record number | |
part_number | part_num | part_number | Part number/name | |
mod_level | mod_level | mod_level | Revision level | |
description | part_num | description | Part maps to sales and mfg systems | |
serial_no | site_part | serial_no | Installed part serial number | |
quantity | site_part | quantity | Installed part quantity; equal to 1 for serialized parts | |
domain | part_num | domain | Name of the domain for the part num | |
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_pt_used_dom | part_num | dom_pt_used_dom | Apply domain rules during parts-used transactions; i.e., 0=no, 1=yes | |
selected_prd | site_part | selected_prd | Selected product | |
instance_name | site_part | instance_name | Part name | |
model_num | part_num | model_num | Marketing model number of the part; within family and line | |
warranty_date | site_part | warranty_date | Part warranty end date | |
dir_site_objid | site_part | dir_site_objid | Site at which the part is installed. Derived from all_site_part2site. Not applicable to parts installed at more than one site | |
sn_track | part_num | sn_track | Track part for serialization; i.e., 0=by quantity, 1=by serial number | |
incl_domain | part_num | incl_domain | Name of the part's included domain | |
role_objid | sit_prt_role | objid | Internal record number of the sit_prt_role | 3 (UNIQUE) |
role_name | sit_prt_role | role_name | Name of the role | |
role_focus_type | sit_prt_role | focus_type | Object type ID of the role-player; i.e., 15=an installed part's role, 52=a site's role | |
role_active | sit_prt_role | active | Indicates whether the site part role is active; i.e., 0=inactive, 1=active | |
site_name | site | name | Site name | |
site_id | site | site_id | Unique site number assigned according to auto-numbering definition | |
site_objid | site | objid | Site internal record number | |
instance_id | site_part | instance_id | Installed part unique instnace id | |
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 | |
invoice_no | site_part | invoice_no | Installed part invoice number | |
part_status | site_part | part_status | Site Configuration installed part status. This is a user-defined popup with default name PART_STATUS | |
family | part_num | family | Marketing product family the part belongs to. This is a user-defined popup with default name FAMILY and level name lev1 | |
part_type | part_num | part_type | Assigns a part type (separate from a domain). This is from a user-defined popup with default name PART_TYPE | |
struct_type | part_num | struct_type | The record type of the object; i.e., 0=service contract, 1=sales item, 2=eOrder, 3=shopping list | |