This topic describes the columns in the mf_shipments table.
| Column Name | Data Type | Primary Key | Is Nullable | Column ID | Comment | Reference Count | Reference To |
|---|---|---|---|---|---|---|---|
| shipment_guid | uniqueidentifier | 1 | 0 | 1 | Primary Key | 6 | |
| company_guid | uniqueidentifier | 0 | 1 | 2 | Company-F-mf_companies | 0 | |
| site_guid | uniqueidentifier | 0 | 1 | 3 | 0 | ||
| order_guid | uniqueidentifier | 0 | 1 | 4 | 0 | mf_orders.order_guid | |
| user_guid | uniqueidentifier | 0 | 1 | 5 | User that created the shipment-F-mf_users | 0 | |
| shipper_guid | uniqueidentifier | 0 | 1 | 6 | 0 | mf_users.user_guid | |
| shipping_order_guid | uniqueidentifier | 0 | 1 | 7 | 0 | ||
| provider_instance_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 | |
| shipment_state_id | smallint | 0 | 1 | 11 | 0 | mf_country_regions.country_region_id | |
| shipment_country_id | smallint | 0 | 1 | 12 | 0 | mf_countries.country_id | |
| shipping_method_id | int | 0 | 1 | 13 | 0 | mf_shipping_methods.shipping_method_id | |
| iso_currency_cd | char (3) | 0 | 1 | 14 | 0 | mf_iso_currencies.iso_currency_cd | |
| shipment_id | varchar (50) | 0 | 1 | 15 | Id used for uniquely identifying a shipment | 0 | |
| shipment_cost | money | 0 | 1 | 16 | Shipment cost | 0 | |
| shipment_date | datetime | 0 | 1 | 17 | Shipment date | 0 | |
| shipment_confirmation_date | datetime | 0 | 1 | 18 | Shipment date | 0 | |
| shipment_confirmation_name | varchar (255) | 0 | 1 | 19 | Shipment date | 0 | |
| shipment_track | varchar (255) | 0 | 1 | 20 | First shipment tracking number | 0 | |
| shipment_attention | varchar (255) | 0 | 1 | 21 | Shipping attention | 0 | |
| shipment_company_name | varchar (255) | 0 | 1 | 22 | Shipping company name | 0 | |
| shipment_address | varchar (50) | 0 | 1 | 23 | Shipping address | 0 | |
| shipment_address2 | varchar (50) | 0 | 1 | 24 | Shipping address line 2 | 0 | |
| shipment_address3 | varchar (50) | 0 | 1 | 25 | Shipping address line 3 | 0 | |
| shipment_city | varchar (50) | 0 | 1 | 26 | Shipping city | 0 | |
| shipment_postal_code | varchar (50) | 0 | 1 | 27 | Shipping postal code | 0 | |
| shipment_country_region_name | nvarchar (50) | 0 | 1 | 28 | 0 | ||
| shipment_tag | varchar (50) | 0 | 1 | 29 | 0 | ||
| provider_instance_storage_key | varchar (50) | 0 | 1 | 30 | 0 | ||
| provider_instance_storage_label | varchar (255) | 0 | 1 | 31 | 0 | ||
| provider_instance_storage_data | varchar (max) | 0 | 1 | 32 | 0 | ||
| provider_instance_storage_version | varchar (25) | 0 | 1 | 33 | 0 | ||
| shipment_shipped | tinyint | 0 | 0 | 34 | Shipment shipped | 0 | |
| shipment_invoiced | tinyint | 0 | 0 | 35 | not used | 0 | |
| shipment_delivered | tinyint | 0 | 0 | 36 | Shipment delivered | 0 | |
| shipment_void | tinyint | 0 | 0 | 37 | Status flag- Indicates whether the shipment is voided | 0 | |
| shipment_flag | tinyint | 0 | 0 | 38 | 0 | ||
| shipment_alert | tinyint | 0 | 0 | 39 | 0 | ||
| shipment_visible | tinyint | 0 | 0 | 40 | 0 | ||
| shipment_new | tinyint | 0 | 0 | 41 | Status flag- Indicates whether the shipment is new | 0 | |
| shipment_approved | tinyint | 0 | 0 | 42 | 0 | ||
| shipment_suspended | tinyint | 0 | 0 | 43 | 0 | ||
| shipment_locked | tinyint | 0 | 0 | 44 | 0 | ||
| shipment_closed | tinyint | 0 | 0 | 45 | Work Flow flag- Indicates whether the shipment is closed | 0 | |
| lu_dt | datetime | 0 | 0 | 46 | Record update date | 0 | |
| cr_dt | datetime | 0 | 0 | 47 | Record created date | 0 | |
| lu_guid | uniqueidentifier | 0 | 1 | 48 | Record updated by-F-mf_users | 0 | |
| cr_guid | uniqueidentifier | 0 | 1 | 49 | Record created by-F-mf_users | 0 | |
| shipment_scrub_scheduled_date | datetime | 0 | 1 | 52 | 0 | ||
| shipment_scrub_completed_date | datetime | 0 | 1 | 53 | 0 |