非税系统数据库字典省厅湘邮系统oracle.docx

1、非税系统数据库字典省厅湘邮系统oracle数据库表结构说明文档目 录DEPARTMENT 8FSDWSERVERLOG 8PJ_DWPZB 8TAB_DB_ERROR_INFO 9T_BB_ACCOUNT 9T_BB_ACCOUNT_TEMP 10T_BB_BBDY 11T_BB_BBWH 11T_BB_DWXMTEMP 11T_BB_JKSTEMP 12T_BB_MODE 12T_BB_SJCZ 13T_BB_SJY 13T_BB_UPLOADWH 13T_BB_XMXX 13T_BB_YSWC 14T_BB_YSWC_TEMP 14T_CZ_DWWG 15T_CZ_DWWLJS 15T_C

2、Z_FMKC 15T_CZ_FMSQ 17T_CZ_FMTZ 17T_CZ_HJMSQ 18T_CZ_JCBZWD 19T_CZ_JMJKS 19T_CZ_SHTT 20T_CZ_SRTZSQ 20T_CZ_TCB 22T_CZ_TCKJ 23T_CZ_TFS 24T_CZ_TFSQ 24T_CZ_TFS_WPQ 26T_CZ_WGLX 27T_CZ_YSB 27T_CZ_YSCSB 28T_CZ_YSCZB 28T_CZ_YSCZB_TEMP 28T_CZ_YSSQ 29T_CZ_YSSQSH 30T_CZ_YSTZSQ 31T_CZ_YSYWB 32T_CZ_YSYWB_TEMP 33T_

3、CZ_YSZFSMX 33T_CZ_YSZFSQR 34T_CZ_ZKFMCLFS 35T_CZ_ZKKC 35T_DPT_CSLOG 36T_DPT_INTERFACE_CS 36T_DPT_INTERFACE_TEMP 36T_DPT_INTERFACE_YSBMDZ 37T_DPT_INTERFACE_YSDW 37T_DPT_INTERFACE_YSFSDWGJ 38T_DPT_INTERFACE_YWWH 38T_ERROR_INFO 38T_GG_CKXXWH 38T_GG_CLFSWH 39T_GG_CS 39T_GG_CSZH 39T_GG_CZWH 40T_GG_DLYHWH

4、 40T_GG_DTDWGJ 41T_GG_DTWH 41T_GG_DWPJGJ 42T_GG_DWPOS 43T_GG_DWPOS_TEMP 43T_GG_DWS 43T_GG_DWS_TY 44T_GG_DWXMGJ 45T_GG_FKRYHWH 46T_GG_GGB 46T_GG_JCWDWH 46T_GG_PJTB 47T_GG_PJWH 48T_GG_PJZL 49T_GG_PMGSWH 49T_GG_QTWJWH 50T_GG_SGFCJZ 50T_GG_SRLB 50T_GG_TCZL 51T_GG_TFLXWH 51T_GG_WJFL 52T_GG_WZFLWH 52T_GG_

5、XMBM 52T_GG_XMS 52T_GG_XMS_TY 53T_GG_XMWJWH 54T_GG_XMXX 55T_GG_XMXX_ST 56T_GG_XMXX_SX 57T_GG_XMXX_TEMP 59T_GG_YSBM 60T_GG_YSBMDZ 60T_GG_YSCWH 60T_GG_YSDWGJ 61T_GG_ZGBM 61T_GG_ZGWH 61T_GG_ZGYSGJ 61T_GG_ZSDW 62T_GG_ZSDWLXR 63T_INTERFACE_GKTF 63T_INTERFACE_KJWH 64T_INTERFACE_YSDW 65T_INTERFACE_YSFSDWGJ

6、 65T_PJ_CZKC 65T_PJ_CZKC_SJ 66T_PJ_CZKC_TEMP 66T_PJ_GLTJ 67T_PJ_GLZDY 67T_PJ_HXSQ 67T_PJ_JKSHX 68T_PJ_JKSNJ 69T_PJ_JKSNJHZ 69T_PJ_JTCZKC 70T_PJ_JTCZKC_ERR 70T_PJ_JTCZKC_TEMP 71T_PJ_JTDWKC 71T_PJ_JTDWKC_ERR 72T_PJ_JTDWKC_TEMP 72T_PJ_JZHJXX 73T_PJ_NJDR 74T_PJ_NJZT 74T_PJ_PJCS 74T_PJ_PJGLXX 75T_PJ_PJHM

