Table Schema: mf_returns

This topic describes the columns in the mf_returns table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
return_guid uniqueidentifier 1 0 1   1  
company_guid uniqueidentifier 0 0 2   0 mf_companies.company_guid
site_guid uniqueidentifier 0 1 3   0 mf_sites.site_guid
customer_guid uniqueidentifier 0 1 4   0  
localization_guid uniqueidentifier 0 1 5   0  
shipping_method_id int 0 1 6   0 mf_shipping_methods.shipping_method_id
iso_culture_cd varchar (15) 0 1 7   0 mf_iso_cultures.iso_culture_cd
iso_currency_cd char (3) 0 1 8   0 mf_iso_currencies.iso_currency_cd
return_id varchar (50) 0 1 9   0  
return_attention varchar (255) 0 1 10   0  
return_company_name varchar (255) 0 1 11   0  
return_address varchar (80) 0 1 12   0  
return_address2 varchar (80) 0 1 13   0  
return_address3 varchar (80) 0 1 14   0  
return_city varchar (50) 0 1 15   0  
return_state_id smallint 0 1 16   0  
return_country_region_name nvarchar (50) 0 1 17   0  
return_postal_code varchar (50) 0 1 18   0  
return_country_id smallint 0 1 19   0  
return_track varchar (255) 0 1 20   0  
return_tag varchar (50) 0 1 21   0  
return_received tinyint 0 0 22   0  
return_credited tinyint 0 0 23   0  
return_void tinyint 0 0 24   0  
return_flag tinyint 0 0 25   0  
return_alert tinyint 0 0 26   0  
return_visible tinyint 0 0 27   0  
return_new tinyint 0 0 28   0  
return_approved tinyint 0 0 29   0  
return_suspended tinyint 0 0 30   0  
return_locked tinyint 0 0 31   0  
return_closed tinyint 0 0 32   0  
return_filed tinyint 0 0 33   0  
lu_dt datetime 0 0 34   0  
cr_dt datetime 0 0 35   0  
lu_guid uniqueidentifier 0 1 36   0  
cr_guid uniqueidentifier 0 1 37   0  
return_scrub_scheduled_date datetime 0 1 40   0  
return_scrub_completed_date datetime 0 1 41   0  

Return to index of tables