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

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055204',N'44/HDDV-SVICC-BanViet',N'CUNG CẤP DỊCH VỤ THẨM ĐỊNH GIÁ NHÀ VÀ XE CHO NGÂN HÀNG',N'1',NULL,NULL,45000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Dec 27 2019 12:00AM',N'A',N'PHUONGTLN1',N'Jan  7 2020 12:00AM',NULL,NULL,NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055205',N'23/2018/HD/IB.VCSC ',N'ĐĂNG KÝ GIAO DỊCH CHỨNG KHOÁN TRÊN HỆ THỐNG GIAO DỊCH UPCOM',N'1',NULL,NULL,220000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Aug 22 2018 12:00AM',N'A',N'PHUONGTLN1',N'Aug 27 2018 12:00AM',NULL,NULL,NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055206',N'14/2018/HD-IB.VCSC',N'PHÁT HÀNH CỔ PHIẾU CHO CỔ ĐÔNG HIỆN HỮU',N'1',NULL,NULL,220000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Aug 22 2018 12:00AM',N'A',N'PHUONGTLN1',N'Aug 27 2018 12:00AM',NULL,NULL,NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055207',N'17/HĐQC-2019',N'THỰC HIỆN BIỂN QUẢNG CÁO NGOÀI TRỜI TẠI TỈNH BÌNH DƯƠNG',N'1',NULL,NULL,308000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056070',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'May 29 2019 12:00AM',N'A',N'PHUONGTLN1',N'Jun  5 2019 12:00AM',NULL,N'TRRDI0001056070',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055208',N'05/HĐQC-VBF-VIETCAPITALBANK',N'CUNG CẤP DỊCH VỤ QUẢNG CÁO THƯƠNG HIỆU',N'1',NULL,N'CMS000001126323',3000000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056068',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Oct 30 2018 12:00AM',N'A',N'PHUONGTLN1',N'Dec 13 2018 12:00AM',NULL,N'TRRDI0001056068',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055209',N'02122019/VCCB-NICHE/PR',N'TRIỂN KHAI BÀI VIẾT TRUYỀN THÔNGBÁO CHÍ QUÝ 4/2019 VÀ THÁNG 01,02/2020',N'1',NULL,NULL,318230000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056069',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Nov 15 2019 12:00AM',N'A',N'PHUONGTLN1',N'Dec 17 2019 12:00AM',NULL,N'TRRDI0001056069',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055210',N' 02/VIETCAPITAL-SN/02/2020',N'HỢP ĐỒNG DỊCH VỤ ĐĂNG KÝ NHÃN HIỆU HÀNG HÓA TẠI VIỆT NAM',N'1',NULL,N'CMS000001126321',7000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056071',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Feb 11 2020 12:00AM',N'A',N'PHUONGTLN1',N'Mar  2 2020 12:00AM',NULL,N'TRRDI0001056071',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055211',N'026/HĐQC/ME-BANVIET',N'Cho thuê mặt bằng quảng cáo tại Sân bay TSN',N'1',NULL,N'CMS000001126286',3836250000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056072',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Feb 18 2020 12:00AM',N'A',N'PHUONGTLN1',N'Mar  6 2020 12:00AM',NULL,N'TRRDI0001056072',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055212',N'15052020/HDMB/BV-ACE',N'CUNG CẤP QUÀ TẶNG GỐI KÊ CỔ',N'1',NULL,NULL,347050000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056074',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Mar  3 2020 12:00AM',N'A',N'PHUONGTLN1',N'May 15 2020 12:00AM',NULL,N'TRRDI0001056074',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055213',N'28022020/HDHT/UREKA - BAN VIET',N'CUNG CẤP DỊCH VỤ QUẢNG CÁO TRỰC TUYẾN',N'1',NULL,N'CMS000001126233',99000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056075',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Mar 16 2020 12:00AM',N'A',N'PHUONGTLN1',N'Jun 15 2020 12:00AM',NULL,N'TRRDI0001056075',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055214',N'27022019/HDHT/UREKA - BAN VIET',N'CUNG CẤP DỊCH VỤ QUẢNG CÁO TRỰC TUYẾN',N'1',NULL,N'CMS000001126233',149999850,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056076',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Mar 16 2020 12:00AM',N'A',N'PHUONGTLN1',N'Jun 17 2020 12:00AM',NULL,N'TRRDI0001056076',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055215',N'B2B/2019/ DAYONE - BVB',N'THỎA THUẬN HƠP TÁC CUNG CẤP EVOUCHER GOT IT',N'1',NULL,N'CMS000001126267',125000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056080',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Apr 22 2020 12:00AM',N'A',N'PHUONGTLN1',N'May  7 2020 12:00AM',NULL,N'TRRDI0001056080',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055216',N'120/HĐDV-DoanhNghiep-BanViet',N'HỢP ĐỒNG DỊCH VỤ THẨM ĐỊNH GIÁ XE',N'1',NULL,NULL,32000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056081',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Apr 27 2020 12:00AM',N'A',N'PHUONGTLN1',N'May  6 2020 12:00AM',NULL,N'TRRDI0001056081',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055217',N'42/HDKT/2020',N'QUẢNG CÁO TẠI SÂN BAY NỘI BÀI',N'1',NULL,NULL,840655200,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056083',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'May 12 2020 12:00AM',N'A',N'PHUONGTLN1',N'May 13 2020 12:00AM',NULL,N'TRRDI0001056083',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055218',N'15-2019/HĐNT-LIENSON-VCCB',N'IN ẤN ẤN PHẨM',N'1',NULL,N'CMS000001126278',7920000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'A',N'PHUONGTLN1',N'Jul  1 2020 12:00AM',NULL,NULL,NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT] ([CONTRACT_ID],[CONTRACT_CODE],[CONTRACT_NAME],[CONTRACT_TYPE],[BID_ID],[SUP_ID],[TOTAL_AMT],[DELIVERY_DT],[FORM1],[VOUCHER_ID1],[BANK1],[AMOUNT1],[EXP_DT1],[RATE1],[FORM2],[VOUCHER_ID2],[BANK2],[AMOUNT2],[EXP_DT2],[RATE2],[REQ_DOC_ID],[REQ_DOC_CONTENT],[APPROVE_VALUE],[SIGN_DT],[CONSTRUCT_PROGRESS],[START_DT],[END_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IS_PARENT],[REQUEST_ID],[CONTRACT_PARENT],[IS_CLOSED],[CONT_TYPE],[CUST_ID],[BRANCH_ID],[EXP_CONTRACT],[DEPOSIT_AMT],[TYPE_PERIOD],[DEPOSIT_NOTE])VALUES(N'TRCI00001055219',N'68/2020/SSV-BV/HĐHT',N'THỎA THUẬN HƠP TÁC CUNG CẤP EVOUCHER 7ELEVEN',N'1',NULL,N'CMS000001126266',200000000,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'TRRDI0001056092',NULL,0,NULL,0,NULL,NULL,N'',N'1',N'PHUONGVN',N'Jun 24 2020 12:00AM',N'A',N'PHUONGTLN1',NULL,NULL,N'TRRDI0001056092',NULL,NULL,N'MS',NULL,N'DV0001',NULL,0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055244',N'TRCI00001055204',NULL,NULL,1,45000000,N'',N'1',N'PHUONGVN',N'Dec 27 2019 12:00AM',N'U',NULL,NULL,N'Phí dịch vụ',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055245',N'TRCI00001055204',NULL,NULL,1,25000000,N'',N'1',N'PHUONGVN',N'Dec 27 2019 12:00AM',N'U',NULL,NULL,N'Dịch vụ định giá tài sản',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055246',N'TRCI00001055205',NULL,NULL,1,220000000,N'',N'1',N'PHUONGVN',N'Aug 22 2018 12:00AM',N'U',NULL,NULL,N'Tư vấn pháp lý',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055247',N'TRCI00001055206',NULL,NULL,1,220000000,N'',N'1',N'PHUONGVN',N'Aug 22 2018 12:00AM',N'U',NULL,NULL,N'Tư vấn pháp lý',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055248',N'TRCI00001055207',N'HH0000000112273',N'690605',4,77000000,N'',N'1',N'PHUONGVN',N'May 29 2019 12:00AM',N'U',NULL,NULL,N'Billboard',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055249',N'TRCI00001055208',N'HH0000000112267',N'690605',1,3000000000,N'',N'1',N'PHUONGVN',N'Oct 30 2018 12:00AM',N'U',NULL,NULL,N'Thể thao',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055250',N'TRCI00001055209',N'HH0000000112272',N'690605',1,318230000,N'',N'1',N'PHUONGVN',N'Nov 15 2019 12:00AM',N'U',NULL,NULL,N'QC/PR báo chí',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055251',N'TRCI00001055210',N'HH0000000112273',N'690605',1,8000000,N'',N'1',N'PHUONGVN',N'Feb 11 2020 12:00AM',N'U',NULL,NULL,N'Giấy phép treo bảng hiệu VCCB',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055252',N'TRCI00001055211',N'HH0000000112273',N'690605',1,3836250000,N'',N'1',N'PHUONGVN',N'Feb 18 2020 12:00AM',N'U',NULL,NULL,N'Billboard',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055253',N'TRCI00001055212',N'HH0000000112289',N'692103',10000,50000,N'',N'1',N'PHUONGVN',N'Mar  3 2020 12:00AM',N'U',NULL,NULL,N'Khác',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055254',N'TRCI00001055213',N'HH0000000112272',N'690605',1,99000000,N'',N'1',N'PHUONGVN',N'Mar 16 2020 12:00AM',N'U',NULL,NULL,N'Gói quảng cáo',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055255',N'TRCI00001055214',N'HH0000000112275',N'690605',1,150000000,N'',N'1',N'PHUONGVN',N'Mar 16 2020 12:00AM',N'U',NULL,NULL,N'Gói quảng cáo',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055256',N'TRCI00001055215',N'HH0000000112301',NULL,2500,50000,N'',N'1',N'PHUONGVN',N'Apr 22 2020 12:00AM',N'U',NULL,NULL,N'eVoucher',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055257',N'TRCI00001055216',N'HH0000000112266',N'0',8,4000000,N'',N'1',N'PHUONGVN',N'Apr 27 2020 12:00AM',N'U',NULL,NULL,N'Dịch vụ định giá tài sản',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055258',N'TRCI00001055216',N'HH0000000112297',N'692103',1000,50000,N'',N'1',N'PHUONGVN',N'Apr 27 2020 12:00AM',N'U',NULL,NULL,N'eVoucher',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055259',N'TRCI00001055217',N'HH0000000112273',N'0',1,840655200,N'',N'1',N'PHUONGVN',N'May 12 2020 12:00AM',N'U',NULL,NULL,N'Bảng quảng cáo Billboard',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055260',N'TRCI00001055217',N'HH0000000112268',NULL,1,10000000,N'',N'1',N'PHUONGVN',N'May 12 2020 12:00AM',N'U',NULL,NULL,N'Chương trình nội bộ',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055261',N'TRCI00001055218',NULL,NULL,10000,1000,N'',N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,N'PIN Mailer',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055262',N'TRCI00001055218',N'HH0000000112275',NULL,1,43463860,N'',N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,N'Gói quảng cáo',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055263',N'TRCI00001055218',N'HH0000000112268',NULL,1,6000000,N'',N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,N'Chương trình nội bộ',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055264',N'TRCI00001055219',N'HH0000000112297',NULL,1,200000000,N'',N'1',N'PHUONGVN',N'Jun 24 2020 12:00AM',N'U',NULL,NULL,N'Quà tặng chương trình khuyến mãi',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_DT] ([CD_ID],[CONTRACT_ID],[GOODS_ID],[UNIT_ID],[QUANTITY],[PRICE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_NAME_REAL],[QUANTITY_USE],[RECURRING],[UNIT_NAME_REAL])VALUES(N'TRCDI0001055265',N'TRCI00001055219',N'HH0000000112275',NULL,1,43463860,N'',N'1',N'PHUONGVN',N'Jun 24 2020 12:00AM',N'U',NULL,NULL,N'Gói quảng cáo',0,NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055293',N'TRCI00001055204',N'ĐỢT 1',N'Aug 25 2020  4:57PM',100.00,45000000,NULL,N'[SaoViet] Tạm ứng chi phí Thẩm định giá',N'1',N'PHUONGVN',N'Dec 27 2019 12:00AM',N'U',NULL,NULL,NULL,45000000,N'44/HDDV-SVICC-BanViet',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055294',N'TRCI00001055204',N'ĐỢT 1',N'Aug 25 2020  4:57PM',100.00,25000000,NULL,N'[SaoViet] Tạm ứng chi phí Thẩm định giá',N'1',N'PHUONGVN',N'Dec 27 2019 12:00AM',N'U',NULL,NULL,NULL,25000000,N'44/HDDV-SVICC-BanViet',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055295',N'TRCI00001055205',N'ĐỢT 1',N'Aug 25 2020  4:57PM',50.00,110000000,NULL,N'Chi phí tư vấn đăng ký giao dịch cổ phiếu trên sàn Upcom năm 2018',N'1',N'PHUONGVN',N'Aug 22 2018 12:00AM',N'U',NULL,NULL,NULL,110000000,N'23/2018/HD/IB.VCSC ',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055296',N'TRCI00001055205',N'ĐỢT 2',N'Aug 25 2020  4:57PM',50.00,110000000,NULL,NULL,N'1',N'PHUONGVN',N'Aug 22 2018 12:00AM',N'U',NULL,NULL,NULL,NULL,N'23/2018/HD/IB.VCSC ',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055297',N'TRCI00001055206',N'ĐỢT 1',N'Aug 25 2020  4:57PM',50.00,100000000,NULL,N'Thanh toán đợt 1_chi phí tư vấn phát hành cổ phiếu',N'1',N'PHUONGVN',N'Aug 22 2018 12:00AM',N'U',NULL,NULL,NULL,100000000,N'14/2018/HD-IB.VCSC',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055298',N'TRCI00001055206',N'ĐỢT 2',N'Aug 25 2020  4:57PM',50.00,120000000,NULL,N'Thanh toán đợt 2_chi phí tư vấn phát hành cổ phiếu',N'1',N'PHUONGVN',N'Aug 22 2018 12:00AM',N'U',NULL,NULL,NULL,120000000,N'14/2018/HD-IB.VCSC',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055299',N'TRCI00001055207',N'ĐỢT 1',N'Aug 25 2020  4:57PM',100.00,308000000,NULL,N'Chưa thanh toán',N'1',N'PHUONGVN',N'May 29 2019 12:00AM',N'U',NULL,NULL,NULL,NULL,N'17/HĐQC-2019',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055300',N'TRCI00001055208',N'30/03/2019',N'Aug 25 2020  4:57PM',25.00,750000000,NULL,N'[Bóng Rổ] Thanh toán đợt 2_Chi phí Hợp tác truyền thông LĐBR Viet Nam VBF',N'1',N'PHUONGVN',N'Oct 30 2018 12:00AM',N'U',NULL,NULL,NULL,750000000,N'05/HĐQC-VBF-VIETCAPITALBANK',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055301',N'TRCI00001055208',N'30/05/2020',N'Aug 25 2020  4:57PM',25.00,750000000,NULL,NULL,N'1',N'PHUONGVN',N'Oct 30 2018 12:00AM',N'U',NULL,NULL,NULL,NULL,N'05/HĐQC-VBF-VIETCAPITALBANK',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055302',N'TRCI00001055209',N'ĐỢT 1',N'Aug 25 2020  4:57PM',50.00,159115000,NULL,NULL,N'1',N'PHUONGVN',N'Nov 15 2019 12:00AM',N'U',NULL,NULL,NULL,NULL,N'02122019/VCCB-NICHE/PR',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055303',N'TRCI00001055209',N'ĐỢT 2',N'Aug 25 2020  4:57PM',50.00,159115000,NULL,NULL,N'1',N'PHUONGVN',N'Nov 15 2019 12:00AM',N'U',NULL,NULL,NULL,NULL,N'02122019/VCCB-NICHE/PR',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055304',N'TRCI00001055210',N'ĐỢT 1',N'Aug 25 2020  4:57PM',90.00,6400000,NULL,N'Chi phí đăng ký nhãn hiệu',N'1',N'PHUONGVN',N'Feb 11 2020 12:00AM',N'U',NULL,NULL,NULL,5760000,N' 02/VIETCAPITAL-SN/02/2020',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055305',N'TRCI00001055210',N'ĐỢT 2',N'Aug 25 2020  4:57PM',10.00,600000,NULL,N'Chưa thanh toán',N'1',N'PHUONGVN',N'Feb 11 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N' 02/VIETCAPITAL-SN/02/2020',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055306',N'TRCI00001055211',N'ĐỢT 1',N'Aug 25 2020  4:57PM',30.00,1150875000,NULL,N'Thanh toán đợt 1',N'1',N'PHUONGVN',N'Feb 18 2020 12:00AM',N'U',NULL,NULL,NULL,1150875000,N'026/HĐQC/ME-BANVIET',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055307',N'TRCI00001055211',N'ĐỢT 2',N'Aug 25 2020  4:57PM',65.00,2493562500,NULL,N'Thanh toán đợt 2',N'1',N'PHUONGVN',N'Feb 18 2020 12:00AM',N'U',NULL,NULL,NULL,2493562500,N'026/HĐQC/ME-BANVIET',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055308',N'TRCI00001055211',N'ĐỢT 3',N'Aug 25 2020  4:57PM',5.00,19181250000,NULL,N'Thanh toán đợt  3',N'1',N'PHUONGVN',N'Feb 18 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'026/HĐQC/ME-BANVIET',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055309',N'TRCI00001055212',N'ĐỢT 1',N'Aug 25 2020  4:57PM',50.00,173525000,NULL,N'Chi phí sản xuất quà tặng',N'1',N'PHUONGVN',N'Mar  3 2020 12:00AM',N'U',NULL,NULL,NULL,173525000,N'15052020/HDMB/BV-ACE',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055310',N'TRCI00001055213',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,99000000,NULL,NULL,N'1',N'PHUONGVN',N'Mar 16 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'28022020/HDHT/UREKA - BAN VIET',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055311',N'TRCI00001055214',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,149999850,NULL,NULL,N'1',N'PHUONGVN',N'Mar 16 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'27022019/HDHT/UREKA - BAN VIET',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055312',N'TRCI00001055215',N'Đang thực hiện',N'Aug 25 2020  4:57PM',0.00,0,NULL,NULL,N'1',N'PHUONGVN',N'Apr 22 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'B2B/2019/ DAYONE - BVB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055313',N'TRCI00001055216',N'Đang thực hiện',N'Aug 25 2020  4:57PM',0.00,0,NULL,NULL,N'1',N'PHUONGVN',N'Apr 27 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'120/HĐDV-DoanhNghiep-BanViet',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055314',N'TRCI00001055216',N'Đang thực hiện',N'Aug 25 2020  4:57PM',0.00,0,NULL,NULL,N'1',N'PHUONGVN',N'Apr 27 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'120/HĐDV-DoanhNghiep-BanViet',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055315',N'TRCI00001055217',N'ĐỢT 1',N'Aug 25 2020  4:57PM',50.00,420327600,NULL,N'Thanh toán đợt 1 chi phí quảng cáo tại Sân bay Nội bài',N'1',N'PHUONGVN',N'May 12 2020 12:00AM',N'U',NULL,NULL,NULL,420327600,N'42/HDKT/2020',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055316',N'TRCI00001055217',N'ĐỢT 2',N'Aug 25 2020  4:57PM',50.00,420327600,NULL,NULL,N'1',N'PHUONGVN',N'May 12 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'42/HDKT/2020',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055317',N'TRCI00001055217',N'Đang thực hiện',N'Aug 25 2020  4:57PM',0.00,0,NULL,NULL,N'1',N'PHUONGVN',N'May 12 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'42/HDKT/2020',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055318',N'TRCI00001055218',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,7920000,NULL,NULL,N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'15-2019/HĐNT-LIENSON-VCCB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055319',N'TRCI00001055218',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,43463860,NULL,NULL,N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'15-2019/HĐNT-LIENSON-VCCB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055320',N'TRCI00001055218',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,76451045,NULL,NULL,N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'15-2019/HĐNT-LIENSON-VCCB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055321',N'TRCI00001055218',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,61648125,NULL,NULL,N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'15-2019/HĐNT-LIENSON-VCCB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055322',N'TRCI00001055218',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,6000000,NULL,NULL,N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'15-2019/HĐNT-LIENSON-VCCB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055323',N'TRCI00001055218',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,7000000,NULL,NULL,N'1',N'PHUONGVN',N'Jun 23 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'15-2019/HĐNT-LIENSON-VCCB',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055324',N'TRCI00001055219',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,200000000,NULL,NULL,N'1',N'PHUONGVN',N'Jun 24 2020 12:00AM',N'U',NULL,NULL,NULL,0,N'68/2020/SSV-BV/HĐHT',NULL,NULL)

INSERT INTO [TR_CONTRACT_PAYMENT] ([PAY_ID],[CONTRACT_ID],[PAY_PHASE],[EXPECTED_DT],[PERCENT],[AMOUNT],[PAY_STATUS],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PAY_DT],[PAY_AMOUNT],[CONTRACT_CODE],[REQUEST_ID],[CONTRACT_PARENT])VALUES(N'TRCPI0001055325',N'TRCI00001055219',N'Đang thực hiện',N'Aug 25 2020  4:57PM',100.00,43463860,NULL,NULL,N'1',N'PHUONGVN',N'Jun 24 2020 12:00AM',N'U',NULL,NULL,NULL,NULL,N'68/2020/SSV-BV/HĐHT',NULL,NULL)