Table Schema: mf_inventory_items

This topic describes the columns in the mf_inventory_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
inventory_guid uniqueidentifier 1 0 1   0  
item_guid uniqueidentifier 1 0 2   0 mf_items.item_guid
inventory_item_quantity_on_hand int 0 1 3   0  
inventory_item_quantity_on_hold int 0 1 5   0  
inventory_item_quantity_on_order int 0 1 6   0  
inventory_item_reorder_point int 0 1 7   0  
inventory_item_reorder_quantity int 0 1 8   0  
inventory_item_current_cost money 0 1 9   0  
inventory_item_average_cost money 0 1 10   0  
inventory_item_last_adjustment_date datetime 0 1 11   0  
inventory_item_last_order int 0 1 12   0  
inventory_item_last_order_date datetime 0 1 13   0  
inventory_item_last_pick_date datetime 0 1 14   0  
inventory_item_last_putaway_date datetime 0 1 15   0  
lu_dt datetime 0 1 16   0  
cr_dt datetime 0 1 17   0  
lu_guid uniqueidentifier 0 1 18   0  
cr_guid uniqueidentifier 0 1 19   0  

Return to index of tables