财税库银平台系统设计开发-详细设计

财税库银平台替换

详细设计说明书

2013年7月13日

文档修改记录表

文件版本修订日期/修订人审核日期/审核人批准日期/批准人修订说明

V1.0-创建

目录

1引言......................................................................................13

1.1文档用途.........................................................................13

1.2阅读对象.........................................................................13

1.3术语和缩略语....................................................................13

1.4参考资料.........................................................................13

2概述......................................................................................13

2.1系统概述.........................................................................13

2.2系统功能说明.....................................................................13

2.2.1TIPS-状态变更通知(688100)...................................................13

2.2.2TIPS-公共数据更新通知(688110)..............................................14

2.2.3TIPS-故障通知(688120).......................................................14

2.2.4TIPS-强制退出通知(688130)...................................................14

2.2.5TIPS-停运起运通知(688140)...................................................14

2.2.6TIPS-接收自由格式报文(9105)(688150)........................................14

2.2.7TIPS-系统运行参数通知(9106)(688160).........................................14

2.2.8TIPS-交易状态查询(9003)(688170)............................................14

2.2.9TIPS-TIPS发起连接测试(9005)(688180)........................................14

2.2.10TIPS-登录请求(9006)(688210)............................................15

2.2.11TIPS-退出请求(9008)(688220).............................................15

2.2.12TIPS-连接测试(9005)我方发起(688230)....................................15

2.2.13TIPS-自由格式报文(9105)我方发起(688240)...............................15

2.2.14TIPS-三方协议录入验证撤销(688290)......................................15

2.2.13TIPS-三方协议手工删除(688300)...........................................15

2.2.16TIPS-实时扣税(3001)(688310).............................................15

2.2.17TIPS-实时冲正(1021)(688320).............................................15

2.2.18TIPS-申报缴税(2090)(688380)............................................15

2.2.19TIPS-申报查询(2091)(688390).............................................16

2.2.20TIPS-批量扣税(3102)(688410)............................................16

2.2.21TIPS-批量止付(1123)(688420)............................................16

2.2.22TIPS-日间日切对账(688430)..............................................16

2.2.23TIPS-通用确认或处理结果(6884A0).........................................16

2.2.24TIPS-三方协议查询打印(688690)..........................................16

2.2.25TIPS-征收机关代码查询(6886P0)..........................................16

2.2.26TIPS-银行代码查询(6886Q0)...............................................16

2.2.27TIPS-节点代码查询(6886R0)...............................................16

2.2.28TIPS-国库代码查询(6886S0)...............................................17

2.2.29TIPS-预算科目查询(6886T0)...............................................17

2.2.30TIPS-税种代码查询(6886U0)...............................................17

2.2.31TIPS-税目代码查询(6886V0)..............................................17

2.2.32TIPS-收入电子缴税凭证打印(688710)......................................17

2.2.33TIPS-收入扣税明细查询打印(688720).......................................17

2.2.34TIPS-收入对账税票明细查询打印(688730).................................17

2.2.35TIPS-收入对账批次查询打印(688740).......................................17

2.2.36TIPS-字段查询征收机关(688810)..........................................17

2.2.37TIPS-字段查询三方协议(688820)..........................................18

2.2.38TIPS-换卡查询签约状态(688830)..........................................18

2.2.39TIPS-销卡查询签约状态(688840)...........................................18

2.2.40TIPS-通知换卡(688850)..................................................18

2.2.41前置交易运行监控(688900)................................................18

2.2.42前置交易对账监控(688910)...............................................18

2.2.43TIPS-收入包明细重发(9111)(688250)......................................18

2.2.44TIPS-收入对账包重发(9112)(688260).....................................18

3数据模型设计.............................................................................19

3.1表汇总..........................................................................19

3.2表结构..........................................................................19

3.2.1buTipsBatchPack横联批量包信息表(流水表).................................20

3.2.2buTipsBatchTax横联批量税票信息表(流水表)................................21

3.2.3buTipsBgetSubCode横联预算科目代码表........................................22

3.2.4buTipsBnkCode横联银行代码表.............................................22

3.2.5buTipsChecklnfo横联对账批次信息表........................................23

3.2.PbuTipsChkTax横联对账税票信息表.............................................24

3.2.7buTipsColOrgan横联征收机关代码表..........................................25

3.2.8buTipsCorrectReasn横联更正原因代码表......................................26

3.2.9buTipsCustHistory横联三方协议历史表.......................................26

3.2.ICbuTipsCustRelap横联三方协议表.........................................27

3.2.11buTipsDetail横联扣税明细流水表(流水表)..............................28

3.2.12buTipsFreeFormat横联自由格式报文登记薄................................32

3.2.13buTipsNodelnf横联节点代码表............................................32

