This topic describes the columns in the mf_auto_orders table.
| Column Name | Data Type | Primary Key | Is Nullable | Column ID | Comment | Reference Count | Reference To |
|---|---|---|---|---|---|---|---|
| auto_order_guid | uniqueidentifier | 1 | 0 | 1 | 2 | ||
| company_guid | uniqueidentifier | 0 | 1 | 2 | Company-F-mf_companies | 0 | mf_companies.company_guid |
| parent_guid | uniqueidentifier | 0 | 1 | 3 | 0 | ||
| catalog_guid | uniqueidentifier | 0 | 1 | 4 | 0 | mf_catalogs.catalog_guid | |
| site_guid | uniqueidentifier | 0 | 1 | 5 | 0 | mf_sites.site_guid | |
| customer_guid | uniqueidentifier | 0 | 1 | 6 | Customer-F-mf_customers | 0 | mf_customers.customer_guid |
| customer_address_guid | uniqueidentifier | 0 | 1 | 7 | Customer-F-mf_customers | 0 | mf_customer_addresses.customer_address_guid |
| customer_payment_method_guid | uniqueidentifier | 0 | 1 | 8 | Customer-F-mf_customers | 0 | mf_customer_payment_methods.customer_payment_method_guid |
| promotion_guid | uniqueidentifier | 0 | 1 | 9 | Item Promotion-F-mf_promotions | 0 | |
| item_price_level_guid | uniqueidentifier | 0 | 1 | 10 | 0 | ||
| term_guid | uniqueidentifier | 0 | 1 | 11 | 0 | mf_terms.term_guid | |
| auto_order_code_guid | uniqueidentifier | 0 | 1 | 12 | 0 | mf_object_codes.code_guid | |
| pending_order_guid | uniqueidentifier | 0 | 1 | 13 | 0 | ||
| iso_currency_cd | char (3) | 0 | 1 | 14 | 0 | mf_iso_currencies.iso_currency_cd | |
| taxation_policy_type_id | smallint | 0 | 0 | 15 | 0 | mf_taxation_policy_types.taxation_policy_type_id | |
| shipping_method_id | int | 0 | 1 | 16 | Shipping method-F-mf_shipping_methods | 0 | |
| auto_order_id | varchar (50) | 0 | 1 | 17 | 0 | ||
| auto_order_label | varchar (50) | 0 | 1 | 18 | 0 | ||
| auto_order_label_short | varchar (50) | 0 | 1 | 19 | 0 | ||
| auto_order_description | varchar (255) | 0 | 1 | 20 | Next Ship Date | 0 | |
| auto_order_promotion_cd | varchar (50) | 0 | 1 | 21 | Promotion code | 0 | |
| auto_order_promotion_description | varchar (255) | 0 | 1 | 22 | Promotion description | 0 | |
| auto_order_request_date | datetime | 0 | 1 | 23 | Order request date | 0 | |
| auto_order_request_date_type_id | smallint | 0 | 1 | 24 | Order requestdate type-F-mf_request_date_types | 0 | |
| auto_order_next_ship_date | datetime | 0 | 1 | 25 | Next Ship Date | 0 | |
| auto_order_next_ship_date_type_id | smallint | 0 | 1 | 26 | Order requestdate type-F-mf_request_date_types | 0 | |
| auto_order_next_ship_date_compute_type_id | smallint | 0 | 0 | 27 | 0 | ||
| auto_order_delay | smallint | 0 | 0 | 28 | 0 | ||
| auto_order_frequency | smallint | 0 | 0 | 29 | 0 | ||
| auto_order_count | smallint | 0 | 0 | 30 | 0 | ||
| auto_order_preserve_promotion_count | smallint | 0 | 0 | 31 | 0 | ||
| auto_order_preserve_pricing_count | smallint | 0 | 0 | 32 | 0 | ||
| auto_order_preserve_shipping_count | smallint | 0 | 0 | 33 | 0 | ||
| auto_order_preserve_discount_count | smallint | 0 | 0 | 34 | 0 | ||
| auto_order_subtotal | money | 0 | 0 | 35 | Sub total | 0 | |
| auto_order_shipping | money | 0 | 0 | 36 | Order shipping | 0 | |
| auto_order_handling | money | 0 | 0 | 37 | Order handling | 0 | |
| auto_order_insurance | money | 0 | 0 | 38 | Order handling | 0 | |
| auto_order_tax | money | 0 | 0 | 39 | Tax | 0 | |
| auto_order_discount_rate | decimal (7,6) | 0 | 1 | 40 | Discount rate | 0 | |
| auto_order_discount | money | 0 | 0 | 41 | Discount amount | 0 | |
| auto_order_discount_description | varchar (255) | 0 | 1 | 42 | 0 | ||
| auto_order_total | money | 0 | 0 | 43 | Order total | 0 | |
| auto_order_total_orders | money | 0 | 0 | 44 | Order total | 0 | |
| auto_order_alert | tinyint | 0 | 0 | 45 | Status flag- Indicates whether the order is alerted | 0 | |
| auto_order_void | tinyint | 0 | 0 | 46 | Status flag- Indicates whether the order is voided | 0 | |
| auto_order_approved | tinyint | 0 | 0 | 47 | Work Flow flag- Indicates whether the order is approved | 0 | |
| auto_order_suspended | tinyint | 0 | 0 | 48 | Status flag- Indicates whether the order is suspended | 0 | |
| auto_order_visible | tinyint | 0 | 0 | 49 | 0 | ||
| auto_order_locked | tinyint | 0 | 0 | 50 | Status flag- Indicates whether the order is locked | 0 | |
| auto_order_closed | tinyint | 0 | 0 | 51 | Work Flow flag- Indicates whether the order is closed | 0 | |
| auto_order_flag | tinyint | 0 | 0 | 52 | Used by UI as a way to assign records to different colored flags.-F-mf_flags | 0 | |
| lu_dt | datetime | 0 | 0 | 53 | 0 | ||
| cr_dt | datetime | 0 | 0 | 54 | 0 | ||
| lu_guid | uniqueidentifier | 0 | 1 | 55 | 0 | ||
| cr_guid | uniqueidentifier | 0 | 1 | 56 | 0 | ||
| cr_object_type_id | smallint | 0 | 1 | 57 | 0 | ||
| cr_object_guid | uniqueidentifier | 0 | 1 | 58 | 0 |