Project

General

Profile

Download (13.7 KB)

PAY SCHEDULE.txt

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

 
1 
??
2
3 
EXEC dbo.sp_generate_inserts @table_name = 'TR_REQ_PAYMENT_DT', @from = 'from TR_REQ_PAYMENT_DT'
4
5 
Tr?ng th?i: Select th?nh c?ng
6
7
8
9 
Column1
10 
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)
11 
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)
12 
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)
13 
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)
14 
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 ?t 3: H?p ?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 nm 2020',N'',N'VND',1.00,713680000.00)
15 
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)
16 
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)
17 
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 ?n v?',N'',N'VND',1.00,9200000.00)
18 
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 ?t 01 chi ph? thi c?ng PGD Thanh Kh?',N'',N'VND',1.00,191909520.00)
19 
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 ?t cu?i chi ph? thi?t k?, thi c?ng PCCC v? ch?ng s?t CN C?n Th?',N'',N'VND',1.00,63710075.00)
20 
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% ?n ?t h?ng 16 m?y in th? Datacard SD260L',N'',N'VND',1.00,179520000.00)
21
22 
Result ErrorDesc
23 
SUCCESSFULL
24