Table Name:price_qty
Table Number:5054
Group:Sales Mgr
Description:Assigns a part both a quantity and an 'installed-in' or 'quoted-under' part for pricing
Flags: 
Baseline/Custom:Baseline
select * from table_price_qty
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
objidLONGint3  DIRECT Internal record number Search (18)
p_qty_typeLONGtinyint  0 DIRECT Type of price_qty; 0=is a standalone part, 1=is a parent or child part Search (4)
priced_qtyLONGint  1 DIRECT The quantity of the priced part being quoted. Default=1 Search (8)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
priced_part2mod_levelMTOmod_levelpriced_part2price_qtyPart to which the quantity applies   Search (21)
context_part2mod_levelMTOmod_levelcontext_part2price_qtyPart the priced part is quoted under   Search (12)
price_qty2offr_prodOTMoffr_prodoffr_prod2price_qtyOfferings products/options which the quantity applies    
price_qty2price_instOTMprice_instprice_inst2price_qtyPrices of the priced part    
ref_price2price_instOTMprice_instref_price2price_qtyPrices using the price quantity in percentage calculation    
priced2vendor_partMTOvendor_partvendor_part2price_qtyRelated vendor part   Search (1)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
price_qty_indpriced_part2mod_level:context_part2mod_level:priced_qty:priced2vendor_partUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_priced_part2mod_levelpriced_part2mod_level, context_part2mod_levelnonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
price_qty_indpriced_part2mod_level, context_part2mod_level, priced_qty, priced2vendor_partnonclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
5068c_pct_price mod_level, price_inst, price_prog, price_qty
5069c_options currency, mod_level, part_num, price_inst, price_prog, price_qty
5101c_price_srvc currency, mod_level, part_num, price_inst, price_prog, price_qty
5277view_vpt_price mod_level, price_inst, price_prog, price_qty, site, vendor_part
5402N_Products mod_level, N_CategoryTrees, N_Product, N_Templates, part_num, price_inst, price_prog, price_qty
5429N_Options mod_level, N_CategoryTrees, N_Option, N_Templates, part_num, price_inst, price_prog, price_qty
5788price_inst_view currency, mod_level, part_num, price_inst, price_prog, price_qty, price_type
5791offr_prod_v mod_level, offering, offering_grp, offr_prod, part_num, price_qty
5792offr_prod_price_v currency, mod_level, offr_prod, part_num, price_inst, price_prog, price_qty, price_type
5793part_in_offr_v mod_level, offering, price_qty, user
5799pc_options currency, mod_level, part_num, price_inst, price_prog, price_qty, price_type
5800offr_search_prod_v mod_level, part_num, price_qty
5807order_line_v contract, mod_level, offr_prod, order_action, order_line, price_qty
5856order_line_parts_v contract, mod_level, offr_prod, order_action, order_line, part_num, price_qty
5993offr_prod_view mod_level, offering, offering_grp, offr_grp_role, offr_prod, part_num, price_qty
5994part_in_offr_view mod_level, offering, price_qty, user
6010cmn_grp_ofr_prd_view mod_level, offering_grp, offr_grp_grp_role, offr_prod, part_num, price_qty
6011cmn_ofr_prd_view mod_level, offering_grp, offr_prod, part_num, price_qty
6032order_line_view contract, mod_level, offr_prod, order_action, order_line, part_num, price_qty
6065offr_search_prod_view mod_level, part_num, price_qty
My Recent Objects
price_qty      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user