Table Schema: mf_return_orders

This topic describes the columns in the mf_return_orders table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
return_order_guid uniqueidentifier 1 0 1   7 mf_return_orders.return_order_guid
company_guid uniqueidentifier 0 0 2   0 mf_companies.company_guid
catalog_guid uniqueidentifier 0 1 3   0 mf_catalogs.catalog_guid
site_guid uniqueidentifier 0 1 4   0 mf_sites.site_guid
order_guid uniqueidentifier 0 0 5   0 mf_orders.order_guid
customer_guid uniqueidentifier 0 1 6   0 mf_customers.customer_guid
user_guid uniqueidentifier 0 1 7   0  
return_order_code_guid uniqueidentifier 0 1 8   0  
localization_guid uniqueidentifier 0 1 9   0  
iso_culture_cd varchar (15) 0 1 10   0 mf_iso_cultures.iso_culture_cd
shipping_method_id int 0 1 11   0 mf_shipping_methods.shipping_method_id
iso_currency_cd char (3) 0 1 12   0 mf_iso_currencies.iso_currency_cd
taxation_policy_type_id smallint 0 0 13   0 mf_taxation_policy_types.taxation_policy_type_id
return_order_type_id smallint 0 1 14   0 mf_return_order_types.return_order_type_id
return_order_id varchar (50) 0 1 15   0  
return_order_reference_id varchar (50) 0 1 16   0  
return_order_date datetime 0 0 17   0  
return_order_shipped_date datetime 0 1 18   0  
return_order_attention varchar (255) 0 1 19   0  
return_order_company_name varchar (255) 0 1 20   0  
return_order_address varchar (80) 0 1 21   0  
return_order_address2 varchar (80) 0 1 22   0  
return_order_address3 varchar (80) 0 1 23   0  
return_order_city varchar (50) 0 1 24   0  
return_order_country_region_id smallint 0 1 25   0  
return_order_country_region_name nvarchar (50) 0 1 26   0  
return_order_country_id smallint 0 1 27   0  
return_order_postal_code varchar (50) 0 1 28   0  
return_order_phone varchar (25) 0 1 29   0  
return_order_email varchar (80) 0 1 30   0  
return_order_instructions varchar (1000) 0 1 31   0  
return_order_account varchar (50) 0 1 32   0  
return_order_replacement_ship_attention varchar (255) 0 1 33   0  
return_order_replacement_ship_company_name varchar (255) 0 1 34   0  
return_order_replacement_ship_address varchar (80) 0 1 35   0  
return_order_replacement_ship_address2 varchar (80) 0 1 36   0  
return_order_replacement_ship_address3 varchar (80) 0 1 37   0  
return_order_replacement_ship_city varchar (50) 0 1 38   0  
return_order_replacement_ship_postal_code varchar (50) 0 1 39   0  
return_order_replacement_ship_country_id smallint 0 1 40   0  
return_order_replacement_ship_country_region_id smallint 0 1 41   0  
return_order_replacement_ship_country_region_name nvarchar (50) 0 1 42   0  
return_order_replacement_ship_phone varchar (25) 0 1 43   0  
return_order_replacement_ship_email varchar (80) 0 1 44   0  
return_order_replacement_subtotal money 0 0 45   0  
return_order_replacement_subtotal_tax money 0 0 46   0  
return_order_replacement_tax money 0 0 47   0  
return_order_replacement_shipping money 0 0 48   0  
return_order_replacement_shipping_tax money 0 0 49   0  
return_order_replacement_handling money 0 0 50   0  
return_order_replacement_handling_tax money 0 0 51   0  
return_order_replacement_insurance money 0 0 52   0  
return_order_replacement_discount money 0 0 53   0  
return_order_replacement_price_adjustment money 0 0 54   0  
return_order_replacement_price_adjustment_tax money 0 0 55   0  
return_order_replacement_total money 0 0 56   0  
return_order_replacement_ordered tinyint 0 0 57   0  
return_order_subtotal money 0 0 58   0  
return_order_subtotal_tax money 0 0 59   0  
return_order_tax money 0 0 60   0  
return_order_shipping money 0 0 61   0  
return_order_shipping_tax money 0 0 62   0  
return_order_shipping_actual money 0 1 63   0  
return_order_handling money 0 0 64   0  
return_order_handling_tax money 0 0 65   0  
return_order_insurance money 0 0 66   0  
return_order_discount money 0 0 67   0  
return_order_price_adjustment money 0 0 68   0  
return_order_price_adjustment_tax money 0 0 69   0  
return_order_total money 0 0 70   0  
return_order_total_fees money 0 0 71   0  
return_order_total_weight numeric (9,2) 0 1 72   0  
return_order_balance_due money 0 0 73   0  
return_order_balance_due_invoices money 0 0 74   0  
return_order_complete tinyint 0 0 75   0  
return_order_received tinyint 0 0 76   0  
return_order_fulfilled tinyint 0 0 77   0  
return_order_credited tinyint 0 0 78   0  
return_order_credited_locked tinyint 0 0 79   0  
return_order_void tinyint 0 0 80   0  
return_order_alert tinyint 0 0 81   0  
return_order_visible tinyint 0 0 82   0  
return_order_new tinyint 0 0 83   0  
return_order_approved tinyint 0 0 84   0  
return_order_suspended tinyint 0 0 85   0  
return_order_locked tinyint 0 0 86   0  
return_order_closed tinyint 0 0 87   0  
return_order_filed tinyint 0 0 88   0  
return_order_flag tinyint 0 0 89   0  
lu_dt datetime 0 0 90   0  
cr_dt datetime 0 0 91   0  
lu_guid uniqueidentifier 0 1 92   0  
cr_guid uniqueidentifier 0 1 93   0  
return_order_replacement_product_tax money 0 0 94   0  
return_order_product_tax money 0 0 95   0  
return_order_tax_converted bit 0 0 96   0  
return_order_replacement_tax_converted bit 0 0 97   0  
return_order_discount_converted bit 0 0 98   0  
return_order_scrub_scheduled_date datetime 0 1 101   0  
return_order_scrub_completed_date datetime 0 1 102   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.