View Name:price_inst_view
View Number:5788
Group:Morder
Description:Used to price at revision level by form RMA Request Details (502), More RMA Info (503), Part Request Detail (507), More (Part Request) Info (508), Repair Info (509) and Pricing (511). Used in product_prices.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
price_inst_objidprice_instobjidPrice instance internal record number 3 (UNIQUE)
priceprice_instpricePrice for a given product 
effective_dateprice_insteffective_datePrice instance effective date 
expire_dateprice_instexpire_datePrice instance expiry date 
price_prog_objidprice_progobjidPrice programme internal record number 
price_prog_nameprice_prognamePrice programme name 
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_qty_objidprice_qtyobjidPrice_qty internal record number 
mod_level_objidmod_levelobjidMod_level internal record number 
part_num_objidpart_numobjidPart num internal record number 
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_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 
currency_objidcurrencyobjidCurrency internal record number 

Joins:

Join FromJoin To
(price_inst).price_inst2price_prog(price_prog).price_prog2price_inst
(price_inst).price_inst2price_qty(price_qty).price_qty2price_inst
(price_qty).priced_part2mod_level(mod_level).priced_part2price_qty
(mod_level).part_info2part_num(part_num).part_num2mod_level
(price_inst).price_inst2price_type(price_type).price_type2price_inst
(price_prog).price_prog2currency(currency).currency2price_prog
My Recent Objects
price_inst_view