7、WH 75T_PJ_PJKPXX 75T_PJ_PJXH 77T_PJ_PZB 77T_PJ_PZB_SZ 78T_PJ_PZCXB 79T_PJ_SYHM 80T_PJ_TJ_FF 80T_PJ_TJ_JC 81T_PJ_TJ_PJJC 81T_PJ_TJ_PJKC 82T_PJ_TJ_RK 82T_PJ_WPQ_HX 83T_PJ_WPQ_JZ 83T_PJ_XJCZKC 84T_PJ_XJYPJH 84T_PJ_XJYPSQ 85T_PJ_YZJH 85T_PJ_ZYPJHX 86T_PJ_ZYPJKC 87T_PRO_LOG 88T_SRHS_101 88T_SRHS_BJFSSR 8

8、8T_SRHS_BJLBREPORT 89T_SRHS_BJXTREPORT 90T_SRHS_BKPZTI 90T_SRHS_BKPZTO 90T_SRHS_BL 91T_SRHS_CZJKS 92T_SRHS_CZSCJKS 93T_SRHS_CZSCMX 94T_SRHS_CZTHDC 94T_SRHS_CZTHJKS 95T_SRHS_CZTHTF 96T_SRHS_DCSR 96T_SRHS_DCSRCM 98T_SRHS_DCSRCM_MOD 100T_SRHS_DCSRCM_TEMP 102T_SRHS_DFCSR 104T_SRHS_DKPJF 104T_SRHS_DWDZ 1

9、05T_SRHS_DWXMYE 106T_SRHS_FCCZMX 106T_SRHS_FCDY 107T_SRHS_FCHJWH 107T_SRHS_FCMX 108T_SRHS_FCSRMX 108T_SRHS_HJSJWH 109T_SRHS_HSXTCS 110T_SRHS_JKS 110T_SRHS_JKS_SEND 111T_SRHS_JKS_TMP 113T_SRHS_JSLX 115T_SRHS_JTMX 115T_SRHS_KJSXKM 116T_SRHS_KMDM 117T_SRHS_KMYE 117T_SRHS_PJLS 117T_SRHS_PJLS_CR 119T_SRH

10、S_PJLS_DK 120T_SRHS_PJLS_NOHX 121T_SRHS_PK 122T_SRHS_PKJYMX 122T_SRHS_PZTI 122T_SRHS_PZTO 123T_SRHS_QJWH 124T_SRHS_REPORT 124T_SRHS_REPORTHELP 125T_SRHS_SGLS 127T_SRHS_SJFHSR 127T_SRHS_SRLBREPORT 128T_SRHS_TCKJ 129T_SRHS_TCTJZJ 129T_SRHS_TEMP 130T_SRHS_TEMP_DWXM 131T_SRHS_WLK 131T_SRHS_WLK_TMP 133T_

11、SRHS_WYJYMX 134T_SRHS_WYMXGJ 134T_SRHS_WYYEB 135T_SRHS_XJSJSR 135T_SRHS_YFHXJSR 136T_SRHS_YFK 136T_SRHS_YHDZ 137T_SRHS_YHPOSYE 138T_SRHS_YHRJZ 138T_SRHS_YHSCBL 138T_SRHS_YHSCBL_TMP 139T_SRHS_YHSCDC 140T_SRHS_YHSCDC_LS 141T_SRHS_YHSCDC_TMP 142T_SRHS_YHSCJKS 143T_SRHS_YHSCJKS_LS 144T_SRHS_YHSCJKS_TMP

12、145T_SRHS_YHSCSS 146T_SRHS_YHSCTF 147T_SRHS_YHSCTF_LS 147T_SRHS_YHSCTF_TMP 148T_SRHS_YHSCWYMX 148T_SRHS_YHSCWYMX_TMP 149T_SRHS_YHSJJS_TEMP 149T_SRHS_YHZHYE 150T_SRHS_YJGKSR 150T_SRHS_YJGKSR_TMP 151T_SRHS_YJWLZH 152T_SRHS_YJZHSR 152T_SRHS_YJZHSR_TMP 153T_SRHS_YLPOS 154T_SRHS_YLPOS_LS 154T_SRHS_YLWYMX

