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