/***********************************************************************/
/****Upgrade scripts for U304*******************************************/
/***********************************************************************/

INSERT INTO [Users_mdb].[dbo].[tblMacros] VALUES (70,'<My Department>','GetMacroMyDepartment',NULL,1,NULL,NULL,NULL)
GO



UPDATE [LicenseManager02_Def].[dbo].[tblProperty] SET tValue='375' WHERE nID=7 AND tValue='56'
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (54, 374, 55, N'<script type=''text/javascript''>document.write(parent.objCustomCode.getCodeAfterField(''%fieldname%'',''mem_375_mem_56_ActivityLog''))</script>', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (54, 375, 71, N'html', NULL)
GO

INSERT [Resources02_Def].[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 (1196, N'tblDts', 32, N'Location', 1, 103, 3, N'Current Location (Overview Tab)', 0, 0, N'Location', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Current Location', NULL, N'1196', 1, N'', 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

INSERT [Resources02_Def].[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 (335, N'tblDts', 32, N'dTargetClosureTime', 1, 109, 0, N'Target Closure Time', 0, 0, NULL, 0, 0, 1, 1, NULL, 0, 1, 0, N'Target Closure Time', NULL, N'dtt_335_ClosureTime', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[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 (336, N'tblDts', 32, N'nEscalationLevel', 1, 103, 4, N'Escalation Level', 1, 0, N'tblEscalationLevel', 64, 0, 1, 1, NULL, 0, 1, 0, N'Escalation Level', NULL, N'cbo_336_EscalationLevel', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[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 (337, N'tblDts', 32, N'nServiceTypeID', 1, 103, 4, N'Service Type', 0, 0, N'tblSLAServiceType', 64, 0, 1, 0, NULL, 0, 1, 0, N'Service Type', NULL, N'cbo_337_ServiceType', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[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 (338, N'tblDts', 32, N'dTargetIRT', 1, 109, 0, N'Target Initial Response Time', 0, 0, NULL, 0, 0, 1, 1, NULL, 0, 1, 0, N'Target Initial Response Time', NULL, N'dtt_338_InitialResponseTime', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[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 (339, N'tblDts', 32, N'nAssociatedSLA', 1, 103, 3, N'Associated SLA', 0, 0, N'tblSLA', 32, 0, 1, 1, NULL, 0, 1, 0, N'Associated SLA', NULL, N'cbo_339_AssociatedSLA', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[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 (344, N'tblDts', 32, N'nEscalationOn', 1, 103, 3, N'Escalation State', 0, 0, N'tblEscalationState', 64, 1, 1, 1, NULL, 0, 1, 0, N'Escalation State', NULL, N'cbo_344_EscalationOn', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[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 (345, N'tblDts', 32, N'dEscalationTimestamp', 1, 109, 0, N'Last Pause Time', 0, 0, NULL, 0, 0, 0, 1, NULL, 0, 0, 0, N'Last Pause Time', NULL, N'dtt_345_LastStopTime', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO


INSERT [Resources02_Def].[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 (350, N'tblDts', 32, N'nServiceTypeID', 1, 103, 4, N'Service Type (Overview Tab)', 0, 0, N'tblSLAServiceType', 64, 1, 1, 1, NULL, 0, 1, 0, N'Service Type', NULL, N'cbo_350_ServiceType', 1, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO


INSERT [Resources02_Def].[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 (356, N'tblDts', 32, N'nCumulativePausedTime', 1, 102, 7, N'Cumulative Paused Time (SLA)', 0, 0, NULL, 0, 1, 0, 0, NULL, 0, 0, 0, N'Cumulative Paused Time (SLA)', NULL, N'nbr_356_CumulativePausedTime', 1, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)

GO



INSERT INTO Roles02_Def.dbo.tblItemLevel(nID, nChoiceID, tName) VALUES(6, 6, 'Room Sub-location')
GO

USE Users_mdb
GO
CREATE VIEW [dbo].[RoleLevel6]
AS
SELECT     [nID], [tBriefDescription] AS tName, [Short_Name] AS tShortName, [Role_Type]
FROM         [Roles01_Dat].[dbo].[tblDts]
WHERE     ([Role_Type] = 7 AND [Item_Level] = 6 AND [tShowInSummary]='-1')
GO

INSERT Users_mdb.[dbo].[tblDtsFieldValueTables] ([nID], [tName], [tSourceTableName], [fDelete], [tCaption], [fChoiceOrder], [nDSType], [fEditable], [dTimestamp], [tDependentTable]) VALUES (100, N'RoleLevel6', N'RoleLevel6', 0, N'Role Level 6', 0, 16, 0, NULL, NULL)
GO

INSERT Roles02_Def.[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 (855, N'tblDts', 32, N'Level_6', 1, 103, 3, N'Level 6', 0, 0, N'RoleLevel6', 16, 1, 1, 1, NULL, 1, 1, 0, N'Level 6', NULL, N'cbo_855_Level_6', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

ALTER TABLE Roles01_Dat.dbo.tblDts ADD Level_6 int NULL
GO

INSERT Roles02_Def.[dbo].[tblRule] ([nID], [nParentID], [tName], [tCaption], [tTmplNameRule], [tTableName], [nDBType], [nTrigger], [nState], [tDescription], [nValidationLevel], [bFinished], [nOrder]) VALUES (39, 27, N'New Rule (39)', N'Room Sub-location-', N'%Value0%-%Value1%', N'tblWrk_Hide_Fields_By_Level_27', 64, 1, 1, N'', NULL, 0, 4);
INSERT Roles02_Def.[dbo].[tblRule] ([nID], [nParentID], [tName], [tCaption], [tTmplNameRule], [tTableName], [nDBType], [nTrigger], [nState], [tDescription], [nValidationLevel], [bFinished], [nOrder]) VALUES (40, 34, N'New Rule (40)', N'Room Sub-location-', N'%Value0%-%Value1%', N'tblWrk_Require_Fields_By_Level_34', 64, 1, 1, N'', NULL, 0, 5);
GO

INSERT Roles02_Def.[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (43, 39, N'Location Level', N'=', N'6', N'AND', 0, 0, 0, 0, 1, NULL, 846);
INSERT Roles02_Def.[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (44, 40, N'Location Level', N'=', N'6', N'AND', 0, 0, 0, 0, 1, NULL, 846);
GO

INSERT Roles02_Def.[dbo].[tblPossibleValue] ([nID], [nRuleID], [tName], [tValue], [nRowID], [nFieldID], [nActionType]) VALUES (39, 39, N'', N'855', 1, 0, 2);
INSERT Roles02_Def.[dbo].[tblPossibleValue] ([nID], [nRuleID], [tName], [tValue], [nRowID], [nFieldID], [nActionType]) VALUES (40, 40, N'', N'840;841;842;843;844', 1, 0, 3);
GO

UPDATE Roles02_Def.[dbo].[tblPossibleValue] SET tValue=tValue+';855' WHERE nID IN(28, 29, 30, 31, 32, 33)
GO

INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (401, 39, 1, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (402, 39, 2, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (403, 39, 32, 5);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (404, 39, 64, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (405, 39, 128, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (406, 39, 256, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (407, 39, 3, 4);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (408, 39, 4, 4);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (409, 40, 1, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (410, 40, 2, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (411, 40, 32, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (412, 40, 64, 5);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (413, 40, 128, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (414, 40, 256, 6);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (415, 40, 3, 4);
INSERT Roles02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (416, 40, 4, 4);
GO


INSERT Resources02_Def.[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 (1197, N'tblStorageLocation', 32, N'nCompositeID', 1, 102, 4, N'Storage Location - ID', 0, 0, NULL, NULL, 1, 0, 1, N'1', 1, 1, NULL, N'Storage Location ID', NULL, N'1197', 41, NULL, 1, 2, 1, NULL, NULL, NULL, 1, NULL)
GO
INSERT Resources02_Def.[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 (1198, N'tblStorageLocation', 32, N'Storage_Location', 1, 103, 3, N'Storage Location', 0, 0, N'RoleLevel6', 16, 1, 0, 1, N'1', 0, 1, NULL, N'Storage Location', NULL, N'1198', 41, NULL, 1, 2, 1, NULL, NULL, NULL, NULL, NULL)
GO
INSERT Resources02_Def.[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 (1200, N'tblStorageLocation', 32, N'nID', 1, 110, 0, N'Storage Locations', 0, 0, NULL, NULL, 1, 0, 0, N'1', 1, 1, NULL, N'Storage Locations', NULL, N'lst_1200_Storage_Locations', 3, NULL, 0, 2, 52, 13, NULL, NULL, 2, NULL)
GO
INSERT Resources02_Def.[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 (1201, N'tblDts', 32, N'Return_to_Storage_Location', 1, 103, 3, N'Return to Storage Location', 0, 0, N'RoleLevel6', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Return to Storage Location', NULL, N'cbo_1201_Return_to_Storage_Location', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO
INSERT Resources02_Def.[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 (1199, N'tblDts', 32, N'Send_For_Repair', 1, 1, 0, N'Send For Repair', 0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Send For Repair', NULL, N'chk_1199_Send_For_Repair', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO
INSERT Resources02_Def.[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 (1202, N'tblDts', 32, N'Check_In', 1, 103, 3, N'Check In', 0, 0, N'tblYesNo', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Check In', NULL, N'cbo_1202_Check_In', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

INSERT Resources02_Def.[dbo].[tblTabs] ([nID], [tTabName], [tSubFormName], [tFormName], [tBoundTable], [tDataSource], [tDataSourceDefault]) VALUES (41, N'Storage Location Popup', N'Storage Location Popup', N'tmplStorageLocs.htm', N'tblStorageLocation', NULL, N'tmplStorageLocs.htm')
GO

INSERT Resources02_Def.[dbo].[tblSystemCustomLayouts] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged]) VALUES (13, N'Storage$Locations', N'Storage Locations', 2, 2);
GO

INSERT Resources02_Def.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (13, N'Left', 10, NULL, 2, 1198);
INSERT Resources02_Def.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (13, N'Left', 0, NULL, 1, 1197);
GO


ALTER TABLE Resources01_Dat.dbo.tblDts ADD [Send_For_Repair] [bit] NOT NULL DEFAULT ('0')
GO
ALTER TABLE Resources01_Dat.dbo.tblDts ADD [Return_to_Storage_Location] [int] NULL
GO
ALTER TABLE Resources01_Dat.dbo.tblDts ADD [Check_In] [int] NULL
GO

ALTER TABLE Resources01_Dat.dbo.tblDts ADD [nEscalationLevel] [int] NULL
GO

ALTER TABLE Resources01_Dat.dbo.tblDts ADD [nServiceTypeID] [int] NULL
GO

ALTER TABLE Resources01_Dat.dbo.tblDts ADD [dEscalationTimestamp] [datetime] NULL
GO

ALTER TABLE Resources01_Dat.dbo.tblDts ADD [nEscalationOn] [int] NULL
GO

ALTER TABLE Resources01_Dat.dbo.tblDts ADD [nSeverityID] [int] NULL
GO

ALTER TABLE Resources01_Dat.dbo.tblDts ADD [nCumulativePausedTime] [float] NULL
GO
ALTER TABLE Resources01_Dat.dbo.tblDts ADD [LastAudit] [datetime] NULL
GO

CREATE TABLE Resources01_Dat.[dbo].[tblStorageLocation](
	[nID] [int] NULL,
	[nCompositeID] [int] NULL,
	[nRevisionNumber] [int] NULL,
	[Storage_Location] [int] NULL
) 
GO


INSERT [Resources02_Def].[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 (1203, N'tblDts', 32, N'Check_In_Asset', 1, 10, 255, N'Check In Asset', 0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Check In Asset', NULL, N'txt_1203_Check_In_Asset', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO
INSERT [Resources02_Def].[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 (1204, N'tblDts', 32, N'Check_Out_Asset', 1, 10, 255, N'Check Out Asset', 0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Check Out Asset', NULL, N'txt_1204_Check_Out_Asset', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

ALTER TABLE Resources01_Dat.dbo.[tblDts] ADD [Check_In_Asset] [nvarchar](255) NULL
GO
ALTER TABLE Resources01_Dat.dbo.[tblDts] ADD [Check_Out_Asset] [nvarchar](255) NULL
GO

INSERT Resources02_Def.[dbo].[tblRule] ([nID], [nParentID], [tName], [tCaption], [tTmplNameRule], [tTableName], [nDBType], [nTrigger], [nState], [tDescription], [nValidationLevel], [bFinished], [nOrder]) VALUES (238, 0, N'Disable Fields By Asset Status', N'Disable Fields By Asset Status', N'%Value0%-%Value1%', N'tblWrk_Disable_Fields_By_Asset_Status_238', 64, 1, 1, N'', NULL, 0, 45);
INSERT Resources02_Def.[dbo].[tblRule] ([nID], [nParentID], [tName], [tCaption], [tTmplNameRule], [tTableName], [nDBType], [nTrigger], [nState], [tDescription], [nValidationLevel], [bFinished], [nOrder]) VALUES (239, 238, N'New Rule (239)', N'Assigned-', N'%Value0%-%Value1%', N'tblWrk_Disable_Fields_By_Asset_Status_238', 64, 1, 1, N'', NULL, 0, 45);
INSERT Resources02_Def.[dbo].[tblRule] ([nID], [nParentID], [tName], [tCaption], [tTmplNameRule], [tTableName], [nDBType], [nTrigger], [nState], [tDescription], [nValidationLevel], [bFinished], [nOrder]) VALUES (240, 0, N'Disable Check In Fields', N'Disable Check In Fields', N'%Value0%-%Value1%', N'tblWrk_Disable_Check_In_Fields_240', 64, 1, 1, N'', NULL, 0, 46);
INSERT Resources02_Def.[dbo].[tblRule] ([nID], [nParentID], [tName], [tCaption], [tTmplNameRule], [tTableName], [nDBType], [nTrigger], [nState], [tDescription], [nValidationLevel], [bFinished], [nOrder]) VALUES (241, 240, N'New Rule (241)', N'Yes-', N'%Value0%-%Value1%', N'tblWrk_Disable_Check_In_Fields_240', 64, 1, 1, N'', NULL, 0, 46);
GO

INSERT Resources02_Def.[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (372, 238, N'Status', N'=', N'', N'AND', 0, 0, 0, 0, 1, NULL, 865);
INSERT Resources02_Def.[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (373, 239, N'Status', N'=', N'1', N'AND', 0, 0, 0, 0, 1, NULL, 865);
INSERT Resources02_Def.[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (374, 240, N'Check In', N'=', N'', N'AND', 0, 0, 0, 0, 1, NULL, 1202);
INSERT Resources02_Def.[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (375, 241, N'Check In', N'=', N'1', N'AND', 0, 0, 0, 0, 1, NULL, 1202);
GO

INSERT Resources02_Def.[dbo].[tblPossibleValue] ([nID], [nRuleID], [tName], [tValue], [nRowID], [nFieldID], [nActionType]) VALUES (238, 238, NULL, NULL, 1, NULL, 5);
INSERT Resources02_Def.[dbo].[tblPossibleValue] ([nID], [nRuleID], [tName], [tValue], [nRowID], [nFieldID], [nActionType]) VALUES (239, 239, N'', N'11;1082', 1, 0, 5);
INSERT Resources02_Def.[dbo].[tblPossibleValue] ([nID], [nRuleID], [tName], [tValue], [nRowID], [nFieldID], [nActionType]) VALUES (240, 240, NULL, NULL, 1, NULL, 5);
INSERT Resources02_Def.[dbo].[tblPossibleValue] ([nID], [nRuleID], [tName], [tValue], [nRowID], [nFieldID], [nActionType]) VALUES (241, 241, N'', N'1078;1196', 1, 0, 5);
GO

UPDATE Resources02_Def.[dbo].[tblPossibleValue] SET tValue='848;1199;1201;1207' WHERE nID=136 AND tValue='848'
GO

INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1786, 238, 1, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1787, 238, 2, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1788, 238, 32, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1789, 238, 64, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1790, 238, 128, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1791, 238, 256, 5);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1792, 238, 3, 3);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1793, 238, 4, 3);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1794, 239, 1, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1795, 239, 2, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1796, 239, 32, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1797, 239, 64, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1798, 239, 128, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1799, 239, 256, 5);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1800, 239, 3, 4);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1801, 239, 4, 4);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1802, 240, 1, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1803, 240, 2, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1804, 240, 32, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1805, 240, 64, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1806, 240, 128, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1807, 240, 256, 5);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1808, 240, 3, 3);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1809, 240, 4, 3);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1810, 241, 1, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1811, 241, 2, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1812, 241, 32, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1813, 241, 64, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1814, 241, 128, 6);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1815, 241, 256, 5);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1816, 241, 3, 4);
INSERT Resources02_Def.[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1817, 241, 4, 4);
GO

UPDATE [Users_mdb].[dbo].[tblImportDB] SET tName='Assets - Import Template.xls' WHERE [nID]=5 AND [tName]='AssetImportTemplate.xls'
UPDATE [Users_mdb].[dbo].[tblImportDB] SET tName='Printer - Import Template.xls' WHERE [nID]=19 AND [tName]='Printers - Import Template.xls'
GO

DELETE FROM [CensusWeb_mdb].[dbo].[tblView]  WHERE nViewID=72 AND nFieldID=11
DELETE FROM [CensusWeb_mdb].[dbo].[tblView]  WHERE nViewID=51 AND nfieldID=838
GO

UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+3 WHERE nViewID=72 AND nFieldID IN(1120,801,21,20,886,898,806,1023,907,1092,1121,993)
GO
UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+4 WHERE nViewID=72 AND nFieldID IN(627)
GO
UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+1 WHERE nViewID=72 AND nFieldID IN(1078)
GO
UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+2 WHERE nViewID=72 AND nFieldID IN(30,1093, 894,918,919,921,865,1082)
GO
UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+1 WHERE nViewID=52 AND nFieldID IN(808,853,29,21,836,627,806,32)
GO
UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+1 WHERE nViewID=50 AND nFieldID IN(808,853,29,21,836,627,806,32,1)
GO
UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+1 WHERE nViewID=51 AND nFieldID IN(808,853,29,21,836,627,806,32)
GO

INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (72, NULL, 1196, 12, 2);
INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (72, NULL, 1199, 26, 2);
INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (20, NULL, 1200, 10, 2);
INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (72, NULL, 1201, 27, 2);
INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (72, NULL, 1202, 28, 2);
INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (72, NULL, 1204, 1, 2);
INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (72, NULL, 1203, 2, 2);
GO

INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (52, NULL, 855, 9, 2);
INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (50, NULL, 855, 9, 2);
INSERT censusweb_mdb.[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (51, NULL, 855, 9, 2);
GO

UPDATE [CensusWeb_mdb].[dbo].[tblFieldAttribute] SET [tAttributeValue] = 'no'  WHERE nAttributeID = 82 and nviewId =72  AND nFieldID = 918
UPDATE [CensusWeb_mdb].[dbo].[tblFieldAttribute] SET [tAttributeValue] = 'no'  WHERE nAttributeID = 82 and nviewId =72  AND nFieldID = 894
UPDATE [CensusWeb_mdb].[dbo].[tblFieldAttribute] SET [tAttributeValue] = 'no'  WHERE nAttributeID = 82 and nviewId =61  AND nFieldID = 918
UPDATE [CensusWeb_mdb].[dbo].[tblFieldAttribute] SET [tAttributeValue] = 'no'  WHERE nAttributeID = 82 and nviewId =61  AND nFieldID = 894

GO

INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1093, 68, N'no', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 865, 56, N'no', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1082, 81, N'no', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1199, 95, N'fld_switch.htmpl', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1202, 56, N'no', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1204, 5, N'2', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1204, 68, N'yes', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1204, 82, N'yes', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1204, 95, N'fld_ExchangeAssets2.htmpl', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1203, 5, N'2', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1203, 68, N'yes', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1203, 82, N'yes', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1203, 95, N'fld_ExchangeAssets1.htmpl', NULL);
GO

INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (50, 855, 13, N'Room Sub-location', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (50, 855, 14, N'2', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (50, 855, 60, N'SpanTwoWidthOne', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (51, 855, 13, N'Room Sub-location', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (51, 855, 14, N'2', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (51, 855, 60, N'SpanTwoWidthOne', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (52, 855, 13, N'Room Sub-location', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (52, 855, 14, N'2', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (52, 855, 60, N'SpanTwoWidthOne', NULL);
GO

DELETE FROM censusweb_mdb.dbo.tblFieldAttribute WHERE nViewID=72 AND nFieldID=11


INSERT [Users_mdb].[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 (299, N'tblUser', 32, N'Nickname', 1, 10, 255, N'Nickname', 0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Nickname', NULL, N'txt_299_Nickname', 0, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO
INSERT [Users_mdb].[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 (300, N'EmployeeAssets', 16, N'nID', 1, 110, 0, N'Employee Assets', 0, 0, NULL, 0, 1, 0, 0, N'1', 0, 1, 0, N'Employee Assets', NULL, N'300', 0, NULL, 0, 2, 5, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [Users_mdb].[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 (301, N'EmployeeAssets', 16, N'Serial_Number', 1, 10, 255, N'Employee Assets - Serial Number', 0, 0, NULL, 0, 1, 0, 0, N'1', 0, 1, 0, N'Employee Assets - Serial Number', NULL, N'301', 0, NULL, 0, 2, 4, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [Users_mdb].[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 (302, N'EmployeeAssets', 16, N'Asset_Tag', 1, 10, 255, N'Employee Assets - Asset Tag', 0, 0, NULL, 0, 1, 0, 0, N'1', 0, 1, 0, N'Employee Assets - Asset Tag', NULL, N'302', 0, NULL, 0, 2, 4, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [Users_mdb].[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 (303, N'EmployeeAssetsCount', 16, N'Number_of_Assets', 1, 102, 4, N'Number of Assets', 0, 0, NULL, 0, 1, 0, 1, NULL, 0, 1, NULL, N'Number of Assets', NULL, N'303', 0, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, NULL)
GO

USE Users_mdb
GO
CREATE VIEW [dbo].[EmployeeAssets]
AS
SELECT     nUserID AS nID, nID AS nCompositeID, nID AS nAssetID, Serial_Number, Asset_Tag, tBriefDescription AS tName, Level_1, Level_2
FROM         Resources01_Dat.dbo.tblDts
WHERE     (nUsageType = 1) AND (NOT (nUserID IS NULL)) AND (nUserID > 0) AND (Asset_Sub_status <> 12)
GO

USE Users_mdb
GO
CREATE VIEW [dbo].[EmployeeAssetsCount]
AS
SELECT     nID, COUNT(nAssetID) AS Number_of_Assets
FROM         dbo.EmployeeAssets
GROUP BY nID
GO

CREATE VIEW [dbo].[UserAssets]
AS
SELECT     Users_mdb_tblUser_Submitter.tName AS [Users_mdb_tblUser_Submitter.tName], Users_mdb_tblUser.tName AS [Users_mdb_tblUser.tName], 
                      Users_mdb_tblUser.Security_Type AS [Users_mdb_tblUser.Security_Type], 
                      Resources01_Dat_tblDts.dAssignedTime AS [Resources01_Dat_tblDts.dAssignedTime], 
                      Resources01_Dat_tblDts.dAssignedDate AS [Resources01_Dat_tblDts.dAssignedDate], Resources01_Dat_tblDts.nUserID AS [Resources01_Dat_tblDts.nUserID], 
                      Resources01_Dat_tblDts.tBriefDescription AS [Resources01_Dat_tblDts.tBriefDescription], 
                      Resources01_Dat_tblDts.Comments AS [Resources01_Dat_tblDts.Comments], Resources01_Dat_tblDts.Serial_Number AS [Resources01_Dat_tblDts.Serial_Number], 
                      Resources01_Dat_tblDts.Model AS [Resources01_Dat_tblDts.Model], Resources01_Dat_tblDts.Asset_Tag AS [Resources01_Dat_tblDts.Asset_Tag], 
                      Resources01_Dat_tblDts.Visible AS [Resources01_Dat_tblDts.Visible], 
                      Resources01_Dat_tblDts.Allocated_to_Department AS [Resources01_Dat_tblDts.Allocated_to_Department], 
                      Resources01_Dat_tblDts.Allocated_to_Unit_Division AS [Resources01_Dat_tblDts.Allocated_to_Unit_Division], 
                      Resources01_Dat_tblDts.Allocated_to_Project AS [Resources01_Dat_tblDts.Allocated_to_Project], 
                      Resources01_Dat_tblDts.Requested_Until AS [Resources01_Dat_tblDts.Requested_Until], Resources01_Dat_tblDts.Level_1 AS [Resources01_Dat_tblDts.Level_1], 
                      Resources01_Dat_tblDts.Level_2 AS [Resources01_Dat_tblDts.Level_2], Resources01_Dat_tblDts.Version AS [Resources01_Dat_tblDts.Version], 
                      Resources01_Dat_tblDts.mDetailedDescription AS [Resources01_Dat_tblDts.mDetailedDescription], 
                      Users_mdb_tblUser.tEmailName AS [Users_mdb_tblUser.tEmailName], Users_mdb_tblUser.tWorkPhone AS [Users_mdb_tblUser.tWorkPhone], 
                      Users_mdb_tblUser.First_Name AS [Users_mdb_tblUser.First_Name], Users_mdb_tblUser.Last_Name AS [Users_mdb_tblUser.Last_Name], 
                      Users_mdb_tblUser.Roles AS [Users_mdb_tblUser.Roles], Users_mdb_tblUser.Employee_ID AS [Users_mdb_tblUser.Employee_ID], 
                      Users_mdb_tblUser.tUserName AS [Users_mdb_tblUser.tUserName], 
                      UsersMDB_tblDisplayPicAttachment.tAttachments AS [UsersMDB_tblDisplayPicAttachment.tAttachments], Users_mdb_AssetType.tName AS Users_mdb_AssetType, 
                      Users_mdb_Department.tName AS Users_mdb_Department, Users_mdb_JobTitle.tName AS Users_mdb_JobTitle, 
                      Resources02_Def_tblAssetSubStatus.tName AS Resources02_Def_tblAssetSubStatus, Users_mdb_Location.tName AS Users_mdb_Location, 
                      Users_mdb_AssetClass.tName AS Users_mdb_AssetClass, Users_mdb_tblUser.nID AS [Users_mdb_tblUser.nID]
FROM         dbo.tblUser AS Users_mdb_tblUser LEFT OUTER JOIN
                      dbo.tblDisplayPicAttachment AS UsersMDB_tblDisplayPicAttachment ON Users_mdb_tblUser.nID = UsersMDB_tblDisplayPicAttachment.nID LEFT OUTER JOIN
                      dbo.Department AS Users_mdb_Department ON Users_mdb_tblUser.Department = Users_mdb_Department.nID LEFT OUTER JOIN
                      dbo.Location AS Users_mdb_Location ON Users_mdb_tblUser.Location = Users_mdb_Location.nID LEFT OUTER JOIN
                      dbo.JobTitle AS Users_mdb_JobTitle ON Users_mdb_tblUser.Job_Title = Users_mdb_JobTitle.nID LEFT OUTER JOIN
                      Resources01_Dat.dbo.tblDts AS Resources01_Dat_tblDts ON Users_mdb_tblUser.nID = Resources01_Dat_tblDts.nUserID LEFT OUTER JOIN
                      dbo.AssetClass AS Users_mdb_AssetClass ON Resources01_Dat_tblDts.Level_1 = Users_mdb_AssetClass.nID LEFT OUTER JOIN
                      dbo.AssetType AS Users_mdb_AssetType ON Resources01_Dat_tblDts.Level_2 = Users_mdb_AssetType.nID LEFT OUTER JOIN
                      Resources02_Def.dbo.tblAssetSubStatus AS Resources02_Def_tblAssetSubStatus ON 
                      Resources01_Dat_tblDts.Asset_Sub_status = Resources02_Def_tblAssetSubStatus.nID LEFT OUTER JOIN
                      dbo.tblUser AS Users_mdb_tblUser_Submitter ON Users_mdb_tblUser_Submitter.nID = Resources01_Dat_tblDts.nSubmitterID

GO


ALTER TABLE [Users_mdb].[dbo].tblUser ADD [Nickname] [nvarchar](255) NULL
GO

ALTER TABLE [Resources01_Dat].dbo.tblDts ADD [Relevant_to_Data_Protection] [int] NULL
GO
ALTER TABLE [Resources01_Dat].dbo.tblDts ADD [To_Be_Deleted] [bit] NOT NULL DEFAULT ('0')
GO
ALTER TABLE [Resources01_Dat].dbo.tblDts ADD [Lost_Date] [datetime] NULL
GO

INSERT [Resources02_Def].[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 (1205, N'tblDts', 32, N'Relevant_to_Data_Protection', 1, 103, 3, N'Relevant to Data Protection', 0, 0, N'tblYesNo', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Relevant to Data Protection', NULL, N'cbo_1205_Relevant_to_Data_Protection', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO
INSERT [Resources02_Def].[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 (1207, N'tblDts', 32, N'To_Be_Deleted', 1, 1, 50, N'To Be Deleted', 0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'To Be Deleted', NULL, N'chk_1207_To_Be_Deleted', 1, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO
INSERT [Resources02_Def].[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 (1208, N'tblDts', 32, N'Lost_Date', 1, 8, 50, N'Lost Date', 0, 0, NULL, NULL, 0, 1, 1, NULL, 1, 1, NULL, N'Lost Date', NULL, N'dt_1208_Lost_Date', 3, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

INSERT [Resources02_Def].[dbo].[tblSystemCustomQueries] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged], [nDefaultSort], [nDefaultLayout]) VALUES (61, N'Assets$By$Assigned$to$Person', N'Assets By Assigned to Person', 6, 2, NULL, NULL)
GO

INSERT [Resources02_Def].[dbo].[tblSystemQueries] ([nID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [nDtsFieldID], [nValueType]) VALUES (61, N'Assigned to Person', N'=', N'<Linked Employee>', N'And', NULL, NULL, NULL, 2, 1, 11, NULL)
GO
INSERT [Resources02_Def].[dbo].[tblSystemQueries] ([nID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [nDtsFieldID], [nValueType]) VALUES (61, N'Status', N'<>', N'To Be Scrapped', NULL, NULL, NULL, NULL, 1, 2, 865, NULL)
GO
INSERT [Resources02_Def].[dbo].[tblSystemQueries] ([nID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [nDtsFieldID], [nValueType]) VALUES (50, N'Status', N'<>', N'To Be Scrapped', NULL, NULL, NULL, NULL, 11, 12, 865, NULL)
GO
UPDATE [Resources02_Def].[dbo].[tblSystemQueries] SET [tAndOr]='And' WHERE nID=50 AND nRow=11
GO

INSERT [Resources02_Def].[dbo].[tblAssetSubStatus] ([nID], [nChoiceID], [tName], [nDependentFieldID]) VALUES (10, 8, N'Retired - Lost', 2)
GO
INSERT [Resources02_Def].[dbo].[tblAssetSubStatus] ([nID], [nChoiceID], [tName], [nDependentFieldID]) VALUES (11, 11, N'Status Requested', 1)
GO
INSERT [Resources02_Def].[dbo].[tblAssetSubStatus] ([nID], [nChoiceID], [tName], [nDependentFieldID]) VALUES (12, 12, N'To Be Scrapped', 1)
GO

UPDATE [Resources02_Def].[dbo].[tblAssetSubStatus] SET nChoiceID=9 WHERE nID=4 AND nChoiceID=8
UPDATE [Resources02_Def].[dbo].[tblAssetSubStatus] SET nChoiceID=10 WHERE nID=7 AND nChoiceID=9
GO

INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 7, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 11, 14, N'2', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 11, 60, N'SpanTwoWidthOne', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 11, 81, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 30, 82, N'yes', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 8, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 865, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 865, 68, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 882, 14, N'2', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 882, 60, N'SpanTwoWidthOne', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 894, 82, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1087, 14, N'2', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1087, 60, N'SpanTwoWidthOne', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 918, 82, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 919, 82, N'yes', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 921, 82, N'yes', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 627, 23, N'5', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 907, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 801, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 21, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 20, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 886, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 993, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1120, 82, N'yes', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 806, 13, N'Allocation Type', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 806, 14, N'2', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 806, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 806, 60, N'SpanTwoWidthOne', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1092, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1092, 79, N'yes', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1093, 68, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1093, 82, N'yes', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1023, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 898, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1121, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 2, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 3, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1196, 79, N'yes', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1201, 79, N'yes', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1199, 95, N'fld_switch.htmpl', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 1202, 56, N'no', NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblLayout] ([nViewID], [nLayoutID], [nStatus]) VALUES (84, 2, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblLayout] ([nViewID], [nLayoutID], [nStatus]) VALUES (84, 6, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblLayout] ([nViewID], [nLayoutID], [nStatus]) VALUES (85, 6, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblQuery] ([nViewID], [nQueryID], [nStatus]) VALUES (84, 9, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblQuery] ([nViewID], [nQueryID], [nStatus]) VALUES (84, 11, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblQuery] ([nViewID], [nQueryID], [nStatus]) VALUES (84, 13, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblQuery] ([nViewID], [nQueryID], [nStatus]) VALUES (84, 19, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblQuery] ([nViewID], [nQueryID], [nStatus]) VALUES (84, 54, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblQuery] ([nViewID], [nQueryID], [nStatus]) VALUES (85, 12, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblSort] ([nViewID], [nSortID], [nStatus]) VALUES (84, 1, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblSort] ([nViewID], [nSortID], [nStatus]) VALUES (85, 1, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 7, 3, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 11, 1, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 30, 1, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 8, 4, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 865, 15, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 882, 2, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 894, 3, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1087, 3, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 918, 4, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 919, 5, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 921, 6, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 627, 11, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 907, 21, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 801, 13, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 21, 14, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 20, 16, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 886, 17, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 993, 24, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1120, 12, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 806, 19, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1078, 8, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1092, 22, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1093, 2, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1023, 20, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 898, 18, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1121, 23, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 2, 1, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 3, 2, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1082, 7, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1196, 9, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1201, 10, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1199, 25, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1202, 26, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1203, 27, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 1204, 28, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 353, 0, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (84, NULL, 354, 0, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 45, 1, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 4, 2, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 73, 3, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 94, 4, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 299, 5, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 300, 6, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 303, 7, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 301, 0, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (85, NULL, 302, 0, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Asset Type Admins', 84, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Admins', 84, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Admins', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Developers', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Employee Admins', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'HelpDesk-Analysts', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'HelpDesk-GroupLeads', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Human Resources', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'IT Managers', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Managers', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'QA', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Support-Analysts', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblViewGroupAccess] ([tGroup], [nViewID], [nAccessType]) VALUES (N'Users', 85, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 2, N'100')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 6, N'<None>')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 8, N'Resources / EmployeeAssets')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 13, N'9')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 15, N'6')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 16, N'0')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 21, N'61')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 22, N'798')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 23, N'asset')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 24, N'assets')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 28, N'an')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (85, 6, N'<None>')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (85, 8, N'Employee Assets')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (85, 19, N'2')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (85, 2, N'100')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (85, 7, N'Employee Assets')
GO
INSERT [censusweb_mdb].[dbo].[tblWebViews] ([nViewID], [tViewName], [nProjectID], [tFileLocation], [tAlias], [nTimeOut], [bLocked], [tLastFileLocation], [bGenerated], [nWebSite], [nMaxLinesPerPage], [tWebServer], [tVdPath], [nFeatureId], [bIntegrateSCC], [bReadOnly], [tURL], [tAnonUser], [tAnonPwd], [nVDInfoDirty], [dLastGen], [dNextGen]) VALUES (84, N'EmployeeAssets', 15, (SELECT [tFileLocation] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), N'connect', NULL, 0, (SELECT [tLastFileLocation] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 0, (SELECT [nWebSite] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), NULL, (SELECT [tWebServer] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), (SELECT [tVdPath] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 8191, 0, 0, (SELECT [tURL] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), (SELECT [tAnonUser] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), (SELECT [tAnonPwd] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), -1, NULL, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblWebViews] ([nViewID], [tViewName], [nProjectID], [tFileLocation], [tAlias], [nTimeOut], [bLocked], [tLastFileLocation], [bGenerated], [nWebSite], [nMaxLinesPerPage], [tWebServer], [tVdPath], [nFeatureId], [bIntegrateSCC], [bReadOnly], [tURL], [tAnonUser], [tAnonPwd], [nVDInfoDirty], [dLastGen], [dNextGen]) VALUES (85, N'EmployeeAssets', 8, (SELECT [tFileLocation] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), N'connect', NULL, 0, (SELECT [tLastFileLocation] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 0, (SELECT [nWebSite] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), NULL, (SELECT [tWebServer] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), (SELECT [tVdPath] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), 8191, 0, 0, (SELECT [tURL] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), (SELECT [tAnonUser] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), (SELECT [tAnonPwd] FROM [Censusweb_mdb].[dbo].tblWebViews WHERE nViewID=1), -1, NULL, NULL)
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (85, 29, N'no');
GO
INSERT [censusweb_mdb].[dbo].[tblWebViewAttribute] ([nViewID], [nViewAttributeID], [tValue]) VALUES (84, 29, N'no');
GO

INSERT Users_mdb.[dbo].[tblSystemCustomLayouts] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged]) VALUES (6, N'Employee$Assets', N'Employee Assets', 2, 2)
GO
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 10, N'Name', 1, 4)
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 10, NULL, 2, 73)
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 10, N'Phone', 3, 18)
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 5, NULL, 4, 303)
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 0, NULL, 5, 1)
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 0, NULL, 6, 50)
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 0, NULL, 7, 51)
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 0, NULL, 8, 92)
INSERT Users_mdb.[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (6, N'Left', 0, NULL, 9, 94)
GO

UPDATE [Resources02_Def].[dbo].[tblSystemQueries] 
	SET [tName]=N'    Location', 
		[nDtsFieldID]=882
	WHERE ([nID]=57 AND [nRow]=6);
GO

UPDATE [Resources02_Def].[dbo].[tblSystemQueries] 
	SET [tName]=N'    Location', 
		[nDtsFieldID]=882
	WHERE ([nID]=24 AND [nRow]=10);
GO


INSERT [Resources02_Def].[dbo].[tblRule] ([nID], [nParentID], [tName], [tCaption], [tTmplNameRule], [tTableName], [nDBType], [nTrigger], [nState], [tDescription], [nValidationLevel], [bFinished], [nOrder]) VALUES (242, 0, N'Disable Ticket By Status', N'Disable Ticket By Status', N'%Value0%-%Value1%', N'tblWrk_Disable_Ticket_By_Status_242', 64, 1, 1, N'', NULL, 0, 47)
GO
INSERT [Resources02_Def].[dbo].[tblRule] ([nID], [nParentID], [tName], [tCaption], [tTmplNameRule], [tTableName], [nDBType], [nTrigger], [nState], [tDescription], [nValidationLevel], [bFinished], [nOrder]) VALUES (243, 242, N'New Rule (243)', N'Users-Retired - Lost', N'%Value0%-%Value1%', N'tblWrk_Disable_Ticket_By_Status_242', 64, 1, 1, N'', NULL, 0, 47)
GO

INSERT [Resources02_Def].[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (376, 242, N'<User in Group>', N'=', N'', N'AND', 0, 0, 0, 0, 1, NULL, -55)
GO
INSERT [Resources02_Def].[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (377, 242, N'Status', N'=', N'', N'AND', 0, 0, 0, 0, 2, NULL, 865)
GO
INSERT [Resources02_Def].[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (378, 243, N'<User in Group>', N'=', N'Users', N'AND', 0, 0, 0, 0, 1, NULL, -55)
GO
INSERT [Resources02_Def].[dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) VALUES (379, 243, N'Status', N'=', N'10', N'AND', 0, 0, 0, 0, 2, NULL, 865)
GO

INSERT [Resources02_Def].[dbo].[tblPossibleValue] ([nID], [nRuleID], [tName], [tValue], [nRowID], [nFieldID], [nActionType]) VALUES (242, 242, NULL, NULL, 1, NULL, 22)
GO
INSERT [Resources02_Def].[dbo].[tblPossibleValue] ([nID], [nRuleID], [tName], [tValue], [nRowID], [nFieldID], [nActionType]) VALUES (243, 243, NULL, NULL, 1, NULL, 22)
GO

INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1818, 242, 1, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1819, 242, 2, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1820, 242, 32, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1821, 242, 64, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1822, 242, 128, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1823, 242, 256, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1824, 242, 3, 3)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1825, 242, 4, 3)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1826, 243, 1, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1827, 243, 2, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1828, 243, 32, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1829, 243, 64, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1830, 243, 128, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1831, 243, 256, 6)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1832, 243, 3, 4)
GO
INSERT [Resources02_Def].[dbo].[tblUIElement_Rule] ([nID], [nRuleID], [nElementID], [nAttributeID]) VALUES (1833, 243, 4, 4)
GO

INSERT [Resources02_Def].[dbo].[tblNotification] ([nID], [nParentTableID], [tName], [tMailContent], [tDescription], [fFieldsChanged], [tCaption], [nWhenID], [nWhenParentTableID], [dEnabledFrom], [nTrigger], [nEnablePeriod], [tEnablePeriodUnit], [nMailTemplate], [nCalendarItem], [nReportID], [nReportFormat], [nReportArea]) VALUES (8, 17, N'Status$is$Requested', N'Mail Template', NULL, 2, N'Status is Requested', 8, 15, NULL, 0, NULL, NULL, 28, NULL, NULL, NULL, NULL)
GO
INSERT [Resources02_Def].[dbo].[tblNotification] ([nID], [nParentTableID], [tName], [tMailContent], [tDescription], [fFieldsChanged], [tCaption], [nWhenID], [nWhenParentTableID], [dEnabledFrom], [nTrigger], [nEnablePeriod], [tEnablePeriodUnit], [nMailTemplate], [nCalendarItem], [nReportID], [nReportFormat], [nReportArea]) VALUES (9, 17, N'Asset$is$Scrapped', N'Mail Template', NULL, 2, N'Asset is Scrapped', 9, 15, NULL, 0, NULL, NULL, 27, NULL, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[dbo].[tblSystemCustomConditions] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged], [fHasTotalVariables]) VALUES (8, N'Status$is$Requested', N'Status is Requested', 15, 2, 0)
GO

INSERT [Resources02_Def].[dbo].[tblSystemCustomConditions] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged], [fHasTotalVariables]) VALUES (9, N'Asset$Is$Scrapped', N'Asset Is Scrapped', 15, 2, 0)
GO

INSERT [Resources02_Def].[dbo].[tblSystemConditions] ([nID], [tTotal], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [fWhenCondition], [nDtsFieldID], [nValueType]) VALUES (8, N'Total1', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 1, 0, NULL, NULL)
GO
INSERT [Resources02_Def].[dbo].[tblSystemConditions] ([nID], [tTotal], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [fWhenCondition], [nDtsFieldID], [nValueType]) VALUES (8, NULL, N'Status', N'Update', N'', N'And', NULL, NULL, NULL, 2, 1, -1, 865, NULL)
GO
INSERT [Resources02_Def].[dbo].[tblSystemConditions] ([nID], [tTotal], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [fWhenCondition], [nDtsFieldID], [nValueType]) VALUES (8, NULL, N'Status', N'=', N'Status Requested', NULL, NULL, NULL, NULL, 1, 2, -1, 865, NULL)
GO

INSERT [Resources02_Def].[dbo].[tblSystemConditions] ([nID], [tTotal], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [fWhenCondition], [nDtsFieldID], [nValueType]) VALUES (9, N'Total1', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 1, 0, NULL, NULL)
GO

INSERT [Resources02_Def].[dbo].[tblSystemConditions] ([nID], [tTotal], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [fWhenCondition], [nDtsFieldID], [nValueType]) VALUES (9, NULL, N'Status', N'Update', N'', N'And', NULL, NULL, 0, 2, 1, -1, 865, NULL)
GO

INSERT [Resources02_Def].[dbo].[tblSystemConditions] ([nID], [tTotal], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [fWhenCondition], [nDtsFieldID], [nValueType]) VALUES (9, NULL, N'Status', N'=', N'To Be Scrapped', N'And', NULL, NULL, NULL, 1, 2, -1, 865, NULL)
GO

INSERT [Resources02_Def].[dbo].[tblMail] ([nID], [tFrom], [tRecipients], [mCC], [tSubject], [mBodyText], [mAttachments], [bHTMLBody], [bSendIndividually], [nParentType], [bSendToQueue], [mBCC]) VALUES (27, N'Asset Scrapped', N'', N'', N'Asset Scrapped', N'<table style="background: rgb(209, 219, 236); margin: 0px; width: 100%; height: 100%; padding-top: 3%; padding-bottom: 3%;">	<tbody>		<tr>			<td>			<table style="margin: 2% 10%; border: 1px solid rgb(146, 162, 181); border-image: none; width: 80%; border-collapse: collapse; background-color: white;">				<tbody>					<tr style="background-color: rgb(232, 238, 250);">						<td style="padding: 10px; height: 60px; font-family: verdana,geneva,sans-serif; border-right-color: currentColor; border-bottom-color: rgb(146, 162, 181); border-right-width: medium; border-bottom-width: 1px; border-right-style: none; border-bottom-style: solid;"><img alt="logo" src="http://localhost/connect/theme/images/logos/logol.gif" /></td>						<td style="padding: 10px; height: 60px; text-align: right; font-family: verdana,geneva,sans-serif; font-size: 10pt; border-bottom-color: rgb(146, 162, 181); border-left-color: currentColor; border-bottom-width: 1px; border-left-width: medium; border-bottom-style: solid; border-left-style: none;"><br />						Asset &lt;F:Name&gt; (ID: &lt;Issue Number&gt;)<br />						&nbsp;</td>					</tr>					<tr>						<td colspan="2" style="padding: 15px;">						<p style="text-align: center; font-family: verdana,geneva,sans-serif; font-size: 13pt;"><span style="font-family: Verdana, sans-serif; font-size: 13pt;"><strong>Asset&nbsp;&lt;F:Name&gt; (&lt;F:Asset Type&gt;) scrapped</strong></span></p>
						<div><span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">The asset &lt;F:Name&gt;&nbsp;has been <strong>scrapped</strong></span><span style="color: rgb(102, 102, 102);">.</span></span></span></div>
						<div>&nbsp;</div>
						<div><span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">The asset was assigned to </span><span style="color: rgb(102, 102, 102);"><strong>&lt;F:Assigned to Person&gt;.</strong>&nbsp;</span><span style="color: rgb(102, 102, 102);">&nbsp;</span></span></span></div>
						<div>&nbsp;</div>
						<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">Type: </span></span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">&lt;F:Asset Type&gt; </span></span></span></div>
						<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">Manufacturer:&nbsp;&lt;F:Manufacturer&gt;&nbsp; </span></span></span></div>
						<div>&nbsp;</div>
						<div><span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Serial Number:&nbsp;<strong>&lt;F:Serial Number&gt;</strong></span></span></span></div>
						<div><span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Asset Tag: </span></span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);"><strong>&lt;F:Asset Tag&gt;</strong></span></span></span></div>
						<div>&nbsp;</div>
						<div><br />						<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">Sincerely,</span></span></span></div>
						<div>&nbsp;</div>
						<div>&nbsp;</div>
						<div><font color="#336699" face="Verdana" size="2">Vizor</font></div>						</td>					</tr>				</tbody>			</table>			</td>		</tr>	</tbody></table>
<div><p>&nbsp;</p></div>', N'', 1, 0, 3, 0, N'')
GO

INSERT [Resources02_Def].[dbo].[tblMail] ([nID], [tFrom], [tRecipients], [mCC], [tSubject], [mBodyText], [mAttachments], [bHTMLBody], [bSendIndividually], [nParentType], [bSendToQueue], [mBCC]) VALUES (28, N'Asset Status Requested', N'', N'', N'Asset Status Requested', N'<table style="background: rgb(209, 219, 236); margin: 0px; width: 100%; height: 100%; padding-top: 3%; padding-bottom: 3%;">	<tbody>		<tr>			<td>			<table style="margin: 2% 10%; border: 1px solid rgb(146, 162, 181); border-image: none; width: 80%; border-collapse: collapse; background-color: white;">				<tbody>					<tr style="background-color: rgb(232, 238, 250);">						<td style="padding: 10px; height: 60px; font-family: verdana,geneva,sans-serif; border-right-color: currentColor; border-bottom-color: rgb(146, 162, 181); border-right-width: medium; border-bottom-width: 1px; border-right-style: none; border-bottom-style: solid;"><img alt="logo" src="http://localhost/connect/theme/images/logos/logol.gif" /></td>						<td style="padding: 10px; height: 60px; text-align: right; font-family: verdana,geneva,sans-serif; font-size: 10pt; border-bottom-color: rgb(146, 162, 181); border-left-color: currentColor; border-bottom-width: 1px; border-left-width: medium; border-bottom-style: solid; border-left-style: none;"><br />						Asset &lt;F:Name&gt; (ID: &lt;Issue Number&gt;)<br />						<a href="http://localhost/connect?View=Resources%2FMy%20Assets;&amp;nId==&lt;Issue Number&gt;&amp;Qry=27">View the&nbsp;asset online</a></td>					</tr>					<tr>						<td colspan="2" style="padding: 15px;">						<p style="text-align: center; font-family: verdana,geneva,sans-serif; font-size: 13pt;"><span style="font-family: Verdana, sans-serif; font-size: 13pt;"><strong>Asset&nbsp;&lt;F:Name&gt; (&lt;F:Asset Type&gt;) status is requested</strong></span></p>
						<div><span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">The asset &lt;F:Name&gt;&nbsp;needs its status to be set</span><span style="color: rgb(102, 102, 102);">.</span></span></span></div>
						<div>&nbsp;</div>
						<div><span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">The asset was assigned to </span><span style="color: rgb(102, 102, 102);"><strong>&lt;F:Assigned to Person&gt;.</strong>&nbsp;</span><span style="color: rgb(102, 102, 102);">&nbsp;</span></span></span></div>
						<div>&nbsp;</div>
						<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">Type: </span></span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">&lt;F:Asset Type&gt; </span></span></span></div>
						<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">Manufacturer:&nbsp;&lt;F:Manufacturer&gt;&nbsp; </span></span></span></div>
						<div>&nbsp;</div>
						<div><span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Serial Number:&nbsp;<strong>&lt;F:Serial Number&gt;</strong></span></span></span></div>
						<div><span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Asset Tag: </span></span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);"><strong>&lt;F:Asset Tag&gt;</strong></span></span></span></div>
						<div>&nbsp;</div>
						<div><br />						<span style="font-size: 10pt;"><span style="font-family: verdana,geneva,sans-serif;"><span style="color: rgb(102, 102, 102);">Sincerely,</span></span></span></div>
						<div>&nbsp;</div>
						<div>&nbsp;</div>
						<div><font color="#336699" face="Verdana" size="2">Vizor</font></div>						</td>					</tr>				</tbody>			</table>			</td>		</tr>	</tbody></table>
<div><p>&nbsp;</p></div>', N'', 1, 0, 3, 0, N'')
GO

INSERT [Resources02_Def].[dbo].[tblProperty] ([nID], [tValue], [tName], [nType], [tDescription], [tValidationRule], [nCustomAction], [tCACaption], [tCADisplay], [tValueSourceTable]) VALUES (50, N'9', NULL, 1, N'ID of notification to send when issue is deleted', NULL, NULL, NULL, NULL, NULL)
GO

INSERT [Actions02_Def].[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], [tOrigCaption], [nRevisionNumber]) VALUES (938, N'tblDts', 2048, N'Asset_Tag', 1, 10, 255, N'Asset Tag', 0, 0, NULL, 0, 0, 0, 1, NULL, 0, 1, 0, N'Asset Tag', N'tblActRes_2048.nResID', N'txt_938_Asset_Tag', 1, NULL, 1, 3, 1, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [Actions02_Def].[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], [tOrigCaption], [nRevisionNumber]) VALUES (939, N'tblDts', 2048, N'Serial_Number', 1, 10, 255, N'Serial Number', 0, 0, NULL, 0, 0, 0, 1, NULL, 0, 1, 0, N'Serial Number', N'tblActRes_2048.nResID', N'txt_939_Serial_Number', 1, NULL, 1, 3, 1, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [Actions02_Def].[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], [tOrigCaption], [nRevisionNumber]) VALUES (940, N'tblDts', 2048, N'Level_2', 1, 103, 3, N'Asset Type (Details Tab)', 0, 0, N'AssetType', 16, 0, 0, 1, NULL, 0, 1, 0, N'Asset Type', N'tblActRes_2048.nResID', N'txt_940_Asset_Type', 1, NULL, 1, 3, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT [Actions02_Def].[dbo].[tblSystemCustomLayouts] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged]) VALUES (5, N'Asset$Actions', N'Asset Actions', 2, 2)
GO

INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 5, N'ID', 1, 1)
INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 10, NULL, 2, 798)
INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 10, NULL, 3, 799)
INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 0, NULL, 4, 879)
INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 10, NULL, 5, 878)
INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 30, NULL, 6, 30)
INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 10, NULL, 7, 938)
INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 10, NULL, 8, 939)
INSERT [Actions02_Def].[dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) VALUES (5, N'Left', 10, N'Asset Type', 9, 940)
GO

INSERT [Actions02_Def].[dbo].[tblSystemCustomQueries] ([nID], [tName], [tCaption], [nParentTableID], [fFieldsChanged], [nDefaultSort], [nDefaultLayout]) VALUES (25, N'Asset$Actions', N'Asset Actions', 6, 2, NULL, 5)
GO

INSERT [Actions02_Def].[dbo].[tblSystemQueries] ([nID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [nDtsFieldID], [nValueType]) VALUES (25, N'Usage Type', N'<>', N'Template', N'And', NULL, NULL, NULL, 2, 1, 826, NULL)
INSERT [Actions02_Def].[dbo].[tblSystemQueries] ([nID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [nDtsFieldID], [nValueType]) VALUES (25, N'Event Type', N'<>', N'Request', NULL, NULL, NULL, NULL, 1, 2, 799, NULL)
GO

INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (19, 938, 56, N'no', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (19, 939, 56, N'no', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (19, 940, 56, N'no', NULL)
GO

INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (19, NULL, 938, 13, 2)
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (19, NULL, 939, 12, 2)
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (19, NULL, 940, 14, 2)
GO

INSERT [censusweb_mdb].[dbo].[tblLayout] ([nViewID], [nLayoutID], [nStatus]) VALUES (19, 5, 2)
GO

INSERT [censusweb_mdb].[dbo].[tblQuery] ([nViewID], [nQueryID], [nStatus]) VALUES (19, 25, 2)
GO

UPDATE [Resources02_Def].[dbo].tblDtsFields SET tFieldValuesTable='Manufacturer', nValueTableDSType=16 WHERE tName='Manufacturer_ID'
UPDATE [Resources02_Def].[dbo].tblDtsFields SET tFieldValuesTable='Model', nValueTableDSType=16, nRelatedField=894 WHERE tName='Model'
GO

INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (49, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (49, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (49, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (49, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (44, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (44, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (44, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (44, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (20, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (20, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (24, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (24, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (28, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (28, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (45, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (45, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (53, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (53, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (61, 894, 82, N'no', NULL);
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (61, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (61, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (61, 918, 82, N'no', NULL);
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (62, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (62, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (74, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (74, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (81, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (81, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (82, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (82, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (83, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (83, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 894, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 894, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (45, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (45, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (53, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (53, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (61, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (61, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (62, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (62, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (74, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (74, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (81, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (81, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (82, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (82, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 918, 86, N'yes', NULL)
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (84, 918, 95, N'fldGlobalChoiceListText.htmpl', NULL)
GO


CREATE TABLE Users_mdb.[dbo].[Manufacturer](
	[nID] [int] NOT NULL,
	[tName] [varchar](255) NULL,
 CONSTRAINT [PK_Manufacturer] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

CREATE TABLE Users_mdb.[dbo].[Model](
	[nID] [int] NOT NULL,
	[tName] [varchar](255) NULL,
	[nDependentFieldID] [int] NULL,
 CONSTRAINT [PK_Model] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

INSERT Users_mdb.[dbo].[tblDtsFieldValueTables] ([nID], [tName], [tSourceTableName], [fDelete], [tCaption], [fChoiceOrder], [nDSType], [fEditable], [dTimestamp], [tDependentTable]) VALUES (101, N'Manufacturer', N'Manufacturer', 0, N'Manufacturer', 0, 16, 1, NULL, NULL)
GO
INSERT Users_mdb.[dbo].[tblDtsFieldValueTables] ([nID], [tName], [tSourceTableName], [fDelete], [tCaption], [fChoiceOrder], [nDSType], [fEditable], [dTimestamp], [tDependentTable]) VALUES (102, N'Model', N'Model', 0, N'Model', 0, 16, 1, NULL, NULL)
GO

INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (18, 252, 55, N'<script type="text/javascript">InitOrgLvlFldOnChange(''%fieldname%'', %fieldid%, 77,78);</script>', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (18, 253, 55, N'<script type="text/javascript">InitOrgLvlFldOnChange(''%fieldname%'', %fieldid%, 77,78);</script>', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (18, 254, 55, N'<script type="text/javascript">InitOrgLvlFldOnChange(''%fieldname%'', %fieldid%, 77,78);</script>', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (18, 255, 55, N'<script type="text/javascript">InitOrgLvlFldOnChange(''%fieldname%'', %fieldid%, 77,78);</script>', NULL);
INSERT censusweb_mdb.[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (18, 259, 55, N'<script type="text/javascript">InitOrgLvlFldOnChange(''%fieldname%'', %fieldid%, 77,78);</script>', NULL);
GO

DELETE FROM LicenseManager02_Def.dbo.tblSystemCustomReports WHERE tReportName = 'rptListingGCosts$per$Department'
DELETE FROM LicenseManager02_Def.dbo.tblSystemCustomReports WHERE tReportName = 'rptListingGCosts$per$Location'
DELETE FROM LicenseManager02_Def.dbo.tblSystemCustomReports WHERE tReportName = 'rptListingGLicences$-$By$Status'
DELETE FROM LicenseManager02_Def.dbo.tblSystemCustomReports WHERE tReportName = 'rptListingGLicenses$License$Allocation'
GO


INSERT Resources02_Def.[dbo].[tblMacros] ([ID], [tName], [tFunctionName], [tTableName], [nType], [nUsageType], [tValuesSource], [tDisplayName]) VALUES (70, N'<My Accessible Companies>', N'GetMacroUserAccessibleCompanies', NULL, 2, 0, NULL, NULL)
GO
INSERT Resources02_Def.[dbo].[tblMacros] ([ID], [tName], [tFunctionName], [tTableName], [nType], [nUsageType], [tValuesSource], [tDisplayName]) VALUES (71, N'<Linked Employee>', N'GetMacroLinkedEmployee', NULL, 3, NULL, NULL, NULL)
GO
INSERT Resources02_Def.[dbo].[tblMacros] ([ID], [tName], [tFunctionName], [tTableName], [nType], [nUsageType], [tValuesSource], [tDisplayName]) VALUES (72, N'<Asset Type Abbrev>', N'GetMacroAssetTypeAbbrev', NULL, 3, NULL, NULL, NULL)
GO
INSERT Resources02_Def.[dbo].[tblMacros] ([ID], [tName], [tFunctionName], [tTableName], [nType], [nUsageType], [tValuesSource], [tDisplayName]) VALUES (73, N'<Asset Type Count>', N'GetMacroAssetTypeCount', NULL, 3, NULL, NULL, NULL)
GO
INSERT Resources02_Def.[dbo].[tblMacros] ([ID], [tName], [tFunctionName], [tTableName], [nType], [nUsageType], [tValuesSource], [tDisplayName]) VALUES (74, N'<Asset Purchased Date>', N'GetMacroPurchasedDate', NULL, 3, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[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 (1209, N'tblDts', 32, N'Abbreviation', 1, 10, 50, N'Abbreviation', 0, 0, NULL, NULL, 1, 1, 1, NULL, 1, 1, NULL, N'Abbreviation', NULL, N'txt_1209_Abbreviation', 1, NULL, 0, -1, 1, NULL, NULL, N'9161', 11, NULL)
GO
INSERT [Resources02_Def].[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 (1210, N'tblDts', 32, N'Asset_Type_Count', 1, 102, 4, N'Asset Type Count', 0, 0, NULL, NULL, 0, 1, 1, NULL, 1, 1, NULL, N'Asset Type Count', NULL, N'nbr_1210_Asset_Type_Count', 3, NULL, 0, -1, 1, NULL, NULL, N'9161', 2, NULL)
GO
INSERT [Resources02_Def].[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 (1211, N'tblDts', 32, N'LastAudit', 1, 8, 50, N'LastAudit', 0, 0, NULL, NULL, 0, 1, 1, NULL, 1, 1, NULL, N'Last Audit', NULL, N'dt_10000_LastAudit', 3, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

ALTER TABLE Resources01_Dat.dbo.tblDts ADD [Abbreviation] [nvarchar](50) NULL
GO
ALTER TABLE Resources01_Dat.dbo.tblDts ADD [Asset_Type_Count] [int] NULL
GO


CREATE TABLE [Resources02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [Resources02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [Resources02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [Resources02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [Actions02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [Actions02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [Actions02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [Actions02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [Appraisals02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [Appraisals02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [Appraisals02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [Appraisals02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [AppraisalSections02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [AppraisalSections02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [AppraisalSections02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [AppraisalSections02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [BugTrk02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [BugTrk02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [BugTrk02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [BugTrk02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [ChangeRequests02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [ChangeRequests02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [ChangeRequests02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [ChangeRequests02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [Configuration02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [Configuration02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [Configuration02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [Configuration02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [HelpDesk02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [HelpDesk02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [HelpDesk02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [HelpDesk02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO


ALTER TABLE Installations01_Dat.dbo.tblDts ADD [nEscalationLevel] [int] NULL
GO

ALTER TABLE Installations01_Dat.dbo.tblDts ADD [nServiceTypeID] [int] NULL
GO



ALTER TABLE Installations01_Dat.dbo.tblDts ADD [dEscalationTimestamp] [datetime] NULL
GO


ALTER TABLE Installations01_Dat.dbo.tblDts ADD [nEscalationOn] [int] NULL
GO



INSERT Installations02_Def.[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 (336, N'tblDts', 32, N'nEscalationLevel', 1, 103, 4, N'Escalation Level', 1, 0, N'tblEscalationLevel', 64, 0, 1, 1, NULL, 0, 1, 0, N'Escalation Level', NULL, N'cbo_336_EscalationLevel', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

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 (337, N'tblDts', 32, N'nServiceTypeID', 1, 103, 4, N'Service Type', 0, 0, N'tblSLAServiceType', 64, 0, 1, 0, NULL, 0, 1, 0, N'Service Type', NULL, N'cbo_337_ServiceType', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO


INSERT Installations02_Def.[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 (344, N'tblDts', 32, N'nEscalationOn', 1, 103, 3, N'Escalation State', 0, 0, N'tblEscalationState', 64, 1, 1, 1, NULL, 0, 1, 0, N'Escalation State', NULL, N'cbo_344_EscalationOn', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT Installations02_Def.[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 (345, N'tblDts', 32, N'dEscalationTimestamp', 1, 109, 0, N'Last Pause Time', 0, 0, NULL, 0, 0, 0, 1, NULL, 0, 0, 0, N'Last Pause Time', NULL, N'dtt_345_LastStopTime', 14, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO

INSERT Installations02_Def.[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 (350, N'tblDts', 32, N'nServiceTypeID', 1, 103, 4, N'Service Type (Overview Tab)', 0, 0, N'tblSLAServiceType', 64, 1, 1, 1, NULL, 0, 1, 0, N'Service Type', NULL, N'cbo_350_ServiceType', 1, NULL, 1, -1, 1, NULL, NULL, NULL, NULL, NULL)
GO


CREATE TABLE [Installations02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [Installations02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [Installations02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [Installations02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [InventoriedSoftware02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [InventoriedSoftware02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [InventoriedSoftware02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [InventoriedSoftware02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [KnowledgeBase02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [KnowledgeBase02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [KnowledgeBase02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [KnowledgeBase02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [LicenseManager02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [LicenseManager02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [LicenseManager02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [LicenseManager02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [Purchases&Agreements02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [Purchases&Agreements02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [Purchases&Agreements02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [Purchases&Agreements02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [ReleaseMgmt02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [ReleaseMgmt02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [ReleaseMgmt02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [ReleaseMgmt02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [Roles02_Def].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [Roles02_Def].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [Roles02_Def].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [Roles02_Def].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

CREATE TABLE [Users_mdb].[dbo].[tblDefVals](
	[nID] [int] NOT NULL,
	[tMask] [nvarchar](255) NULL,
 CONSTRAINT [PK_tblDefVals] PRIMARY KEY CLUSTERED 
(
	[nID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT [Users_mdb].[dbo].[tblDtsFieldsFields] ([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]) VALUES (32, N'tblDefVals', 64, N'tMask', 1, 10, 255, N'Default Values', 0, 0, NULL, 0, 1, 1, 0, NULL, 1, 1, 0, N'Default Values', NULL, N'32', 0, NULL, 0, 1, 1, NULL, NULL, NULL)
GO

INSERT [Users_mdb].[dbo].[tblDtsFieldsTables] ([nID], [tTableName], [tTableNameTemp], [tBeforeSubmitFunc], [tSubmitFunc], [tCopyRecordsFunc], [tRevisionFunc], [tDefaultTableName], [nRelationshipType], [nDsType]) VALUES (2, N'tblDefVals', NULL, NULL, NULL, NULL, NULL, NULL, 1, 64)
GO

INSERT [Users_mdb].[dbo].[tblFieldEditorField] ([nID], [tBoundControlName], [fEnabled], [nControlType]) VALUES (32, N'32', 1, 2)
GO

INSERT [Resources02_Def].[dbo].[tblDefVals] ([nID], [tMask]) VALUES (30, N'<F.ID:Asset Tag>')
INSERT [Resources02_Def].[dbo].[tblDefVals] ([nID], [tMask]) VALUES (921, N'<Asset Purchased Date><Asset Type Abbrev><Asset Type Count>')
GO


INSERT [KnowledgeBase01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mWorkaroundDescription], [nOriginatorID], [nSubmitterID], [nSubstateID], [nStateID], [KB___Article_Type], [KB___Title], [KB___Symptoms], [KB___Cause], [KB___Workaround], [KB___Status], [KB___Resolution], [Products_Affected], [KB___Author], [KB___Date_Created], [KB___Date_of_Last_Review], [KB___Summary], [KB___Task_at_Hand], [KB___Solution], [KB___More_Information], [KB___Question], [KB___Answer], [KB___Review_Date], [KB___Article_Security]) VALUES (20, 7, N'-1', 0, NULL, NULL, NULL, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE00E94C9C AS DateTime), CAST(0xFFFFFFFE0109611C AS DateTime), NULL, 5, 5, NULL, 1, 2, N'How to check Printer settings in Windows 10', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, CAST(0x0000A88E00000000 AS DateTime), N'<div><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>Windows 10 is all new with a&nbsp;new interface and new Settings. There is a new<span>&nbsp;</span></span><strong style=''font-weight: bold; color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;''>Devices</strong><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''><span>&nbsp;</span>section in<span>&nbsp;</span></span><strong style=''font-weight: bold; color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;''>Windows 10 PC Settings </strong><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>which makes it easy for users to add, remove or manage the devices connected to their PC. In this post, we will learn about the how to open and use the Devices Panel in Settings, and see how to change Printers, Scanner, Bluetooth, Mouse, Touchpad, Typing, Autoplay and Connected Devices preferences.</span></div>', NULL, N'<div><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>Open the<span>&nbsp;</span></span><a style=''color: rgb(33, 90, 195); text-decoration: none; font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);'' href="http://www.thewindowsclub.com/windows-10-settings" target="_blank">Settings app</a><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''><span>&nbsp;</span>and click on<span>&nbsp;</span></span><strong style=''font-weight: bold; color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;''>Devices</strong><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>. Clicking on Devices will open a tab where you can adjust the settings for all your printers, connected devices, Bluetooth devices, mouse &amp; touchpad, typing settings and autoplay settings. Let us see the settings available in each of te sub-sections.</span></div><br><div>&nbsp;</div><br><div><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''><img style="width: 400px; height: 313px;" alt="" src="http://thewindowsclub.thewindowsclubco.netdna-cdn.com/wp-content/uploads/2015/07/Windows-10-Devices-settings-1-400x313.jpg"></span></div><br><div>&nbsp;</div><br><div><span style="background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); display: inline; float: none; font-size: 14px; font-style: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; widows: 2; word-spacing: 0px;">Under Printers &amp; Scanners tab, you can see the connected printers and also add a new printer or a&nbsp;scanner to your PC. Not just the printers, but you can also see the device set up for Microsoft Print to PDF, XPS Document writer, Send to SnagIt or OneNote.&nbsp;Scroll down and you can see a button where you can turn off the download of drivers for new devices, when on a metered connections. Turning this button off will help you save your data while you are using a metered connected.</span></div><br><div>&nbsp;</div><br><div><img alt="" src="http://thewindowsclub.thewindowsclubco.netdna-cdn.com/wp-content/uploads/2015/07/Windows-10-Devices-settings-2-400x314.jpg"></div><br><div>&nbsp;</div><br><div><div style="background-color: transparent; color: rgb(51, 51, 51); cursor: text; font-family: sans-serif,Arial,Verdana,&amp;quot;Trebuchet MS&amp;quot;; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 20.8px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>This tab shows the hardware connected to your PC. Click on<span>&nbsp;</span></span><em style=''font-style: italic; color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;''>Add a device</em><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''><span>&nbsp;</span>and your PC will automatically scan for the connected devices. Related settings take you to the Bluetooth settings, hardware devices through the Control Panel and to the Device Manager. You can also<span>&nbsp;</span></span><a style=''color: rgb(33, 90, 195); text-decoration: none; font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);'' href="http://www.thewindowsclub.com/set-up-use-miracast-windows-10" target="_blank">set up Miracast</a><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''><span>&nbsp;</span>here.</span></div><br><div style="background-color: transparent; color: rgb(51, 51, 51); cursor: text; font-family: sans-serif,Arial,Verdana,&amp;quot;Trebuchet MS&amp;quot;; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 20.8px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">&nbsp;</div></div>', N'<div>For more information see&nbsp;<a href="https://support.microsoft.com/en-gb/help/4027370/windows-view-the-print-queue?" target="_blank">https://support.microsoft.com/en-gb/help/4027370/windows-view-the-print-queue?</a></div>', NULL, NULL, CAST(0x0000A88E00000000 AS DateTime), 1)
GO

INSERT [KnowledgeBase01_Dat].[dbo].[tblFixInformation] ([nID]) VALUES (20)
GO

INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 1, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE00E94C9C AS DateTime), N'analyst', NULL, N'Public', NULL, 384, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 1, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE00E94C9C AS DateTime), N'analyst', NULL, N'How To', NULL, 366, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 1, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE00E94C9C AS DateTime), N'analyst', NULL, N'Help Desk Analyst', NULL, 374, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 1, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE00E94C9C AS DateTime), N'analyst', NULL, N'How to check Printer settings in Windows', NULL, 367, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 1, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE00E94C9C AS DateTime), N'analyst', N'', N'<div><ul class="ia-numbered" ng-class="$ctrl.listStyle" style="box-sizing: inherit; padding-right: 0px; padding-left: 16px; margin: 0px; list-style: decimal; color: rgb(0, 0, 0); font-family: &quot;Segoe UI&quot;, SegoeUI, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 15px;">	<li class="ng-scope x-hidden-focus" ng-repeat="step in $ctrl.stepList.steps" style="box-sizing: inherit; margin-bottom: 12px;">	<p class="ng-scope" style="box-sizing: inherit; margin-top: 0px; margin-bottom: 24px; display: inline;"><span class="ng-isolate-scope" compile="step.stepHtml" style="box-sizing: inherit; outline: none;">To view a list of items waiting to print in Windows 10,&nbsp;select the search box next to Start&nbsp;&nbsp;on the taskbar and&nbsp;type&nbsp;<span style="box-sizing: inherit; font-weight: 700;">devices and printers</span>.</span></p>	</li>	<li class="ng-scope" ng-repeat="step in $ctrl.stepList.steps" style="box-sizing: inherit; margin-bottom: 12px;">	<p class="ng-sc', NULL, 379, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 2, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE00EA0240 AS DateTime), N'analyst', NULL, NULL, NULL, -13563, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 3, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE00EB341C AS DateTime), N'analyst', N'<div><ul class="ia-numbered" ng-class="$ctrl.listStyle" style="box-sizing: inherit; padding-right: 0px; padding-left: 16px; margin: 0px; list-style: decimal; color: rgb(0, 0, 0); font-family: &quot;Segoe UI&quot;, SegoeUI, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 15px;">	<li class="ng-scope x-hidden-focus" ng-repeat="step in $ctrl.stepList.steps" style="box-sizing: inherit; margin-bottom: 12px;">	<p class="ng-scope" style="box-sizing: inherit; margin-top: 0px; margin-bottom: 24px; display: inline;"><span class="ng-isolate-scope" compile="step.stepHtml" style="box-sizing: inherit; outline: none;">To view a list of items waiting to print in Windows 10,&nbsp;select the search box next to Start&nbsp;&nbsp;on the taskbar and&nbsp;type&nbsp;<span style="box-sizing: inherit; font-weight: 700;">devices and printers</span>.</span></p>	</li>	<li class="ng-scope" ng-repeat="step in $ctrl.stepList.steps" style="box-sizing: inherit; margin-bottom: 12px;">	<p class="ng-sc', N'<ol>	<li>To view a list of items waiting to print in Windows 10, select the search box next to <strong>Start</strong>&nbsp; on the taskbar and type <strong>devices and printers</strong>.</li>	<li>Select <strong>Devices and Printers</strong> and find your printer in the list.</li>	<li>Press and hold (or right-click) it and select <strong>See what is printing.</strong></li></ol>
<div><img alt="" src="https://dr5mo5s7lqrtc.cloudfront.net/items/2a2g1Q3x0T3917251e0g/Screen%20Recording%202018-02-21%20at%2001.46.03%20PM.gif?X-CloudApp-Visitor-Id=2958720&amp;v=a0b213d1" style="width: 606px; height: 602px;"></div>', NULL, 379, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 4, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE0107CCD0 AS DateTime), N'analyst', NULL, N'2/21/2018', NULL, 376, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 4, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE0107CDFC AS DateTime), N'analyst', N'', N'<div>For more information see&nbsp;<a href="https://support.microsoft.com/en-gb/help/4027370/windows-view-the-print-queue?" target="_blank">https://support.microsoft.com/en-gb/help/4027370/windows-view-the-print-queue?</a></div>', NULL, 380, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 4, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE0107CDFC AS DateTime), N'analyst', NULL, N'2/21/2018', NULL, 383, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 4, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE0107CDFC AS DateTime), N'analyst', N'<ol>	<li>To view a list of items waiting to print in Windows 10, select the search box next to <strong>Start</strong>&nbsp; on the taskbar and type <strong>devices and printers</strong>.</li>	<li>Select <strong>Devices and Printers</strong> and find your printer in the list.</li>	<li>Press and hold (or right-click) it and select <strong>See what is printing.</strong></li></ol>
<div><img alt="" src="https://dr5mo5s7lqrtc.cloudfront.net/items/2a2g1Q3x0T3917251e0g/Screen%20Recording%202018-02-21%20at%2001.46.03%20PM.gif?X-CloudApp-Visitor-Id=2958720&amp;v=a0b213d1" style="width: 606px; height: 602px;"></div>', N'<ol>	<li class="ng-scope" style="box-sizing: inherit; margin-bottom: 12px;" ng-repeat="step in $ctrl.stepList.steps">	<p class="ng-scope x-hidden-focus" style="box-sizing: inherit; margin-top: 0px; margin-bottom: 24px; display: inline;"><span class="ng-isolate-scope" style="box-sizing: inherit; outline: none;" compile="step.stepHtml">To view a list of items waiting to print in Windows 10,&nbsp;select the search box next to Start<span>&nbsp;</span><span>&nbsp;</span>on the taskbar and&nbsp;type<span>&nbsp;</span><b style="box-sizing: inherit; font-weight: 700;">devices and printers</b>.</span></p>	</li>	<li class="ng-scope" style="box-sizing: inherit; margin-bottom: 12px;" ng-repeat="step in $ctrl.stepList.steps">	<p class="ng-scope" style="box-sizing: inherit; margin-top: 0px; margin-bottom: 24px; display: inline;"><span class="ng-isolate-scope" style="box-sizing: inherit; outline: none;" compile="step.stepHtml">Select<span>&nbsp;</span><b style="box-sizing: inherit; font-weight: 700;"', NULL, 379, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 4, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE0107CDFC AS DateTime), N'analyst', N'', N'<div><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>Windows 10 is all new with a&nbsp;new interface and new Settings. There is a new<span>&nbsp;</span></span><strong style=''font-weight: bold; color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0', NULL, 377, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 7, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE01095FF0 AS DateTime), N'analyst', N'How to check Printer settings in Windows', N'How to check Printer settings in Windows 10', NULL, 367, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 5, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE0108BF64 AS DateTime), N'analyst', N'<ol>	<li class="ng-scope" style="box-sizing: inherit; margin-bottom: 12px;" ng-repeat="step in $ctrl.stepList.steps">	<p class="ng-scope x-hidden-focus" style="box-sizing: inherit; margin-top: 0px; margin-bottom: 24px; display: inline;"><span class="ng-isolate-scope" style="box-sizing: inherit; outline: none;" compile="step.stepHtml">To view a list of items waiting to print in Windows 10,&nbsp;select the search box next to Start<span>&nbsp;</span><span>&nbsp;</span>on the taskbar and&nbsp;type<span>&nbsp;</span><b style="box-sizing: inherit; font-weight: 700;">devices and printers</b>.</span></p>	</li>	<li class="ng-scope" style="box-sizing: inherit; margin-bottom: 12px;" ng-repeat="step in $ctrl.stepList.steps">	<p class="ng-scope" style="box-sizing: inherit; margin-top: 0px; margin-bottom: 24px; display: inline;"><span class="ng-isolate-scope" style="box-sizing: inherit; outline: none;" compile="step.stepHtml">Select<span>&nbsp;</span><b style="box-sizing: inherit; font-weight: 700;"', N'<div><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>Open the<span>&nbsp;</span></span><a style=''color: rgb(33, 90, 195); text-decoration: none; font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-colo', NULL, 379, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO
INSERT [KnowledgeBase01_Dat].[dbo].[tblRevisionHistory] ([nRecordID], [nRevisionNumber], [nID], [dDate], [dTime], [tName], [tPreviousValue], [tCurrentValue], [tComment], [nModifiedDtsFieldID], [tSourceName], [tSourceIP]) VALUES (20, 6, NULL, CAST(0x0000A88E00000000 AS DateTime), CAST(0xFFFFFFFE0108C66C AS DateTime), N'analyst', N'<div><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>Open the<span>&nbsp;</span></span><a style=''color: rgb(33, 90, 195); text-decoration: none; font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-colo', N'<div><span style=''color: rgb(0, 0, 0); font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;''>Open the<span>&nbsp;</span></span><a style=''color: rgb(33, 90, 195); text-decoration: none; font-family: "Segoe UI", Tahoma, Verdana, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-colo', NULL, 379, N'host86-173-42-38.range86-173.btcentralplus.com', N'86.173.42.38')
GO

UPDATE Users_mdb.dbo.tblOptions SET tValue='column1=1&column2=60&column3=71' WHERE nUserID=4 AND nSetting=115 AND tValue='column1=1&column2=60&column3='
GO
UPDATE Users_mdb.dbo.tblOptions SET tValue='column1=1&column2=59,58&column3=56,66' WHERE nUserID=5 AND nSetting=115 AND tValue='column1=1&column2=59,58&column3='
GO
UPDATE Users_mdb.dbo.tblOptions SET tValue='column1=1&column2=44,68&column3=18,56' WHERE nUserID=42 AND nSetting=115 AND tValue='column1=1&column2=44,54&column3=18,56'
GO

UPDATE HelpDesk01_Dat.dbo.tblDts SET Asset = 467 WHERE nID=11
GO

INSERT [Resources01_Dat].dbo.[tblRoleRes] ([nRoleID], [nResID]) VALUES (12, 42)
GO

UPDATE Resources01_Dat.dbo.tblDts SET Supplier_Seller=98,Asset_Location=Null,[Warranty_Description]='Standard one year',[Warranty_ID]='SR292190-1',[Allocated_to_Department]=637,[Allocated_to_Unit_Division]=564,[Allocated_to_Project]=12,Primary_Owner='martin.west',[Top_Console_User]='martin.west',Location=674,Environment=1,Pool_Responsible=43,Recurring_Costs=0.00 WHERE nID=365
GO

UPDATE Resources01_Dat.dbo.tblDts SET nUserID=NULL WHERE nID=1787 AND nUserID=19
GO
DELETE FROM Resources01_Dat.dbo.tblEmpRes WHERE nResID=1787 AND nEmpID=19
GO

DELETE FROM [Purchases&Agreements01_Dat].dbo.tblDts WHERE nID=1094 AND PO_Number='5345'
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1094, 10, N'-1', 0, NULL, NULL, CAST(0x0000A88F00000000 AS DateTime), CAST(0xFFFFFFFE00C8BE3C AS DateTime), CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE009CE730 AS DateTime), CAST(0xFFFFFFFE00C6BA9C AS DateTime), NULL, NULL, 16, NULL, 42, 4, N'Microsoft Office 2013 YR2', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'INV34512', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(0x0000A6CE00000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, N'PO105345', NULL, NULL, NULL, 80, 19, 17, 1619.0000, 0.0000, 1619.0000, 2, NULL, NULL, N'Cost Center 2', NULL, NULL, NULL, NULL, N'7564', NULL, 1, 1, NULL, 0.0000, 0.0000, 1, NULL, NULL, CAST(0x0000A6CE00000000 AS DateTime), CAST(0x0000A6CE00000000 AS DateTime), CAST(0x0000A6AF00000000 AS DateTime), NULL, NULL, NULL, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO
DELETE FROM [Purchases&Agreements01_Dat].dbo.tblDts WHERE nID=1102 AND PO_Number='4675231'
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1102, 6, N'-1', 0, NULL, NULL, NULL, NULL, CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE00AAE470 AS DateTime), CAST(0xFFFFFFFE00C5FB98 AS DateTime), NULL, NULL, NULL, NULL, 42, 3, N'Microsoft Office 2013', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(0x0000A57C00000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, N'PO467231', NULL, NULL, NULL, 80, NULL, NULL, 450.0000, 0.0000, 450.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 1, NULL, 0.0000, 0.0000, 1, NULL, NULL, CAST(0x0000A57C00000000 AS DateTime), CAST(0x0000A57C00000000 AS DateTime), NULL, NULL, NULL, NULL, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO
DELETE FROM [Purchases&Agreements01_Dat].dbo.tblDts WHERE nID=1096 AND Invoice_Number='4549'
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1096, 7, N'-1', 0, NULL, NULL, NULL, NULL, CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE009E5BD8 AS DateTime), CAST(0xFFFFFFFE00C654A8 AS DateTime), NULL, NULL, 16, NULL, 42, 3, N'Microsoft Office 2013 YR3', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'INV4549', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(0x0000A83B00000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, N'PO839211', NULL, NULL, NULL, 80, 19, 17, 2475.0000, 0.0000, 2475.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'745', NULL, 1, 1, NULL, 0.0000, 0.0000, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO
DELETE FROM [Purchases&Agreements01_Dat].dbo.tblDts WHERE nID=1099 AND Invoice_Number='34512'
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1099, 4, N'-1', 0, NULL, NULL, CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE00A297D4 AS DateTime), CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE00A297D4 AS DateTime), CAST(0xFFFFFFFE00C2AB28 AS DateTime), NULL, NULL, NULL, NULL, 42, 1, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'34512', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, 0.0000, 0.0000, 0.0000, NULL, NULL, 3, NULL, 2, CAST(0x0000A57C00000000 AS DateTime), CAST(0x0000A6EA00000000 AS DateTime), NULL, NULL, NULL, NULL, 2, NULL, 15.0000, 150.0000, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Software Assurance Maintenance', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 419, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO
DELETE FROM [Purchases&Agreements01_Dat].dbo.tblDts WHERE nID=1103
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1103, 3, N'-1', 0, NULL, NULL, CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE00AB1F08 AS DateTime), CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE00AB1F08 AS DateTime), CAST(0xFFFFFFFE00C241B0 AS DateTime), NULL, NULL, NULL, NULL, 42, 1, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, 0.0000, 0.0000, 0.0000, NULL, NULL, 1, NULL, 1, CAST(0x0000A57C00000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, 1, NULL, 150.0000, 1500.0000, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Office 2013 licenses', 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 419, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO
DELETE FROM [Purchases&Agreements01_Dat].dbo.tblDts WHERE nID=1095 AND Invoice_Number='34512'
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1095, 6, N'-1', 0, NULL, NULL, CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE009D4D24 AS DateTime), CAST(0x0000A88F00000000 AS DateTime), CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE009D4D24 AS DateTime), CAST(0xFFFFFFFE00C8BE3C AS DateTime), NULL, NULL, NULL, NULL, 42, 1, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'34512', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8, NULL, NULL, NULL, NULL, 0.0000, 0.0000, 0.0000, NULL, NULL, 3, NULL, 2, CAST(0x0000A6CE00000000 AS DateTime), CAST(0x0000A83B00000000 AS DateTime), NULL, NULL, NULL, NULL, 1, NULL, 178.0000, 1424.0000, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'More licenses for Office 2013', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 419, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO
DELETE FROM [Purchases&Agreements01_Dat].dbo.tblDts WHERE nID=1097 AND Invoice_Number='4549'
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1097, 5, N'-1', 0, NULL, NULL, CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE009EA930 AS DateTime), CAST(0x0000A88F00000000 AS DateTime), CAST(0x0000A85700000000 AS DateTime), CAST(0xFFFFFFFE009EA930 AS DateTime), CAST(0xFFFFFFFE00C58E9C AS DateTime), NULL, NULL, NULL, NULL, 42, 1, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'4549', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12, NULL, NULL, NULL, NULL, 0.0000, 0.0000, 0.0000, NULL, NULL, 3, NULL, 2, CAST(0x0000A83B00000000 AS DateTime), CAST(0x0000A9A800000000 AS DateTime), NULL, NULL, NULL, NULL, 1, NULL, 165.0000, 1980.0000, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'More licenses needed for the new project people', 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 419, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO


INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1144, 5, N'-1', 0, NULL, NULL, NULL, NULL, CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A89600000000 AS DateTime), CAST(0xFFFFFFFE00C308E8 AS DateTime), CAST(0xFFFFFFFE00C633D8 AS DateTime), NULL, NULL, NULL, NULL, 42, 3, N'Microsoft Office 2013', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(0x0000A6EA00000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, N'PO123022', NULL, NULL, NULL, 603, NULL, NULL, 1500.0000, 0.0000, 1500.0000, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 2, 1, NULL, 0.0000, 0.0000, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1145, 2, N'-1', 0, NULL, NULL, NULL, NULL, CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A89600000000 AS DateTime), CAST(0xFFFFFFFE00C35E74 AS DateTime), CAST(0xFFFFFFFE00C3A014 AS DateTime), NULL, NULL, NULL, NULL, 42, 3, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, 0.0000, 0.0000, 0.0000, NULL, NULL, 1, NULL, 1, CAST(0x0000A6EA00000000 AS DateTime), NULL, NULL, NULL, NULL, 2, 1, NULL, 150.0000, 1500.0000, 3, NULL, NULL, NULL, NULL, NULL, NULL, N'OFF2013', NULL, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 419, 507, NULL, NULL, 0, 0, 0, 0, 0, NULL, 1, NULL, NULL, NULL)
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1146, 3, N'-1', 0, NULL, NULL, NULL, NULL, CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A89600000000 AS DateTime), CAST(0xFFFFFFFE00C47FE8 AS DateTime), CAST(0xFFFFFFFE00C4CC14 AS DateTime), NULL, NULL, NULL, NULL, 42, 3, N'Microsoft Office 2013', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(0x0000A85700000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, N'PO920282', NULL, NULL, NULL, 603, NULL, NULL, 540.0000, 0.0000, 540.0000, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 2, 1, NULL, 0.0000, 0.0000, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL)
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblDts] ([nID], [nRevisionNumber], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [dLastUpdateDate], [dSubmittedDate], [dSubmittedTime], [dUpdateTime], [mDetailedDescription], [mWorkaroundDescription], [nOriginatorID], [nPriorityID], [nSubmitterID], [nSubstateID], [tBriefDescription], [nStateID], [Time$Spent$Hours], [Time$Spent$Minutes], [Description$Input], [Resolution], [Activity], [Activity$Log], [Problem$Area], [Estimated$Effort], [Planned$Start$Date], [Planned$End$Date], [Problem$Area$Other], [ComputerName], [nControlledByParent], [dTargetClosureTime], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [dEscalationTimestamp], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [nCumulativePausedTime], [Timeliness_When_Reported], [Timeliness_Through_Resolution], [Survey___Communication_Throughout_Transaction], [Survey___Support_Analyst_Technical_Skills], [Survey___Support_Analyst_Courtesy], [Survey___Comments], [Ticket_Type], [RMA_Status], [RMA_Type], [Invoice], [Power_Supply_Test], [UPS_Tracking_Number], [Work_Perfomed_By], [Resolution_Date], [Accessories_Sent_In], [Data_Backup_Required], [Customer_Induced_Damage], [Unnecessary_Repair], [Asset_Name], [Company_Name], [VAR_Name], [VAR_Contact], [Is_a_Problem_], [Shipping_Priority], [Invoice_Number], [Purchased_Date], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [Actual_Shipping_Date], [Desired_Shipping_Date], [Problem_Resolution_Issue_Number], [Tracking_Number], [Veritas_License], [Problem_Resolution_Summary], [System], [RMA_Problem_Resolution_Summary], [RMA_Problem_Resolution_Details_Log_Internal], [RMA_Problem_Resolution_Details_Internal], [Comments_Log], [Comments], [Root_Cause_Details], [Root_Cause_Details_Log], [Problem_Resolution_Details_Log_External], [Problem_Resolution_Details_External], [Subcomponent], [Business_Contact], [Technical_Contact], [Technical_VAR___OEM_Contact], [Business_VAR___OEM_Contact], [OEM], [Distributor], [System_Serial_Number], [Unit_Serial_Number], [Part_Serial_Number], [Short_Summary], [Ticket_Sub_Type], [Component], [Shipping_Address], [Software_License], [Problem_Resolution_Code], [RMA_Owner], [RMA_State], [RMA_Problem_Resolution_Code], [Ticket_Closed_By], [Desired_Shipping_Method], [Actual_Shipping_Method], [Product_Type], [Resource_Type], [Resource_Will_Expire_On], [Mandatory], [Provisioned], [Authorization_Required], [Has_Been_Utilized], [nUsageType], [Estimated_Duration], [Historical_Duration], [Status], [Estimated_Start_Time], [Estimated_Closure_Time], [Based_On], [Training], [Vendor], [Has_An_Associated_Cost_], [ComputerName_Is_Required_], [Vendor_Is_Required_], [Printer_Name], [Printer_Name_Is_Required_], [Is_Missing_Required_Value], [Open_Role_Allocation], [Complete_Provisioning_By], [Training_Level], [Training_Level_Is_Required_], [Brand], [Model], [Serial_Number], [Barcode_Tag], [Supplier_Seller], [Unit_Price], [Service_Contractor], [Delivery_Date], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [Retired_Date], [Invoice_Date], [License_Vendor], [License_Units], [License_Version], [License_Language], [License_Upgrade], [PO_Number], [Purchased_From], [Quantity], [Base_Resource], [Company], [Sold_to_Person], [Sold_to_Organization], [SubTotal], [Taxes], [Total_with_Tax], [Terms], [Invoice_Contact_Info], [Sub_Type], [Cost_Center], [Expires_], [Start_Date], [End_Date], [Approved_By], [Requisition_Number], [Account_Number], [View_Details], [Line_Item_Number], [Line_Item_Purchase_Order], [Line_Item_Unit_Price], [Line_Item_Total], [Type], [Shipping_Method], [Ship_To], [Ordered_Date], [Received_Date], [Approved_Date], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [Auto_Renewal_Date], [tSID], [dActualIRTDate], [dActualIRTTime], [Auto_Renew_Amount__], [Auto_Renew_Amount], [Asset_Type], [Purchased_For_Department], [Purchased_For_Location], [GL_Account], [Alert_30_Days], [Alert_60_Days], [Alert_90_Days], [Alert_7_Days], [Alert_0_Days], [Review_Date], [Auto_Create_Assets], [Reference_ID], [Process_Pending], [Stakeholders]) VALUES (1147, 1, N'-1', 0, NULL, NULL, NULL, NULL, CAST(0x0000A89600000000 AS DateTime), CAST(0x0000A89600000000 AS DateTime), CAST(0xFFFFFFFE00C4BF30 AS DateTime), CAST(0xFFFFFFFE00C4BF30 AS DateTime), NULL, NULL, NULL, NULL, 42, 3, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 0.0000, 0.0000, 0.0000, NULL, NULL, 1, NULL, 1, CAST(0x0000A85700000000 AS DateTime), NULL, NULL, NULL, NULL, 2, 1, NULL, 180.0000, 540.0000, 3, NULL, NULL, NULL, NULL, NULL, NULL, N'OFF_2013', NULL, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 419, 502, NULL, NULL, 0, 0, 0, 0, 0, NULL, 1, NULL, NULL, NULL)
GO

INSERT [Purchases&Agreements01_Dat].[dbo].[tblLineItem] ([nID], [nRelID]) VALUES (1144, 1145)
GO
INSERT [Purchases&Agreements01_Dat].[dbo].[tblLineItem] ([nID], [nRelID]) VALUES (1146, 1147)
GO

INSERT LicenseManager01_Dat.[dbo].[tblLMPurch] ([nID], [nRelID]) VALUES (10, 1145)
GO
INSERT LicenseManager01_Dat.[dbo].[tblLMPurch] ([nID], [nRelID]) VALUES (10, 1147)
GO

INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (72, NULL, 1207, 29, 2);
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (20, NULL, 1198, 1, 2);
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (20, NULL, 1197, 2, 2);
GO

UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+1 WHERE nViewID=20 AND nFieldID IN(816,1080,993,1023,1022,806,1,32,898,901,627,1091,1092,1093,1133)
GO

INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (20, NULL, 1205, 12, 2);
INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (20, NULL, 1209, 28, 2);
GO

UPDATE censusweb_mdb.dbo.tblView SET nFieldIndex=nFieldIndex+1 WHERE nViewID=18 AND nFieldID IN(84,137,94,93,283,284,2,9)
GO

INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (18, NULL, 299, 18, 2);
GO

INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (20, 1197, 56, N'no', NULL);
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1207, 26, N'Scrap Asset', NULL);
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1207, 27, N'2', NULL);
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (72, 1207, 95, N'fld_switch.htmpl', NULL);
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (20, 1205, 14, N'2', NULL);
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (20, 1205, 60, N'SpanTwoWidthOne', NULL);
GO

INSERT [Licenses_mdb].[dbo].[tblSettings] ([nID], [tValue], [tName], [nType], [tDescription], [tValidationRule], [nCustomAction], [tCACaption], [tCADisplay], [tValueSourceTable]) VALUES (468, N'7', N'Days before lost asset marked lost (retired)', 4, N'Number of days after which assets that have been marked as lost are set to Retired - Lost. Enter 0 to turn off this feature.', NULL, NULL, NULL, NULL, NULL)
GO


INSERT [censusweb_mdb].[dbo].[tblView] ([nViewID], [nTabID], [nFieldID], [nFieldIndex], [nStatus]) VALUES (65, NULL, 865, 12, 2)
GO
INSERT [censusweb_mdb].[dbo].[tblFieldAttribute] ([nViewID], [nFieldID], [nAttributeID], [tAttributeValue], [nStatus]) VALUES (65, 865, 56, N'no', NULL)
GO