13、 155T_SRHS_YSJSJSR 155T_SRHS_YSKM 156T_SRHS_YSKM_BAK 157T_SRHS_YSSR 157T_SRHS_YSSR_YS 158T_SRHS_YSXMDY 160T_SRHS_ZYK 160T_SYS_ADMINDEPTMENU 160T_SYS_JSDY 160T_SYS_MENU 160T_SYS_PARAMETER 161T_SYS_YHJSGJ 161T_XT_BFB 161T_XT_CDDY 161T_XT_CDDY2009 162T_XT_CDDY2010 162T_XT_CDDY_OLD 162T_XT_CWRZ 163T_XT_

14、CZY 163T_XT_JSCDGJ 163T_XT_JSCDGJ2009 164T_XT_JSCDGJ2010 164T_XT_JSCDGJ_NEW 164T_XT_JSCDGJ_OLD 164T_XT_JSDY 164T_XT_LOG 165T_XT_POSLOG 165T_XT_QXDY 165T_XT_REG 165T_XT_RZB 166T_XT_YHJSGJ 166T_YZ_PJBMDZ 166T_ZJB_PZXXB 166T_ZJB_YWXXB 167T_ZSGL_BMHXSQ 168T_ZSGL_BMKC 169T_ZSGL_CDDY 169T_ZSGL_CZY 169T_ZS

15、GL_DWKC 170T_ZSGL_HJMSQ 170T_ZSGL_HXSQ 171T_ZSGL_JSDY 172T_ZSGL_PJPZ 172T_ZSGL_PJRK 173T_ZSGL_SRTZSQ 173T_ZSGL_SRYS 174T_ZSGL_TFSQ 175T_ZSGL_XJDWKC 176T_ZSGL_XJYPJH 176T_ZSGL_XJYPSQ 177T_ZSGL_YHJSGJ 178USE 178YLMX 178YLMXBANKID 179YLMXDOWNLOG 179ZW_CS_DZD 179ZW_DTKJ 179ZW_DTKJ_TEMP 180ZW_KMSXMS 180Z

16、W_SJQS_TEMP 181ZW_SRXM_YSKMDYB 182ZW_TCBL 182ZW_TCJZ 183ZW_TCKJ_TMP 183ZW_TMP_DWHZB 184ZW_TMP_DZD 184ZW_TMP_MXSJB 185ZW_ZDYCS 186DEPARTMENT描述：基础数据_部门表序号字段名称字段描述字段类型长度允许空缺省值1AFA105部门编码VARCHAR232AFA106部门名称VARCHAR2100FSDWSERVERLOG描述：序号字段名称字段描述字段类型长度允许空缺省值1DWDM单位代码(KEY)VARCHAR2202REQDATE请求日期(KEY)VARCHAR

17、2103REQTIME请求时间(KEY)VARCHAR284MSGTYPE消息类型VARCHAR245UPFILENAME上传文件名VARCHAR21006DORESULT处理结果;1为成功，0为失败，空值为未处理VARCHAR217RESDATE处理完成日期VARCHAR2108RESTIME处理完成时间VARCHAR289FPJH票号VARCHAR22210PJLX票据类型 0:为正常缴款,1为批扣缴款VARCHAR2211PROCESS处理码VARCHAR2612PQLSH批扣流水号VARCHAR24013MESSAGE系统消息VARCHAR2200014ZIPFILENAME压缩文件名

18、VARCHAR260PJ_DWPZB描述：票据管理_单位与票种挂接表序号字段名称字段描述字段类型长度允许空缺省值1FPZDM票种代码VARCHAR252FDWDM单位内码VARCHAR2163FQSSJ起始时间VARCHAR2104FZZSJ终止时间VARCHAR2105FJBR经办人VARCHAR2406FJBSJ经办时间VARCHAR2107FIFFZ是否废止VARCHAR218FIFGX0 未更新；1 已经更新VARCHAR210TAB_DB_ERROR_INFO描述：序号字段名称字段描述字段类型长度允许空缺省值1IDNUMBER5,02ERROR_TIMEDATE73ERROR_NON

