273 lines
35 KiB
SQL
273 lines
35 KiB
SQL
truncate table CMMTRTRULE;
|
|
|
|
alter table CMMTEMRULE add TXN_CNL varchar(20) default 'CAP' not null ;
|
|
alter table CMMTEMRULE add TXN_CNLNA varchar(64) default '集团代收付' not null ;
|
|
alter table CMMTRTRULE add TXN_CNL varchar(20) default 'CAP' not null ;
|
|
alter table CMMTRTRULE add TXN_CNLNA varchar(64) default '集团代收付' not null ;
|
|
alter table CMMTEMRULE_BATCH add TXN_CNL varchar(20) default 'CAP' not null ;
|
|
alter table CMMTEMRULE_BATCH add TXN_CNLNA varchar(64) default '集团代收付' not null ;
|
|
alter table CMMTRTRULE_BATCH add TXN_CNL varchar(20) default 'CAP' not null ;
|
|
alter table CMMTRTRULE_BATCH add TXN_CNLNA varchar(64) default '集团代收付' not null ;
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0000','9999','11','','','','','','','','20130426','20200401','000000','235959','EBPPP','银联互联网收单','2','20130427012305',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0001','0','11','','','','0105','中国建设银行','','','20130426','20180423','000000','235959','CCB','中国建设银行','2','20140731153130',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0002','2','12','','','','','','','','20130513','20160531','000000','235959','CMBC','中国民生银行','2','20130514180811',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0003','0','12','','','','0105','中国建设银行','','','20130518','20160519','000000','235959','CCB','中国建设银行','2','20140731153139',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0004','0','11','','','','0307','深圳发展银行','','','20130710','20160711','000000','235959','PAB','平安银行','2','20140731155057',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0005','0','11','','','','0410','平安银行','','','20130710','20160711','000000','235959','PAB','平安银行','2','20130711174248',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0006','0','12','','','','0307','平安银行(借记卡)','','','20130710','20160711','000000','235959','PAB','平安银行','2','20140731155119',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0007','0','12','','','','0410','平安银行','','','20130710','20160711','000000','235959','PAB','平安银行','2','20140123034130',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0008','0','11','','','','0610','平安银行股份有限公司','','','20130711','20160712','000000','235959','PAB','平安银行','2','20130712144627',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0009','0','12','','','','0610','平安银行股份有限公司','','','20130711','20160712','000000','235959','PAB','平安银行','2','20140123034140',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0010','0','11','','','','0510','平安银行股份有限公司','','','20130716','20160717','000000','235959','PAB','平安银行','2','20130717111350',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0011','0','12','','','','0510','平安银行股份有限公司','','','20130716','20160717','000000','235959','PAB','平安银行','2','20140123034150',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0012','1','11','','','','0104','中国银行','','','20130809','20990810','000000','235959','BOC','中国银行','2','20140731155854',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0013','1','12','','','','0104','中国银行','','','20130809','20990810','000000','235959','BOC','中国银行','2','20140731155903',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0015','1','11','','','','0303','中国光大银行','','','20130912','20990913','000000','235959','CEB','光大银行','2','20140623133155',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0016','1','12','','','','0303','中国光大银行','','','20130912','20990913','000000','235959','CEB','光大银行','2','20140623133205',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0017','1','12','','','','0301','交通银行','','','20130917','20990918','000000','235959','BCOM','交通银行','2','20140616232230',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0019','1','12','','','','0302','中信银行','','','20131030','20991031','000000','235959','CITIC','中信银行','2','20140616234304',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0020','1','11','','','','0103','中国农业银行','','','20140108','20160409','000000','235959','ABC','中国农业银行','2','20140623132916',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0021','1','12','','','','0103','中国农业银行','','','20140125','20160331','000000','235959','ABC','中国农业银行','2','20140623132927',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0022','1','11','','','','0310','上海浦东发展银行','','','20140328','20170131','000000','235959','SPDB','浦发银行','2','20140623143442',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0023','1','12','','','','0310','上海浦东发展银行','','','20140328','20170130','000000','235959','SPDB','浦发银行','2','20140623143457',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0024','0','11','','','','0102','中国工商银行','','','20130718','20610419','000000','235959','ICBC','中国工商银行','2','20140702161841',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0025','0','12','','','','0102','中国工商银行','','','20131121','20510425','000000','235959','ICBC','中国工商银行','2','20140403212654',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0026','0','11','','','00','0304','华夏银行','0',100,'20140420','20160731','000000','235959','SZFS','深圳结算中心','2','20140808112832',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0027','0','12','','','','0304','华夏银行','','','20140618','20140620','000000','235959','PAB','平安银行','2','20140620094527',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0028','0','11','','','','0103','中国农业银行','','','20140622','20140731','000000','235959','SZFS','深圳结算中心','2','20140808112819',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0029','0','11','','','','0309','兴业银行','0',100,'20140730','20140731','000000','235959','SZFS','深圳结算中心','2','20140808112924',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0030','0','11','','','','0303','中国光大银行','','','20140807','20150831','000000','235959','SZFS','深圳结算中心','2','20140808113234',100,'CAP','集团代收付');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0043', 0, '11', '', '', '', '0307', '平安银行(借记卡)', '', '', '20140804', '20160831', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805131017', 100, 'trust', '信托');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0044', 0, '11', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805110754', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0045', 0, '12', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805130111', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0046', 0, '11', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805130245', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0047', 0, '12', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805130321', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0048', 0, '11', '', '', '', '0102', '中国工商银行', '', '', '20140804', '20160831', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140805130452', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0049', 0, '12', '', '', '', '0102', '中国工商银行', '', '', '20140804', '20160831', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140805130500', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0050', 0, '11', '', '', '', '0310', '上海浦东发展银行', '', '', '20140804', '20160831', '000000', '235959', 'SPDB', '浦发银行', '2', '20140805130651', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0051', 0, '12', '', '', '', '0310', '上海浦东发展银行', '', '', '20140804', '20160831', '000000', '235959', 'SPDB', '浦发银行', '2', '20140805130659', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0052', 100, '11', '', '', '', '', '', '', '', '20140804', '20160831', '000000', '235959', 'SZFS', '结算中心', '2', '20140805130836', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0053', 100, '12', '', '', '', '', '', '', '', '20140804', '20160831', '000000', '235959', 'SZFS', '结算中心', '2', '20140805130848', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0054', 0, '12', '', '', '', '0307', '平安银行(借记卡)', '', '', '20140804', '20160831', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805131113', 100, 'trust', '信托');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0055', 0, '11', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805131239', 100, 'trust', '信托');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0056', 0, '12', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805131248', 100, 'trust', '信托');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0057', 0, '11', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805131408', 100, 'trust', '信托');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0058', 0, '12', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805131419', 100, 'trust', '信托');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0059', 0, '11', '', '', '', '0307', '平安银行(借记卡)', '', '', '20130801', '20150806', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805140919', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0060', 0, '12', '', '', '', '0307', '平安银行(借记卡)', '', '', '20130801', '20150806', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805132100', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0061', 100, '11', '', '', '', '', '', '', '', '20140804', '20160831', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805132703', 100, 'trust', '信托');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0062', 100, '12', '', '', '', '', '', '', '', '20140804', '20160831', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805140656', 100, 'trust', '信托');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0063', 0, '11', '', '', '', '0102', '中国工商银行', '', '', '20140804', '20160831', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140805133421', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0064', 0, '12', '', '', '', '0102', '中国工商银行', '', '', '20140804', '20160831', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140805140445', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0065', 0, '11', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805133428', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0041', 0, '11', '', '', '', '0307', '平安银行(借记卡)', '', '', '20130601', '20160804', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805104945', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0042', 1, '12', '', '', '', '0307', '平安银行(借记卡)', '', '', '20130801', '20160804', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805130120', 100, 'haofang', '好房宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0066', 0, '12', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805133434', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0067', 0, '11', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805133440', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0068', 0, '12', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805140554', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0069', 0, '11', '', '', '', '0307', '平安银行(借记卡)', '', '', '20140804', '20160831', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805133452', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0070', 0, '12', '', '', '', '0307', '平安银行(借记卡)', '', '', '20140804', '20160831', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805133459', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0071', 100, '11', '', '', '', '', '', '', '', '20140804', '20160831', '000000', '235959', 'CMBC', '中国民生银行', '2', '20140805133505', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0072', 100, '12', '', '', '', '', '', '', '', '20140804', '20160831', '000000', '235959', 'CMBC', '中国民生银行', '2', '20140805133512', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0073', 0, '11', '', '', '', '0305', '中国民生银行', '', '', '20140804', '20160831', '000000', '235959', 'CMBC', '中国民生银行', '2', '20140805133519', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0074', 0, '12', '', '', '', '0305', '中国民生银行', '', '', '20140804', '20160831', '000000', '235959', 'CMBC', '中国民生银行', '2', '20140805133525', 100, '1qianbao', '壹钱包');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0075', 0, '11', '', '', '', '0102', '中国工商银行', '', '', '20140804', '20160831', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140805134138', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0077', 0, '11', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805134155', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0078', 0, '12', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805134203', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0079', 0, '11', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805134214', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0080', 0, '12', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805134225', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0081', 0, '11', '', '', '', '0310', '上海浦东发展银行', '', '', '20140804', '20160831', '000000', '235959', 'SPDB', '浦发银行', '2', '20140805134234', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0082', 0, '12', '', '', '', '0310', '上海浦东发展银行', '', '', '20140804', '20160831', '000000', '235959', 'SPDB', '浦发银行', '2', '20140805134244', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0083', 0, '11', '', '', '', '0301', '交通银行', '', '', '20140804', '20160831', '000000', '235959', 'BCOM', '交通银行', '2', '20140805134254', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0084', 0, '12', '', '', '', '0301', '交通银行', '', '', '20140804', '20160831', '000000', '235959', 'BCOM', '交通银行', '2', '20140805134303', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0085', 100, '11', '', '', '', '', '', '', '', '20140804', '20150804', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805140837', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0086', 100, '12', '', '', '', '', '', '', '', '20140804', '20150804', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805140847', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0076', 0, '12', '', '', '', '0102', '中国工商银行', '', '', '20140804', '20160831', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140805134147', 100, 'lufax', '陆金所');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0088', 0, '11', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805110754', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0089', 0, '12', '', '', '', '0105', '中国建设银行', '', '', '20140804', '20160831', '000000', '235959', 'CCB', '中国建设银行', '2', '20140805130111', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0090', 0, '11', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805130245', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0091', 0, '12', '', '', '', '0104', '中国银行', '', '', '20140804', '20160831', '000000', '235959', 'BOC', '中国银行', '2', '20140805130321', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0092', 0, '11', '', '', '', '0102', '中国工商银行', '', '', '20140804', '20160831', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140805130452', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0093', 0, '12', '', '', '', '0102', '中国工商银行', '', '', '20140804', '20160831', '000000', '235959', 'ICBC', '中国工商银行', '2', '20140805130500', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0094', 0, '11', '', '', '', '0310', '上海浦东发展银行', '', '', '20140804', '20160831', '000000', '235959', 'SPDB', '浦发银行', '2', '20140805130651', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0095', 0, '12', '', '', '', '0310', '上海浦东发展银行', '', '', '20140804', '20160831', '000000', '235959', 'SPDB', '浦发银行', '2', '20140805130659', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0096', 100, '11', '', '', '', '', '', '', '', '20140804', '20160831', '000000', '235959', 'SZFS', '结算中心', '2', '20140805130836', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0097', 100, '12', '', '', '', '', '', '', '', '20140804', '20160831', '000000', '235959', 'SZFS', '结算中心', '2', '20140805130848', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0098', 0, '11', '', '', '', '0307', '平安银行(借记卡)', '', '', '20130601', '20160804', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805104945', 100, 'xuqibao', '续期宝');
|
|
|
|
insert into CMMTRTRULE (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, TXN_CNL, TXN_CNLNA)
|
|
values ('0099', 1, '12', '', '', '', '0307', '平安银行(借记卡)', '', '', '20130801', '20160804', '000000', '235959', 'PAB', '中国平安银行', '2', '20140805130120', 100, 'xuqibao', '续期宝');
|
|
|
|
commit; |