EXEC dbo.sp_generate_inserts @table_name = 'TR_REQ_PAY_SERVICE', @from = 'from TR_REQ_PAY_SERVICE' 

Trạng thái: Select thành công 

  

Column1 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200043',N'TADY00000200026',N'TRC000000051005',N'ADV_PAY',N'Aug 17 2020 12:00AM',2197,2468,13961508.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200026',N'0',NULL,N'07/2020',N'Tạm ứng chi phí tiền điện sinh hoạt cho BVB Cà Mau (từ ngày 12/07/2020 đến 11/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200048',N'TADY00000200032',N'TRC000001125905',N'ADV_PAY',N'Aug 18 2020 12:00AM',0,0,514162.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200032',N'0',NULL,N'',N'TẠM ỨNG TIỀN CƯỚC VT-CNTT THÁNG 07/2020 CHỊU THUẾ GTGT THEO GIẤY BIÊN NHẬN THANH TOÁN NGÀY 06.08.2020 BVB KIẾN TƯỜNG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200050',N'TRPY00000200050',N'TRC000001125820',N'PAY',N'Aug 19 2020 4:00PM',0,0,501888750.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'T8/2020-T2/2021',N'THANH TOAN TIEN THUE NHA 6 THANG TU : THANG 8 DEN THANG 2/2021 BVB DSG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200053',N'TRPY00000200041',N'TRC000001125754',N'PAY',N'Aug 17 2020 12:00AM',0,0,788072.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'tháng 7',N'Thanh toán điện thoại tháng 7.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200054',N'TADY00000200033',N'TRC000000251045',N'ADV_PAY',N'Aug 18 2020 12:00AM',0,0,14605690.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200033',N'0',NULL,N'từ ngày 15/7/2020 đến 14/8/2020',N'Tạm ứng thanh toán tiền điện tháng 8.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200056',N'TRPY00000200054',N'TRC000001125804',N'PAY',N'Aug 20 2020 3:08PM',0,0,449222.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOÁN CHI PHÍ CHUYỂN PHÁT NHANH T07.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200062',N'TRPY00000200059',N'TRC000000251050',N'PAY',N'Aug 18 2020 12:00AM',0,0,276583.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 7/2020',N'thanh toan tien dien thoai thang 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200064',N'TRPY00000200057',N'TRC000001125906',N'PAY',N'Aug 18 2020 12:00AM',0,0,2694200.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOÁN TIỀN VĂN PHÒNG PHẨM T08.2020 THEO SỐ HĐGTGT: 0080324 NGÀY 10.08.2020 BVB KIẾN TƯỜNG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200072',N'TRPY00000200049',N'TRC000000251046',N'PAY',N'Aug 18 2020 12:00AM',0,0,1011532060.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Kỳ cước tháng 6/2020',N'CMC - Thanh toán cước kênh truyền tại Data Center tháng 06/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200073',N'TRPY00000200067',N'TRC000000251046',N'PAY',N'Aug 18 2020 3:30PM',0,0,1011532060.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Kỳ cước tháng 6/2020',N'CMC - Thanh toán cước kênh truyền tại Data Center tháng 06/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200074',N'TADY00000200035',N'TRC000000051010',N'ADV_PAY',N'Aug 18 2020 12:00AM',13247,15036,5246421.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200035',N'0',NULL,N'',N'Tạm ứng tiền điện từ ngày 10/07/2020 đến ngày 09/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200075',N'TADY00000200035',N'TRC000000051010',N'ADV_PAY',N'Aug 18 2020 12:00AM',4855,5530,3405848.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200035',N'0',NULL,N'',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200076',N'TADY00000200035',N'TRC000000051010',N'ADV_PAY',N'Aug 18 2020 12:00AM',1942,2113,305098.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200035',N'0',NULL,N'',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200095',N'TRPY00000200074',N'TRC000000251056',N'PAY',N'Aug 19 2020 9:48AM',1697,1735,428430.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Kỳ tháng 07/2020',N'Thanh toán chi phí hóa đơn nước sinh hoạt Kỳ: Tháng 07/2020 Từ ngày: 24/06 Đến ngày : 23/07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200098',N'TADY00000200014',N'TRC000001125928',N'ADV_PAY',N'Aug 17 2020 12:00AM',3042,3087,861750.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200014',N'0',NULL,N'THÁNG 8/2020',N'TẠM ỨNG CHI PHÍ NƯỚC SINH HOẠT THÁNG 8/2020 (CNBT: 861.750, PGD PT: 134.050)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200099',N'TADY00000200014',N'TRC000001125928',N'ADV_PAY',N'Aug 17 2020 12:00AM',376,383,134050.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200014',N'0',NULL,N'THÁNG 8/2020',N'TẠM ỨNG CHI PHÍ NƯỚC SINH HOẠT THÁNG 8/2020 (CNBT: 861.750, PGD PT: 134.050)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200103',N'TRPY00000200061',N'TRC000000251040',N'PAY',N'Aug 18 2020 12:00AM',0,0,4947835.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOÁN TIỀN ĐIỆN từ 10/07/2020 đến 09/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200112',N'TADY00000200023',N'TRC000000251012',N'ADV_PAY',N'Aug 17 2020 12:00AM',41147,42638,4372507.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200023',N'0',NULL,N'',N'Tạm ứng chi phí tiền điện sinh hoạt cho BVB Đầm Dơi (từ ngày 06/07/2020 đến 05/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200138',N'TRPY00000200083',N'TRC000001125868',N'PAY',N'Aug 18 2020 12:00AM',0,0,3000000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 7/2020',N'THANH TOAN TIEN DICH VU VE SINH THANG 07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200144',N'TADY00000200043',N'TRC000001125857',N'ADV_PAY',N'Aug 19 2020 12:00AM',5625,5830,6203888.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200043',N'0',NULL,N'18/7/2020-17/8/2020',N'Thanh toán tiền điện') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200181',N'TADY00000200013',N'TRC000001125927',N'ADV_PAY',N'Aug 17 2020 12:00AM',2648,2891,433561.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200013',N'0',NULL,N'THÁNG 8',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200182',N'TADY00000200013',N'TRC000001125927',N'ADV_PAY',N'Aug 17 2020 12:00AM',10146,11129,4959923.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200013',N'0',NULL,N'THÁNG 8',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200183',N'TADY00000200013',N'TRC000001125927',N'ADV_PAY',N'Aug 18 2020 12:00AM',31968,34658,7888694.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200013',N'0',NULL,N'THÁNG 8',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200184',N'TADY00000200013',N'TRC000001125927',N'ADV_PAY',N'Aug 18 2020 12:00AM',62470,63874,4117370.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200013',N'0',NULL,N'THÁNG 8',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200185',N'TADY00000200013',N'TRC000001125927',N'ADV_PAY',N'Aug 18 2020 12:00AM',2527,3060,2689358.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200013',N'0',NULL,N'THÁNG 8',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200186',N'TADY00000200013',N'TRC000001125927',N'ADV_PAY',N'Aug 18 2020 12:00AM',1048,1270,396093.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200013',N'0',NULL,N'THÁNG 8',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200198',N'TRPY00000200110',N'TRC000001125746',N'PAY',N'Aug 20 2020 1:15PM',0,0,934189.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 7/2020',N'Thanh toán tiền điện thoại T7.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200200',N'TRPY00000200114',N'TRC000000251051',N'PAY',N'Aug 19 2020 12:00AM',0,5069390,5069390.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Quý 3/2020',N'THANH TOAN VVP QUY 3/2020 PGD HANG XANH') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200201',N'TRPY00000200118',N'TRC000001125793',N'PAY',N'Aug 21 2020 3:34PM',0,154,600000.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'thang 7',N'PGD NGUYEN TRAI THANH TOAN CHI PHI THUE MAY PHOTO THANG 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200202',N'TRPY00000200120',N'TRC000000251069',N'PAY',N'Aug 19 2020 12:00AM',0,0,2420000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'BVB THANH KHÊ TANH TOÁN CHI PHÍ DỊCH VỤ VỆ SINH THÁNG 07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200209',N'TADY00000200048',N'TRC000001125921',N'ADV_PAY',N'Aug 19 2020 12:00AM',0,0,28778461.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200048',N'0',NULL,N'từ ngày 13/7-12/8',N'Tạm ứng tiền điện tháng 8/2020 cho chi nhánh Hà Nội') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200211',N'TRPY00000200086',N'TRC000000251066',N'PAY',N'Aug 20 2020 3:23PM',0,0,7920000.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'BVB HẢI CHÂU THANH TOÁN CP THUÊ DỊCH VỤ BẢO VỆ THÁNG 8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200212',N'TRPY00000200127',N'TRC000001125839',N'PAY',N'Aug 19 2020 12:00AM',0,0,0.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'Thanh toan thue may photocopy tu 16.7-17.8.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200215',N'TRPY00000200130',N'TRC000000251070',N'PAY',N'Aug 20 2020 5:07PM',0,0,2420000.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'CHI PHI DỊCH VỤ VỆ SINH THÁNG 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200217',N'TRPY00000200128',N'TRC000001125900',N'PAY',N'Aug 19 2020 12:00AM',0,0,3343000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'thanh toán chi phí VPP tháng 07/2020 Phòng QLTD CN Long An') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200218',N'TRPY00000200132',N'TRC000001125791',N'PAY',N'Aug 19 2020 12:00AM',0,0,400000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'THANG 5',N'PGD NGUYEN TRAI THANH TOAN CHI PHI THUE CAY CANH THANG 5/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200220',N'TRPY00000000006',N'TRC000000051009',N'PAY',N'Aug 21 2020 4:51PM',0,0,389462.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'Thanh toán cước phí CPN tháng 7') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200223',N'TADY00000200053',N'TRC000000251071',N'ADV_PAY',N'Aug 19 2020 12:00AM',0,0,210000000.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200053',N'0',NULL,N'08/2020',N'TẠM ỨNG ĐẶT CỌC TIỀN THUÊ NHÀ PGD CAM RANH THEO HỢP ĐỒNG ĐẶT CỌC NGÀY 18/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200263',N'TRPY00000200124',N'TRC000000251063',N'PAY',N'Aug 20 2020 5:15PM',1252,1288,598428.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN TIEN NUOC SINH HOAT T7.20') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200265',N'TRPY00000200154',N'TRC000000251083',N'PAY',N'Aug 21 2020 2:19PM',0,0,10500000.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'Thanh toán chi phí dịch vụ bảo vệ kỳ 9/7/2020 đến 8/8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200267',N'TRPY00000200163',N'TRC000000251091',N'PAY',N'Aug 19 2020 12:00AM',0,0,1800000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN TIEN DICH VU VE SINH THANG 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200268',N'TRPY00000200164',N'TRC000000251052',N'PAY',N'Aug 19 2020 12:00AM',0,0,805000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'T06, 07/2020',N'CHI PHÍ CẦU ĐƯỜNG, BẾN BÃI T06,07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200269',N'TRPY00000200164',N'TRC000000251052',N'PAY',N'Aug 19 2020 12:00AM',0,0,600000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'T06, 07/2020',N'RỬA XE T06,07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200271',N'TRPY00000200170',N'TRC000000251087',N'PAY',N'Aug 19 2020 12:00AM',0,0,6480000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Q2/2020',N'THANH TOAN TIN VAN PHONG PHAM QUY 2/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200274',N'TADY00000200062',N'TRC000000251101',N'ADV_PAY',N'Aug 20 2020 12:00AM',21875,24161,7313149.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200062',N'0',NULL,N'',N'BVB DĨ AN TẠM ỨNG TIỀN ĐIỆN KỲ 01 THÁNG 08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200277',N'TRPY00000200189',N'TRC000001125757',N'PAY',N'Aug 20 2020 12:00AM',0,0,7715671.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'15/07/2020-10/08/2020',N'Thanh toán chi phí nước sinh hoạt kỳ 08/2019 từ ngày 15/07/2020 đến ngày 10/08/2020, chi phí điện sinh hoạt tháng 08/2020(31 ngày từ 11/07/2020 đến ngày 10/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200278',N'TRPY00000200189',N'TRC000001125760',N'PAY',N'Aug 20 2020 12:00AM',0,0,589950.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'11/07/2020-10/08/2020',N'Thanh toán chi phí nước sinh hoạt kỳ 08/2019 từ ngày 15/07/2020 đến ngày 10/08/2020, chi phí điện sinh hoạt tháng 08/2020(31 ngày từ 11/07/2020 đến ngày 10/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200280',N'TRPY00000200195',N'TRC000001125889',N'PAY',N'Aug 20 2020 4:21PM',0,0,5066064.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TTTY00001120708',N'2',N'TTTY00001120708',N'07/07/2020 - 06',N'Tạm ứng tiền điện tháng 8/2020 từ 7/7/2020 đến 6/8/2020 theo GDNTU 082020/091102') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200288',N'TRPY00000200085',N'TRC000000251053',N'PAY',N'Aug 21 2020 5:36PM',16394,16644,629500.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'Thanh toan chi phi nhien lieu km 16394-16644 tu ngay 06/8-12/8/2020 xe 51E04649') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200290',N'TRPY00000200202',N'TRC000001125907',N'PAY',N'Jan 1 1900 12:00AM',0,0,5442615.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TTTY00001120717',N'2',N'TTTY00001120717',N'03/07/2020-02/0',N'Tạm ứng tiền điện từ ngày ngày 03/07/2020-02/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200293',N'TRPY00000200205',N'TRC000000251117',N'PAY',N'Aug 20 2020 12:00AM',0,0,792221.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'TT CHUYỂN PHÁT NHANH T07/2020 BVB AN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200304',N'TRPY00000200206',N'TRC000000251100',N'PAY',N'Aug 21 2020 1:30PM',199843,201672,5992287.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'BVB HẢI CHÂU THANH TOÁN CP ĐIỆN KỲ 16/07/2020 ĐẾN 15/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200329',N'TADY00000200067',N'TRC000000251030',N'ADV_PAY',N'Aug 20 2020 12:00AM',859,2757,6476044.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200067',N'0',NULL,N'',N'BVB THANH KHÊ TẠM ỨNG CHI PHÍ TIỀN ĐIỆN SINH HOẠT TỪ NGÀY 14/07/2020 ĐẾN NGÀY 13/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200330',N'TRPY00000200208',N'TRC000001125824',N'PAY',N'Aug 20 2020 12:00AM',0,0,825000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN THUE MAY PHOTO THANG 8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200331',N'TRPY00000200215',N'TRC000000251069',N'PAY',N'Aug 20 2020 12:00AM',0,0,2420000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'BVB THANH KHÊ THANH TOÁN CHI PHÍ DỊCH VỤ VỆ SINH THÁNG 07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200333',N'TRPY00000200216',N'TRC000001126922',N'PAY',N'Jan 1 1900 12:00AM',0,0,13869636.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TTTY00001120749',N'2',N'TTTY00001120749',N'11/07-10/08/202',N'TẠM ỨNG TIỀN ĐIỆN SINH HOẠT 11/07-10/08/2020 BVB AN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200335',N'TRPY00000200219',N'TRC000001125900',N'PAY',N'Aug 20 2020 12:00AM',0,0,5551000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'Thanh toán chi phí VPP tháng 07/2020 CN Long An') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200337',N'TRPY00000200141',N'TRC000000251072',N'PAY',N'Aug 19 2020 12:00AM',0,0,632669.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'07/2020',N'THANH TOAN CUOC DIEN THOAI CO DINH') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200339',N'TRPY00000200139',N'TRC000000251068',N'PAY',N'Aug 21 2020 2:21PM',0,0,10755812.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'07/2020',N'THANH TOAN TIEN DIEN SINH HOAT T08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200344',N'TRPY00000200221',N'TRC000001125855',N'PAY',N'Aug 20 2020 12:00AM',0,0,786806.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'Thanh toán tiền điện thoại tháng 7.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200346',N'TRPY00000200222',N'TRC000000251082',N'PAY',N'Aug 20 2020 12:00AM',1669,1682,211931.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'BVB THANH KHÊ THANH TOÁN CHI PHÍ NƯỚC SINH HOẠT THÁNG 08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200349',N'TADY00000200045',N'TRC000001125916',N'ADV_PAY',N'Aug 19 2020 12:00AM',0,0,611280.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200045',N'0',NULL,N'',N'DVVT tháng 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200355',N'TRPY00000200227',N'TRC000001125777',N'PAY',N'Aug 20 2020 12:00AM',0,0,468627.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 07/2020',N'THANH TOÁN CHI PHÍ ĐIỆN THOẠI CỐ ĐỊNH THÁNG 07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200359',N'TRPY00000200228',N'TRC000001125777',N'PAY',N'Aug 20 2020 12:00AM',0,0,490396.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 06/2020',N'THANH TOÁN CHI PHÍ ĐIỆN THOẠI CỐ ĐỊNH THÁNG 06/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200360',N'TRPY00000200230',N'TRC000001125859',N'PAY',N'Aug 20 2020 12:00AM',0,234,825000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOÁN TIỀN THUÊ MÁY PHOTO THEO BẢN CHỤP TỪ 10/06/2020-09/7/2020 PGD QUANG TRUNG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200362',N'TRPY00000200232',N'TRC000000251120',N'PAY',N'Aug 21 2020 2:54PM',0,0,547194.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'tháng 7/2020',N'BVB HẢI CHÂU THANH TOÁN CP CƯỚC ĐIỆN THOẠI THÁNG 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200365',N'TRPY00000200192',N'TRC000000251095',N'PAY',N'Aug 20 2020 12:00AM',0,0,8184000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Từ tháng 06 đến tháng 07',N'Thanh toán chi phí mực in và sữa chữa hộp mực cho BVB Cà Mau từ 01/06/2020 đến 31/07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200370',N'TRPY00000200235',N'TRC000001125859',N'PAY',N'Aug 20 2020 12:00AM',0,627,825000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOÁN TIỀN THUÊ MÁY PHOTO THEO BẢN CHỤP TỪ 10/07/2020-10/8/2020 PGD QUANG TRUNG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200372',N'TRPY00000200236',N'TRC000000251076',N'PAY',N'Aug 20 2020 12:00AM',0,0,321698.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'BVB THANH KHÊ THANH TOÁN CHI PHÍ ĐIỆN THOẠI BÀN THÁNG 07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200376',N'TADY00000200074',N'TRC000001125931',N'ADV_PAY',N'Aug 20 2020 12:00AM',0,0,17665982.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200074',N'0',NULL,N'',N'Tạm ứng thanh toán tiền điện tháng 8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200377',N'TADY00000200039',N'TRC000001126779',N'ADV_PAY',N'Aug 20 2020 12:00AM',0,0,1168213.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200039',N'0',NULL,N'07/2020',N'Tạm ứng tiền điện thoại cố định + điện thoại báo động ATM T7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200378',N'TADY00000200039',N'TRC000001126779',N'ADV_PAY',N'Aug 20 2020 12:00AM',0,0,50049.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200039',N'0',NULL,N'07/2020',N'Tạm ứng tiền điện thoại cố định + điện thoại báo động ATM T7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200381',N'TADY00000200038',N'TRC000000251025',N'ADV_PAY',N'Aug 18 2020 12:00AM',463,476,156316.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200038',N'0',NULL,N'',N'Tạm ứng tiền nước sinh hoạt từ ngày 04/07/2020 đến ngày 03/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200383',N'TRPY00000200240',N'TRC000000251104',N'PAY',N'Aug 20 2020 12:00AM',0,0,12826900.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Quý 3/2020',N'Thanh toán chi phí văn phòng phẩm định mức và vật liệu văn phòng quý 3/2020 Cho CN Thăng Long & PGD Cầu Giấy') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200389',N'TRPY00000200247',N'TRC000000251122',N'PAY',N'Aug 20 2020 12:00AM',0,0,200000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'BVB THANH KHÊ THANH TOÁN CHI PHÍ CƯỚC WIFI THÁNG 07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200393',N'TRPY00000200244',N'TRC000000251015',N'PAY',N'Aug 20 2020 12:00AM',0,0,687501.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'TT TIỀN NƯỚC THÁNG 08/2020 BVB AN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200395',N'TRPY00000200250',N'TRC000001125771',N'PAY',N'Aug 20 2020 12:00AM',0,0,781094.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 7/2020',N'THANH TOÁN CHI PHÍ ĐIỆN THOẠI BÀN THÁNG 07.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200396',N'TRPY00000200253',N'TRC000001125741',N'PAY',N'Aug 20 2020 12:00AM',0,0,7360104.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN TIEN DIEN THANG 07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200398',N'TRPY00000200246',N'TRC000000051005',N'PAY',N'Jan 1 1900 12:00AM',2197,2468,13961508.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200026',N'2',N'TADY00000200026',N'07/2020',N'Tạm ứng chi phí tiền điện sinh hoạt cho BVB Cà Mau (từ ngày 12/07/2020 đến 11/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200401',N'TRPY00000200243',N'TRC000000251126',N'PAY',N'Aug 20 2020 12:00AM',0,0,15373969.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'kỳ 15.7.2020 đến 14.8.2020',N'Thanh toán chi phí điện, nước, DVCC kỳ 15.7.2020 đến 14.8.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200404',N'TRPY00000200204',N'TRC000000251027',N'PAY',N'Aug 20 2020 12:00AM',0,0,650000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'TT THUÊ BÃI GỬI XE THÁNG 07/2020 BVB AN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200410',N'TRPY00000200261',N'TRC000000251128',N'PAY',N'Aug 21 2020 12:00AM',0,0,11196925.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'Thanh Toán Chi phí Điện Sinh Hoạt Chi Nhánh Từ Ngày 17/07/2020 Đến 16/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200412',N'TRPY00000200264',N'TRC000000251131',N'PAY',N'Aug 21 2020 12:00AM',0,0,684644.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'07/2020',N'Thanh Toán Chi Phí Dịch Vụ Viễn Thông Chi Nhánh Tháng 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200415',N'TRPY00000200259',N'TRC000000251098',N'PAY',N'Aug 21 2020 12:00AM',0,0,501251.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 07/2020',N'Thanh toán chi phí hóa đơn thuê bao điện thoại cố định cho BVB Cà Mau tháng 07.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200416',N'TRPY00000200259',N'TRC000000251135',N'PAY',N'Aug 21 2020 12:00AM',0,0,80700.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 07/2020',N'Thanh toán chi phí hóa đơn thuê bao điện thoại cho máy ATM cho BVB Cà Mau tháng 07.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200419',N'TRPY00000200266',N'TRC000000251127',N'PAY',N'Aug 21 2020 12:00AM',0,0,120900.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN TIEN DIEN THOAI DI DONG - SIM ATM THANG 07/2020O PGD HOA THANH') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200430',N'TRPY00000200268',N'TRC000000251073',N'PAY',N'Aug 21 2020 1:48PM',1676,3839,6865113.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'08/2020',N'THANH TOAN TIEN DIEN SINH HOAT KY 8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200431',N'TRPY00000200268',N'TRC000000251078',N'PAY',N'Aug 21 2020 1:48PM',0,0,1029895.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'07/2020',N'THANH TOAN TIEN DIEN THOAI CO DINH, INTERNET, CUOC SIM ATM THANG 07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200432',N'TRPY00000200268',N'TRC000000251077',N'PAY',N'Aug 21 2020 1:48PM',294,301,143290.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'08/2020',N'THANH TOAN TIEN NUOC SINH HOAT KY 8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200433',N'TRPY00000200268',N'TRC000000251080',N'PAY',N'Aug 21 2020 1:48PM',0,0,1000000.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'07/2020',N'THANH TOAN LUONG TAP VU THANG 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200434',N'TRPY00000200268',N'TRC000000251079',N'PAY',N'Aug 21 2020 1:48PM',0,0,1500000.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'07/2020',N'THANH TOAN LUONG TAP VU THANG 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200436',N'TRPY00000200272',N'TRC000000251050',N'PAY',N'Aug 21 2020 12:00AM',0,0,747712.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200439',N'TADY00000200064',N'TRC000000251102',N'ADV_PAY',N'Aug 20 2020 12:00AM',0,0,17998547.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200064',N'0',NULL,N'',N'CN ĐÀ NẴNG TẠM ỨNG CHI PHÍ TIỀN ĐIỆN SINH HOẠT TỪ NGÀY 15/07/2020 ĐẾN 14/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200440',N'TRPY00000200276',N'TRC000000251136',N'PAY',N'Aug 21 2020 4:14PM',53723,55799,6807548.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN TIEN DIEN THANG 8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200445',N'TRPY00000200218',N'TRC000000251108',N'PAY',N'Aug 21 2020 12:00AM',0,0,2231885.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 7/2020',N'Thanh toán cước điện thoại cố định cho CN Thăng Long & PGD Cầu Giấy') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200446',N'TRPY00000200218',N'TRC000000251107',N'PAY',N'Aug 21 2020 12:00AM',0,0,62516.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 7/2020',N'Thanh toán cước điện thoại di đông (sim báo động ATM) cho Cn Thăng Long') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200449',N'TRPY00000200280',N'TRC000000251099',N'PAY',N'Aug 21 2020 12:00AM',0,0,139759.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'Thanh toán chi phí hóa đơn dịch vụ bưu chính cho BVB Cà Mau tháng 07.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200450',N'TRPY00000200281',N'TRC000000251139',N'PAY',N'Aug 21 2020 12:00AM',0,33,1996500.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Thang 6 & 7',N'Hỏi điểm khách hàng riêng') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200452',N'TRPY00000200282',N'TRC000000251141',N'PAY',N'Aug 21 2020 12:00AM',0,0,1074424000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'CHI PHÍ THUÊ NHÀ -CN BÌNH THUẬN (25/8/2020-24/8/2021)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200459',N'TRPY00000200289',N'TRC000000251142',N'PAY',N'Aug 21 2020 12:00AM',1036,1096,490000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'08/2020',N'THANH TOÁN TIỀN NƯỚC SINH HOẠT') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200462',N'TRPY00000200290',N'TRC000001125830',N'PAY',N'Aug 21 2020 12:00AM',0,0,1500000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN TIEN GUI 2 XE OTO THANG 8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200463',N'TRPY00000200290',N'TRC000001125831',N'PAY',N'Aug 21 2020 12:00AM',0,0,1500000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN TIEN GUI 2 XE OTO THANG 8/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200465',N'TADY00000200079',N'TRC000000251143',N'ADV_PAY',N'Aug 21 2020 12:00AM',0,0,4967208.00,N'VND',1.00,N'A',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200079',N'0',NULL,N'08/2020',N'Tạm ứng CP tiền điện sinh hoạt tháng 08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200469',N'TADY00000200047',N'TRC000001125921',N'ADV_PAY',N'Aug 19 2020 12:00AM',12285,17634,15686478.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200047',N'0',NULL,N'từ ngày 13/7-12/8',N'Tạm ứng tiền điện tháng 8/2020 cho chi nhánh Hà Nội') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200470',N'TADY00000200047',N'',N'ADV_PAY',N'Aug 21 2020 12:00AM',5671,7998,11741344.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200047',N'0',NULL,N'',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200471',N'TADY00000200047',N'',N'ADV_PAY',N'Aug 21 2020 12:00AM',1870,2627,1350639.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200047',N'0',NULL,N'',N'') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200472',N'TRPY00000200292',N'TRC000000251144',N'PAY',N'Aug 21 2020 12:00AM',0,0,4445619.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOAN TIEN DIEN THANG 08.2020 CHO PGD HOA THANH') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200474',N'TRPY00000200294',N'TRC000001126921',N'PAY',N'Jan 1 1900 12:00AM',0,0,5636677.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TTTY00001120746',N'2',N'TTTY00001120746',N'THÁNG 08/2020',N'TAM UNG CP DIEN SH TU 7/7-6/8/2020 - PGD THOAI SON - GDNTU 082020/091010') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200476',N'TADY00000200019',N'TRC000000051011',N'ADV_PAY',N'Aug 17 2020 12:00AM',0,0,529923.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200019',N'0',NULL,N'T07.2020',N'CƯỚC ĐIỆN THOẠI CỐ ĐỊNH SỐ 39717900 VÀ 39717910 THÁNG 07.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200484',N'TRPY00000200306',N'TRC000001125767',N'PAY',N'Aug 21 2020 12:00AM',0,0,685240.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'Tháng 8/2020',N'THANH TOÁN CHI PHÍ LAVIE THÁNG 08.2020_PGD LÊ VĂN SỸ') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200492',N'TRPY00000200308',N'TRC000000251078',N'PAY',N'Aug 21 2020 12:00AM',0,0,1513654.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'THANH TOÁN ĐIỆN THOẠI VIETTEL THÁNG 7/2020 - CN ĐỒNG NAI') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200494',N'TADY00000200082',N'TRC000000251110',N'ADV_PAY',N'Aug 21 2020 12:00AM',7038,7331,5963158.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200082',N'0',NULL,N'THÁNG 08/2020',N'TẠM ỨNG CHI PHI ĐIỆN SINH HOẠT THÁNG 08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200496',N'TRPY00000200311',N'TRC000001126924',N'PAY',N'Jan 1 1900 12:00AM',0,0,7337149.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TTTY00001120752',N'2',N'TTTY00001120752',N'THANG 07/2020',N'TAM UNG DIEN SINH HOAT KY 09/07 - 08/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200497',N'TADY00000200084',N'TRC000000251159',N'ADV_PAY',N'Aug 21 2020 12:00AM',0,0,856071.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200084',N'0',NULL,N'7/2020',N'Tạm ứng cước phí viễn thông tháng 7') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200510',N'TADY00000200088',N'TRC000000251166',N'ADV_PAY',N'Aug 21 2020 12:00AM',0,0,100000000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'TADY00000200088',N'0',NULL,N'1',N'Tạm ứng chi phí xăng xe ô tô tại Hội sở tháng 8/2020 nạp vào tài khoản thẻ F-Card') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108307',N'TTTY00001120673',N'TRC000001126800',N'ADV_PAY',NULL,0,0,7693310.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'13/11/2018-13/1',N'Tiền điện sinh hoạt kỳ I năm 2019 từ 13/11/2018 đến 13/12/2018 của PGD Tân Bình') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108308',N'TTTY00001120674',N'TRC000001126801',N'ADV_PAY',NULL,0,0,210000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tiền đặt cọc thuê nhà PGD Quang Trung 1339-1341 Phan Văn Trị - Gò Vấp') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108309',N'TTTY00001120675',N'TRC000001126802',N'ADV_PAY',NULL,0,0,360000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'tiền đặt cọc thuê nhà 395-397 Lạc Long Quân, P.5, Q.11, TP.HCM') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108310',N'TTTY00001120676',N'TRC000001126803',N'ADV_PAY',NULL,0,0,400000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'tiền đặt cọc thuê nhà 211 Tô Hiến Thành, P.13, Q.10, TP.HCM') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108311',N'TTTY00001120677',N'TRC000001126805',N'ADV_PAY',NULL,0,0,753274.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'CƯỚC ĐIỆN THOẠI CỐ ĐỊNH SỐ 39717900 VÀ 39717910 THÁNG 06.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108312',N'TTTY00001120678',N'TRC000001125735',N'ADV_PAY',NULL,0,0,300000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Năm 2020',N'NỘP PHÍ CẤP MÃ SỬ DỤNG CƠ SỞ DỮ LIỆU VỀ GIAO DỊCH ĐẢM BẢO NĂM 2020 - MS: 106472662') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108313',N'TTTY00001120679',N'TRC000001125820',N'ADV_PAY',NULL,0,0,120000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tiền đặt cọc thuê nhà số 37 Trần não& 04 đường số 2 KP4 F.Bình An Q2 HCM') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108314',N'TTTY00001120680',N'TRC000001125819',N'ADV_PAY',NULL,0,0,327419.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 07/2020',N'THANH TOAN TIEN CUOC FTTH THANG 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108315',N'TTTY00001120681',N'TRC000001125736',N'ADV_PAY',NULL,0,0,1210709.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'THANH TOAN TIEN CUOC DT VIETTEL THANG 6/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108316',N'TTTY00001120682',N'TRC000001125736',N'ADV_PAY',NULL,0,0,1183964.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 07/2020',N'THANH TOAN TIEN CUOC DT VIETTEL THANG 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108317',N'TTTY00001120683',N'TRC000001126807',N'ADV_PAY',NULL,0,0,330000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Chi thanh toán tiền cọc nhà 671 Hồng Bàng, Phường 6, Quận 6 ( PGD Hậu Giang)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108318',N'TTTY00001120684',N'TRC000001125834',N'ADV_PAY',NULL,0,0,615000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tam ung chi phi dat coc tien thue tru so chi nhanh Nam Sai Gon theo HD 024215 ngay 05/7/2018') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108319',N'TTTY00001120685',N'TRC000001125836',N'ADV_PAY',NULL,0,0,4914138.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'24/06/2020-23/0',N'Tam ung chi phi dien tu 24/6/2020 - 23/7/2020- PGD Quan 10') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108320',N'TTTY00001120686',N'TRC000001125836',N'ADV_PAY',NULL,0,0,13330732.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'24/06/2020-23/0',N'Tạm ứng chi phí tiền điện từ 24/06/2020 đến 23/7/2020 MKH: 03000141397- Chi nhánh Nam Sai Gon') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108321',N'TTTY00001120687',N'TRC000001125836',N'ADV_PAY',NULL,0,0,8081982.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'24/06/2020-23/0',N'Tạm ứng chi phí điện sinh hoạt từ 24/06/2020 đến 23/07/2020- PGD Hậu Giang') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108322',N'TTTY00001120688',N'TRC000001125739',N'ADV_PAY',NULL,0,0,95876000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 7/2020',N'Tam ung chi phi dich vu bao ve thang 7.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108323',N'TTTY00001120689',N'TRC000001125857',N'ADV_PAY',NULL,0,0,7162060.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'18/05/2020-17/0',N'Tạm ứng tiền điện từ 18/5/2020-17/6/2020 PGD Quang Trung') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108324',N'TTTY00001120690',N'TRC000001125857',N'ADV_PAY',NULL,0,0,6797541.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'18/06/2020-17/0',N'Tạm ứng tiền điện từ 18/6/2020-17/7/2020 PGD Quang Trung') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108325',N'TTTY00001120691',N'TRC000001125784',N'ADV_PAY',NULL,0,0,5354655.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'TAM UNG THANH TOAN CHI PHI DIEN THANG 06/2020, PHI GUI XE KHACH HANG (XE LUOT) THANG 06/2020 CUA PGD NGUYEN TRAI') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108326',N'TTTY00001120692',N'TRC000001125785',N'ADV_PAY',NULL,0,0,764500.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'TAM UNG THANH TOAN CHI PHI DIEN THANG 06/2020, PHI GUI XE KHACH HANG (XE LUOT) THANG 06/2020 CUA PGD NGUYEN TRAI') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108327',N'TTTY00001120693',N'TRC000001125784',N'ADV_PAY',NULL,0,0,5981105.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 7/2020',N'TAM UNG THANH TOAN CHI PHI DIEN THANG 07/2020, PHI GUI XE KHACH HANG (XE LUOT) THANG 07/2020 CUA PGD NGUYEN TRAI') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108328',N'TTTY00001120694',N'TRC000001125785',N'ADV_PAY',NULL,0,0,687500.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 7/2020',N'TAM UNG THANH TOAN CHI PHI DIEN THANG 07/2020, PHI GUI XE KHACH HANG (XE LUOT) THANG 07/2020 CUA PGD NGUYEN TRAI') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108329',N'TTTY00001120695',N'TRC000001126797',N'ADV_PAY',NULL,0,0,25683602.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'ký quỹ+ CP gắn',N'Tạm ứng cp gắn đồng hồ nước PGD Phú Nhuận 172A Phan Đăng Lưu P3 Q.Phú Nhuận theo GDNTU 052020/088037') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108330',N'TTTY00001120696',N'TRC000001125818',N'ADV_PAY',NULL,0,0,300000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặt cọc thuê nhà 35-36-37 Đồng Khởi-BH -ĐN') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108331',N'TTTY00001120697',N'TRC000001125864',N'ADV_PAY',NULL,0,0,82500000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặt cọc thuê nhà PGD Trảng Bom- 2528 QL1A, Thanh Hóa-Hố Nai 3- BH- ĐN') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108332',N'TTTY00001120698',N'TRC000001125874',N'ADV_PAY',NULL,0,0,99000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặt cọc thuê nhà PGD Long Khánh - 473A Tổ 1, KP 4 P. Xuân Thanh, Long Khánh- ĐN') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108333',N'TTTY00001120699',N'TRC000001125815',N'ADV_PAY',NULL,0,0,10000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặt cọc tiền điện cho PGD Trảng Bom') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108334',N'TTTY00001120700',N'TRC000001125815',N'ADV_PAY',NULL,0,0,19000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặt cọc tiền điện cho PGD Hoá An') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108335',N'TTTY00001120701',N'TRC000001126912',N'ADV_PAY',NULL,0,0,180000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Trần Thị Mỹ Linh- TƯ tiền đặt cọc thuê nhà mở PGD Cờ Đỏ (Địa chỉ: Ấp Thới Thuận, TT Cờ Đỏ, Huyện Cờ Đỏ TPCT)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108336',N'TTTY00001120702',N'TRC000001125879',N'ADV_PAY',NULL,0,0,180000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Trần Thị Mỹ Linh- TƯ tiền đặt cọc thuê nhà mở PGD Thới Lai (Địa chỉ: Ấp Thới Thuận, TT Thới Lai, TPCT)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108337',N'TTTY00001120703',N'TRC000001125882',N'ADV_PAY',NULL,0,0,198000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Trần Thị Mỹ Linh- TƯ tiền đặt cọc thuê nhà 307 Nguyễn Văn Cừ (PGD Ninh Kiều)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108338',N'TTTY00001120704',N'TRC000001125884',N'ADV_PAY',NULL,0,0,7970735160.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'01/07/2020 đến',N'NH TMCP Bản Việt tt tiền thuê trụ sở và thuê đặt bảng quảng cáo tại toà nhà HM Town 412 NTMK P5 Q3 TPHCM từ 01/07/2020 đến 30/09/2020 theo GDNTU 072020/089967') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108339',N'TTTY00001120705',N'TRC000001125885',N'ADV_PAY',NULL,0,0,195000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tạm ứng tiền đặt cọc thuê nhà tại thị xã Trảng Bàng, tỉnh Tây Ninh, Số phiếu: 052020/088354') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108340',N'TTTY00001120706',N'TRC000001126913',N'ADV_PAY',NULL,0,0,5000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặng Trần Huyền Trân_Đặt cọc tiền thuê máy Photo cho PGD Tân Biên') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108341',N'TTTY00001120707',N'TRC000001126913',N'ADV_PAY',NULL,0,0,5000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tạm ứng tiền đặt cọc thuê máy photocopy PGD Trảng Bàng theo GDNTU 082020/090940') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108342',N'TTTY00001120708',N'TRC000001125889',N'ADV_PAY',NULL,0,0,5066064.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'07/07/2020 - 06',N'Tạm ứng tiền điện tháng 8/2020 từ 7/7/2020 đến 6/8/2020 theo GDNTU 082020/091102') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108343',N'TTTY00001120709',N'TRC000001125883',N'ADV_PAY',NULL,0,0,17675037.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 7/2020',N'Tạm ứng cp cước 94 lines ĐTCĐ tháng 7/2020 theo GDNTU 082020/091152') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108344',N'TTTY00001120710',N'TRC000001125892',N'ADV_PAY',NULL,0,0,4468704.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'07/06/2020-06/0',N'Thanh toán tiền điện 07/06/2020-06/07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108345',N'TTTY00001120711',N'TRC000001125892',N'ADV_PAY',NULL,0,0,5633882.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'07/07/2020-06/0',N'Thanh toán tiền điện 07/07/2020-06/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108346',N'TTTY00001120712',N'TRC000001125896',N'ADV_PAY',NULL,0,0,78948943.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 07/2020',N'Tạm ứng chi phí đóng BHXH, BHYT, BHTN tháng 07/2020 CN Cà Mau') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108347',N'TTTY00001120713',N'TRC000001125901',N'ADV_PAY',NULL,0,0,17055049.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'08/07/2020-07/0',N'Thanh toán tiền điện 08/07/2020-07/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108348',N'TTTY00001120714',N'TRC000001125902',N'ADV_PAY',NULL,0,0,360333.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 07/2020',N'Tạm ứng thanh toán tiền nước tháng 07/2020 CN Long An') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108349',N'TTTY00001120715',N'TRC000001125902',N'ADV_PAY',NULL,0,0,347464.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 08/2020',N'Tạm ứng tiền nước SH tháng 08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108350',N'TTTY00001120716',N'TRC000001125899',N'ADV_PAY',NULL,0,0,300000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Năm 2020',N'Tạm ứng thanh toán phí giao dịch đảm bảo mã số 102717971 NH Bản Việt CN Long An') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108351',N'TTTY00001120717',N'TRC000001125907',N'ADV_PAY',NULL,0,0,5442615.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'03/07/2020-02/0',N'Tạm ứng tiền điện từ ngày ngày 03/07/2020-02/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108352',N'TTTY00001120718',N'TRC000001125908',N'ADV_PAY',NULL,0,0,321849.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 07/2020',N'Tạm ứng cước VT-CNTT tháng 06/2020 PGD Kiến Tường') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108353',N'TTTY00001120719',N'TRC000001125909',N'ADV_PAY',NULL,0,0,5607883.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'08/07/2020-07/0',N'Tạm ứng tiền điện từ ngày ngày 08/07/2020-07/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108354',N'TTTY00001120720',N'TRC000001125851',N'ADV_PAY',NULL,0,0,264000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'KET CHUYEN CHI PHI TAM UNG DAT COC TIEN THUE NHA PGD TRUONG CHINH -423 CONG HOA, P15, Q.TAN BINH THEO GDNTU 092017/045876 N07.09.2017') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108355',N'TTTY00001120721',N'TRC000001125870',N'ADV_PAY',NULL,0,0,420000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tạm ứng đặt cọc tiền thuê nhà 306 Bạch Đằng-PGDHX') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108356',N'TTTY00001120722',N'TRC000001125786',N'ADV_PAY',NULL,0,0,181823943.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Th/ toán tiền đặt cọc Thuê nhà 208 Nguyễn Trãi') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108357',N'TTTY00001120723',N'TRC000001125786',N'ADV_PAY',NULL,0,0,35427272.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Th/ toán tiền đặt cọc Thuê nhà Tầng M, 208 Nguyễn Trãi') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108358',N'TTTY00001120724',N'TRC000001125786',N'ADV_PAY',NULL,0,0,150812785.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Th/ toán tiền đặt cọc bổ sung Thuê nhà Tầng G, 208 Nguyễn Trãi') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108359',N'TTTY00001120725',N'TRC000001125917',N'ADV_PAY',NULL,0,0,4802798.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 07/2020',N'TAM UNG CP DIEN SH T7/2020 - PGD PHU TAN - GDNTU 082020/091005') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108360',N'TTTY00001120726',N'TRC000001126914',N'ADV_PAY',NULL,0,0,148788.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 07/2020',N'TAM UNG CP NUOC SH T7/2020 - PGD PHU TAN - GDNTU 082020/091005') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108361',N'TTTY00001120727',N'TRC000001126915',N'ADV_PAY',NULL,0,0,86679000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 01/2020',N'TAM UNG NOP BHXH - BHYT - BHTN- T01/2020 - CN TIEN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108362',N'TTTY00001120728',N'TRC000001126915',N'ADV_PAY',NULL,0,0,80556485.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 02/2020',N'TAM UNG CP NOP BHXH, BHYT, BHTN THANG 02/2020-CN TIEN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108363',N'TTTY00001120729',N'TRC000001126915',N'ADV_PAY',NULL,0,0,84118169.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 03/2020',N'CN TIEN GIANG TAM UNG NOP BHXH BHYT BHTN THANG 03/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108364',N'TTTY00001120730',N'TRC000001125911',N'ADV_PAY',NULL,0,0,1835492.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 03/2020',N'Tạm ứng cước điện thoại cố định tháng 03/2020 của CN Đà Nẵng') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108365',N'TTTY00001120731',N'TRC000001126915',N'ADV_PAY',NULL,0,0,83968076.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 04/2020',N'CN TIEN GIANG TAM UNG NOP BHXH BHYT BHTN THANG 04/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108366',N'TTTY00001120732',N'TRC000001126916',N'ADV_PAY',NULL,0,0,615000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'QUÝ 2/2020',N'TẠM ỨNG TRẢ TIỀN THU GOM RÁC QUÝ 2/2020 CỦA CHI NHÁNH ĐÀ NẴNG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108367',N'TTTY00001120733',N'TRC000001126915',N'ADV_PAY',NULL,0,0,79236169.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 05/2020',N'Tạm ứng chi phí trích nộp BHXH, BHYT, BHTN, BHTNLĐ, BNN Chi nhánh Tiền Giang tháng 05/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108368',N'TTTY00001120734',N'TRC000001126917',N'ADV_PAY',NULL,0,0,938994.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 07/2020',N'TAM UNG CP NUOC SH T7/2020 - CN THANG LONG - GDNTU 072020/089784') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108369',N'TTTY00001120735',N'TRC000001126918',N'ADV_PAY',NULL,0,0,46123200.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 06/2020',N'TAM UNG TIEN NOP BHXH THANG 06.2020 CN QUANG NINH THEO GDNTU SO 072020/089875') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108370',N'TTTY00001120736',N'TRC000001126919',N'ADV_PAY',NULL,0,0,600000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'năm 2020',N'TAM UNG NOP PHI CAP MA SO SU DUNG CO SO DU LIEU VE GIAO DICH DAM BAO NAM 2020 PGD GO CONG THEO GDNTU 072020/089883') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108371',N'TTTY00001120737',N'TRC000001126915',N'ADV_PAY',NULL,0,0,75625369.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 06/2020',N'TAM UNG NOP BHXH THANG 06.2020 CN TIEN GIANG THEO GDNTU SO 072020/089886') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108372',N'TTTY00001120738',N'TRC000001125932',N'ADV_PAY',NULL,0,0,480000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'15/6-14/12/2020',N'Tạm ứng tiền thuê nhà kỳ từ 15/6-14/12/2020 cho PGD Ba Đình') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108373',N'TTTY00001120739',N'TRC000001125933',N'ADV_PAY',NULL,0,0,8177257.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Từ 13/06-12/07/',N'Tạm ứng tiền điện từ 13/06-12/07/2020 cho PGD Ba Đình') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108374',N'TTTY00001120740',N'TRC000001125933',N'ADV_PAY',NULL,0,0,26452753.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Từ 13/06-12/07/',N'Tạm ứng tiền điện từ 13/06-12/07/2020 cho chi nhánh Hà Nội') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108375',N'TTTY00001120741',N'TRC000001126920',N'ADV_PAY',NULL,0,0,56916226.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 07/2020',N'Tạm ứng chi phí bhxh tháng 7 năm 2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108376',N'TTTY00001120742',N'TRC000001125936',N'ADV_PAY',NULL,0,0,45000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,NULL,N'Tạm ứng chi phí đặt cọc tiền thuê nhà cho PGD Hồng Bàng - CN Hải Phòng') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108377',N'TTTY00001120743',N'TRC000001126781',N'ADV_PAY',NULL,0,0,679640.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 08/2020',N'Tạm ứng tiền nước sinh hoạt tháng 08.2020 từ ngày CN Hải Phòng') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108378',N'TTTY00001120744',N'TRC000001126918',N'ADV_PAY',NULL,0,0,45769600.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 07/2020',N'Tạm ứng chi phí bhxh tháng 7 năm 2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108379',N'TTTY00001120745',N'TRC000001126917',N'ADV_PAY',NULL,0,0,938994.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 08/2020',N'TAM UNG CP NUOC SH TU 3/7-2/8/2020 - CN THANG LONG - GDNTU 082020/091001') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108380',N'TTTY00001120746',N'TRC000001126921',N'ADV_PAY',NULL,0,0,5636677.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 08/2020',N'TAM UNG CP DIEN SH TU 7/7-6/8/2020 - PGD THOAI SON - GDNTU 082020/091010') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108381',N'TTTY00001120747',N'TRC000001125938',N'ADV_PAY',NULL,0,0,918896.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 07/2020',N'Tạm ứng cước điện thoại VNPT tháng 7/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108382',N'TTTY00001120748',N'TRC000001125911',N'ADV_PAY',NULL,0,0,1556310.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 07/2020',N'TAM UNG CP DTCD T7/2020 - CN DA NANG - GDNTU 082020/091106') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108383',N'TTTY00001120749',N'TRC000001126922',N'ADV_PAY',NULL,0,0,13869636.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'11/07-10/08/202',N'TẠM ỨNG TIỀN ĐIỆN SINH HOẠT 11/07-10/08/2020 BVB AN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108384',N'TTTY00001120750',N'TRC000001126923',N'ADV_PAY',NULL,0,0,749909.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 08/2020',N'TAM UNG NUOC SINH HOAT T08/2020 CN DA NANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108385',N'TTTY00001120751',N'TRC000001126915',N'ADV_PAY',NULL,0,0,78211693.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 07/2020',N'TAM UNG NOP BHXH - BHYT - BHTN- T07/2020 - CN TIEN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108386',N'TTTY00001120752',N'TRC000001126924',N'ADV_PAY',NULL,0,0,7337149.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THANG 07/2020',N'TAM UNG DIEN SINH HOAT KY 09/07 - 08/08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108387',N'TTTY00001120753',N'TRC000001125924',N'ADV_PAY',NULL,0,0,15803043.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 08/2020',N'Tạm ứng tiền điện sinh hoạt tháng 8/2020 cho Cn Thăng Long') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108388',N'TTTY00001120754',N'TRC000001126925',N'ADV_PAY',NULL,0,0,431014.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'tháng 07/2020',N'TAM UNG CUOC DIEN THOAI T07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108389',N'TTTY00001120755',N'TRC000001126926',N'ADV_PAY',NULL,0,0,461370.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'tháng 08/2020',N'TAM UNG CP NUOC SH T08/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYPY00001108390',N'TTTY00001120756',N'TRC000001126927',N'ADV_PAY',NULL,0,0,400000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,NULL,N'Tạm ứng cước viễn thông T07/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108091',N'TTDY00001120454',N'TRC000001125890',N'ADV_PAY',NULL,0,0,568100.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 05/2020',N'Tạm ứng tiền nước SH tháng 05/2020 CN Bình Dương') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108092',N'TTDY00001120455',N'TRC000001125892',N'ADV_PAY',NULL,0,0,6057989.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'07/05/2020-06/0',N'Tạm ứng tiền điện 07/05/2020-06/06/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108093',N'TTDY00001120456',N'TRC000001125896',N'ADV_PAY',NULL,0,0,83417254.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 05/2020',N'Tạm ứng chi phí đóng BHXH, BHYT, BHTN tháng 05/2020 CN Cà Mau') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108094',N'TTDY00001120457',N'TRC000001125899',N'ADV_PAY',NULL,0,0,300000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Năm 2020',N'Tạm ứng nộp phí cấp mã số sử dụng CSDL về giao dịch đảm bảo năm 2020 - mã số 102717971 CN Long An') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108095',N'TTDY00001120458',N'TRC000001125905',N'ADV_PAY',NULL,0,0,373084.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 05/2020',N'Tạm ứng cước VT-CNTT tháng 05/2020 PGD Kiến Tường') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108096',N'TTDY00001120459',N'TRC000001125909',N'ADV_PAY',NULL,0,0,5161599.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Từ ngày 08/05 -',N'Tạm ứng tiền điện từ ngày ngày 08/05 - 7/06/2020 PGD Bến Lức') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108097',N'TTDY00001120460',N'TRC000001126777',N'ADV_PAY',NULL,0,0,8151897.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'10/05 - 09/06/2',N'Tạm ứng tiền điện từ 10/05 - 09/06/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108098',N'TTDY00001120461',N'TRC000001126778',N'ADV_PAY',NULL,0,0,72146.00,NULL,NULL,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 05/2020',N'Tạm ứng tiền nước SH tháng 05/2020 CN Gia Lai') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108099',N'TTDY00001120462',N'TRC000001126779',N'ADV_PAY',NULL,0,0,903516.00,NULL,NULL,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 05/2020',N'Tạm ứng tiền điện thoại tháng 05/2020 CN Gia Lai') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108100',N'TTDY00001120463',N'TRC000001126780',N'ADV_PAY',NULL,0,0,14438468.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'15/05 - 14/06/2',N'Tạm ứng tiền điện từ ngày 15/05 - 14/06/2020 CN Hải PHòng') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108101',N'TTDY00001120464',N'TRC000001126781',N'ADV_PAY',NULL,0,0,657572.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'Tạm ứng tiền nước sinh hoạt tháng 06.2020 CN Hải PHòng') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108102',N'TTDY00001120465',N'TRC000001125925',N'ADV_PAY',NULL,0,0,831422.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'04/05/2020-03/0',N'TẠM ỨNG TRẢ TIỀN NUOCS SINH HOẠT THÁNG 06/2020 CỦA CN ĐÀ NẴNG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108103',N'TTDY00001120466',N'TRC000001126886',N'ADV_PAY',NULL,0,0,12513246.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 06/2020',N'Tạm ứng tiền điện sinh hoạt tháng 6/2020 cho Cn Thăng Long') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108104',N'TTDY00001120467',N'TRC000001126887',N'ADV_PAY',NULL,0,0,4422796.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 05/2020',N'Tạm ứng hóa đơn tiền điện sinh hoạt kỳ 5/2020 - PGD Phú Tân') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108105',N'TTDY00001120468',N'TRC000001126888',N'ADV_PAY',NULL,0,0,148788.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 05/2020',N' Tạm ứng hóa đơn tiền nước sinh hoạt kỳ 5/2020 - PGD Phú Tân') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108106',N'TTDY00001120469',N'TRC000001126889',N'ADV_PAY',NULL,0,0,114166.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 04/2020',N'Tạm ứng tiền cước viễn thông tháng 04/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108107',N'TTDY00001120470',N'TRC000001126890',N'ADV_PAY',NULL,0,0,15290135.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'tháng 05/2020',N'tạm ứng tiền điện từ ngày 13.04-12.05.20') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108108',N'TTDY00001120471',N'TRC000001126891',N'ADV_PAY',NULL,0,0,1835492.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 03/2020',N'Tạm ứng cước điện thoại cố định tháng 03/2020 của CN Đà Nẵng') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108109',N'TTDY00001120472',N'TRC000001126892',N'ADV_PAY',NULL,0,0,615000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'QUÝ 2/2020',N'TẠM ỨNG TRẢ TIỀN THU GOM RÁC QUÝ 2/2020 CỦA CHI NHÁNH ĐÀ NẴNG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108110',N'TTDY00001120473',N'TRC000001126893',N'ADV_PAY',NULL,0,0,15095471.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'15/05/2020 - 14',N'TẠM ỨNG TRẢ TIỀN ĐIỆN SINH HOẠT TỪ 15/05/2020 - 14/06/2020 CỦA CHI NHÁNH ĐÀ NẴNG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108111',N'TTDY00001120474',N'TRC000001126894',N'ADV_PAY',NULL,0,0,300000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'NĂM 2020',N'TẠM ỨNG CP NỘP PHÍ CẤP MÃ SỐ SỬ DỤNG CƠ SỞ DỮ LIỆU GIAO DỊCH ĐẢM BẢO NĂM 2020 CN DAKLAK') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108112',N'TTDY00001120475',N'TRC000001126895',N'ADV_PAY',NULL,0,0,300000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'NĂM 2020',N'PGD HẢI CHÂU TẠM ỨNG ĐỂ NỘP PHÍ CẤP MÃ SỐ SD CSDL VỀ GD BẢO ĐẢM NĂM 2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108113',N'TTDY00001120476',N'TRC000001125923',N'ADV_PAY',NULL,0,0,86679000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 01/2020',N'TAM UNG NOP BHXH - BHYT - BHTN- T01/2020 - CN TIEN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108114',N'TTDY00001120477',N'TRC000001125923',N'ADV_PAY',NULL,0,0,80556485.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 02/2020',N'TAM UNG CP NOP BHXH, BHYT, BHTN THANG 02/2020-CN TIEN GIANG') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108115',N'TTDY00001120478',N'TRC000001125923',N'ADV_PAY',NULL,0,0,84118169.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 03/2020',N'CN TIEN GIANG TAM UNG NOP BHXH BHYT BHTN THANG 03/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108116',N'TTDY00001120479',N'TRC000001125923',N'ADV_PAY',NULL,0,0,83968076.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 04/2020',N'CN TIEN GIANG TAM UNG NOP BHXH BHYT BHTN THANG 04/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108117',N'TTDY00001120480',N'TRC000001125923',N'ADV_PAY',NULL,0,0,79236169.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 05/2020',N'Tạm ứng chi phí trích nộp BHXH, BHYT, BHTN, BHTNLĐ, BNN Chi nhánh Tiền Giang tháng 05/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108118',N'TTDY00001120481',N'TRC000001126792',N'ADV_PAY',NULL,0,0,5057800.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,NULL,N'Tạm ứng thanh toán tiền DV bảo vệ tháng 12/2019 tại CN Nha Trang') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108119',N'TTDY00001120482',N'TRC000001126792',N'ADV_PAY',NULL,0,0,5287700.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,NULL,N'Tạm ứng thanh toán tiền DV bảo vệ tháng 10/2019 tại CN Nha Trang') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108120',N'TTDY00001120483',N'TRC000001126792',N'ADV_PAY',NULL,0,0,9425900.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,NULL,N'Tạm ứng thuê bảo vệ t01+02/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108121',N'TTDY00001120484',N'TRC000001126896',N'ADV_PAY',NULL,0,0,362601.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'tháng 05/2020',N'Tạm ứng Thanh toán DVVT tháng 5/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108122',N'TTDY00001120485',N'TRC000001126897',N'ADV_PAY',NULL,0,0,7222669.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'THÁNG 06/2020',N'Tạm ứng thanh toán tiền điện tháng 6/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108123',N'TTDY00001120486',N'TRC000001126795',N'ADV_PAY',NULL,0,0,12475100.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,NULL,N'TAM UNG CP DV BAO VE THNG 03/2020 - PGD VINH HAI - GDNTU 052020/088345') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108124',N'TTDY00001120487',N'TRC000001126898',N'ADV_PAY',NULL,0,0,101124265.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'11/05/2020 đến',N'Tạm ứng tiền điện cho TTDL Bình Dương tháng 6/2020 từ N.11/05 DEN N.10/06/2020 theo GDNTU 062020/089164') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108125',N'TTDY00001120488',N'TRC000001126797',N'ADV_PAY',NULL,0,0,25683602.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'ký quỹ+ CP gắn',N'Tạm ứng cp gắn đồng hồ nước PGD Phú Nhuận 172A Phan Đăng Lưu P3 Q.Phú Nhuận theo GDNTU 052020/088037') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108126',N'TTDY00001120489',N'TRC000001126798',N'ADV_PAY',NULL,0,0,25000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tạm ứng bảo đảm hợp đồng mua bán điện - CN cần Thơ theo GDNTU 042019/071345') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108127',N'TTDY00001120490',N'TRC000001126799',N'ADV_PAY',NULL,0,0,1732594.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 5/2020',N'Tạm ứng tiền điện thoại tháng 05/2020 (CN & các PGD) theo GDNTU 062020/088938') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108128',N'TTDY00001120491',N'TRC000001126798',N'ADV_PAY',NULL,0,0,16292041.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 6/2020',N'Tạm ứng tiền điện tháng 06/2020 (07/05-06/06/2020) theo GDNTU 062020/089011') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108129',N'TTDY00001120492',N'TRC000001125818',N'ADV_PAY',NULL,0,0,300000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặt cọc thuê nhà 35-36-37 Đồng Khởi-BH -ĐN') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108130',N'TTDY00001120493',N'TRC000001125863',N'ADV_PAY',NULL,0,0,82500000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặt cọc thuê nhà PGD Trảng Bom- 2528 QL1A, Thanh Hóa-Hố Nai 3- BH- ĐN') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108131',N'TTDY00001120494',N'TRC000001125865',N'ADV_PAY',NULL,0,0,99000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Đặt cọc thuê nhà PGD Long Khánh - 473A Tổ 1, KP 4 P. Xuân Thanh, Long Khánh- ĐN') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108132',N'TTDY00001120495',N'TRC000001125877',N'ADV_PAY',NULL,0,0,180000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Trần Thị Mỹ Linh- TƯ tiền đặt cọc thuê nhà mở PGD Cờ Đỏ (Địa chỉ: Ấp Thới Thuận, TT Cờ Đỏ, Huyện Cờ Đỏ TPCT)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108133',N'TTDY00001120496',N'TRC000001125878',N'ADV_PAY',NULL,0,0,180000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Trần Thị Mỹ Linh- TƯ tiền đặt cọc thuê nhà mở PGD (Địa chỉ: Ấp Thới Thuận, TT Thới Lai, TPCT)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108134',N'TTDY00001120497',N'TRC000001125880',N'ADV_PAY',NULL,0,0,198000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Trần Thị Mỹ Linh- TƯ tiền đặt cọc thuê nhà 307 Nguyễn Văn Cừ') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108135',N'TTDY00001120498',N'TRC000001125883',N'ADV_PAY',NULL,0,0,17982391.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'Tạm ứng cp cước 94 lines ĐTCĐ tháng 6/2020 theo GDNTU 072020/090090') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108136',N'TTDY00001120499',N'TRC000001125884',N'ADV_PAY',NULL,0,0,7970735160.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'01/07/2020 đến',N'NH TMCP Bản Việt tt tiền thuê trụ sở và thuê đặt bảng quảng cáo tại toà nhà HM Town 412 NTMK P5 Q3 TPHCM từ 01/07/2020 đến 30/09/2020 theo GDNTU 072020/089967') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108137',N'TTDY00001120500',N'TRC000001126800',N'ADV_PAY',NULL,0,0,7693310.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'13/11/2018-13/1',N'Tiền điện sinh hoạt kỳ I năm 2019 từ 13/11/2018 đến 13/12/2018 của PGD Tân Bình') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108138',N'TTDY00001120501',N'TRC000001126801',N'ADV_PAY',NULL,0,0,210000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tiền đặt cọc thuê nhà PGD Quang Trung 1339-1341 Phan Văn Trị - Gò Vấp') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108139',N'TTDY00001120502',N'TRC000001126802',N'ADV_PAY',NULL,0,0,360000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'tiền đặt cọc thuê nhà 395-397 Lạc Long Quân, P.5, Q.11, TP.HCM') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108140',N'TTDY00001120503',N'TRC000001126803',N'ADV_PAY',NULL,0,0,400000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'tiền đặt cọc thuê nhà 211 Tô Hiến Thành, P.13, Q.10, TP.HCM') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108141',N'TTDY00001120504',N'TRC000001126804',N'ADV_PAY',NULL,0,0,120000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tạm ứng thanh toán đặt cọc nhà 98E Phan Đăng Lưu, P.3, Q.Phú Nhuận theo HĐ 2478/HĐ-TN') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108142',N'TTDY00001120505',N'TRC000001126805',N'ADV_PAY',NULL,0,0,753274.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'CƯỚC ĐIỆN THOẠI CỐ ĐỊNH SỐ 39717900 VÀ 39717910 THÁNG 06.2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108143',N'TTDY00001120506',N'TRC000001126806',N'ADV_PAY',NULL,0,0,300000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Năm 2020',N'NỘP PHÍ CẤP MÃ SỬ DỤNG CƠ SỞ DỮ LIỆU VỀ GIAO DỊCH ĐẢM BẢO NĂM 2020 - MS: 106472662') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108144',N'TTDY00001120507',N'TRC000001125857',N'ADV_PAY',NULL,0,0,7162060.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'18/05/2020-17/0',N'Tạm ứng tiền điện từ 18/5/2020-17/6/2020 PGD Quang Trung') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108145',N'TTDY00001120508',N'TRC000001125820',N'ADV_PAY',NULL,0,0,120000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tiền đặt cọc thuê nhà số 37 Trần não& 04 đường số 2 KP4 F.Bình An Q2 HCM') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108146',N'TTDY00001120509',N'TRC000001126807',N'ADV_PAY',NULL,0,0,330000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Chi thanh toán tiền cọc nhà 671 Hồng Bàng, Phường 6, Quận 6 ( PGD Hậu Giang)') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108147',N'TTDY00001120510',N'TRC000001125834',N'ADV_PAY',NULL,0,0,615000000.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'đặt cọc',N'Tam ung chi phi dat coc tien thue tru so chi nhanh Nam Sai Gon theo HD 024215 ngay 05/7/2018') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108148',N'TTDY00001120511',N'TRC000001125836',N'ADV_PAY',NULL,0,0,7836209.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'24/05/2020-23/0',N'Tạm ứng tiền điện 24/05-23/06/2020 PGD Hậu Giang') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108149',N'TTDY00001120512',N'TRC000001125836',N'ADV_PAY',NULL,0,0,4439294.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'24/05/2020-23/0',N'Tạm ứng tiền điện 24/05-23/06/2020 PGD Quận 10') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108150',N'TTDY00001120513',N'TRC000001125736',N'ADV_PAY',NULL,0,0,1210709.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'THANH TOAN TIEN CUOC DT VIETTEL THANG 6/2020') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108151',N'TTDY00001120514',N'TRC000001125784',N'ADV_PAY',NULL,0,0,5354655.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'TAM UNG THANH TOAN CHI PHI DIEN THANG 06/2020, PHI GUI XE KHACH HANG (XE LUOT) THANG 06/2020 CUA PGD NGUYEN TRAI') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108152',N'TTDY00001120515',N'TRC000001125785',N'ADV_PAY',NULL,0,0,764500.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'Tháng 06/2020',N'TAM UNG THANH TOAN CHI PHI DIEN THANG 06/2020, PHI GUI XE KHACH HANG (XE LUOT) THANG 06/2020 CUA PGD NGUYEN TRAI') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108153',N'TTDY00001120516',N'TRC000001125857',N'ADV_PAY',NULL,0,0,6797541.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'18/06/2020-17/0',N'Tạm ứng tiền điện từ 18/6/2020-17/7/2020 PGD Quang Trung') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108154',N'TTDY00001120517',N'TRC000001125836',N'ADV_PAY',NULL,0,0,4914138.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'24/06/2020-23/0',N'Tam ung chi phi dien tu 24/6/2020 - 23/7/2020- PGD Quan 10') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108155',N'TTDY00001120518',N'TRC000001125836',N'ADV_PAY',NULL,0,0,13330732.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'24/06/2020-23/0',N'Tạm ứng chi phí tiền điện từ 24/06/2020 đến 23/7/2020 MKH: 03000141397- Chi nhánh Nam Sai Gon') 
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'TPOD00001108156',N'TTDY00001120519',N'TRC000001125836',N'ADV_PAY',NULL,0,0,8081982.00,N'VND',1.00,N'A',NULL,NULL,NULL,N'0',NULL,N'24/06/2020-23/0',N'Tạm ứng chi phí điện sinh hoạt từ 24/06/2020 đến 23/07/2020- PGD Hậu Giang') 

Result ErrorDesc 
SUCCESSFULL