Table Schema: mf_item_site_locations

This topic describes the columns in the mf_item_site_locations table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
item_guid uniqueidentifier 1 0 1   0 mf_items.item_guid
site_location_guid uniqueidentifier 1 0 2   0 mf_site_locations.site_location_guid
item_site_location_quantity_on_hand int 0 0 3   0  
item_site_location_last_pick_date datetime 0 1 5   0  
item_site_location_last_putaway_date datetime 0 1 6   0  
lu_dt datetime 0 0 7   0  
cr_dt datetime 0 0 8   0  
lu_guid uniqueidentifier 0 1 9   0  
cr_guid uniqueidentifier 0 1 10   0  

Return to index of tables