第1页共66页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第1页共66页一、系统库1.单位表SM_COMPANY（全量）列名数据类型可为空缺省值字段描述SCOMPANYCODEVARCHAR2(20)N[单位编码]SCOMPANYNAMEVARCHAR2(60)N[单位名称]SSHORTNAMEVARCHAR2(60)Y[简称]SLOCATIONVARCHAR2(60)Y[地址]SPOSTCODEVARCHAR2(6)Y[邮政编码]STELPHONEVARCHAR2(30)Y[电话]SCONTANCTORVARCHAR2(30)Y[联系人]SEMAILVARCHAR2(60)Y[邮箱]SFAXVARCHAR2(30)Y[传真]SWEBSERVERVARCHAR2(60)Y[网站]NSORTNUMVARCHAR2(20)Y[排序码]BCLIENTCHAR(1)Y'N'[是否集团单位]SPARENTCODEVARCHAR2(20)Y[上级单位编码]SALLPARENTCODEVARCHAR2(2000)Y[所有上级编码]SGROUPCODEVARCHAR2(20)Y[集团代码]SPROPERTYVARCHAR2(50)Y[产权登记码]SFIELDCODEVARCHAR2(20)Y'IC'[内部分类]SBIZAREACODE1VARCHAR2(20)Y[内部分类编码值]SFIELDCODE2VARCHAR2(20)Y'CC'[单位地区]SBIZAREACODE2VARCHAR2(20)Y[单位地区代码值]SFIELDCODE3VARCHAR2(20)Y'DC'[基层单位代码]SBIZAREACODE3VARCHAR2(20)Y[基层单位代码值]SFIELDCODE4VARCHAR2(20)Y'AC'[单位属性]SBIZAREACODE4VARCHAR2(20)Y[单位属性值]SFIELDCODE5VARCHAR2(20)Y'PC'[所在省份]第2页共66页第1页共66页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第2页共66页SBIZAREACODE5VARCHAR2(20)Y[所在省份值]NSHAREHOLDNUMBER(5,4)Y[股权比率]SADMINGROUPIDVARCHAR2(36)Y[单位管理组]SUSERADMINGROUPIDVARCHAR2(36)Y[单位人员管理组]SREMARKVARCHAR2(100)Y[备注]SBEGINDATEVARCHAR2(20)Y[开始日期]SENDDATEVARCHAR2(20)Y[结束日期]SDIRECTORVARCHAR2(50)Y[负责人]SSTATEVARCHAR2(20)Y[状态]SSORTNUMVARCHAR2(20)Y[排序]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')[时间戳]SCPCODEVARCHAR2(200)Y2.帐套表SM_CORP（全量）列名数据类型可为空缺省值字段描述SCORPCODEVARCHAR2(20)N[帐套编码]SCORPNAMEVARCHAR2(60)N[帐套名称]NSORTNUMNUMBER(12,2)Y[排序码]SCOMPANYCODEVARCHAR2(20)N[单位编码]STRADEPROPCHAR(1)Y'0'[行业属性]BISCLOSECHAR(1)Y'0'[是否停用]SCLOSEREASONVARCHAR2(100)Y[停用原因]SSERVERCODEVARCHAR2(50)Y[服务编码]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')[时间戳]BISSTANDARDCOMPCHAR(1)Y'1'[是否标准科目]SDATEFROMVARCHAR2(20)Y[起始日期]SDATETOVARCHAR2(20)Y[失效日期]第3页共66页第2页共66页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第3页共66页BCLIENTCHAR(1)Y'0'[集团帐套]SUSERIDVARCHAR2(50)Y[负责人]3.用户表SM_USERS（全量）列名数据类型可为空缺省值字段描述SUSERIDVARCHAR2(50)NSUSERCODEVARCHAR2(20)NSUSERNAMEVARCHAR2(60)YSNICKNAMEVARCHAR2(60)YSPICPATHVARCHAR2(100)YSSEXVARCHAR2(2)YSPASSWORDVARCHAR2(60)YBISSYSMANAGERCHAR(1)YSCOMPANYCODEVARCHAR2(20)YBLOGINCHAR(1)YSEMAILVARCHAR2(50)YSWEBEMAILVARCHAR2(50)YSMOBILENOVARCHAR2(50)YSPHONENOVARCHAR2(50)YSREMARKVARCHAR2(60)YDDATEFROMVARCHAR2(10)NDDATETOVARCHAR2(10)NNSORTNUMNUMBER(12,2)YSDEPTIDVARCHAR2(50)YNSPACESIZENUMBER(10)YSPOSITIONVARCHAR2(50)YSDUTYVARCHAR2(50)YSPOSTCODEVARCHAR2(20)YSADDRESSVARCHAR2(50)Y第4页共66页第3页共66页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第4页共66页SCARDIDVARCHAR2(50)YSNATIONCODEVARCHAR2(50)YSMAJORCODEVARCHAR2(50)YSADDUSERVARCHAR2(50)YTSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')SSHORTVARCHAR2(20)YBFORCECHANGEPWCHAR(1)YSLASTLOGINVARCHAR2(10)YTO_CHAR(SYSDATE,'YYYYMMDD')BLOGGEDINCHAR(1)YSCLIENTGUIDVARCHAR2(50)Y4.会计期间子表BD_FYEARSTRUCT_S（全量）名称类型可为空DEFAULT/EXPR.字段描述SPERIODCODEVARCHAR2(7)NIYEARNUMBER(4)NDP_BEGINDATEVARCHAR2(8)NDP_ENDDATEVARCHAR2(8)YSPERIODNAMEVARCHAR2(20)NBCLOSEDCHAR(1)Y'N'BACITVECHAR(1)YTSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')5....
