View Name:offr_price_inst_view
View Number:5812
Group:Morder
Description:Used to price at revision level. Used in form (122025) or create_offering_special_pricing.jsp JSP page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
price_inst_objidprice_instobjidPrice_inst internal record number 3 (UNIQUE)
priceprice_instpricePrice for a given product 
effective_dateprice_insteffective_dateDate the price instance becomes effective 
expire_dateprice_instexpire_dateLast date the price instance is effective 
rate_descriptionprice_instrate_descriptionString value of price amount 
is_referenceprice_instis_referenceIndicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced 
price_prog_objidprice_progobjidPrice_prog internal record number 
price_prog_nameprice_prognameName for the pricing program 
price_type_objidprice_typeobjidPrice_type internal record number 
price_typeprice_typetypePricing type used to decide how to handle the charge. 1=one time immediate, 2=one time bill, 3=recurring bill 
price_type_descriptionprice_typedescriptionMarketing text to be used to present the pricing to the user or customer e.g. 'Connection Fee', 'Monthly Line Rental', 'Deposit' 
adjustmentprice_instprice_typeType of value in the price field; i.e., 0=currency amount, 1=percent of parent from price_qty, 2=percent of child 
adjustment_stringprice_insttype_stringTranslates price_type 
offr_price_objidoffr_priceobjidOffr_price internal record number 
offr_price_is_sharedoffr_priceis_sharedIndicates that the indirect offr_price can be re-used across offerings. 1=shared, 0=not shared; default=0 
currency_objidcurrencyobjidCurrency internal record number 
currency_symbolcurrencysymbolSymbol for the currency; e.g., $ for US dollar 

Joins:

Join FromJoin To
(price_inst).price_inst2price_prog(price_prog).price_prog2price_inst
(price_inst).price_inst2offr_price(offr_price).offr_price2price_inst
(price_inst).price_inst2price_type(price_type).price_type2price_inst
(price_prog).price_prog2currency(currency).currency2price_prog
My Recent Objects
offr_price_inst_view