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'',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'',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'',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'',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'',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'',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'',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'',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'',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'',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'',N'TADY00000200607',N'RQET00000200322',NULL,N'1',N'DV0001',N'D',N'359202006',N'DV0001',N'',400000000.00,N'VND',1.00,N'1',N'Nov 30 2020 3:26PM',N'TAM UNG THANH TOAN TIEN DAT COC THUE NHA HA TIEN, KIEN GIANG (THUA DAT SO 86 VA 90, KHU PHO 1, PHUONG PHAO DAI, TP. HA TIEN, TINH KIEN GIANG) THEO GDNTU NCC.2020.000346',N'tranlh',N'hainth') 
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'',N'TADY00000200607',N'RQET00000200323',NULL,N'1',N'DV0001',N'C',N'0697044000019',N'DV0001',N'',400000000.00,N'VND',1.00,N'1',N'Nov 30 2020 3:26PM',N'TAM UNG THANH TOAN TIEN DAT COC THUE NHA HA TIEN, KIEN GIANG (THUA DAT SO 86 VA 90, KHU PHO 1, PHUONG PHAO DAI, TP. HA TIEN, TINH KIEN GIANG) THEO GDNTU NCC.2020.000346',N'tranlh',N'hainth') 
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'',N'TADY00000200897',N'RQET00000200329',NULL,N'1',N'DV0001',N'C',N'0697044000019',N'DV0001',N'',8796986.00,N'VND',1.00,N'1',N'Jan 18 2021 1:59PM',N'TAM UNG THANH TOAN TIEN DIEN THANG 1/2021 CUA BVB DONG THAP THEO GDNTU NCC.2021.000042',N'thaottp3',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'069AMS2103000954',N'TRPTF0000000001',N'RQET00000200371',NULL,N'1',N'DV0001',N'D',N'359202006',N'BRN000000000427',N'',20000000.00,N'VND',1.00,N'1',N'Mar 1 2021 5:19PM',N'dieu chuyen phieu tam ung 052020/088037',N'trangnt2',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'PET000000000015',N'069AMS2103000954',N'TRPTF0000000001',N'RQET00000200372',NULL,N'1',N'DV0001',N'C',N'359202006',N'DV0001',N'',20000000.00,N'VND',1.00,N'1',N'Mar 1 2021 5:19PM',N'dieu chuyen phieu tam ung 052020/088037',N'trangnt2',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'PET000000000016',N'069AMS2103001026',N'TRPY00000210450',N'RQET00000200395',NULL,N'1',N'DV0001',N'D',N'861400001',N'BRN000000000388',N'DEP000000000080',826364.00,N'VND',1.00,N'1',N'Mar 15 2021 11:37AM',N'TT CP XANG XE, CONG TAC PHI, PHI CAU DUONG XE 51H-132.45 TU 01/03-03/03/2021, 39.006-39.339 KM - CN NAM SAI GON - GDNTT 032021/000369',N'yenmk',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'PET000000000017',N'069AMS2103001026',N'TRPY00000210450',N'RQET00000200396',NULL,N'1',N'DV0001',N'D',N'353200002',N'BRN000000000388',N'DEP000000000080',82636.00,N'VND',1.00,N'1',N'Mar 15 2021 11:37AM',N'TT CP XANG XE, CONG TAC PHI, PHI CAU DUONG XE 51H-132.45 TU 01/03-03/03/2021, 39.006-39.339 KM - CN NAM SAI GON - GDNTT 032021/000369',N'yenmk',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'PET000000000018',N'069AMS2103001026',N'TRPY00000210450',N'RQET00000200397',NULL,N'1',N'DV0001',N'D',N'862000002',N'BRN000000000388',N'DEP000000000080',200000.00,N'VND',1.00,N'1',N'Mar 15 2021 11:37AM',N'TT CP XANG XE, CONG TAC PHI, PHI CAU DUONG XE 51H-132.45 TU 01/03-03/03/2021, 39.006-39.339 KM - CN NAM SAI GON - GDNTT 032021/000369',N'yenmk',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'PET000000000019',N'069AMS2103001026',N'TRPY00000210450',N'RQET00000200398',NULL,N'1',N'DV0001',N'D',N'832000001',N'BRN000000000388',N'DEP000000000080',150000.00,N'VND',1.00,N'1',N'Mar 15 2021 11:37AM',N'TT CP XANG XE, CONG TAC PHI, PHI CAU DUONG XE 51H-132.45 TU 01/03-03/03/2021, 39.006-39.339 KM - CN NAM SAI GON - GDNTT 032021/000369',N'yenmk',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'PET000000000020',N'069AMS2103001026',N'TRPY00000210450',N'RQET00000200399',NULL,N'1',N'DV0001',N'C',N'0037041000196',N'BRN000000000388',N'',1259000.00,N'VND',1.00,N'1',N'Mar 15 2021 11:37AM',N'TT CP XANG XE, CONG TAC PHI, PHI CAU DUONG XE 51H-132.45 TU 01/03-03/03/2021, 39.006-39.339 KM - CN NAM SAI GON - GDNTT 032021/000369',N'yenmk',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'PET000000000021',N'069AMS2103001030',N'TADY00000201203',N'RQET00000200410',NULL,N'1',N'DV0001',N'D',N'0177048004569',N'BRN000000000395',N'',10000000.00,N'VND',1.00,N'1',N'Mar 16 2021 10:45AM',N'TAM UNG LE TAN KHANH TIET THANG 03.2021 CHO BAN VIET BINH DUONG THEO GDNTU NBO.2021.000132',N'thuanht',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'069AMS2103001030',N'TADY00000201203',N'RQET00000200411',NULL,N'1',N'DV0001',N'C',N'0147041006779',N'BRN000000000395',N'',10000000.00,N'VND',1.00,N'1',N'Mar 16 2021 10:45AM',N'TAM UNG LE TAN KHANH TIET THANG 03.2021 CHO BAN VIET BINH DUONG THEO GDNTU NBO.2021.000132',N'thuanht',N'huongvt') 

Result ErrorDesc 
SUCCESSFULL