USE [LicenseManager02_Def]
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblDtsFields] WHERE nID=768)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (768, N'tblDts', 32, N'Reserve_for_Department', 1, 103, 50, N'Reserve for Department', 0, 0, N'Department', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Department', NULL, N'cbo_768_Reserve_for_Department', 8, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblDtsFields] WHERE nID=769)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (769, N'tblDts', 32, N'Reserve_for_Location', 1, 103, 50, N'Reserve for Location', 0, 0, N'Location', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Location', NULL, N'cbo_769_Reserve_for_Location', 8, NULL, 0, -1, 1, NULL, NULL, NULL, 3, NULL)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblDtsFields] WHERE nID=770)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (770, N'tblDts', 32, N'Reserve_for_Project', 1, 103, 50, N'Reserve for Project', 0, 0, N'Project', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Project', NULL, N'cbo_770_Reserve_for_Project', 8, NULL, 0, -1, 1, NULL, NULL, NULL, 3, NULL)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblDtsFields] WHERE nID=771)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (771, N'tblDts', 32, N'Reserve_for_License_Server', 1, 103, 50, N'Reserve for License Server', 0, 0, N'Computer', 16, 1, 1, 1, NULL, 1, 1, NULL, N'License Server', NULL, N'cbo_771_Reserve_for_License_Server', 8, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblDtsFields] WHERE nID=772)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (772, N'tblDts', 32, N'Reserve__', 1, 102, 50, N'Number to Reserve', 0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Number to Reserve', NULL, N'nbr_772_Reserve__', 8, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

UPDATE [dbo].[tblDtsFields] 
	SET [tFieldValuesTable]='Vendor',
	[nValueTableDSType]=16
	WHERE nID=699

GO



