INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126348', N'123/2020/HÐVS-M', N'Dịch vụ vệ sinh', N'', N'', N'CMS000001126393', NULL, NULL, N'', N'', N'', CAST(9000000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2020-04-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'Thời gian thực hiện: 6h-8h thứ 2,3,4,5,6
3.000.000/tháng (đã bao gồm VAT)', N'1', NULL, CAST(N'2020-08-18T08:13:32.210' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000427', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126338', N'16/TBHK-2019/BV', N'Hợp đồng dịch vụ trưng bày cây cảnh', N'', N'', N'CMS000001126331', NULL, NULL, N'', N'', N'', CAST(1050000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2019-12-15T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'Cây nội thất: 7 cây*150.000 = 1.050.000/tháng', N'1', NULL, CAST(N'2020-08-18T08:13:32.177' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000388', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126339', N'870/ÐV-NHBV_CNN', N'Thuê dịch vụ bảo vệ tại CN NSG và các PGD trực thuộc', N'', N'', N'CMS000001126333', NULL, NULL, N'', N'', N'', CAST(95876000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2020-07-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'- CN Nam Sài Gòn: 22.720.000/tháng
- PGD PMH: 12.800.000/tháng
- PGD Hậu Giang: 27.920.000/tháng
- PGD Nguyễn Trãi: 15.120.000/tháng
- PGD Q.10: 7.600.000/tháng
(chưa bao gồm VAT)', N'1', NULL, CAST(N'2020-08-18T08:13:32.180' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000388', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126340', N'07864/HÐ-TN', N'Thuê nhà 423 Cộng Hóa, P.15, Q.Tân Bình', N'', N'', N'CMS000001126355', NULL, NULL, N'', N'', N'', CAST(258000000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2017-09-05T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'- 01/10/2017-30/09/2019: 88.000.000/tháng
- 01/10/2019-30/09/2021: 96.800.000
- 01/07/2020-30/09/2020: 86.000.000
- 01/10/2021-06/09/2023: 106.480.000
- đặt cọc: 264.000.000 (TK: 359201040)
PLHĐ 01/2020/PLHĐ-BVB-PGDTB ngày 09/01/2020
07A/2020/PLHĐ-BVB-PGD', N'1', NULL, CAST(N'2020-08-18T08:13:32.183' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000425', 0, NULL, N'Hàng quý', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126341', N'0107/2019HÐTM-G', N'Thuê máy photo', N'', N'', N'CMS000001126334', NULL, NULL, N'', N'', N'', CAST(825000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2019-07-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'- Dưới 5.000 bản: 750.000/tháng
- Từ 5.000 bản trở lên: 110/bản (chưa bao gồm VAT)
Loại máy: Toshiba 452/453
Seri: CGB850574
PL 01 ngày 01/07/2020', N'1', NULL, CAST(N'2020-08-18T08:13:32.190' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000425', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126342', N'002/2019/HÐVS-V', N'Dịch vụ vệ sinh', N'', N'', N'CMS000001126351', NULL, NULL, N'', N'', N'', CAST(2833600 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2020-01-02T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'Thời gian thực hiện: 17h-19h từ thứ 2 đến thứ 6
56.000/giờ (chưa bao gồm VAT)', N'1', NULL, CAST(N'2020-08-18T08:13:32.193' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000425', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126343', N'25483/HÐ-TN', N'Thuê nhà 1339-1341 Phan Văn Trị, P.10, Q.Gò Vấp', N'', N'', N'CMS000001126357', NULL, NULL, N'', N'', N'', CAST(231000000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2017-11-02T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'- 01/12/2017-30/11/2019: 70.000.000/tháng
- 01/12/2019-30/11/2021: 77.000.000/tháng
- 01/12/2021-02/11/2022: 84.700.000/tháng
- Đặc cọc: 210.000.000 (TK: 359201044_001)', N'1', NULL, CAST(N'2020-08-18T08:13:32.193' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000426', 0, NULL, N'3 tháng/l?n', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126344', N'044/HDKH - 2020', N'Dịch vụ vệ sinh', N'', N'', N'CMS000001126351', NULL, NULL, N'', N'', N'', CAST(2833600 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2020-05-05T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'Nhân viên: Hương
Thời gian thực hiện: 17h-19h thứ 2,3,4,5,6
56.000/giờ (chưa bao gồm VAT)', N'1', NULL, CAST(N'2020-08-18T08:13:32.200' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000426', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126345', N'1006/2019HÐTM-G', N'Thuê máy photo', N'', N'', N'CMS000001126334', NULL, NULL, N'', N'', N'', CAST(825000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2019-06-10T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'Loại máy: Toshiba 283, S/N: CGC732920
- Dưới 5.000 bản: 750.000/tháng
- Từ 5.000 bản trở lên: 110/bản (chưa bao gồm VAT)
- Thông tin xuất hóa đơn: CN Tây Sài Gòn
PL 01 ngày 10/06/2020', N'1', NULL, CAST(N'2020-08-18T08:13:32.203' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000426', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126346', N'0106/2019/HÐTM-', N'Thuê máy photo', N'', N'', N'CMS000001126334', NULL, NULL, N'', N'', N'', CAST(825000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2019-06-01T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'- Dưới 5.000 bản: 750.000/tháng
- Từ 5.000 bản trở lên: 110/bản (chưa bao gồm VAT)
Loại máy: Toshiba 306 (S/N: C2KC69642)
PL01 ngày 12/03/2020
PL02 ngày 01/06/2020', N'1', NULL, CAST(N'2020-08-18T08:13:32.207' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000427', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126347', N'02567/HÐ-TN', N'Thuê nhà 172A, Phan Đăng lưu, P.3, Q.PN', N'', N'', N'CMS000001126384', NULL, NULL, N'', N'', N'', CAST(683333334 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2020-03-20T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'- Đặt cọc: 615.000.000
- 2 năm đầu: 205.000.000/tháng (chưa bao gồm thuế, thuế do bên thuê chịu)
- tiền thuê điều chỉnh 2 năm/lần, mỗi lần tăng 10%
Tir62n thuê tính từ 15/05/2020', N'1', NULL, CAST(N'2020-08-18T08:13:32.207' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000427', 0, NULL, N'3 tháng/l?n', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126349', N'PN37221', N'Hợp đồng dịch vụ cấp nước tại 172A Phan Đăng Lưu, P.3, Q.PN TPHCM', N'', N'', N'CMS000001126363', NULL, NULL, N'', N'', N'', CAST(25683602 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2020-05-18T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'SDB: 1203 132 5772', N'1', NULL, CAST(N'2020-08-18T08:13:32.217' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000427', 0, NULL, N'Hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126350', N'02/HÐ-TN', N'Hợp đồng thuê QSDĐ Ấp Thới Thuận A, Thị trấn Thới Lai, Huyện Thới Lai, TP Cần Thơ (PGD Thới Lai)', N'', N'', N'CMS000001126406', NULL, NULL, N'', N'', N'', CAST(180000000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2018-01-12T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'23/03/2018 - 22/03/2019: 30.000.000đ/tháng.
23/03/2019 - 22/03/2020: 31.500.000đ/tháng.
23/03/2020 - 22/03/2021: 33.075.000đ/tháng.
23/03/2021 - 22/03/2022: 34.728.750đ/tháng.
23/03/2022 - 22/03/2023: 36.465.188đ/tháng.
(Giá đã bao gồm VAT, thuế TNCN)', N'1', NULL, CAST(N'2020-08-18T08:13:32.217' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000392', 0, NULL, N'06 tháng/l?n', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126351', N'01/2017/HÐ-TN', N'Hợp đồng thuê nhà 307 Nguyễn Văn Cừ, Phường An Hòa, Quận Ninh Kiều, TP.Cần Thơ (PGD Ninh Kiều)', N'', N'', N'CMS000001126407', NULL, NULL, N'', N'', N'', CAST(198000000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2017-10-20T00:00:00.000' AS DateTime), NULL, NULL, NULL, N'15/01/2018 - 14/12/2020: 33.000.000đ/tháng.
15/12/2020 - 14/12/2021: 37.950.000đ/tháng.
15/12/2021 - 14/12/2022: 39.847.500đ/tháng.
(Giá đã bao gồm VAT, thuế TNCN)', N'1', NULL, CAST(N'2020-08-18T08:13:32.220' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000392', 0, NULL, N'06 tháng/l?n', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126352', NULL, N'Hợp đồng tiền nước', N'', N'', N'CMS000001126442', NULL, NULL, N'', N'', N'', CAST(831422 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'1', NULL, CAST(N'2020-08-18T08:13:32.223' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000391', 0, NULL, N'hàng tháng', NULL)
INSERT [dbo].[TR_CONTRACT] ([CONTRACT_ID], [CONTRACT_CODE], [CONTRACT_NAME], [CONTRACT_TYPE], [BID_ID], [SUP_ID], [TOTAL_AMT], [DELIVERY_DT], [FORM1], [VOUCHER_ID1], [BANK1], [AMOUNT1], [EXP_DT1], [RATE1], [FORM2], [VOUCHER_ID2], [BANK2], [AMOUNT2], [EXP_DT2], [RATE2], [REQ_DOC_ID], [REQ_DOC_CONTENT], [APPROVE_VALUE], [SIGN_DT], [CONSTRUCT_PROGRESS], [START_DT], [END_DT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [IS_PARENT], [REQUEST_ID], [CONTRACT_PARENT], [IS_CLOSED], [CONT_TYPE], [CUST_ID], [BRANCH_ID], [EXP_CONTRACT], [DEPOSIT_AMT], [TYPE_PERIOD], [DEPOSIT_NOTE]) VALUES (N'IPCT00001126353', NULL, N'Hợp đồng thuê nhà', N'', N'', N'CMS000001126445', NULL, NULL, N'', N'', N'', CAST(480000000 AS Decimal(18, 0)), NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'1', NULL, CAST(N'2020-08-18T08:13:32.227' AS DateTime), N'A', NULL, NULL, N'', N'', N'', N'', N'DK', N'', N'BRN000000000390', 0, NULL, N'6 tháng', NULL)
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126339', N'IPCT00001126338', N'HH0000000112190', N'003', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126340', N'IPCT00001126339', N'HH0000000112192', N'003', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126341', N'IPCT00001126340', N'HH0000000112102', N'008', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126342', N'IPCT00001126341', N'HH0000000112191', N'008', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126343', N'IPCT00001126342', N'HH0000000112186', N'008', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126344', N'IPCT00001126343', N'HH0000000112102', N'009', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126345', N'IPCT00001126344', N'HH0000000112186', N'009', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126346', N'IPCT00001126345', N'HH0000000112191', N'009', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126347', N'IPCT00001126346', N'HH0000000112191', N'010', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126348', N'IPCT00001126347', N'HH0000000112102', N'010', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126349', N'IPCT00001126348', N'HH0000000112186', N'010', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126350', N'IPCT00001126349', N'HH0000000112225', N'010', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126351', N'IPCT00001126350', N'HH0000000112102', N'006', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126352', N'IPCT00001126351', N'HH0000000112102', N'006', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126353', N'IPCT00001126352', N'HH0000000112225', N'005', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')
INSERT [dbo].[TR_CONTRACT_DT] ([CD_ID], [CONTRACT_ID], [GOODS_ID], [UNIT_ID], [QUANTITY], [PRICE], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [GD_NAME_REAL], [QUANTITY_USE], [RECURRING], [UNIT_NAME_REAL]) VALUES (N'TRCD00001126354', N'IPCT00001126353', N'HH0000000112102', N'004', CAST(0 AS Decimal(18, 0)), CAST(0 AS Decimal(18, 0)), N'', N'1', NULL, NULL, N'A', NULL, NULL, N'', NULL, N'', N'CMU000000000047')