Table Schema: mf_customers

This topic describes the columns in the mf_customers table.

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