objid | price_inst | objid | Price instance internal record number | 3 (UNIQUE) |
part_num_objid | part_num | objid | Part internal record number | |
part_number | part_num | part_number | Part number/name | |
part_desc | part_num | description | Description of the product | |
mod_level_objid | child_mod_level(mod_level) | objid | Child 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 part revision | |
price_qty_objid | price_qty | objid | Price_qty internal record number | |
price | price_inst | price | Price for a given product | |
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 | |
reference | price_inst | is_reference | Indicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced | |
rate_description | price_inst | rate_description | String value of price amount | |
price_prog_objid | price_prog | objid | Price_prog internal record number | |
price_prog_name | price_prog | name | Name for the pricing program | |
price_type_objid | price_type | objid | Price_type internal record number | |
price_type_type | price_type | type | Pricing type used to decide how to handle the charge. 1=one time immediate, 2=one time bill, 3=recurring bill | |
price_type_description | price_type | description | Marketing text to be used to present the pricing to the user or customer e.g. 'Connection Fee', 'Monthly Line Rental', 'Deposit' | |
currency_objid | currency | objid | Currency internal record number | |
currency_symbol | currency | symbol | Symbol for the currency; e.g., $ for US dollar | |