DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

INSERT INTO [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'TRCI00001127267',N'260.2020/HÐKT/BK6',N'HỢP ĐỒNG CUNG CẤP DỊCH VỤ BẢO TRÌ PHẦN MỀM THUẾ ĐIỆN TỬ',N'1',NULL,N'CMS000001126240',161000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100071',NULL,0,NULL,0,NULL,NULL,N'',N'1',NULL,N'Mar 27 2020 12:00AM',N'A',NULL,NULL,NULL,N'TRRDI0000100071',NULL,NULL,N'MS',NULL,NULL,NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127268',N'06/SRV/VCCB-MICROTEC/010420',N'HỢP ĐỒNG CUNG CẤP DỊCH VỤ BẢO TRÌ THƯỜNG XUYÊN HỆ THỐNG CÔNG NGHỆ THÔNG TIN ATM NCR',N'1',NULL,N'CMS000001126282',3020160000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100081',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Apr  1 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100081',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127269',N'06042020/HÐKT/VCCB-MKG',N'HỢP ĐỒNG CUNG CẤP THIẾT BỊ',N'1',NULL,N'CMS000001126305',748000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100080',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Apr 29 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100080',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127270',N'UNIT/BVB-20200608.1',N'HỢP ĐỒNG DỊCH VỤ HỖ TRỢ SẢN XUẤT PHẦN MỀM',N'1',NULL,N'CMS000001126273',1472000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100076',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Jun  8 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100076',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127271',N'UNIT/BVB-20200601.1',N'HỢP ĐỒNG DỊCH VỤ HỖ TRỢ SẢN XUẤT PHẦN MỀM',N'1',NULL,N'CMS000001126273',791000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100077',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Jun 29 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100077',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127272',N'2020.250/HÐKT/BK6',N'HỢP ĐỒNG TRIỂN KHAI NÂNG CẤP CHO PHẦN MỀM LOCAL PAYMENT THEO CHUẨN TRAO ĐỔI DỮ LIỆU IBPS v2.5',N'1',NULL,N'CMS000001126240',243675000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100087',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Aug  3 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100087',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127273',N'2020.259/HÐKT/BK6',N'HỢP ĐỒNG CUNG CẤP DỊCH VỤ BẢO TRÌ PHẦN MỀM THU NGÂN SÁCH NHÀ NƯỚC (TCS)',N'1',NULL,N'CMS000001126280',310000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100072',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100072',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127274',N'20/CSG/FSI/07/0044',N'HỢP ĐỒNG MUA THIẾT BỊ',N'1',NULL,N'CMS000001126316',179135000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100085',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Jul 27 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100085',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127275',N'000516/2020/HO/FSI3',N'HỢP ĐỒNG CUNG CẤP DỊCH VỤ',N'1',NULL,N'CMS000001126238',857340000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100070',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Jun 23 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100070',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127276',N'010720A.GCP/HDKT',N'HỢP ĐỒNG DỊCH VỤ',N'1',NULL,N'CMS000001126314',108400000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100073',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',NULL,N'A',N'phuongtln1',N'Jan  7 2020 12:00AM',NULL,N'TRRDI0000100073',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127251',N'2019.524/HDKT/BK6',N'Hợp đồng cung cấp dịch vụ',N'1',NULL,N'CMS000001126280',542895400,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100055',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Dec 13 2019 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100055',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127252',N'#CL-13/09/19-VIETCAPITAL-UX.UI',N'Hợp đồng cung ứng dịch vụ',N'1',NULL,N'CMS000001126230',1257722400,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100056',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Oct 14 2019 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100056',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127253',N'01/BVB-MCS/Napas/112019',N'Hợp đồng cung cấp dịch vụ',N'1',NULL,N'CMS000001126301',420000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100057',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Nov 18 2019 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100057',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127254',N'05/SRV/VCCB-MICROTEC/010319',N'Hợp đồng cung cấp dịch vụ bảo trì thường xuyên hệ thống công nghệ thông tin ATM NCR',N'1',NULL,N'CMS000001126282',2533960000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100058',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Mar 21 2019 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100058',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127255',N'11102019/HÐKT/CLICK-NHBV',N'Hợp Đồng Dịch Vụ',N'1',NULL,N'CMS000001126272',1603744240,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100060',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Oct 11 2019 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100060',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127256',N'432020/HDKT/SV-VCCB',N'HỢP ĐỒNG DỊCH VỤ',N'1',NULL,N'CMS000001126311',1395000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100062',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Apr 27 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100062',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127257',N'20/CSG/FSI/05/0038',N'HỢP ĐỒNG DỊCH VỤ',N'1',NULL,N'CMS000001126316',1379645500,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100063',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'May 27 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100063',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127258',N'20/CSG/FSI/05/0032',N'HỢP ĐỒNG DỊCH VỤ',N'1',NULL,N'CMS000001126316',861300000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100064',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'May 21 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100064',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127259',N'20/CSG/FSI/05/004',N'HỢP ĐỒNG DỊCH VỤ',N'1',NULL,N'CMS000001126316',2239464700,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100065',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100065',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127260',N'20/CSG/FSI/05/0029',N'HỢP ĐỒNG DỊCH VỤ',N'1',NULL,N'CMS000001126316',1339800000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100066',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'May 18 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100066',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127261',N'2020.135/HÐKT/BK6',N'HỢP ĐỒNG DỊCH VỤ BẢO TRÌ PHẦN MỀM CỦA HÃNG ORACLE',N'1',NULL,N'CMS000001126280',11600000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100067',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'May  7 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100067',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127262',N'20/CSG/FSI/05/0006',N'HỢP ĐỒNG DỊCH VỤ',N'1',NULL,N'CMS000001126316',2859781835,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100068',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100068',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127263',N'20/CSG/FSI/05/0007',N'HỢP ĐỒNG DỊCH VỤ',N'1',NULL,N'CMS000001126316',5892457300,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100069',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100069',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127264',N'178.2020/HÐKT/BK6',N'HỢP ĐỒNG CUNG CẤP DỊCH VỤ BẢO TRÌ PHẦN MỀM BÁO CÁO NGÂN HÀNG NHÀ NƯỚC SBRS',N'1',NULL,N'CMS000001126240',282366000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100071',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Jun 15 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100071',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127265',N'GMC20060B0',N'HỢP ĐỒNG BẢO TRÌ HỆ THỐNG PHẦN MÊM QUẢN LÝ NHÂN SỰ VÀ TIỀN LƯƠNG FPT.IHRP',N'1',NULL,N'CMS000001126240',98442750,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100071',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Dec 31 2019 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100071',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCI00001127266',N'2020.115/HÐKT/BK6',N'HỢP ĐỒNG BẢO TRÌ PHẦN MỀM HỆ THỐNG TRUNG TÂM THANH TOÁN',N'1',NULL,N'CMS000001126240',166521000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0000100071',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'tuyenlt',N'Mar 27 2020 12:00AM',N'A',N'phuongtln1',NULL,NULL,N'TRRDI0000100071',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [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'TRCDI0001127282',N'TRCI00001127251',N'HH0000000112041',N'0690900',1,542895400,N'',N'1',N'tuyenlt',N'Dec 13 2019 12:00AM',N'U',NULL,NULL,N'Bảo trì phần cứng và phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127283',N'TRCI00001127252',N'HH0000000112076',N'0690013',1,1257722400,N'',N'1',N'tuyenlt',N'Oct 14 2019 12:00AM',N'U',NULL,NULL,N'Dịch vụ CNTT khác',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127284',N'TRCI00001127253',N'HH0000000112038',N'0690900',1,420000000,N'',N'1',N'tuyenlt',N'Nov 18 2019 12:00AM',N'U',NULL,NULL,N'Nâng cấp phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127285',N'TRCI00001127254',N'HH0000000112195',N'0691200',886,2860000,N'',N'1',N'tuyenlt',N'Mar 21 2019 12:00AM',N'U',NULL,NULL,N'Sửa chữa, bảo trì máy móc thiết bị',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127286',N'TRCI00001127255',N'HH0000000112039',N'0690900',1,1603744240,N'',N'1',N'tuyenlt',N'Oct 11 2019 12:00AM',N'U',NULL,NULL,N'Phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127287',N'TRCI00001127256',N'HH0000000112040',N'0690900',1,1395000000,N'',N'1',N'tuyenlt',N'Apr 27 2020 12:00AM',N'U',NULL,NULL,N'Gia hạn bản quyền phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127288',N'TRCI00001127257',N'HH0000000112041',N'0690900',1,1379645500,N'',N'1',N'tuyenlt',N'May 27 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần cứng và phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127289',N'TRCI00001127258',N'HH0000000112041',N'0690900',1,861300000,N'',N'1',N'tuyenlt',N'May 21 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần cứng và phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127290',N'TRCI00001127259',N'HH0000000112041',N'0690900',1,2239464700,N'',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần cứng và phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127291',N'TRCI00001127260',N'HH0000000112041',N'0690900',1,1339800000,N'',N'1',N'tuyenlt',N'May 18 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần cứng và phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127292',N'TRCI00001127261',N'HH0000000112040',N'0690900',1,11600000000,N'',N'1',N'tuyenlt',N'May  7 2020 12:00AM',N'U',NULL,NULL,N'Gia hạn bản quyền phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127293',N'TRCI00001127262',N'HH0000000112041',N'0690900',1,2859781835,N'',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần cứng và phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127294',N'TRCI00001127263',N'HH0000000112041',N'0690900',1,5892457300,N'',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần cứng và phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127295',N'TRCI00001127264',N'HH0000000112036',N'0690900',1,282366000,N'',N'1',N'tuyenlt',N'Jun 15 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127296',N'TRCI00001127265',N'HH0000000112036',N'0690900',1,98442750,N'',N'1',N'tuyenlt',N'Dec 31 2019 12:00AM',N'U',NULL,NULL,N'Bảo trì phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127297',N'TRCI00001127266',N'HH0000000112036',N'0690900',1,166521000,N'',N'1',N'tuyenlt',N'Mar 27 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127298',N'TRCI00001127267',N'HH0000000112036',N'0690900',1,161000000,N'',N'1',NULL,N'Mar 27 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127299',N'TRCI00001127268',N'HH0000000112195',N'0691200',1056,2860000,N'',N'1',N'tuyenlt',N'Apr  1 2020 12:00AM',N'U',NULL,NULL,N'Sửa chữa, bảo trì máy móc thiết bị: Bảo trì máy ATM năm 2020',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127300',N'TRCI00001127269',N'HH0000000112308',N'0691200',20,37400000,N'',N'1',N'tuyenlt',N'Apr 29 2020 12:00AM',N'U',NULL,NULL,N'Trang bị máy in thẻ',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127301',N'TRCI00001127270',N'HH0000000112038',NULL,1,1472000000,N'',N'1',N'tuyenlt',N'Jun  8 2020 12:00AM',N'U',NULL,NULL,N'Nâng cấp phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127302',N'TRCI00001127271',N'HH0000000112038',NULL,1,791000000,N'',N'1',N'tuyenlt',N'Jun 29 2020 12:00AM',N'U',NULL,NULL,N'Nâng cấp phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127303',N'TRCI00001127272',N'HH0000000112038',NULL,1,243675000,N'',N'1',N'tuyenlt',N'Aug  3 2020 12:00AM',N'U',NULL,NULL,N'Nâng cấp phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127304',N'TRCI00001127273',N'HH0000000112036',NULL,1,310000000,N'',N'1',N'tuyenlt',N'Aug 13 2020 12:00AM',N'U',NULL,NULL,N'Bảo trì phần mềm',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127305',N'TRCI00001127274',N'HH0000000112123',NULL,25,7165400,N'',N'1',N'tuyenlt',N'Jul 27 2020 12:00AM',N'U',NULL,NULL,N'Máy tính bảng',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127306',N'TRCI00001127275',N'HH0000000112070',NULL,1,857340000,N'',N'1',N'tuyenlt',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,N'Thuê quản lý TTDL dự phòng',0,NULL,NULL)

