Table Schema: mf_picking_orders

This topic describes the columns in the mf_picking_orders table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
picking_order_guid uniqueidentifier 1 0 1   2  
company_guid uniqueidentifier 0 0 2   0  
site_guid uniqueidentifier 0 1 3   0  
transit_site_location_guid uniqueidentifier 0 1 4   0 mf_site_locations.site_location_guid
picking_order_id varchar (50) 0 1 5   0  
picking_order_date datetime 0 1 6   0  
picking_order_assigned_guid uniqueidentifier 0 1 7 Assigned To-F-mf_users 0  
picking_order_assigned tinyint 0 0 8 Work Flow flag- Indicates whether the order is assigned 0  
picking_order_void tinyint 0 0 9 Used by UI as a way to assign records to different colored flags.-F-mf_flags 0  
picking_order_flag tinyint 0 0 10 Used by UI as a way to assign records to different colored flags.-F-mf_flags 0  
picking_order_alert tinyint 0 0 11 Status flag- Indicates whether the order is alerted 0  
picking_order_visible tinyint 0 0 12 Status flag- Indicates whether the order is visible 0  
picking_order_new tinyint 0 0 13 Status flag- Indicates whether the order is new 0  
picking_order_approved tinyint 0 0 14 Work Flow flag- Indicates whether the order is approved 0  
picking_order_suspended tinyint 0 0 15 Status flag- Indicates whether the order is suspended 0  
picking_order_locked tinyint 0 0 16 Status flag- Indicates whether the order is locked 0  
picking_order_closed tinyint 0 0 17 Work Flow flag- Indicates whether the order is closed 0  
picking_order_filed tinyint 0 0 18 Work Flow flag- Indicates whether the order is filed 0  
lu_dt datetime 0 0 19   0  
cr_dt datetime 0 0 20   0  
lu_guid uniqueidentifier 0 1 21   0  
cr_guid uniqueidentifier 0 1 22   0  

Return to index of tables