Table Schema: mf_auto_order_items

This topic describes the columns in the mf_auto_order_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
auto_order_item_guid uniqueidentifier 1 0 1   0  
auto_order_guid uniqueidentifier 0 0 2 Order-F-mf_orders 0 mf_auto_orders.auto_order_guid
item_guid uniqueidentifier 0 0 3 Item-F-mf_items 0  
item_price_level_guid uniqueidentifier 0 1 4   0  
site_guid uniqueidentifier 0 1 5   0  
auto_order_item_preserve_count smallint 0 0 6   0  
auto_order_item_quantity int 0 0 7   0  
auto_order_item_unit_price decimal (16,6) 0 0 8   0  
auto_order_item_unit_price_ref decimal (16,6) 0 1 9   0  
auto_order_item_extended_price money 0 1 10   0  
auto_order_item_discount_rate decimal (7,6) 0 1 11   0  
auto_order_item_discount money 0 0 12   0  
auto_order_item_discount_description varchar (255) 0 1 13   0  
lu_dt datetime 0 0 14   0  
cr_dt datetime 0 0 15   0  
lu_guid uniqueidentifier 0 1 16   0  
cr_guid uniqueidentifier 0 1 17   0  

Return to index of tables