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

Tr?ng thái: Select thành công 

  

Column1 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000001',N'TRPY00000200022',N'TRPP00000251001',N'1',9000000.00,N'',0.00,0.00,9000000.00,N'Aug 17 2020 2:57PM',N'Jan 1 1900 12:00AM',N'1',N'cuongvd',N'Aug 17 2020 2:57PM',N'U',N'',N'PAY',N'TRPM00000251002',N'',N'',N'VND',1.00,9000000.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000005',N'TRPY00000200038',N'TRPP00000251001',N'1',9000000.00,N'',0.00,0.00,9000000.00,N'Aug 17 2020 5:03PM',N'Jan 1 1900 12:00AM',N'1',N'cuongvd',N'Aug 17 2020 5:03PM',N'U',N'',N'PAY',N'TRPM00000251002',N'',N'',N'VND',1.00,9000000.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000008',N'TRPY00000200200',N'TRCPI0001127111',N'1',149600000.00,N'',0.00,0.00,149600000.00,N'Aug 20 2020 1:38PM',N'Jan 1 1900 12:00AM',N'1',N'tuyenlt',N'Aug 20 2020 1:38PM',N'U',N'',N'PAY',N'TRCI00001127269',N'',N'',N'VND',1.00,149600000.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000011',N'TRPY00000200212',N'TRCPI0001127092',N'2',1410000000.00,N'',0.00,0.00,1410000000.00,N'Aug 20 2020 2:39PM',N'Jan 1 1900 12:00AM',N'1',N'tuyenlt',N'Aug 20 2020 2:39PM',N'U',N'',N'PAY',N'TRCI00001127261',N'',N'',N'VND',1.00,1410000000.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000014',N'TRPY00000200251',N'TRCPI0001127099',N'3',713680000.00,N'',0.00,0.00,713680000.00,N'Aug 20 2020 5:46PM',N'Jan 1 1900 12:00AM',N'1',N'tuyenlt',N'Aug 20 2020 5:46PM',N'U',N'',N'PAY',N'TRCI00001127263',N'Thanh toán d?t 3: H?p d?ng d?ch v? b?o trì ph?n c?ng và ph?n m?m các thi?t b? b?o m?t nam 2020',N'',N'VND',1.00,713680000.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000018',N'TRPY00000200254',N'TRCPI0001127072',N'1',542895400.00,N'',0.00,0.00,542895400.00,N'Aug 21 2020 8:12AM',N'Jan 1 1900 12:00AM',N'1',N'tuyenlt',N'Aug 21 2020 8:12AM',N'U',N'',N'PAY',N'TRCI00001127251',N'',N'',N'VND',1.00,542895400.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000021',N'TRPY00000200265',N'TRCP00000251074',N'1',420000000.00,N'',0.00,0.00,420000000.00,N'Aug 21 2020 10:21AM',N'Jan 1 1900 12:00AM',N'1',N'tuyenlt',N'Aug 21 2020 10:21AM',N'U',N'',N'PAY',N'TRCI00001127253',N'Thanh toán chi phí Nâng c?p h? th?ng ATM NCR - VCCS Smartcard cho ATM NCR Selfserv',N'',N'VND',1.00,420000000.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000023',N'TRPY00000200262',N'TRPP00000251003',N'1',9200000.00,N'',0.00,0.00,9200000.00,N'Aug 21 2020 1:20PM',N'Jan 1 1900 12:00AM',N'1',N'quanvta',N'Aug 21 2020 1:20PM',N'U',N'',N'PAY',N'TRPM00000251003',N'Thanh toán ti?n mua máy scan cho don v?',N'',N'VND',1.00,9200000.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000026',N'TRPY00000200288',N'TRCPI0001057430',N'1',191909520.00,N'',0.00,0.00,0.00,N'Aug 21 2020 2:00PM',N'Jan 1 1900 12:00AM',N'1',N'tanvt',N'Aug 21 2020 2:00PM',N'U',N'',N'PAY',N'TRCI00001055914',N'Thanh toán d?t 01 chi phí thi công PGD Thanh Khê',N'',N'VND',1.00,191909520.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0000000028',N'TRPY00000200297',N'TRCPI0001057385',N'2',97897360.00,N'',0.00,0.00,34187285.00,N'Aug 21 2020 3:11PM',N'Jan 1 1900 12:00AM',N'1',N'tanvt',N'Aug 21 2020 3:11PM',N'U',N'',N'PAY',N'TRCI00001055901',N'Thanh toán d?t cu?i chi phí thi?t k?, thi công PCCC và ch?ng sét CN C?n Tho',N'',N'VND',1.00,63710075.00) 
INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSCI001105566',N'TADYI0001119527',N'TRCPI0001127112',N'2',179520000.00,N'',0.00,179520000.00,0.00,N'Jun 25 2020 12:00AM',N'Aug 20 2020 11:00AM',N'0',N'tuyenlt',N'Jun 25 2020 12:00AM',N'A',N'',N'',N'TRCI00001127269',N'T?m ?ng 30% Ðon d?t hàng 16 máy in th? Datacard SD260L',N'',N'VND',1.00,179520000.00) 

Result ErrorDesc 
SUCCESSFULL