兴业联调sql
```sql
--发起借款查询
-- sendmsg OMPLURM2 5066090 -d "USR_NO=400003315560&ORD_NO=50620220622133333000353236&ORD_DT=20220622"
-- 确认办理文件
--sendmsg OMPLCHK1 5066742 -d "CHK_FIL_DT=20220626&CHK_ORG_ID=888073155233179&CHK_TYP_ID=FC001"
--分省结算文件对账
-- sendmsg OMPLCHK1 5066735 -d "CHK_FIL_DT=20220626&CHK_ORG_ID=888073155233179&CHK_TYP_ID=FC009"
--还款计划查询接口
-- sendmsg OMPLSYN1 5065636 -d "ORD_NO=50620220614130001000357719&ORD_DT=20220614"
--主动还款申请接口
select * from mpladm.mpltstag where mpl_ord_no = '50620220704200000000358753';
-- sendmsg OMPLRPY2 5066300 -d "USR_NO=400003315560&ORD_NO=50620220614130001000357719&ORD_DT=20220614&RPY_TYP=1&STG_SEQ_NO=2"
--扣款结果通知（单期）
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 = '50620220704200000000358753' and a.rpy_ord_no = b.mpl_ord_no;
-- sendmsg OMPLRPY2 5066302 -d "USR_NO=400003315560&MBL_NO=18684748230&BNK_PAY_CAP_MOD=1&BNK_STS=SUCCESS&BNK_MSG_INF=SUCCESS&BNK_MSG_CD=00000&MPL_ORD_NO=50620220614130001000358013&MPL_ORD_DT=20220614&BNK_JRN_NO=220614560023144762"
select * from mpladm.mpltrpyjrn where brw_ord_no = '50620220614130001000357719';
select * from mpladm.mpltbnkjrn;
--主动提前结清
update mpladm.mpltactorgn set act_merc_id = '888510700001536' where act_org_id = 'HCBL-FAC';
-- sendmsg OMPLRPY2 5066300 -d "USR_NO=400003315560&ORD_NO=50620220614131207000351018&ORD_DT=20220614&RPY_TYP=2"
--批量扣款文件
-- sendmsg OMPLRPY2 5066309 -d "CHK_ORG_ID=888073155233179&CHK_FIL_DT=20220310&CHK_TYP_ID=FC003"
select * from mpladm.mplthckct where chk_typ_id = 'FC003' and chk_org_id = '888073155233179';
select * from mpladm.mpltcpbatchk where chk_bat_no = '220310560023065270';
-- 220310560023065270 0 888073155233179 9 20220310 130001 50620220622133333000353236 20220622 220622012022010105ESPSFG660W 20220622 1 31.27 31.27 0 MPL00000 该期存在还款中或还款成功的订单 0.00 0.00 20220625180529 01 U 18 400003315560 20.00 2203105600230652700000
-- sendmsg OMPLRPY2 5066310 -d "CHK_BAT_NO=220310560023065270&CHK_FIL_DT=20220310&CHK_ORG_ID=888073155233179&DED_BAT_NO=2203105600230652700000"
select * from mpladm.mpltbcdt where mpl_ord_no = '50620220622133333000353236'
-- 202203100000338492 0 Y U 20220310 31.27 U 400003315560 18 888073155233179 50620220622133333000353236 20220622 U 1 3 20.00 0.00 0.00 31.27 20220625230801 31.27
-- sendmsg OMPLRPY2 5066311 -d "BAT_NO=202203100000338495&BAT_SEQ=0"
-- sendmsg OMPLRPY2 5066309 -d "CHK_FIL_DT=20220310&CHK_ORG_ID=888073155233179&CHK_TYP_ID=BN003";---对账 /home/uatftp/data/mpl/CZB/20520324/
SELECT T.CHK_FIL_STS,T.*,ROWID FROM mplthckct T where CHK_TYP_ID='FC003' ORDER BY TM_SMP DESC;---对账表 先下载清分文件，再下载批扣文件
SELECT T.*,ROWID FROM mpltcpbatchk T where CHK_BAT_NO='220310560023065270' ORDER BY TM_SMP DESC;---对账明细数据，可查询每笔记录成功、失败原因
--在216 mplbat用户发下面这条命令
-- sendmsg OMPLRPY2 5066308 -d "PROC_DT=20220310";----批扣（【重要】账单还款日、对账批次、模拟码日期需要和会计日一致）
SELECT T.*,ROWID FROM mpltbcdt T where MPL_ORD_NO='50620220622133333000353236' ORDER BY TM_SMP DESC;---根据借款订单查询bsp处理明细
--批量扣款回盘明细文件
-- sendmsg OMPLCHK1 5066733 -d "CHK_FIL_DT=20220310"
SELECT * FROM MPLTCPTCREJRN WHERE ORG_ID='888073155233179' AND JRN_DT='20220613';
--退货
-- sendmsg OMPLRPY2 5066321 -d "BOSS_JRN_NO=SIMU20220622114959&CUS_MBL_NO=18684748230&MPL_ORD_NO=50620220622133333000353385&MPL_ORD_DT=20220608&PROC_TYP=2&BOSS_REJ_TRADE_NO=REFUND20220607143825"
--分省提前清贷/退货文件导出
-- sendmsg OMPLCHK1 5066743 -d "CHK_FIL_DT=20220626&CHK_ORG_ID=888073155233179&CHK_TYP_ID=FC002"
--借款合同导出
-- sendmsg OMPLURM2 5066078 -d "CON_JRN_NO=210602550017262758&CON_TX_DT=20210602"
SELECT * FROM MPLTUPLOADCONT where mbl_no = '13974856860' AND ORG_ID='888073155233179' AND CON_TX_DT='20220609';
-- sendmsg OMPLCHK1 5066795 -d "PROV_ID=18&CHK_ORG_ID=888099200000009&CHK_FIL_DT=20210603&CHK_TYP_ID=FC008"
-----------------
```