You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
8 lines
1.7 KiB
SQL
8 lines
1.7 KiB
SQL
|
|
-- 카드 사용 반송 내역 정보 테스트
|
|
|
|
Insert into CARD_TRANS_DETAIL_INFO (WORKER_ID,FARE_OFFICE_ID,BOOTH_ID,YEAR,MONTH,DAY,WORK_TIMES,SEQNO,CARD_NO,JOIN_CARD_NUMBER,NOMAL_DATE,REJECT_KBN,REJECT_ID,LEVY_AMOUNT,ADJUST_YN,CREATE_DATE,CREATER,UPDATE_DATE,UPDATER,RECEIPT_YN,RECEIPT_DATE,RETURN_OFFERER,CITY_TAXES_YN,CITY_TAXES_DATE) values ('010085','01','06','2019','03','04','070134',10600002,'1019150125732586 ','3101915',to_date('19/01/22','RR/MM/DD'),'1','07',1000,'1',to_date('19/01/22','RR/MM/DD'),'test',to_date('19/01/22','RR/MM/DD'),'test','1','20190304','스마트 중복오류','1','20190122');
|
|
Insert into CARD_TRANS_DETAIL_INFO (WORKER_ID,FARE_OFFICE_ID,BOOTH_ID,YEAR,MONTH,DAY,WORK_TIMES,SEQNO,CARD_NO,JOIN_CARD_NUMBER,NOMAL_DATE,REJECT_KBN,REJECT_ID,LEVY_AMOUNT,ADJUST_YN,CREATE_DATE,CREATER,UPDATE_DATE,UPDATER,RECEIPT_YN,RECEIPT_DATE,RETURN_OFFERER,CITY_TAXES_YN,CITY_TAXES_DATE) values ('010034','01','03','2019','03','04','070843',10300024,'1019150125732586 ','3101915',to_date('19/01/22','RR/MM/DD'),'1','07',1000,'1',to_date('19/01/22','RR/MM/DD'),'test',to_date('19/01/22','RR/MM/DD'),'test','1','20190304','스마트 중복오류','1','20190122');
|
|
Insert into CARD_TRANS_DETAIL_INFO (WORKER_ID,FARE_OFFICE_ID,BOOTH_ID,YEAR,MONTH,DAY,WORK_TIMES,SEQNO,CARD_NO,JOIN_CARD_NUMBER,NOMAL_DATE,REJECT_KBN,REJECT_ID,LEVY_AMOUNT,ADJUST_YN,CREATE_DATE,CREATER,UPDATE_DATE,UPDATER,RECEIPT_YN,RECEIPT_DATE,RETURN_OFFERER,CITY_TAXES_YN,CITY_TAXES_DATE) values ('030004','03','03','2019','03','04','070022',30300001,'1019150125732586 ','3101915',to_date('19/01/22','RR/MM/DD'),'1','07',1000,'1',to_date('19/01/22','RR/MM/DD'),'test',to_date('19/01/22','RR/MM/DD'),'test','1','20190304','스마트 중복오류','1','20190122');
|
|
|