View Name:price_num
View Number:403
Group:Logistics
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)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_price_num
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
part_numpart_numobjidPart number internal record number 
objidprice_instobjidPrice instance internal record number 3 (UNIQUE)
price_progprice_progobjidPrice program internal record number 
nameprice_prognameName of the price program 2
priceprice_instpricePrice 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 thhe price instance 
prog_eff_dateprice_progeffective_dateEffective date from the price program 
prog_exp_dateprice_progexpire_dateExpiration date from the price program 
part_modmod_levelobjidMod_level 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
My Recent Objects
price_num      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user