67 lines
8.3 KiB
SQL
67 lines
8.3 KiB
SQL
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0002', 2, '12 ', '', '', '', '', '', '', '', '20130513', '20160531', '000000', '235959', 'CMBC', '中国民生银行', '2', '20130514180811 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0003', 0, '12 ', '', '', '', '0105', '中国建设银行', '', '', '20130518', '20160519', '000000', '235959', 'CCB', '中国建设银行', '2', '20140217174256 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0000', 9999, '11 ', '', '', '', '', '', '', '', '20130426', '20200401', '000000', '235959', 'EBPPP', '银联互联网收单', '2', '20130427012305 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0001', 0, '11 ', '', '', '', '0105', '中国建设银行', '', '', '20130426', '20180423', '000000', '235959', 'CCB', '中国建设银行', '2', '20130702174942 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0004', 0, '11 ', '', '', '', '0307', '深圳发展银行', '', '', '20130710', '20160711', '000000', '235959', 'PAB', '平安银行', '2', '20130711174219 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0005', 0, '11 ', '', '', '', '0410', '平安银行', '', '', '20130710', '20160711', '000000', '235959', 'PAB', '平安银行', '2', '20130711174248 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0006', 0, '12 ', '', '', '', '0307', '深圳发展银行', '', '', '20130710', '20160711', '000000', '235959', 'PAB', '平安银行', '2', '20140123034120 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0007', 0, '12 ', '', '', '', '0410', '平安银行', '', '', '20130710', '20160711', '000000', '235959', 'PAB', '平安银行', '2', '20140123034130 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0008', 0, '11 ', '', '', '', '0610', '平安银行股份有限公司', '', '', '20130711', '20160712', '000000', '235959', 'PAB', '平安银行', '2', '20130712144627 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0009', 0, '12 ', '', '', '', '0610', '平安银行股份有限公司', '', '', '20130711', '20160712', '000000', '235959', 'PAB', '平安银行', '2', '20140123034140 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0010', 0, '11 ', '', '', '', '0510', '平安银行股份有限公司', '', '', '20130716', '20160717', '000000', '235959', 'PAB', '平安银行', '2', '20130717111350 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0011', 0, '12 ', '', '', '', '0510', '平安银行股份有限公司', '', '', '20130716', '20160717', '000000', '235959', 'PAB', '平安银行', '2', '20140123034150 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0012', 0, '11 ', '', '', '', '0104', '中国银行', '', '', '20130809', '20990810', '000000', '235959', 'BOC', '中国银行', '2', '20130810100609 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0013', 0, '12 ', '', '', '', '0104', '中国银行', '', '', '20130809', '20990810', '000000', '235959', 'BOC', '中国银行', '2', '20130810100627 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0021', 0, '12 ', '', '', '', '0103', '中国农业银行', '', '', '20140125', '20160331', '000000', '235959', 'ABC', '中国农业银行', '2', '20140126142317 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0020', 0, '11 ', '', '', '', '0103', '中国农业银行', '', '', '20140108', '20160409', '000000', '235959', 'ABC', '中国农业银行', '2', '20140109010918 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0014', 0, '12 ', '', '', '', '0102', '中国工商银行', '', '', '20130912', '20990913', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140225191838 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0015', 0, '11 ', '', '', '', '0303', '中国光大银行', '', '', '20130912', '20990913', '000000', '235959', 'CEB', '光大银行', '2', '20130913154421 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0016', 0, '12 ', '', '', '', '0303', '中国光大银行', '', '', '20130912', '20990913', '000000', '235959', 'CEB', '光大银行', '2', '20130913154433 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0018', 0, '11 ', '', '', '', '0102', '中国工商银行', '', '', '20131030', '20991031', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140225191847 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0019', 0, '12 ', '', '', '', '0302', '中信银行', '', '', '20131030', '20991031', '000000', '235959', 'CITIC', '中信银行', '2', '20131031141347 ', 100);
|
|
|
|
insert into CMMTRTRULE_BATCH (RUL_NO, RUL_LVL, TRA_CD, YMCC_CD, RARD_CD, CRD_FLG, BNK_TYP, BNK_NM, ATM_LOW, ATM_UP, DAT_LOW, DAT_UP, TIM_LOW, TIM_UP, CORG_NO, CORG_NM, RUL_STS, TM_SMP, WEIGHT)
|
|
values ('0017', 0, '12 ', '', '', '', '0301', '交通银行', '', '', '20130917', '20990918', '000000', '235959', 'BCOM', '交通银行', '2', '20130918100842 ', 100);
|
|
|