View Name:f_offr_price_list_v
View Number:5829
Group:Morder
Description:Lists the prices of products belonging to an offer. Used in offering_pricing.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidfake_baseobjidPrice instance internal record number 3 (UNIQUE)
offr_prod_objidfake_basenumber_fieldOffering product internal record number 
price_qty_objidfake_basenumber_fieldPrice_qty internal record number 
pricefake_basecurrency_fieldPrice for a given product 
effective_datefake_basedate_fieldDate the price instance becomes effective 
expire_datefake_basedate_fieldLast date the price instance is effective 
price_type_namefake_basetext_fieldPricing type used to decide how to handle the charge. 1=one time immediate, 2=one time bill, 3=recurring bill 
price_prog_namefake_basetext_fieldName for the pricing program 
currency_objidcurrencyobjidCurrency internal record number 
child_objidfake_basenumber_fieldPrice instance internal record number 
child_pricefake_basetext_fieldPrice for a given product 
child_price_typefake_baseboolean_fieldPrice type for child price 
child_type_stringfake_basetext_fieldPrice type string for child price 
offr_price_namefake_basetext_fieldReference name of offering pricing. Typically used for shared indirect pricing 
offr_price_objidfake_basenumber_fieldReference objid of offering pricing. Typically used for shared indirect pricing 
is_overridefake_baseboolean_fieldIndicates that this price is ovverideb by another price. 1=overriden, 0=not overriden 
agr_offr_price_objidfake_basenumber_fieldReference objid of offering pricing. Typically used for shared indirect pricing 
agr_child_objidfake_basenumber_fieldPrice instance internal record number 
agr_child_pricefake_basetext_fieldPrice for a given product 
agr_child_type_stringfake_basetext_fieldPrice type string for child price 
agr_child_price_typefake_baseboolean_fieldPrice type for agr child price 

Joins:

Join FromJoin To
(fake_join).fake_join2fake_base(fake_base).fake_base2fake_join
My Recent Objects
f_offr_price_list_v