Table Schema: mf

This topic describes the columns in the mf_vendors 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 Count	Reference To
vendor_guid	uniqueidentifier	1	0	1	3
company_guid	uniqueidentifier	0	0	2	0	mf_companies.company_guid
vendor_code_guid	uniqueidentifier	0	1	3	0
vendor_state_id	smallint	0	1	4	0	mf_country_regions.country_region_id
vendor_country_id	smallint	0	1	5	0	mf_countries.country_id
vendor_sstate_id	smallint	0	1	6	0	mf_country_regions.country_region_id
vendor_scountry_id	smallint	0	1	7	0	mf_countries.country_id
vendor_cd	varchar (50)	0	1	8	0
vendor_name	varchar (255)	0	1	9	0
vendor_first_name	varchar (255)	0	1	10	0
vendor_last_name	varchar (255)	0	1	11	0
vendor_title	varchar (30)	0	1	12	0
vendor_attention	varchar (255)	0	1	13	0
vendor_company_name	varchar (255)	0	1	14	0
vendor_address	varchar (50)	0	1	15	0
vendor_address2	varchar (50)	0	1	16	0
vendor_address3	varchar (50)	0	1	17	0
vendor_city	varchar (30)	0	1	18	0
vendor_postal_code	varchar (50)	0	1	19	0
vendor_country_region_name	nvarchar (50)	0	1	20	0
vendor_sattention	varchar (255)	0	1	21	0
vendor_scompany_name	varchar (255)	0	1	22	0
vendor_saddress	varchar (50)	0	1	23	0
vendor_saddress2	varchar (50)	0	1	24	0
vendor_saddress3	varchar (50)	0	1	25	0
vendor_scity	varchar (30)	0	1	26	0
vendor_spostal_code	varchar (50)	0	1	27	0
vendor_scountry_region_name	nvarchar (50)	0	1	28	0
vendor_contact	varchar (50)	0	1	29	0
vendor_alt_contact	varchar (50)	0	1	30	0
vendor_phone	varchar (20)	0	1	31	0
vendor_alt_phone	varchar (20)	0	1	32	0
vendor_fax	varchar (20)	0	1	33	0
vendor_cell	varchar (20)	0	1	34	0
vendor_email	varchar (80)	0	1	35	0
vendor_alt_email	varchar (80)	0	1	36	0
vendor_account_number	varchar (50)	0	1	37	0
vendor_tax_id	varchar (50)	0	1	38	0
vendor_credit_limit	money	0	1	39	0
vendor_notes	varchar (1000)	0	1	40	0
vendor_email_info	tinyint	0	0	41	0
vendor_alert	tinyint	0	0	42	0
vendor_visible	tinyint	0	0	43	0
vendor_new	tinyint	0	0	44	0
vendor_approved	tinyint	0	0	45	0
vendor_suspended	tinyint	0	0	46	0
vendor_locked	tinyint	0	0	47	0
vendor_closed	tinyint	0	0	48	0
vendor_filed	tinyint	0	0	49	0
vendor_flag	tinyint	0	0	50	0
lu_dt	datetime	0	0	51	0
cr_dt	datetime	0	0	52	0
lu_guid	uniqueidentifier	0	1	53	0
cr_guid	uniqueidentifier	0	1	54	0

Return to index of tables

Table Schema: mf_vendors