part_num_objid | part_num | objid | Part_num objid | |
mod_level_objid | parent_mod_level(mod_level) | objid | Mod_level objid | |
price_qty_objid | price_qty | objid | Price_qty internal record number | |
objid | price_inst | objid | Price_inst internal record number | 3 (UNIQUE) |
price_prog_objid | price_prog | objid | Price_prog internal record number | |
part_number | part_num | part_number | Partnumber/name | |
part_desc | part_num | description | Description of the product | |
part_domain | part_num | domain | Name of the domain for the partnum. See object prt_domain | |
unit_measure | part_num | unit_measure | Unit of measure | |
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 | |
mod_level | parent_mod_level(mod_level) | mod_level | Name of the part revision | |
active | parent_mod_level(mod_level) | active | Active/inactive/obsolete | |
priced_qty | price_qty | priced_qty | The quantity of the priced part being quoted | |
p_qty_type | price_qty | p_qty_type | Type of price_qty; 0=is parent or standalone; 1=is child | |
fixed_amt | price_inst | price | Price for a given product or the calculated price as fetched percentage*the price | |
percentage | price_inst | price | Percentage used in price calculations | |
price | price_inst | price | Price for a given product or the calculated price as fetched percentage*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 | |
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_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 | |
child_mod_objid | child_mod_level(mod_level) | objid | Child mod_level internal record number | |
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 | |
currency_objid | currency | objid | currency internal record number | |
model_num | part_num | model_num | Marketing model number of the part; within family and line | |
price_type_str | price_inst | type_string | Translates price_type | |
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 | |