Table Schema: mf_order_ship

This topic describes the columns in the mf_order_ship_addresses table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

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

Table Schema: mf_order_ship_addresses