3.2.14buTipsRefundReason横联退库原因表......................................33

3.2.15buTipsRunDate横联运行日期表............................................34

3.2.IfbuTipsRushApply横联冲正信息表.........................................34

3.2.17buTipsStatus横联系统状态表.............................................35

3.2.18buTipsStopInfo横联止付信息信息表......................................35

3.2.ISbuTipsSysParam横联运行参数通知表......................................36

3.2.2CbuTipsTaxSubData横联税目数据表........................................36

3.2.21buTipsTaxSublnf横联税目代码表.........................................37

3.2.22buTipsTaxType横联对帐税种明细表........................................37

3.2.23buTipsTaxTypeData横联税种数据表.......................................38

3.2.24buTipsTaxTypelnf横联税种代码表........................................39

3.2.25buTipsTreCode横联国库代码表............................................39

3.2.2fbuTipsStllnst横联机构清算表...........................................40

3.2.27buTipsStlAcc横联清算账号表.............................................40

3.2.28buTipsAcsAgent横联节点通讯代理表......................................41

3.2.2sbuTipsBanklnfo横联银行信息表..........................................42

4功能说明.................................................................................42

4.1TlPS-状态变更通知688100........................................................42

4.1.1需求说明.....................................................................42

4.1.2设计思路....................................................................42

4.1.3业务流程....................................................................42

4.1.4前台处理....................................................................43

4.1.5后台处理....................................................................43

4.1.6相关子交易设计..............................................................43

4.I.7相关API设计................................................................43

4.2TIPS-公共数据更新通知(688110)...................................................43

4.2.1需求说明.....................................................................44

4.2.2设计思路....................................................................44

4.2.3业务流程....................................................................44

4.2.4前台处理....................................................................44

4.2.5后台处理....................................................................44

4.2.P相关子交易设计..............................................................44

4.2.7相关API设计................................................................45

4.3TIPS-故障通知(688120)........................................................45

4.3.1需求说明.....................................................................45

4.3.2设计思路....................................................................45

4.3.3业务流程....................................................................45

4.3.4前台处理....................................................................45

4.3.5后台处理....................................................................46

4.3.6相关子交易设计..............................................................46

4.3.7相关API设计................................................................46

4.4TlPS-强制退出通知(688130)......................................................46

4.4.1需求说明.....................................................................46

4.4.2设计思路....................................................................46

4.4.3业务流程....................................................................46

4.4.4前台处理....................................................................47

4.4.5后台处理....................................................................47

4.4.f相关子交易设计..............................................................47

4.4.7相关API设计................................................................47

4.5TlPS-停运起运通知(688140).......................................................47

4.5.1需求说明.....................................................................48

4.5.2设计思路....................................................................48

4.5.3业务流程....................................................................48

4.5.4前台处理....................................................................48

4.5.5后台处理....................................................................48

4.5.6相关子交易设计..............................................................48

4.5.7相关API设计................................................................49

4.6TIPS-接收自由格式报文(9105)(688150)..........................................49

4.6.1需求说明.....................................................................49

4.6.2设计思路....................................................................49

4.6.3业务流程....................................................................49

4.6.4前台处理.....................................................................50

4.6.5后台处理....................................................................50

4.6.6相关子交易设计..............................................................50

4.6.7相关API设计................................................................50

4.7TIPS-系统运行参数通知(9106)(688160)......................................................................................50

4.7.1需求说明....................................................................51

4.7.2设计思路....................................................................51

4.7.3业务流程....................................................................51

4.7.4前台处理....................................................................51

4.7.5后台处理....................................................................51

4.7.6相关子交易设计..............................................................51

4.7.7相关API设计................................................................52

4.8TIPS-交易状态查询(9003)(688170).....................................................................................................52

4.8.1需求说明....................................................................52

4.8.2设计思路....................................................................52

4.8.3业务流程....................................................................53

4.8.4前台处理....................................................................53

4.8.5后台处理....................................................................53

4.8.6相关子交易设计..............................................................53

4.8.7相关API设计................................................................54

4.9TIPS-TIPS发起连接测试(9005)(688180)..........................................................................................54

4.9.1需求说明....................................................................54

4.9.2设计思路....................................................................54

4.9.3业务流程....................................................................54

4.9.4前台处理....................................................................55

4.9.5后台处理....................................................................55

4.9.6相关子交易设计..............................................................55

4.9.7相关API设计................................................................56

4.10TlPS-登录请求(9006)(688210).............................................................................................................56

4.10.1需求说明................................................................56

4.10.2设计思路................................................................56

4.10.3业务流程................................................................56

4.10.4前台处理................................................................57

4.10.5后台处理................................................................57

4.10.6相关子交易设计..........................................................57

4.10.7相关API设计............................................................58

