View Name:c_price_srvc
View Number:5101
Group:Sales Mgr
Description:Used for pricing the services on forms Pricing (9153) and Pricing as Child (9166)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
part_num_objidpart_numobjidPart_num objid 
mod_level_objidparent_mod_level(mod_level)objidMod_level objid 
price_qty_objidprice_qtyobjidPrice_qty internal record number 
objidprice_instobjidPrice_inst internal record number 3 (UNIQUE)
price_prog_objidprice_progobjidPrice_prog internal record number 
part_numberpart_numpart_numberPartnumber/name 
part_descpart_numdescriptionDescription of the product 
part_domainpart_numdomainName of the domain for the partnum. See object prt_domain 
unit_measurepart_numunit_measureUnit of measure 
p_standalonepart_nump_standaloneIndicates whether the part MAY receive standalone pricing; i.e. 0=no, 1=yes, default=0 
p_as_parentpart_nump_as_parentIndicates whether the part MAY be priced with options under it; i.e. 0=no, 1=yes, default=0 
p_as_childpart_nump_as_childIndicates whether the part MAY be priced as an option; i.e. 0=no, 1=yes, default=0 
mod_levelparent_mod_level(mod_level)mod_levelName of the part revision 
activeparent_mod_level(mod_level)activeActive/inactive/obsolete 
priced_qtyprice_qtypriced_qtyThe quantity of the priced part being quoted 
p_qty_typeprice_qtyp_qty_typeType of price_qty; 0=is parent or standalone; 1=is child 
fixed_amtprice_instpricePrice for a given product or the calculated price as fetched percentage*the price 
percentageprice_instpricePercentage used in price calculations 
priceprice_instpricePrice for a given product or the calculated price as fetched percentage*the price 
price_inst_eff_dtprice_insteffective_dateDate the price instance becomes effective 
price_inst_exp_dtprice_instexpire_dateLast date the price instance is effective 
price_typeprice_instprice_typeLast date the price instance is effective 
is_sppt_progpart_numis_sppt_progIndicates application category of the part: i.e., 0=physical part, 1=service part, 2=product literature 
price_prog_nameprice_prognameName for the pricing program 
price_prog_dspccprice_progdisplayccIf true, display pricing program in Clear Contracts; i.e., 0=false, 1=true. Default=0 
child_mod_objidchild_mod_level(mod_level)objidChild mod_level internal record number 
prog_eff_dtprice_progeffective_dateDate the price program becomes effective 
prog_exp_dtprice_progexpire_dateLast date the price program is effective 
currency_objidcurrencyobjidcurrency internal record number 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
price_type_strprice_insttype_stringTranslates price_type 
sub_scalecurrencysub_scaleGives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 

Joins:

Join FromJoin To
(price_inst).price_inst2price_qty(price_qty).price_qty2price_inst
(price_qty).context_part2mod_levelparent_mod_level(mod_level).context_part2price_qty
parent_mod_level(mod_level).part_info2part_num(part_num).part_num2mod_level
(price_inst).price_inst2price_prog(price_prog).price_prog2price_inst
(price_qty).priced_part2mod_levelchild_mod_level(mod_level).priced_part2price_qty
(price_prog).price_prog2currency(currency).currency2price_prog
My Recent Objects
c_price_srvc