Table Schema: mf_auto_orders

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  

Return to index of tables

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.