objid | price_inst | objid | Price instance internal record number | 3 (UNIQUE) |
offr_prod_objid | offr_prod | objid | Offering product internal record number | |
min_number | offr_prod | min_number | Minimum number of product / option that must be taken up in the offering. Default=1 | |
max_number | offr_prod | max_number | Maximum number of product / option that must be taken up in the offering. Default=1 | |
part_num_objid | part_num | objid | Part internal record number | |
part_number | part_num | part_number | Part number/name | |
price_qty_objid | price_qty | objid | Price_qty internal record number | |
par_mod_level_objid | parent_mod_level(mod_level) | objid | Parent mod_level internal record number | |
child_mod_level_objid | child_mod_level(mod_level) | objid | Child mod_level internal record number | |
price | price_inst | price | Price for a given product | |
rate_description | price_inst | rate_description | String value of price amount | |
is_reference | price_inst | is_reference | Indicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced | |
effective_date | price_inst | effective_date | Date the price instance becomes effective | |
expire_date | price_inst | expire_date | Last date the price instance is effective | |
price_type_name | 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' | |
price_prog_name | price_prog | name | Name for the pricing program | |
currency_objid | currency | objid | Currency internal record number | |