View Name:c_pct_price
View Number:5068
Group:Sales Mgr
Description:Used in part pricing by form Select Generic (9148) Services (NOT USED)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
parent_mod_level_objidparent_mod_level(mod_level)objidMod level internal record number of parent part 
price_qty_objidcon_price_qty(price_qty)objidInternal record number of the priced price_qty 
ref_price_qty_objidref_price_qty(price_qty)objidInternal record number of the reference price quantify 
price_inst_objidcon_price_inst(price_inst)objidInternal record number of the percentage price object 3 (UNIQUE)
ref_price_inst_objidref_price_inst(price_inst)objidInternal record number of the reference price used for percentage pricing 
ref_price_priceref_price_inst(price_inst)priceThe reference price used in calculating the percentage price 
ref_price_effref_price_inst(price_inst)effective_dateThe reference price effective date 
ref_price_expref_price_inst(price_inst)expire_dateThe reference price expire date 
price_prog_objidprice_progobjidPrice program internal record number 
ref_child_mod_level_objidref_child_mod_level(mod_level)objidInternal record number 

Joins:

Join FromJoin To
con_price_qty(price_qty).context_part2mod_levelparent_mod_level(mod_level).context_part2price_qty
con_price_inst(price_inst).price_inst2price_qtycon_price_qty(price_qty).price_qty2price_inst
con_price_inst(price_inst).ref_price2price_qtyref_price_qty(price_qty).ref_price2price_inst
ref_price_inst(price_inst).price_inst2price_qtyref_price_qty(price_qty).price_qty2price_inst
ref_price_inst(price_inst).price_inst2price_prog(price_prog).price_prog2price_inst
ref_price_qty(price_qty).priced_part2mod_levelref_child_mod_level(mod_level).priced_part2price_qty
My Recent Objects
c_pct_price