搜索
一、系统库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'[所在省份]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')[时间戳]2.帐套表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[失效日期]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)YSCARDIDVARCHAR2(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.会计期间主表BD_FYEARSTRUCT_M（全量）名称类型可为空DEFAULT/EXPR.字段描述IYEARNUMBER(4)NDY_STARTDATECHAR(8)YDY_ENDDATECHAR(8)YIPERIODNUMNUMBER(2)Y12BCLOSEDCHAR(1)Y'N'BACTIVEYEARCHAR(1)YTSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')二、账务6.货币档案表BD_CURRENCY（全量）列名数据类型可为空缺省值主键字段描述SCUR_ABVVARCHAR2(20)N√[货币代码]各个货币的国际简码SCURRENCYVARCHAR2(20)N[货币名称]BNATURAL_FLAGCHAR(1)N[本位币标识位]SCUR_FLAGCHAR(1)Y[货币标识符]IEXCHANGERATE_METHODINTEGERY1[换算方式]NTOLERANCENUMBER(4,2)Y0[容差]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS'[TS]创建日期7.会计科目表BD_ACC_SUBJECT_C（全量）列名数据类型可为空缺省值主键字段描述SACC_CODE_CVARCHAR2(100)N√[科目代码]基础核算单位编号SACC_CODEVARCHAR2(100)Y[科目内置代码]IYEARNUMBER(4)N√[年份]SCORPCODEVARCHAR2(20)N√[公司信息编码]SACC_NAME_CVARCHAR2(80)N[公司科目名称]会计科目名称，不能为空SABVVARCHAR2(20)Y[助记码]BISJOUR_SUBJECTCHAR(1)Y'N'[末级科目标识位]ILEVELINTEGERY[级次]SOUTPUT_TEMPVARCHAR2(4)Y[账簿首选样式]SACC_CLASSVARCHAR2(4)Y[科目分类属性]ICREDIT_DEBITINTEGERN0[余额方向]0:借方1:贷方BCLOSEDCHAR(1)N'N'[关闭标识位]BFROZENCHAR(1)N'N'[冻结标识位]BCASH_FLAGCHAR(1)N'N'[现金标识]BBANK_FLAGCHAR(10)N'N'[银行帐标识]SAMOUNTUINTVARCHAR2(20)N'0'[数量核算标识位]SPOSTCURVARCHAR2(20)N'0'[记账币种代码]SDRIVENSUBJECTVARCHAR2(4)Y[控制科目标识]BITT_FLAGCHAR(1)N'N'[集团内部往来标识位]SARAP_FLAGVARCHAR2(4)N'0'[往来核算标识位]SCTL_ITEM_FLAGVARCHAR2(4)N'0'[成本要素标识位]BSLG_DEPCHAR(1)N'N'[部门核算标识位]SLG_PJT1VARCHAR2(20)Y[项目核算标识位1]SLG_PJT2VARCHAR2(20)Y[项目核算标识位2]SLG_PJT3VARCHAR2(20)Y[项目核算标识位3]SLG_PJT4VARCHAR2(20)Y[行业属性]DCREATEDSTPVARCHAR2(8)Y[创建时间]创建时间BINI_SUBJECTCHAR(1)Y'N'[初始科目标识位]SCREATEDBYVARCHAR2(20)Y[创建人]取当前操作员名称TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')[TS]SPARENTCODEVARCHAR2(100)Y[上科目编码]8.凭证主表GL_DOC_M（增量）列名数据类型可为空缺省值主键字段描述SDOC_IDVARCHAR2(60)N√[凭证主键编号]SDOC_NOVARCHAR2(20)N[凭证号]即凭证字第号SPERIODCODEVARCHAR2(7)Y[期间代码]:'XXXX-XX'SCORPCODEVARCHAR2(20)N[公司信息编码]IYEARNUMBER(4)N[年份]DDOC_DATECHAR(8)N[凭证日期]DPOST_DATECHAR(8)Y'00000000'[记账日期]SDOC_TYPEVARCHAR2(20)N[凭证类型代码]SEXPLAINVARCHAR2(80)Y[参考说明]NAPPENDDIXINTEGERN0[附件数]说明附件张数SPOSTEDBYVARCHAR2(40)Y[记账人]SCHECKEDBYVARCHAR2(40)Y[审核人]SENTRIEDBYVARCHAR2(40)Y[制证人]SCASHIERVARCHAR2(40)Y[出纳人]SPAY_METHODS_CODEVARCHAR2(20)Y[结算方式代码]SBILLNOVARCHAR2(40)Y[结算号]SPAYERVARCHAR2(40)Y[收缴款人]NAMT_DBTNUMBER(20,2)N[借方金额合计]NCWORKLOADNUMBER(20,4)Y[工作量借方]NDWORKLOADNUMBER(20,4)Y[工作量贷方]BPOSTEDCHAR(1)N'N'[记账标识位]BCHECKEDCHAR(1)N'N'[审核标识位]BLOCKEDCHAR(1)N'N'[加锁标识位]SPOSTEDFROMVARCHAR2(4)N'1040'[凭证来源标识位]ICREDIT_FLAGINTEGERN0[贷项处理标识位]SCREDIT_ORGVARCHAR2(60)Y[贷项原凭证号]STRANSTYPEVARCHAR2(20)Y[