price_inst_objid | price_inst | objid | Price instance internal record number | 3 (UNIQUE) |
price | price_inst | price | Price for a given product | |
effective_date | price_inst | effective_date | Price instance effective date | |
expire_date | price_inst | expire_date | Price instance expiry date | |
price_prog_objid | price_prog | objid | Price programme internal record number | |
price_prog_name | price_prog | name | Price programme name | |
price_type_objid | price_type | objid | Price type internal record number | |
price_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_qty_objid | price_qty | objid | Price_qty internal record number | |
mod_level_objid | mod_level | objid | Mod_level internal record number | |
part_num_objid | part_num | objid | Part num internal record number | |
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 | |
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' | |
adjustment | price_inst | price_type | Type of value in the price field; i.e., 0=currency amount, 1=percent of parent from price_qty, 2=percent of child | |
adjustment_string | price_inst | type_string | Translates price_type | |
currency_objid | currency | objid | Currency internal record number | |