Table Schema: mf_shipping_orders

This topic describes the columns in the mf_shipping_orders table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
shipping_order_guid uniqueidentifier 1 0 1 Primary Key 5  
company_guid uniqueidentifier 0 1 2 Company-F-mf_companies 0  
catalog_guid uniqueidentifier 0 1 3 Catalog-F-mf_catalogs 0 mf_catalogs.catalog_guid
site_guid uniqueidentifier 0 1 4 Site-F-mf_sites 0 mf_sites.site_guid
returns_site_guid uniqueidentifier 0 1 5   0  
customer_guid uniqueidentifier 0 1 6 Customer-F-mf_customers 0  
user_guid uniqueidentifier 0 1 7 User that placed the shipping order-F-mf_users 0  
term_guid uniqueidentifier 0 1 8   0  
vendor_guid uniqueidentifier 0 1 9 Vendor-F-mf_vendors 0  
allocation_partition_guid uniqueidentifier 0 1 10   0  
rma_guid uniqueidentifier 0 1 11 RMA-F-mf_rmas 0  
single_allocation_order_guid uniqueidentifier 0 1 12   0 mf_orders.order_guid
shipping_order_code_guid uniqueidentifier 0 1 13   0  
fulfillment_site_location_guid uniqueidentifier 0 1 14   0 mf_site_locations.site_location_guid
max_order_priority_guid uniqueidentifier 0 1 15   0  
localization_guid uniqueidentifier 0 1 16   0  
iso_culture_cd varchar (15) 0 1 17   0 mf_iso_cultures.iso_culture_cd
iso_currency_cd char (3) 0 1 18   0 mf_iso_currencies.iso_currency_cd
taxation_policy_type_id smallint 0 0 19   0 mf_taxation_policy_types.taxation_policy_type_id
shipping_method_id int 0 1 20 Shipping Method-F-mf_shipping_methods 0  
shipping_order_type_id smallint 0 1 21 Shipping order type-F-mf_shipping_order_types 0 mf_shipping_order_types.shipping_order_type_id
shipping_order_id varchar (50) 0 1 22 Id used for uniquely identifying a shipping order 0  
shipment_guid uniqueidentifier 0 1 23 Not used 0  
shipping_order_reference_id varchar (50) 0 1 24 Refernce Id that can be used as an id in another system 0  
shipping_order_state_id smallint 0 1 25 Billing Address State-F-mf_states 0  
shipping_order_country_id smallint 0 1 26 Billing Address Country-F-mf_countries 0  
shipping_order_ship_state_id smallint 0 1 27 Ship Address state-F-mf_states 0  
shipping_order_ship_country_id smallint 0 1 28 Ship Address country-F-mf_countries 0  
shipping_order_date datetime 0 0 29 Shipping order date 0  
shipping_order_shipped_date datetime 0 1 30 Shipped date 0  
shipping_order_attention varchar (255) 0 1 31 Billing attention 0  
shipping_order_company_name varchar (255) 0 1 32 Billing company name 0  
shipping_order_address varchar (80) 0 1 33 Billing address 0  
shipping_order_address2 varchar (80) 0 1 34 Billing address line 2 0  
shipping_order_address3 varchar (80) 0 1 35 Billing address line 3 0  
shipping_order_city varchar (50) 0 1 36 Billing address city 0  
shipping_order_postal_code varchar (50) 0 1 37 Billing Address postal code 0  
shipping_order_country_region_name nvarchar (50) 0 1 38   0  
shipping_order_phone varchar (25) 0 1 39 Billing address phone 0  
shipping_order_email varchar (80) 0 1 40 Billing email 0  
shipping_order_instructions varchar (1000) 0 1 41 Shipping order instructions 0  
shipping_order_ship_attention varchar (255) 0 1 42 Shipping attention 0  
shipping_order_ship_company_name varchar (255) 0 1 43 Shipping company name 0  
shipping_order_ship_address varchar (80) 0 1 44 Shipping address 0  
shipping_order_ship_address2 varchar (80) 0 1 45 Shipping address line 2 0  
shipping_order_ship_address3 varchar (80) 0 1 46 Shipping address line 3 0  
shipping_order_ship_city varchar (50) 0 1 47 Shipping address city 0  
shipping_order_ship_postal_code varchar (50) 0 1 48 Shipping address postal code 0  
shipping_order_ship_country_region_name nvarchar (50) 0 1 49   0  
shipping_order_ship_phone varchar (25) 0 1 50 Shipping phone 0  
shipping_order_ship_email varchar (80) 0 1 51 Shipping email 0  
shipping_order_ship_notes varchar (500) 0 1 52 Shipping notes 0  
shipping_order_ship_account varchar (50) 0 1 53 Shipping account 0  
shipping_order_account varchar (50) 0 1 54   0  
shipping_order_subtotal money 0 0 55 Sub total 0  
shipping_order_subtotal_tax money 0 0 56   0  
shipping_order_tax money 0 0 57 Tax 0  
shipping_order_shipping money 0 0 58 Order shipping 0  
shipping_order_shipping_tax money 0 0 59   0  
shipping_order_shipping_locked tinyint 0 0 60   0  
shipping_order_shipping_actual money 0 1 61   0  
shipping_order_handling money 0 0 62 Order handling 0  
shipping_order_handling_tax money 0 0 63   0  
shipping_order_handling_locked tinyint 0 0 64   0  
shipping_order_insurance money 0 0 65 Order handling 0  
shipping_order_insurance_locked tinyint 0 0 66   0  
shipping_order_discount money 0 0 67   0  
shipping_order_price_adjustment money 0 0 68   0  
shipping_order_price_adjustment_tax money 0 0 69   0  
shipping_order_total money 0 0 70 Order total 0  
shipping_order_total_weight numeric (9,2) 0 1 71   0  
shipping_order_total_lines smallint 0 1 72   0  
shipping_order_total_items smallint 0 1 73   0  
shipping_order_primary_location varchar (50) 0 1 74   0  
shipping_order_amount_attached money 0 0 75   0  
shipping_order_balance_due money 0 0 76   0  
shipping_order_no_backorders tinyint 0 0 77 Shipping order cannot be backordered if set 0  
shipping_order_suppress_short_ship tinyint 0 0 78   0  
shipping_order_separateship tinyint 0 0 79   0  
shipping_order_complete tinyint 0 0 80 Status Flag-Indicates whether the shipping order is complete 0  
shipping_order_invoiced tinyint 0 0 81   0  
shipping_order_authorized tinyint 0 0 82 Work Flow flag- Indicates whether the order is authorized 0  
shipping_order_authorized_locked tinyint 0 0 83   0  
shipping_order_assigned tinyint 0 0 84 Work Flow flag- Indicates whether the order is assigned 0  
shipping_order_assigned_guid uniqueidentifier 0 1 85 Assigned To-F-mf_users 0  
shipping_order_picked tinyint 0 0 86   0  
shipping_order_pickedpacked tinyint 0 0 87 Work Flow flag- Indicates whether the shipping order is pick packed 0  
shipping_order_fulfilled tinyint 0 0 88 Work Flow flag- Indicates whether the shipping order is fulfilled 0  
shipping_order_adjusted tinyint 0 0 89 Work Flow flag- Indicates whether the shipping order is adjusted 0  
shipping_order_exported tinyint 0 0 90   0  
shipping_order_void tinyint 0 0 91 Status flag- Indicates whether the shipping order is voided 0  
shipping_order_alert tinyint 0 0 92 Status flag- Indicates whether the shipping order is alerted 0  
shipping_order_visible tinyint 0 0 93 Status flag- Indicates whether the order is visible 0  
shipping_order_new tinyint 0 0 94 Status flag- Indicates whether the shipping order is new 0  
shipping_order_approved tinyint 0 0 95 Work Flow flag- Indicates whether the shipping order is approved 0  
shipping_order_suspended tinyint 0 0 96 Status flag- Indicates whether the shiping order is suspended 0  
shipping_order_locked tinyint 0 0 97 Status flag- Indicates whether the shipping order is locked 0  
shipping_order_closed tinyint 0 0 98 Work Flow flag- Indicates whether the shipping order is closed 0  
shipping_order_filed tinyint 0 0 99 Work Flow flag- Indicates whether the shipping order is filed 0  
shipping_order_flag tinyint 0 0 100 Used by UI as a way to assign records to different colored flags-F-mf_flags 0  
lu_dt datetime 0 0 101 Record update date 0  
cr_dt datetime 0 0 102 Record created date 0  
lu_guid uniqueidentifier 0 1 103 Record updated by-F-mf_users 0  
cr_guid uniqueidentifier 0 1 104 Record created by-F-mf_users 0  
shipping_order_product_tax money 0 0 105   0  
shipping_order_tax_converted bit 0 0 106   0  
shipping_order_discount_converted bit 0 0 107   0  
shipping_order_payment_pending tinyint 0 1 111   0  
shipping_order_scrub_scheduled_date datetime 0 1 112   0  
shipping_order_scrub_completed_date datetime 0 1 113   0  

Return to index of tables