Table Schema: mf_work

This topic describes the columns in the mf_work_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
work_order_guid	uniqueidentifier	1	0	1
company_guid	uniqueidentifier	0	0	2
work_order_id	varchar (50)	0	1	3
work_order_assigned_guid	uniqueidentifier	0	1	4	Assigned To-F-mf_users
work_order_assigned	tinyint	0	0	5	Work Flow flag- Indicates whether the order is assigned
work_order_void	tinyint	0	0	6	Used by UI as a way to assign records to different colored flags.-F-mf_flags
work_order_flag	tinyint	0	0	7	Used by UI as a way to assign records to different colored flags.-F-mf_flags
work_order_alert	tinyint	0	0	8	Status flag- Indicates whether the order is alerted
work_order_visible	tinyint	0	0	9	Status flag- Indicates whether the order is visible
work_order_new	tinyint	0	0	10	Status flag- Indicates whether the order is new
work_order_approved	tinyint	0	0	11	Work Flow flag- Indicates whether the order is approved
work_order_suspended	tinyint	0	0	12	Status flag- Indicates whether the order is suspended
work_order_locked	tinyint	0	0	13	Status flag- Indicates whether the order is locked
work_order_closed	tinyint	0	0	14	Work Flow flag- Indicates whether the order is closed
work_order_filed	tinyint	0	0	15	Work Flow flag- Indicates whether the order is filed
lu_dt	datetime	0	0	16
cr_dt	datetime	0	0	17
lu_guid	uniqueidentifier	0	1	18
cr_guid	uniqueidentifier	0	1	19

Table Schema: mf_work_orders