CREATE TABLE [dbo].[BDS_IMPORT]
(
[MA_TAI_SAN] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_TAI_SAN] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MO_TA] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NGUYEN_GIA_TAI_SAN] [decimal] (18, 2) NULL,
[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,
[MA_DV_SU_DUNG] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_DV_SU_DUNG] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DIA_CHI_BDS] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HIEN_TRANG_BDS] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOAI_BDS] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DAI] [decimal] (18, 2) NULL,
[RONG] [decimal] (18, 2) NULL,
[DIEN_TICH_DAT] [decimal] (18, 2) NULL,
[NGUON_GOC_SD] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HINH_THUC_SD] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HINH_THUC_SD_KHAC] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DIEN_TICH_XD] [decimal] (18, 2) NULL,
[SO_TANG] [int] NULL,
[DIEN_TICH_SAN_SD] [decimal] (18, 2) NULL,
[NGAY_MUA_THUE_BDS] [datetime] NULL,
[THOI_HAN_SD] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[THOI_HAN_SD_DEN_NGAY] [datetime] NULL,
[HINH_THUC_BDS] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TINH_TRANG_SD_DAT] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TINH_TRANG_XD] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MUC_DICH_SD_DAT] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CONG_NANG_SD] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KET_CAU_NHA] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HIEN_TRANG_PHAP_LY_TS] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GHI_CHU] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOAI_SO_HUU] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOAI_SO_HUU_KHAC] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CHU_SO_HUU] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_HS_LUU_TRU] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NGAY_CAP_NHAT_BIEN_DONG] [datetime] NULL,
[CAP_NHAT_BIEN_DONG] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[BDS_DI_THUE_KY_THANH_TOAN_IMPORT]'
GO
CREATE TABLE [dbo].[BDS_DI_THUE_KY_THANH_TOAN_IMPORT]
(
[SO_HOP_DONG] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KY_THANH_TOAN] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TU_NGAY] [datetime] NULL,
[DEN_NGAY] [datetime] NULL,
[GIA_THUE] [decimal] (18, 2) NULL,
[TONG_SO_TIEN_KY_THANH_TOA] [decimal] (18, 2) NULL,
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[BDS_DI_THUE_IMPORT]'
GO
CREATE TABLE [dbo].[BDS_DI_THUE_IMPORT]
(
[SO_HOP_DONG] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_DON_VI_QUAN_LY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_DV_QUAN_LY] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_DON_VI_SU_DUNG] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_DV_SU_DUNG] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DIA_CHI] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NGAY_BAT_DAU] [datetime] NULL,
[LAN_GIA_HAN] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NGAY_KET_THUC] [datetime] NULL,
[NGAY_GIA_HAN] [datetime] NULL,
[DIEN_TICH_THUE] [decimal] (18, 2) NULL,
[QUY_MO] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DIEN_TICH_XAY_DUNG] [decimal] (18, 2) NULL,
[KET_CAU] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GHI_CHU] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SO_TIEN_DAT_COC] [decimal] (18, 2) NULL,
[THOI_DIEM_HOAN_TIEN_COC] [datetime] NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[BDS_H_T_TTPL_IMPORT]'
GO
CREATE TABLE [dbo].[BDS_H_T_TTPL_IMPORT]
(
[MA_DON_VI_QUAN_LY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TEN_DV_QUAN_LY] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_DON_VI_SU_DUNG] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TEN_DV_SU_DUNG] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_BDS] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NGAY_MUA] [datetime] NULL,
[DIA_CHI] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DIEN_TICH_DAT] [decimal] (18, 2) NULL,
[DIEN_TICH_XAY_DUNG] [decimal] (18, 2) NULL,
[GT_TS_TREN_DAT] [decimal] (18, 2) NULL,
[GT_QUYEN_SD_DAT] [decimal] (18, 2) NULL,
[GIA_THI_TRUONG] [decimal] (18, 2) NULL,
[HIEN_TRANG] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NGUYEN_NHAN] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CAC_TT_DA_THUC_HIEN] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CAC_TT_TIEP_THEO] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TG_DU_KIEN_HT] [datetime] NULL,
[NGAY_HT_TTPL] [datetime] NULL,
[GHI_CHU] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[QL_TRU_SO_IMPORT]'
GO
CREATE TABLE [dbo].[QL_TRU_SO_IMPORT]
(
[HINH_THUC_SO_HUU] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_TAI_SAN] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[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,
[MA_DV_SU_DUNG] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_DV_SU_DUNG] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SO_HOP_DONG] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_TRU_SO] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DIA_CHI] [nvarchar] (800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TONG_SO_TANG] [int] NULL,
[DIEN_TICH_MAT_SAN] [decimal] (18, 2) NULL,
[TONG_DIEN_TICH_M2] [decimal] (18, 2) NULL,
[DAI] [decimal] (18, 2) NULL,
[RONG] [decimal] (18, 2) NULL,
[DIEN_TICH] [decimal] (18, 2) NULL,
[GIA_THUE_HT_DA_THUE] [decimal] (18, 0) NULL,
[VAT] [int] NULL,
[SO_TIEN_THUE] [decimal] (18, 0) NULL,
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[QL_TRU_SO_DS_TANG_IMPORT]'
GO
CREATE TABLE [dbo].[QL_TRU_SO_DS_TANG_IMPORT]
(
[TEN_TRU_SO] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TANG] [int] NULL,
[DIEN_TICH_TANG] [decimal] (18, 2) NULL,
[DT_DA_SU_DUNG] [decimal] (18, 2) NULL,
[DT_CHO_THUE] [decimal] (18, 2) NULL,
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[DTSD_NOI_BO_IMPORT]'
GO
CREATE TABLE [dbo].[DTSD_NOI_BO_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,
[MA_TRU_SO] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_TRU_SO] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NGAY_BAT_DAU_SD] [datetime] NULL,
[NGAY_DUA_VAO_SD_SAU_CUNG] [datetime] NULL,
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
GO
IF @@ERROR <> 0 SET NOEXEC ON
GO
PRINT N'Creating [dbo].[DTSD_NOI_BO_DT_IMPORT]'
GO
CREATE TABLE [dbo].[DTSD_NOI_BO_DT_IMPORT]
(
[MA_TRU_SO] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_TRU_SO] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TANG] [int] NULL,
[DT_CAN_SU_DUNG] [decimal] (18, 2) NULL,
[MA_DV_CHIU_CHI_PHI] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_DV_CHIU_CHI_PHI] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PHONG_BAN_CHIU_CHI_PHI] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEN_PHONG_BAN_CHIU_CHI_PHI] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MUC_DICH_SU_DUNG] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DON_GIA] [decimal] (18, 0) NULL,
[VAT] [int] NULL,
[KY_THANH_TOAN] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GHI_CHU] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
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
)