USE [AirTrak]
GO
SET IDENTITY_INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ON 

INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (1, N'File No', N'File No', N'FK_OrderNo', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (2, N'Ship Quote', N'Ship Quote', N'ShipQuote', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (3, N'Shipment Type', N'Shipment Type', N'ShipmentType', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (4, N'SeqNo', N'SeqNo', N'SeqNo', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (5, N'Manifest#', N'Manifest#', N'ManifestNo', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (6, N'Seq#', N'Seq#', N'ManifestSeqNo', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (7, N'HS', N'HS', N'HandlingStation', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (8, N'CS', N'CS', N'ControllingStation', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (9, N'Dst', N'Dst', N'DestAirport', N'text', N'Y', N'textmag', N'left', -1, N'50px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (10, N'Org', N'Org', N'OrgAirport', N'text', N'Y', N'textmag', N'left', -1, N'50px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (11, N'Housebill', N'Housebill', N'Housebill', N'text', N'Y', N'text', N'left', -1, N'100px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (12, N'Driver', N'Driver', N'FK_DriverId', N'text', N'Y', N'text', N'left', -1, N'90px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (13, N'Tractor', N'Tractor', N'FK_TractorCode', N'text', N'Y', N'text', N'left', -1, N'90px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (14, N'Trailer', N'Trailer', N'FK_TrailerCode', N'text', N'Y', N'text', N'left', -1, N'90px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (15, N'Shipper Info', N'Shipper Info', N'ShipperInfo', N'text', N'Y', N'text', N'left', 8, N'110px', N'ShipperInfo', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (16, N'Consignee Info', N'Consignee Info', N'ConsigneeInfo', N'text', N'Y', N'text', N'left', 8, N'110px', N'ConsigneeInfo', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (17, N'Ready Date', N'Ready Date', N'ReadyDateTime', N'date', N'Y', N'date', N'left', -1, N'100px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (18, N'Ready Time', N'Ready Time', N'ReadyTime', N'text', N'Y', N'texttime', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (19, N'Service Date', N'Service Date', N'ServiceDate', N'date', N'Y', N'date', N'left', -1, N'100px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (20, N'Sched Date', N'Sched Date', N'ScheduledDateTime', N'date', N'Y', N'date', N'left', -1, N'100px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (21, N'Sched Time', N'Sched Time', N'ScheduledTime', N'text', N'Y', N'texttime', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (22, N'SV', N'SV', N'FK_ServiceLevelId', N'text', N'Y', N'textmag', N'left', -1, N'50px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (23, N'Status', N'Status', N'FK_OrderStatusId', N'text', N'Y', N'textmag', N'left', -1, N'50px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (24, N'Bill No', N'Bill No', N'BillNo', N'text', N'Y', N'text', N'left', -1, N'50px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (25, N'Customer', N'Customer', N'CustName', N'text', N'Y', N'text', N'left', 8, N'110px', N'CustName', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (26, N'CHB', N'CHB', N'CHB', N'text', N'Y', N'text', N'left', -1, N'100px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (27, N'Move', N'Move', N'MoveType', N'text', N'Y', N'text', N'center', -1, N'20px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (28, N'Notes', N'Notes', N'Notes', N'text', N'Y', N'text', N'left', -1, N'400px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (29, N'StatusDescription', N'StatusDescription', N'StatusDescription', N'text', N'Y', N'text', N'left', -1, N'100px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (30, N'ServiceLevel', N'ServiceLevel', N'ServiceLevel', N'text', N'Y', N'text', N'left', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (31, N'TractorDispatched', N'TractorDispatched', N'TractorDispatched', N'text', N'Y', N'text', N'left', -1, N'10px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (32, N'NextTrackingDateTime', N'NextTrackingDateTime', N'NextTrackingDateTime', N'date', N'Y', N'date', N'left', -1, N'100px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (33, N'NextTrackingTZHoursAway', N'NextTrackingTZHoursAway', N'NextTrackingTZHoursAway', N'text', N'Y', N'text', N'left', -1, N'10px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (39, N'Shipper Name', N'Shipper Name', N'ShipName', N'text', N'Y', N'text', N'left', -1, N'60px', N'ShipName', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (40, N'Consignee Name', N'Consignee Name', N'ConName', N'text', N'Y', N'text', N'left', -1, N'60px', N'ConName', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (41, N'Equipment Type', N'Equipment Type', N'FK_EquipmentCode', N'text', N'Y', N'text', N'left', -1, N'60px', N'FK_EquipmentCode', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (42, N'Shipper (Short)', N'Shipper (Short)', N'ShipAlpha', N'text', N'Y', N'text', N'left', 8, N'100px', N'ShipperTooltip', NULL)
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES (43, N'Consignee (Short)', N'Consignee (Short)', N'ConAlpha', N'text', N'Y', N'text', N'left', 8, N'100px', N'ConsigneeTooltip', NULL)
SET IDENTITY_INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] OFF