Table Schema: mf_item_price_points

This topic describes the columns in the mf_item_price_points table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
item_price_point_guid uniqueidentifier 1 0 1   0  
item_guid uniqueidentifier 0 0 2   0 mf_items.item_guid
item_price_level_guid uniqueidentifier 0 1 3   0 mf_item_price_levels.item_price_level_guid
item_price_point_type_id int 0 1 4   0 mf_item_price_point_type.item_price_point_type_id
item_price_point_calc_method int 0 0 5   0  
item_price_calc_method_id smallint 0 0 6   0  
item_price_calc_basis_id smallint 0 0 7   0  
item_price_point_quantity int 0 0 8   0  
item_price_point_value decimal (16,6) 0 1 9   0  
item_price_point_description varchar (50) 0 1 10   0  
item_price_point_tbd tinyint 0 0 11   0  
item_price_point_unitprice float 0 1 12   0  
item_price_point_discount float 0 1 13   0  
item_price_point_costplus float 0 1 14   0  
item_price_point_markup float 0 1 15   0  
lu_dt datetime 0 1 16   0  
cr_dt datetime 0 1 17   0  
lu_guid uniqueidentifier 0 1 18   0  
cr_guid uniqueidentifier 0 1 19   0  

Return to index of tables