objid | site_part | objid | Part internal record number | 3 (UNIQUE) |
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 | |
level_to_part | site_part | level_to_part | Relative level to a part in an installed part hierarchy | |
selected_prd | site_part | selected_prd | Selected product | |
level_to_bin | site_part | level_to_bin | Relative level to a bin | |
bin_objid | site_part | bin_objid | Locally stored product bin ID | |
site_objid | site_part | site_objid | Site internal record number | |
inst_objid | site_part | inst_objid | Installed part internal record number | |
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 included domain | |
dom_literature | part_num | dom_literature | Indicates the 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 | |
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 | |
line | part_num | line | Marketing product line, within family, of the part. This is a user-defined popup with default name FAMILY and level name lev2 | |
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 | |
invoice_no | site_part | invoice_no | Installed part invoice number | |
ship_date | site_part | ship_date | Installed part ship date | |
install_date | site_part | install_date | Part installation date | |
part_status | site_part | part_status | Site Configuration installed part status. This is a user-defined popup with default name PART_STATUS | |
comments | site_part | comments | Installed part comment | |
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 | |