Table Schema: mf_site_locations

This topic describes the columns in the mf_site_locations table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
site_location_guid uniqueidentifier 1 0 1   10  
company_guid uniqueidentifier 0 0 2   0  
site_guid uniqueidentifier 0 0 3   0 mf_sites.site_guid
site_location_group_guid uniqueidentifier 0 1 4   0 mf_site_location_groups.site_location_group_guid
site_location_id varchar (50) 0 1 5   0  
site_location_rfid varchar (50) 0 1 6   0  
site_location_label varchar (50) 0 1 7   0  
site_location_label_short varchar (50) 0 1 8   0  
site_location_description varchar (255) 0 1 9   0  
site_location_x varchar (50) 0 1 10   0  
site_location_y varchar (50) 0 1 11   0  
site_location_z varchar (50) 0 1 12   0  
site_location_height varchar (50) 0 1 13   0  
site_location_length varchar (50) 0 1 14   0  
site_location_width varchar (50) 0 1 15   0  
site_location_max_weight int 0 1 16   0  
site_location_quantity_on_hand int 0 1 17   0  
site_location_order int 0 0 18   0  
site_location_suppress_sale tinyint 0 0 19   0  
site_location_suppress_pick tinyint 0 0 20   0  
site_location_flag tinyint 0 0 21   0  
site_location_alert tinyint 0 0 22   0  
site_location_visible tinyint 0 0 23   0  
site_location_new tinyint 0 0 24   0  
site_location_approved tinyint 0 0 25   0  
site_location_suspended tinyint 0 0 26   0  
site_location_locked tinyint 0 0 27   0  
site_location_closed tinyint 0 0 28   0  
site_location_filed tinyint 0 0 29   0  
lu_dt datetime 0 1 30   0  
cr_dt datetime 0 1 31   0  
lu_guid uniqueidentifier 0 1 32   0  
cr_guid uniqueidentifier 0 1 33   0  

Return to index of tables