EXEC dbo.sp_generate_inserts @table_name = 'TR_REQ_PAY_PERIOD', @from = 'from TR_REQ_PAY_PERIOD' 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 di?n sinh ho?t cho BVB Cà Mau (t? ngày 12/07/2020 d?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 CU?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 TU?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 di?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 d?n 14/8/2020',N'T?m ?ng thanh toán ti?n di?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 VAN PH̉NG PH?M T08.2020 THEO S? HĐGTGT: 0080324 NGÀY 10.08.2020 BVB KI?N TU?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? cu?c tháng 6/2020',N'CMC - Thanh toán cu?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? cu?c tháng 6/2020',N'CMC - Thanh toán cu?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 di?n t? ngày 10/07/2020 d?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 don nu?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Í NU?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Í NU?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 d?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 di?n sinh ho?t cho BVB Đ?m Doi (t? ngày 06/07/2020 d?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 di?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 di?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 di?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 Pḥ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 cu?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 d?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 Đ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 DI 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í nu?c sinh ho?t k? 08/2019 t? ngày 15/07/2020 d?n ngày 10/08/2020, chi phí di?n sinh ho?t tháng 08/2020(31 ngày t? 11/07/2020 d?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í nu?c sinh ho?t k? 08/2019 t? ngày 15/07/2020 d?n ngày 10/08/2020, chi phí di?n sinh ho?t tháng 08/2020(31 ngày t? 11/07/2020 d?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 di?n tháng 8/2020 t? 7/7/2020 d?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 di?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 di?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Í NU?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 CU?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 d?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 d?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 di?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 di?n tho?i c? d?nh + di?n tho?i báo d?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 di?n tho?i c? d?nh + di?n tho?i báo d?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 nu?c sinh ho?t t? ngày 04/07/2020 d?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í van pḥng ph?m d?nh m?c và v?t li?u van pḥng quư 3/2020 Cho CN Thang 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Í CU?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 NU?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 di?n sinh ho?t cho BVB Cà Mau (t? ngày 12/07/2020 d?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 d?n 14.8.2020',N'Thanh toán chi phí di?n, nu?c, DVCC k? 15.7.2020 d?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 don thuê bao di?n tho?i c? d?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 don thuê bao di?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 cu?c di?n tho?i c? d?nh cho CN Thang 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 cu?c di?n tho?i di dông (sim báo d?ng ATM) cho Cn Thang 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 don d?ch v? buu 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 di?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 NU?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 di?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 di?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'CU?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Ê VAN 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 cu?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í xang 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 di?n sinh ho?t k? I nam 2019 t? 13/11/2018 d?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'd?t c?c',N'Ti?n d?t c?c thuê nhà PGD Quang Trung 1339-1341 Phan Van 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'd?t c?c',N'ti?n d?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'd?t c?c',N'ti?n d?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'CU?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'Nam 2020',N'N?P PHÍ C?P MĂ S? D?NG CO S? D? LI?U V? GIAO D?CH Đ?M B?O NAM 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'd?t c?c',N'Ti?n d?t c?c thuê nhà s? 37 Tr?n năo& 04 du?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'd?t c?c',N'Chi thanh toán ti?n c?c nhà 671 H?ng Bàng, Phu?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'd?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 di?n t? 24/06/2020 d?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í di?n sinh ho?t t? 24/06/2020 d?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 di?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 di?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 d?ng h? nu?c PGD Phú Nhu?n 172A Phan Đang Luu 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'd?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'd?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'd?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'd?t c?c',N'Đ?t c?c ti?n di?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'd?t c?c',N'Đ?t c?c ti?n di?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'd?t c?c',N'Trâ`n Thi? My~ Linh- TU tiê`n da?t co?c thuê nha` 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'd?t c?c',N'Trâ`n Thi? My~ Linh- TU tiê`n da?t co?c thuê nha` 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'd?t c?c',N'Trâ`n Thi? My~ Linh- TU tiê`n da?t co?c thuê nha` 307 Nguyê~n Van Cu` (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 d?n',N'NH TMCP B?n Vi?t tt ti?n thuê tr? s? và thuê d?t b?ng qu?ng cáo t?i toà nhà HM Town 412 NTMK P5 Q3 TPHCM t? 01/07/2020 d?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'd?t c?c',N'T?m ?ng ti?n d?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'd?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'd?t c?c',N'T?m ?ng ti?n d?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 di?n tháng 8/2020 t? 7/7/2020 d?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 cu?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 di?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 di?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í dó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 di?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 nu?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 nu?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'Nam 2020',N'T?m ?ng thanh toán phí giao d?ch d?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 di?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 cu?c VT-CNTT tháng 06/2020 PGD Ki?n Tu?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 di?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'd?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'd?t c?c',N'T?m ?ng d?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'd?t c?c',N'Th/ toán ti?n d?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'd?t c?c',N'Th/ toán ti?n d?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'd?t c?c',N'Th/ toán ti?n d?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 cu?c di?n tho?i c? d?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'nam 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 di?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 di?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 nam 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í d?t c?c ti?n thuê nhà cho PGD H?ng Bàng - CN H?i Pḥ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 nu?c sinh ho?t tháng 08.2020 t? ngày CN H?i Pḥ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 nam 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 cu?c di?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 di?n sinh ho?t tháng 8/2020 cho Cn Thang 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 cu?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 nu?c SH tháng 05/2020 CN B́nh Duong') INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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 di?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í dó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'Nam 2020',N'T?m ?ng n?p phí c?p mă s? s? d?ng CSDL v? giao d?ch d?m b?o nam 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 cu?c VT-CNTT tháng 05/2020 PGD Ki?n Tu?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 di?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 di?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 nu?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 di?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 di?n t? ngày 15/05 - 14/06/2020 CN H?i PḤ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 nu?c sinh ho?t tháng 06.2020 CN H?i PḤ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 di?n sinh ho?t tháng 6/2020 cho Cn Thang 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 don ti?n di?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 don ti?n nu?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 cu?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 di?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 cu?c di?n tho?i c? d?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'NAM 2020',N'T?M ?NG CP N?P PHÍ C?P MĂ S? S? D?NG CO S? D? LI?U GIAO D?CH Đ?M B?O NAM 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'NAM 2020',N'PGD H?I CHÂU T?M ?NG Đ? N?P PHÍ C?P MĂ S? SD CSDL V? GD B?O Đ?M NAM 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 di?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 d?n',N'T?m ?ng ti?n di?n cho TTDL B́nh Duong 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 d?ng h? nu?c PGD Phú Nhu?n 172A Phan Đang Luu 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'd?t c?c',N'T?m ?ng b?o d?m h?p d?ng mua bán di?n - CN c?n Tho 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 di?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 di?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'd?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'd?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'd?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'd?t c?c',N'Trâ`n Thi? My~ Linh- TU tiê`n da?t co?c thuê nha` 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'd?t c?c',N'Trâ`n Thi? My~ Linh- TU tiê`n da?t co?c thuê nha` 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'd?t c?c',N'Trâ`n Thi? My~ Linh- TU tiê`n da?t co?c thuê nha` 307 Nguyê~n Van Cu`') INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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 cu?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 d?n',N'NH TMCP B?n Vi?t tt ti?n thuê tr? s? và thuê d?t b?ng qu?ng cáo t?i toà nhà HM Town 412 NTMK P5 Q3 TPHCM t? 01/07/2020 d?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 di?n sinh ho?t k? I nam 2019 t? 13/11/2018 d?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'd?t c?c',N'Ti?n d?t c?c thuê nhà PGD Quang Trung 1339-1341 Phan Van 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'd?t c?c',N'ti?n d?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'd?t c?c',N'ti?n d?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'd?t c?c',N'T?m ?ng thanh toán d?t c?c nhà 98E Phan Đang Luu, 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'CU?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'Nam 2020',N'N?P PHÍ C?P MĂ S? D?NG CO S? D? LI?U V? GIAO D?CH Đ?M B?O NAM 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 di?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'd?t c?c',N'Ti?n d?t c?c thuê nhà s? 37 Tr?n năo& 04 du?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'd?t c?c',N'Chi thanh toán ti?n c?c nhà 671 H?ng Bàng, Phu?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'd?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 di?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 di?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 di?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 di?n t? 24/06/2020 d?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í di?n sinh ho?t t? 24/06/2020 d?n 23/07/2020- PGD H?u Giang') Result ErrorDesc SUCCESSFULL