Table Schema: mf

This topic describes the columns in the mf_customers 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	Comment	Reference Count	Reference To
customer_guid	uniqueidentifier	1	0	1	Primary Key	18
company_guid	uniqueidentifier	0	0	2	Company-F-mf_companies	0	mf_companies.company_guid
customer_handler_guid	uniqueidentifier	0	1	3		0	mf_customer_handlers.customer_handler_guid
parent_guid	uniqueidentifier	0	1	4	Organization-F-mf_customers	0
organization_guid	uniqueidentifier	0	1	5	No longer used	0
item_price_level_guid	uniqueidentifier	0	1	6	Default Price Level-F-mf_item_price_levels	0	mf_item_price_levels.item_price_level_guid
term_guid	uniqueidentifier	0	1	7	Terms - F-mf_terms	0	mf_terms.term_guid
customer_code_guid	uniqueidentifier	0	1	8		0	mf_object_codes.code_guid
localization_guid	uniqueidentifier	0	1	9		0
iso_culture_cd	varchar (15)	0	1	10		0	mf_iso_cultures.iso_culture_cd
customer_type_id	smallint	0	0	11	Customer type-F-mf_customer_types	0	mf_customer_types.customer_type_id
customer_state_id	smallint	0	1	12	State-F-mf_states	0	mf_country_regions.country_region_id
customer_sstate_id	smallint	0	1	13	Ship state-F-mf_states	0	mf_country_regions.country_region_id
customer_country_id	smallint	0	1	14	Country-F-mf_countries	0	mf_countries.country_id
customer_scountry_id	smallint	0	1	15	Ship country-F-mf_countries	0	mf_countries.country_id
customer_shipping_method_id	int	0	1	16	Default shipping method-F-mf_shipping_methods	0	mf_shipping_methods.shipping_method_id
customer_username	varchar (50)	0	1	17	User name for web access	0
customer_password	varchar (200)	0	1	18	password for web access	0
customer_cd	varchar (50)	0	1	19	Code used for uniquely identifying a customer	0
customer_name	varchar (255)	0	1	20	Name	0
customer_first_name	varchar (255)	0	1	21	First name	0
customer_middle_name	varchar (255)	0	1	22	Middle name	0
customer_last_name	varchar (255)	0	1	23	Last name	0
customer_title	varchar (30)	0	1	24	Title	0
customer_attention	varchar (255)	0	1	25	Attention	0
customer_company_name	varchar (255)	0	1	26	Customer company name	0
customer_address	varchar (80)	0	1	27	Address	0
customer_address2	varchar (80)	0	1	28	Address line 2	0
customer_address3	varchar (80)	0	1	29	Address line 3	0
customer_city	varchar (50)	0	1	30	City	0
customer_postal_code	varchar (50)	0	1	31	Postal code	0
customer_country_region_name	nvarchar (50)	0	1	32		0
customer_sattention	varchar (255)	0	1	33	Ship attention	0
customer_scompany_name	varchar (255)	0	1	34	Ship company name	0
customer_saddress	varchar (80)	0	1	35	Ship address	0
customer_saddress2	varchar (80)	0	1	36	Ship address line 2	0
customer_saddress3	varchar (80)	0	1	37	Ship address line 3	0
customer_scity	varchar (50)	0	1	38	Ship city	0
customer_spostal_code	varchar (50)	0	1	39	Ship postal code	0
customer_scountry_region_name	nvarchar (50)	0	1	40		0
customer_contact	varchar (50)	0	1	41	Contact name	0
customer_alt_contact	varchar (50)	0	1	42	Alternate contact name	0
customer_phone	varchar (25)	0	1	43	Phone	0
customer_sphone	varchar (25)	0	1	44		0
customer_alt_phone	varchar (25)	0	1	45	Alternate phone	0
customer_phone_work	varchar (25)	0	1	46	Work phone	0
customer_alt_phone_work	varchar (25)	0	1	47	Alternate work phone	0
customer_fax	varchar (25)	0	1	48	Fax	0
customer_cell	varchar (25)	0	1	49	Cell phone number	0
customer_email	varchar (80)	0	1	50	Email	0
customer_semail	varchar (80)	0	1	51	Email	0
customer_alt_email	varchar (80)	0	1	52	Alternate email	0
customer_tax_id	varchar (50)	0	1	53	Tax Id	0
customer_tax_exempt	tinyint	0	0	54	Tax exempt	0
customer_notes	varchar (1000)	0	1	55	Notes	0
customer_credit_limit	money	0	1	56	Credit limit	0
customer_price_multiplier	money	0	1	57	Price Multiplier	0
customer_no_backorders	tinyint	0	0	58	If set customers would not accept back orders	0
customer_email_info	tinyint	0	0	59		0
customer_alert	tinyint	0	0	60	If set indicates that the customer has been alerted by the business process.	0
customer_visible	tinyint	0	0	61	Status flag- if set indicates that the customer is visible in the UI	0
customer_new	tinyint	0	0	62	Status flag- if set indicates that the customer is new and has been just entered into the system	0
customer_approved	tinyint	0	0	63	Workflow flag- if set indicates that the customer is approved and avialble for sale	0
customer_suspended	tinyint	0	0	64	Status flag- if set indicates that the record is suspended and cannot participate in transactions	0
customer_locked	tinyint	0	0	65	Status flag- if set indicates that the record is locked and cannot be edited	0
customer_closed	tinyint	0	0	66	Workflow flag- if set indicates that the record is closed	0
customer_filed	tinyint	0	0	67	Workflow flag- if set indicates that the record is filed	0
customer_flag	tinyint	0	0	68	Used by UI as a way to assign records to different colored flags.-F-mf_flags	0
lu_dt	datetime	0	0	69	Record update date	0
cr_dt	datetime	0	0	70	Record created date	0
lu_guid	uniqueidentifier	0	1	71	Record updated by-F-mf_users	0
cr_guid	uniqueidentifier	0	1	72	Record created by-F-mf_users	0
customer_scrub_scheduled_date	datetime	0	1	75		0
customer_scrub_completed_date	datetime	0	1	76		0
customer_scrub_failed	tinyint	0	1	77		0

Return to index of tables

Table Schema: mf_customers