USE [Purchases&Agreements01_Dat]
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1058 and Line_Item_Description=N'Office 365 2015')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Office 365 2017' WHERE [nID]=1058
END 
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1073 and Line_Item_Description=N'Adobe Photoshop Maintenance')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Adobe Photoshop Maintenance 2014' WHERE [nID]=1073
END
GO
	
IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1074 and Line_Item_Description=N'Adobe Photoshop Maintenance')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Adobe Photoshop Maintenance 2015' WHERE [nID]=1074
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1075 and Line_Item_Description=N'Adobe Photoshop Maintenance')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Adobe Photoshop Maintenance 2016' WHERE [nID]=1075
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1093 and nSubstateID = 4)
BEGIN
	UPDATE [dbo].[tblDts] SET [nSubstateID]=3 WHERE [nID]=1093
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1100 and nSubstateID = 4 and nStateID = 2)
BEGIN
	UPDATE [dbo].[tblDts] SET [dClosedDate]=NULL, [dClosedTime]=NULL, [nSubstateID]=3, [nStateID]=1 WHERE [nID]=1100
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1101 and Line_Item_Status = 4)
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Status]=3 WHERE [nID]=1101
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1108 and nSubstateID=4 and nStateID=2)
BEGIN
	UPDATE [dbo].[tblDts] SET [dClosedDate]=NULL, [dClosedTime]=NULL, [nSubstateID]=3, [nStateID]=1 WHERE [nID]=1108
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1109 and Line_Item_Status=4)
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Status]=3 WHERE [nID]=1109
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1110 and tBriefDescription=N'AutoCAD 2014')
BEGIN
	UPDATE [dbo].[tblDts] SET [tBriefDescription]=N'AutoCAD 2016' WHERE [nID]=1110
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1117 and tBriefDescription=N'Office 365 2015')
BEGIN
	UPDATE [dbo].[tblDts] SET [tBriefDescription]=N'Office 365 2017' WHERE [nID]=1117
END
GO


IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1118 and tBriefDescription=N'Office 365 2016' and nSubstateID=4 and nStateID=2)
BEGIN
	UPDATE [dbo].[tblDts] SET [dClosedDate]=NULL, [dClosedTime]=NULL, [nSubstateID]=3, [tBriefDescription]=N'Microsoft Office 365 2018', [nStateID]=1 WHERE [nID]=1118
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1119 and Line_Item_Description=N'Office 365 2016' and Line_Item_Status=4)
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Office 365 2018', [Line_Item_Status]=3 WHERE [nID]=1119
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1124 and tBriefDescription=N'Windows 7 Maint 2014')
BEGIN
	UPDATE [dbo].[tblDts] SET [tBriefDescription]=N'Windows 7 Maint 2016' WHERE [nID]=1124
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1125 and tBriefDescription=N'Windows 7 Maint 2015')
BEGIN
	UPDATE [dbo].[tblDts] SET [tBriefDescription]=N'Windows 7 Maint 2017' WHERE [nID]=1125
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1126 and tBriefDescription=N'PC-Duo Host 2016')
BEGIN
	UPDATE [dbo].[tblDts] SET [tBriefDescription]=N'PC-Duo Host 2018' WHERE [nID]=1126
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1127 and Line_Item_Description=N'PC-Duo Maintenance 2016-2017')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'PC-Duo Maintenance 2018-2019' WHERE [nID]=1127
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1128 and tBriefDescription=N'PC-Duo Master 2016')
BEGIN
	UPDATE [dbo].[tblDts] SET [tBriefDescription]=N'PC-Duo Master 2018' WHERE [nID]=1128
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1129 and Line_Item_Description=N'Maintenance 2016-2017')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Maintenance 2018-2019' WHERE [nID]=1129
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1133 and Line_Item_Description=N'Maintenance 2016')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Maintenance 2018' WHERE [nID]=1133
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1134 and tBriefDescription=N'Vector Issue Tracker Maint 2017' and nSubstateID=4 and nStateID=2)
BEGIN
	UPDATE [dbo].[tblDts] SET [dClosedDate]=NULL, [dClosedTime]=NULL, [nSubstateID]=3, [tBriefDescription]=N'Vector Issue Tracker Maint 2019', [nStateID]=1 WHERE [nID]=1134
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1135 and Line_Item_Description=N'Vector Issue Tracker 2017')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Vector Issue Tracker 2019' WHERE [nID]=1135
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1139 and tBriefDescription=N'Adobe Photoshop CS6 Maintenance 2017')
BEGIN
	UPDATE [dbo].[tblDts] SET [tBriefDescription]=N'Adobe Photoshop CS6 Maintenance 2018' WHERE [nID]=1139
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1142 and Line_Item_Description=N'Maintenance 2017-2018')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'Maintenance 2019-2020' WHERE [nID]=1142
END
GO

