|
1
|
|
|
2
|
|
|
3
|
EXEC dbo.sp_generate_inserts @table_name = 'TR_REQ_PAY_PERIOD', @from = 'from TR_REQ_PAY_PERIOD'
|
|
4
|
|
|
5
|
Tr?ng th?i: Select th?nh c?ng
|
|
6
|
|
|
7
|
|
|
8
|
|
|
9
|
Column1
|
|
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'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')
|
|
11
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
12
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
13
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
14
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
15
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
16
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
17
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
18
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
19
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
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'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')
|
|
21
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
22
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
23
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
24
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
25
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
26
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
27
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
28
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
29
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
30
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
31
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
32
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
33
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
34
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
35
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
36
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
37
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
38
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
39
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
40
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
41
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
42
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
43
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
44
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[NEW_INDEX],[AMT_PAY],[CURRENCY],[RATE],[AUTH_STATUS_KT],[FROM_DATE],[TO_DATE],[AD_PAY_ID],[PROCESS],[PARENT_ID],[PAY_PHASE],[REASON])VALUES(N'PYOD00000200217',N'TRPY00000200128',N'TRC000001125900',N'PAY',N'Aug 19 2020 12:00AM',0,0,3343000.00,N'VND',1.00,N'U',N'Jan 1 1900 12:00AM',N'Jan 1 1900 12:00AM',N'',N'1',N'',N'',N'thanh to?n chi ph? VPP th?ng 07/2020 Ph?ng QLTD CN Long An')
|
|
45
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
46
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
47
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
48
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
49
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
50
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
51
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
52
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
53
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
54
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
55
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
56
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
57
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
58
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
59
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
60
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
61
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
62
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
63
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
64
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
65
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
66
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
67
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
68
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
69
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
70
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
71
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
72
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
73
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
74
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
75
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
76
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
77
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
78
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
79
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
80
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
81
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
82
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
83
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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 ph?ng ph?m d?nh m?c v? v?t li?u van ph?ng qu? 3/2020 Cho CN Thang Long & PGD C?u Gi?y')
|
|
84
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
85
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
86
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
87
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
88
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
89
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
90
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
91
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
92
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
93
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
94
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
95
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
96
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
97
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
98
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
99
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
100
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
101
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
102
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
103
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
104
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
105
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
106
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
107
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
108
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
109
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
110
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
111
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
112
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
113
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
114
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
115
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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'')
|
|
116
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
117
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
118
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
119
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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?')
|
|
120
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
121
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
122
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
123
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
124
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
125
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
126
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
127
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
128
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
129
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
130
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
131
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
132
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
133
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
134
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
135
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
136
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
137
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
138
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
139
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
140
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
141
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
142
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
143
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
144
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
145
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
146
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
147
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
148
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
149
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
150
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
151
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
152
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
153
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
154
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
155
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
156
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
157
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
158
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
159
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
160
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
161
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
162
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
163
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
164
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
165
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
166
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
167
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
168
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
169
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
170
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
171
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
172
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
173
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
174
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
175
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
176
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
177
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
178
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
179
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
180
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
181
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
182
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
183
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
184
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
185
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
186
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
187
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
188
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
189
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
190
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
191
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
192
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
193
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
194
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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 Ph?ng')
|
|
195
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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 Ph?ng')
|
|
196
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
197
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
198
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
199
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
200
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
201
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
202
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
203
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
204
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
205
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
206
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
207
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
208
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
209
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
210
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
211
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
212
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
213
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
214
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
215
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
216
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
217
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
218
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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 PH?ng')
|
|
219
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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 PH?ng')
|
|
220
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
221
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
222
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
223
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
224
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
225
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
226
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
227
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
228
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
229
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
230
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
231
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
232
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
233
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
234
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
235
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
236
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
237
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
238
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
239
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
240
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
241
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
242
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
243
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
244
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
245
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
246
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
247
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
248
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
249
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
250
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
251
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
252
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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`')
|
|
253
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
254
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
255
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
256
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
257
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
258
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
259
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
260
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
261
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
262
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
263
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
264
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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)')
|
|
265
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
266
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
267
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
268
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
269
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
270
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
271
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
272
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
273
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
274
|
INSERT INTO [TR_REQ_PAY_PERIOD] ([PERIOD_ID],[REQ_PAY_ID],[CONTRACT_ID],[PAY_TYPE],[PAY_DT_REAL],[OLD_INDEX],[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')
|
|
275
|
|
|
276
|
Result ErrorDesc
|
|
277
|
SUCCESSFULL
|