资金管理数据库设计.doc

资金管理数据库设计 "序号"物理表名 "中文名称 "备注 " "1 "MOM_BAL "资金余额 " " "2 "MOM_BANK "往来客户银行定义 " " "3 "MOM_BILL "结算单信息 " " "4 "MOM_BK_CTRAST_DET"银行对帐单明细 " " " "AIL " " " "5 "MOM_BK_CTRAST_HEA"银行对帐单主信息 " " " "D " " " "6 "MOM_OPT "单位级选项设置 " " "7 "MOM_VOUTEMP "支付中心凭证模板定义 " " 1、表MOM_BAL "数据表名称"资金余额 "主键定义 "FISCAL、PERIOD、CO_CODE、ACCO" " " " "UNT_ID、ACCOUNT_BANK " "存储内容： 资金余额信息 "外键一定义 " " " "索引一名称 " " " "索引二名称 " " "序号 "字段名称 "中文名称 "类型及长度 "其它 "说明 " "1 "FISCAL "会计年度 "Varchar2(20"Not null" " " " " ") " " " "2 "PERIOD "期间 "NUMBER " " " "3 "CO_CODE "单位代码 "Varchar2(20" " " " " " ") " " " "4 "ACCOUNT_ID "账套 "Varchar2(20" " " " " " ") " " " "5 "ACCOUNT_BAN"银行账户 "Varchar2(20" " " " "K " ") " " " "6 "DR_AMT "借方金额 "NUMBER " " " "7 "CR_AMT "贷方金额 "NUMBER " " " 2、表MOM_BANK "数据表名称"往来客户银行定义 "主键定义 "CO_CODE、BANK_ACCOUNT、ACCOUN" " " " "T_ID " "存储内容：往来客户银行定义信息 "外键一定义 " " " "索引一名称 " " " "索引二名称 " " "序号 "字段名称 "中文名称 "类型及长度 "其它 "说明 " "1 "CO_CODE "单位代码 "Varchar2(20"Not null" " " " " ") " " " "2 "BANK_ACCOUN"银行账号 "NUMBER " " " " "T " " " " " "3 "ACCOUNT_ID "账套代码 "Varchar2(20" " " " " " ") " " " "4 "BANK_BANK "开户行 "Varchar2(20" " " " " " ") " " " "5 "BANK_AC_NAM"全称 "Varchar2(20" " " " "E " ") " " " "6 "FISCAL "年度 "NUMBER " " " "7 "NOTE "备注 "NUMBER " " " 3、表MOM_BILL "数据表名称"结算单 "主键定义 "BILL_NO " "存储内容： 结算单信息 "外键一定义 " " " "索引一名称 " " " "索引二名称 " " "序号 "字段名称 "中文名称 "类型及长度 "可为空 "说明 " "1 "BILL_NO "通知单编号 "VARCHAR2(30"N " " " " " ") " " " "2 "INPUT_DATE "录入日期 "DATE "Y " " "3 "INPUTOR "录入人 "VARCHAR2(30"Y " " " " " ") " " " "4 "FISCAL "年度 "NUMBER "Y " " "5 "PERIOD "会计期间 "NUMBER "Y " " "6 "CO_CODE "单位代码 "VARCHAR2(30"Y " " " " " ") " " " "7 "ACCOUNT_ID "账套代码 "VARCHAR2(30"Y " " " " " ") " " " "8 "CO_CODE_ALL"支付局代码 "VARCHAR2(30"Y " " " " " ") " " " "9 "BF_NAME "本方账户名称 "VARCHAR2(50"Y " " " " " ") " " " "10 "BF_ACCOUNT "本方账户 "VARCHAR2(50"Y " " " " " ") " " " "11 "BF_BANK "本方开户行 "VARCHAR2(50"Y " " " " " ") " " " "12 "DF_NAME "对方账户名称 "VARCHAR2(50"Y " " " " " ") " " " "13 "DF_ACCOUNT "对方账户 "VARCHAR2(50"Y " " " " " ") " " " "14 "DF_BANK "对方开户行