財(cái)務(wù)管理-會(huì)計(jì)核算系統(tǒng)-接口數(shù)據(jù)表表結(jié)構(gòu)

數(shù)據(jù)類型可為空缺省值字段描述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[是否集團(tuán)單位]SPARENTCODEVARCHAR2(20)Y[上級(jí)單位編碼]SALLPARENTCODEVARCHAR2(2000)Y[所有上級(jí)編碼]SGROUPCODEVARCHAR2(20)Y團(tuán)代碼]SPROPERTYVARCHAR2(50)Y[產(chǎn)權(quán)登記碼]SFIELDCODEVARCHAR2(20)Y部分類]SBIZAREACODE1VARCHAR2(20)Y[內(nèi)部分類編碼值]SFIELDCODE2VARCHAR2(20)Y位地區(qū)]SBIZAREACODE2VARCHAR2(20)Y[單位地區(qū)代碼值]SFIELDCODE3VARCHAR2(20)Y[基層單位代碼]SBIZAREACODE3VARCHAR2(20)Y[基層單位代碼值]SFIELDCODE4VARCHAR2(20)Y位屬性]SBIZAREACODE4VARCHAR2(20)Y[單位屬性值]SFIELDCODE5VARCHAR2(20)Y在省份]SBIZAREACODE5VARCHAR2(20)Y[所在省份值]NSHAREHOLDNUMBER(5,4)Y權(quán)比率][[單位管理組][單位人員管理組]始日期]束日期]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')字段描述套編碼]套名稱]位編碼]業(yè)屬性]否停用]用原因]務(wù)編碼][是否標(biāo)準(zhǔn)科目]始日期]效日期]團(tuán)帳套]數(shù)據(jù)類型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(全量)數(shù)據(jù)類型可為空缺省值字段描述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.會(huì)計(jì)期間子表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.會(huì)計(jì)期間主表BD_FYEARSTRUCT_M(全量)類型可為空字段描述NUMBERNCHAR(8)YCHAR(8)YIPERIODNUMNUMBERYCHAR(1)YYEARCHAR(1)YTSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')6.貨幣檔案表BD_CURRENCY(全量)主鍵主鍵字段描述貨幣名稱][本位幣標(biāo)識(shí)位][貨幣標(biāo)識(shí)符]換算方式][TS]創(chuàng)建日期SCUR_ABVSCURRENCYATURALFLAGURFLAGIEXCHANGERATE_METHODNCETS數(shù)據(jù)類型可為空VARCHAR2(20)NVARCHAR2(20)NCHAR(1)NCHAR(1)YINTEGERYNUMBER(4,2)YVARCHAR2(20)Y缺省值10TOCHAR(SYSDATE,MMDDHHMI:SS'主主鍵字段描述算單位編號(hào)[科目?jī)?nèi)置代碼][公司科目名稱]會(huì)計(jì)科目名稱，不能[末級(jí)科目標(biāo)識(shí)位][賬簿首選樣式][科目分類屬性]SACC_CODE_CSACC_CODESCORPCODESACC_NAME_CBISJOUR_SUBJECTSOUTPUT_TEMPSACC_CLASS數(shù)據(jù)類型VARCHAR2(100)VARCHAR2(100)NUMBER)VARCHAR2(20)VARCHAR2(80)VARCHAR2(20)CHAR(1)VARCHAR2(4)VARCHAR2(4)可為空NYNNNYYYYY缺省值ICREDIT_DEBITN0[余額方向]0:借方CHAR(1)N[關(guān)閉標(biāo)識(shí)位]CHAR(1)N[凍結(jié)標(biāo)識(shí)位]CHAR(1)N金標(biāo)識(shí)]BBANK_FLAGCHAR(10)N[銀行帳標(biāo)識(shí)]SAMOUNTUINTVARCHAR2(20)N[數(shù)量核算標(biāo)識(shí)位]SPOSTCURVARCHAR2(20)N[記賬幣種代碼]SDRIVENSUBJECTVARCHAR2(4)Y[控制科目標(biāo)識(shí)]BITT_FLAGCHAR(1)N[集團(tuán)內(nèi)部往來(lái)標(biāo)識(shí)位]SARAP_FLAGVARCHAR2(4)N[往來(lái)核算標(biāo)識(shí)位]ITEMFLAGVARCHAR2(4)N[成本要素標(biāo)識(shí)位]EPCHAR(1)N[部門(mén)核算標(biāo)識(shí)位]VARCHAR2(20)Y[項(xiàng)目核算標(biāo)識(shí)位VARCHAR2(20)Y[項(xiàng)目核算標(biāo)識(shí)位VARCHAR2(20)Y[項(xiàng)目核算標(biāo)識(shí)位VARCHAR2(20)Y業(yè)屬性]VARCHAR2(8)Y[創(chuàng)建時(shí)間]創(chuàng)建時(shí)間BINISUBJECTCHAR(1)Y[初始科目標(biāo)識(shí)位]VARCHAR2(20)Y[創(chuàng)建人]取當(dāng)前操作員名稱TSVARCHAR2(20)YTOCHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')ODEVARCHAR2(100)Y[上科目編碼]CMSDOC_IDSDOC_NOSPERIODCODESCORPCODESDOC_TYPESEXPLAINNAPPENDDIXSPOSTEDBYSCHECKEDBYSENTRIEDBYSCASHIERETHODSCODESBILLNOTDBTDDDSPOSTEDFROMSCREDIT_ORG數(shù)據(jù)類型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主鍵字段描述√[憑證主鍵編號(hào)][憑證號(hào)]即憑證字第號(hào)[期間代碼]:'XXXX-XX'[公司信息編碼]證日期]賬日期][憑證類型代碼]考說(shuō)明][附件數(shù)]說(shuō)明附件張數(shù)[結(jié)算方式代碼]繳款人][借方金額合計(jì)][工作量借方][工作量貸方][記賬標(biāo)識(shí)位][審核標(biāo)識(shí)位][加鎖標(biāo)識(shí)位][憑證來(lái)源標(biāo)識(shí)位][貸項(xiàng)處理標(biāo)識(shí)位][貸項(xiàng)原憑證號(hào)]STSTRANSTYPEVARCHAR2(20)Y[原始交易類型]SBASEREFVARCHAR2(60)Y礎(chǔ)參考]CHAR(10)Y賬日期]NUMBER(20,2)Y[以外幣記的總計(jì)]STRANSCODEVARCHAR2(40)Y[原始交易代碼]TSVARCHAR2(20)YTOCHARSYSDATE,MMDDHH24:MI:SS')VARCHAR2(300)Y主鍵主鍵字段描述√[憑證主鍵編號(hào)][公司信息編碼][科目代碼]基礎(chǔ)核算單位編號(hào)摘要]文本[借貨方向](0:借方/1:貸方)[業(yè)務(wù)伙伴代碼]唯一標(biāo)識(shí)[計(jì)量單位代碼][貨幣代碼]各個(gè)貨幣的國(guó)際部門(mén)代碼][成本要素標(biāo)識(shí)位][項(xiàng)目分類代碼]數(shù)據(jù)類型可為空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')[本位幣借方][本位幣貸方]外幣匯率]外幣借方]外幣貸方]數(shù)量借方]數(shù)量貸方][工作量借方][工作量貸方]交易日期][交易憑證號(hào)]人員編號(hào)][未清理標(biāo)識(shí)][未清理余額][上次付款日期][付款通知打印標(biāo)識(shí)位][往來(lái)對(duì)賬標(biāo)識(shí)位][結(jié)算方式代碼]收繳款人][對(duì)方科目代碼]創(chuàng)建日期]分組編號(hào)]SACC_CODE_CSCORPCODESPERIODCODESCUR_ABVIOPEN_INDNOPEN_BALCLOSEINDCLOSINGBALNF_OPEN_BALEBITCREDITYDEBITNF_CLOSING_BALSUNIT_CODENA_OPEN_BALADEBITREDITDEBITNA_CLOSING_BAL數(shù)據(jù)類型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'[貨幣代碼]各個(gè)貨幣的國(guó)際簡(jiǎn)碼[期初余額方向]期初余額][本期借方累計(jì)][本期貸方累計(jì)][本年借方累計(jì)][本年貸方累計(jì)][期末余額方向]期末余額][外幣期初余額][本期外幣借方累計(jì)][本期外幣貸方累計(jì)][本年外幣借方累計(jì)][本年外幣貸方累計(jì)][期末外幣余額][計(jì)量單位代碼][數(shù)量期初余額][本期數(shù)量借方累計(jì)][本期數(shù)量貸方累計(jì)][本年數(shù)量借方累計(jì)][本年數(shù)量貸方累計(jì)][期末數(shù)量余額]NW_OPEN_BALNUMBER(20,2)Y0[工作量期初余額]NWDEBITNUMBER(20,2)Y0[本期工作量借方累計(jì)]CREDITNUMBER(20,2)Y0[本期工作量貸方累計(jì)]YDEBITNUMBER(20,2)Y0[本年工作量借方累計(jì)]TNUMBER(20,2)Y0[本年工作量貸方累計(jì)]NW_CLOSING_BALNUMBER(20,2)Y0[期末工作量余額]OPENPRICENUMBER(20,4)Y0[單價(jià)期初值]SINGPRICENUMBER(20,4)Y0[期末單價(jià)值]IOPEN_IND_UY0[包含未記賬期初余額方向]NOPEN_BAL_UNUMBER(20,2)Y0[包含未記賬期初余額]NDEBIT_UNUMBER(20,2)Y0[包含未記賬本期借方累計(jì)]NCREDIT_UNUMBER(20,2)Y0[包含未記賬本期貸方累計(jì)]NYDEBIT_UNUMBER(20,2)Y0[包含未記賬本年借方累計(jì)]NYCREDIT_UNUMBER(20,2)Y0[包含未記賬本年貸方累計(jì)]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[包含未記賬計(jì)量單位代碼]NA_OPEN_BAL_UNUMBER(20,2)Y0[包含未記賬數(shù)量期初余額]NA_DEBIT_UNUMBER(20,2)Y0[包含未記賬本期數(shù)量借方累NA_CREDIT_UNUMBER(20,2)Y0[包含未記賬本期數(shù)量貸方累NA_YDEBIT_UNUMBER(20,2)Y0[包含未記賬本年數(shù)量借方累NA_YCREDIT_UNUMBER(20,2)Y0[包含未記賬本年數(shù)量貸方累NA_CLOSING_BAL_UNUMBER(20,2)Y0[包含未記賬期末數(shù)量余額]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.項(xiàng)目分類表GL_PJT_CLS(全量)缺省缺省值TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')主鍵字段描述√[項(xiàng)目分類代碼]√[公司信息編碼][項(xiàng)目分類名稱]數(shù)據(jù)類型可為空VARCHAR2(20)NVARCHAR2(20)NVARCHAR2(40)YVARCHAR2(20)YSPJ_CLS_CODESCORPCODESPJ_CLS_NAMETS12.12.項(xiàng)目表GL_PJ_ITEM(全量)列名數(shù)據(jù)類型可為空缺省值主鍵字段描述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目代碼][項(xiàng)目分類代碼]目名稱]級(jí)代碼]建日期][公司信息編碼][末級(jí)標(biāo)識(shí)位]YYYYYYY13.輔助余額表GL_SLG_BAL(增量)數(shù)數(shù)據(jù)類型可為空缺省值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主鍵字段描述期間代碼]部門(mén)代碼]人員代碼]往來(lái)代碼]SSL_BAL_IDSCORPCODESACC_CODE_CSPERIODCODESDEPTCODESPERSONCODESBP_CODESPJ_CLS_CODE1SPROJECTCODE1SPJ_CLS_CODE2SPROJECTCODE2SPJ_CLS_CODE3SPROJECTCODE3SPJ_CLS_CODE4SPROJECTCODE4IOPEN_INDY0[期初余額方向]NOPEN_BALNUMBER(20,2)Y0期初余額]NUMBER(20,2)Y0[本期借方累計(jì)]NUMBER(20,2)Y0[本期貸方累計(jì)]CLOSEINDY0[期末余額方向]LNUMBER(20,2)Y0期末余額]FOPENBALNUMBER(20,2)Y0[外幣期初余額]EBITNUMBER(20,2)Y0[本期外幣借方累計(jì)]CREDITNUMBER(20,2)Y0[本期外幣貸方累計(jì)]SINGBALNUMBER(20,2)Y0[期末外幣余額]OPENBALNUMBER(20,2)Y0[數(shù)量期初余額]ADEBITNUMBER(20,2)Y0[本期數(shù)量借方累計(jì)]REDITNUMBER(20,2)Y0[本期數(shù)量貸方累計(jì)]INGBALNUMBER(20,2)Y0[期末數(shù)量余額]NW_OPEN_BALNUMBER(20,2)Y[工作量期初余額]NWDEBITNUMBER(20,2)Y[本期工作量借方累計(jì)]CREDITNUMBER(20,2)Y[本期工作量貸方累計(jì)]YDEBITNUMBER(20,2)Y[本年工作量借方累計(jì)]TNUMBER(20,2)Y[本年工作量貸方累計(jì)]WCLOSINGBALNUMBER(20,2)Y[期末工作量余額]IOPEN_IND_UY0[包含未記賬期初余額方向]NOPEN_BAL_UNUMBER(20,2)Y0[包含未記賬期初余額]NDEBIT_UNUMBER(20,2)Y0[包含未記賬本期借方累計(jì)]NCREDIT_UNUMBER(20,2)Y0[包含未記賬本期貸方累計(jì)]NYDEBIT_UNUMBER(20,2)Y0[包含未記賬本年借方累計(jì)]NYCREDIT_UNUMBER(20,2)Y0[包含未記賬本年貸方累計(jì)]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[包含未記賬計(jì)量單位代碼]NA_OPEN_BAL_UNUMBER(20,2)Y0[包含未記賬數(shù)量期初余額]NA_DEBIT_UNUMBER(20,2)Y0[包含未記賬本期數(shù)量借方NA_CREDIT_UNUMBER(20,2)Y0[包含未記賬本期數(shù)量貸方NA_YDEBIT_UNUMBER(20,2)Y0[包含未記賬本年數(shù)量借方NA_YCREDIT_UNUMBER(20,2)Y0[包含未記賬本年數(shù)量貸方NA_CLOSING_BAL_UNUMBER(20,2)Y0[包含未記賬期末數(shù)量余額]NW_OPEN_BAL_UNUMBER(20,2)Y0[包含未記賬工作量期數(shù)余NW_DEBIT_UNUMBER(20,2)Y0[包含未記賬本期工作量借方累計(jì)]NW_CREDIT_UNUMBER(20,2)Y0[包含未記賬本期工作量貸方累計(jì)]NW_YDEBIT_UNUMBER(20,2)Y0[包含未記賬本年工作量借方累計(jì)]NW_YCREDIT_UNUMBER(20,2)Y0[包含未記賬本年工作量貸方累計(jì)]NW_CLOSING_BAL_UNUMBER(20,2)Y0[包含未記賬期末工作量余TSVARCHAR2(20)YTOCHARSYSDATE,創(chuàng)建日期]MMDDHH24:MI:SS')NUMBER(20,2)Y0[本年借方累計(jì)]NUMBER(20,2)Y0[本年貸方累計(jì)]YDEBITNUMBER(20,2)Y0NUMBER(20,2)Y0DEBITNUMBER(20,2)Y0NUMBER(20,2)Y014.部門(mén)信息表BD_DEPT(全量)SCORPCODESDEPTCODESDEPTNAMEPARENTDEPTCODESREMARKTSSSIMPLECODESSPELLSLEVELCODE字段描述√[公司信息編碼]√門(mén)代碼]門(mén)名稱][上級(jí)部門(mén)代碼]建日期][公司信息編碼]數(shù)據(jù)類型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數(shù)據(jù)類型VARCHAR2(20)VARCHAR2(40)VARCHAR2(20)√[年份標(biāo)識(shí)]制[打印默認(rèn)模板]創(chuàng)建日期]SMUDOLESTYPESPRINTTEMPLATECODETSVARCHAR2(4)NUMBER)CHAR(1)VARCHAR2(38)VARCHAR2(20)TOCHAR(SYSDATE,MMDDHHMI:SS'YYYYY16.系統(tǒng)的枚舉值表BD_SYSENUM(全量)缺缺省值主鍵字段描述[枚舉項(xiàng)含義](系統(tǒng)內(nèi)置)屬模塊][啟用控制標(biāo)識(shí)位]建日期]SCORPCODESENUM_CODESENUM_ITEMSENUM_CONTENTSMODULETS數(shù)據(jù)類型VARCHAR2(20)VARCHAR2(20)VARCHAR2(20)VARCHAR2(30)VARCHAR2(20)CHAR(1)VARCHAR2(20)可為空NNNNYYY17.客戶供應(yīng)商表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.資產(chǎn)分類表AM_ASSETCLASS(全量)字字段名字段類型可為空默認(rèn)值字段描述SCORPCODEVARCHAR2(20)N套編碼]SCLASSCODEVARCHAR2(20)N別編碼]SCLASSNAMEVARCHAR2(100)別名稱]NUMBER(5,4)[預(yù)計(jì)凈殘值率]NUMBER)[預(yù)計(jì)使用年限]SDEPRECIATIONCODEVARCHAR2(20)[缺省折舊方式]ENUMBER(6,4)折舊率]XTBZVARCHAR2(1)[4.2中的保留字]BZVARCHAR2(1)[4.2中的保留字][資本化方法標(biāo)識(shí)]0表示當(dāng)月初始化1表示次月初始化SORGACC_CODEVARCHAR2(20)[原值計(jì)入缺省科目代碼]SDPREACC_CODEVARCHAR2(20)[折舊計(jì)入缺省科目代碼]SUI_CODEVARCHAR2(20)面代碼]NUMBER(5,4)[凈殘值率(JCZL)][[使用年限(SYNX)][折舊方法(ZJFF)][年折舊率(NZJL)][凈殘值率(JCZL)][使用年限(SYNX)][折舊方法(ZJFF)][年折舊率(NZJL)][編號(hào)規(guī)則代碼]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)字字段名字段類型可為空默認(rèn)值字段描述SCONTENTS_CODEVARCHAR2(20)N錄編碼]SCLASSCODEVARCHAR2(20)別編碼]SCORPCODEVARCHAR2(20)N套編碼]SCONTENTSVARCHAR2(100)錄名稱]SUNIT_CODEVARCHAR2(20)[計(jì)量單位一]SUNIT_CODE2VARCHAR2(20)[計(jì)量單位二]SPECIFICATIONVARCHAR2(20)格型號(hào)]NUMBER(20,2)省原價(jià)]NUMBER(20,2)[預(yù)計(jì)使用年限]SCTL_CODEVARCHAR2(20)[成本對(duì)象代碼默認(rèn)值]HSPECIATIONVARCHAR2(40)[技術(shù)特征默認(rèn)值]1[資本化方法標(biāo)識(shí)]0表示當(dāng)月初始化1表示次月初始化NUMBER(6,5)[凈殘值率(JCZL)]ENUMBER(6,4)[年折舊率(NZJL)]EVARCHAR2(20)[[末級(jí)]"Y"表示是"N"表[原值計(jì)入缺省科目代碼][折舊計(jì)入缺省科目代碼][凈殘值率(JCZL)][使用年限(SYNX)][折舊方法(ZJFF)][年折舊率(NZJL)][凈殘值率(JCZL)][使用年限(SYNX)][折舊方法(ZJFF)][年折舊率(NZJL)][折舊方法(ZJFF)][減值標(biāo)識(shí)]"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.成本對(duì)象AM_COSTOBJECT(全量)字字段名字段類型可為空默認(rèn)值字段描述SCOSTOBJECT_CODESCOSTOBJECT_NAMEVARCHAR2(20)VARCHAR2(20)N[成本對(duì)象編碼][成本對(duì)象名稱]SCORPCODEVARCHAR2(20)N帳套編碼]SGETVALUEEXPVARCHAR2(20)[取值表達(dá)式]SCOSACC_CODEVARCHAR2(20)[缺省科目代碼]TSVARCHAR2(20)TO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')21.資產(chǎn)變動(dòng)履歷表AM_TRANSACTION(增量)字段名字段類型可為空默認(rèn)值字段描述SPERIODCODEVARCHAR2(7)NSCORPCODEVARCHAR2(20)N套編碼]SASSETS_CODEVARCHAR2(40)N產(chǎn)編號(hào)]SMASTERCARD_CODEVARCHAR2(20)N片編號(hào)]SHANDBYVARCHAR2(20)YSREASONVARCHAR2(50)Y動(dòng)說(shuō)明]VARCHAR2(10)N動(dòng)日期]NUMBER(4)N0SCONTENTS_CODEVARCHAR2(20)N[資產(chǎn)目錄代碼]VARCHAR2(20)N動(dòng)類型]SDESCRIPTIONVARCHAR2(200)Y產(chǎn)名稱]SM_UNITVARCHAR2(20)Y[計(jì)量單位一]SS_UNITVARCHAR2(20)Y[計(jì)量單位二]SDEPR_CODE_TVARCHAR2(20)Y[折舊方式一]SDEPR_CODE_MVARCHAR2(20)Y[折舊方式二]TNUMBER(3)Y0[預(yù)計(jì)使用年限一]ATIONMNUMBER(3)Y0[預(yù)計(jì)使用年限LOADTNUMBER(20,2)Y0[預(yù)計(jì)工作量一]NWORKLOAD_MNUMBER(20,2)Y0[預(yù)計(jì)工作量二]NUMBER(8,6)Y0[預(yù)計(jì)凈殘率值一]NRESIDUALS_RATE_MNUMBER(8,6)Y0[預(yù)計(jì)凈殘率值NUMBER(8,6)Y0折舊率]EPRECIATIONRATEMNUMBER(8,6)Y0[管理年折舊率]NUMBER(20,2)Y0動(dòng)原價(jià)]PSETUP_FEENUMBER(20,2)Y0VARCHAR2(7)Y賬年月]NPOST_NUMBER1NUMBER(10,3)Y0[變動(dòng)數(shù)量一]NPOSTNUMBER2NUMBER(10,3)Y0[變動(dòng)數(shù)量二]NDEPR_WHENPOSTED_TNUMBER(13,2)Y0[入賬時(shí)累計(jì)折NDEPR_WHENPOSTED_MNUMBER(13,2)Y0[入賬時(shí)管理累計(jì)折舊]ETVALUEPOSTEDTNUMBER(20,2)Y0[入賬時(shí)凈值]NNETVALUE_POSTED_MNUMBER(20,2)Y0[入賬時(shí)管理凈NUMBER(13,2)Y0計(jì)折舊]NDEPRECIATION_MNUMBER(13,2)Y0[管理累計(jì)折舊]NUMBER(20,2)Y0NNETVAUE_MNUMBER(20,2)Y0理凈值]ALSVALUETNUMBER(20,2)Y0NRESIDUALS_VALUE_MNUMBER(20,2)Y0[管理凈殘值]NDEPR_WORKLOAD_TNUMBER(20,2)Y0[入賬時(shí)工作量]NDEPR_WORKLOAD_MNUMBER(20,2)Y0[入賬時(shí)管理凈NUSEDMONTHY0[已使用期間]NDEPR_WORKLOAD_T1NUMBER(20,2)Y0[入賬時(shí)工作量一]NDEPR_WORKLOAD_M1NUMBER(20,2)Y0[入賬時(shí)工作量NUMBER(20,2)Y0估凈值]EPRNUMBER(20,2)Y0[評(píng)估累計(jì)折舊]TESETUPFEENUMBER(20,2)Y0[評(píng)估安裝費(fèi)]DLIFENUMBER(10,3)Y0[評(píng)估使用年限]NUMBER(20,2)Y0[評(píng)估折舊率]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值(即資產(chǎn)減少價(jià)值)][變動(dòng)的評(píng)估稅務(wù)殘值率]格型號(hào)]術(shù)證書(shū)]產(chǎn)證書(shū)]造日期]廠編號(hào)]術(shù)特征]置地點(diǎn)]用用途]濟(jì)用途][融資標(biāo)識(shí)]"Y"表用部門(mén)][變動(dòng)的多部門(mén)使用標(biāo)識(shí)]"Y"表可證書(shū)][變動(dòng)的折舊狀"Y"表示需要計(jì)不需要計(jì)提折舊[變動(dòng)的業(yè)務(wù)編ATCHFLAGCOLUMN_69COLUMN_70COLUMN_71COLUMN_72COLUMN_73COLUMN_74SPOSTED_FLAGSCOSTOBJECT_CODEDUALSUNITSBUSINESSAREATS0TO_CHAR(SYSDATE,'YYYY/MM/DDHH4:MI:SS')號(hào)(業(yè)務(wù)流水號(hào))]賬標(biāo)識(shí)]本對(duì)象][個(gè)別折舊標(biāo)識(shí)]提基數(shù)]量單位][升級(jí)數(shù)據(jù)標(biāo)識(shí)]務(wù)對(duì)象]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(增量)字段名字段名字段類型可為空默認(rèn)值字段描述SCORPCODEVARCHAR2(20)N套編碼]SASSETS_CODEVARCHAR2(40)N產(chǎn)編號(hào)]SMASTERCARD_CODEVARCHAR2(20)N片編碼]SPERIOD_CODEVARCHAR2(7)N舊期間]NUMBER(20,2)0月折舊]LOADTNUMBER(20,4)0[折舊工作量]NUMBER(20,2)0[當(dāng)月累計(jì)折舊]NUMBER(20,2)Y0提基數(shù)]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全量)字段名字段類型可為空默認(rèn)值字段描述SCORPCODEVARCHAR2(20)N套編碼]SCLASSCODEVARCHAR2(20)別編碼]SCONTENTS_CODEVARCHAR2(20)N錄編碼]SASSETS_CODEVARCHAR2(40)N產(chǎn)編號(hào)]SMASTERCARD_CODEVARCHAR2(20)片編碼]SBUSINESSAREAVARCHAR2(20)務(wù)對(duì)象]VARCHAR2(20)態(tài)類型]SUSEAGE_CODEVARCHAR2(30)濟(jì)用途]BDEPINONEMONTHCHAR(1)本列支]CHAR(1)否新品]SCOSTOBJECT_CODEVARCHAR2(20)本對(duì)象]VARCHAR2(20)前狀態(tài)]SDESCRIPTIONVARCHAR2(200)產(chǎn)名稱]SM_UNITVARCHAR2(20)[計(jì)量單位一]SS_UNITVARCHAR2(20)[計(jì)量單位二]SDEPR_CODE_TVARCHAR2(20)[折舊方式編碼]TNUMBER)0[預(yù)計(jì)使用年限]LOADTNUMBER(20,2)0[預(yù)計(jì)工作量]NUMBER(8,6)0殘值率]NUMBER(8,6)0折舊率]NUMBER(20,2)0賬原價(jià)]PSETUP_FEENUMBER(20,2)0NOTHEREXPENSENUMBER(10,3)0他費(fèi)用]VARCHAR2(10)[交付使用年月]NPOST_NUMBER1NUMBER(10,3)0[入賬數(shù)量一]NPOSTNUMBER2NUMBER(10,3)0[入賬數(shù)量二]NDEPR_WHENPOSTED_TNUMBER(13,2)0[入賬累計(jì)折舊]ETVALUEPOSTEDTNUMBER(20,2)0賬凈值]NUMBER(13,2)0[累計(jì)折舊(月初)]NUMBER(20,2)0產(chǎn)凈值]ALSVALUETNUMBER(20,2)0NDEPR_WORKLOAD_TNUMBER(20,2)0[折舊工作量]NUSEDMONTHNUMBER(20,2)0使用月]NUMBER(20,2)0估價(jià)值]EPRNUMBER(20,2)0[重復(fù)累計(jì)折舊]TESETUPFEENUMBER(20,2)0[重估安裝費(fèi)]DLIFENUMBER(10,3)0[重復(fù)預(yù)計(jì)年限]NUMBER(20,2)0[重估可回收價(jià)NUMBER(8,6)0[重估凈殘值率]SPECIFICATIONVARCHAR2(80)格型號(hào)]LORVARCHAR2(20)STECH_LICENCEVARCHAR2(20)術(shù)證書(shū)]SMANUFACTURERVARCHAR2(100)造單位]VARCHAR2(10)造年月]VARCHAR2(10)賬年月]SPRODUCTIONNOVARCHAR2(20)產(chǎn)編號(hào)]STECH_DESCRIPTIONVARCHAR2(70)術(shù)特征]VARCHAR2(100)置地點(diǎn)]SKEEPERVARCHAR2(20)VARCHAR2(30)[使用狀態(tài)編碼]BLEASEFLAGVARCHAR2(1)資標(biāo)識(shí)]SDEPTCODEVARCHAR2(20)門(mén)編碼]BMITILDEPTFLAGVARCHAR2(1)[多部門(mén)標(biāo)識(shí)]SLICENCEVARCHAR2(30)VARCHAR2(1)舊標(biāo)識(shí)]BDEADFLAGCHAR(1)出標(biāo)識(shí)]NUMBER(20,2)0[有償調(diào)撥價(jià)]SDEPR_DIS_METHODVARCHAR2(20)N[折舊分?jǐn)偡绞絔SPOSTED_FLAGCHAR(1)N賬標(biāo)識(shí)]CHAR(1)[減值準(zhǔn)備標(biāo)識(shí)]NUMBER(13,2)0[累計(jì)減值(月初)]STRANSACTIONDISCVARCHAR2(40)0態(tài)編碼]ZKNYVARCHAR2(7)卡年月]RYVARCHAR2(20)DUALCHAR(1)[個(gè)別折舊標(biāo)志]NUMBER(20,2)0[折舊計(jì)提基數(shù)]NUMBER(20,2)0計(jì)原價(jià)]VARCHAR2(7)卡年月]NUMBER(20,2)0[累計(jì)折舊(實(shí)時(shí))]TNUMBER(13,2)0[累計(jì)減值(實(shí)時(shí))]CHAR(1)據(jù)版本]ERVEDEPRECIATIONNUMBER(20,2)0[減值累計(jì)折舊]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.放置地點(diǎn)表AM_LOCATION(全量)字段字段名字段類型可為空默認(rèn)值字段描述Y號(hào)VARCHAR2(200)Y地點(diǎn)名稱25.大修記錄表AM_MAINTANCE(增量)字段字段名字段類型可為空默認(rèn)值字段描述NTANCEIDVARCHAR2(36)NSCORPCODEVARCHAR2(20)Y套編碼]SASSETS_CODEVARCHAR2(40)Y產(chǎn)編號(hào)]SMASTERCARD_CODEVARCHAR2(20)Y片編號(hào)]NUMBER(20,2)Y修費(fèi)用]CHAR(10)Y修日期]NUMBER(12,2)Y[維修工作量]SUNITCODEVARCHAR2(20)Y量單位]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')26.減值準(zhǔn)備表AM_RESERVE_DEP(增量)字段類型字段類型可為空默認(rèn)值VARCHAR2(36)YVARCHAR2(20)N字段名STRANSACTIONCODESCORPCODE字段描述態(tài)編號(hào)]套編碼]SASSETSSASSETS_CODEVARCHAR2(40)N產(chǎn)編號(hào)]SMASTERCARD_CODEVARCHAR2(20)N片編號(hào)]SPERIODCODEVARCHAR2(20)NNUMBER(4)NSRESERVEDESPVARCHAR2(40)Y值說(shuō)明]SRESERVETYPEVARCHAR2(30)N'RESERVE_BASEON_CLASS_2'值類型]NUMBER(13,2)Y值金額]NUMBER(13,2)Y[累計(jì)減值金額]NROLLBACKAMOUNTNUMBER(13,2)Y滾金額]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')SPOSTED_FLAGCHAR(1)Y賬標(biāo)識(shí)]VALUENUMBER(13,2)Y[可回收價(jià)值]NUMBER(13,2)YVARCHAR2(20)Y[預(yù)計(jì)提足年月]NUMBER(8,6)Y0[減值時(shí)年折舊率]ERVEDEPRECIATIONNUMBER(20,2)Y0[減值時(shí)累計(jì)折舊]AMSTATUS)字字段描述帳套編碼][作用用途編碼][作用用途名稱][折舊計(jì)提標(biāo)識(shí)(ZJBZ)]"Y"表示計(jì)提"N"表示[折舊影響到時(shí)機(jī)]0：影響當(dāng)月的折舊計(jì)提1：影響次月的折舊計(jì)提字段類型可為空VARCHAR2(20)NVARCHAR2(20)NVARCHAR2(20)YCHAR(1)YSCORPCODEIDEPRECATEFLAG默認(rèn)值1YTOTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')VARCHAR2(20)YTS28.經(jīng)濟(jì)用途表AM_USAGE(全量)字字段名字段類型可為空默認(rèn)值字段描述SUSEAGE_CODEVARCHAR2(20)N[經(jīng)濟(jì)用途編碼]SUAGE_NAMEVARCHAR2(60)Y[經(jīng)濟(jì)用途名稱]SCORPCODEVARCHAR2(20)N帳套編碼]TSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')29.資產(chǎn)附件表AM_ACCESSORY(全量)字字段名字段類型可為空默認(rèn)值字段描述SCORPCODEVARCHAR2(20)N編碼]SASSETS_CODEVARCHAR2(40)N編號(hào)]SMASTERCARD_CODEVARCHAR2(20)N編號(hào)]SACCESSORY_CODEVARCHAR2(20)N編碼]SACCESSORY_NAMEVARCHAR2(40)Y名稱]SPECIFICATIONVARCHAR2(20)Y型號(hào)]SUNIT_CODEVARCHAR2(20)Y單位]UNTNUMBER(20,4)YNUMBER(20,4)YTSVARCHAR2(20)YTO_CHAR(SYSDATE,'YYYY/MM/DDHH24:MI:SS')30.資產(chǎn)附件履歷表AM_ACCESSORYHISTORY(全量)字字段名字段類型可為空默認(rèn)值字段描述VARCHAR2(36)NVARCHAR2(20)N類型]VARCHAR2(10)N日期]套編碼]產(chǎn)編號(hào)]片編號(hào)]件編號(hào)]件名稱]格型號(hào)]量單位]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(全量)默認(rèn)值默認(rèn)值字段描述套編碼][折舊方式名稱][折舊方式代碼][折舊方式公式表達(dá)式][計(jì)提基數(shù)公式][折舊率公式]字段名SCORPCODEDEPRECIATION_IDECIATIONNAMERECIATIONFUNCODEDEPRECIATION_FUNEXPREDEPRECIATION_BASE_FUNEFUNEPRECIATIONREMARK字段類型VARCHAR2(20)VARCHAR2(20)VARCHAR2(50)VARCHAR2(200)VARCHAR2(200)VARCHAR2(500)VARCHAR2(500)VARCHAR2(50)可為空NNNYNYYY32.工資類別表WA_CLASS(全量)字段字段名字段類型可為空默認(rèn)值字段描述SCORPCODEVARCHAR2(20)N代碼]SCLASSCODEVARCHAR2(20)N代碼]SCLASSNAMEVARCHAR2(60)Y[類別名稱]SESEDITUSERVARCHAR2(36)Y[最后被修改用戶代碼]SEDITTIMEVARCHAR2(20)Y[最后被修改時(shí)間]CHAR(1)Y[默認(rèn)當(dāng)前]1默認(rèn)0不默認(rèn)SUSEDCHAR(1)Y用，默認(rèn)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默認(rèn)值字段描述司代碼]套代碼]員內(nèi)碼]員代碼]員名稱]治面貌]生日期]路日期]份證號(hào)]份證號(hào)]門(mén)代碼]門(mén)名稱][工資類別代碼][業(yè)務(wù)員標(biāo)識(shí)]"Y"表示為業(yè)務(wù)員"N"表示非業(yè)務(wù)員，默認(rèn)為"N"[停發(fā)標(biāo)志]1停發(fā)0發(fā)放[啟用控制識(shí)位]如果該標(biāo)識(shí)位為:'1'表示被員擴(kuò)展]員擴(kuò)展]員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]VARCHAR2(60)Y員擴(kuò)展]SPERIODCODECHAR(7)N間代碼]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]VARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]VARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]VARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]VARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]VARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]VARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]VARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]CVARCHAR2(60)Y[項(xiàng)目外擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0目擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)Y0擴(kuò)展]NUMBER(16,4)