mod_level_objid | child_mod_level(mod_level) | objid | Child mod_level internal record number | |
part_no | part_num | part_number | Part number/name | |
description | part_num | description | Product description | |
mod_level | child_mod_level(mod_level) | mod_level | Name of part revision | |
family | part_num | family | Marketing product family, of the part. 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 | Part number/name | |
domain | part_num | domain | Name of the domain for the part num. See object prt_domain | |
active | part_num | active | Active/inactive/obsolete | |
mod_active | child_mod_level(mod_level) | active | Active/inactive/obsolete | |
part_num_objid | part_num | objid | Part internal record number | |
model_num | part_num | model_num | Marketing model number of the part; within family and line | |
objid | price_qty | objid | Price_qty internal record number | 3 (UNIQUE) |
p_qty_type | price_qty | p_qty_type | Type of price_qty; 0=is a standalone part, 1=is a parent or child part | |
par_mod_level_objid | parent_mod_level(mod_level) | objid | Parent mod_level internal record number | |