objid | this_price_inst(price_inst) | objid | Price instance internal record number | 3 (UNIQUE) |
is_direct | offr_price | is_direct | Indicates if offer pricing uses an eligibility set to decide which products the offer pricing applies to, or if it applies directly to the related offer_product. 1=direct, 0=indirect; default=0 | |
price | this_price_inst(price_inst) | price | Price for a given product | |
rate_description | this_price_inst(price_inst) | rate_description | String value of price amount | |
is_reference | this_price_inst(price_inst) | is_reference | Indicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced | |
effective_date | this_price_inst(price_inst) | effective_date | Date the price instance becomes effective | |
expire_date | this_price_inst(price_inst) | expire_date | Last date the price instance is effective | |
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' | |
prog_name | price_prog | name | Description of the pricing program | |
offr_prod_objid | offr_prod | objid | Offering product internal record number | |
offr_price_name | offr_price | name | Reference name of offering pricing. Typically used for shared indirect pricing | |
base_objid | base_price_inst(price_inst) | objid | Base_price_inst internal record number | |
offr_price_objid | offr_price | objid | Offr_price internal record number | |
price_inst_price_type | this_price_inst(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 | |
type_string | this_price_inst(price_inst) | type_string | Translates price_type | |
is_offering_context | offr_price_role | is_offering_context | Indicate that the usage of the price is for just an offering; 1=Yes, 0=No;Default = 0 | |
is_group_context | offr_price_role | is_offering_group_context | Indicates that the usage of the price is for a common offering group; 1=Yes, 0=No;Default = 0 | |
is_framework_context | offr_price_role | is_framework_context | Indicates that the usage of the price is for a framework agreement; 1=Yes, 0=No;Default = 0 | |