DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

EXEC dbo.sp_generate_inserts @table_name = 'TR_REQ_PAYMENT_DT', @from = 'from TR_REQ_PAYMENT_DT' 

Tr?ng th?i: Select th?nh c?ng 

Column1 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00000000001',N'TADY00001118123',N'TRPY00000200016',17500000.00,0.00,17500000.00,0.00,14688000.00,2812000.00,0.00,N'Aug 17 2020 2:00PM',N'hoangha',N'Aug 17 2020 2:00PM',N'chittn',N'Aug 19 2020 4:21PM',N'A',NULL,NULL,NULL,NULL,NULL,N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00000000005',N'TADY00001118116',N'TRPY00000200018',200000000.00,112677837.00,87322163.00,0.00,76414750.00,0.00,0.00,N'Aug 17 2020 2:39PM',N'dungltm',N'Aug 17 2020 2:39PM',N'chittn',N'Aug 19 2020 4:21PM',N'A',NULL,NULL,NULL,NULL,NULL,N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00000000007',N'TADY00001118179',N'TRPY00000200051',5000000.00,0.00,5000000.00,0.00,0.00,5000000.00,0.00,N'Aug 18 2020 11:14AM',N'minhnxq',N'Aug 18 2020 11:14AM',N'hunghd',N'Aug 19 2020 8:33AM',N'A',NULL,NULL,N'nghihm',N'Aug 19 2020 3:11PM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00000000008',N'TADY00001119227',N'TRPY00000200203',20000000.00,0.00,20000000.00,0.00,0.00,20000000.00,0.00,N'Aug 20 2020 1:38PM',N'huyenctn',N'Aug 20 2020 1:38PM',N'haipt1',N'Aug 20 2020 3:58PM',N'A',NULL,NULL,N'hainth',N'Aug 21 2020 9:06AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00000000017',N'TADY00001118142',N'TRPY00000200258',20000000.00,0.00,20000000.00,0.00,8657000.00,11343000.00,0.00,N'Aug 21 2020 9:59AM',N'loanntk',N'Aug 21 2020 9:59AM',NULL,NULL,N'U',NULL,NULL,NULL,NULL,NULL,N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00000000021',N'TADY00001118160',N'TRPY00000200274',5000000.00,0.00,5000000.00,0.00,5920000.00,0.00,920000.00,N'Aug 21 2020 1:26PM',N'quyenptt1',N'Aug 21 2020 1:26PM',NULL,NULL,N'U',NULL,NULL,NULL,NULL,NULL,N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00000000023',N'TADY00001118178',N'TRPY00000200310',9800000.00,0.00,9800000.00,0.00,9800000.00,0.00,0.00,N'Aug 21 2020 4:22PM',N'minhnxq',N'Aug 21 2020 4:22PM',NULL,NULL,N'U',NULL,NULL,NULL,NULL,NULL,N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105532',NULL,N'TRPY00001108262',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105533',NULL,N'TRPY00001108263',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105534',NULL,N'TRPY00001108264',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,N'Nov 8 2020 12:00AM',N'admin',N'Nov 8 2020 12:00AM',N'A',N'admin',N'Nov 8 2020 12:00AM',N'Nov 8 2020 12:',N'Nov 8 2020 12:00AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105535',NULL,N'TRPY00001108265',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,N'Nov 8 2020 12:00AM',N'admin',N'Nov 8 2020 12:00AM',N'A',N'admin',N'Nov 8 2020 12:00AM',N'Nov 8 2020 12:',N'Nov 8 2020 12:00AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105536',NULL,N'TRPY00001108266',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,N'Nov 8 2020 12:00AM',N'admin',N'Dec 8 2020 12:00AM',N'A',N'admin',N'Dec 8 2020 12:00AM',N'Dec 8 2020 12:',N'Dec 8 2020 12:00AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105537',NULL,N'TRPY00001108267',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105538',NULL,N'TRPY00001108268',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105539',NULL,N'TRPY00001108269',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105540',NULL,N'TRPY00001108270',0.00,0.00,0.00,0.00,NULL,0.00,0.00,NULL,NULL,NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105541',N'TADY00001118186',N'TRPY00001108271',69600000.00,0.00,69600000.00,0.00,30000000.00,0.00,0.00,NULL,N'phuctd',N'Nov 11 2019 12:00AM',N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105542',N'TADY00001118186',N'TRPY00001108272',69600000.00,30000000.00,39600000.00,0.00,30000000.00,0.00,0.00,NULL,N'phuctd',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105543',N'TADY00001118187',N'TRPY00001108273',600000000.00,0.00,600000000.00,0.00,500000000.00,0.00,0.00,NULL,N'trangldp',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105544',N'TADY00001118187',N'TRPY00001108274',600000000.00,500000000.00,100000000.00,0.00,24071860.00,0.00,0.00,NULL,NULL,N'Aug 3 2016 12:00AM',N'admin',N'Nov 3 2016 12:00AM',N'A',N'admin',N'Nov 3 2016 12:00AM',N'Nov 3 2016 12:',N'Nov 3 2016 12:00AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105545',N'TADY00001118187',N'TRPY00001108275',600000000.00,524071860.00,75928140.00,0.00,12030000.00,0.00,0.00,NULL,NULL,N'Oct 5 2016 12:00AM',N'admin',N'Nov 5 2016 12:00AM',N'A',N'admin',N'Nov 5 2016 12:00AM',N'Nov 5 2016 12:',N'Nov 5 2016 12:00AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105546',N'TADY00001118187',N'TRPY00001108276',600000000.00,536101860.00,63898140.00,0.00,180000000.00,0.00,0.00,NULL,NULL,N'Apr 4 2018 12:00AM',N'admin',N'Jun 4 2018 12:00AM',N'A',N'admin',N'Jun 4 2018 12:00AM',N'Jun 4 2018 12:',N'Jun 4 2018 12:00AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105547',N'TADY00001118188',N'TRPY00001108277',200000000.00,0.00,200000000.00,0.00,30000000.00,0.00,0.00,NULL,N'dungvn',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105548',N'TADY00001118195',N'TRPY00001108278',426575000.00,0.00,426575000.00,0.00,227317707.00,0.00,0.00,NULL,N'sonpx',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105549',N'TADY00001118113',N'TRPY00001108279',312800000.00,0.00,312800000.00,0.00,27500000.00,0.00,0.00,NULL,N'tamnh1',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105550',N'TADY00001118113',N'TRPY00001108280',312800000.00,27500000.00,285300000.00,0.00,88375000.00,0.00,0.00,NULL,N'tamnh1',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105551',N'TADY00001118113',N'TRPY00001108281',312800000.00,115875000.00,196925000.00,0.00,84750000.00,0.00,0.00,NULL,N'tamnh1',N'Feb 1 2020 12:00AM',N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105552',N'TADY00001118113',N'TRPY00001108282',312800000.00,200625000.00,112175000.00,0.00,975000.00,0.00,0.00,NULL,N'tamnh1',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105553',N'TADY00001118113',N'TRPY00001108283',312800000.00,201600000.00,111200000.00,0.00,66462000.00,0.00,0.00,NULL,N'tamnh1',N'Mar 2 2020 12:00AM',N'admin',N'Nov 2 2020 12:00AM',N'A',N'admin',N'Nov 2 2020 12:00AM',N'Nov 2 2020 12:',N'Nov 2 2020 12:00AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105554',N'TADY00001118113',N'TRPY00001108284',312800000.00,268062000.00,44738000.00,0.00,47575000.00,0.00,0.00,NULL,N'tamnh1',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105555',N'TADY00001118113',N'TRPY00001108285',312800000.00,315637000.00,-2837000.00,0.00,84300000.00,0.00,0.00,NULL,N'tamnh1',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105556',N'TADY00001118131',N'TRPY00001108286',30697169.00,0.00,30697169.00,0.00,23800000.00,0.00,0.00,NULL,N'BUI CAO TRINH',N'Dec 2 2018 12:00AM',N'admin',N'Dec 2 2018 12:00AM',N'A',N'admin',N'Dec 2 2018 12:00AM',N'Dec 2 2018 12:',N'Dec 2 2018 12:00AM',N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105557',N'TADY00001118116',N'TRPY00001108287',200000000.00,0.00,200000000.00,0.00,112677837.00,0.00,0.00,NULL,N'thanhpt',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105558',N'TADY00001118129',N'TRPY00001108288',10000000.00,0.00,10000000.00,0.00,1498000.00,0.00,0.00,NULL,N'linhttm',NULL,N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105559',N'TADY00001118129',N'TRPY00001108289',10000000.00,1498000.00,8502000.00,0.00,7000000.00,0.00,0.00,NULL,NULL,N'Dec 6 2019 12:00AM',N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105560',N'TADY00001118129',N'TRPY00001108290',10000000.00,8498000.00,1502000.00,0.00,5683602.00,0.00,0.00,NULL,NULL,N'Mar 7 2020 12:00AM',N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105561',N'TADY00001118129',N'TRPY00001108291',10000000.00,14181602.00,-4181602.00,0.00,17982391.00,0.00,0.00,NULL,NULL,N'Nov 8 2020 12:00AM',N'admin',NULL,N'A',N'admin',NULL,NULL,NULL,N'A',N'VND',1.00) 

INSERT INTO [TR_REQ_PAYMENT_DT] ([PAYDTID],[PAY_ADV_ID],[PAY_ID],[AMT_ADVANCED],[AMT_DO],[AMT_REMAIN],[AMT_PAY],[AMT_USE],[AMT_REVERT],[AMT_ADD],[TRN_DATE],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[AUTH_STATUS],[MAKER_ID_KT],[CREATE_DT_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[AUTH_STATUS_KT],[CURRENCY],[RATE])VALUES(N'PYDT00001105562',N'TADY00001118152',N'TRPY00001108292',25000000.00,0.00,25000000.00,0.00,6700000.00,0.00,0.00,NULL,N'quyenmtt',N'Feb 7 2020 12:00AM',N'admin',N'Aug 7 2020 12:00AM',N'A',N'admin',N'Aug 7 2020 12:00AM',N'Aug 7 2020 12:',N'Aug 7 2020 12:00AM',N'A',N'VND',1.00) 

Result ErrorDesc 

SUCCESSFULL