135 lines
25 KiB
SQL
135 lines
25 KiB
SQL
|
||
--渠道信息表capcnlinf
|
||
insert into capcnlinf (SYS_ID, TXN_CNL, TXN_DES, IS_ACC, IS_SIG, IS_STL, RLR_STS, TM_SMP)
|
||
values ('00001', 'HRO', '易才HRO系统', 'N', 'N', 'N', '0', '20130928000000');
|
||
|
||
--机构信息表CMMTORGN
|
||
insert into CMMTORGN (CORP_ORG, ENB_FLG, CORG_NM, CORG_TYP, BNK_TYP, LNK_FLG, IN_POS_AC, SUB_ITM_NO, STL_OPN_LBNK, LBNK_CD, STL_OPN_LBNK_NM, STL_AC_NM, STL_OAC, POS_IAC, RFD_EXC_NO, RFD_BNK_NO, RFD_BNK_NM, RFD_AC_NM, RFD_AC_NO, CORG_AD, CORG_ZIP, CTT_PSN_CNM, CTT_PSN_TEL, CTT_PSN_EMAIL, CUS_MGR, CORP_SNM, CORP_URL, TM_SMP, SIGN_FLG, CANCEL_FLG, RFD_FLG, STL_MTH, DISP_NO, WORK_KEY, OUT_TERM_ID, OUT_MERC_ID)
|
||
values ('CMB', '1', '招商银行', '0', ' ', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '20210305160128', ' ', ' ', ' ', '1', ' ', '', '', '');
|
||
insert into CMMTORGN (CORP_ORG, ENB_FLG, CORG_NM, CORG_TYP, BNK_TYP, LNK_FLG, IN_POS_AC, SUB_ITM_NO, STL_OPN_LBNK, LBNK_CD, STL_OPN_LBNK_NM, STL_AC_NM, STL_OAC, POS_IAC, RFD_EXC_NO, RFD_BNK_NO, RFD_BNK_NM, RFD_AC_NM, RFD_AC_NO, CORG_AD, CORG_ZIP, CTT_PSN_CNM, CTT_PSN_TEL, CTT_PSN_EMAIL, CUS_MGR, CORP_SNM, CORP_URL, TM_SMP, SIGN_FLG, CANCEL_FLG, RFD_FLG, STL_MTH, DISP_NO, WORK_KEY, OUT_TERM_ID, OUT_MERC_ID)
|
||
values ('ICBC', '1', '工商银行', '0', ' ', '0', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '20210108223153', ' ', ' ', ' ', '1', ' ', '', '', '');
|
||
|
||
--路由组
|
||
INSERT INTO CMMTRTRGRP (GRP_NM, GRP_DSC) VALUES ('D', '既有工行又有招行账户，所有工资发放都通过招行账户发放');
|
||
INSERT INTO CMMTRTRGRP (GRP_NM, GRP_DSC) VALUES ('A', '只有工行账户');
|
||
INSERT INTO CMMTRTRGRP (GRP_NM, GRP_DSC) VALUES ('C', '既有工行又有招行账户，工行同行，招行同行及跨行');
|
||
INSERT INTO CMMTRTRGRP (GRP_NM, GRP_DSC) VALUES ('B', '只有招行账户');
|
||
|
||
|
||
--路由信息表CMMTRTRULE_BATCH
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0018', 9999, '12 ', null, null, null, null, null, null, null, null, '99991231', '000000', '235959', 'ICBC', '工商银行', '2', '20210325191431 ', 999, 'HRO', '集团代收付', 'SUPER', 'A', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0020', 100, '12 ', null, null, null, null, null, null, '1000000.00', '20210304', '20990101', '000000', '235959', 'ICBC', '工商银行', '2', '20210325191439 ', 100, 'HRO', '集团代收付', 'SUPER', 'A', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0021', 100, '12 ', null, null, null, null, null, '1000000.00', null, '20210325', '20990101', '000000', '235959', 'ICBC', '工商银行', '2', '20210325191434 ', 100, 'HRO', '集团代收付', 'LARGE', 'A', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0024', 9999, '12 ', null, null, null, null, null, null, null, null, '99991231', '000000', '235959', 'CMB', '招商银行', '2', '20210325190143 ', 999, 'HRO', '集团代收付', 'SUPER', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0025', 100, '12 ', null, null, null, '0102', '中国工商银行', null, '1000000.00', '20210325', '20990101', '000000', '235959', 'ICBC', '工商银行', '2', '20210325190233 ', 100, 'HRO', '集团代收付', 'SMALL', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0026', 100, '12 ', null, null, null, '0102', '中国工商银行', '1000000.00', null, '20210325', '20990101', '000000', '235959', 'ICBC', '工商银行', '2', '20210325190330 ', 100, 'HRO', '集团代收付', 'LARGE', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0027', 101, '12 ', null, null, null, null, null, null, '1000000.00', '20210325', '20990101', '000000', '235959', 'CMB', '招商银行', '2', '20210325190359 ', 100, 'HRO', '集团代收付', 'SUPER', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0028', 101, '12 ', null, null, null, null, null, '1000000.00', null, '20210325', '20990101', '000000', '235959', 'CMB', '招商银行', '2', '20210325190433 ', 100, 'HRO', '集团代收付', 'LARGE', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0029', 9999, '12 ', null, null, null, null, null, null, null, null, '99991231', '000000', '235959', 'CMB', '招商银行', '2', '20210325190523 ', 999, 'HRO', '集团代收付', 'SUPER', 'D', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0030', 100, '12 ', null, null, null, null, null, null, '1000000.00', '20210325', '20990101', '000000', '235959', 'CMB', '招商银行', '2', '20210325190629 ', 100, 'HRO', '集团代收付', 'SUPER', 'D', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0031', 100, '12 ', null, null, null, null, null, '1000000.00', null, '20210325', '20990101', '000000', '235959', 'CMB', '招商银行', '2', '20210325190635 ', 100, 'HRO', '集团代收付', 'LARGE', 'D', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0022', 100, '12 ', null, null, null, null, null, null, '1000000.00', '20210325', '20990101', '000000', '235959', 'CMB', '招商银行', '2', '20210325185941 ', 100, 'HRO', '集团代收付', 'SUPER', 'B', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0019', 9999, '12 ', null, null, null, null, null, null, null, null, '99991231', '000000', '235959', 'CMB', '招商银行', '2', '20210325185838 ', 999, 'HRO', '集团代收付', 'SUPER', 'B', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0023', 100, '12 ', null, null, null, null, null, '1000000.00', null, '20210325', '20990101', '000000', '235959', 'CMB', '招商银行', '2', '20210325190017 ', 100, 'HRO', '集团代收付', 'LARGE', 'B', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0046', 50, '12 ', null, null, '04', null, null, null, '1000000.00', '20210513', '20990630', '000000', '235959', 'CMB', '招商银行', '2', '20210513170350 ', 100, 'HRO', '集团代收付', 'SMALL', 'B', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0045', 50, '12 ', null, null, '04', null, null, null, '1000000.00', '20210513', '20990630', '000000', '235959', 'ICBC', '工商银行', '2', '20210513165711 ', 100, 'HRO', '集团代收付', 'SMALL', 'A', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0047', 50, '12 ', null, null, '04', null, null, '1000000.00', null, '20210513', '20990529', '000000', '235959', 'CMB', '招商银行', '2', '20210513170233 ', 100, 'HRO', '集团代收付', 'LARGE', 'B', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0048', 50, '12 ', null, null, '04', null, null, '1000000.00', null, '20210513', '20990629', '000000', '235959', 'ICBC', '工商银行', '2', '20210513165723 ', 100, 'HRO', '集团代收付', 'LARGE', 'A', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0049', 50, '12 ', null, null, '04', null, null, null, '1000000.00', '20210513', '20990521', '000000', '235959', 'CMB', '招商银行', '2', '20210513170538 ', 100, 'HRO', '集团代收付', 'SMALL', 'D', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0052', 50, '12 ', null, null, '04', '0102', '中国工商银行', '1000000.00', null, '20210506', '20990513', '000000', '235959', 'ICBC', '工商银行', '2', '20210513174523 ', 100, 'HRO', '集团代收付', 'LARGE', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0053', 50, '12 ', null, null, '04', '0308', '招商银行', null, '1000000.00', '20210513', '20990521', '000000', '235959', 'CMB', '招商银行', '2', '20210513174519 ', 100, 'HRO', '集团代收付', 'SMALL', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0054', 50, '12 ', null, null, '04', '0308', '招商银行', '1000000.00', null, '20210513', '20990521', '000000', '235959', 'CMB', '招商银行', '2', '20210513174527 ', 100, 'HRO', '集团代收付', 'LARGE', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0051', 50, '12 ', null, null, '04', '0102', '中国工商银行', null, '1000000.00', '20210513', '20990521', '000000', '235959', 'ICBC', '工商银行', '2', '20210513174513 ', 100, 'HRO', '集团代收付', 'SMALL', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0050', 50, '12 ', null, null, '04', null, null, '1000000.00', null, '20210513', '20990521', '000000', '235959', 'CMB', '招商银行', '2', '20210513170202 ', 100, 'HRO', '集团代收付', 'LARGE', 'D', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0055', 100, '12 ', null, null, null, '2647', '中国工商银行', null, '1000000.00', '20210325', '20990101', '000000', '235959', 'ICBC', '工商银行', '2', '20210325190233 ', 100, 'HRO', '集团代收付', 'SMALL', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0056', 100, '12 ', null, null, null, '2647', '中国工商银行', '1000000.00', null, '20210325', '20990101', '000000', '235959', 'ICBC', '工商银行', '2', '20210325190330 ', 100, 'HRO', '集团代收付', 'LARGE', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0057', 50, '12 ', null, null, '04', '2647', '中国工商银行', '1000000.00', null, '20210506', '20990513', '000000', '235959', 'ICBC', '工商银行', '2', '20210513174523 ', 100, 'HRO', '集团代收付', 'LARGE', 'C', 'N');
|
||
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, TXN_CNL, TXN_CNLNA, ROUT_FLG, GRP_NM, SKIP_HLD) VALUES ('0058', 50, '12 ', null, null, '04', '2647', '中国工商银行', null, '1000000.00', '20210513', '20990521', '000000', '235959', 'ICBC', '工商银行', '2', '20210513174513 ', 100, 'HRO', '集团代收付', 'SMALL', 'C', 'N');
|
||
|
||
|
||
--事件CAPEVTRLR
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_DISK_PROC_TIMEOUT', '接入批次长时间未处理完成', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO009', 'HRO009', '1', '20210309161023');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_BATCH_PROC_TIMEOUT', '接出批次长时间未处理完成', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO010', 'HRO010', '1', '20210309161032');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_DISK_PROC_FAILURE', '接入批次处理异常', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO001', 'HRO001', '1', '20210309161041');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_DFS_DOWNLOAD_FAILURE', 'FastDFS下载失败', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO004', 'HRO004', '1', '20210309161052');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_DFS_UPLOAD_FAILURE', 'FastDFS上传失败', 'FAL', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO003', 'HRO003', '1', '20210309161103');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_BATCH_SEND_FAILURE', '接出批次送盘异常', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO005', 'HRO005', '1', '20210309161109');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_BATCH_BACK_FAILURE', '接出批次回盘异常', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO006', 'HRO006', '1', '20210309161116');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_RISK_BEEN_HIT', '客户风控命中告警', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO007', 'HRO007', '1', '20210309161124');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_BALANCE_INSUFFICIENT', '余额不足', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO008', 'HRO008', '1', '20210309161136');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('RECONCILIATION_FAILURE', '对账失败', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO011', 'HRO011', '1', '20210309161143');
|
||
insert into CAPEVTRLR (EVT_TYP, EVT_DSC, EVT_PTY, IS_SND_MERC, IS_SND_DEV, IS_SND_BUS, IS_SND_OPR, IS_SND_OTH, IS_SND_SMS, IS_SND_MAL, SMS_TPL, MAL_TPL, RLR_STS, TM_SMP)
|
||
values ('EVT_CHANNEL_COMMU_FAILURE', '机构通道通讯异常', 'NTY', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'HRO002', 'HRO002', '1', '20210309161323');
|
||
|
||
--短信模板SMSTTMPS
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO009', '0', '000', '00', '接入批次[$],长时间未处理完成，请及时处理！', 'DSK_NO|DSK_STS|', '0000000000', '0', '1', '20210309', ' ', '接入批次长时间未处理完成', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO002', '0', '000', '00', '通道通讯异常:合作机构（[$]）[$]，请及时查看！', 'CORG_NO|ERR_MSG|', '0000000000', '0', '1', '20210309', ' ', '通道通讯异常', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO003', '0', '000', '00', '批次号[$],文件ID[$],上传失败：[$],请及时查看！', 'DSK_NO|FID|ERR_MSG|', '0000000000', '0', '1', '20210309', ' ', 'FastDFS上传失败', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO010', '0', '000', '00', '接出批次长时间未处理完成：以下批次[$]长时间未处理完成，请及时处理！', 'DSK_NO|', '0000000000', '0', '1', '20210309', ' ', '接出批次长时间未处理完成', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO004', '0', '000', '00', '批次号[$],文件ID[$],下载失败：[$],请及时查看！', 'DSK_NO|FID|ERR_MSG|', '0000000000', '0', '1', '20210309', ' ', 'FastDFS下载失败', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO001', '0', '000', '00', '接入批次[$]处理异常：[$]，请及时查看！', 'DSK_NO|ERR_MSG|', '0000000000', '0', '1', '20210309', ' ', '接入批次处理异常', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO005', '0', '000', '00', '接出批次送盘异常：HRO批次号[$],接出批次号[$],[$]', 'DSK_NO|BAT_NO|ERR_MSG|', '0000000000', '0', '1', '20210309', ' ', '接出批次送盘异常', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO006', '0', '000', '00', '接出批次回盘盘异常：HRO批次号[$],接出批次号[$],[$]', 'DSK_NO|BAT_NO|ERR_MSG|', '0000000000', '0', '1', '20210309', ' ', '接出批次回盘异常', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO011', '0', '000', '00', '对账失败：对账日期[$]，失败原因[$]，请及时处理！', 'CHK_DT|ERR_MSG|', '0000000000', '0', '1', '20210309', ' ', '对账失败', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO007', '0', '000', '00', '客户风控命中告警：HRO批次号[$]，客户号[$]：[$]', 'DSK_NO|CUS_ID|ERR_MSG|', '0000000000', '0', '1', '20210309', ' ', '客户风控命中告警', 'N');
|
||
insert into SMSTTMPS (SMS_CD, SM_TYP, SMS_MO, SMS_CLS, SMS_TMP, REP_FLD, ID_KEY, PSW_FLG, EFF_FLG, UPD_DT, UPD_TLR, RMK, MAL_FLG)
|
||
values ('HRO008', '0', '000', '00', '余额不足：HRO批次号[$]，支付地[$]，账户[$],合作机构[$]余额不足', 'DSK_NO|TITLE_NAME|AC_NO|CORG_NO|', '0000000000', '0', '1', '20210309', ' ', '余额不足', 'N');
|
||
|
||
--参数信息表CAPPARAMTER
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('FIL_ZIP_PWD', '1234567', '文件加压解压密码', '0', ' ', ' ');
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('FIL_TOKEN', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0IiwiaWF0IjoxNjE0MzI5NzU2LCJleHAiOjE2MTY5MjE3NTZ9.oH9Vvy-9HMF_5Ud11Wh47lP1F3s8ZudVLpgSzMomUmnhf-l-Hch4RZUQZzHBXQUBB4A2vWhFj9KfIB_K5Eb3rQ', '文件上传/下载TOKEN', '0', '20210226170159', ' ');
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('FIL_TOKEN_NAME', 'murong', '用户名', '0', ' ', ' ');
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('FIL_TOKEN_PWD', '173f6bcd4621d3736ade75332627b1y7', '密码', '0', ' ', ' ');
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('MAIL_HOST', 'smtp.exmail.qq.com', '邮件发送host', '0', ' ', ' ');
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('MAIL_PORT', '25', '邮件发送port', '0', ' ', ' ');
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('MAIL_USER', 'sfkadmin@chinatalentgroup.com', '邮件发送用户名', '0', ' ', ' ');
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('MAIL_PWD', 'Ctg@12345', '邮件发送密码', '0', ' ', ' ');
|
||
insert into CAPPARAMTER (P_KEY, P_VALUES, P_DESC, STS, TM_SMP, RMK)
|
||
values ('FIL_TOKEN_URL', 'http://172.17.11.90', '文件上传/下载访问路径', '0', ' ', ' ');
|
||
|
||
|
||
--节假日
|
||
insert into CIMHLDTBL (YEAR, ARECOD, HLDFLG)
|
||
values ('2021', '341', 'HHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHWWWWHHHHHHHWWWHWWWWWHHHHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHHWWWWHHWWWWWHHWWWWWHWWWWWWHHHHHHWWWHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHHWWWWHHWWWWWHHWWWHWWHHWWWWWHHWWWWWHHWWWWHHWWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWWHHHWWWHWWWWWHHHHHHHHWWHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWWHHWWHWWWHHWWWWWHHWWWWWHHWWWWWHHWWWWW');
|
||
|
||
--风控规则表
|
||
insert into CUSLMTRLR (CAP_TYP, SUB_TYP, ST_TIM, ED_TIM, HOD_FLG, LMT_MAX_PL_AMT, LMT_MIN_PL_AMT, LMT_MAX_CD_AMT, LMT_MIN_CD_AMT, LMT_MAX_BAT_AMT, LMT_MIN_BAT_AMT, LMT_MAX_DAY_AMT, LMT_MIN_DAY_AMT, LMT_MAX_MTH_AMT, LMT_MIN_MTH_AMT, LMT_MAX_YAR_AMT, LMT_MIN_YAR_AMT, LMT_MAX_BAT_CNT, LMT_MAX_DAY_CNT, LMT_MAX_MTH_CNT, LMT_MAX_YAR_CNT, RLR_STS, TM_SMP, LMT_NM, LMT_DESC)
|
||
values ('CAP_PAY_BAT', null, null, null, null, '0.00', null, null, null, '0.00', null, '0.00', null, '0.00', null, '0.00', null, null, null, null, null, '0', '20210121185150', 'DEFAULT', '默认风控规则');
|
||
|
||
--公共表
|
||
INSERT INTO PUBPLTINF (SYS_ID, LOG_NO, BLOG_NO, ACC_DT, LST_ACC_DT, DAT_END, ELE_BK, TM_SMP) VALUES ('F00001', '426901', '000000000000', '20080504', '20080503', '00', '000000', '000000000000');
|
||
INSERT INTO PUBTRSTS (SYS_VER_NO, SYS_STUS, WIN_MODE, WIN_STS, WIN_SW_TM, WIN_DT1, WIN_DT2, WIN_BEG_TM, WIN_END_TM, LAST_AC_DT, LAST_AC_DT_FLG, LAST_AC_DT2, LAST_AC_DT2_FLG, CUR_AC_DT, CUR_AC_DT_FLG, NEXT_AC_DT, NEXT_AC_DT_FLG, AC_DT_SW_FLG, LAST_UPD_DT, LAST_UPD_TM, LAST_UPD_OPR, TM_SMP) VALUES ('V1.0.0', 'A', '1', 'B', '000000', '20170829', '20170830', '220000', '020000', '20170828', 'D', '20170827', 'D', '20170829', 'D', '20170830', 'D', '0', '20200714', '233000', 'T00001', '20150526235900');
|
||
|
||
commit;
|
||
|
||
|
||
|