蜂云-鑫欣保理2022.05.05
```sql
/*贷款申请接口*/
sendmsg OMPLURM2 5066089 -d "USR_NO=400004144035&ORD_NO=50620220429200000000338656&ORD_DT=20220429"
sendmsg OMPLURM2 5066018 -d "USR_NO=400004144035&ORD_NO=50620220429200000000338656&ORD_DT=20220429"
--确认办理文件
sendmsg OMPLCHK1 5066742 -d "CHK_FIL_DT=20220430&CHK_ORG_ID=888099200000007&CHK_TYP_ID=BN001"
--分省结算文件对账
sendmsg OMPLCHK1 5066735 -d "CHK_FIL_DT=20220430&CHK_ORG_ID=888099200000007&CHK_TYP_ID=BN009"
--账单查询
sendmsg OMPLSYN1 5065636 -d "ORD_NO=50620220429200000000338656&ORD_DT=20220429"
--主动还单期
sendmsg OMPLRPY2 5066300 -d "USR_NO=400004144035&ORD_NO=50620220429200000000338656&ORD_DT=20220429&RPY_TYP=1&STG_SEQ_NO=1"
--扣款结果通知（单期）
select a.rpy_ord_no,a.rpy_ord_dt,b.jrn_no,a.rpy_sts,a.rpy_typ from mpladm.mpltrpyjrn a, mpladm.mpltbnkjrn b where a.brw_ord_no = '50620210330130021000221201' and a.rpy_ord_no = b.mpl_ord_no
sendmsg OMPLRPY2 5066302 -d "USR_NO=400004144035&MBL_NO=18684741155&BNK_PAY_CAP_MOD=1&BNK_STS=SUCCESS&BNK_MSG_INF=SUCCESS&BNK_MSG_CD=00000&MPL_ORD_NO=50620220429200000000338810&MPL_ORD_DT=20220429&BNK_JRN_NO=220429560022111717"
--扣款明细文件
sendmsg OMPLCHK1 5066741 -d "CHK_ORG_ID=888099200000007&CHK_FIL_DT=20220429&CHK_TYP_ID=BN000"
--批量扣款文件
sendmsg OMPLRPY2 5066309 -d "CHK_ORG_ID=888099200000007&CHK_FIL_DT=20220430&CHK_TYP_ID=BN003"
select * from mpladm.mplthckct where chk_typ_id = 'BN003' and chk_org_id = '888099200000007'
select * from mpladm.mpltcpbatchk where chk_bat_no = '220506560022129319' for update
sendmsg OMPLRPY2 5066310 -d "CHK_BAT_NO=220506560022129319&CHK_FIL_DT=20220430&CHK_ORG_ID=888099200000007&DED_BAT_NO=2205065600221293190000"
select * from mpladm.mpltbcdt WHERE ORG_ID='888099200000007' and mpl_ord_no = '50620220429200000000338656'
sendmsg OMPLRPY2 5066311 -d "BAT_NO=202204300000320620&BAT_SEQ=0"
2022.05.05---------------------------
----还款期数
SELECT * from MPLTSTAG WHERE MPL_ORD_NO='50620220429200000000338656'
----文件下载路径
SELECT * from FILTURLCFG where SYS_TYP = '1' AND SYS_CNL = 'MPL' AND FIL_TYP = '0' AND BUS_CNL = 'FAC-JSFYRECV'
SELECT * from MPLTACTSELACBL where ACT_ORG_ID = 'XXBL-FAC'
INSERT INTO MPLTACTSELACBL(ACT_ORG_ID,ACT_ORG_NM,ORG_ID,AC_TYP,ACT_MERC_ID,LAST_ACBAL,CUR_AC_BAL,UPD_CNL,UPD_DT,UPD_TM,UPD_JRN,LAST_DAY_BAL,LAST_BAL_DT,TM_SMP,LAST_DAY_BAL_3,LAST_DAY_BAL_2) VALUES(
'XXBL-FAC','鑫欣保理','888099200000007','SYS','888009955110002','964201','964201','SYS','20220505','184858','','32154561','20220505','20220505191932','32154561','32154561'
)
--/home/uatftp/data/mpl/HBOF/cmdown/
UPDATE FILTURLCFG SET SVR_URL='ftp://121.199.54.123:21',USR_NM='baoli.cm.test',USR_PWD='aDa56EO9CQ24exh1' where URL_NO='224435'
UPDATE FILTURLCFG SET OBJ_DIR='/cmdown/' where URL_NO='224435'
commit
```