View Name:c_options
View Number:5069
Group:Sales Mgr
Description:Used by forms Contract (9133), Contract<ID> (9134), More Info (9135), Line Items (9136), Schedules (9140), Payment Options (9141), Select (S) Installed Products (9145), S Installed Part (9146) and others
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
part_num_objidpart_numobjidPart num internal record number 
part_numberpart_numpart_numberPart number/name 
part_descpart_numdescriptionDescription of the product 
part_domainpart_numdomainName of the domain for the part num. See object prt_domain 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
mod_level_objidchild_mod_level(mod_level)objidMod 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 the parent part revision 
activechild_mod_level(mod_level)activeActive/inactive/obsolete 
price_qty_objidprice_qtyobjidPrice quantity internal record number 
priced_qtyprice_qtypriced_qtyThe quantity of the part being quoted 
fixed_amtprice_instpricePrice for a given product or the calculated price as fetched percentage * the price 
percentageprice_instpricePrice for a given product or the calculated price as fetched percentage of the price 
priceprice_instpricePrice for a given product or the calculated price as fetched percentage of 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 
unit_measurepart_numunit_measureunit of measure 
objidprice_instobjidPrice_inst internal record number 3 (UNIQUE)
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 
part_linepart_numlineMarketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm 
part_familypart_numfamilyMarketing product family the part belongs to; new user-defined pop up replaces relation to gbst_elm 
part_typepart_numpart_typeUser-defined pop up to denote a part type separate from the domain 
part_statuspart_numactiveActive/inactive/obsolete 
p_qty_typeprice_qtyp_qty_typeType of price_qty; 0=is parent or standalone; 1=is child 
is_sppt_progpart_numis_sppt_progIndicates application category of the part: i.e., 0=physical part, 1=service part, 2=product literature 
price_prog_objidprice_progobjidPrice program internal record number 
currency_objidcurrencyobjidCurrency internal record number 
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 
prog_eff_dtprice_progeffective_dateDate the price program becomes effective 
prog_exp_dtprice_progexpire_dateLast date the price program is effective 
mod_eff_dtchild_mod_level(mod_level)eff_dateThe date the support program version becomes effective 
mod_exp_dtchild_mod_level(mod_level)end_dateThe date the support program version expires 
price_type_strprice_insttype_stringTranslates price_type 
sn_trackpart_numsn_trackTrack part for serialization; i.e., 0=by quantity, 1=by serial number 
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 
currency_namecurrencynameName for the currency 

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_prog).price_prog2currency(currency).currency2price_prog
My Recent Objects
c_options