| active | CHAR | varchar | | 20 | | CHANGE_FIELD | Active/inactive/obsolete | Search (12) |
| description | CHAR | varchar | | 255 | | CHANGE_FIELD | Description of the product | Search (65) |
| dev | LONG | int | 151 | | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | |
| dimension | CHAR | varchar | | 20 | | | Packaged dimensions of part | |
| dom_at_domain | LONG | int | | | | DIRECT | Bin must be included in another domain? 0=no, 1=yes | Search (5) |
| dom_at_parts | LONG | int | | | | DIRECT | Domain allows parts to be installed under other parts in the Site Configuration Manager; i.e., 0=no, 1=yes | Search (5) |
| dom_at_site | LONG | int | | | | DIRECT | Part may be installed at either site or under another part. 0=no, 1=yes | Search (5) |
| dom_boms | LONG | int | | | | DIRECT | Allow part to be included in BOMs; i.e., 0=no, 1=yes | Search (5) |
| dom_catalogs | LONG | int | | | | DIRECT | Allow part to be included in BOMs; i.e., 0=no, 1=yes | Search (5) |
| dom_is_service | LONG | int | | | 0 | DIRECT | 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, default=0 | Search (10) |
| dom_literature | LONG | tinyint | | | 0 | DIRECT | Indicates whether part is a literature part; 0=no, 1=yes. Marketing collateral is an example of a literature part | Search (4) |
| dom_pt_used_bom | LONG | int | | | | DIRECT | During parts-used transactions, force part installation to conform to BOM; i.e., 0=no, 1=yes | Search (5) |
| dom_pt_used_dom | LONG | int | | | | DIRECT | Apply domain rules during parts-used transactions; i.e., 0=no, 1=yes | Search (5) |
| dom_pt_used_warn | LONG | int | | | | DIRECT | Warning for parts used | Search (2) |
| dom_serialno | LONG | int | | | | DIRECT | Serial number's degree of uniqueness; i.e., 0=no serial numbers, tracked only by quantity, 1=unique across all part numbers, 2=unique within a part number, 3=not unique | Search (5) |
| dom_uniquesn | LONG | int | | | | DIRECT | For any given site, serial number must be unique for all part numbers; i.e., 0=no, 1=yes | Search (5) |
| domain | CHAR | varchar | | 40 | | | Name of the domain for the part num. See object prt_domain | Search (35) |
| family | CHAR | varchar | | 40 | | | Marketing product family the part belongs to. This is a user-defined popup with default name FAMILY and level name lev1 | Search (23) |
| incl_domain | CHAR | varchar | | 40 | | | Domain of the part under which the current part must be installed. If empty, part may be installed directly under the site | Search (5) |
| is_dom_at_bus_org | LONG | tinyint | | | 0 | DIRECT, ALLOW_NULL | Indicates group level products, to allow parts in the domain to be related to a bus_org; 1=Yes, 0=No; Default=0 | Search (4) |
| is_fulfilled | LONG | tinyint | | | 0 | DIRECT, ALLOW_NULL | Is the product need to be fulfilled by fulfillment system. 0= no, 1=yes; Default=0 | Search (1) |
| is_sppt_prog | LONG | tinyint | | | | DIRECT | Indicates application category of the part: i.e., 0=physical part, 1=service part, 2=product literature | Search (9) |
| line | CHAR | varchar | | 40 | | | Marketing product line, within family, of the part. This is a user-defined popup with default name FAMILY and level name lev2 | Search (21) |
| model_num | CHAR | varchar | | 20 | | | Marketing model number of the part; within family and line | Search (28) |
| notes | CHAR | varchar | | 255 | | | Comments about the part number | Search (3) |
| objid | LONG | int | 3 | | | DIRECT | Internal record number | Search (64) |
| p_as_child | LONG | tinyint | | | 0 | DIRECT | Indicates whether the part may be priced as an option; i.e. 0=no, 1=yes, default=0 | Search (8) |
| p_as_parent | LONG | tinyint | | | 0 | DIRECT | Indicates whether the part may be priced with options under it; i.e. 0=no, 1=yes, default=0 | Search (8) |
| p_standalone | LONG | tinyint | | | 0 | DIRECT | Indicates whether the part may receive standalone pricing; i.e. 0=no, 1=yes, default=0 | Search (8) |
| part_number | CHAR | varchar | | 30 | | CHANGE_FIELD | Part number/name | Search (78) |
| part_type | CHAR | varchar | | 40 | | | Assigns a part type (separate from a domain). This is from a user-defined popup with default name PART_TYPE | Search (13) |
| prog_type | LONG | tinyint | | | | DIRECT | If support program, indicates whether program is site-based or product-based; i.e., 0=product, 1=site, default=0. Reserved; not used | Search (3) |
| repair_type | CHAR | varchar | | 20 | | | Shows whether the part is repairable or expendable | |
| sn_track | LONG | int | | | 1 | DIRECT | Track part for serialization; i.e., 0=by quantity, 1=by serial number | Search (20) |
| std_warranty | LONG | int | | | | DIRECT | Defines length of standard warranty for part | Search (2) |
| struct_type | LONG | tinyint | | | 0 | DIRECT, ALLOW_NULL | The record type of the object; i.e., 0=service contract, 1=sales item, 2=eOrder, 3=shopping list | Search (1) |
| unit_measure | CHAR | varchar | | 8 | | | Unit of measure for part number; e.g., roll, set, etc | Search (8) |
| warr_start_key | LONG | int | | | | DIRECT | Indicates whether warranty starts from shipment or installation | Search (1) |
| weight | CHAR | varchar | | 20 | | | Packaged weight of the part | |
| x_literature | CHAR | varchar | | 255 | | USER_DEFINED | Path for sales literature | Search (1) |
| x_modify_stmp | CLK_TIME | datetime | | | | CHANGE_DATE, USER_DEFINED | The date and time when change fields were last updated | Search (1) |
| x_res1 | CHAR | varchar | | 20 | | USER_DEFINED | Restriction field | Search (8) |
| x_res2 | CHAR | varchar | | 20 | | USER_DEFINED | Restriction field | Search (8) |
| x_res3 | CHAR | varchar | | 20 | | USER_DEFINED | Restriction field | Search (8) |
| x_res4 | CHAR | varchar | | 20 | | USER_DEFINED | Restriction field | Search (8) |
| x_res5 | CHAR | varchar | | 20 | | USER_DEFINED | Restriction field | Search (8) |