price_inst_objid | price_inst | objid | Price_inst internal record number | 3 (UNIQUE) |
price | price_inst | price | Price for a given product | |
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 | |
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_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 | 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' | |
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 | |
offr_price_objid | offr_price | objid | Offr_price internal record number | |
offr_price_is_shared | offr_price | is_shared | Indicates that the indirect offr_price can be re-used across offerings. 1=shared, 0=not shared; default=0 | |
currency_objid | currency | objid | Currency internal record number | |
currency_symbol | currency | symbol | Symbol for the currency; e.g., $ for US dollar | |