方正春元数据字典22866.pdf

TABLE_MANAGERTABLE_NAMETABLE_CNAMETABLE_TYPEREMARKIS_RELATEBUDGET_ITEM项目分类1011APP_SYSTEM应用系统管理表301DEFAULT_FLOW_SET流程节点设置表301SALARY_SET_BUDGET工资统发用表301PAY_SALARY工资统发用表301ELEMENT_DATA_LOG增量上传数据日志表301ELEMENT_SETELEMENT_SET301ROLE_ECIDROLE_ECID301ELEMENT_COMBINATIONELEMENT_COMBINATION301ELEM_RIGHTTYPE通用要素配置表301ELEM_RIGHT通用要素授权表301MODULE_RIGHT_GROUP模块权限组关联表301SQLSCRIPTSQL脚本执行记录表301VOUCHER_BALANCETYPE余额类型DATA_SOURCE数据来源VOUCHER_DATASOURCE_RELATING数据来源和账套挂接关系VOUCHER_BILL_RELATING业务单和会计凭证关联关系CONVERTEDNOTAX_DETAIL非税收入业务明细数据NOTAX_BILL非税收入业务单表NOTAX_DETAIL_BILL非税收入关联表BUSINESS_LEVEL级次设置表BUSINESS_LEVELCUSTOM自定义级次设置BUSINESS_LEVELREF级次引用表CONFIG_MANAGER配置信息表PAY_NOBUDGET拨款单表2090INCOME_DAY_BILL收入单表2090INCOME_DAY_DETAIL收入单明细表2090YE_IDRELATION301DB_BUG_SQLLOCALTABLELOGSYSCONFIGTEMP_CONVERTEDTEMP_YEREPORTVOUCHER_BILLDETAIL_RELATING209TRANSFERSET结转设置表301TRANSFERSET_DETAIL结转设置明细表301BUDGET_PURPOSE指标特性101BUDGET_LABEL指标来源101PLAN_SUMMARY计划说明101GOVERMENT_BUY政府采购标志101PLAN_ORDER计划函号101PAY_ORDER政府采购支付函号101BUDGET_ITEM_SUMMARY预算项目1011BUDGET_DIVISION代分标志101APP_SYSTEM_MENU无3010BANK_ACCOUNT_BLACK黑名单帐户1020UPGRADE_REPORT_CACHE升级报告201DATA_CHECK_INFO_CACHE四方对帐结果201PAY_NOBUDGET_BILL拨款单主表2090RELATION_TABLE关联关系主表209RELATION_DEFINE关联关系字段表209RELATION_VALUE关联关系值表209VOUCHER_TCPERCENT统筹比例209Page 1TABLE_MANAGERGL_BALANCE以收定支余额表209VOUCHER_EID_LOG单位余额变更日志表209ACCOUNT_RELATIONS账务关联关系表209ACCOUNT_RELATION_MANAGER账务关联关系主表209SYSACCOUNT系统标示表3010DATAFORVOUCHER_CACHE账务数据中间主表209DATAFORVOUCHER_DETAIL_CACHE账务数据中间明细表209PAYEE_REGION_PRINT收款人区域缩写表101EXCHANGE_USER_SET交换中心区域用户(账务)301PAY_DETAIL_CACHE公务卡信息201PLAN_NEW待分配计划额度表201PLAN_NEW_CACHE待分配计划额度临时表201PLAN_SUM计划余额确认表201PLAN_REMAIN计划余额201PLAN_DIVIDE计划分配201BUDGET_DIVIDE指标分配201BUDGET_SUM指标余额汇总表201BUDGET_REMAIN指标余额表201BUDGET_NEW指标余额分配表201BUDGET_NEW_CACHE指标余额分配缓冲表201DATACHECK_PLAN_DETAIL计划明细对账表201DATACHECK_PLAN_BILL计划对账单表202DATACHECK_PAY_BILL支付对账单表202DATACHECK_PAY支付明细对账表201DATACHECK_BUDGET_DOING指标明细对账表201DATACHECK_BUDGET_BILL指标对账单表202DATACHECK_DETAIL单位对账明细表201DATACHECK_BILL对账汇总单表202BASE_APP_ROUTE_VIEW无3010BASE_APP_TABLE_RELATION无3010BASE_FIELD_MANAGER无3010BASE_TABLE_VER无3010ENTERPRISE_DETAIL预算单位信息维护101FILE_APPLICATION无3010FILE_APPLICATION_DETAIL无3010ITEM_SUMMARY_MAINTAIN无3010NONTAX无3010PAYEE_REGION收款人对应区域1010PAY_BANK_DETAIL代理银行信息维护101SQL_APPLICATION无3010FIELD_MANAGER_LOGPAY_SALARY_TMP301VIEW_LIST_LOGBUDGET_ORIGIN预算类型1010BUDGET_TARGET指标流向101CURRENTS往来101TABLE_MANAGER业务表和基础表管理表301BUDGET_FLOW_STATE指标流程状态表204BUSINESS_SYSTEM业务子系统表301FLOW_RIGHT_RELATION权限组相关表301FLOW_NODE_MENU流程节点菜单关系表301FLOW_NODE_LINK流程节点关系表301FLOW_NODE流程节点表301FLOW流程表301PAY_BANK代理银行101PAY_ADJUST支付调整类型101Page 2TABLE_MANAGERBUDGET_EN_BILL_CACHE指标导入单临时表201BUDGET_DOING_CACHE指标过程缓存表203BUDGET_DOING指标明细表201BUDGET_BILL_CACHE指标下达缓存表203BUDGET_OPERATION指标操作历史表204PAY_EN_BILL用款申请上报202PAY_DAY_BILL_CACHE日报缓存表203PAY_DAY_BILL支出日报表202PAY_CENTER_BILL_CACHE清算额度发送缓存表203CODE_TRANSLATION编码对照表301CACHE_MANAGER缓存管理表301MODULE_OPERATION_STATE功能与操作关联表301MODULE_OPERATION功能与操作的关联表301MODULE功能表301MODEL_VOUCHER_DETAIL凭证模板明细表309BUDGET指标额度201PAY支付申请201MODEL_VOUCHER凭证模板主表309MENU菜单信息301PAY_MODE结算方式101PLAN_ADJUST计划调整类型101PAY_BILL_CACHE支付单缓存表203PAY_BILL支付凭证202PLAN_DETAIL_CACHE计划明细缓存表203HOLD13保留表13101PAY_BANK_BILL划款申请202FILE_NO指标文号101PLAN_EN_BILL_CACHE预算单位上报计划单缓存表203PLAN_EN_BILL用款计划上报单202PAY_EN_ACC_BILL授权支付信息上报202PAY_EN_ACC_BILL_CACHE授权支付回单上报表_cache203BUSINESS_PRIMARYKEY序列管理表301DATA_STATE数据状态表301DATA_STATE_BASE数据状态基础表301DATA_VERSION基础数据版本301EXCHANGE_USER交换中心用户301RC_RI_RELATION报表关系表301REG_DETAIL参数注册明细表301MSG_ADDRESS_LIST消息地址本301REG_ITEM参数注册项目表301REPORT_CLASS报表类表301REPORT_INSTANCE报表实例表301EDITOR编制机构101INCOME非税收入201INCOME_BILL收入单表202INCOME_BILL_CACHE收入单临时表203INCOME_CACHE收入临时表203PAYEE_RIGHT_RELATION收款账户授权表301PAYEE收款帐户102CLEAR_BANK清算银行101INCOME_BANK收费银行101INCOME_ITEM收费项目101USER_PAY_BANK用户代理银行授权301USER_CLEAR_BANK用户清算银行授权301SALARY_DEFAULT_SETUP工资表301PAY_SETTLE预算支出结算清单表209Page 3TABLE_MANAGERBUDGET_INIT待分指标201BUDGET_CATEGORY指标类别101PLAN_AGENT_BILL授权支付额度通知单202PLAN_AGENTEN_BILL_CACHE额度到账通知单缓存表203PLAN_AGENTEN_BILL授权额度到账通知单202DATACHECK_BILL_CACHE对账明细表202DATACHECK_CACHE对账主表202DEPARTMENT项目101ENTERPRISE预算单位1011FOREIGN_MONEY外币101MONEY_KIND资金性质101MANAGE_BRANCH业务科室1011BOOK_SET账套管理表309ELEM_ENUMERATE基础数据枚举数据表301ELEM_CHANGE基础信息变动记录表301FIELD_MANAGER业务表和基础数据表的字段管理表302EXCHANGE_DATA交换数据存储表301PLAN_OPERATION计划操作历史表204PLAN_RECEIVE_BILL用款计划接收单202PLAN_RECEIVE_BILL_CACHE预算单位接收计划缓存表203REGION区域101PLAN计划额度表201SUMMARY支付摘要101VIEW_MANAGER视图管理主表301VIEW_LIST视图管理明细表302WORK_DAY工作日管理表301PAYOFF_KIND支付方式1010VOUCHER凭证主表209VOUCHER_SET机制凭证类型设置表309VOUCHER_DETAIL凭证明细表209USERS用户信息301ROUTE_USER路由用户表301ROUTE_SEND_MODE发送方式表301ROUTE_RULE路由规则表301ROUTE_DATA_TYPE路由数据类型表301ROUTE_COMBINATION机构对应收发表301ROUTE_ADDRESS_LIST_ALL路由地址表(财政)301ROUTE_ADDRESS_LIST路由地址表301ROLE_SET用户对帐套授权表301ROLE_RIGHT_RELATION权限组相关表301ROLE_MENU角色对菜单的权限301ROLE角色表301RIGHT_GROUP_REM_DETAIL存储排除权限301RIGHT_GROUP_PRO_DETAIL存储追加权限301RIGHT_GROUP_DETAIL存储主权限301RIGHT_GROUP_COMMENT权限组相关表301RIGHT_GROUP权限组相关表301REMAIN期初数表209REPORT报表301VOUCHER_VIEW机制凭证可见列表309VOUCHER_SET_FILTER机制凭证过滤条件表309VOUCHER_SET_DETAIL机制凭证科目对照表309VOUCHER_RESTRICT_VALUE科目挂接辅助核算值表309VOUCHER_RESTRICT凭证核算约束表309VOUCHER_PASSED机制凭证已生成表309VOUCHERNO_DEFINE凭证类别表309Page 4TABLE_MANAGERPLAN_FLOW_STATE计划流程状态表204USER_SET用户对帐套授权表301USER_ROLE用户与角色关系表301USER_MANAGE_BRANCH用户业务处室对应表301USER_ENTERPRISE用户预算单位对应表301UNIT_NUM数量单位101SYSUSER系统用户表301PAY_OPERATION支付申请操作历史表204PAY_RECEIVE_BILL用款申请接收表202PAY_FLOW_STATE支付流程状态表204OUTSYS_CODE_FORMAT外部编码对照表301OPERATION操作信息表301PRIMARY_MANAGER主键管理表301PRINT_OPERATION打印历史记录301RELATIONS基础表间的约束关系表301TRANS_MODEL_DETAIL自动转账模板明细表309TRANS_MODEL自动转账模板主表309FORMULA_DETAIL自定义函数参数表309FORMULA自定义函数主表309GK_STANDARD_DATA_TYPE数据库类型标准表301HOLD9保留表9101PAY_EN_BILL_CACHE预算单位上报申请缓存表203PAY_CENTER_BILL清算额度通知单202ASSISTANT辅助核算101PAY_ACC_BILL_CACHE代理银行到账通知单缓存表203PAY_ACC_BILL入账通知书202PLAN_CLEAR_BILL_CACHE授权清算额度缓存表203PLAN_BILL计划批复单202PLAN_AGENT_BILL_CACHE授权支付额度缓存表203HOLD8保留表8101HOLD5保留表5101HOLD20保留表20101HOLD2监控标识101HOLD16保留表16101HOLD15保留表15101HOLD12保留表12101HOLD11保留表11101MSG_RECV收件箱201BUDGET_SUBJECT_INCOME收入分类101BANK_ACCOUNT_INCOME预算外收入账户102BUDGET_EN_BILL指标导入单201PAY_CACHE支付申请缓存表203VOUCHER_DETAIL_PAY支付中心账凭证明细表209VOUCHER_DETAIL_BUDGET总预算会计账凭证明细表209VOUCHER_PAY支付中心账凭证主表209VOUCHER_BUDGET总预算会计账凭证主表209RELATION_MANAGER要素关联关系表301HOLD1指标来源级次101SUMMARY_ACCOUNT帐套摘要309REMAIN_PAY支付中心账期初数表209REMAIN_BUDGET总预算会计账期初数表209MSG_CACHE发件箱201BANK_ACCOUNT_AGENT代理银行划款账户102ACCOUNT_CLEAR_RIGHT_RELATION国库账户授权表301ACCOUNT_PAY_RIGHT_RELATION支付账户授权表301BANK_ACCOUNT_PAY支付账户102Page 5TABLE_MANAGERBANK_ACCOUNT_CLEAR国库账户102PAY_BANK_BILL_CACHE划款申请发送缓存表203HOLD7保留表7101HOLD6保留表6101HOLD4保留表4101HOLD3备用3101HOLD19保留表19101HOLD18保留表18101HOLD17保留表17101HOLD14保留表14101PLAN_DETAIL计划明细表201PLAN_CLEAR_BILL授权清算额度通知单202OTHER社保类型101PLAN_BILL_CACHE计划批复打印缓存表203PAY_RECEIVE_BILL_CACHE预算单位接收支付申请缓存表203HOLD10保留表10101ACCOUNTANT_SUBJECT会计科目101BUDGET_KIND支付类型1010BUDGET_SUBJECT支出功能分类科目1011BUDGET_SUBJECT_ITEM支出经济分类科目101BUDGET_BILL指标批复单202BUSINESS_YEAR业务年度表301BUDGET_ADJUST指标调整类型101Page 6TABLE_MANAGERIS_MAINTAINIS_UPDATED FIELD_NAME DISP_FORMATNEED_UPDATEFORMAT_FLAGLAST_VER10 BI_CODE3-3-3-31136000360103600013600013600036000003600000360000036000036000036000036000036003600360036003600360036003600360036003600360036000036000036000036-10036003600360036003600360036-10036000360003610 BP_CODE3-3-3-3113610 BL_CODE3-3-3-3113600 PS_CODE3-3-3-3113610 GB_CODE3-3-3-3113600 PLO_CODE 3-3-3-3013600 PO_CODE3-3-3-3013611 BIS_CODE 3-3-3-3013600 BD_CODE3-3-3-31136-100136000036-100136-10013600003600036000360003600036Page 7TABLE_MANAGER0003600036000360003600003600036000360003600036-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-100136-10013600036-100136-100136-100136-10013610 PAYEE_RG_CO3-3-3-3113600036-10013600360036003610 BO_CODE3-3-3-3113610 BT_CODE3-3-3-3113601 CR_CODE3-3-3-30136001360003600036000360003600036000360003610 PAY_BANK_CO3-3-3-3113600 PA_CODE3-3-3-31136Page 8TABLE_MANAGER0003600036000360003600036000360003600036000360003600136000360003600036000360003600036000360003610 PAY_MODE_CO3-3-3-3113600 PL_CODE3-3-3-3113600036000360003600 HOLD13_CODE3-3-3-301360003600 FILE_CODE3-3-3-3013600036000360003600036000360003600036000360003600036-1003600036-10036000360003600 EDITOR_CODE3-3-3-3013600036-10036-10036-1003600036003-3-3-303610 CLEAR_BANK_3-3-3-3113601 INCOME_BANK3-3-3-3013601 IN_BSI_CODE3-3-3-30136-10036-10036-10036-10036Page 9TABLE_MANAGER0003600 BC_CODE3-3-3-31136000360003600036000360003601 DP_CODE3-3-3-3013610 EN_CODE3-3-3-3113601 FM_CODE3-3-3-3013610 MK_CODE3-3-3-3113610 MB_CODE3-3-3-3113600036-1013600036001360003600036000360003600 RG_CODE2-2-2-211360003600 SUMMARY_COD3-3-3-3013600136001360013610 PK_CODE3-3-3-31136000360003600036000360003600036001360013600036000360003600036000360003600036000360003600036000360003600036-1003600036000360003600036000360003600036Page 10TABLE_MANAGER000360003600036000360003601 UNIT_CODE3-3-3-301360003600036000036000360003600036000360003600036000360003600036000360003600 HOLD9_CODE 3-3-3-30136000360003600 ASS_CODE 3-3-3-30136000360003600036000360003600 HOLD8_CODE 3-3-3-3013600 HOLD5_CODE 3-3-3-3013600 HOLD20_CODE3-3-3-3013610 HOLD2_CODE 3-3-3-3113600 HOLD16_CODE3-3-3-3013600 HOLD15_CODE3-3-3-3013600 HOLD12_CODE3-3-3-3013600 HOLD11_CODE3-3-3-301360003611 IN_BS_CODE 2-2-2013600 INCOME_ACCO3-3-3-30360003600036000360003600036000360003610 HOLD1_CODE 3-3-3-311360003600036000360003600 PAY_ACCOUNT3-3-3-3036000360003600 PAY_ACCOUNT3-3-3-3136Page 11TABLE_MANAGER00 CLEAR_ACCOU3-3-3-31360003600 HOLD7_CODE 3-3-3-3013600 HOLD6_CODE 3-3-3-3013600 HOLD4_CODE 3-3-3-3013600 HOLD3_CODE 3-3-3-3113600 HOLD19_CODE3-3-3-3013600 HOLD18_CODE3-3-3-3013600 HOLD17_CODE3-3-3-3013600 HOLD14_CODE3-3-3-30136000360003601 OTH_CODE 3-3-3-30136000360003600 HOLD10_CODE3-3-3-3013601 AS_CODE3-2-2-2013610 BK_CODE3-3-3-3113610 BS_CODE3-2-2113610 BSI_CODE 3-2-2113600036-1013600 BA_CODE3-3-3-31136Page 12