USE [Configuration02_Def]
GO

-- Move Description to 1st tab
UPDATE [tblDtsFields] 
	SET tCaption='ID',
	tLabelCaption='ID',
	tBoundControlName='1',
	tOrigCaption='ID'
WHERE nID = 1;

IF NOT EXISTS (SELECT * FROM [tblDtsFields] WHERE nID=14)
	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 (14, N'tblDts', 32, N'nType', 1, 103, 50, N'Type', 
		0, 0, N'Type', 64, 1, 1, 1, NULL, 1, 1, NULL, N'Type', NULL, N'14', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 3, NULL)

IF NOT EXISTS (SELECT * FROM [tblDtsFields] WHERE nID=15)
	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 (15, N'tblDts', 32, N'nSubType', 1, 103, 50, N'SubType', 
		0, 0, N'SubType', 64, 1, 1, 1, NULL, 1, 1, NULL, N'SubType', NULL, N'15', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)


IF NOT EXISTS (SELECT * FROM [tblDtsFields] WHERE nID=17)
	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 (17, N'tblDts', 32, N'tValue', 1, 10, 255, N'Value',
		0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Value', NULL, N'17', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)

GO

IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 22)
BEGIN
	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 (22, N'tblDts', 32, N'tName', 1, 10, 255, N'Name', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Name', 
	NULL, N'22', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END

GO

IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 23)
BEGIN
	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 (23, N'tblDts', 32, N'nImportType', 1, 103, 50, N'Import Type', 0, 0, N'tblImportSource', 16, 1, 1, 1, NULL, 1, 1, NULL, 
	N'Import Type', NULL, N'23', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END

-- Move Description to 1st tab
UPDATE [tblDtsFields] 
	SET nDestinationTabID=1
WHERE nID = 29;



GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 918)
BEGIN
	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 (918, N'tblDts', 32, N'nImportAuthType', 1, 103, 50, N'Authentication', 
	0, 0, N'tblAuthentication', 16, 0, 1, 1, NULL, 
	1, 1, NULL, N'Authenticate With', NULL, N'918', 5, 'WHERE nAuthType IN (1,2,3,11)', 
	0, -1, 1, NULL, NULL, NULL, 2, NULL)
END

GO

IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 920)
BEGIN
	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 (920, N'tblImp_MappingGroup', 32, N'InternalGroupName',  1, 103, 50, N'Import Mapping: VIZOR Group', 
	0, 0, N'tblGroup', 16, 1, 1, 1, N'1', 1, 1, NULL, N'VIZOR Group', NULL, N'920', 17, NULL, 0, 0, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 921)
BEGIN
	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 (921, N'tblImp_MappingGroup', 32, N'ExternalGroupName', 1, 10, 100, N'Import Mapping: External Group Name', 
	0, 0, NULL, NULL, 1, 1, 1, N'1', 1, 1, NULL, N'External Group Name', NULL, N'921', 17, NULL, 0, 0, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 922)
BEGIN
	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 (922, N'tblDts', 32, N'TotalImported', 1, 102, 50, N'Total Imported', 
	0, 0, NULL, NULL, 0, 1, 1, NULL, 1, 1, NULL, N'Total Imported', NULL, N'922', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID =923 )
BEGIN
	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 (923, N'tblDts', 32, N'TotalAdded', 1, 102, 50, N'Total Added', 
	0, 0, NULL, NULL, 0, 1, 1, NULL, 1, 1, NULL, N'Total Added', NULL, N'923', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 924)
BEGIN
	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 (924, N'tblDts', 32, N'TotalSynchronized', 1, 102, 50, N'Total Synchronized', 
	0, 0, NULL, NULL, 0, 1, 1, NULL, 1, 1, NULL, N'Total Synchronized', NULL, N'924', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 901)
