View Name:offr_price_view
View Number:6041
Group:Morder
Description:Used by indirect offer pricing table . Additional Pricing to be applied to other products if this product is selected) of screen ID 122023. Used in offering_pricing.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidthis_price_inst(price_inst)objidPrice instance internal record number 3 (UNIQUE)
is_directoffr_priceis_directIndicates 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 
pricethis_price_inst(price_inst)pricePrice for a given product 
rate_descriptionthis_price_inst(price_inst)rate_descriptionString value of price amount 
is_referencethis_price_inst(price_inst)is_referenceIndicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced 
effective_datethis_price_inst(price_inst)effective_dateDate the price instance becomes effective 
expire_datethis_price_inst(price_inst)expire_dateLast date the price instance is effective 
type_nameprice_typedescriptionMarketing text to be used to present the pricing to the user or customer e.g. 'Connection Fee', 'Monthly Line Rental', 'Deposit' 
prog_nameprice_prognameDescription of the pricing program 
offr_prod_objidoffr_prodobjidOffering product internal record number 
offr_price_nameoffr_pricenameReference name of offering pricing. Typically used for shared indirect pricing 
base_objidbase_price_inst(price_inst)objidBase_price_inst internal record number 
offr_price_objidoffr_priceobjidOffr_price internal record number 
price_inst_price_typethis_price_inst(price_inst)price_typeType of value in the price field; i.e., 0=currency amount, 1=percent of parent from price_qty, 2=percent of child 
type_stringthis_price_inst(price_inst)type_stringTranslates price_type 
is_offering_contextoffr_price_roleis_offering_contextIndicate that the usage of the price is for just an offering; 1=Yes, 0=No;Default = 0 
is_group_contextoffr_price_roleis_offering_group_contextIndicates that the usage of the price is for a common offering group; 1=Yes, 0=No;Default = 0 
is_framework_contextoffr_price_roleis_framework_contextIndicates that the usage of the price is for a framework agreement; 1=Yes, 0=No;Default = 0 

Joins:

Join FromJoin To
(offr_price_role).offr_price_role2offr_price(offr_price).offr_price2offer_price_role
(offr_price_role).offr_price_role2offr_prod(offr_prod).offr_prod2offr_price_role
this_price_inst(price_inst).price_inst2offr_price(offr_price).offr_price2price_inst
this_price_inst(price_inst).price_inst2price_type(price_type).price_type2price_inst
this_price_inst(price_inst).price_inst2price_prog(price_prog).price_prog2price_inst
this_price_inst(price_inst).override2price_instbase_price_inst(price_inst).price_inst2price_inst
My Recent Objects
offr_price_view