4.11TlPS-退出请求(9008)(688220).............................................................................................................58

4.11.1需求说明................................................................58

4.11.2设计思路................................................................58

4.11.3业务流程................................................................58

4.11.4前台处理................................................................59

4.11.3后台处理................................................................59

4.11.6相关子交易设计..........................................................59

4.11.7相关API设计............................................................60

4.12TlPS-连接测试(9005)我方发起(688230).............................................................................................60

4.12.1需求说明................................................................60

4.12.2设计思路................................................................60

4.12.3业务流程................................................................60

4.12.4前台处理................................................................61

4.12.5后台处理................................................................61

4.12.P相关子交易设计..........................................................61

4.12.7相关API设计............................................................62

4.13TIPS-自由格式报文(9105)我方发起(688240)..................................................................................62

4.13.1需求说明................................................................62

4.13.2设计思路................................................................62

4.13.3业务流程................................................................62

4.13.4前台处理................................................................63

4.13.5后台处理................................................................63

4.13.6相关子交易设计..........................................................63

4.13.7相关API设计............................................................64

4.14TIPS-三方协议录入验证撤销(688290)..............................................................................................64

4.14.1需求说明................................................................64

4.14.2设计思路................................................................64

4.14.3业务流程................................................................65

4.14.4前台处理................................................................66

4.14.5后台处理................................................................66

4.14.P相关子交易设计..........................................................66

4.14.7相关API设计............................................................68

4.15TIPS-三方协议手工删除(688300)........................................................................................................68

4.15.1需求说明................................................................68

4.15.2设计思路................................................................68

4.15.3业务流程................................................................69

4.15.4前台处理................................................................69

4.15.5后台处理................................................................69

4.15.6相关子交易设计..........................................................69

4.15.7相关API设计............................................................70

4.16TIPS-实时扣税(3001)(688310).............................................................................................................70

4.16.1需求说明................................................................70

4.16.2设计思路................................................................70

4.16.3业务流程................................................................71

4.16.4前台处理................................................................71

4.16.5后台处理................................................................71

4.16.f相关子交易设计..........................................................71

4.16.7相关API设计............................................................73

4.17TIPS-实时冲正(1021)(688320)............................................................................................................73

4.17.1需求说明................................................................73

4.17.2设计思路................................................................73

4.17.3业务流程................................................................73

4.17.4前台处理................................................................74

4.17.5后台处理................................................................74

4.17.6相关子交易设计..........................................................74

4.17.7相关API设计............................................................75

4.18TIPS-申报缴税(2090)(688380)......................................................75

4.18.1需求说明................................................................75

4.18.2设计思路................................................................76

4.18.3业务流程................................................................76

4.18.4前台处理................................................................77

4.18.5后台处理................................................................77

4.18.5相关子交易设计..........................................................77

4.18.7相关API设计............................................................78

4.19TIPS-申报查询(2091)(688390)......................................................79

4.19.1需求说明................................................................79

4.19.2设计思路................................................................79

4.19.3业务流程................................................................79

4.19.4前台处理................................................................79

4.19.5后台处理................................................................80

4.19.6相关子交易设计..........................................................80

4.19.7相关API设计............................................................81

4.20TIPS一批量扣税(3102)(688410)..................................................81

4.20.1需求说明................................................................81

4.20.2设计思路................................................................81

4.20.3业务流程................................................................81

4.20.4前台处理................................................................82

4.20.5后台处理................................................................82

4.20.€相关子交易设计..........................................................82

4.20.7相关API设计............................................................83

4.21TIPS-批量止付(1123)(688420)...................................................83

4.21.1需求说明................................................................83

4.21.2设计思路................................................................83

4.21.3业务流程................................................................84

4.21.4前台处理................................................................84

4.21.5后台处理................................................................84

4.21.6相关子交易设计..........................................................84

4.21.7相关API设计............................................................85

4.22TlPS-日间日切对账(688430).......................................................85

4.22.1需求说明................................................................85

4.22.2设计思路................................................................86

4.22.3业务流程................................................................86

4.22.4前台处理................................................................86

4.22.3后台处理................................................................87

4.22.€相关子交易设计..........................................................87

4.22.7相关API设计............................................................88

4.23TIPS-通用确认或处理结果(6884A0).................................................88

4.23.1需求说明................................................................88

4.23.2设计思路................................................................88

4.23.3业务流程................................................................88

4.23.4前台处理................................................................89

4.23.5后台处理................................................................89

4.23.P相关子交易设计..........................................................89

4.23.7相关API设计............................................................89

4.24TIPS-三方协议查询打印(688690).......................................................................................................89

4.24.1需求说明................................................................89

4.24.2设计思路................................................................90

4.24.3业务流程.