Table Schema: mf_items

This topic describes the columns in the mf_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
item_guid uniqueidentifier 1 0 1 Primary Key 28  
company_guid uniqueidentifier 0 1 2 Company-F-mf_companies 0 mf_companies.company_guid
site_guid uniqueidentifier 0 1 3 Site-F-mf_sites 0  
addin_guid uniqueidentifier 0 1 4   0  
reference_guid uniqueidentifier 0 1 5   0  
item_handler_guid uniqueidentifier 0 1 6   0 mf_item_handlers.item_handler_guid
allocation_partition_guid uniqueidentifier 0 1 7   0 mf_allocation_partitions.allocation_partition_guid
category_guid uniqueidentifier 0 1 8 Category-F-mf_categories 0  
master_guid uniqueidentifier 0 1 9 Master Item-F-mf_items 0 mf_items.item_guid
bin_guid uniqueidentifier 0 1 10 Bin-F-mf_bins 0  
item_code_guid uniqueidentifier 0 1 11   0  
item_state_id int 0 1 12 Item State-F-mf_item_states 0 mf_item_states.item_state_id
item_buyer_guid uniqueidentifier 0 1 13   0 mf_users.user_guid
item_type_id int 0 0 14 Item Type-F-mf_item_types 0 mf_item_types.item_type_id
item_sub_type_id int 0 1 15 Item sub type-F-mf_item_sub_types 0 mf_item_sub_types.item_sub_type_id
item_unit_id int 0 1 16 Unit Type-F-mf_item_units 0 mf_item_units.item_unit_id
item_cd varchar (50) 0 1 17 Item Code 0  
item_upc varchar (50) 0 1 18 Universal product Code 0  
item_ean varchar (256) 0 1 19 Universal product Code 0  
item_rfid varchar (50) 0 1 20 Radio Frequency Id 0  
item_label varchar (50) 0 1 21   0  
item_notes varchar (100) 0 1 22 Item Notes 0  
item_description varchar (3000) 0 1 23 Description about the item 0  
item_description_price varchar (55) 0 1 24   0  
item_description_title varchar (80) 0 1 25 Item title 0  
item_description_title_attributes varchar (55) 0 1 26 Item title 0  
item_description_short varchar (255) 0 1 27 Short description 0  
item_description_html text 0 1 28 HTML description of the item 0  
item_description_url varchar (255) 0 1 29 External URL to the description of the item. 0  
item_description_keywords varchar (1000) 0 1 30 Key words are used during searching for items. These should be separated by spaces 0  
item_seo_title varchar (255) 0 1 31   0  
item_seo_keywords varchar (1000) 0 1 32   0  
item_seo_description varchar (2000) 0 1 33   0  
item_quantity int 0 1 34 Quantity on order 0  
item_quantity_on_hand int 0 0 35 Quantity on hand 0  
item_quantity_on_hold int 0 0 36 Quantity on hold 0  
item_quantity_on_allocation int 0 0 37   0  
item_quantity_on_order int 0 0 38 Quantity on order 0  
item_quantity_backorder_authorizations int 0 0 39   0  
item_quantity_min int 0 1 40 Minimum quantity that can be ordered 0  
item_quantity_max int 0 1 41 Maximum quantity that can be ordered 0  
item_average_cost money 0 1 42 Average cost of an item 0  
item_purchase_price money 0 1 43 Purchase price 0  
item_wholesale_price money 0 1 44 Base Sale Price 0  
item_retail_price money 0 1 45 Retail price 0  
item_price_adjustment_value decimal (16,6) 0 1 46   0  
item_price_adjustment_calc_method_id smallint 0 1 47   0  
item_price_adjustment_description varchar (50) 0 1 48   0  
item_pieces_per_unit int 0 0 49 Pieces per unit. 0  
item_pieces_per_shipping_unit int 0 0 50 Pieces per shipping unit 0  
item_shipping_units int 0 0 51   0  
item_shipping_fixed_price money 0 1 52   0  
item_fulfillment_latency_days smallint 0 1 53   0  
item_weight numeric (9,4) 0 1 54 Item weight 0  
item_dimension_length numeric (5,2) 0 1 55 Item length 0  
item_dimension_width numeric (5,2) 0 1 56 Item width 0  
item_dimension_height numeric (5,2) 0 1 57 Item height 0  
item_order smallint 0 1 58   0  
item_location varchar (50) 0 1 59   0  
item_tag varchar (1000) 0 1 60   0  
item_rating tinyint 0 1 61   0  
item_hits int 0 0 62   0  
item_transaction_count int 0 0 63   0  
item_transaction_failures int 0 0 64   0  
item_featured bit 0 0 65 Indicates if the item is featured 0  
item_new_stock bit 0 0 66 Indicates whether the item is part of a new stock 0  
item_back_in_stock bit 0 0 67   0  
item_backordered bit 0 0 68 Indicates that the item is already backordered 0  
item_discontinued bit 0 0 69 Indicates if the item is discontinued. 0  
master_allow_child_catalog_override tinyint 0 0 70   0  
master_allow_child_category_override tinyint 0 0 71   0  
item_available tinyint 0 0 72   0  
item_available_date datetime 0 1 73   0  
item_promise_date datetime 0 1 74   0  
item_promise_fulfill_date datetime 0 1 75   0  
item_fulfill_date datetime 0 1 76   0  
item_track_inventory tinyint 0 0 77 if set then the allocation business rules are followed 0  
item_backorderable tinyint 0 0 78 Indicates that the item is backorderable if set 0  
item_backorderable_type_id smallint 0 1 79   0 mf_item_backorderable_types.item_backorderable_type_id
item_dropship tinyint 0 0 80 Indicates item as a dropship item if set 0  
item_separateship tinyint 0 0 81   0  
item_autosource tinyint 0 0 82   0  
item_taxable tinyint 0 0 83 Indicates that the item is taxable 0  
item_unique tinyint 0 0 84   0  
item_serialized tinyint 0 0 85 Indicates the item as a serialized item 0  
item_suppress_sale tinyint 0 0 86   0  
item_suppress_allocate tinyint 0 0 87   0  
item_alert tinyint 0 0 88 If set indicates that the item has been alerted by the business process. 0  
item_visible tinyint 0 0 89 Status flag- if set indicates that the item is visible in the UI 0  
item_new tinyint 0 0 90 Status flag- if set indicates that the item is new and has been just entered into the system 0  
item_approved tinyint 0 0 91 Workflow flag- if set indicates that the item is approved and avialble for sale 0  
item_suspended tinyint 0 0 92 Status flag- if set indicates that the item is locked and cannot participate in transactions 0  
item_locked tinyint 0 0 93 Status flag- if set indicates that the record is locked and cannot be edited 0  
item_closed tinyint 0 0 94 Workflow flag- if set indicates that the record is closed 0  
item_filed tinyint 0 0 95 Workflow flag- if set indicates that the record is filed 0  
item_flag tinyint 0 0 96 Used by UI as a way to assign records to different colored flags.-F-mf_flags 0  
lu_dt datetime 0 0 97 Record update date 0  
cr_dt datetime 0 0 98 Record created date 0  
lu_guid uniqueidentifier 0 1 99 Record updated by-F-mf_users 0  
cr_guid uniqueidentifier 0 1 100 Record created by-F-mf_users 0  
uploaded tinyint 0 1 101   0  
item_cash_price money 0 1 102   0  
item_quantity_on_hand_effective int 0 1 105   0  

Return to index of tables