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 |