财务管理-会计核算系统-接口数据表表结构

数据类型可为空缺省值字段描述SPANYCODEVARCHAR2(20)N位编码]SPANYNAMEVARCHAR2(60)N位名称]SSHORTNAMEVARCHAR2(60)YSLOCATIONVARCHAR2(60)YSPOSTCODEVARCHAR2(6)Y政编码]STELPHONEVARCHAR2(30)YSCONTANCTORVARCHAR2(30)YSEMAILVARCHAR2(60)YFAXVARCHAR2(30)YSWEBSERVERVARCHAR2(60)YORTNUMVARCHAR2(20)YCHAR(1)Y[是否集团单位]SPARENTCODEVARCHAR2(20)Y[上级单位编码]SALLPARENTCODEVARCHAR2(2000)Y[所有上级编码]SGROUPCODEVARCHAR2(20)Y团代码]SPROPERTYVARCHAR2(50)Y[产权登记码]SFIELDCODEVARCHAR2(20)Y部分类]SBIZAREACODE1VARCHAR2(20)Y[内部分类编码值]SFIELDCODE2VARCHAR2(20)Y位地区]SBIZAREACODE2VARCHAR2(20)Y[单位地区代码值]SFIELDCODE3VARCHAR2(20)Y[基层单位代码]SBIZAREACODE3VARCHAR2(20)Y[基层单位代码值]SFIELDCODE4VARCHAR2(20)Y位属性]SBIZAREACODE4VARCHAR2(20)Y[单位属性值]SFIELDCODE5VARCHAR2(20)Y在省份]SBIZAREACODE5VARCHAR2(20)Y[所在省份值]NSHAREHOLDNUMBER(5,4)Y权比率][[单位管理组][单位人员管理组]始日期]束日期]TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')SADMINGROUPIDSUSERADMINGROUPIDSREMARKSBEGINDATESENDDATESDIRECTORSSTATESSORTNUMTSVARCHAR2(36)VARCHAR2(36)VARCHAR2(100)VARCHAR2(20)VARCHAR2(20)VARCHAR2(50)VARCHAR2(20)VARCHAR2(20)VARCHAR2(20)YYYYYYYYYP缺省缺省值TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')字段描述套编码]套名称]位编码]业属性]否停用]用原因]务编码][是否标准科目]始日期]效日期]团帐套]数据类型VARCHAR2(20)VARCHAR2(60)NUMBER(12,2)VARCHAR2(20)CHAR(1)CHAR(1)VARCHAR2(100)VARCHAR2(50)VARCHAR2(20)CHAR(1)VARCHAR2(20)VARCHAR2(20)CHAR(1)VARCHAR2(50)SCORPCODESCORPNAMEORTNUMSPANYCODESTRADEPROPESCLOSEREASONSSERVERCODETSBISSTANDARDPSDATEFROMSDATETOSUSERID可为空NNYNYYYYYYYYYY3.用户表SM_USERS(全量)数据类型可为空缺省值字段描述SUSERIDVARCHAR2(50)NSUSERCODEVARCHAR2(20)NSUSERNAMEVARCHAR2(60)YSNICKNAMEVARCHAR2(60)YVARCHAR2(100)YSSEXVARCHAR2(2)YVARCHAR2(60)YBISSYSMANAGERCHAR(1)YVARCHAR2(20)YCHAR(1)YSEMAILVARCHAR2(50)YSWEBEMAILVARCHAR2(50)YSMOBILENOVARCHAR2(50)YSPHONENOVARCHAR2(50)YSREMARKVARCHAR2(60)YVARCHAR2(10)NVARCHAR2(10)NNUMNUMBER(12,2)YSDEPTIDVARCHAR2(50)YNUMBER(10)YSPOSITIONVARCHAR2(50)YSDUTYVARCHAR2(50)YSPOSTCODEVARCHAR2(20)YSADDRESSVARCHAR2(50)YSCARDIDVARCHAR2(50)YONCODEVARCHAR2(50)YSMAJORCODEVARCHAR2(50)YSADDUSERVARCHAR2(50)YTOTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')VARCHAR2(20)CHAR(1)VARCHAR2(10)CHAR(1)VARCHAR2(50)SSHORTBFORCECHANGEPWSLASTLOGINSCLIENTGUIDTO_CHAR(SYSDATE,'YYYYMMDD')VARCHAR2(20)YYYYYTSY4.会计期间子表BD_FYEARSTRUCT_S(全量)类型可为空字段描述SPERIODCODEVARCHAR2(7)NNUMBER)NVARCHAR2(8)NVARCHAR2(8)YSPERIODNAMEVARCHAR2(20)NCHAR(1)YCHAR(1)YTSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')5.会计期间主表BD_FYEARSTRUCT_M(全量)类型可为空字段描述NUMBERNCHAR(8)YCHAR(8)YIPERIODNUMNUMBERYCHAR(1)YYEARCHAR(1)YTSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')6.货币档案表BD_CURRENCY(全量)主键主键字段描述货币名称][本位币标识位][货币标识符]换算方式][TS]创建日期SCUR_ABVSCURRENCYATURALFLAGURFLAGIEXCHANGERATE_METHODNCETS数据类型可为空VARCHAR2(20)NVARCHAR2(20)NCHAR(1)NCHAR(1)YINTEGERYNUMBER(4,2)YVARCHAR2(20)Y缺省值10TOCHAR(SYSDATE,MMDDHHMI:SS'主主键字段描述算单位编号[科目内置代码][公司科目名称]会计科目名称，不能[末级科目标识位][账簿首选样式][科目分类属性]SACC_CODE_CSACC_CODESCORPCODESACC_NAME_CBISJOUR_SUBJECTSOUTPUT_TEMPSACC_CLASS数据类型VARCHAR2(100)VARCHAR2(100)NUMBER)VARCHAR2(20)VARCHAR2(80)VARCHAR2(20)CHAR(1)VARCHAR2(4)VARCHAR2(4)可为空NYNNNYYYYY缺省值ICREDIT_DEBITN0[余额方向]0:借方CHAR(1)N[关闭标识位]CHAR(1)N[冻结标识位]CHAR(1)N金标识]BBANK_FLAGCHAR(10)N[银行帐标识]SAMOUNTUINTVARCHAR2(20)N[数量核算标识位]SPOSTCURVARCHAR2(20)N[记账币种代码]SDRIVENSUBJECTVARCHAR2(4)Y[控制科目标识]BITT_FLAGCHAR(1)N[集团内部往来标识位]SARAP_FLAGVARCHAR2(4)N[往来核算标识位]ITEMFLAGVARCHAR2(4)N[成本要素标识位]EPCHAR(1)N[部门核算标识位]VARCHAR2(20)Y[项目核算标识位VARCHAR2(20)Y[项目核算标识位VARCHAR2(20)Y[项目核算标识位VARCHAR2(20)Y业属性]VARCHAR2(8)Y[创建时间]创建时间BINISUBJECTCHAR(1)Y[初始科目标识位]VARCHAR2(20)Y[创建人]取当前操作员名称TSVARCHAR2(20)YTOCHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')ODEVARCHAR2(100)Y[上科目编码]CMSDOC_IDSDOC_NOSPERIODCODESCORPCODESDOC_TYPESEXPLAINNAPPENDDIXSPOSTEDBYSCHECKEDBYSENTRIEDBYSCASHIERETHODSCODESBILLNOTDBTDDDSPOSTEDFROMSCREDIT_ORG数据类型VARCHAR2(60)VARCHAR2(20)VARCHAR2(7)VARCHAR2(20)NUMBER)CHAR(8)CHAR(8)VARCHAR2(20)VARCHAR2(80)VARCHAR2(40)VARCHAR2(40)VARCHAR2(40)VARCHAR2(40)VARCHAR2(20)VARCHAR2(40)VARCHAR2(40)NUMBER(20,2)NUMBER(20,4)NUMBER(20,4)CHAR(1)CHAR(1)CHAR(1)VARCHAR2(4)VARCHAR2(60)可为空NNYNNNYNYNYYYYYYYNYYNNNNNY缺省值0000000'00主键字段描述√[凭证主键编号][凭证号]即凭证字第号[期间代码]:'XXXX-XX'[公司信息编码]证日期]账日期][凭证类型代码]考说明][附件数]说明附件张数[结算方式代码]缴款人][借方金额合计][工作量借方][工作量贷方][记账标识位][审核标识位][加锁标识位][凭证来源标识位][贷项处理标识位][贷项原凭证号]STSTRANSTYPEVARCHAR2(20)Y[原始交易类型]SBASEREFVARCHAR2(60)Y础参考]CHAR(10)Y账日期]NUMBER(20,2)Y[以外币记的总计]STRANSCODEVARCHAR2(40)Y[原始交易代码]TSVARCHAR2(20)YTOCHARSYSDATE,MMDDHH24:MI:SS')VARCHAR2(300)Y主键主键字段描述√[凭证主键编号][公司信息编码][科目代码]基础核算单位编号摘要]文本[借货方向](0:借方/1:贷方)[业务伙伴代码]唯一标识[计量单位代码][货币代码]各个货币的国际部门代码][成本要素标识位][项目分类代码]数据类型可为空VARCHAR2(60)NNUMBER(5)NVARCHAR2(20)NNUMBER(4)NVARCHAR2(100)NVARCHAR2(200)YINTEGERYVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(24)YVARCHAR2(20)YVARCHAR2(24)YSDOC_IDIDOC_LINE_IDSCORPCODESACC_CODE_CSBP_CODESUNIT_CODESCUR_ABVSDEPTCODESPJ_CLS_CODE1ODESPJ_CLS_CODE2ODE缺省值SPJ_CLS_CODE3ODESPJ_CLS_CODE4ODEEBITCREDITADEBITREDITDDDVCH_NOSPERSONCODEARNOTPRINTEDETHODSCODESBILLNOSOPPOSITE_ACCCODETSSGROUPCODEVARCHAR2(20)VARCHAR2(24)VARCHAR2(20)VARCHAR2(20)NUMBER(20,2)NUMBER(20,2)NUMBER(20,6)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,4)NUMBER(20,2)NUMBER(20,2)VARCHAR2(10)VARCHAR2(20)VARCHAR2(20)VARCHAR2(2)NUMBER(20,2)CHAR(8)CHAR(1)CHAR(1)VARCHAR2(20)VARCHAR2(20)VARCHAR2(20)VARCHAR2(20)VARCHAR2(20)VARCHAR2(36)YVARCHAR2(300)Y000000000TOCHARSYSDATE,MMDDHH24:MI:SS')[本位币借方][本位币贷方]外币汇率]外币借方]外币贷方]数量借方]数量贷方][工作量借方][工作量贷方]交易日期][交易凭证号]人员编号][未清理标识][未清理余额][上次付款日期][付款通知打印标识位][往来对账标识位][结算方式代码]收缴款人][对方科目代码]创建日期]分组编号]SACC_CODE_CSCORPCODESPERIODCODESCUR_ABVIOPEN_INDNOPEN_BALCLOSEINDCLOSINGBALNF_OPEN_BALEBITCREDITYDEBITNF_CLOSING_BALSUNIT_CODENA_OPEN_BALADEBITREDITDEBITNA_CLOSING_BAL数据类型VARCHAR2(100)VARCHAR2(20)VARCHAR2(7)NUMBER)VARCHAR2(20)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)VARCHAR2(20)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)NUMBER(20,2)可为空NNNNNYNNNYYYNYYYYYYYYYYYYY缺省值000000000000000000000主键字段描述√[公司科目代码]√[公司信息编码]√[期间代码]:'XXXX-XX'[货币代码]各个货币的国际简码[期初余额方向]期初余额][本期借方累计][本期贷方累计][本年借方累计][本年贷方累计][期末余额方向]期末余额][外币期初余额][本期外币借方累计][本期外币贷方累计][本年外币借方累计][本年外币贷方累计][期末外币余额][计量单位代码][数量期初余额][本期数量借方累计][本期数量贷方累计][本年数量借方累计][本年数量贷方累计][期末数量余额]NW_OPEN_BALNUMBER(20,2)Y0[工作量期初余额]NWDEBITNUMBER(20,2)Y0[本期工作量借方累计]CREDITNUMBER(20,2)Y0[本期工作量贷方累计]YDEBITNUMBER(20,2)Y0[本年工作量借方累计]TNUMBER(20,2)Y0[本年工作量贷方累计]NW_CLOSING_BALNUMBER(20,2)Y0[期末工作量余额]OPENPRICENUMBER(20,4)Y0[单价期初值]SINGPRICENUMBER(20,4)Y0[期末单价值]IOPEN_IND_UY0[包含未记账期初余额方向]NOPEN_BAL_UNUMBER(20,2)Y0[包含未记账期初余额]NDEBIT_UNUMBER(20,2)Y0[包含未记账本期借方累计]NCREDIT_UNUMBER(20,2)Y0[包含未记账本期贷方累计]NYDEBIT_UNUMBER(20,2)Y0[包含未记账本年借方累计]NYCREDIT_UNUMBER(20,2)Y0[包含未记账本年贷方累计]ICLOSE_IND_UY0[包含未记账期末余额方向]NCLOSING_BAL_UNUMBER(20,2)Y0[包含未记账期末余额]NF_OPEN_BAL_UNUMBER(20,2)Y0[包含未记账外币期初余额]NF_DEBIT_UNUMBER(20,2)Y0[包含未记账本期外币借方累NF_CREDIT_UNUMBER(20,2)Y0[包含未记账本期外币贷方累NF_YDEBIT_UNUMBER(20,2)Y0[包含未记账本年外币借方累NF_YCREDIT_UNUMBER(20,2)Y0[包含未记账本年外币贷方累NF_CLOSING_BAL_UNUMBER(20,2)Y0[包含未记账期末外币余额]SUNIT_CODE_UVARCHAR2(20)Y[包含未记账计量单位代码]NA_OPEN_BAL_UNUMBER(20,2)Y0[包含未记账数量期初余额]NA_DEBIT_UNUMBER(20,2)Y0[包含未记账本期数量借方累NA_CREDIT_UNUMBER(20,2)Y0[包含未记账本期数量贷方累NA_YDEBIT_UNUMBER(20,2)Y0[包含未记账本年数量借方累NA_YCREDIT_UNUMBER(20,2)Y0[包含未记账本年数量贷方累NA_CLOSING_BAL_UNUMBER(20,2)Y0[包含未记账期末数量余额]NW_OPEN_BAL_UNUMBER(20,2)Y0[包含未记账工作量期初余额]NW_DEBIT_UNUMBER(20,2)Y0[包含未记账本期工作量借方NW_CREDIT_UNUMBER(20,2)Y0[包含未记账本期工作量贷方NW_YDEBIT_UNUMBER(20,2)Y0[包含未记账本年工作量借方NW_YCREDIT_UNUMBER(20,2)Y0[包含未记账本年工作量贷方NW_CLOSING_BAL_UNUMBER(20,2)Y0[包含未记账期末工作量余额]TSVARCHAR2(20)YTOCHARSYSDATE,MMDDHH24:MI:SS')11.项目分类表GL_PJT_CLS(全量)缺省缺省值TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')主键字段描述√[项目分类代码]√[公司信息编码][项目分类名称]数据类型可为空VARCHAR2(20)NVARCHAR2(20)NVARCHAR2(40)YVARCHAR2(20)YSPJ_CLS_CODESCORPCODESPJ_CLS_NAMETS12.12.项目表GL_PJ_ITEM(全量)列名数据类型可为空缺省值主键字段描述TOCHARSYSDATE,'YYYY-MM-DDHH24:MI:SS')VARCHAR2(24)VARCHAR2(20)VARCHAR2(80)VARCHAR2(24)VARCHAR2(20)VARCHAR2(20)CHAR(1)VARCHAR2(24)VARCHAR2(20)VARCHAR2(200)SPROJECTCODESPROJECTNAMEODETSSCORPCODESSIMPLECODESSPELLSLEVELCODE目代码][项目分类代码]目名称]级代码]建日期][公司信息编码][末级标识位]YYYYYYY13.辅助余额表GL_SLG_BAL(增量)数数据类型可为空缺省值VARCHAR2(36)NVARCHAR2(20)NVARCHAR2(100)NNUMBER(4)NVARCHAR2(7)NVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(24)YVARCHAR2(20)YVARCHAR2(24)YVARCHAR2(20)YVARCHAR2(24)YVARCHAR2(20)YVARCHAR2(24)Y主键字段描述期间代码]部门代码]人员代码]往来代码]SSL_BAL_IDSCORPCODESACC_CODE_CSPERIODCODESDEPTCODESPERSONCODESBP_CODESPJ_CLS_CODE1SPROJECTCODE1SPJ_CLS_CODE2SPROJECTCODE2SPJ_CLS_CODE3SPROJECTCODE3SPJ_CLS_CODE4SPROJECTCODE4IOPEN_INDY0[期初余额方向]NOPEN_BALNUMBER(20,2)Y0期初余额]NUMBER(20,2)Y0[本期借方累计]NUMBER(20,2)Y0[本期贷方累计]CLOSEINDY0[期末余额方向]LNUMBER(20,2)Y0期末余额]FOPENBALNUMBER(20,2)Y0[外币期初余额]EBITNUMBER(20,2)Y0[本期外币借方累计]CREDITNUMBER(20,2)Y0[本期外币贷方累计]SINGBALNUMBER(20,2)Y0[期末外币余额]OPENBALNUMBER(20,2)Y0[数量期初余额]ADEBITNUMBER(20,2)Y0[本期数量借方累计]REDITNUMBER(20,2)Y0[本期数量贷方累计]INGBALNUMBER(20,2)Y0[期末数量余额]NW_OPEN_BALNUMBER(20,2)Y[工作量期初余额]NWDEBITNUMBER(20,2)Y[本期工作量借方累计]CREDITNUMBER(20,2)Y[本期工作量贷方累计]YDEBITNUMBER(20,2)Y[本年工作量借方累计]TNUMBER(20,2)Y[本年工作量贷方累计]WCLOSINGBALNUMBER(20,2)Y[期末工作量余额]IOPEN_IND_UY0[包含未记账期初余额方向]NOPEN_BAL_UNUMBER(20,2)Y0[包含未记账期初余额]NDEBIT_UNUMBER(20,2)Y0[包含未记账本期借方累计]NCREDIT_UNUMBER(20,2)Y0[包含未记账本期贷方累计]NYDEBIT_UNUMBER(20,2)Y0[包含未记账本年借方累计]NYCREDIT_UNUMBER(20,2)Y0[包含未记账本年贷方累计]ICLOSE_IND_UY0[包含未记账期末余额方向]NCLOSING_BAL_UNUMBER(20,2)Y0[包含未记账期末余额]NF_OPEN_BAL_UNUMBER(20,2)Y0[包含未记账外币期初余额]NF_DEBIT_UNUMBER(20,2)Y0[包含未记账本期外币借方NF_CREDIT_UNUMBER(20,2)Y0[包含未记账本期外币贷方NF_YDEBIT_UNUMBER(20,2)Y0[包含未记账本年外币借方NF_YCREDIT_UNUMBER(20,2)Y0[包含未记账本年外币贷方NF_CLOSING_BAL_UNUMBER(20,2)Y0[包含未记账期末外币余额]SUNIT_CODE_UVARCHAR2(20)Y[包含未记账计量单位代码]NA_OPEN_BAL_UNUMBER(20,2)Y0[包含未记账数量期初余额]NA_DEBIT_UNUMBER(20,2)Y0[包含未记账本期数量借方NA_CREDIT_UNUMBER(20,2)Y0[包含未记账本期数量贷方NA_YDEBIT_UNUMBER(20,2)Y0[包含未记账本年数量借方NA_YCREDIT_UNUMBER(20,2)Y0[包含未记账本年数量贷方NA_CLOSING_BAL_UNUMBER(20,2)Y0[包含未记账期末数量余额]NW_OPEN_BAL_UNUMBER(20,2)Y0[包含未记账工作量期数余NW_DEBIT_UNUMBER(20,2)Y0[包含未记账本期工作量借方累计]NW_CREDIT_UNUMBER(20,2)Y0[包含未记账本期工作量贷方累计]NW_YDEBIT_UNUMBER(20,2)Y0[包含未记账本年工作量借方累计]NW_YCREDIT_UNUMBER(20,2)Y0[包含未记账本年工作量贷方累计]NW_CLOSING_BAL_UNUMBER(20,2)Y0[包含未记账期末工作量余TSVARCHAR2(20)YTOCHARSYSDATE,创建日期]MMDDHH24:MI:SS')NUMBER(20,2)Y0[本年借方累计]NUMBER(20,2)Y0[本年贷方累计]YDEBITNUMBER(20,2)Y0NUMBER(20,2)Y0DEBITNUMBER(20,2)Y0NUMBER(20,2)Y014.部门信息表BD_DEPT(全量)SCORPCODESDEPTCODESDEPTNAMEPARENTDEPTCODESREMARKTSSSIMPLECODESSPELLSLEVELCODE字段描述√[公司信息编码]√门代码]门名称][上级部门代码]建日期][公司信息编码]数据类型VARCHAR2(20)VARCHAR2(20)VARCHAR2(60)VARCHAR2(20)VARCHAR2(100)VARCHAR2(20)VARCHAR2(20)CHAR(1)VARCHAR2(20)VARCHAR2(20)VARCHAR2(200)缺省值TOCHAR(SYSDATE,MMDDHHMI:SS'可为空NNYYYYYYYYY15.凭证类别表BD_DOC_TYPE(全量)主键主键字段描述√[凭证类别代码][凭证类别名称]SDOC_TYPE_CODESDOC_TYPE_NAMESSHORT_TEXT可为空缺省值NNY数据类型VARCHAR2(20)VARCHAR2(40)VARCHAR2(20)√[年份标识]制[打印默认模板]创建日期]SMUDOLESTYPESPRINTTEMPLATECODETSVARCHAR2(4)NUMBER)CHAR(1)VARCHAR2(38)VARCHAR2(20)TOCHAR(SYSDATE,MMDDHHMI:SS'YYYYY16.系统的枚举值表BD_SYSENUM(全量)缺缺省值主键字段描述[枚举项含义](系统内置)属模块][启用控制标识位]建日期]SCORPCODESENUM_CODESENUM_ITEMSENUM_CONTENTSMODULETS数据类型VARCHAR2(20)VARCHAR2(20)VARCHAR2(20)VARCHAR2(30)VARCHAR2(20)CHAR(1)VARCHAR2(20)可为空NNNNYYY17.客户供应商表BD_BP_M(全量)类型字段描述SCORPCODEVARCHAR2(20)NSBP_CODEVARCHAR2(20)NSBP_NAMEVARCHAR2(80)YECHAR(1)YBOCCASIONALBPCHAR(1)NCHAR(20)YSCLEARCURR_ABVVARCHAR2(10)YBBPFROZEN_FLAGCHAR(1)YBBPFROZEN_STMPVARCHAR2(8)YBBPCLOSED_FLAGCHAR(1)YSADDRESSADDRESSSPOSTCODESWEBSITESREFCORPCODEELTSVARCHAR2(80)VARCHAR2(20)VARCHAR2(40)VARCHAR2(20)VARCHAR2(20)VARCHAR2(20)VARCHAR2(20)TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')YYYYYYY18.资产分类表AM_ASSETCLASS(全量)字字段名字段类型可为空默认值字段描述SCORPCODEVARCHAR2(20)N套编码]SCLASSCODEVARCHAR2(20)N别编码]SCLASSNAMEVARCHAR2(100)别名称]NUMBER(5,4)[预计净残值率]NUMBER)[预计使用年限]SDEPRECIATIONCODEVARCHAR2(20)[缺省折旧方式]ENUMBER(6,4)折旧率]XTBZVARCHAR2(1)[4.2中的保留字]BZVARCHAR2(1)[4.2中的保留字][资本化方法标识]0表示当月初始化1表示次月初始化SORGACC_CODEVARCHAR2(20)[原值计入缺省科目代码]SDPREACC_CODEVARCHAR2(20)[折旧计入缺省科目代码]SUI_CODEVARCHAR2(20)面代码]NUMBER(5,4)[净残值率(JCZL)][[使用年限(SYNX)][折旧方法(ZJFF)][年折旧率(NZJL)][净残值率(JCZL)][使用年限(SYNX)][折旧方法(ZJFF)][年折旧率(NZJL)][编号规则代码]TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')SDEPRECIATIONCODE2SDEPRECIATIONCODE3SCRULE_CODETSNUMBER)VARCHAR2(20)NUMBER(4,2)NUMBER(3,2)NUMBER)VARCHAR2(20)NUMBER(4,2)VARCHAR2(20)VARCHAR2(20)字字段名字段类型可为空默认值字段描述SCONTENTS_CODEVARCHAR2(20)N录编码]SCLASSCODEVARCHAR2(20)别编码]SCORPCODEVARCHAR2(20)N套编码]SCONTENTSVARCHAR2(100)录名称]SUNIT_CODEVARCHAR2(20)[计量单位一]SUNIT_CODE2VARCHAR2(20)[计量单位二]SPECIFICATIONVARCHAR2(20)格型号]NUMBER(20,2)省原价]NUMBER(20,2)[预计使用年限]SCTL_CODEVARCHAR2(20)[成本对象代码默认值]HSPECIATIONVARCHAR2(40)[技术特征默认值]1[资本化方法标识]0表示当月初始化1表示次月初始化NUMBER(6,5)[净残值率(JCZL)]ENUMBER(6,4)[年折旧率(NZJL)]EVARCHAR2(20)[[末级]"Y"表示是"N"表[原值计入缺省科目代码][折旧计入缺省科目代码][净残值率(JCZL)][使用年限(SYNX)][折旧方法(ZJFF)][年折旧率(NZJL)][净残值率(JCZL)][使用年限(SYNX)][折旧方法(ZJFF)][年折旧率(NZJL)][折旧方法(ZJFF)][减值标识]"Y"表示是"N"表是否INALLEVELSORGACC_CODESDPREACC_CODESDEPRECIATIONCODE2SDEPRECIATIONCODE3SDEPRECIATIONCODETSCHAR(1)NUMBERNVARCHAR2(20)VARCHAR2(20)NUMBER(3,2)NUMBER)VARCHAR2(20)NUMBER(4,2)NUMBER(3,2)NUMBER)VARCHAR2(20)NUMBER(4,2)VARCHAR2(20)CHAR(1)VARCHAR2(20)TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')20.成本对象AM_COSTOBJECT(全量)字字段名字段类型可为空默认值字段描述SCOSTOBJECT_CODESCOSTOBJECT_NAMEVARCHAR2(20)VARCHAR2(20)N[成本对象编码][成本对象名称]SCORPCODEVARCHAR2(20)N帐套编码]SGETVALUEEXPVARCHAR2(20)[取值表达式]SCOSACC_CODEVARCHAR2(20)[缺省科目代码]TSVARCHAR2(20)TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')21.资产变动履历表AM_TRANSACTION(增量)字段名字段类型可为空默认值字段描述SPERIODCODEVARCHAR2(7)NSCORPCODEVARCHAR2(20)N套编码]SASSETS_CODEVARCHAR2(40)N产编号]SMASTERCARD_CODEVARCHAR2(20)N片编号]SHANDBYVARCHAR2(20)YSREASONVARCHAR2(50)Y动说明]VARCHAR2(10)N动日期]NUMBER(4)N0SCONTENTS_CODEVARCHAR2(20)N[资产目录代码]VARCHAR2(20)N动类型]SDESCRIPTIONVARCHAR2(200)Y产名称]SM_UNITVARCHAR2(20)Y[计量单位一]SS_UNITVARCHAR2(20)Y[计量单位二]SDEPR_CODE_TVARCHAR2(20)Y[折旧方式一]SDEPR_CODE_MVARCHAR2(20)Y[折旧方式二]TNUMBER(3)Y0[预计使用年限一]ATIONMNUMBER(3)Y0[预计使用年限LOADTNUMBER(20,2)Y0[预计工作量一]NWORKLOAD_MNUMBER(20,2)Y0[预计工作量二]NUMBER(8,6)Y0[预计净残率值一]NRESIDUALS_RATE_MNUMBER(8,6)Y0[预计净残率值NUMBER(8,6)Y0折旧率]EPRECIATIONRATEMNUMBER(8,6)Y0[管理年折旧率]NUMBER(20,2)Y0动原价]PSETUP_FEENUMBER(20,2)Y0VARCHAR2(7)Y账年月]NPOST_NUMBER1NUMBER(10,3)Y0[变动数量一]NPOSTNUMBER2NUMBER(10,3)Y0[变动数量二]NDEPR_WHENPOSTED_TNUMBER(13,2)Y0[入账时累计折NDEPR_WHENPOSTED_MNUMBER(13,2)Y0[入账时管理累计折旧]ETVALUEPOSTEDTNUMBER(20,2)Y0[入账时净值]NNETVALUE_POSTED_MNUMBER(20,2)Y0[入账时管理净NUMBER(13,2)Y0计折旧]NDEPRECIATION_MNUMBER(13,2)Y0[管理累计折旧]NUMBER(20,2)Y0NNETVAUE_MNUMBER(20,2)Y0理净值]ALSVALUETNUMBER(20,2)Y0NRESIDUALS_VALUE_MNUMBER(20,2)Y0[管理净残值]NDEPR_WORKLOAD_TNUMBER(20,2)Y0[入账时工作量]NDEPR_WORKLOAD_MNUMBER(20,2)Y0[入账时管理净NUSEDMONTHY0[已使用期间]NDEPR_WORKLOAD_T1NUMBER(20,2)Y0[入账时工作量一]NDEPR_WORKLOAD_M1NUMBER(20,2)Y0[入账时工作量NUMBER(20,2)Y0估净值]EPRNUMBER(20,2)Y0[评估累计折旧]TESETUPFEENUMBER(20,2)Y0[评估安装费]DLIFENUMBER(10,3)Y0[评估使用年限]NUMBER(20,2)Y0[评估折旧率]NUMBER(20,2)Y0SPECIFICATIONLORSTECH_LICENCESMANUFACTURERSPRODUCTIONNOSTECH_DESCRIPTIONSKEEPERSUSEAGE_CODEBLEASEFLAGSDEPTCODEBMITILDEPTFLAGSLICENCESTRANSACTIONCODENUMBER(8,6)YVARCHAR2(30)YVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(100)YVARCHAR2(7)YVARCHAR2(20)YVARCHAR2(30)YVARCHAR2(100)YVARCHAR2(20)YVARCHAR2(30)YVARCHAR2(30)YVARCHAR2(1)YVARCHAR2(20)YVARCHAR2(1)YYYVARCHAR2(YYVARCHAR2(1)VARCHAR2(36)N0值(即资产减少价值)][变动的评估税务残值率]格型号]术证书]产证书]造日期]厂编号]术特征]置地点]用用途]济用途][融资标识]"Y"表用部门][变动的多部门使用标识]"Y"表可证书][变动的折旧状"Y"表示需要计不需要计提折旧[变动的业务编ATCHFLAGCOLUMN_69COLUMN_70COLUMN_71COLUMN_72COLUMN_73COLUMN_74SPOSTED_FLAGSCOSTOBJECT_CODEDUALSUNITSBUSINESSAREATS0TO_CHAR(SYSDATE,'YYYY/MM/DDHH4:MI:SS')号(业务流水号)]账标识]本对象][个别折旧标识]提基数]量单位][升级数据标识]务对象]CHAR(10)CHAR(10)CHAR(10)CHAR(10)CHAR(10)CHAR(10)CHAR(1)VARCHAR2(20)CHAR(1)NUMBER(20,2)VARCHAR2(20)CHAR(1)VARCHAR2(20)VARCHAR2(20)YYYYYYYYYYYYYYY22.折旧记录表AM_DEPRECIATION(增量)字段名字段名字段类型可为空默认值字段描述SCORPCODEVARCHAR2(20)N套编码]SASSETS_CODEVARCHAR2(40)N产编号]SMASTERCARD_CODEVARCHAR2(20)N片编码]SPERIOD_CODEVARCHAR2(7)N旧期间]NUMBER(20,2)0月折旧]LOADTNUMBER(20,4)0[折旧工作量]NUMBER(20,2)0[当月累计折旧]NUMBER(20,2)Y0提基数]NDEPRECIATION_MNUMBER(20,2)00000TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')NWORKLOAD_MRKLOADTNWORKLOAD_M2TSNUMBER(20,4)NUMBER(20,4)NUMBER(20,4)VARCHAR2(20)AMMASTERDATA全量)字段名字段类型可为空默认值字段描述SCORPCODEVARCHAR2(20)N套编码]SCLASSCODEVARCHAR2(20)别编码]SCONTENTS_CODEVARCHAR2(20)N录编码]SASSETS_CODEVARCHAR2(40)N产编号]SMASTERCARD_CODEVARCHAR2(20)片编码]SBUSINESSAREAVARCHAR2(20)务对象]VARCHAR2(20)态类型]SUSEAGE_CODEVARCHAR2(30)济用途]BDEPINONEMONTHCHAR(1)本列支]CHAR(1)否新品]SCOSTOBJECT_CODEVARCHAR2(20)本对象]VARCHAR2(20)前状态]SDESCRIPTIONVARCHAR2(200)产名称]SM_UNITVARCHAR2(20)[计量单位一]SS_UNITVARCHAR2(20)[计量单位二]SDEPR_CODE_TVARCHAR2(20)[折旧方式编码]TNUMBER)0[预计使用年限]LOADTNUMBER(20,2)0[预计工作量]NUMBER(8,6)0残值率]NUMBER(8,6)0折旧率]NUMBER(20,2)0账原价]PSETUP_FEENUMBER(20,2)0NOTHEREXPENSENUMBER(10,3)0他费用]VARCHAR2(10)[交付使用年月]NPOST_NUMBER1NUMBER(10,3)0[入账数量一]NPOSTNUMBER2NUMBER(10,3)0[入账数量二]NDEPR_WHENPOSTED_TNUMBER(13,2)0[入账累计折旧]ETVALUEPOSTEDTNUMBER(20,2)0账净值]NUMBER(13,2)0[累计折旧(月初)]NUMBER(20,2)0产净值]ALSVALUETNUMBER(20,2)0NDEPR_WORKLOAD_TNUMBER(20,2)0[折旧工作量]NUSEDMONTHNUMBER(20,2)0使用月]NUMBER(20,2)0估价值]EPRNUMBER(20,2)0[重复累计折旧]TESETUPFEENUMBER(20,2)0[重估安装费]DLIFENUMBER(10,3)0[重复预计年限]NUMBER(20,2)0[重估可回收价NUMBER(8,6)0[重估净残值率]SPECIFICATIONVARCHAR2(80)格型号]LORVARCHAR2(20)STECH_LICENCEVARCHAR2(20)术证书]SMANUFACTURERVARCHAR2(100)造单位]VARCHAR2(10)造年月]VARCHAR2(10)账年月]SPRODUCTIONNOVARCHAR2(20)产编号]STECH_DESCRIPTIONVARCHAR2(70)术特征]VARCHAR2(100)置地点]SKEEPERVARCHAR2(20)VARCHAR2(30)[使用状态编码]BLEASEFLAGVARCHAR2(1)资标识]SDEPTCODEVARCHAR2(20)门编码]BMITILDEPTFLAGVARCHAR2(1)[多部门标识]SLICENCEVARCHAR2(30)VARCHAR2(1)旧标识]BDEADFLAGCHAR(1)出标识]NUMBER(20,2)0[有偿调拨价]SDEPR_DIS_METHODVARCHAR2(20)N[折旧分摊方式]SPOSTED_FLAGCHAR(1)N账标识]CHAR(1)[减值准备标识]NUMBER(13,2)0[累计减值(月初)]STRANSACTIONDISCVARCHAR2(40)0态编码]ZKNYVARCHAR2(7)卡年月]RYVARCHAR2(20)DUALCHAR(1)[个别折旧标志]NUMBER(20,2)0[折旧计提基数]NUMBER(20,2)0计原价]VARCHAR2(7)卡年月]NUMBER(20,2)0[累计折旧(实时)]TNUMBER(13,2)0[累计减值(实时)]CHAR(1)据版本]ERVEDEPRECIATIONNUMBER(20,2)0[减值累计折旧]SDEPR_CODE_MVARCHAR2(20)ATIONMNUMBER)0RKLOADTNUMBER(20,2)0NWORKLOAD_MNUMBER(20,2)0NRESIDUALS_RATE_MNUMBER(8,6)0EPRECIATIONRATEMNUMBER(8,6)0NDEPR_WHENPOSTED_MNUMBER(13,2)0NNETVALUE_POSTED_MNUMBER(20,2)0NDEPRECIATION_MNUMBER(13,2)0NNETVAUE_MNUMBER(20,2)0NRESIDUALS_VALUE_MNUMBER(20,2)0NDEPR_WORKLOAD_MNUMBER(20,2)0NDEPR_WORKLOAD_T1NUMBER(20,2)0NDEPR_WORKLOAD_M1NUMBER(20,2)0COLUMN_87VARCHAR2(30)COLUMN_88VARCHAR2(30)COLUMN_89VARCHAR2(30)COLUMN_90VARCHAR2(30)COLUMN_91VARCHAR2(30)COLUMN_92VARCHAR2(30)COLUMN_93VARCHAR2(30)COLUMN_94VARCHAR2(30)COLUMN_95VARCHAR2(30)COLUMN_96VARCHAR2(30)COLUMN_97NUMBER(20,4)0COLUMN_98NUMBER(20,4)0COLUMN_99NUMBER(20,4)0COLUMN_100NUMBER(20,4)0COLUMN_102NUMBER(20,4)0COLUMN_103NUMBER(20,4)0COLUMN_104NUMBER(20,4)0COLUMN_105NUMBER(20,4)0COLUMN_106NUMBER(20,4)0COLUMN_107NUMBER(20,4)0COLUMN_108VARCHAR2(10)COLUMN_109VARCHAR2(10)COLUMN_110VARCHAR2(10)COLUMNCOLUMN_111VARCHAR2(10)COLUMN_112VARCHAR2(10)TSVARCHAR2(20)TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')STRANSACTIONCODEVARCHAR2(36)SUNITVARCHAR2(20)24.放置地点表AM_LOCATION(全量)字段字段名字段类型可为空默认值字段描述Y号VARCHAR2(200)Y地点名称25.大修记录表AM_MAINTANCE(增量)字段字段名字段类型可为空默认值字段描述NTANCEIDVARCHAR2(36)NSCORPCODEVARCHAR2(20)Y套编码]SASSETS_CODEVARCHAR2(40)Y产编号]SMASTERCARD_CODEVARCHAR2(20)Y片编号]NUMBER(20,2)Y修费用]CHAR(10)Y修日期]NUMBER(12,2)Y[维修工作量]SUNITCODEVARCHAR2(20)Y量单位]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')26.减值准备表AM_RESERVE_DEP(增量)字段类型字段类型可为空默认值VARCHAR2(36)YVARCHAR2(20)N字段名STRANSACTIONCODESCORPCODE字段描述态编号]套编码]SASSETSSASSETS_CODEVARCHAR2(40)N产编号]SMASTERCARD_CODEVARCHAR2(20)N片编号]SPERIODCODEVARCHAR2(20)NNUMBER(4)NSRESERVEDESPVARCHAR2(40)Y值说明]SRESERVETYPEVARCHAR2(30)N'RESERVE_BASEON_CLASS_2'值类型]NUMBER(13,2)Y值金额]NUMBER(13,2)Y[累计减值金额]NROLLBACKAMOUNTNUMBER(13,2)Y滚金额]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')SPOSTED_FLAGCHAR(1)Y账标识]VALUENUMBER(13,2)Y[可回收价值]NUMBER(13,2)YVARCHAR2(20)Y[预计提足年月]NUMBER(8,6)Y0[减值时年折旧率]ERVEDEPRECIATIONNUMBER(20,2)Y0[减值时累计折旧]AMSTATUS)字字段描述帐套编码][作用用途编码][作用用途名称][折旧计提标识(ZJBZ)]"Y"表示计提"N"表示[折旧影响到时机]0：影响当月的折旧计提1：影响次月的折旧计提字段类型可为空VARCHAR2(20)NVARCHAR2(20)NVARCHAR2(20)YCHAR(1)YSCORPCODEIDEPRECATEFLAG默认值1YTOTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')VARCHAR2(20)YTS28.经济用途表AM_USAGE(全量)字字段名字段类型可为空默认值字段描述SUSEAGE_CODEVARCHAR2(20)N[经济用途编码]SUAGE_NAMEVARCHAR2(60)Y[经济用途名称]SCORPCODEVARCHAR2(20)N帐套编码]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')29.资产附件表AM_ACCESSORY(全量)字字段名字段类型可为空默认值字段描述SCORPCODEVARCHAR2(20)N编码]SASSETS_CODEVARCHAR2(40)N编号]SMASTERCARD_CODEVARCHAR2(20)N编号]SACCESSORY_CODEVARCHAR2(20)N编码]SACCESSORY_NAMEVARCHAR2(40)Y名称]SPECIFICATIONVARCHAR2(20)Y型号]SUNIT_CODEVARCHAR2(20)Y单位]UNTNUMBER(20,4)YNUMBER(20,4)YTSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')30.资产附件履历表AM_ACCESSORYHISTORY(全量)字字段名字段类型可为空默认值字段描述VARCHAR2(36)NVARCHAR2(20)N类型]VARCHAR2(10)N日期]套编码]产编号]片编号]件编号]件名称]格型号]量单位]TO_CHAR(SYSDATE,'YYYY/MM/DDHH4:MI:SS')SCORPCODESASSETS_CODESMASTERCARD_CODESACCESSORY_CODESACCESSORY_NAMESPECIFICATIONSUNIT_CODEUNTTSVARCHAR2(20)VARCHAR2(40)VARCHAR2(20)VARCHAR2(20)VARCHAR2(40)VARCHAR2(20)VARCHAR2(20)NUMBER(20,4)NUMBER(20,4)VARCHAR2(20)YYYYYY31.折旧方式AM_DEPRECIATIONTYPE(全量)默认值默认值字段描述套编码][折旧方式名称][折旧方式代码][折旧方式公式表达式][计提基数公式][折旧率公式]字段名SCORPCODEDEPRECIATION_IDECIATIONNAMERECIATIONFUNCODEDEPRECIATION_FUNEXPREDEPRECIATION_BASE_FUNEFUNEPRECIATIONREMARK字段类型VARCHAR2(20)VARCHAR2(20)VARCHAR2(50)VARCHAR2(200)VARCHAR2(200)VARCHAR2(500)VARCHAR2(500)VARCHAR2(50)可为空NNNYNYYY32.工资类别表WA_CLASS(全量)字段字段名字段类型可为空默认值字段描述SCORPCODEVARCHAR2(20)N代码]SCLASSCODEVARCHAR2(20)N代码]SCLASSNAMEVARCHAR2(60)Y[类别名称]SESEDITUSERVARCHAR2(36)Y[最后被修改用户代码]SEDITTIMEVARCHAR2(20)Y[最后被修改时间]CHAR(1)Y[默认当前]1默认0不默认SUSEDCHAR(1)Y用，默认1SCORPCODESPERSONIDSPERSONCODESPERSONNAMESPOLITICALSCARDNOSPHONENOSDEPTCODESDEPTNAMESCLASSCODEBBUSINESSAGENTLG字段类型可为空VARCHAR2(20)YVARCHAR2(20)NVARCHAR2(36)NVARCHAR2(20)YVARCHAR2(60)YYVARCHAR2(10)VARCHAR2(20)YCHAR(10)YCHAR(10)YVARCHAR2(60)YVARCHAR2(60)YVARCHAR2(20)YVARCHAR2(20)YVARCHAR2(20)YCHAR(10)YVARCHAR2(10)YCHAR(10)YVARCHAR2(60)YVARCHAR2(60)YVARCHAR2(60)Y默认值字段描述司代码]套代码]员内码]员代码]员名称]治面貌]生日期]路日期]份证号]份证号]门代码]门名称][工资类别代码][业务员标识]"Y"表示为业务员"N"表示非业务员，默认为"N"[停发标志]1停发0发放[启用控制识位]如果该标识位为:'1'表示被员扩展]员扩展]员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]VARCHAR2(60)Y员扩展]SPERIODCODECHAR(7)N间代码]CVARCHAR2(60)Y[项目外扩展]VARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]VARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]VARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]VARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]VARCHAR2(60)Y[项目外扩展]VARCHAR2(60)Y[项目外扩展]VARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]CVARCHAR2(60)Y[项目外扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0目扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)Y0扩展]NUMBER(16,4)