View Name:price_mod_view
View Number:5085
Group:Sales Mgr
Description:Reserved; not used
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
part_modmod_levelobjidMod Level internal record number 40
part_numpart_numobjidPart number internal record number 
price_instprice_instobjidPrice instance internal record number 3 (UNIQUE)
price_progprice_progobjidPrice program internal record number 
nameprice_prognameName of the price program 2
priceprice_instpricePrice from the price instance 
descriptionprice_progdescriptionDescription from the price program 
typeprice_progtypeType of the price program 
displayprice_progdisplayIf true, display pricing program in list box on parts look-up form 
eff_dateprice_insteffective_dateEffective date from the price instance 
exp_dateprice_instexpire_dateExpiration date from the price instance 
prog_eff_dateprice_progeffective_dateEffective date from the price program 
prog_exp_dateprice_progexpire_dateExpiration date from the price program 

Joins:

Join FromJoin To
(price_inst).price_inst2price_prog(price_prog).price_prog2price_inst
(price_inst).price_inst2part_num(part_num).part_num2price_inst
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
price_mod_view