/*
Run this script on:

remote.minovais.com,1442.MinovaES_Bank_Kalteng_Dev    -  This database will be modified

to synchronize it with:

45.251.75.66.MinovaES_Demo

You are recommended to back up your database before running this script

Script created by SQL Data Compare version 11.1.3 from Red Gate Software Ltd at 20/06/2022 14.52.26

*/
		
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
SET DATEFORMAT YMD
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)

PRINT(N'Delete rows from [dbo].[PCMEPRPTSELECTION]')
DELETE FROM [dbo].[PCMEPRPTSELECTION] WHERE [ReportID]='1510002' AND [FieldName]='Tahun'
PRINT(N'Operation applied to 1 rows out of 33')

PRINT(N'Add rows to [dbo].[PCMEPRPTCATALOG]')
INSERT INTO [dbo].[PCMEPRPTCATALOG] ([ReportID], [MenuID], [StoreName], [RdlName], [ReportSourceType], [HeaderTitle], [FooterTitle], [ReportLayout], [Notes], [CreateBy], [CreateDate], [ChangeBy], [ChangeDate]) VALUES ('1510003', 'BUR04', '', 'PRPTBUACTCOM', '1', 'Budget & Actual Comparison', 'Budget & Actual Comparison', 'R001', 'Budget & Actual Comparison', 'minovais', '20160606095829', 'minovais', '20160606095829')
PRINT(N'Operation applied to 1 rows out of 18')

PRINT(N'Add rows to [dbo].[PCMEPRPTSELECTION]')
INSERT INTO [dbo].[PCMEPRPTSELECTION] ([ReportID], [FieldName], [Sequence], [SelectionType], [ColumnNo], [Description], [Required], [IsHidden], [FieldRef], [DefaultValue], [FormatRef], [SearchType], [TableRef], [TriggerCombo], [SelectFunction], [FixedValue], [IsActive], [Notes], [CreateBy], [CreateDate], [ChangeBy], [ChangeDate], [SearchFunction], [ParamCombo], [ReadOnly], [LookupFunction]) VALUES ('1510002', 'Period', 1, '1', 1, 'Period', '1', '0', 'PERIOD', '', 'monthpicker', '', '', '', '', '', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[PCMEPRPTSELECTION] ([ReportID], [FieldName], [Sequence], [SelectionType], [ColumnNo], [Description], [Required], [IsHidden], [FieldRef], [DefaultValue], [FormatRef], [SearchType], [TableRef], [TriggerCombo], [SelectFunction], [FixedValue], [IsActive], [Notes], [CreateBy], [CreateDate], [ChangeBy], [ChangeDate], [SearchFunction], [ParamCombo], [ReadOnly], [LookupFunction]) VALUES ('1510003', 'CostCenter', 1, '1', 1, 'CostCenter', '0', '0', 'CC', '00000043', NULL, '3', 'PHROM0001', NULL, '', NULL, '1', NULL, NULL, NULL, NULL, NULL, 'CG-CG-CC', 'ObjectClass[=]CC', NULL, NULL)
INSERT INTO [dbo].[PCMEPRPTSELECTION] ([ReportID], [FieldName], [Sequence], [SelectionType], [ColumnNo], [Description], [Required], [IsHidden], [FieldRef], [DefaultValue], [FormatRef], [SearchType], [TableRef], [TriggerCombo], [SelectFunction], [FixedValue], [IsActive], [Notes], [CreateBy], [CreateDate], [ChangeBy], [ChangeDate], [SearchFunction], [ParamCombo], [ReadOnly], [LookupFunction]) VALUES ('1510003', 'key1', 4, '1', 1, 'Time', '1', '1', 'TIME', '', NULL, '', '', '', '1 = 1510004', '', '1', '', 'minovais', '2.01606E+13', 'minovais', '2.01606E+13', NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[PCMEPRPTSELECTION] ([ReportID], [FieldName], [Sequence], [SelectionType], [ColumnNo], [Description], [Required], [IsHidden], [FieldRef], [DefaultValue], [FormatRef], [SearchType], [TableRef], [TriggerCombo], [SelectFunction], [FixedValue], [IsActive], [Notes], [CreateBy], [CreateDate], [ChangeBy], [ChangeDate], [SearchFunction], [ParamCombo], [ReadOnly], [LookupFunction]) VALUES ('1510003', 'key2', 4, '1', 1, 'Time', '1', '1', 'TIME', '', NULL, '', '', '', '', '', '1', '', 'minovais', '2.01606E+13', 'minovais', '2.01606E+13', NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[PCMEPRPTSELECTION] ([ReportID], [FieldName], [Sequence], [SelectionType], [ColumnNo], [Description], [Required], [IsHidden], [FieldRef], [DefaultValue], [FormatRef], [SearchType], [TableRef], [TriggerCombo], [SelectFunction], [FixedValue], [IsActive], [Notes], [CreateBy], [CreateDate], [ChangeBy], [ChangeDate], [SearchFunction], [ParamCombo], [ReadOnly], [LookupFunction]) VALUES ('1510003', 'Period', 2, '1', 1, 'Period', '1', '0', 'PERIOD', '2017', '', '', '', '', NULL, '2016=2016||2017=2017||2018=2018', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[PCMEPRPTSELECTION] ([ReportID], [FieldName], [Sequence], [SelectionType], [ColumnNo], [Description], [Required], [IsHidden], [FieldRef], [DefaultValue], [FormatRef], [SearchType], [TableRef], [TriggerCombo], [SelectFunction], [FixedValue], [IsActive], [Notes], [CreateBy], [CreateDate], [ChangeBy], [ChangeDate], [SearchFunction], [ParamCombo], [ReadOnly], [LookupFunction]) VALUES ('1510003', 'Scenario', 4, '1', 1, 'Scenario', '1', '0', 'SCENARIO', '0000000001', NULL, '0', 'PHRBUSCENARIO', '', '', '', '1', '', 'minovais', '2.01606E+13', 'minovais', '2.01606E+13', NULL, NULL, NULL, NULL)
INSERT INTO [dbo].[PCMEPRPTSELECTION] ([ReportID], [FieldName], [Sequence], [SelectionType], [ColumnNo], [Description], [Required], [IsHidden], [FieldRef], [DefaultValue], [FormatRef], [SearchType], [TableRef], [TriggerCombo], [SelectFunction], [FixedValue], [IsActive], [Notes], [CreateBy], [CreateDate], [ChangeBy], [ChangeDate], [SearchFunction], [ParamCombo], [ReadOnly], [LookupFunction]) VALUES ('1510003', 'Year', 3, '1', 1, 'Year', '1', '0', 'YEAR', '2018', NULL, '', '', '', '', '2016=2016||2017=2017||2018=2018', '1', '', 'minovais', '2.01606E+13', 'minovais', '2.01606E+13', NULL, NULL, NULL, NULL)
PRINT(N'Operation applied to 7 rows out of 459')
COMMIT TRANSACTION
GO