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'TRCI00001055766',NULL,N'Dịch vụ vận chuyển - PGD Phú nhuận Tầng 3 về PGD Cộng Hòa',N'1',NULL,NULL,5049000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055395',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Feb 25 2020 12:00AM',N'A',N'Phuongtln1',N'Mar  3 2020 12:00AM',NULL,N'TRRDI0001055395',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'TRCI00001055747',N'2204/2019/NHBV-NP',N'Hợp đồng thi công cải tạo Khối Vận hành - Tầng 2 HO',N'1',NULL,NULL,79033460,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055369',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'May 16 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055369',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'TRCI00001055748',NULL,N'Thi công cửa cuốn PGD Bến Lức',N'1',NULL,N'CMS000001126292',25418800,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055370',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Jul 22 2019 12:00AM',N'A',N'Phuongtln1',N'Jul  8 2019 12:00AM',NULL,N'TRRDI0001055370',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'TRCI00001055749',N'21-10/2019/BVB-ASIA',N'Hợp đồng thi công cải tạo xây dựng PGD Hóa An',N'1',NULL,NULL,735153100,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055371',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov  6 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055371',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'TRCI00001055750',N'1811/2019/BVB-HÐ',N'Hợp đồng thi công sửa chữa các tầng tại HO',N'1',NULL,NULL,1253667250,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055372',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055372',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'TRCI00001055751',N'1210/2019/VCCB-H?i Âu',N'Hợp đồng nguyên tắc thi công lắp đặt biển hiệu',N'1',NULL,N'CMS000001126237',15636632,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055374',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Dec 20 2019 12:00AM',N'A',N'Phuongtln1',N'Feb  1 2020 12:00AM',NULL,N'TRRDI0001055374',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'TRCI00001055752',N'1605/2019/NHBV-TBC',N'Hợp đồng thi công lắp đặt PCCC tại CN Cần Thơ',N'1',NULL,N'CMS000001126295',122371700,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055377',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Oct 29 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055377',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'TRCI00001055753',N'1002/2020/BVB-ALPEC',N'Hợp đồng thi công lắp đặt thang máy CN Cần Thơ',N'1',NULL,NULL,509200000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov  8 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,NULL,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'TRCI00001055754',N'1004/2020/BVB-TL',N'Hợp đồng cung cấp bàn CVTV',N'1',NULL,NULL,223355000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055385',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055385',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'TRCI00001055755',N'1003/2020/NHBV-TL',N'Hợp đồng thi công cải tạo CN Quảng Ninh',N'1',NULL,NULL,1200000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055379',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'A',N'Phuongtln1',N'Aug  4 2020 12:00AM',NULL,N'TRRDI0001055379',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'TRCI00001055756',N'1210-1/2019/VCCB-Hoàng Phi',N'Hợp đồng nguyên tắc thi công lắp đặt biển hiệu',N'1',NULL,NULL,969228326,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055380',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055380',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'TRCI00001055757',N'2005/2020/BVB-ASIA',N'Hợp đồng thi công cải tạo sửa chữa PGD Phú Mỹ Hưng',N'1',NULL,NULL,170203000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055381',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'May 29 2020 12:00AM',N'A',N'Phuongtln1',N'Feb  6 2020 12:00AM',NULL,N'TRRDI0001055381',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'TRCI00001055758',N'1603/2020/BVB-HÐ',N'Hợp đồng thi công nội thất CN Cần Thơ',N'1',NULL,NULL,338000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055382',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055382',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'TRCI00001055759',N'1603/2020/BVB-HÐ',N'Thi công nội thất CN Cần Thơ và CN An Giang',N'1',NULL,NULL,338000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055382',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 25 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055382',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'TRCI00001055760',N'1004/2020/BVB-TL',N'Trang bị bàn Chuyên viên tư vấn cho một số Đơn vị khinh doanh ( chưa trang bị )',N'1',NULL,NULL,223355000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055385',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055385',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'TRCI00001055761',N'1206/2020/BVB-ASIA',N'Chi phí cải tạo nội thất di dời PGD Phú Nhuận',N'1',NULL,NULL,1892474744,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055387',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',NULL,N'A',N'Phuongtln1',N'Jan  7 2020 12:00AM',NULL,N'TRRDI0001055387',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'TRCI00001055762',N'1206/2020/BVB-NP',N'Thi công cải tạo,sửa chữa TTQLTD HO-Ngân hàng TMCP Bản Việt',N'1',NULL,NULL,57777500,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055389',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',NULL,N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055389',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'TRCI00001055763',N'0207/2020/BVB-HÐ',N'Chi phí cải tạo sửa chữa PGD Trảng Bàng',N'1',NULL,NULL,990000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055391',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Jul 20 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055391',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'TRCI00001055764',N'0307/2020/BVB-PS',N'Chi phí cải tạo sửa chữa PGD Thanh Khê',N'1',NULL,NULL,930000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055393',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',NULL,N'A',N'Phuongtln1',N'Oct  8 2020 12:00AM',NULL,N'TRRDI0001055393',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'TRCI00001055765',N'0607/2020/BVB-PS',N'Chi phí cải tạo sửa chữa PGD Thanh Khê',N'1',NULL,NULL,479773800,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055394',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',NULL,N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055394',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'TRCI00001055730',N'0801/2018/NHBV-KHANGGIA',N'Hợp đồng thi công sửa chữa cải tạo PGD Hậu Giang',N'1',NULL,NULL,168702600,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055352',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Feb  6 2018 12:00AM',N'A',N'Phuongtln1',N'Dec  2 2018 12:00AM',NULL,N'TRRDI0001055352',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'TRCI00001055731',N'1003/2018/NHBV-KHANGGIA',N'Hợp đồng thi công sửa chữa cải tạo PGD Phú Nhuận (Âu Cơ)',N'1',NULL,N'CMS000001126228',459643921,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055353',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Apr 12 2018 12:00AM',N'A',N'Phuongtln1',N'Dec  4 2018 12:00AM',NULL,N'TRRDI0001055353',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'TRCI00001055732',N'0606/2018/NHBV-KHANGGIA',N'Hợp đồng cải tạo lầu 3 tại số 423 Cộng Hòa thành TTĐT',N'1',NULL,NULL,199584490,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055354',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Jun 13 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055354',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'TRCI00001055733',N'2206/2018/NHBV-ASIA',N'Hợp đồng thi công cải tạo xây dựng và trang bị nội thất CN Tây Ninh',N'1',NULL,NULL,1700777133,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055355',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Jun 28 2018 12:00AM',N'A',N'Phuongtln1',N'Feb  7 2018 12:00AM',NULL,N'TRRDI0001055355',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'TRCI00001055734',N'1207/2018/NHBV-HÐ',N'Hợp đồng thi công cải tạo xây dựng PGD Hải Châu',N'1',NULL,NULL,590517717,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055356',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Aug  1 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055356',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'TRCI00001055735',N'2008/2018/NHBV-VT',N'Hợp đồng thi công cải tạo xây dựng PGD Phú Mỹ Hưng',N'1',NULL,NULL,710827679,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055357',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Sep 13 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055357',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'TRCI00001055736',N'1709-2/2018/NHBV-TD',N'Hợp đồng thi công biển hiệu Hội Sở',N'1',NULL,N'CMS000001126313',592103600,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055358',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov  6 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055358',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'TRCI00001055737',N'2510/2018/NHBV-HÐ',N'Hợp đồng thi công cải tạo phòng làm việc phòng thu hồi nợ lầu 04 HO',N'1',NULL,N'CMS000001126292',143139205,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055359',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov 13 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055359',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'TRCI00001055738',N'2311/2018/NHBV-ASIA',N'Hợp đồng thi công nội thất PGD Bà Rịa',N'1',NULL,N'CMS000001126234',117454700,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055360',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Dec 17 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055360',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'TRCI00001055739',N'0701/2019/NHBV-ASIA',N'Hợp đồng thi công cải tạo xây dựng CN Kiên Giang',N'1',NULL,NULL,175247050,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055361',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Dec 24 2018 12:00AM',N'A',N'Phuongtln1',N'Apr  1 2019 12:00AM',NULL,N'TRRDI0001055361',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'TRCI00001055740',N'0607/2018/NHBV-VT và  PL 0607-1/2018/NHBV-VT',N'Hợp đồng thi công xây dựng CN Tiền Giang',N'1',NULL,NULL,1327742725,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055362',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'A',N'Phuongtln1',N'Jun  1 2020 12:00AM',NULL,N'TRRDI0001055362',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'TRCI00001055741',N'0512/2018/NHBV-ASIA',N'Hợp đồng thi công cải tạo xây dựng PGD Hòa Thành',N'1',NULL,NULL,859590380,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055363',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'A',N'Phuongtln1',N'Mar  1 2019 12:00AM',NULL,N'TRRDI0001055363',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'TRCI00001055742',N'2102/2019/NHBV-ASIA',N'Hợp đồng thi công cải tạo xây dựng PGD Chi Lăng',N'1',NULL,NULL,652487165,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055364',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055364',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'TRCI00001055743',N'2102-1/2019/NHBV-ASIA',N'Hợp đồng thi công cải tạo xây dựng PGD Thanh Khê',N'1',NULL,NULL,97730600,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055365',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055365',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'TRCI00001055744',N'1502/NHBV/HÐTK-XD',N'Hợp đồng thiết kế và khoan khảo sát địa chất CN Nha Trang',N'1',NULL,NULL,481001730,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055366',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 11 2019 12:00AM',N'A',N'Phuongtln1',N'Dec  3 2019 12:00AM',NULL,N'TRRDI0001055366',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'TRCI00001055745',N'0504/HÐTK/NHBV-XD',N'Hợp đồng thiết kế và khoan khảo sát địa chất CN Cần Thơ',N'1',NULL,NULL,309257080,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055367',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Apr 16 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001055367',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'TRCI00001055746',NULL,N'Thi công tầng 10,11 và 12',N'1',NULL,NULL,147986520,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001055368',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'May 15 2019 12:00AM',N'A',N'Phuongtln1',N'Feb  1 2020 12:00AM',NULL,N'TRRDI0001055368',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'TRCDI0001055792',N'TRCI00001055730',NULL,N'0690400',1,168702600,N'',N'1',N'Tanvt',N'Feb  6 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055793',N'TRCI00001055731',NULL,N'0690400',1,459643921,N'',N'1',N'Tanvt',N'Apr 12 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055794',N'TRCI00001055732',N'HH0000000112086',N'0690400',1,199584490,N'',N'1',N'Tanvt',N'Jun 13 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055795',N'TRCI00001055733',NULL,N'0690400',1,1700777133,N'',N'1',N'Tanvt',N'Jun 28 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055796',N'TRCI00001055734',NULL,N'0690400',1,590517717,N'',N'1',N'Tanvt',N'Aug  1 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055797',N'TRCI00001055735',NULL,N'0690400',1,710827679,N'',N'1',N'Tanvt',N'Sep 13 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055798',N'TRCI00001055736',N'HH0000000112088',N'0690400',1,592103600,N'',N'1',N'Tanvt',N'Nov  6 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055799',N'TRCI00001055737',N'HH0000000112086',N'0690400',1,143139205,N'',N'1',N'Tanvt',N'Nov 13 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055800',N'TRCI00001055738',NULL,N'0690400',1,117454700,N'',N'1',N'Tanvt',N'Dec 17 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055801',N'TRCI00001055739',NULL,N'0690400',1,175247050,N'',N'1',N'Tanvt',N'Dec 24 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055802',N'TRCI00001055740',NULL,N'0690400',1,1327742725,N'',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055803',N'TRCI00001055741',NULL,N'0690400',1,859590380,N'',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055804',N'TRCI00001055742',NULL,N'0690400',1,652487165,N'',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055805',N'TRCI00001055743',NULL,N'0690400',1,97730600,N'',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055806',N'TRCI00001055744',N'HH0000000112085',N'0690400',1,481001730,N'',N'1',N'Tanvt',N'Mar 11 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055807',N'TRCI00001055745',NULL,N'0690400',1,309257080,N'',N'1',N'Tanvt',N'Apr 16 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055808',N'TRCI00001055746',N'HH0000000112088',N'0690400',1,147986520,N'',N'1',N'Tanvt',N'May 15 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055809',N'TRCI00001055747',N'HH0000000112088',N'0690400',1,79033460,N'',N'1',N'Tanvt',N'May 16 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055810',N'TRCI00001055748',NULL,N'0690400',1,25418800,N'',N'1',N'Tanvt',N'Jul 22 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055811',N'TRCI00001055749',NULL,N'0690400',1,735153100,N'',N'1',N'Tanvt',N'Nov  6 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055812',N'TRCI00001055750',N'HH0000000112088',N'0690400',1,1253667250,N'',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055813',N'TRCI00001055751',N'HH0000000112086',N'0690400',1,15636632,N'',N'1',N'Tanvt',N'Dec 20 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055814',N'TRCI00001055751',NULL,N'0690400',1,123610879,N'',N'1',N'Tanvt',N'Dec 20 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055815',N'TRCI00001055752',NULL,N'0690400',1,122371700,N'',N'1',N'Tanvt',N'Oct 29 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055816',N'TRCI00001055753',NULL,N'0690400',1,509200000,N'',N'1',N'Tanvt',N'Nov  8 2019 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055817',N'TRCI00001055754',N'HH0000000112085',N'0690400',1,223355000,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,N'XAY DUNG CO BAN',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'TRCDI0001055818',N'TRCI00001055755',N'HH0000000112091',N'0690400',1,1200000000,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,N'Di dời Chi nhánh',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'TRCDI0001055819',N'TRCI00001055756',N'HH0000000112091',N'0690400',1,969228326,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,N'Di dời Chi nhánh',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'TRCDI0001055820',N'TRCI00001055757',N'HH0000000112087',N'0690400',1,170203000,N'',N'1',N'Tanvt',N'May 29 2020 12:00AM',N'U',NULL,NULL,N'Sửa chữa, cải tạo Phòng giao dịch',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'TRCDI0001055821',N'TRCI00001055758',N'HH0000000112086',N'0690400',1,338000000,N'',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'U',NULL,NULL,N'Sửa chữa, cải tạo Chi nhánh',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'TRCDI0001055822',N'TRCI00001055758',N'HH0000000112096',N'0690400',1,352076043,N'',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'U',NULL,NULL,N'Biển hiệu Chi nhánh',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'TRCDI0001055823',N'TRCI00001055759',N'HH0000000112086',N'0690400',1,338000000,N'',N'1',N'Tanvt',N'Mar 25 2020 12:00AM',N'U',NULL,NULL,N'Sửa chữa, cải tạo Chi nhánh',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'TRCDI0001055824',N'TRCI00001055760',N'HH0000000112085',N'0690400',1,223355000,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,N'Sửa chữa, cải tạo Hội sở',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'TRCDI0001055825',N'TRCI00001055760',N'HH0000000112087',N'0690400',1,68013970,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,N'Sửa chữa, cải tạo Phòng giao dịch',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'TRCDI0001055826',N'TRCI00001055761',N'HH0000000112092',N'0690400',1,1892474744,N'',N'1',N'Tanvt',NULL,N'U',NULL,NULL,N'Di dời Phòng giao dịch',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'TRCDI0001055827',N'TRCI00001055762',N'HH0000000112085',N'0690400',1,57777500,N'',N'1',N'Tanvt',NULL,N'U',NULL,NULL,N'Sửa chữa, cải tạo Hội sở',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'TRCDI0001055828',N'TRCI00001055762',N'HH0000000112097',N'0690400',1,283844204,N'',N'1',N'Tanvt',NULL,N'U',NULL,NULL,N'Biển hiệu Phòng giao dịch',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'TRCDI0001055829',N'TRCI00001055763',N'HH0000000112029',N'0690400',1,990000000,N'',N'1',N'Tanvt',N'Jul 20 2020 12:00AM',N'U',NULL,NULL,N'Mở mới Phòng giao dịch',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'TRCDI0001055830',N'TRCI00001055764',N'HH0000000112092',N'0690400',1,930000000,N'',N'1',N'Tanvt',NULL,N'U',NULL,NULL,N'Di dời Phòng giao dịch',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'TRCDI0001055831',N'TRCI00001055765',N'HH0000000112097',N'0690400',1,479773800,N'',N'1',N'Tanvt',NULL,N'U',NULL,NULL,N'Biển hiệu Phòng giao dịch',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'TRCDI0001055832',N'TRCI00001055766',N'HH0000000112214',N'0690400',1,5049000,N'',N'1',N'Tanvt',N'Feb 25 2020 12:00AM',N'U',NULL,NULL,N'Vận chuyển',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'TRCPI0001056963',N'TRCI00001055730',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Feb  6 2018 12:00AM',N'U',NULL,NULL,NULL,50610780,N'0801/2018/NHBV-KHANGGIA',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'TRCPI0001056964',N'TRCI00001055730',N'2',N'Aug 21 2020  8:18AM',65.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Feb  6 2018 12:00AM',N'U',NULL,NULL,NULL,93454070,N'0801/2018/NHBV-KHANGGIA',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'TRCPI0001056965',N'TRCI00001055730',N'3',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Feb  6 2018 12:00AM',N'U',NULL,NULL,NULL,24637750,N'0801/2018/NHBV-KHANGGIA',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'TRCPI0001056966',N'TRCI00001055731',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Apr 12 2018 12:00AM',N'U',NULL,NULL,NULL,137893176,N'1003/2018/NHBV-KHANGGIA',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'TRCPI0001056967',N'TRCI00001055731',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Apr 12 2018 12:00AM',N'U',NULL,NULL,NULL,137893176,N'1003/2018/NHBV-KHANGGIA',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'TRCPI0001056968',N'TRCI00001055731',N'3',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Apr 12 2018 12:00AM',N'U',NULL,NULL,NULL,157663346,N'1003/2018/NHBV-KHANGGIA',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'TRCPI0001056969',N'TRCI00001055731',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Apr 12 2018 12:00AM',N'U',NULL,NULL,NULL,26194223,N'1003/2018/NHBV-KHANGGIA',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'TRCPI0001056970',N'TRCI00001055732',N'1+2+3',N'Aug 21 2020  8:18AM',95.00,NULL,NULL,N'Thanh toán đợt 1+2+3',N'1',N'Tanvt',N'Jun 13 2018 12:00AM',N'U',NULL,NULL,NULL,174421624,N'0606/2018/NHBV-KHANGGIA',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'TRCPI0001056971',N'TRCI00001055732',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Jun 13 2018 12:00AM',N'U',NULL,NULL,NULL,25162866,N'0606/2018/NHBV-KHANGGIA',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'TRCPI0001056972',N'TRCI00001055733',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Jun 28 2018 12:00AM',N'U',NULL,NULL,NULL,510233140,N'2206/2018/NHBV-ASIA',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'TRCPI0001056973',N'TRCI00001055733',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Jun 28 2018 12:00AM',N'U',NULL,NULL,NULL,510233140,N'2206/2018/NHBV-ASIA',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'TRCPI0001056974',N'TRCI00001055733',N'3',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Jun 28 2018 12:00AM',N'U',NULL,NULL,NULL,524937665,N'2206/2018/NHBV-ASIA',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'TRCPI0001056975',N'TRCI00001055733',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Jun 28 2018 12:00AM',N'U',NULL,NULL,NULL,155373188,N'2206/2018/NHBV-ASIA',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'TRCPI0001056976',N'TRCI00001055734',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Aug  1 2018 12:00AM',N'U',NULL,NULL,NULL,177155315,N'1207/2018/NHBV-HĐ',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'TRCPI0001056977',N'TRCI00001055734',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Aug  1 2018 12:00AM',N'U',NULL,NULL,NULL,177155315,N'1207/2018/NHBV-HĐ',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'TRCPI0001056978',N'TRCI00001055734',N'3',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Aug  1 2018 12:00AM',N'U',NULL,NULL,NULL,136028868,N'1207/2018/NHBV-HĐ',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'TRCPI0001056979',N'TRCI00001055734',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Aug  1 2018 12:00AM',N'U',NULL,NULL,NULL,100178219,N'1207/2018/NHBV-HĐ',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'TRCPI0001056980',N'TRCI00001055735',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Sep 13 2018 12:00AM',N'U',NULL,NULL,NULL,213248304,N'2008/2018/NHBV-VT',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'TRCPI0001056981',N'TRCI00001055735',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Sep 13 2018 12:00AM',N'U',NULL,NULL,NULL,213248304,N'2008/2018/NHBV-VT',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'TRCPI0001056982',N'TRCI00001055735',N'3',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Sep 13 2018 12:00AM',N'U',NULL,NULL,NULL,220891646,N'2008/2018/NHBV-VT',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'TRCPI0001056983',N'TRCI00001055735',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Sep 13 2018 12:00AM',N'U',NULL,NULL,NULL,63439425,N'2008/2018/NHBV-VT',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'TRCPI0001056984',N'TRCI00001055736',N'1',N'Aug 21 2020  8:18AM',50.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Nov  6 2018 12:00AM',N'U',NULL,NULL,NULL,296051800,N'1709-2/2018/NHBV-TD',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'TRCPI0001056985',N'TRCI00001055736',N'2',N'Aug 21 2020  8:18AM',50.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Nov  6 2018 12:00AM',N'U',NULL,NULL,NULL,296051800,N'1709-2/2018/NHBV-TD',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'TRCPI0001056986',N'TRCI00001055737',N'1+2+3',N'Aug 21 2020  8:18AM',95.00,NULL,NULL,N'Thanh toán đợt 1 +2 +3',N'1',N'Tanvt',N'Nov 13 2018 12:00AM',N'U',NULL,NULL,NULL,131321545,N'2510/2018/NHBV-HĐ',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'TRCPI0001056987',N'TRCI00001055737',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Nov 13 2018 12:00AM',N'U',NULL,NULL,NULL,11817660,N'2510/2018/NHBV-HĐ',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'TRCPI0001056988',N'TRCI00001055738',N'1',N'Aug 21 2020  8:18AM',60.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Dec 17 2018 12:00AM',N'U',NULL,NULL,NULL,70472820,N'2311/2018/NHBV-ASIA',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'TRCPI0001056989',N'TRCI00001055738',N'2',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Dec 17 2018 12:00AM',N'U',NULL,NULL,NULL,41109145,N'2311/2018/NHBV-ASIA',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'TRCPI0001056990',N'TRCI00001055738',N'3',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Dec 17 2018 12:00AM',N'U',NULL,NULL,NULL,5872735,N'2311/2018/NHBV-ASIA',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'TRCPI0001056991',N'TRCI00001055739',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Dec 24 2018 12:00AM',N'U',NULL,NULL,NULL,52574115,N'0701/2019/NHBV-ASIA',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'TRCPI0001056992',N'TRCI00001055739',N'2+3',N'Aug 21 2020  8:18AM',65.00,NULL,NULL,N'Thanh toán đợt 2 + đợt 3',N'1',N'Tanvt',N'Dec 24 2018 12:00AM',N'U',NULL,NULL,NULL,63020127,N'0701/2019/NHBV-ASIA',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'TRCPI0001056993',N'TRCI00001055739',N'3',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Dec 24 2018 12:00AM',N'U',NULL,NULL,NULL,59652808,N'0701/2019/NHBV-ASIA',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'TRCPI0001056994',N'TRCI00001055740',N'5',N'Aug 21 2020  8:18AM',25.00,NULL,NULL,N'Thanh toán đợt 5 chi phí phát sinh CN Tiền Giang + giữ lại 5% bảo hành',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'U',NULL,NULL,NULL,336096684,N'0607/2018/NHBV-VT và  PL 0607-1/2018/NHBV-VT',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'TRCPI0001056995',N'TRCI00001055741',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'U',NULL,NULL,NULL,257877114,N'0512/2018/NHBV-ASIA',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'TRCPI0001056996',N'TRCI00001055741',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'U',NULL,NULL,NULL,257877114,N'0512/2018/NHBV-ASIA',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'TRCPI0001056997',N'TRCI00001055741',N'3',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'U',NULL,NULL,NULL,215992562,N'0512/2018/NHBV-ASIA',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'TRCPI0001056998',N'TRCI00001055741',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Dec 25 2018 12:00AM',N'U',NULL,NULL,NULL,127843590,N'0512/2018/NHBV-ASIA',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'TRCPI0001056999',N'TRCI00001055742',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,NULL,195746150,N'2102/2019/NHBV-ASIA',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'TRCPI0001057000',N'TRCI00001055742',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,NULL,195746150,N'2102/2019/NHBV-ASIA',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'TRCPI0001057001',N'TRCI00001055742',N'3',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,NULL,63879408,N'2102/2019/NHBV-ASIA',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'TRCPI0001057002',N'TRCI00001055742',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,NULL,197115457,N'2102/2019/NHBV-ASIA',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'TRCPI0001057003',N'TRCI00001055743',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,NULL,29319180,N'2102-1/2019/NHBV-ASIA',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'TRCPI0001057004',N'TRCI00001055743',N'2',N'Aug 21 2020  8:18AM',65.00,NULL,NULL,N'Thanh toán đợt 2 + đợt 3',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,NULL,51162540,N'2102-1/2019/NHBV-ASIA',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'TRCPI0001057005',N'TRCI00001055743',N'3',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'U',NULL,NULL,NULL,17248880,N'2102-1/2019/NHBV-ASIA',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'TRCPI0001057006',N'TRCI00001055744',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Mar 11 2019 12:00AM',N'U',NULL,NULL,NULL,144300000,N'1502/NHBV/HĐTK-XD',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'TRCPI0001057007',N'TRCI00001055744',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Mar 11 2019 12:00AM',N'U',NULL,NULL,NULL,144300000,N'1502/NHBV/HĐTK-XD',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'TRCPI0001057008',N'TRCI00001055744',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Mar 11 2019 12:00AM',N'U',NULL,NULL,NULL,144300000,N'1502/NHBV/HĐTK-XD',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'TRCPI0001057009',N'TRCI00001055744',N'4',N'Aug 21 2020  8:18AM',10.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Mar 11 2019 12:00AM',N'U',NULL,NULL,NULL,48101730,N'1502/NHBV/HĐTK-XD',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'TRCPI0001057010',N'TRCI00001055745',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Apr 16 2019 12:00AM',N'U',NULL,NULL,NULL,92777000,N'0504/HĐTK/NHBV-XD',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'TRCPI0001057011',N'TRCI00001055745',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Apr 16 2019 12:00AM',N'U',NULL,NULL,NULL,92777000,N'0504/HĐTK/NHBV-XD',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'TRCPI0001057012',N'TRCI00001055745',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Apr 16 2019 12:00AM',N'U',NULL,NULL,NULL,92777000,N'0504/HĐTK/NHBV-XD',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'TRCPI0001057013',N'TRCI00001055745',N'4',N'Aug 21 2020  8:18AM',10.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Apr 16 2019 12:00AM',N'U',NULL,NULL,NULL,30926080,N'0504/HĐTK/NHBV-XD',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'TRCPI0001057014',N'TRCI00001055746',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí thi công tầng 10+11+12',N'1',N'Tanvt',N'May 15 2019 12:00AM',N'U',NULL,NULL,NULL,147986520,NULL,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'TRCPI0001057015',N'TRCI00001055747',N'1',N'Aug 21 2020  8:18AM',95.00,NULL,NULL,N'Thanh toán đợt 1 + 2 + 3',N'1',N'Tanvt',N'May 16 2019 12:00AM',N'U',NULL,NULL,NULL,75043017,N'2204/2019/NHBV-NP',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'TRCPI0001057016',N'TRCI00001055747',N'2',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'May 16 2019 12:00AM',N'U',NULL,NULL,NULL,3990443,N'2204/2019/NHBV-NP',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'TRCPI0001057017',N'TRCI00001055748',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí thi công cửa cuốn PGD Bến Lức',N'1',N'Tanvt',N'Jul 22 2019 12:00AM',N'U',NULL,NULL,NULL,25418800,NULL,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'TRCPI0001057018',N'TRCI00001055749',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Nov  6 2019 12:00AM',N'U',NULL,NULL,NULL,220545930,N'21-10/2019/BVB-ASIA',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'TRCPI0001057019',N'TRCI00001055749',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Nov  6 2019 12:00AM',N'U',NULL,NULL,NULL,220545930,N'21-10/2019/BVB-ASIA',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'TRCPI0001057020',N'TRCI00001055749',N'3',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Nov  6 2019 12:00AM',N'U',NULL,NULL,NULL,0,N'21-10/2019/BVB-ASIA',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'TRCPI0001057021',N'TRCI00001055749',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Nov  6 2019 12:00AM',N'U',NULL,NULL,NULL,294061240,N'21-10/2019/BVB-ASIA',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'TRCPI0001057022',N'TRCI00001055750',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'U',NULL,NULL,NULL,376100175,N'1811/2019/BVB-HĐ',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'TRCPI0001057023',N'TRCI00001055750',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'U',NULL,NULL,NULL,376100000,N'1811/2019/BVB-HĐ',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'TRCPI0001057024',N'TRCI00001055750',N'3',N'Aug 21 2020  8:18AM',35.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'U',NULL,NULL,NULL,324997372,N'1811/2019/BVB-HĐ',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'TRCPI0001057025',N'TRCI00001055750',N'4',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán đợt 4',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'U',NULL,NULL,NULL,176469703,N'1811/2019/BVB-HĐ',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'TRCPI0001057026',N'TRCI00001055750',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí phát sinh thi công HO',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'U',NULL,NULL,NULL,179486962,N'1811/2019/BVB-HĐ',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'TRCPI0001057027',N'TRCI00001055750',N'2',N'Aug 21 2020  8:18AM',5.00,NULL,NULL,N'Thanh toán chi phí phát sinh thi công HO',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'U',NULL,NULL,NULL,9446682,N'1811/2019/BVB-HĐ',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'TRCPI0001057028',N'TRCI00001055751',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí Bảng vẫy PGD Thủ Đức',N'1',N'Tanvt',N'Dec 20 2019 12:00AM',N'U',NULL,NULL,NULL,15636632,N'1210/2019/VCCB-Hải Âu',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'TRCPI0001057029',N'TRCI00001055751',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí Thay decal dán kính PGD Nguyễn trãi',N'1',N'Tanvt',N'Dec 20 2019 12:00AM',N'U',NULL,NULL,NULL,13501895,N'1210/2019/VCCB-Hải Âu',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'TRCPI0001057030',N'TRCI00001055751',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán chi phí  Sửa chữa ngoại thất CN Đông Sài Gòn',N'1',N'Tanvt',N'Dec 20 2019 12:00AM',N'U',NULL,NULL,NULL,49444352,N'1210/2019/VCCB-Hải Âu',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'TRCPI0001057031',N'TRCI00001055751',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán chi phí  Sửa chữa ngoại thất CN Đông Sài Gòn',N'1',N'Tanvt',N'Dec 20 2019 12:00AM',N'U',NULL,NULL,NULL,37083264,N'1210/2019/VCCB-Hải Âu',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'TRCPI0001057032',N'TRCI00001055751',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán chi phí  Sửa chữa ngoại thất CN Đông Sài Gòn',N'1',N'Tanvt',N'Dec 20 2019 12:00AM',N'U',NULL,NULL,NULL,37083263,N'1210/2019/VCCB-Hải Âu',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'TRCPI0001057033',N'TRCI00001055752',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Oct 29 2019 12:00AM',N'U',NULL,NULL,NULL,24474340,N'1605/2019/NHBV-TBC',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'TRCPI0001057034',N'TRCI00001055752',N'2',N'Aug 21 2020  8:18AM',70.00,NULL,NULL,N'Thanh toán đợt 2&3',N'1',N'Tanvt',N'Oct 29 2019 12:00AM',N'U',NULL,NULL,NULL,97897360,N'1605/2019/NHBV-TBC',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'TRCPI0001057035',N'TRCI00001055753',N'1',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Nov  8 2019 12:00AM',N'U',NULL,NULL,NULL,203680000,N'1002/2020/BVB-ALPEC',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'TRCPI0001057036',N'TRCI00001055753',N'2',N'Aug 21 2020  8:18AM',50.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Nov  8 2019 12:00AM',N'U',NULL,NULL,NULL,254600000,N'1002/2020/BVB-ALPEC',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'TRCPI0001057037',N'TRCI00001055753',N'3',N'Aug 21 2020  8:18AM',20.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Nov  8 2019 12:00AM',N'U',NULL,NULL,NULL,101840000,N'1002/2020/BVB-ALPEC',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'TRCPI0001057038',N'TRCI00001055753',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí phát sinh thi công cải tạo xây dựng PGD Hóa An',N'1',N'Tanvt',N'Nov  8 2019 12:00AM',N'U',NULL,NULL,NULL,35365000,N'1002/2020/BVB-ALPEC',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'TRCPI0001057039',N'TRCI00001055754',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,89342000,N'1004/2020/BVB-TL',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'TRCPI0001057040',N'TRCI00001055754',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,67006500,N'1004/2020/BVB-TL',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'TRCPI0001057041',N'TRCI00001055754',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,67006500,N'1004/2020/BVB-TL',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'TRCPI0001057042',N'TRCI00001055755',N'1&2',N'Aug 21 2020  8:18AM',70.00,NULL,NULL,N'Thanh toán đợt 1 + 2',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,840000000,N'1003/2020/NHBV-TL',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'TRCPI0001057043',N'TRCI00001055755',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,360000000,N'1003/2020/NHBV-TL',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'TRCPI0001057044',N'TRCI00001055756',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,387691330,N'1210-1/2019/VCCB-Hoàng Phi',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'TRCPI0001057045',N'TRCI00001055756',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,290768498,N'1210-1/2019/VCCB-Hoàng Phi',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'TRCPI0001057046',N'TRCI00001055756',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,290768498,N'1210-1/2019/VCCB-Hoàng Phi',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'TRCPI0001057047',N'TRCI00001055757',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'May 29 2020 12:00AM',N'U',NULL,NULL,NULL,68081200,N'2005/2020/BVB-ASIA',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'TRCPI0001057048',N'TRCI00001055757',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'May 29 2020 12:00AM',N'U',NULL,NULL,NULL,51060900,N'2005/2020/BVB-ASIA',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'TRCPI0001057049',N'TRCI00001055757',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'May 29 2020 12:00AM',N'U',NULL,NULL,NULL,51060900,N'2005/2020/BVB-ASIA',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'TRCPI0001057050',N'TRCI00001055758',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'U',NULL,NULL,NULL,135200000,N'1603/2020/BVB-HĐ',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'TRCPI0001057051',N'TRCI00001055758',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'U',NULL,NULL,NULL,101400000,N'1603/2020/BVB-HĐ',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'TRCPI0001057052',N'TRCI00001055758',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'U',NULL,NULL,NULL,101400000,N'1603/2020/BVB-HĐ',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'TRCPI0001057053',N'TRCI00001055758',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'U',NULL,NULL,NULL,140830417,N'1603/2020/BVB-HĐ',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'TRCPI0001057054',N'TRCI00001055758',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'U',NULL,NULL,NULL,105622813,N'1603/2020/BVB-HĐ',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'TRCPI0001057055',N'TRCI00001055758',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'U',NULL,NULL,NULL,105622813,N'1603/2020/BVB-HĐ',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'TRCPI0001057056',N'TRCI00001055759',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Mar 25 2020 12:00AM',N'U',NULL,NULL,NULL,135200000,N'1603/2020/BVB-HĐ',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'TRCPI0001057057',N'TRCI00001055759',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Mar 25 2020 12:00AM',N'U',NULL,NULL,NULL,101400000,N'1603/2020/BVB-HĐ',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'TRCPI0001057058',N'TRCI00001055759',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Mar 25 2020 12:00AM',N'U',NULL,NULL,NULL,101400000,N'1603/2020/BVB-HĐ',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'TRCPI0001057059',N'TRCI00001055760',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,89342000,N'1004/2020/BVB-TL',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'TRCPI0001057060',N'TRCI00001055760',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'1004/2020/BVB-TL',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'TRCPI0001057061',N'TRCI00001055760',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'1004/2020/BVB-TL',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'TRCPI0001057062',N'TRCI00001055760',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí thi công, lắp đặt mới buồng ATM cho PGD Phú Tân',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'U',NULL,NULL,NULL,68013970,N'1004/2020/BVB-TL',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'TRCPI0001057063',N'TRCI00001055761',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán chi phí cải tạo nội thất di dời PGD Phú Nhuận',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,756989898,N'1206/2020/BVB-ASIA',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'TRCPI0001057064',N'TRCI00001055761',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán chi phí cải tạo nội thất di dời PGD Phú Nhuận',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,567742423,N'1206/2020/BVB-ASIA',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'TRCPI0001057065',N'TRCI00001055761',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán chi phí cải tạo nội thất di dời PGD Phú Nhuận',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,567742423,N'1206/2020/BVB-ASIA',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'TRCPI0001057066',N'TRCI00001055762',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí Thi công cải tạo,sửa chữa TTQLTD HO-Ngân hàng TMCP Bản Việt',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,57777500,N'1206/2020/BVB-NP',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'TRCPI0001057067',N'TRCI00001055762',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,113537682,N'1206/2020/BVB-NP',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'TRCPI0001057068',N'TRCI00001055762',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,85153261,N'1206/2020/BVB-NP',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'TRCPI0001057069',N'TRCI00001055762',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,85153261,N'1206/2020/BVB-NP',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'TRCPI0001057070',N'TRCI00001055762',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,242407908,N'1206/2020/BVB-NP',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'TRCPI0001057071',N'TRCI00001055762',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,181805931,N'1206/2020/BVB-NP',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'TRCPI0001057072',N'TRCI00001055762',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,181805931,N'1206/2020/BVB-NP',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'TRCPI0001057073',N'TRCI00001055763',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',N'Jul 20 2020 12:00AM',N'U',NULL,NULL,NULL,396000000,N'0207/2020/BVB-HĐ',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'TRCPI0001057074',N'TRCI00001055763',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',N'Jul 20 2020 12:00AM',N'U',NULL,NULL,NULL,297000000,N'0207/2020/BVB-HĐ',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'TRCPI0001057075',N'TRCI00001055763',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',N'Jul 20 2020 12:00AM',N'U',NULL,NULL,NULL,297000000,N'0207/2020/BVB-HĐ',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'TRCPI0001057076',N'TRCI00001055764',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,372000000,N'0307/2020/BVB-PS',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'TRCPI0001057077',N'TRCI00001055764',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,279000000,N'0307/2020/BVB-PS',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'TRCPI0001057078',N'TRCI00001055764',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,279000000,N'0307/2020/BVB-PS',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'TRCPI0001057079',N'TRCI00001055765',N'1',N'Aug 21 2020  8:18AM',40.00,NULL,NULL,N'Thanh toán đợt 1',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,191909520,N'0607/2020/BVB-PS',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'TRCPI0001057080',N'TRCI00001055765',N'2',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 2',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,143932140,N'0607/2020/BVB-PS',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'TRCPI0001057081',N'TRCI00001055765',N'3',N'Aug 21 2020  8:18AM',30.00,NULL,NULL,N'Thanh toán đợt 3',N'1',N'Tanvt',NULL,N'U',NULL,NULL,NULL,143932140,N'0607/2020/BVB-PS',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'TRCPI0001057082',N'TRCI00001055766',N'1',N'Aug 21 2020  8:18AM',100.00,NULL,NULL,N'Thanh toán chi phí vận chuyển',N'1',N'Tanvt',N'Feb 25 2020 12:00AM',N'U',NULL,NULL,NULL,5049000,NULL,NULL,NULL)