View Name:pc_options
View Number:5799
Group:Morder
Description:Lists the Options of a product. Used in product_options.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidprice_instobjidPrice instance internal record number 3 (UNIQUE)
part_num_objidpart_numobjidPart internal record number 
part_numberpart_numpart_numberPart number/name 
part_descpart_numdescriptionDescription of the product 
mod_level_objidchild_mod_level(mod_level)objidChild mod_level internal record number 
par_mod_level_objidparent_mod_level(mod_level)objidParent mod_level internal record number 
mod_levelchild_mod_level(mod_level)mod_levelName of part revision 
price_qty_objidprice_qtyobjidPrice_qty internal record number 
priceprice_instpricePrice for a given product 
price_inst_eff_dtprice_insteffective_dateDate the price instance becomes effective 
price_inst_exp_dtprice_instexpire_dateLast date the price instance is effective 
referenceprice_instis_referenceIndicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced 
rate_descriptionprice_instrate_descriptionString value of price amount 
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_type_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' 
currency_objidcurrencyobjidCurrency internal record number 
currency_symbolcurrencysymbolSymbol for the currency; e.g., $ for US dollar 

Joins:

Join FromJoin To
child_mod_level(mod_level).part_info2part_num(part_num).part_num2mod_level
(price_qty).priced_part2mod_levelchild_mod_level(mod_level).priced_part2price_qty
(price_inst).price_inst2price_qty(price_qty).price_qty2price_inst
(price_qty).context_part2mod_levelparent_mod_level(mod_level).context_part2price_qty
(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
pc_options