会计核算系统-接口数据表表结构.doc

《会计核算系统-接口数据表表结构.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、一、系统库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[邮箱

2、]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'[内部分

3、类]SBIZAREACODE1VARCHAR2(20)Y[内部分类编码值]SFIELDCODE2VARCHAR2(20)Y'CC'[单位地区]SBIZAREACODE2VARCHAR2(20)Y[单位地区代码值]SFIELDCODE3VARCHAR2(20)Y'DC'[基层单位代码]SBIZAREACODE3VARCHAR2(20)Y[基层单位代码值]SFIELDCODE4VARCHAR2(20)Y'AC'[单位属性]SBIZAREACODE4VARCHAR2(20)Y[单位属性值]SFIELDCODE5VARC

4、HAR2(20)Y'PC'[所在省份]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[负责人

5、]SSTATEVARCHAR2(20)Y[状态]SSORTNUMVARCHAR2(20)Y[排序]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')[时间戳]SCPCODEVARCHAR2(200)Y1.帐套表SM_CORP（全量）列名数据类型可为空缺省值字段描述SCORPCODEVARCHAR2(20)N[帐套编码]SCORPNAMEVARCHAR2(60)N[帐套名称]NSORTNUMNUMBER(12,2)Y[排序码]SCOMPANYCODEVARC

6、HAR2(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[起始日期]SDATETOVA

7、RCHAR2(20)Y[失效日期]BCLIENTCHAR(1)Y'0'[集团帐套]SUSERIDVARCHAR2(50)Y[负责人]1.用户表SM_USERS（全量）列名数据类型可为空缺省值字段描述SUSERIDVARCHAR2(50)NSUSERCODEVARCHAR2(20)NSUSERNAMEVARCHAR2(60)YSNICKNAMEVARCHAR2(60)YSPICPATHVARCHAR2(100)YSSEXVARCHAR2(2)YSPASSWORDVARCHAR2(60)YBISSYSMANAGERC

8、HAR(1)YSCOMPANYCODEVARCHAR2(20)YBLOGINCHAR(1)YSEMAILVARCHAR2(50)YSWEBEMAILVARCHAR2(50)YSMOBILENOVARCHAR2(50)YSPHONENOVARCHAR2(50)YSREMARKVARCHAR2(60)YDDATEFROMVARCHAR2(10)NDDATETOVARCHAR2