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 |