View Name:offr_prod_price_v
View Number:5792
Group:Morder
Description:Lists the prices of products belonging to a certain offer (Screen ID 122023) May later become a FAKE view joining the products base prices with the prices given to them as part of the offer. Used in offering_pricing.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidprice_instobjidPrice instance internal record number 3 (UNIQUE)
offr_prod_objidoffr_prodobjidOffering product internal record number 
min_numberoffr_prodmin_numberMinimum number of product / option that must be taken up in the offering. Default=1 
max_numberoffr_prodmax_numberMaximum number of product / option that must be taken up in the offering. Default=1 
part_num_objidpart_numobjidPart internal record number 
part_numberpart_numpart_numberPart number/name 
price_qty_objidprice_qtyobjidPrice_qty internal record number 
par_mod_level_objidparent_mod_level(mod_level)objidParent mod_level internal record number 
child_mod_level_objidchild_mod_level(mod_level)objidChild mod_level internal record number 
priceprice_instpricePrice for a given product 
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 
effective_dateprice_insteffective_dateDate the price instance becomes effective 
expire_dateprice_instexpire_dateLast date the price instance is effective 
price_type_nameprice_typedescriptionMarketing text to be used to present the pricing to the user or customer e.g. 'Connection Fee', 'Monthly Line Rental', 'Deposit' 
price_prog_nameprice_prognameName for the pricing program 
currency_objidcurrencyobjidCurrency internal record number 

Joins:

Join FromJoin To
(offr_prod).offr_prod2price_qty(price_qty).price_qty2offr_prod
(price_qty).priced_part2mod_levelchild_mod_level(mod_level).priced_part2price_qty
(price_qty).context_part2mod_levelparent_mod_level(mod_level).context_part2price_qty
child_mod_level(mod_level).part_info2part_num(part_num).part_num2mod_level
(price_inst).price_inst2price_qty(price_qty).price_qty2price_inst
(price_inst).price_inst2price_prog(price_prog).price_prog2price_inst
(price_inst).price_inst2price_type(price_type).price_type2price_inst
(price_prog).price_prog2currency(currency).currency2price_prog
My Recent Objects
offr_prod_price_v