210 lines
35 KiB
SQL
210 lines
35 KiB
SQL
--capadm
|
|
grant select on CAPSTLFEE to payadm;
|
|
|
|
--渠道规则设置
|
|
INSERT INTO CAPCNLINF VALUES('CAP','innergw','二代支付系统','N','N','N','1','20130928000000');
|
|
INSERT INTO CAPCNLINF VALUES('CAP','WWW','实名认证','Y','N','N','1','20130928000000');
|
|
INSERT INTO CAPCNLINF VALUES('CAP','B2B','公对公','N','N','N','1','20130928000000');
|
|
|
|
--风控事务控制表
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_ORG_TIM_FAL','机构运营时间超限','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_MERC_TIM_FAL','商户运营时间超限','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_ORG_AMT_OFW','机构金额超限','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_MERC_AMT_OFW','商户金额超限','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_ORG_BLC_SRT','机构余额不足','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_MERC_BLC_SRT','商户余额不足','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_ORG_CHK_FAL','机构对账失败','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_ORG_CHK_SUC','机构对账成功','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_BAT_SND_FAL','批量送盘失败','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_BAT_SND_SUC','批量送盘成功','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_BAT_RSP_FAL','批量回盘失败','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_BAT_RSP_SUC','批量回盘成功','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_ORG_STL_SUC','机构清算成功','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_ORG_STL_FAL','机构清算失败','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_MERC_STL_SUC','商户清算成功','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
INSERT INTO CAPEVTRLR VALUES('EVT_MERC_STL_FAL','商户清算失败','NTY','N','N','N','N','N','N','N','','','1','20130909000000');
|
|
|
|
|
|
--商户风控规则表
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080002', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080002', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080002', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080002', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080001', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080001', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080001', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080001', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500050014', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500050014', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500050014', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500050014', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080001', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080001', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080001', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080001', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('858000063000001', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('858000063000001', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('858000063000001', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('858000063000001', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500050015', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500050015', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500050015', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500050015', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080004', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080004', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080004', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080004', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080002', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080002', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080002', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080002', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080003', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080003', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080003', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800075500080003', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080005', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080005', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080005', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080005', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080003', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080003', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080003', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO URMLMTRLR VALUES ('800021000080003', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--机构风控规则表
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBR', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBR', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBR', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBR', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBP', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBP', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBP', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBP', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBBATR', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBBATR', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBBATR', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBBATR', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBBATP', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBBATP', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBBATP', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CCBBATP', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('BOC', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('BOC', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('BOC', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('BOC', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('EBPPP', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('EBPPP', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('EBPPP', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('EBPPP', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('CMBC', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CMBC', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CMBC', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CMBC', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('HXB', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('HXB', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('HXB', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('HXB', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('BCOM', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('BCOM', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('BCOM', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('BCOM', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('ICBC', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('ICBC', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('ICBC', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('ICBC', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('CITIC', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CITIC', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CITIC', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CITIC', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('CEB', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CEB', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CEB', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('CEB', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--INSERT INTO ORGLMTRLR VALUES ('PAB', 'CAP_RCV_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('PAB', 'CAP_PAY_SIG', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('PAB', 'CAP_RCV_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
--INSERT INTO ORGLMTRLR VALUES ('PAB', 'CAP_PAY_BAT', null, '000000', '235959', 'Y', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999.00', '0.00', '99999999', '99999999', '99999999', '99999999', '0', '20130928000000');
|
|
|
|
--商户电子账户表
|
|
--INSERT INTO URMACTINF VALUES('800021000080002','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080002','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080002','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080002','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800075500080001','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080001','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080001','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080001','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800075500050014','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500050014','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500050014','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500050014','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800021000080001','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080001','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080001','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080001','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('858000063000001','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('858000063000001','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('858000063000001','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('858000063000001','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800075500050015','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500050015','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500050015','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500050015','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800021000080004','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080004','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080004','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080004','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800075500080002','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080002','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080002','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080002','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800075500080003','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080003','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080003','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800075500080003','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800021000080005','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080005','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080005','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080005','CAP_PAY_BAT','','','','','','','20130928000000');
|
|
|
|
--INSERT INTO URMACTINF VALUES('800021000080003','CAP_RCV_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080003','CAP_PAY_SIG','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080003','CAP_RCV_BAT','','','','','','','20130928000000');
|
|
--INSERT INTO URMACTINF VALUES('800021000080003','CAP_PAY_BAT','','','','','','','20130928000000');
|