蜂云-鑫欣保理2022.05.06
```sql
select * from mpladm.mpltbcdt where mpl_ord_no = '50620220429200000000338656'
sendmsg OMPLRPY2 5066311 -d "BAT_NO=202204300000320599&BAT_SEQ=0"
sendmsg OMPLRPY2 5066308 -d "PROC_DT=20220430"
SELECT T.*,ROWID FROM mpltbcdt T where MPL_ORD_NO='50620220429200000000338656' ORDER BY TM_SMP DESC---根据借款订单查询bsp处理明细
--批量扣款回盘明细文件
sendmsg OMPLCHK1 5066733 -d "CHK_FIL_DT=20220430"
--主动提前结清
-- update mpladm.mpltactorgn set act_merc_id = '888510700001536' where act_org_id = 'XXBL-FAC';
sendmsg OMPLRPY2 5066300 -d "USR_NO=400004144035&ORD_NO=50620220429200000000338656&ORD_DT=20220429&RPY_TYP=2"
--扣款结果通知（提前结清）
select * from mpladm.MPLTRPYJRN a, mpladm.mpltbnkjrn b where a.brw_ord_no = '50620220429200000000338656' and a.rpy_ord_no = b.mpl_ord_no
select * from mpltbnkjrn where jrn_no = '220507560022143834'
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=50620220507112800000339169&MPL_ORD_DT=20220507&BNK_JRN_NO=220507560022143834"
--分省提前清贷/退货文件
sendmsg OMPLCHK1 5066743 -d "CHK_FIL_DT=20220513&CHK_ORG_ID=888099200000007&CHK_TYP_ID=BN002"
select * from mpladm.mpltckct where chk_typ_id = 'BN002' and chk_org_id = '888099200000007' and chk_fil_dt = '20201023' for update
select * from mpladm.mplthckct where chk_typ_id = 'BN002' and chk_org_id = '888099200000007' and chk_fil_dt = '20201023' for update
select * from MPLTRPYCONFIG where ext_jrn_no = '205107110516423921'
select * from mpladm.mpltbustxcd where mpl_prd_typ = '008' and bus_org_id = '70488';
--借款合同导出XX-----------------xxxxxxxxxx
sendmsg OMPLURM2 5066078 -d "CON_JRN_NO=300000000448716370&CON_TX_DT=20220512"
SELECT * FROM MPLTUPLOADCONT where mbl_no = '18684748230' AND ORG_ID='888099200000007'
50620220512200000000339795
sendmsg OMPLCHK1 5066795 -d "PROV_ID=18&CHK_ORG_ID=888099200000007&CHK_FIL_DT=20220513&CHK_TYP_ID=FC008"
-------------------------------
SELECT * from MPLTSIGNORDT where mbl_no = '18684748230' AND ORG_ID='888099200000007' AND BUS_ORD_NO='50620220512200000000339795'
--退货结算文件
sendmsg OMPLCHK1 5066749 -d "PROV_ID=18&CHK_ORG_ID=888099200000007&CHK_FIL_DT=20220508&CHK_TYP_ID=BN010"
--退货
sendmsg OMPLRPY2 5066321 -d "BOSS_JRN_NO=SIMU20220512091230&CUS_MBL_NO=18684748230&MPL_ORD_NO=50620220512200000000339795&MPL_ORD_DT=20220512&PROC_TYP=2&BOSS_REJ_TRADE_NO=REFUND20220516145113"
-------------------------------xxxxxxxxx
--门店合同导出
sendmsg OMPLURM2 5066095 -d "CON_JRN_NO=205206090018158398&CON_TX_DT=20520609"
sendmsg OMPLCHK1 5066819 -d "CHK_ORG_ID=888099200000007&CHK_FIL_DT=20220513&CHK_TYP_ID=CN001"
-------------------------------
SELECT * from MPLTDEPCONT WHERE ORG_ID='888099200000007'
SELECT * FROM
MPLTDEPCONT WHERE CON_JRN_NO = '205206090018158398' AND CON_TX_DT = '20520609'
UPDATE MPLTDEPCONT SET ACT_ORG_ID='XXBL-FAC',AGR_TYP=''
SELECT *
FROM MPLTBUSPARM
WHERE PARM_NM = 'FAC_CONT_PDF_NM'
AND PARM_VAL1='888099200000007'
AND parm_val4='0'
AND PARM_VAL2='XXBL-FAC'
--门店上传
SELECT * from MPLTDEPCONT WHERE ORG_ID='888099200000007' and CON_JRN_NO='205206090018158398'
UPDATE MPLTDEPCONT set UPLOAD_STS='S' WHERE ORG_ID='888099200000007' and CON_JRN_NO='205206090018158398'
-----线下渠道还款账单同步文件----------
sendmsg OMPLCHK1 5066796 -d "CHK_FIL_DT=20220513&CHK_ORG_ID=888099200000007&CHK_TYP_ID=FC221"
```