Table Schema: mf_putaway

This topic describes the columns in the mf_putaway_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
putaway_order_guid	uniqueidentifier	1	0	1		1
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
putaway_order_id	varchar (50)	0	1	5		0
putaway_order_date	datetime	0	1	6		0
putaway_order_assigned_guid	uniqueidentifier	0	1	7	Assigned To-F-mf_users	0
putaway_order_assigned	tinyint	0	0	8	Work Flow flag- Indicates whether the order is assigned	0
putaway_order_void	tinyint	0	0	9	Used by UI as a way to assign records to different colored flags.-F-mf_flags	0
putaway_order_flag	tinyint	0	0	10	Used by UI as a way to assign records to different colored flags.-F-mf_flags	0
putaway_order_alert	tinyint	0	0	11	Status flag- Indicates whether the order is alerted	0
putaway_order_visible	tinyint	0	0	12	Status flag- Indicates whether the order is visible	0
putaway_order_new	tinyint	0	0	13	Status flag- Indicates whether the order is new	0
putaway_order_approved	tinyint	0	0	14	Work Flow flag- Indicates whether the order is approved	0
putaway_order_suspended	tinyint	0	0	15	Status flag- Indicates whether the order is suspended	0
putaway_order_locked	tinyint	0	0	16	Status flag- Indicates whether the order is locked	0
putaway_order_closed	tinyint	0	0	17	Work Flow flag- Indicates whether the order is closed	0
putaway_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_putaway_orders