Table Schema: mf_picking

This topic describes the columns in the mf_picking_orders table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

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

Table Schema: mf_picking_orders