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