Table Schema: mf_ext

This topic describes the columns in the mf_ext_items table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	Reference To
ext_item_guid	uniqueidentifier	1	0	1
company_guid	uniqueidentifier	0	0	2
vendor_guid	uniqueidentifier	0	1	3	mf_ext_item_catalogs.vendor_guid
ext_item_catalog_cd	nvarchar (100)	0	1	4	mf_ext_item_catalogs.ext_item_catalog_cd
ext_item_cd	nvarchar (50)	0	0	5
ext_item_title	nvarchar (100)	0	1	6
ext_item_description	nvarchar (1000)	0	1	7
ext_item_price	money	0	1	8
ext_item_cost	money	0	1	9
ext_item_msrp	money	0	1	10
ext_item_quantity_available	int	0	1	11
ext_item_x1	nvarchar (255)	0	1	12
ext_item_x2	nvarchar (255)	0	1	13
ext_item_x3	nvarchar (255)	0	1	14
ext_item_x4	nvarchar (255)	0	1	15
ext_item_x5	nvarchar (255)	0	1	16
ext_item_approved	bit	0	1	17
ext_item_visible	bit	0	1	18
ext_item_closed	bit	0	1	19

Table Schema: mf_ext_items