part_num_objid | part_num | objid | Part num internal record number | |
part_number | part_num | part_number | Part number/name | |
part_desc | part_num | description | Description of the product | |
part_domain | part_num | domain | Name of the domain for the part num. See object prt_domain | |
model_num | part_num | model_num | Marketing model number of the part; within family and line | |
mod_level_objid | child_mod_level(mod_level) | objid | Mod level internal record number | |
par_mod_level_objid | parent_mod_level(mod_level) | objid | Parent mod level internal record number | |
mod_level | child_mod_level(mod_level) | mod_level | Name of the parent part revision | |
active | child_mod_level(mod_level) | active | Active/inactive/obsolete | |
price_qty_objid | price_qty | objid | Price quantity internal record number | |
priced_qty | price_qty | priced_qty | The quantity of the part being quoted | |
fixed_amt | price_inst | price | Price for a given product or the calculated price as fetched percentage * the price | |
percentage | price_inst | price | Price for a given product or the calculated price as fetched percentage of the price | |
price | price_inst | price | Price for a given product or the calculated price as fetched percentage of the price | |
price_inst_eff_dt | price_inst | effective_date | Date the price instance becomes effective | |
price_inst_exp_dt | price_inst | expire_date | Last date the price instance is effective | |
price_type | price_inst | price_type | Last date the price instance is effective | |
unit_measure | part_num | unit_measure | unit of measure | |
objid | price_inst | objid | Price_inst internal record number | 3 (UNIQUE) |
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 | |
part_line | part_num | line | Marketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm | |
part_family | part_num | family | Marketing product family the part belongs to; 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 | |
part_status | part_num | active | Active/inactive/obsolete | |
p_qty_type | price_qty | p_qty_type | Type of price_qty; 0=is parent or standalone; 1=is child | |
is_sppt_prog | part_num | is_sppt_prog | Indicates application category of the part: i.e., 0=physical part, 1=service part, 2=product literature | |
price_prog_objid | price_prog | objid | Price program internal record number | |
currency_objid | currency | objid | Currency internal record number | |
price_prog_name | price_prog | name | Name for the pricing program | |
price_prog_dspcc | price_prog | displaycc | If true, display pricing program in Clear Contracts; i.e., 0=false, 1=true. Default=0 | |
prog_eff_dt | price_prog | effective_date | Date the price program becomes effective | |
prog_exp_dt | price_prog | expire_date | Last date the price program is effective | |
mod_eff_dt | child_mod_level(mod_level) | eff_date | The date the support program version becomes effective | |
mod_exp_dt | child_mod_level(mod_level) | end_date | The date the support program version expires | |
price_type_str | price_inst | type_string | Translates price_type | |
sn_track | part_num | sn_track | Track part for serialization; i.e., 0=by quantity, 1=by serial number | |
sub_scale | currency | sub_scale | Gives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 | |
currency_name | currency | name | Name for the currency | |