IF EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1143 and Line_Item_Description=N'PC-Duo Maintenance 2017-2018')
BEGIN
	UPDATE [dbo].[tblDts] SET [Line_Item_Description]=N'PC-Duo Maintenance 2019-2020' WHERE [nID]=1143
END
GO

IF NOT EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1148)
BEGIN
	INSERT INTO [dbo].[tblDts] ([nID], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [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], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [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], [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], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [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], [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], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [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_], [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], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [tSID], [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], [dLastAssetsValidation], [Purchased_for_Project], [License_Server]) VALUES (1148, N'-1', 0, NULL, NULL, '20190610 11:52:46.000', '20190610 11:52:46.000', NULL, NULL, NULL, NULL, 1, 4, N'Adobe Photoshop CS6 Mainenance 2014', 2, 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, 5, 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, N'4512', NULL, NULL, NULL, NULL, NULL, NULL, 2275.0000, 0.0000, 2275.0000, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 2, NULL, NULL, 0.0000, 0.0000, 1, NULL, NULL, NULL, NULL, NULL, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL)
	INSERT INTO [dbo].[tblLineItem] ([nID], [nRelID]) VALUES (1148, 1073)
END
GO

IF NOT EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1149)
BEGIN
	INSERT INTO [dbo].[tblDts] ([nID], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [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], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [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], [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], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [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], [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], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [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_], [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], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [tSID], [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], [dLastAssetsValidation], [Purchased_for_Project], [License_Server]) VALUES (1149, N'-1', 0, NULL, NULL, '20190610 12:11:26.000', '20190610 12:11:26.000', NULL, NULL, NULL, NULL, 1, 4, N'Adobe Photoshop CS6 Maintenance 2015', 2, 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, 5, 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, N'4865', NULL, NULL, NULL, NULL, NULL, NULL, 2275.0000, 0.0000, 2275.0000, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 2, NULL, NULL, 0.0000, 0.0000, 1, NULL, NULL, NULL, NULL, NULL, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL)
	INSERT INTO [dbo].[tblLineItem] ([nID], [nRelID]) VALUES (1149, 1074)
END
GO

IF NOT EXISTS (SELECT nID FROM [tblDts] WHERE nID = 1150)
BEGIN
	INSERT INTO [dbo].[tblDts] ([nID], [tShowInSummary], [nUserID], [dAssignedDate], [dAssignedTime], [dClosedDate], [dClosedTime], [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], [nEscalationLevel], [nServiceTypeID], [dTargetIRT], [nAssociatedSLA], [nEscalationOn], [nSeverityID], [nSource], [nAddToKnowledgeBase], [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], [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], [Item_Number___Serial_Number], [Memory_Test], [Hard_Drive_Test], [Burn_In_Test], [Network_Port_Test], [Audio_Port_Test], [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], [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], [Depreciation_Scheme], [Warranty_Until], [Expected_Life], [Salvage_Value], [Invoice_Reference], [Rest_Value], [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_], [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], [Software_Asset], [Line_Item], [Line_Item_Description], [Line_Item_Status], [Auto_Renew], [Auto_Renewal_Interval], [tSID], [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], [dLastAssetsValidation], [Purchased_for_Project], [License_Server]) VALUES (1150, N'-1', 0, NULL, NULL, '20190610 12:12:10.000', '20190610 12:12:10.000', NULL, NULL, NULL, NULL, 1, 4, N'Adobe Photoshop CS6 Maintenance 2016', 2, 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, 5, 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, NULL, NULL, 2275.0000, 0.0000, 2275.0000, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 2, NULL, NULL, 0.0000, 0.0000, 1, NULL, NULL, NULL, NULL, NULL, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL)
	INSERT INTO [dbo].[tblLineItem] ([nID], [nRelID]) VALUES (1150, 1075)
END
GO
