Table Schema: mf_item_sites

This topic describes the columns in the mf_item_sites 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_guid uniqueidentifier 1 0 2   0 mf_sites.site_guid
item_site_cd varchar (50) 0 1 3   0  
item_site_label varchar (50) 0 1 4   0  
site_quantity_on_hand int 0 0 5   0  
site_quantity_on_hold int 0 0 6   0  
site_quantity_on_allocation int 0 0 7   0  
site_quantity_on_order int 0 0 8   0  
site_average_cost money 0 1 9   0  
site_location varchar (50) 0 1 10   0  
item_site_order smallint 0 0 11   0  
item_site_suppress_sale tinyint 0 0 12   0  
item_site_suppress_allocate tinyint 0 0 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  
site_quantity_safety_stock int 0 1 20   0  
site_quantity_on_allocation_intersect_on_hold int 0 1 21   0  
item_site_calculated_suppress_sale tinyint 0 0 22   0  

Return to index of tables