INSERT INTO [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'TRCDI0001127307',N'TRCI00001127276',N'HH0000000112071',NULL,1,108400000,N'',N'1',N'tuyenlt',NULL,N'U',NULL,NULL,N'Thuê  dịch vụ Cloud',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127072',N'TRCI00001127251',N'1',N'Aug 20 2020 10:31AM',100.00,NULL,NULL,NULL,N'1',N'tuyenlt',N'Dec 13 2019 12:00AM',N'U',NULL,NULL,NULL,NULL,N'2019.524/HDKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127073',N'TRCI00001127252',N'1',N'Aug 20 2020 10:31AM',40.00,503088960,NULL,N'Thanh toán đợt 1: 40% giá trị hợp đồng Thuê ngoài thiết kế UIUX cho ứng dụng Mobile dành cho KHCN',N'1',N'tuyenlt',N'Oct 14 2019 12:00AM',N'U',NULL,NULL,NULL,503088960,N'#CL-13/09/19-VIETCAPITAL-UX.UI',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127074',N'TRCI00001127252',N'2',N'Aug 20 2020 10:31AM',30.00,377316720,NULL,NULL,N'1',N'tuyenlt',N'Oct 14 2019 12:00AM',N'U',NULL,NULL,NULL,NULL,N'#CL-13/09/19-VIETCAPITAL-UX.UI',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127075',N'TRCI00001127252',N'3',N'Aug 20 2020 10:31AM',30.00,377316720,NULL,NULL,N'1',N'tuyenlt',N'Oct 14 2019 12:00AM',N'U',NULL,NULL,NULL,NULL,N'#CL-13/09/19-VIETCAPITAL-UX.UI',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127076',N'TRCI00001127254',N'1',N'Aug 20 2020 10:31AM',50.00,1266980000,NULL,N'Thanh toán đợt 1: 50% Hợp đồng bảo trì ATM năm 2019',N'1',N'tuyenlt',N'Mar 21 2019 12:00AM',N'U',NULL,NULL,NULL,1266980000,N'05/SRV/VCCB-MICROTEC/010319',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127077',N'TRCI00001127254',N'2',N'Aug 20 2020 10:31AM',40.00,910624000,NULL,N'Thanh toán đợt 1: 40% Hợp đồng bảo trì ATM năm 2019',N'1',N'tuyenlt',N'Mar 21 2019 12:00AM',N'U',NULL,NULL,NULL,910624000,N'05/SRV/VCCB-MICROTEC/010319',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127078',N'TRCI00001127254',N'3',N'Aug 20 2020 10:31AM',10.00,NULL,NULL,NULL,N'1',N'tuyenlt',N'Mar 21 2019 12:00AM',N'U',NULL,NULL,NULL,NULL,N'05/SRV/VCCB-MICROTEC/010319',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127079',N'TRCI00001127256',N'1',N'Aug 20 2020 10:31AM',NULL,1105000000,NULL,N'Thanh toán 100% hạng mục Renew RHEL và Renew VMWare',N'1',N'tuyenlt',N'Apr 27 2020 12:00AM',N'U',NULL,NULL,NULL,1105000000,N'432020/HDKT/SV-VCCB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127080',N'TRCI00001127256',N'2',N'Aug 20 2020 10:31AM',NULL,NULL,NULL,NULL,N'1',N'tuyenlt',N'Apr 27 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'432020/HDKT/SV-VCCB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127081',N'TRCI00001127257',N'1',N'Aug 20 2020 10:31AM',NULL,628095200,NULL,N'Thanh toán đợt 1: Hợp đồng bảo trì phần cứng và phần mềm hãng Cisco năm 2020',N'1',N'tuyenlt',N'May 27 2020 12:00AM',N'U',NULL,NULL,NULL,628095200,N'20/CSG/FSI/05/0038',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127082',N'TRCI00001127257',N'2',N'Aug 20 2020 10:31AM',NULL,151550300,NULL,N'Thanh toán đợt 2: Hợp đồng bảo trì phần cứng và phần mềm hãng Cisco năm 2020',N'1',N'tuyenlt',N'May 27 2020 12:00AM',N'U',NULL,NULL,NULL,151550300,N'20/CSG/FSI/05/0038',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127083',N'TRCI00001127257',N'3',N'Aug 20 2020 10:31AM',NULL,600000000,NULL,NULL,N'1',N'tuyenlt',N'May 27 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0038',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127084',N'TRCI00001127258',N'1',N'Aug 20 2020 10:31AM',NULL,569800000,NULL,N'Thanh toán đợt 1: Hợp đồng bảo trì phần cứng và phần mềm hãng HP',N'1',N'tuyenlt',N'May 21 2020 12:00AM',N'U',NULL,NULL,NULL,569800000,N'20/CSG/FSI/05/0032',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127085',N'TRCI00001127258',N'2',N'Aug 20 2020 10:31AM',NULL,291500000,NULL,NULL,N'1',N'tuyenlt',N'May 21 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0032',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127086',N'TRCI00001127259',N'1',N'Aug 20 2020 10:31AM',NULL,155722600,NULL,N'Thanh toán chi phí Renew IBM DS5300 - năm 2020',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,155722600,N'20/CSG/FSI/05/004',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127087',N'TRCI00001127259',N'2',N'Aug 20 2020 10:31AM',NULL,647516400,NULL,N'Thanh toán chi phí Renew IBM máy chủ S Series - năm 2020',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,647516400,N'20/CSG/FSI/05/004',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127088',N'TRCI00001127259',N'3',N'Aug 20 2020 10:31AM',NULL,1166725700,NULL,NULL,N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/004',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127089',N'TRCI00001127260',N'1',N'Aug 20 2020 10:31AM',NULL,580800000,NULL,N'Thanh toán chi phí bảo trì phần cứng thiết bị lưu trữ NetApp for DR',N'1',N'tuyenlt',N'May 18 2020 12:00AM',N'U',NULL,NULL,NULL,580800000,N'20/CSG/FSI/05/0029',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127090',N'TRCI00001127260',N'2',N'Aug 20 2020 10:31AM',NULL,759000000,NULL,NULL,N'1',N'tuyenlt',N'May 18 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0029',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127091',N'TRCI00001127261',N'1',N'Aug 20 2020 10:31AM',NULL,3050000000,NULL,N'Thanh toán đợt 1: Hợp đồng bảo trì phần mềm hãng Oracle năm 2020',N'1',N'tuyenlt',N'May  7 2020 12:00AM',N'U',NULL,NULL,NULL,3050000000,N'2020.135/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127092',N'TRCI00001127261',N'2',N'Aug 20 2020 10:31AM',NULL,1410000000,NULL,NULL,N'1',N'tuyenlt',N'May  7 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'2020.135/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127093',N'TRCI00001127261',N'3',N'Aug 20 2020 10:31AM',NULL,7140000000,NULL,NULL,N'1',N'tuyenlt',N'May  7 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'2020.135/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127094',N'TRCI00001127262',N'1',N'Aug 20 2020 10:32AM',NULL,331672131,NULL,N'Thanh toán chi phí Renew McAfee IPS Support for DR năm 2020',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,331672131,N'20/CSG/FSI/05/0006',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127095',N'TRCI00001127262',N'2',N'Aug 20 2020 10:32AM',NULL,480220972,NULL,NULL,N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0006',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127096',N'TRCI00001127262',N'3',N'Aug 20 2020 10:32AM',NULL,2047888732,NULL,NULL,N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0006',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127097',N'TRCI00001127263',N'1',N'Aug 20 2020 10:32AM',NULL,2527094800,NULL,N'Thanh toán đợt 1: Hợp đồng bảo trì phần cứng và phần mềm các thiết bị bảo mật năm 2020',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,2527094800,N'20/CSG/FSI/05/0007',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127098',N'TRCI00001127263',N'2',N'Aug 20 2020 10:32AM',NULL,249700000,NULL,N'Thanh toán đợt 2: Hợp đồng bảo trì phần cứng và phần mềm các thiết bị bảo mật năm 2020',N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,249700000,N'20/CSG/FSI/05/0007',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127099',N'TRCI00001127263',N'3',N'Aug 20 2020 10:32AM',NULL,713680000,NULL,NULL,N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0007',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127100',N'TRCI00001127263',N'4',N'Aug 20 2020 10:32AM',NULL,312749800,NULL,NULL,N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0007',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127101',N'TRCI00001127263',N'5',N'Aug 20 2020 10:32AM',NULL,836995200,NULL,NULL,N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0007',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127102',N'TRCI00001127263',N'6',N'Aug 20 2020 10:32AM',NULL,1252237500,NULL,NULL,N'1',N'tuyenlt',N'May  6 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'20/CSG/FSI/05/0007',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127103',N'TRCI00001127264',N'1',N'Aug 20 2020 10:32AM',50.00,141183000,NULL,NULL,N'1',N'tuyenlt',N'Jun 15 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'178.2020/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127104',N'TRCI00001127264',N'2',N'Aug 20 2020 10:32AM',50.00,141183000,NULL,NULL,N'1',N'tuyenlt',N'Jun 15 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'178.2020/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127105',N'TRCI00001127265',N'1',N'Aug 20 2020 10:32AM',50.00,49221375,NULL,N'Thanh toán đợt 1: 50% Hợp đồng Bảo trì phần mềm FPT.IHRP năm 2020',N'1',N'tuyenlt',N'Dec 31 2019 12:00AM',N'U',NULL,NULL,NULL,49221375,N'GMC20060B0',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127106',N'TRCI00001127265',N'2',N'Aug 20 2020 10:32AM',50.00,49221375,NULL,NULL,N'1',N'tuyenlt',N'Dec 31 2019 12:00AM',N'U',NULL,NULL,NULL,NULL,N'GMC20060B0',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127107',N'TRCI00001127266',N'1',N'Aug 20 2020 10:32AM',50.00,83260500,NULL,N'Thanh toán đợt 1: 50% giá trị hợp đồng Bảo trì hệ thống Trung tâm thanh toán (năm 2020)',N'1',N'tuyenlt',N'Mar 27 2020 12:00AM',N'U',NULL,NULL,NULL,83260500,N'2020.115/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127108',N'TRCI00001127266',N'2',N'Aug 20 2020 10:32AM',50.00,83260500,NULL,NULL,N'1',N'tuyenlt',N'Mar 27 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'2020.115/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127109',N'TRCI00001127267',N'1',N'Aug 20 2020 10:32AM',50.00,80500000,NULL,NULL,N'1',NULL,N'Mar 27 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'260.2020/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127110',N'TRCI00001127267',N'2',N'Aug 20 2020 10:32AM',50.00,80500000,NULL,NULL,N'1',NULL,N'Mar 27 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'260.2020/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127111',N'TRCI00001127269',N'1',N'Aug 20 2020 10:32AM',NULL,149600000,NULL,NULL,N'1',N'tuyenlt',N'Apr 29 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'06042020/HĐKT/VCCB-MKG',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127112',N'TRCI00001127269',N'2',N'Aug 20 2020 10:32AM',NULL,179520000,NULL,NULL,N'1',N'tuyenlt',N'Apr 29 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'06042020/HĐKT/VCCB-MKG',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127113',N'TRCI00001127269',N'3',N'Aug 20 2020 10:32AM',NULL,418880000,NULL,NULL,N'1',N'tuyenlt',N'Apr 29 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'06042020/HĐKT/VCCB-MKG',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127114',N'TRCI00001127270',N'1',N'Aug 20 2020 10:32AM',NULL,368000000,NULL,N'Thanh toán tháng thứ nhất: Hợp đồng thuê đối tác hỗ trợ sản xuất phần mềm Dự án DigiCore và Dự án Digital Bank giai đoạn 2',N'1',N'tuyenlt',N'Jun  8 2020 12:00AM',N'U',NULL,NULL,NULL,368000000,N'UNIT/BVB-20200608.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127115',N'TRCI00001127270',N'2',N'Aug 20 2020 10:32AM',NULL,368000000,NULL,NULL,N'1',N'tuyenlt',N'Jun  8 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'UNIT/BVB-20200608.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127116',N'TRCI00001127270',N'3',N'Aug 20 2020 10:32AM',NULL,368000000,NULL,NULL,N'1',N'tuyenlt',N'Jun  8 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'UNIT/BVB-20200608.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127117',N'TRCI00001127270',N'4',N'Aug 20 2020 10:32AM',NULL,368000000,NULL,NULL,N'1',N'tuyenlt',N'Jun  8 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'UNIT/BVB-20200608.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127118',N'TRCI00001127271',N'1',N'Aug 20 2020 10:32AM',NULL,184000000,NULL,N'Thanh toán tháng thứ nhất: Hợp đồng hỗ trợ sản xuất phần mềm ACH',N'1',N'tuyenlt',N'Jun 29 2020 12:00AM',N'U',NULL,NULL,NULL,184000000,N'UNIT/BVB-20200601.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127119',N'TRCI00001127271',N'2',N'Aug 20 2020 10:32AM',NULL,184000000,NULL,NULL,N'1',N'tuyenlt',N'Jun 29 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'UNIT/BVB-20200601.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127120',N'TRCI00001127271',N'3',N'Aug 20 2020 10:32AM',NULL,188000000,NULL,NULL,N'1',N'tuyenlt',N'Jun 29 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'UNIT/BVB-20200601.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127121',N'TRCI00001127271',N'4',N'Aug 20 2020 10:32AM',NULL,188000000,NULL,NULL,N'1',N'tuyenlt',N'Jun 29 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'UNIT/BVB-20200601.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127122',N'TRCI00001127271',N'5',N'Aug 20 2020 10:32AM',NULL,47000000,NULL,NULL,N'1',N'tuyenlt',N'Jun 29 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'UNIT/BVB-20200601.1',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127123',N'TRCI00001127272',N'1',N'Aug 20 2020 10:32AM',50.00,121837500,NULL,NULL,N'1',N'tuyenlt',N'Aug  3 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'2020.250/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127124',N'TRCI00001127272',N'2',N'Aug 20 2020 10:32AM',50.00,121837500,NULL,NULL,N'1',N'tuyenlt',N'Aug  3 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'2020.250/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127125',N'TRCI00001127273',N'1',N'Aug 20 2020 10:32AM',50.00,155000000,NULL,NULL,N'1',N'tuyenlt',N'Aug 13 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'2020.259/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127126',N'TRCI00001127273',N'2',N'Aug 20 2020 10:32AM',50.00,155000000,NULL,NULL,N'1',N'tuyenlt',N'Aug 13 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'2020.259/HĐKT/BK6',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127127',N'TRCI00001127276',N'1',N'Aug 20 2020 10:32AM',50.00,54200000,NULL,N'Thanh toán đợt 1: 50% Hợp đồng Dịch vụ xử lý, cài đặt phần mềm và Dịch vụ tư vấn (đào tạo) cho nền tảng Google Cloud Platform',N'1',N'tuyenlt',NULL,N'U',NULL,NULL,NULL,54200000,N'010720A.GCP/HDKT',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001127128',N'TRCI00001127276',N'2',N'Aug 20 2020 10:32AM',50.00,54200000,NULL,NULL,N'1',N'tuyenlt',NULL,N'U',NULL,NULL,NULL,NULL,N'010720A.GCP/HDKT',NULL,NULL)

INSERT [dbo].[TR_REQ_ADVANCE_PAYMENT] ([REQ_PAY_ID], [REQ_PAY_CODE], [REQ_DT], [BRANCH_ID], [DEP_ID], [REQ_REASON], [REQ_TYPE], [REQ_ENTRIES], [REQ_DESCRIPTION], [REF_ID], [RECEIVER_PO], [RECEIVER_DEBIT], [REQ_PAY_TYPE], [REQ_TYPE_CURRENCY], [REQ_AMT], [REQ_TEMP_AMT], [PAY_AMT], [MAKER_ID], [CREATE_DT], [EDITOR_ID], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [CREATE_DT_KT], [MAKER_ID_KT], [AUTH_STATUS_KT], [CHECKER_ID_KT], [APPROVE_DT_KT], [CONFIRM_NOTES], [BRANCH_CREATE], [NOTES], [RECORD_STATUS], [TRANSFER_MAKER], [TRANSFER_DT], [TRASFER_USER_RECIVE], [PROCESS], [PAY_PHASE], [DVDM_ID], [RATE], [RECIVER_MONEY], [IS_PERIOD]) VALUES (N'TADYI0001119514', N'062020/089373', CAST(N'2020-06-25' AS Date), N'DV0001', N'DEP000000000014', N'Tạm ứng 30% Đơn đặt hàng 16 máy in thẻ Datacard SD260L', N'P', N'', N'', N'TRC000001126193', N'', N'', N'1', N'VND', CAST(179520000.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(0 AS Decimal(18, 0)), N'tuyenlt', CAST(N'2020-06-25T00:00:00.000' AS DateTime), N'', N'A', N'huongvt', CAST(N'2020-06-25T00:00:00.000' AS DateTime), NULL, N'', N'', N'', NULL, N'', N'DV0001', N'', N'1', NULL, NULL, N'', N'', NULL, NULL, NULL, N'', N'N')

GO