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

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.