Project

General

Profile

Download (10.9 KB)

PAY ENTRIES.txt

Luc Tran Van, 08/21/2020 06:35 PM

 
1 
??
2
3 
EXEC dbo.sp_generate_inserts @table_name = 'PAY_ENTRIES_POST', @from = 'from PAY_ENTRIES_POST'
4
5 
Tr?ng th?i: Select th?nh c?ng
6
7
8
9 
Column1
10 
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'0360000202320001',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')
11 
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',NULL,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')
12 
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',NULL,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')
13 
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',NULL,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')
14 
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',NULL,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')
15 
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'0450000202330001',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')
16 
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'0320004202330001',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')
17 
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',NULL,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')
18 
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',NULL,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')
19 
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',NULL,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')
20
21 
Result ErrorDesc
22 
SUCCESSFULL
23