|
1
|
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'TRCI00001055894',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'TRRDI0001125754',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Apr 16 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125754',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
2
|
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'TRCI00001055896',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'TRRDI0001125756',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'May 16 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125756',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
3
|
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'TRCI00001055915',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'TRRDI0001125782',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'TRRDI0001125782',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
4
|
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'TRCI00001055897',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'TRRDI0001125757',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'TRRDI0001125757',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
5
|
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'TRCI00001055898',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'TRRDI0001125758',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov 6 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125758',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
6
|
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'TRCI00001055899',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'TRRDI0001125759',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov 25 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125759',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
7
|
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'TRCI00001055900',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'TRRDI0001125761',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'TRRDI0001125761',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
8
|
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'TRCI00001055901',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'TRRDI0001125764',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Oct 29 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125764',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
9
|
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'TRCI00001055902',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)
|
|
10
|
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'TRCI00001055903',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'TRRDI0001125772',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125772',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
11
|
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'TRCI00001055904',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'TRRDI0001125766',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'TRRDI0001125766',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
12
|
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'TRCI00001055905',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'TRRDI0001125767',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125767',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
13
|
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'TRCI00001055906',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'TRRDI0001125768',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'TRRDI0001125768',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
14
|
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'TRCI00001055907',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'TRRDI0001125769',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 24 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125769',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
15
|
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'TRCI00001055908',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'TRRDI0001125769',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 25 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125769',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
16
|
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'TRCI00001055909',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'TRRDI0001125772',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Mar 26 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125772',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
17
|
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'TRCI00001055910',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'TRRDI0001125774',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',NULL,N'A',N'Phuongtln1',N'Jan 7 2020 12:00AM',NULL,N'TRRDI0001125774',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
18
|
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'TRCI00001055912',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'TRRDI0001125778',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Jul 20 2020 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125778',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
19
|
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'TRCI00001055913',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'TRRDI0001125780',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',NULL,N'A',N'Phuongtln1',N'Oct 8 2020 12:00AM',NULL,N'TRRDI0001125780',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
20
|
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'TRCI00001055914',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'TRRDI0001125781',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',NULL,N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125781',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
21
|
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'TRCI00001055911',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'TRRDI0001125776',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',NULL,N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125776',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
22
|
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'TRCI00001055879',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'TRRDI0001125739',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'TRRDI0001125739',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
23
|
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'TRCI00001055880',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'TRRDI0001125740',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'TRRDI0001125740',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
24
|
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'TRCI00001055881',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'TRRDI0001125741',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Jun 13 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125741',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
25
|
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'TRCI00001055882',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'TRRDI0001125742',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'TRRDI0001125742',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
26
|
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'TRCI00001055883',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'TRRDI0001125743',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Aug 1 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125743',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
27
|
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'TRCI00001055884',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'TRRDI0001125744',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Sep 13 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125744',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
28
|
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'TRCI00001055885',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'TRRDI0001125745',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov 6 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125745',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
29
|
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'TRCI00001055886',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'TRRDI0001125746',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Nov 13 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125746',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
30
|
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'TRCI00001055887',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'TRRDI0001125747',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Dec 17 2018 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125747',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
31
|
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'TRCI00001055888',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'TRRDI0001125748',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'TRRDI0001125748',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
32
|
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'TRCI00001055889',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'TRRDI0001125749',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'TRRDI0001125749',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
33
|
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'TRCI00001055890',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'TRRDI0001125750',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'TRRDI0001125750',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
34
|
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'TRCI00001055891',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'TRRDI0001125751',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125751',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
35
|
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'TRCI00001055892',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'TRRDI0001125752',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'Tanvt',N'Feb 19 2019 12:00AM',N'A',N'Phuongtln1',NULL,NULL,N'TRRDI0001125752',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
36
|
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'TRCI00001055893',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'TRRDI0001125753',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'TRRDI0001125753',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
37
|
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'TRCI00001055895',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'TRRDI0001125755',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'TRRDI0001125755',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)
|
|
38
|
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'TRCDI0001055987',N'TRCI00001055879',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)
|
|
39
|
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'TRCDI0001055988',N'TRCI00001055880',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)
|
|
40
|
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'TRCDI0001055989',N'TRCI00001055881',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)
|
|
41
|
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'TRCDI0001055990',N'TRCI00001055882',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)
|
|
42
|
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'TRCDI0001055991',N'TRCI00001055883',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)
|
|
43
|
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'TRCDI0001055992',N'TRCI00001055884',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)
|
|
44
|
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'TRCDI0001055993',N'TRCI00001055885',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)
|
|
45
|
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'TRCDI0001055994',N'TRCI00001055886',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)
|
|
46
|
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'TRCDI0001055995',N'TRCI00001055887',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)
|
|
47
|
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'TRCDI0001055996',N'TRCI00001055888',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)
|
|
48
|
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'TRCDI0001055997',N'TRCI00001055889',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)
|
|
49
|
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'TRCDI0001055998',N'TRCI00001055890',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)
|
|
50
|
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'TRCDI0001055999',N'TRCI00001055891',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)
|
|
51
|
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'TRCDI0001056000',N'TRCI00001055892',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)
|
|
52
|
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'TRCDI0001056001',N'TRCI00001055893',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)
|
|
53
|
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'TRCDI0001056002',N'TRCI00001055894',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)
|
|
54
|
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'TRCDI0001056003',N'TRCI00001055895',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)
|
|
55
|
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'TRCDI0001056004',N'TRCI00001055896',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)
|
|
56
|
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'TRCDI0001056005',N'TRCI00001055897',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)
|
|
57
|
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'TRCDI0001056006',N'TRCI00001055898',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)
|
|
58
|
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'TRCDI0001056007',N'TRCI00001055899',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)
|
|
59
|
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'TRCDI0001056008',N'TRCI00001055900',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)
|
|
60
|
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'TRCDI0001056009',N'TRCI00001055900',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)
|
|
61
|
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'TRCDI0001056010',N'TRCI00001055901',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)
|
|
62
|
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'TRCDI0001056011',N'TRCI00001055902',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)
|
|
63
|
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'TRCDI0001056012',N'TRCI00001055903',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)
|
|
64
|
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'TRCDI0001056013',N'TRCI00001055904',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)
|
|
65
|
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'TRCDI0001056014',N'TRCI00001055905',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)
|
|
66
|
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'TRCDI0001056015',N'TRCI00001055906',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)
|
|
67
|
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'TRCDI0001056016',N'TRCI00001055907',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)
|
|
68
|
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'TRCDI0001056017',N'TRCI00001055907',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)
|
|
69
|
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'TRCDI0001056018',N'TRCI00001055908',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)
|
|
70
|
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'TRCDI0001056019',N'TRCI00001055909',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)
|
|
71
|
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'TRCDI0001056020',N'TRCI00001055909',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)
|
|
72
|
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'TRCDI0001056021',N'TRCI00001055910',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)
|
|
73
|
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'TRCDI0001056022',N'TRCI00001055911',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)
|
|
74
|
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'TRCDI0001056023',N'TRCI00001055911',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)
|
|
75
|
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'TRCDI0001056024',N'TRCI00001055912',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)
|
|
76
|
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'TRCDI0001056025',N'TRCI00001055913',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)
|
|
77
|
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'TRCDI0001056026',N'TRCI00001055914',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)
|
|
78
|
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'TRCDI0001056027',N'TRCI00001055915',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)
|
|
79
|
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'TRCPI0001057314',N'TRCI00001055879',N'1',N'Aug 21 2020 10:25AM',30.00,50610780,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)
|
|
80
|
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'TRCPI0001057315',N'TRCI00001055879',N'2',N'Aug 21 2020 10:25AM',65.00,93454070,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)
|
|
81
|
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'TRCPI0001057316',N'TRCI00001055879',N'3',N'Aug 21 2020 10:25AM',5.00,24637750,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)
|
|
82
|
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'TRCPI0001057317',N'TRCI00001055880',N'1',N'Aug 21 2020 10:25AM',30.00,137893176,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)
|
|
83
|
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'TRCPI0001057318',N'TRCI00001055880',N'2',N'Aug 21 2020 10:25AM',30.00,137893176,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)
|
|
84
|
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'TRCPI0001057319',N'TRCI00001055880',N'3',N'Aug 21 2020 10:25AM',35.00,157663346,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)
|
|
85
|
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'TRCPI0001057320',N'TRCI00001055880',N'4',N'Aug 21 2020 10:25AM',5.00,26194223,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)
|
|
86
|
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'TRCPI0001057321',N'TRCI00001055881',N'1+2+3',N'Aug 21 2020 10:25AM',95.00,174421624,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)
|
|
87
|
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'TRCPI0001057322',N'TRCI00001055881',N'4',N'Aug 21 2020 10:25AM',5.00,25162866,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)
|
|
88
|
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'TRCPI0001057323',N'TRCI00001055882',N'1',N'Aug 21 2020 10:25AM',30.00,510233140,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)
|
|
89
|
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'TRCPI0001057324',N'TRCI00001055882',N'2',N'Aug 21 2020 10:25AM',30.00,510233140,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)
|
|
90
|
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'TRCPI0001057325',N'TRCI00001055882',N'3',N'Aug 21 2020 10:25AM',35.00,524937665,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)
|
|
91
|
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'TRCPI0001057326',N'TRCI00001055882',N'4',N'Aug 21 2020 10:25AM',5.00,155373188,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)
|
|
92
|
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'TRCPI0001057327',N'TRCI00001055883',N'1',N'Aug 21 2020 10:25AM',30.00,177155315,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)
|
|
93
|
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'TRCPI0001057328',N'TRCI00001055883',N'2',N'Aug 21 2020 10:25AM',30.00,177155315,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)
|
|
94
|
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'TRCPI0001057329',N'TRCI00001055883',N'3',N'Aug 21 2020 10:25AM',35.00,136028868,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)
|
|
95
|
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'TRCPI0001057330',N'TRCI00001055883',N'4',N'Aug 21 2020 10:25AM',5.00,100178219,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)
|
|
96
|
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'TRCPI0001057331',N'TRCI00001055884',N'1',N'Aug 21 2020 10:25AM',30.00,213248304,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)
|
|
97
|
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'TRCPI0001057332',N'TRCI00001055884',N'2',N'Aug 21 2020 10:25AM',30.00,213248304,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)
|
|
98
|
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'TRCPI0001057333',N'TRCI00001055884',N'3',N'Aug 21 2020 10:25AM',35.00,220891646,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)
|
|
99
|
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'TRCPI0001057334',N'TRCI00001055884',N'4',N'Aug 21 2020 10:25AM',5.00,63439425,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)
|
|
100
|
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'TRCPI0001057335',N'TRCI00001055885',N'1',N'Aug 21 2020 10:25AM',50.00,296051800,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)
|
|
101
|
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'TRCPI0001057336',N'TRCI00001055885',N'2',N'Aug 21 2020 10:25AM',50.00,296051800,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)
|
|
102
|
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'TRCPI0001057337',N'TRCI00001055886',N'1+2+3',N'Aug 21 2020 10:25AM',95.00,131321545,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)
|
|
103
|
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'TRCPI0001057338',N'TRCI00001055886',N'4',N'Aug 21 2020 10:25AM',5.00,11817660,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)
|
|
104
|
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'TRCPI0001057339',N'TRCI00001055887',N'1',N'Aug 21 2020 10:25AM',60.00,70472820,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)
|
|
105
|
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'TRCPI0001057340',N'TRCI00001055887',N'2',N'Aug 21 2020 10:25AM',35.00,41109145,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)
|
|
106
|
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'TRCPI0001057341',N'TRCI00001055887',N'3',N'Aug 21 2020 10:25AM',5.00,5872735,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)
|
|
107
|
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'TRCPI0001057342',N'TRCI00001055888',N'1',N'Aug 21 2020 10:25AM',30.00,52574115,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)
|
|
108
|
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'TRCPI0001057343',N'TRCI00001055888',N'2+3',N'Aug 21 2020 10:25AM',65.00,63020127,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)
|
|
109
|
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'TRCPI0001057344',N'TRCI00001055888',N'3',N'Aug 21 2020 10:25AM',5.00,59652808,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)
|
|
110
|
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'TRCPI0001057345',N'TRCI00001055889',N'5',N'Aug 21 2020 10:25AM',25.00,336096684,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)
|
|
111
|
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'TRCPI0001057346',N'TRCI00001055890',N'1',N'Aug 21 2020 10:25AM',30.00,257877114,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)
|
|
112
|
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'TRCPI0001057347',N'TRCI00001055890',N'2',N'Aug 21 2020 10:25AM',30.00,257877114,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)
|
|
113
|
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'TRCPI0001057348',N'TRCI00001055890',N'3',N'Aug 21 2020 10:25AM',35.00,215992562,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)
|
|
114
|
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'TRCPI0001057349',N'TRCI00001055890',N'4',N'Aug 21 2020 10:25AM',5.00,127843590,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)
|
|
115
|
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'TRCPI0001057350',N'TRCI00001055891',N'1',N'Aug 21 2020 10:25AM',30.00,195746150,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)
|
|
116
|
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'TRCPI0001057351',N'TRCI00001055891',N'2',N'Aug 21 2020 10:25AM',30.00,195746150,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)
|
|
117
|
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'TRCPI0001057352',N'TRCI00001055891',N'3',N'Aug 21 2020 10:25AM',35.00,63879408,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)
|
|
118
|
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'TRCPI0001057353',N'TRCI00001055891',N'4',N'Aug 21 2020 10:25AM',5.00,197115457,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)
|
|
119
|
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'TRCPI0001057354',N'TRCI00001055892',N'1',N'Aug 21 2020 10:25AM',30.00,29319180,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)
|
|
120
|
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'TRCPI0001057355',N'TRCI00001055892',N'2',N'Aug 21 2020 10:25AM',65.00,51162540,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)
|
|
121
|
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'TRCPI0001057356',N'TRCI00001055892',N'3',N'Aug 21 2020 10:25AM',5.00,17248880,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)
|
|
122
|
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'TRCPI0001057357',N'TRCI00001055893',N'1',N'Aug 21 2020 10:25AM',30.00,144300000,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)
|
|
123
|
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'TRCPI0001057358',N'TRCI00001055893',N'2',N'Aug 21 2020 10:25AM',30.00,144300000,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)
|
|
124
|
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'TRCPI0001057359',N'TRCI00001055893',N'3',N'Aug 21 2020 10:25AM',30.00,144300000,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)
|
|
125
|
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'TRCPI0001057360',N'TRCI00001055893',N'4',N'Aug 21 2020 10:25AM',10.00,48101730,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)
|
|
126
|
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'TRCPI0001057361',N'TRCI00001055894',N'1',N'Aug 21 2020 10:25AM',30.00,92777000,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)
|
|
127
|
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'TRCPI0001057362',N'TRCI00001055894',N'2',N'Aug 21 2020 10:25AM',30.00,92777000,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)
|
|
128
|
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'TRCPI0001057363',N'TRCI00001055894',N'3',N'Aug 21 2020 10:25AM',30.00,92777000,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)
|
|
129
|
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'TRCPI0001057364',N'TRCI00001055894',N'4',N'Aug 21 2020 10:25AM',10.00,30926080,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)
|
|
130
|
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'TRCPI0001057365',N'TRCI00001055895',N'1',N'Aug 21 2020 10:25AM',100.00,147986520,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)
|
|
131
|
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'TRCPI0001057366',N'TRCI00001055896',N'1',N'Aug 21 2020 10:25AM',95.00,75043017,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)
|
|
132
|
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'TRCPI0001057367',N'TRCI00001055896',N'2',N'Aug 21 2020 10:25AM',5.00,3990443,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)
|
|
133
|
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'TRCPI0001057368',N'TRCI00001055897',N'1',N'Aug 21 2020 10:25AM',100.00,25418800,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)
|
|
134
|
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'TRCPI0001057369',N'TRCI00001055898',N'1',N'Aug 21 2020 10:25AM',30.00,220545930,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)
|
|
135
|
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'TRCPI0001057370',N'TRCI00001055898',N'2',N'Aug 21 2020 10:25AM',30.00,220545930,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)
|
|
136
|
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'TRCPI0001057371',N'TRCI00001055898',N'3',N'Aug 21 2020 10:25AM',35.00,0,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)
|
|
137
|
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'TRCPI0001057372',N'TRCI00001055898',N'4',N'Aug 21 2020 10:25AM',5.00,294061240,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)
|
|
138
|
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'TRCPI0001057373',N'TRCI00001055899',N'1',N'Aug 21 2020 10:25AM',30.00,376100175,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)
|
|
139
|
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'TRCPI0001057374',N'TRCI00001055899',N'2',N'Aug 21 2020 10:25AM',30.00,376100000,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)
|
|
140
|
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'TRCPI0001057375',N'TRCI00001055899',N'3',N'Aug 21 2020 10:25AM',35.00,324997372,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)
|
|
141
|
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'TRCPI0001057376',N'TRCI00001055899',N'4',N'Aug 21 2020 10:25AM',5.00,176469703,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)
|
|
142
|
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'TRCPI0001057377',N'TRCI00001055899',N'1',N'Aug 21 2020 10:25AM',100.00,179486962,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)
|
|
143
|
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'TRCPI0001057378',N'TRCI00001055899',N'2',N'Aug 21 2020 10:25AM',5.00,9446682,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)
|
|
144
|
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'TRCPI0001057379',N'TRCI00001055900',N'1',N'Aug 21 2020 10:25AM',100.00,15636632,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)
|
|
145
|
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'TRCPI0001057380',N'TRCI00001055900',N'1',N'Aug 21 2020 10:25AM',100.00,13501895,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)
|
|
146
|
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'TRCPI0001057381',N'TRCI00001055900',N'1',N'Aug 21 2020 10:25AM',40.00,49444352,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)
|
|
147
|
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'TRCPI0001057382',N'TRCI00001055900',N'2',N'Aug 21 2020 10:25AM',30.00,37083264,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)
|
|
148
|
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'TRCPI0001057383',N'TRCI00001055900',N'3',N'Aug 21 2020 10:25AM',30.00,37083263,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)
|
|
149
|
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'TRCPI0001057384',N'TRCI00001055901',N'1',N'Aug 21 2020 10:25AM',30.00,24474340,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)
|
|
150
|
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'TRCPI0001057385',N'TRCI00001055901',N'2',N'Aug 21 2020 10:25AM',70.00,97897360,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)
|
|
151
|
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'TRCPI0001057386',N'TRCI00001055902',N'1',N'Aug 21 2020 10:25AM',30.00,203680000,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)
|
|
152
|
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'TRCPI0001057387',N'TRCI00001055902',N'2',N'Aug 21 2020 10:25AM',50.00,254600000,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)
|
|
153
|
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'TRCPI0001057388',N'TRCI00001055902',N'3',N'Aug 21 2020 10:25AM',20.00,101840000,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)
|
|
154
|
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'TRCPI0001057389',N'TRCI00001055902',N'1',N'Aug 21 2020 10:25AM',100.00,35365000,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)
|
|
155
|
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'TRCPI0001057390',N'TRCI00001055903',N'1',N'Aug 21 2020 10:25AM',40.00,89342000,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)
|
|
156
|
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'TRCPI0001057391',N'TRCI00001055903',N'2',N'Aug 21 2020 10:25AM',30.00,67006500,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)
|
|
157
|
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'TRCPI0001057392',N'TRCI00001055903',N'3',N'Aug 21 2020 10:25AM',30.00,67006500,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)
|
|
158
|
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'TRCPI0001057393',N'TRCI00001055904',N'1&2',N'Aug 21 2020 10:25AM',70.00,840000000,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)
|
|
159
|
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'TRCPI0001057394',N'TRCI00001055904',N'3',N'Aug 21 2020 10:25AM',30.00,360000000,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)
|
|
160
|
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'TRCPI0001057395',N'TRCI00001055905',N'1',N'Aug 21 2020 10:25AM',40.00,387691330,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)
|
|
161
|
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'TRCPI0001057396',N'TRCI00001055905',N'2',N'Aug 21 2020 10:25AM',30.00,290768498,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)
|
|
162
|
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'TRCPI0001057397',N'TRCI00001055905',N'3',N'Aug 21 2020 10:25AM',30.00,290768498,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)
|
|
163
|
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'TRCPI0001057398',N'TRCI00001055906',N'1',N'Aug 21 2020 10:25AM',40.00,68081200,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)
|
|
164
|
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'TRCPI0001057399',N'TRCI00001055906',N'2',N'Aug 21 2020 10:25AM',30.00,51060900,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)
|
|
165
|
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'TRCPI0001057400',N'TRCI00001055906',N'3',N'Aug 21 2020 10:25AM',30.00,51060900,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)
|
|
166
|
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'TRCPI0001057401',N'TRCI00001055907',N'1',N'Aug 21 2020 10:25AM',40.00,135200000,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)
|
|
167
|
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'TRCPI0001057402',N'TRCI00001055907',N'2',N'Aug 21 2020 10:25AM',30.00,101400000,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)
|
|
168
|
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'TRCPI0001057403',N'TRCI00001055907',N'3',N'Aug 21 2020 10:25AM',30.00,101400000,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)
|
|
169
|
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'TRCPI0001057404',N'TRCI00001055907',N'1',N'Aug 21 2020 10:25AM',40.00,140830417,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)
|
|
170
|
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'TRCPI0001057405',N'TRCI00001055907',N'2',N'Aug 21 2020 10:25AM',30.00,105622813,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)
|
|
171
|
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'TRCPI0001057406',N'TRCI00001055907',N'3',N'Aug 21 2020 10:25AM',30.00,105622813,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)
|
|
172
|
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'TRCPI0001057407',N'TRCI00001055908',N'1',N'Aug 21 2020 10:25AM',40.00,135200000,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)
|
|
173
|
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'TRCPI0001057408',N'TRCI00001055908',N'2',N'Aug 21 2020 10:25AM',30.00,101400000,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)
|
|
174
|
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'TRCPI0001057409',N'TRCI00001055908',N'3',N'Aug 21 2020 10:25AM',30.00,101400000,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)
|
|
175
|
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'TRCPI0001057410',N'TRCI00001055909',N'1',N'Aug 21 2020 10:25AM',40.00,89342000,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)
|
|
176
|
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'TRCPI0001057411',N'TRCI00001055909',N'2',N'Aug 21 2020 10:25AM',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)
|
|
177
|
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'TRCPI0001057412',N'TRCI00001055909',N'3',N'Aug 21 2020 10:25AM',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)
|
|
178
|
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'TRCPI0001057413',N'TRCI00001055909',N'1',N'Aug 21 2020 10:25AM',100.00,68013970,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)
|
|
179
|
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'TRCPI0001057414',N'TRCI00001055910',N'1',N'Aug 21 2020 10:25AM',40.00,756989898,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)
|
|
180
|
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'TRCPI0001057415',N'TRCI00001055910',N'2',N'Aug 21 2020 10:25AM',30.00,567742423,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)
|
|
181
|
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'TRCPI0001057416',N'TRCI00001055910',N'3',N'Aug 21 2020 10:25AM',30.00,567742423,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)
|
|
182
|
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'TRCPI0001057417',N'TRCI00001055911',N'1',N'Aug 21 2020 10:25AM',100.00,57777500,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)
|
|
183
|
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'TRCPI0001057418',N'TRCI00001055911',N'1',N'Aug 21 2020 10:25AM',40.00,113537682,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)
|
|
184
|
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'TRCPI0001057419',N'TRCI00001055911',N'2',N'Aug 21 2020 10:25AM',30.00,85153261,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)
|
|
185
|
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'TRCPI0001057420',N'TRCI00001055911',N'3',N'Aug 21 2020 10:25AM',30.00,85153261,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)
|
|
186
|
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'TRCPI0001057421',N'TRCI00001055911',N'1',N'Aug 21 2020 10:25AM',40.00,242407908,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)
|
|
187
|
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'TRCPI0001057422',N'TRCI00001055911',N'2',N'Aug 21 2020 10:25AM',30.00,181805931,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)
|
|
188
|
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'TRCPI0001057423',N'TRCI00001055911',N'3',N'Aug 21 2020 10:25AM',30.00,181805931,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)
|
|
189
|
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'TRCPI0001057424',N'TRCI00001055912',N'1',N'Aug 21 2020 10:25AM',40.00,396000000,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)
|
|
190
|
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'TRCPI0001057425',N'TRCI00001055912',N'2',N'Aug 21 2020 10:25AM',30.00,297000000,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)
|
|
191
|
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'TRCPI0001057426',N'TRCI00001055912',N'3',N'Aug 21 2020 10:25AM',30.00,297000000,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)
|
|
192
|
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'TRCPI0001057427',N'TRCI00001055913',N'1',N'Aug 21 2020 10:25AM',40.00,372000000,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)
|
|
193
|
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'TRCPI0001057428',N'TRCI00001055913',N'2',N'Aug 21 2020 10:25AM',30.00,279000000,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)
|
|
194
|
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'TRCPI0001057429',N'TRCI00001055913',N'3',N'Aug 21 2020 10:25AM',30.00,279000000,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)
|
|
195
|
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'TRCPI0001057430',N'TRCI00001055914',N'1',N'Aug 21 2020 10:25AM',40.00,191909520,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)
|
|
196
|
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'TRCPI0001057431',N'TRCI00001055914',N'2',N'Aug 21 2020 10:25AM',30.00,143932140,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)
|
|
197
|
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'TRCPI0001057432',N'TRCI00001055914',N'3',N'Aug 21 2020 10:25AM',30.00,143932140,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)
|
|
198
|
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'TRCPI0001057433',N'TRCI00001055915',N'1',N'Aug 21 2020 10:25AM',100.00,5049000,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)
|