第二章 总账系统数据库 1. 数据库列表 "名称 "说明 " "Code "《科目表》 " "Dsign "《凭证类别表》 " "Dsigns "《凭证类别子表》 " "Exch "《汇率表》 " "Fitem "《项目大类》 " "Fitemgrademode "《项目分类定义模版》 " "Fitemstructure "《项目结构定义》 " "Fitemstrumode "《项目目录定义模版》 " "Foreigncurrency "《币种表》 " "GL_accass "《辅助总帐》 " "GL_accsum "《科目总帐》 " "GL_accvouch "《凭证及明细帐》 " "GL_bage "《往来帐龄区间定义》 " "GL_bautotran "《自动转帐定义》 " "GL_bdigest "《常用摘要表》 " "GL_bfreq "《常用凭证》 " "GL_bmulti "《多栏定义》 " "GL_btext "《往来函证信息》 " "GL_mccontrol "《科目并发控制表》 " "GL_mcodeauth "《科目权限表》 " "GL_mcodeused "《科目常用项》 " "GL_mend "《帐套结帐状态表》 " "GL_merror "《对帐出错信息》 " "GL_mitemused "《项目常用项》 " "GL_mpostcond "《最近一次记帐凭证》 " "GL_msysname "《系统名称对照表》 " "GL_mvcontrol "《凭证并发控制表》 " "GL_mvocontrol "《外部凭证并发控制表》 " "GL_myaccount "《我的帐簿》 " "GL_mybooktype "《帐簿套打格式》 " "GL_myoutput "《输出栏目》 " "GL_vouchother "《外部凭证临时表》 " "RP_bankrecp "《银行对帐单(银行日记帐)》 " "RP_cheque "《支票登记簿》 " 2. 数据库字段说明 表名称 "名称 "序 "类型 "长度 "必填 "空 "默认 "说明 " "《科目表》 "Code " " " " " " " " " "i_id "1 "数字 (长整型) "4 " " " "自动编号(用于编辑时的唯一标识) " " "Cclass "2 "文本 "14 "** " " "科目类型(根据企业类型定义科目分类) " " "cclass_engl "3 "文本 "50 "** " " "科目类型英文名称 " " "Cclassany "4 "文本 "14 " " " "财务分析类型 " " "cclassany_engl "5 "文本 "50 " " " "财务分析类型英文名称 " " "Ccode "6 "文本 "15 "** " " "科目编码(按科目编码原则进行编码,<主表关联项>) " " "ccode_name "7 "文本 "20 " " " "科目名称 " " "ccode_engl "8 "文本 "100 " " " "科目英文名称 " " "igrade "9 "数字 (字节) "1 "** " " "科目级次(必须与科目编码相匹配) " " "bproperty "10 "是/否 "1 "** " " "科目性质(False：来源 True:占用) " " "cbook_type "11 "文本 "10 "** " " "帐页格式(金额式,数量金额式,外币金额式,数量外币式) " " "cbook_type_engl "12 "文本 "50 "** " " "帐页格式英文名称 " " "chelp "13 "文本 "6 " " " "科目助记码 " " "cexch_name "14 "文本 "8 " " " "外币名称(与外币主表关联) " " "cmeasure "15 "文本 "6 " " " "计量单位 " " "bperson "16 "是/否 "1 "** " " "个人往来核算(不能与其他辅助核算同时设置) " " "bcus "17 "是/否 "1 "** " " "客户往来核算(可与部门,项目核算同时设置) " " "bsup "18 "是/否 "1 "** " " "供应商往来核算(可与部门,项目核算同时设置) " " "bdept "19 "是/否 "1 "** " " "部门核算(可与客户,供应商,项目核算同时设置) " " "bitem "20 "是/否 "1 "** " " "项目核算(可与客户,供应商,部门核算同时设置) " " "cass_item "21 "文本 "2 " " " "项目大类(与项目大类主表_item关联,当bitem=True) " " "br "22 "是/否 "1
