/*
Run this script on:

        DESKTOP-RQSO948\DEV.VCCB_AMS    -  This database will be modified

to synchronize it with:

        118.69.72.241,5036.gAMSPro_BVB_v3_FINAL

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

Script created by SQL Compare version 13.7.7.10021 from Red Gate Software Ltd at 16/01/2023 4:15:05 PM

*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
SET XACT_ABORT ON
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[TR_REQ_KPI]'
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating primary key [PK__TR_REQ_K__3214EC2720D18873] on [dbo].[TR_REQ_KPI]'
GO
ALTER TABLE [dbo].[TR_REQ_KPI] ADD CONSTRAINT [PK__TR_REQ_K__3214EC2720D18873] PRIMARY KEY CLUSTERED  ([ID])
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[DT_KHACH_THUE_IMPORT]'
GO
CREATE TABLE [dbo].[DT_KHACH_THUE_IMPORT]
(
[MA_DV_TAO] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_DV_TAO] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SO_HOP_DONG] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_TRU_SO] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NGAY_GIA_HAN_HOP_DONG] [datetime] NULL,
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VAT] [int] NULL,
[SO_TIEN_DAT_COC] [decimal] (18, 2) NULL,
[NGAY_DINH_KY_THANH_TOAN] [datetime] NULL,
[LICH_THANH_TOAN] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[DT_KHACH_THUE_DT_IMPORT]'
GO
CREATE TABLE [dbo].[DT_KHACH_THUE_DT_IMPORT]
(
[TEN_TRU_SO] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TANG] [int] NULL,
[DT_KHACH_HANG_THUE] [decimal] (18, 2) NULL,
[DON_GIA] [decimal] (18, 0) NULL,
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
COMMIT TRANSACTION
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
SET NOEXEC OFF