Table Schema: mf_order_ship_addresses

This topic describes the columns in the mf_order_ship_addresses table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
order_ship_address_guid uniqueidentifier 1 0 1   2  
order_guid uniqueidentifier 0 0 2 Primary Key 0 mf_orders.order_guid
order_ship_address_state_id smallint 0 1 3 Ship Address state-F-mf_states 0  
order_ship_address_country_id smallint 0 1 4 Ship Address country-F-mf_countries 0  
order_ship_address_attention varchar (255) 0 1 5 Shipping attention 0  
order_ship_address_company_name varchar (255) 0 1 6 Shipping company name 0  
order_ship_address_address varchar (80) 0 1 7 Shipping address 0  
order_ship_address_address2 varchar (80) 0 1 8 Shipping address line 2 0  
order_ship_address_address3 varchar (80) 0 1 9 Shipping address line 3 0  
order_ship_address_city varchar (50) 0 1 10 Shipping address city 0  
order_ship_address_postal_code varchar (50) 0 1 11 Shipping address postal code 0  
order_ship_address_country_region_name nvarchar (50) 0 1 12   0  
order_ship_address_phone varchar (25) 0 1 13 Shipping phone 0  
order_ship_address_email varchar (80) 0 1 14 Shipping email 0  
order_ship_address_notes varchar (500) 0 1 15 Shipping notes 0  
order_ship_address_account varchar (50) 0 1 16 Shipping account 0  
order_ship_address_gift tinyint 0 1 17   0  
order_ship_tax_rate decimal (7,6) 0 0 18 Tax rate 0  
order_ship_tax_rate_state decimal (7,6) 0 1 19 State tax rate 0  
order_ship_tax_rate_county decimal (7,6) 0 1 20 County tax rate 0  
order_ship_tax_rate_city decimal (7,6) 0 1 21 City tax rate 0  
order_ship_tax_rate_vat decimal (7,6) 0 1 22 Vat tax rate 0  
order_ship_tax_shipping bit 0 0 23 Indicates whether shipping has to be taxed 0  
order_ship_tax_handling bit 0 0 24 Indicates whether handling has to be taxed 0  

Return to index of tables