综合业务系统-事后监督.doc

综合业务系统-业务流程事后监督V1.0.12004年3月上海华腾软件系统有限公司修订控制页章节编号章节名称修订内容简述修订日期修订前版本号拟稿人已评审目录1、综述52接口62.1公业务监督62.1.1.活期,定期，单位通知存款，保证金，公积金开户(8151)62.1.2所有帐户销户查询（8153）62.1.3贷款,委托贷款的开户（8152）72.1.4帐户冻结/解冻,止付/解除止付（8161）72.1.5支票挂失、解挂查询（8162）72.1.6挂失、解挂查询（8163）82.1.7取消交易查询(8165)82.1.8错帐更正查询（8166）82.1.9设置帐户限额（8167）92.1.10统一表内分户帐开户（8168）92.1.11统一表外备忘分户帐开户 （8169）92.1.12单位通知存款业务的交易明细（8171）92.1.13银行承兑汇票签发(8172)102.1.14银行承兑汇票划款(8173)102.1.15当日协定存款帐户发生业务的交易明细（8174）102.1.16当日结清计息记录(8175)102.1.17补打存折、凭证、定期存单交易明细（8176）112.1.18查询2次以上（包括2次），合计金额超过5万元（含）的现金取款(8177)112.1.19同一帐户单笔50万元（含）以上的支现业务明细（8178）112.1.20每天微机自动汇总显示前台应解汇款及临时存款发生的支现业务（8179）122.1.21非基本帐户支取现金交易明细（8180）122.1.22对114、115、135、139、141、142、162、190、262、280科目当日发生业务情况查询（8181）122.1.23 133科目、705科目非自动划转的交易明细（8182）132.1.24 260科目非自动计提利息的交易明细（8183）132.1.25 汇总显示与贷款帐户相对应的存款帐户发生业务往来的交易明细（8184）132.2储蓄业务监督152.2.1开户查询（8101）152.2.2销户查询（8102）152.2.4可查询5万元以上的取款业务明细列表152.2.5查询显示20万元以上存款业务明细列表。162.2.6冻结、解冻（8104）162.2.7挂失、解挂（8105）172.2.8更改密码（ 8106）173.业务流程181、综述事后监督就是对柜台发生的各种会计票据进行审核，监督，看其是否会计原则的一项活动。2接口2.1公业务监督2.1.1.活期,定期，单位通知存款，保证金，公积金开户(8151)select a. custno ,, c.subtype, c.savcd,c.curcd, b.avbal, c. inbrflg, c. term,c. isdate,c. tedate, c meditype,c.medisubtype,c.medino, a. tlrno from svocacc a,inmr b, svcard cwhere a.ocdate=? And a.kinbr= ?and a.actid = b.actidand c.actid = a.actidand a. octype = O O-开户 C销户and (b.accode1,3 = 201 活期，公积金or b.accode1,3 = 205定期 or b.accode1,5 = 20201 单位通知存款or b.accode1,3 = 251 保证金)order byc.subtype对非定期类帐户的到期日（tedate为39991231）查询结果中不要显示根据svcard中的subtype可以区分帐户的类型(dp_def.h)2.1.2所有帐户销户查询（8153）select a. custno ,, c.subtype, c.savcd,c.curcd, b.avbal, c. inbrflg, c. term,c. isdate,c. tedate, c. iedate，c meditype,c.medisubtype,c.medino, a. tlrno from svocacc a,inmr b, svcard cwhere a.ocdate=? And a.kinbr= ?and a.actid = b.actidand c.actid = a.actidand a. octype = C O-开户 C销户and (a.acttype 2 ora.acttype = 3)order byc.subtype2.1.3贷款,委托贷款的开户（8152）select a.txday,a.db_custno,b.actno,b.brcode,b.accode,b.curcd, ,b.cdtype,a.cr_actid a. kinbr, a. tlrnofrom xdtl a, inmr bwhere （a.txno = 5002 贷款开户or a.txno = 4405）委托贷款and a. hcode = 0and b.actid = a. db_actid贷款帐号and a.txday = ?and a.kinbr = ?order by a.txno2.1.4帐户冻结/解冻,止付/解除止付（8161）select inmr.actno, , svafrzstp.appno, svafrzstp. type，svafrzstp.status, svafrzstp.actbal, svafrzstp.sdate,svafrzstp.edate, svafrzstp.stlrno, svafrzstp.skinbrsvafrzstp.rdate ,svafrzstp.rtlrno，svafrzstp.rkinbrfrom inmr, svafrzstp whereinmr.actid = svafrzstp.actid and （svafrzstp.skinbr = ? or svafrzstp.rkinbr = ？）and （svafrzstp.sdate = ? or svafrzstp. rdate= ?）order by inmr.actno2.1.5支票挂失、解挂查询（8162）select a.chktype,a.chkno,c.actno,,a.appno, a.sdate,a.edate,a.rdate,a.status,a.stlrno,a.skinbr,a.rtlrno,a.rkinbrfrom svachkstp a, chkdtl b, inmr cwhere(a.sdate = ? or a.rdate = ?)and （a.skinbr = ? or a.rkinbr = ?）and a.chktype = b.chktypeand a.chkno = b.chknoand b.actid = c.actid2.1.6挂失、解挂查询（8163） select inmr.actno, svalosstp.appno, svalosstp.stpmode,svalosstp.stptype,svalosstp.status,svalosstp.meditype,svalosstp.medisubtype,svalosstp.medino, svalosstp.pbbal, svalosstp.stpreason,svalosstp.sdate,svalosstp.edate, svalosstp.stlrno, svalosstp.Skinbr,svalosstp.rdate, svalosstp.rtlrno,svalosstp.rkinbrfrom inmr, svalosstpwhereinmr.actid = svalosstp.actidand svalosstp.skinbr = ？and (svalosstp.sdate = ？or svalosstp.rdate = ？)order by svalosstp.stptype2.1.7取消交易查询(8165)xdtl具体可参照cm/0105交易select tlsrno ,txtime ,txno ,taskid ,db_actno ,db_txamt ,db_cardno ,db_curno ,db_meditype ,db_medisubtype ,db_medino ,db_vocno ,cr_actno ,cr_txamt ,cr_cardno ,cr_curno ,cr_meditype ,cr_medisubtype ,cr_medino ,cr_vocno ,sptlrno ,multno ,rinputflgsfrom xdtlwherehcode 1and txday ？ and kinbr ?2.1.8错帐更正查询（8166）selectb.actno,,b.brcode,b.accode,b.curcd,a.txtype, a.crdb,a.txamt,b.avbal,a.desccd,a.tlrno,a.txcdfrom inhtr a，inmr bwherea.actid = b.actida.txdate ？ and a.kinbr ?and a.txcd in( 2275 , 2276, 2277) order by a.txcd2.1.9设置帐户限额（8167）select a.txday,b.actno,b.brcode,b.accode,b.curcd, ,b.cdtype, c.minbal,a.kinbr, a.tlrnofrom xdtl a, inmr b, svcard cwhere a.txno = 2001and a. hcode = 0and b.actid = a.db_actidand c.actid = a.db_actidand a.txday = ?and a.kinbr = ?2.1.10统一表内分户帐开户（8168）select a.txday,b.actno,b.brcode,b.accode,b.curcd, ,b.cdtype, a. kinbr, a. tlrnofrom xdtl a, inmr bwhere a.txno = 7411and a. hcode = 0and(b.actid = a. Db_Actid or b.actid = a. Cr_Actid)and a. txday = ?and a.kinbr = ?2.1.11统一表外备忘分户帐开户 （8169）select a.txday,b.actno,b.brcode,b.accode,b.curcd, ,b.cdtype, a. kinbr, a. tlrnofrom xdtl a, inmr bwhere a.txno = 7461and a. hcode = 0and(b.actid = a. Db_Actid or b.actid = a. Cr_Actid)and a. txday = ?and a.kinbr = ?2.1.12单位通知存款业务的交易明细（8171）selectb.actno,,b.brcode,b.accode,b.curcd,a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrnofrom inhtr a，inmr bwherea.actid = b.actida.txdate ？ and a.kinbr ?and b.accode1,5 = 20201 2.1.13银行承兑汇票签发(8172)select a.cardno, a.sv_actid, a.pay_name, a.amount, a.sdate , a.edate, a.acpt_date, a.mort_type, a.mort_name, from bacard a, xdtl bwhere b.txno = 3032and b. txday = ? and b. kinbr= ?b.Cr_Actid = a. actidand b. Cr_Cardno = a. cardno2.1.14银行承兑汇票划款(8173)select cardno ,sur_actid, sur_amt, sv_actid, adv_actid, adv_amtfrom bacard where acpt_date = ?2.1.15当日协定存款帐户发生业务的交易明细（8174）select b.actno,,b.accode,a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrnofrom inhtr a, inmr b， svcard cwhere a.txdate = ? and a.kinbr = ?and a.actid = b.actid and c.actid = a.actidand c.acttype = 2and c.savcd = 12and c.subtype = 22.1.16当日结清计息记录(8175)select b.actno,,b.accode,a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrnofrom inhtr a, inmr bwherea. actid = b.actidand a.txdate =? And a.kinbr = ?and a.txcd in (2014,2021,2035,2037,2133,2064,2067,2057)2.1.17补打存折、凭证、定期存单交易明细（8176）select b.actno,,b.accode,a.db_custno,a. db_meditype,a. db_medisubtype,a. db_vocno from xdtl a, inmr bwhere a.kinbr = ?and a. txday = ?and a.txno = 2256 and a. hcode = 0and b.actid = a. Db_Actid 2.1.18查询2次以上（包括2次），合计金额超过5万元（含）的现金取款(8177)select a.actid, sum(a.txamt), count(*) from inhtr a, inmr bwherea.kinbr = ? and txdate = ?and b.accode1,3 = 201 and a.crdb = 1 and a.txtype = 01and a.actid = b.actidgroup by a.actidhaving sum(a.txamt) 5000000再依次查询上面帐号的明细select b.actno,,b.accode, a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrno，a.txtimefrom inhtr a, inmr bwherea.kinbr = ? and txdate = ?and a.crdb = 1 and a.txtype = 01and a.actid = b.actidand a.actid in (上一查询的结果)order a. txtime2.1.19同一帐户单笔50万元（含）以上的支现业务明细（8178）select b.actno,,b.accode, c.subtype,a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrno，a.txtimefrom inhtr a, inmr b, svcard cwhere a.kinbr = ? and txdate = ?and (b.accode1,3 = 201 or b.accode1,3 = 205or b.accode1,5 = 20201)and a.crdb = 1 and a.txtype = 01and a.actid = b.actidand a.actid = c.actidand a.txamt 50000000order a. txtime2.1.20每天微机自动汇总显示前台应解汇款及临时存款发生的支现业务（8179）select a.cardno,,a.crdb,a.txamt,a.voctype,a.vocno,a. tlrnofrom wohtr a, wocard bwherea.txdate = ? and a.kinbr = ? and a.crdb = 1 and a.txtype = 01and a.actid = b.actid and a.cardno = b.cardno 2.1.21非基本帐户支取现金交易明细（8180）select b.actno,,b.accode, c.subtype, a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrno，a.txtimefrom inhtr a, inmr b,svard cwhere a.txdate = ? and a.kinbr = ? and a.crdb = 1 and a.txtype = 01and a.actid = b.actid and a.actid = c.actidand c.misc11 1order by a.txtime2.1.22对114、115、135、139、141、142、162、190、262、280科目当日发生业务情况查询（8181）selectb.actno,,b.brcode,b.accode,b.curcd,a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrnofrom inhtr a，inmr bwherea.txdate ？ and a.kinbr ?and b.accode1,3 in (114,115,135,139,141,142,162,190,262,280)and a.actid = b.actidorder by a.actid2.1.23 133科目、705科目非自动划转的交易明细（8182）selectb.actno,,b.brcode,b.accode,b.curcd,a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrnofrom inhtr a，inmr bwherea.txdate ？ and a.kinbr ?and a.tlrno1,3 999and (b.accode1,3 = 133 or b.accode1,3 = 705)and a.actid = b.actid2.1.24 260科目非自动计提利息的交易明细（8183）selectb.actno,,b.brcode,b.accode,b.curcd,a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrnofrom inhtr a，inmr bwherea.txdate ？ and a.kinbr ?and a.tlrno1,3= 999 and a.crdb = 2and b.accode1,3 = 260 and a.actid = b.actid2.1.25 汇总显示与贷款帐户相对应的存款帐户发生业务往来的交易明细（8184）selectb.actno,,b.brcode,b.accode,b.curcd,a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrnofrom inhtr a,inmr bwherea.txdate ？ and a.kinbr ?and a.actid in (select mapactid from actmap)and a.actid = b.actid2.2储蓄业务监督2.2.1开户查询（8101）select b.actno,, b.avbal,d.savcd, d.term,c.idtype,c.idnofrom svocacc a, inmr b, custindv c, svcard dwhere a.actid = b.actid and a.custno = c.custnoand a.acttype = 1 and a.actid = d.actidand a.octype = O and a.ocdate= ? and a.kinbr = ?2.2.2销户查询（8102） select b.actno,, b.avbal,d.savcd, d.isdate,d.tedate, d.term, d.meditype, d. medisubtype, d. medino,c.idtype,c.idnofrom svocacc a, inmr b, custindv c, svcard d, where a.actid = b.actid and a.actid = d.actidand a.custno = c.custnoand a.acttype = 1and a.octype = C and a.ocdate= ? and a.kinbr = ?2.2.4可查询5万元以上的取款业务明细列表select a.actid, sum(a.txamt), count(*) from inhtr a, inmr bwherea.kinbr = ? and txdate = ?and （b.accode1,3 = 211 or b.accode1,3 = 215 ）and a.crdb = 1 and a.txtype = 01and a.actid = b.actidgroup by a.actidhaving sum(a.txamt) 5000000select b.actno,,b.accode, a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrno，a.txtimefrom inhtr a, inmr bwherea.kinbr = ? and txdate = ?and a.crdb = 1 and a.txtype = 01and a.actid = b.actidand a.actid in (上一查询的结果)order a. txtime2.2.5查询显示20万元以上存款业务明细列表。select a.actid, sum(a.txamt) from inhtr a, inmr bwherea.kinbr = ? and txdate = ?and （b.accode1,3 = 211 or b.accode1,3 = 215） and a.crdb = 2 and a.txtype = 01and a.actid = b.actidgroup by a.actidhaving sum(a.txamt) 20000000select b.actno,,b.accode, a.txcd,a.txtype, a.crdb,a.txamt, a.desccd,a.tlrno，a.txtimefrom inhtr a, inmr bwherea.kinbr = ? and txdate = ?and a.crdb = 2 and a.txtype = 01and a.actid = b.actidand a.actid in (上一查询的结果)order a. txtime2.2.6冻结、解冻（8104）select inmr.actno, , svafrzstp.appno, svafrzstp. type，svafrzstp.status, svafrzstp.actbal, svafrzstp.sdate,svafrzstp.edate, svafr