BEGIN
	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 (901, N'tblDts', 32, N'mFilter', 1, 10, 255, N'Filter', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Filter', NULL, N'901', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 902)
BEGIN
	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 (902, N'tblDts', 32, N'bAddNew', 1, 1, 50, N'Add New', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Add New', NULL, N'902', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 903)
BEGIN
	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 (903, N'tblDts', 32, N'bSynch', 1, 1, 50, N'Sync', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Sync', NULL, N'903', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 904)
BEGIN
	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 (904, N'tblDts', 32, N'nMailExt', 1, 102, 50, N'Mail Ext',
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Mail Ext', NULL, N'904', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 919)
BEGIN
	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 (919, N'tblImp_MappingGroup', 32, N'nID', 1, 110, 0, N'Group Mappings',
	0, 0, NULL, 0, 1, 0, 0, N'1', 0, 1, 0, N'Group Mappings', NULL, N'919', 16, NULL, 0, 2, 55, 2, NULL, NULL, NULL, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 907)
BEGIN
	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 (907, N'tblDts', 32, N'nProjectID', 1, 103, 50, N'Project', 
	0, 0, N'VIZORProject', 16, 0, 1, 1, NULL, 
	1, 1, NULL, N'Project', NULL, N'907', 1, NULL, 
	0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 908)
BEGIN
	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 (908, N'tblDts', 32, N'tUniqueFields', 1, 10, 50, N'Unique Fields', 
	0, 0, NULL, NULL, 0, 1, 1, NULL, 1, 1, NULL, N'Unique Fields', NULL, N'908', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 909)
BEGIN
	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 (909, N'tblDts', 32, N'nImportSrc', 1, 103, 50, N'Import Source', 
	0, 0, N'tblImportSource', 16, 0, 1, 1, NULL, 1, 1, NULL, N'Import Source', NULL, N'909', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 3, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 911)
BEGIN
	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 (911, N'tblDts', 32, N'dLastRun', 1, 8, 50, N'Last Run', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Last Run', NULL, N'911', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 912)
BEGIN
	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 (912, N'tblDts', 32, N'nInterval', 1, 102, 50, N'Interval', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Interval', NULL, N'912', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 913)
BEGIN
	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 (913, N'tblDts', 32, N'ADInstance', 1, 10, 255, N'Active Directory Instance',
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Active Directory Instance', NULL, N'913', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 914)
BEGIN
	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 (914, N'tblDts', 32, N'TenantID', 1, 10, 255, N'Tenant ID', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Tenant ID', NULL, N'914', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 915)
BEGIN
	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 (915, N'tblDts', 32, N'ClientID', 1, 10, 255, N'Client ID', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Client ID', NULL, N'915', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 916)
BEGIN
	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 (916, N'tblDts', 32, N'SecretKey', 1, 10, 255, N'Secret Key', 
	0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Secret Key', NULL, N'916', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID = 925)
BEGIN
	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 (925, N'tblDts', 32, N'Errors', 1, 102, 50, N'Total Errors', 
	0, 0, NULL, NULL, 0, 1, 1, NULL, 1, 1, NULL, N'Total Errors', NULL, N'925', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO
IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID =926 )
BEGIN
	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 (926, N'tblDts', 32, N'Enabled', 1, 103, 50, N'Enabled', 
	0, 0, N'tblYesNo', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Enabled', NULL, N'926', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO

IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID =927 )
BEGIN
	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 (927, N'tblImp_MappingGroup', 32, N'nCompositeID', 1, 102, 0, N'Import Mapping ID', 
	0, 0, NULL, 0, 1, 0, 1, NULL, 1, 1, 0, N'Row', NULL, N'927', 17, NULL, 0, 2, NULL, NULL, NULL, NULL, 1, NULL)
END
GO

IF NOT EXISTS (SELECT nID FROM [tblDtsFields] WHERE nID =928 )
BEGIN
	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 (928, N'tblDts', 32, N'Show_Advanced', 1, 103, 3, N'Show Advanced', 0, 0, N'tblYesNo', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Show Advanced', NULL, N'928', 5, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
END
GO