19、UMBER10,04ERROR_MESSAGEVARCHAR25125ERROR_MODULEVARCHAR240T_BB_ACCOUNT描述：报表数据序号字段名称字段描述字段类型长度允许空缺省值1BBH报表号VARCHAR2102XH序号NUMBER8,03QHBM区划编码VARCHAR2124RQ报表时间VARCHAR2105CSBZ传输标志 0未传输 1已传输NUMBER1,006FLAG备用标志NUMBER1,07V1VARCHAR2508V2VARCHAR2509V3VARCHAR25010V4VARCHAR25011N1NUMBER14,2012N2NUMBER14,2013N3N

20、UMBER14,2014N4NUMBER14,2015N5NUMBER14,2016N6NUMBER14,2017N7NUMBER14,2018N8NUMBER14,2019N9NUMBER14,2020N10NUMBER14,2021N11NUMBER14,2022N12NUMBER14,2023N13NUMBER14,2024N14NUMBER14,2025N15NUMBER14,2026N16NUMBER14,2027N17NUMBER14,2028N18NUMBER14,2029N19NUMBER14,2030N20NUMBER14,2031ND年度VARCHAR210T_BB_ACC

21、OUNT_TEMP描述：序号字段名称字段描述字段类型长度允许空缺省值1BBHVARCHAR2102XHNUMBER8,03QHBMVARCHAR2124RQVARCHAR2105CSBZNUMBER1,06FLAGNUMBER1,07V1VARCHAR25018V2VARCHAR25019V3VARCHAR250110V4VARCHAR250111N1NUMBER14,2012N2NUMBER14,2013N3NUMBER14,2014N4NUMBER14,2015N5NUMBER14,2016N6NUMBER14,2017N7NUMBER14,2018N8NUMBER14,2019N9NUM

22、BER14,2020N10NUMBER14,2021N11NUMBER14,2022N12NUMBER14,2023N13NUMBER14,2024N14NUMBER14,2025N15NUMBER14,2026N16NUMBER14,2027N17NUMBER14,2028N18NUMBER14,2029N19NUMBER14,2030N20NUMBER14,2031NDVARCHAR210T_BB_BBDY描述：报表定义表序号字段名称字段描述字段类型长度允许空缺省值1BBH报表号VARCHAR2102LMMC显示栏目名称VARCHAR21003XH列序号NUMBER2,04JC级次VARC

23、HAR225SJXH上级序号VARCHAR226SFXS是否显示：0 不显示；1 显示VARCHAR217SJLX数据类型：0公式 1 非公式VARCHAR228LENGTH栏目宽度VARCHAR21009RULE规则，公式则是具体公式，其余为科目代码VARCHAR210010LSH流水号NUMBER10,011SJYXH数据源序号NUMBER2,0T_BB_BBWH描述：定义生成报表日期序号字段名称字段描述字段类型长度允许空缺省值1LSH流水号NUMBER9,02MBLX模板类型 0月报 1季报 2年报 3其它VARCHAR243BBH报表号VARCHAR2104BBMC报表名称VARCHA

24、R21005JBSJ经办时间DATE76JBR经办人VARCHAR2407SJRQ数据日期VARCHAR2408ND年度VARCHAR240T_BB_DWXMTEMP描述：上下级分成业务中，生成上传的单位项目的数据序号字段名称字段描述字段类型长度允许空缺省值1DWMC单位名称VARCHAR21002XMBM项目编码VARCHAR2183XMMC项目名称VARCHAR21004DYLSH对应流水号NUMBER15,05JE金额NUMBER14,20 6ZYJE中央金额NUMBER14,207SJJE省级金额NUMBER14,208SIJE市级金额NUMBER14,209XJJE县级金额NUMBER14,20T_BB_JKSTEMP描述：上下级分成业务，生成上传缴款书数据序号字段名称字段描述字段类型长度允许空缺省值1LSH流水号NUMBER15,02JKSBH缴款书编号VARCHAR2