Table Schema: mf_vendors

This topic describes the columns in the mf_vendors table.

Column Name Data Type Primary Key Is Nullable Column ID Comment 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

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.