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 ((Select Top 1 [WFCustomBoardID] + 1 From [tbl_WFCustomDispatchBoardColumns] Order by [WFCustomBoardID] desc), N'DangerousGoods', N'DangerousGoods', N'DangerousGoods', 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 ((Select Top 1 [WFCustomBoardID] + 1 From [tbl_WFCustomDispatchBoardColumns] Order by [WFCustomBoardID] desc), N'Shipper City', N'Shipper City', N'ShipCity', N'text', N'Y', N'text', N'center', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES ((Select Top 1 [WFCustomBoardID] + 1 From [tbl_WFCustomDispatchBoardColumns] Order by [WFCustomBoardID] desc), N'Shipper State', N'Shipper State', N'ShipState', 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 ((Select Top 1 [WFCustomBoardID] + 1 From [tbl_WFCustomDispatchBoardColumns] Order by [WFCustomBoardID] desc), N'Consignee City', N'Consignee City', N'ConCity', N'text', N'Y', N'text', N'center', -1, N'60px', N'', N' ')
INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] ([WFCustomBoardID], [SetupName], [ColumnName], [FieldName], [FieldType], [Sortable], [SortType], [Alignment], [MaxDisplayCharacters], [DefaultWidth], [DataTooltip], [ExactMatch]) VALUES ((Select Top 1 [WFCustomBoardID] + 1 From [tbl_WFCustomDispatchBoardColumns] Order by [WFCustomBoardID] desc), N'Consignee State', N'Consignee State', N'ConState', N'text', N'Y', N'text', N'center', -1, N'20px', N'', N' ')
SET IDENTITY_INSERT [dbo].[tbl_WFCustomDispatchBoardColumns] OFF