Table Schema: mf_shipments

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  

Return to index of tables