EXEC dbo.sp_generate_inserts @table_name = 'PAY_ENTRIES_POST', -- varchar(776) @from = 'FROM PAY_ENTRIES_POST' -- varchar(800) Trạng thái: Select thành công Column1 INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000001',N'069AMS2101000025',N'TADY00000200026',N'RQET00000200027',NULL,N'1',N'DV0001',N'D',N'359202006',N'BRN000000000407',N'',13961508.00,N'VND',1.00,N'1',N'Aug 19 2020 9:33AM',N'TAM UNG CHI PHI TIEN DIEN SINH HOAT CHO BVB CA MAU (TU NGAY 12/07/2020 DEN 11/08/2020 THEO GDNTU NCC.2020.000013',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000002',N'069AMS2101000025',N'TADY00000200026',N'RQET00000200028',NULL,N'1',N'DV0001',N'C',N'0697044000019',N'DV0001',N'',13961508.00,N'VND',1.00,N'1',N'Aug 19 2020 9:33AM',N'TAM UNG CHI PHI TIEN DIEN SINH HOAT CHO BVB CA MAU (TU NGAY 12/07/2020 DEN 11/08/2020 THEO GDNTU NCC.2020.000013',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000003',N'069AMS2101000025',N'TRPY00000200051',N'RQET00000200071',NULL,N'1',N'DV0001',N'C',N'0687041003414',N'',N'',5000000.00,N'VND',1.00,N'1',N'Aug 19 2020 3:11PM',N'HOAN TAM UNG TIEN CHI PHI TET THEO GDNTT 082020/000051',N'thaodn',N'nghihm') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000004',N'069AMS2101000025',N'TRPY00000000010',N'RQET00000200121',NULL,N'1',N'DV0001',N'C',N'0697044000019',N'DV0001',N'',454562350.00,N'VND',1.00,N'1',N'Aug 20 2020 10:03AM',N'THANH TOAN CHI PHI HOAN TRA MAT BANG SO NHA 27 PHO KIM HOAN TANG 1 VA 2 TOA NHA TTTM VA DV HONG GAI-CN QUANG NINH-GDNTT 082020/000010',N'trangnt2',N'chaudtm') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000005',N'069AMS2101000025',N'TRPY00000000010',N'RQET00000200122',NULL,N'1',N'DV0001',N'C',N'359201035',N'BRN000000000404',N'',450000000.00,N'VND',1.00,N'1',N'Aug 20 2020 10:03AM',N'THANH TOAN CHI PHI HOAN TRA MAT BANG SO NHA 27 PHO KIM HOAN TANG 1 VA 2 TOA NHA TTTM VA DV HONG GAI-CN QUANG NINH-GDNTT 082020/000010',N'trangnt2',N'chaudtm') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000006',N'069AMS2101000025',N'TRPY00000000010',N'RQET00000200123',NULL,N'1',N'DV0001',N'D',N'899000003',N'BRN000000000404',N'DEP000000000272',904562350.00,N'VND',1.00,N'1',N'Aug 20 2020 10:03AM',N'THANH TOAN CHI PHI HOAN TRA MAT BANG SO NHA 27 PHO KIM HOAN TANG 1 VA 2 TOA NHA TTTM VA DV HONG GAI-CN QUANG NINH-GDNTT 082020/000010',N'trangnt2',N'chaudtm') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000007',N'069AMS2101000025',N'TRPY00000200106',N'RQET00000200114',NULL,N'1',N'DV0001',N'C',N'0327041000003',N'BRN000000000399',N'',2861950.00,N'VND',1.00,N'1',N'Aug 20 2020 3:56PM',N'TT VE SINH XE CHI PHI XANG DAU XE FORD CONG TAC BVB AN GIANG THEO GDNTT 082020/000106',N'trangnt2',N'chaudtm') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000008',N'069AMS2101000025',N'TRPY00000200106',N'RQET00000200115',NULL,N'1',N'DV0001',N'D',N'861400001',N'BRN000000000399',N'DEP000000000212',2383591.00,N'VND',1.00,N'1',N'Aug 20 2020 3:56PM',N'TT VE SINH XE CHI PHI XANG DAU XE FORD CONG TAC BVB AN GIANG THEO GDNTT 082020/000106',N'trangnt2',N'chaudtm') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000009',N'069AMS2101000025',N'TRPY00000200106',N'RQET00000200116',NULL,N'1',N'DV0001',N'D',N'872000002',N'BRN000000000399',N'DEP000000000212',240000.00,N'VND',1.00,N'1',N'Aug 20 2020 3:56PM',N'TT VE SINH XE CHI PHI XANG DAU XE FORD CONG TAC BVB AN GIANG THEO GDNTT 082020/000106',N'trangnt2',N'chaudtm') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000010',N'069AMS2101000025',N'TRPY00000200106',N'RQET00000200117',NULL,N'1',N'DV0001',N'D',N'353200002',N'BRN000000000399',N'',238359.00,N'VND',1.00,N'1',N'Aug 20 2020 3:56PM',N'TT VE SINH XE CHI PHI XANG DAU XE FORD CONG TAC BVB AN GIANG THEO GDNTT 082020/000106',N'trangnt2',N'chaudtm') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000011',N'069AMS2101000025',N'TRPY00000203407',N'RQET00000200309',NULL,N'1',N'DV0001',N'D',N'68010000000511',N'BRN000000000393',N'',6000000.00,N'VND',1.00,N'1',N'Nov 13 2020 4:59PM',N'THANH TOAN CHI PHI XANG XE + DI LAI CONG TAC THEO GDNTT 112020/000002',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000012',N'069AMS2101000025',N'TRPY00000203407',N'RQET00000200310',NULL,N'1',N'DV0001',N'C',N'018 1000 139133',N'BRN000000000393',N'',6000000.00,N'VND',1.00,N'1',N'Nov 13 2020 4:59PM',N'THANH TOAN CHI PHI XANG XE + DI LAI CONG TAC THEO GDNTT 112020/000002',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000013',N'069AMS2101000025',N'TRPY00000203408',N'RQET00000200311',NULL,N'1',N'DV0001',N'C',N'0687041048888',N'BRN000000000389',N'',4000000.00,N'VND',1.00,N'1',N'Nov 16 2020 3:47PM',N'THANH TOAN CHI PHI RAC + NUOC UONG HANG NGAY THEO GDNTT 112020/000003',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000014',N'069AMS2101000025',N'TRPY00000203408',N'RQET00000200312',NULL,N'1',N'DV0001',N'D',N'302900001',N'BRN000000000390',N'',4000000.00,N'VND',1.00,N'1',N'Nov 16 2020 3:47PM',N'THANH TOAN CHI PHI RAC + NUOC UONG HANG NGAY THEO GDNTT 112020/000003',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000015',N'069AMS2101000025',N'TRPY00000203409',N'RQET00000200313',NULL,N'1',N'DV0001',N'C',N'0687041002667',N'BRN000000000420',N'',5500000.00,N'VND',1.00,N'1',N'Nov 16 2020 4:25PM',N'THANH TOAN TIEN RAC THANG 10 THEO GDNTT 112020/000004',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000016',N'069AMS2101000025',N'TRPY00000203409',N'RQET00000200314',NULL,N'1',N'DV0001',N'D',N'305103013',N'BRN000000000420',N'',5500000.00,N'VND',1.00,N'1',N'Nov 16 2020 4:25PM',N'THANH TOAN TIEN RAC THANG 10 THEO GDNTT 112020/000004',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000017',N'069AMS2101000025',N'TRPY00000203395',N'RQET00000200315',NULL,N'1',N'DV0001',N'C',N'0537041001513',N'BRN000000000835',N'',2250000.00,N'VND',1.00,N'1',N'Nov 16 2020 4:28PM',N'THANH TOAN CHI PHI VE SINH CO QUAN THANG 9.2020 CHO PGD GO CONG THEO GDNTT 102020/001034',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000018',N'069AMS2101000025',N'TRPY00000203395',N'RQET00000200316',NULL,N'1',N'DV0001',N'C',N'453800001',N'BRN000000000835',N'',250000.00,N'VND',1.00,N'1',N'Nov 16 2020 4:28PM',N'THANH TOAN CHI PHI VE SINH CO QUAN THANG 9.2020 CHO PGD GO CONG THEO GDNTT 102020/001034',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000019',N'069AMS2101000025',N'TRPY00000203395',N'RQET00000200317',NULL,N'1',N'DV0001',N'D',N'353200002',N'BRN000000000835',N'',2500000.00,N'VND',1.00,N'1',N'Nov 16 2020 4:28PM',N'THANH TOAN CHI PHI VE SINH CO QUAN THANG 9.2020 CHO PGD GO CONG THEO GDNTT 102020/001034',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000020',N'069AMS2101000025',N'TRPY00000202531',N'RQET00000200318',NULL,N'1',N'DV0001',N'C',N'0687041020973',N'BRN000000000819',N'',8000000.00,N'VND',1.00,N'1',N'Nov 16 2020 5:34PM',N'TT CHI PHI DIEN NUOC THANG 9/2020 THEO GDNTT 102020/000170',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000021',N'069AMS2101000025',N'TRPY00000202531',N'RQET00000200319',NULL,N'1',N'DV0001',N'D',N'811006001',N'BRN000000000819',N'',8000000.00,N'VND',1.00,N'1',N'Nov 16 2020 5:34PM',N'TT CHI PHI DIEN NUOC THANG 9/2020 THEO GDNTT 102020/000170',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000022',N'069AMS2101000025',N'TRPY00000203204',N'RQET00000200320',NULL,N'1',N'DV0001',N'C',N'0687041020973',N'BRN000000000821',N'',9000000.00,N'VND',1.00,N'1',N'Nov 17 2020 4:36PM',N'THANH TOAN CHI PHI CONG AN BAO VE CHO BVB BINH DUONG THANG 09/2020 ( TU NGAY 18/9 DEN 17/10/2020) THEO GDNTT 102020/000843',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000023',N'069AMS2101000025',N'TRPY00000203204',N'RQET00000200321',NULL,N'1',N'DV0001',N'D',N'811006001',N'BRN000000000821',N'',9000000.00,N'VND',1.00,N'1',N'Nov 17 2020 4:36PM',N'THANH TOAN CHI PHI CONG AN BAO VE CHO BVB BINH DUONG THANG 09/2020 ( TU NGAY 18/9 DEN 17/10/2020) THEO GDNTT 102020/000843',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000024',N'069AMS2101000025',N'TRPY00000203413',N'RQET00000200324',NULL,N'1',N'DV0001',N'C',N'06870440008997',N'BRN000000000821',N'',2500000.00,N'VND',1.00,N'1',N'Nov 24 2020 4:01PM',N'THANH TOAN KHAC (TIEN RAC + TIEN NUOC UONG) THEO GDNTT 112020/000008',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000025',N'069AMS2101000025',N'TRPY00000203413',N'RQET00000200325',NULL,N'1',N'DV0001',N'D',N'06870440008997',N'BRN000000000821',N'',2500000.00,N'VND',1.00,N'1',N'Nov 24 2020 4:01PM',N'THANH TOAN KHAC (TIEN RAC + TIEN NUOC UONG) THEO GDNTT 112020/000008',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000026',N'069AMS2101000025',N'TRPY00000202844',N'RQET00000200328',NULL,N'1',N'DV0001',N'C',N'0687041086482',N'BRN000000000821',N'',5000500.00,N'VND',1.00,N'1',N'Nov 24 2020 4:05PM',N'THANH TOAN TIEN VAN PHONG PHAM Q3/2020 THEO GDNTT 102020/000483',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000027',N'069AMS2101000025',N'TRPY00000202844',N'RQET00000200329',NULL,N'1',N'DV0001',N'D',N'811006002',N'BRN000000000821',N'',5000500.00,N'VND',1.00,N'1',N'Nov 24 2020 4:05PM',N'THANH TOAN TIEN VAN PHONG PHAM Q3/2020 THEO GDNTT 102020/000483',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000028',N'069AMS2101000025',N'TRPY00000202849',N'RQET00000200332',NULL,N'1',N'DV0001',N'D',N'0687041020973',N'BRN000000000821',N'',4827900.00,N'VND',1.00,N'1',N'Nov 24 2020 4:26PM',N'THANH TOAN TIEN BAO VE CO QUAN T09/2020 THEO GDNTT 102020/000488',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000029',N'069AMS2101000025',N'TRPY00000202849',N'RQET00000200333',NULL,N'1',N'DV0001',N'C',N'811006200',N'BRN000000000821',N'',4827900.00,N'VND',1.00,N'1',N'Nov 24 2020 4:26PM',N'THANH TOAN TIEN BAO VE CO QUAN T09/2020 THEO GDNTT 102020/000488',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000032',N'069AMS2101000025',N'TRPY00000203414',N'RQET00000200348',NULL,N'1',N'DV0001',N'C',N'0057041000181',N'BRN000000000420',N'',8700000.00,N'VND',1.00,N'1',N'Jan 22 2021 5:05PM',N'THANH TOAN DIEN NUOC KIEM TRA IN HACH TOAN THEO GDNTT 012021/000001',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000033',N'069AMS2101000025',N'TRPY00000203414',N'RQET00000200349',NULL,N'1',N'DV0001',N'D',N'0697048000160',N'DV0001',N'',8700000.00,N'VND',1.00,N'1',N'Jan 22 2021 5:05PM',N'THANH TOAN DIEN NUOC KIEM TRA IN HACH TOAN THEO GDNTT 012021/000001',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000051',N'069AMS2101000025',N'TRPY00000203418',N'RQET00000200390',NULL,N'1',N'DV0001',N'D',N'861100001',N'BRN000000000406',N'',10000000.00,N'VND',1.00,N'1',N'Jan 25 2021 3:54PM',N'THANH TOAN CAC CHI PHI KHAC THEO GDNTT 012021/000005',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000052',N'069AMS2101000025',N'TRPY00000203418',N'RQET00000200391',NULL,N'1',N'DV0001',N'D',N'353200002',N'BRN000000000406',N'',1000000.00,N'VND',1.00,N'1',N'Jan 25 2021 3:54PM',N'THANH TOAN CAC CHI PHI KHAC THEO GDNTT 012021/000005',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000053',N'069AMS2101000025',N'TRPY00000203418',N'RQET00000200392',NULL,N'1',N'DV0001',N'C',N'0387041000137',N'BRN000000000406',N'',11000000.00,N'VND',1.00,N'1',N'Jan 25 2021 3:54PM',N'THANH TOAN CAC CHI PHI KHAC THEO GDNTT 012021/000005',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000054',N'069AMS2101000026',N'TRPY00000203418',N'RQET00000200393',NULL,N'2',N'DV0001',N'D',N'353200001',N'DV0001',N'',3000000.00,N'VND',1.00,N'1',N'Jan 25 2021 3:54PM',N'THANH TOAN CAC CHI PHI KHAC THEO GDNTT 012021/000005',N'binhlv',N'huongvt') INSERT INTO [PAY_ENTRIES_POST] ([ET_ID],[REF_NO],[TRN_ID],[REF_ID],[TRN_TYPE],[ENTRY_PAIR],[DO_BRN],[DRCR],[ACCT],[BRN_ID],[DEPT_ID],[AMT],[CURRENCY],[EXC_RATE],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID])VALUES(N'PET000000000055',N'069AMS2101000026',N'TRPY00000203418',N'RQET00000200394',NULL,N'2',N'DV0001',N'C',N'0387041000137',N'DV0001',N'',3000000.00,N'VND',1.00,N'1',N'Jan 25 2021 3:54PM',N'THANH TOAN CAC CHI PHI KHAC THEO GDNTT 012021/000005',N'binhlv',N'huongvt') Result ErrorDesc SUCCESSFULL