OracleEBS中文數(shù)據(jù)字典

1、OracleOracle ERPERP 數(shù)據(jù)字典數(shù)據(jù)字典i內(nèi)容索引內(nèi)容索引內(nèi)容索引內(nèi)容索引1總概總概.11.1數(shù)據(jù)關(guān)系圖.12基礎(chǔ)信息基礎(chǔ)信息.22.1數(shù)據(jù)關(guān)系圖.22.2數(shù)據(jù)表簡(jiǎn)述.32.3數(shù)據(jù)表明細(xì).32.3.1GL_SETS_OF_BOOKS.32.3.2GL_PERIOD_SETS .52.3.3GL_PERIODS.52.3.4GL_CODE_COMBINATIONS.63日記帳日記帳.83.1數(shù)據(jù)關(guān)系圖.83.2數(shù)據(jù)表簡(jiǎn)述.83.3數(shù)據(jù)表明細(xì).93.3.1GL_JE_BATCHES.93.3.2GL_JE_HEADERS.103.3.3GL_JE_LINES.124日記帳導(dǎo)入日記帳

2、導(dǎo)入.144.1數(shù)據(jù)關(guān)系圖.144.2數(shù)據(jù)表簡(jiǎn)述.144.3數(shù)據(jù)表明細(xì).144.3.1gl_interface.1411 1 1總概總概總概總概1.11.1數(shù)據(jù)關(guān)系圖數(shù)據(jù)關(guān)系圖21.21.2數(shù)據(jù)表簡(jiǎn)述數(shù)據(jù)表簡(jiǎn)述表名描述相關(guān)視圖備注GL_BALANCES余額表1.31.3數(shù)據(jù)表明細(xì)數(shù)據(jù)表明細(xì)1.3.1GL_BALANCES名稱類型可為空描述SET_OF_BOOKS_IDNUMBER(15)帳薄 IdCODE_COMBINATION_IDNUMBER(15)帳戶 IDCURRENCY_CODEVARCHAR2(15)幣種PERIOD_NAMEVARCHAR2(15)區(qū)間ACTUAL_FLAGVAR

3、CHAR2(1) 標(biāo)記(A 實(shí)際款，B預(yù)算款，E保留款)TRANSLATED_FLAGVARCHAR2(1)YREVALUATION_STATUSVARCHAR2(1)YPERIOD_TYPEVARCHAR2(15)YPERIOD_YEARNUMBER(15)Y區(qū)間年（四位數(shù)字）PERIOD_NUMNUMBER(15)Y區(qū)間月PERIOD_NET_DRNUMBERY本期借方發(fā)生額PERIOD_NET_CRNUMBERY本期貸方發(fā)生額PERIOD_TO_DATE_ADBNUMBERYQUARTER_TO_DATE_DRNUMBERYQUARTER_TO_DATE_CRNUMBERYQUARTER

4、_TO_DATE_ADBNUMBERYYEAR_TO_DATE_ADBNUMBERYPROJECT_TO_DATE_DRNUMBERY期初借方余額(原幣)PROJECT_TO_DATE_CRNUMBERY期初貸方余額(原幣)PROJECT_TO_DATE_ADBNUMBERYBEGIN_BALANCE_DRNUMBERY期初借方余額(原幣)BEGIN_BALANCE_CRNUMBERY期初貸方余額(原幣)PERIOD_NET_DR_BEQNUMBERY本期借方余額(本位幣)PERIOD_NET_CR_BEQNUMBERY本期貸方余額(本位幣)BEGIN_BALANCE_DR_BEQNUMBER

5、Y期初借方余額(本位幣)BEGIN_BALANCE_CR_BEQNUMBERY期初貸方余額(本位幣)TEMPLATE_IDNUMBER(15)YENCUMBRANCE_DOC_IDNUMBER(15)YENCUMBRANCE_LINE_NUMNUMBER(15)Y32 2 2基礎(chǔ)信息基礎(chǔ)信息基礎(chǔ)信息基礎(chǔ)信息2.12.1數(shù)據(jù)關(guān)系圖數(shù)據(jù)關(guān)系圖42.22.2數(shù)據(jù)表簡(jiǎn)述數(shù)據(jù)表簡(jiǎn)述表名描述相關(guān)視圖備注5GL_SETS_OF_BOOKS帳簿表GL_PERIOD_SETS總帳日歷表GL_PERIODS總帳日歷明細(xì)表GL_PERIODS_VGL_CODE_COMBINATIONS帳戶表2.32.3數(shù)據(jù)表明細(xì)數(shù)

6、據(jù)表明細(xì)2.3.1GL_SETS_OF_BOOKS帳簿表外鍵（FK）:主鍵表主鍵列外鍵列FND_CURRENCIESCURRENCY_CODECURRENCY_CODEFND_ID_FLEX_STRUCTURESID_FLEX_NUMCHART_OF_ACCOUNTS_IDGL_CODE_COMBINATIONSCODE_COMBINATION_IDCUM_TRANS_CODE_COMBINATION_IDGL_CODE_COMBINATIONSCODE_COMBINATION_IDRET_EARN_CODE_COMBINATION_IDGL_CODE_COMBINATIONSCODE_COM

7、BINATION_IDRES_ENCUMB_CODE_COMBINATION_IDGL_CODE_COMBINATIONSCODE_COMBINATION_IDNET_INCOME_CODE_COMBINATION_IDGL_CODE_COMBINATIONSCODE_COMBINATION_IDROUNDING_CODE_COMBINATION_IDGL_DAILY_CONVERSION_TYPESCONVERSION_TYPEDAILY_TRANSLATION_RATE_TYPEGL_PERIOD_SETSPERIOD_SET_NAMEPERIOD_SET_NAMEGL_PERIOD_TY

8、PESPERIOD_TYPEACCOUNTED_PERIOD_TYPEGL_TRANSACTION_CALENDARTRANSACTION_CALENDAR_IDTRANSACTION_CALENDAR_ID快速編碼列(QuickCodes)列快速編碼類型快速編碼表ALLOW_INTERCOMPANY_POST_FLAGYES/NONYGL_LOOKUPSNoYesCONSOLIDATION_SOB_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_AUTOMATIC_TAX_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_AVERAGE_BALANCES

9、_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_BUDGETARY_CONTROL_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_JE_APPROVAL_FLAGYES/NONYGL_LOOKUPSNoYesREQUIRE_BUDGET_JOURNALS_FLAGYES/NONYGL_LOOKUPSNoYesSUSPENSE_ALLOWED_FLAGYES/NONGL_LOOKUPSNo6YYesTRACK_ROUNDING_IMBALANCE_FLAGYES/NONYGL_LOOKUPSNoYesTRANSLATE_EOD_FLAGYES/NONY

10、GL_LOOKUPSNoYesTRANSLATE_QATD_FLAGYES/NONYGL_LOOKUPSNoYesTRANSLATE_YATD_FLAGYES/NONYGL_LOOKUPSNoYes列描述名稱類型可為空描述SET_OF_BOOKS_ID （PK）NUMBER(15)N帳薄 IDCURRENCY_CODEVARCHAR2(15)N幣種代碼CHART_OF_ACCOUNTS_IDNUMBER(15)N彈性域結(jié)構(gòu) IDNAMEVARCHAR2(30)N帳簿名稱PERIOD_SET_NAMEVARCHAR2(15)N帳簿區(qū)間（日歷）名SUSPENSE_ALLOWED_FLAGVARCH

11、AR2(1)NALLOW_POSTING_WARNING_FLAGVARCHAR2(1)NACCOUNTED_PERIOD_TYPEVARCHAR2(15)NSHORT_NAMEVARCHAR2(20)N帳簿簡(jiǎn)程REQUIRE_BUDGET_JOURNALS_FLAGVARCHAR2(1)NENABLE_BUDGETARY_CONTROL_FLAGVARCHAR2(1)NALLOW_INTERCOMPANY_POST_FLAGVARCHAR2(1)NLATEST_ENCUMBRANCE_YEARNUMBER(15)YEARLIEST_UNTRANS_PERIOD_NAMEVARCHAR2(15

12、)YCUM_TRANS_CODE_COMBINATION_IDNUMBER(15)YFUTURE_ENTERABLE_PERIODS_LIMITNUMBER(15)YLATEST_OPENED_PERIOD_NAMEVARCHAR2(15)YRET_EARN_CODE_COMBINATION_IDNUMBER(15)YRES_ENCUMB_CODE_COMBINATION_IDNUMBER(15)YDESCRIPTIONVARCHAR2(240)YENABLE_AVERAGE_BALANCES_FLAGVARCHAR2(1)NCONSOLIDATION_SOB_FLAGVARCHAR2(1)N

13、TRANSLATE_EOD_FLAGVARCHAR2(1)NTRANSLATE_QATD_FLAGVARCHAR2(1)NTRANSLATE_YATD_FLAGVARCHAR2(1)NTRANSACTION_CALENDAR_IDNUMBER(15)YDAILY_TRANSLATION_RATE_TYPEVARCHAR2(30)YNET_INCOME_CODE_COMBINATION_IDNUMBER(15)Y7GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(30)YGLOBAL_ATTRIBUTE1VARCHAR2(150)YGLOBAL_ATTRIBUTE2VARCHA

14、R2(150)YGLOBAL_ATTRIBUTE3VARCHAR2(150)YGLOBAL_ATTRIBUTE4VARCHAR2(150)YGLOBAL_ATTRIBUTE5VARCHAR2(150)YGLOBAL_ATTRIBUTE6VARCHAR2(150)YGLOBAL_ATTRIBUTE7VARCHAR2(150)YGLOBAL_ATTRIBUTE8VARCHAR2(150)YGLOBAL_ATTRIBUTE9VARCHAR2(150)YGLOBAL_ATTRIBUTE10VARCHAR2(150)YENABLE_AUTOMATIC_TAX_FLAGVARCHAR2(1)NENABLE

15、_JE_APPROVAL_FLAGVARCHAR2(1)NMRC_SOB_TYPE_CODEVARCHAR2(1)NTRACK_ROUNDING_IMBALANCE_FLAGVARCHAR2(1)NROUNDING_CODE_COMBINATION_IDNUMBER(15)Y2.3.2GL_PERIOD_SETS總帳日歷表名稱類型可為空描述PERIOD_SET_NAME (PK)VARCHAR2(15)N區(qū)間（日歷）名DESCRIPTIONVARCHAR2(240)Y備注2.3.3GL_PERIODS總帳日歷明細(xì)表名稱類型可為空描述PERIOD_SET_NAME (PK)VARCHAR2(15

16、)N區(qū)間（日歷）名PERIOD_NAME (PK)VARCHAR2(15)N區(qū)間（日歷）明細(xì)名START_DATEDATEN起始日期END_DATEDATEN截至日期PERIOD_TYPEVARCHAR2(15)N區(qū)間類型PERIOD_YEARNUMBER(15)N區(qū)間年份PERIOD_NUMNUMBER(15)N區(qū)間序號(hào)QUARTER_NUMNUMBER(15)N區(qū)間季節(jié)號(hào)ENTERED_PERIOD_NAMEVARCHAR2(15)N手工輸入?yún)^(qū)間明細(xì)名ADJUSTMENT_PERIOD_FLAGVARCHAR2(1)NDESCRIPTIONVARCHAR2(240)Y備注YEAR_STAR

17、T_DATEDATEY年度起始日期QUARTER_START_DATEDATEY季度起始日期82.3.4GL_CODE_COMBINATIONS帳戶表，用于存放已選擇的彈性域段值。累計(jì)型帳號(hào)，SUMMARY_FLAG = Y 且TEMPLATE_ID not NULL；明細(xì)型帳號(hào)，SUMMARY_FLAG =N 且 TEMPLATE_ID NULL。外鍵（FK）:主鍵表主鍵列外鍵列FND_ID_FLEX_STRUCTURESID_FLEX_NUMCHART_OF_ACCOUNTS_IDGL_SUMMARY_TEMPLATESTEMPLATE_IDTEMPLATE_ID快速編碼列(QuickCo

18、des)列快速編碼類型快速編碼表ACCOUNT_TYPEACCOUNT TYPEAELORGL_LOOKUPSAELORDETAIL_BUDGETING_ALLOWED_FLAGYES/NONYGL_LOOKUPSNoYesDETAIL_POSTING_ALLOWED_FLAGYES/NONYGL_LOOKUPSNoYesPRESERVE_FLAGYES/NONYGL_LOOKUPSNoYesREFRESH_FLAGYES/NONYGL_LOOKUPSNoYesSUMMARY_FLAGYES/NONYGL_LOOKUPSNoYes列描述名稱類型可為空描述CODE_COMBINATION_IDN

19、UMBER(15)N帳戶 IDCHART_OF_ACCOUNTS_IDNUMBER(15)N彈性域結(jié)構(gòu) ID(=FND_ID_FLEX_STRUCTURES.ID_FLEX_NUM)DETAIL_POSTING_ALLOWED_FLAGVARCHAR2(1)NDETAIL_BUDGETING_ALLOWED_FLAGVARCHAR2(1)NACCOUNT_TYPEVARCHAR2(1)N帳號(hào)類型ENABLED_FLAGVARCHAR2(1)N啟用標(biāo)志，Y 是，N 非SUMMARY_FLAGVARCHAR2(1)N標(biāo)識(shí)是否是父；累計(jì)組標(biāo)記 Y 是，N非SEGMENT1VARCHAR2(25)Y彈

20、性域段值。VARCHAR2(25)YDESCRIPTIONVARCHAR2(240)Y備注TEMPLATE_IDNUMBER(15)Y9ALLOCATION_CREATE_FLAGVARCHAR2(1)YSTART_DATE_ACTIVEDATEY生效起始日期END_DATE_ACTIVEDATEY生效截止日期ATTRIBUTE1VARCHAR2(150)Y。VARCHAR2(150)YSEGMENT_ATTRIBUTE1VARCHAR2(60)Y。VARCHAR2(60)YJGZZ_RECON_FLAGVARCHAR2(1)YJGZZ_RECON_CONTEXTVARCHAR2(30)YRE

21、FERENCE1VARCHAR2(1)YREFERENCE2VARCHAR2(1)YREFERENCE3VARCHAR2(1)YREFERENCE4VARCHAR2(1)YREFERENCE5VARCHAR2(1)YPRESERVE_FLAGVARCHAR2(1)YREFRESH_FLAGVARCHAR2(1)YIGI_BALANCED_BUDGET_FLAGVARCHAR2(1)YCOMPANY_COST_CENTER_ORG_IDNUMBER(15)Y103 3 3日記帳日記帳日記帳日記帳3.13.1數(shù)據(jù)關(guān)系圖數(shù)據(jù)關(guān)系圖3.2數(shù)據(jù)表簡(jiǎn)述數(shù)據(jù)表簡(jiǎn)述表名描述相關(guān)視圖備注GL_JE_BATCHE

22、S批次表GL_JE_HEADERS憑證頭表11GL_JE_LINES憑證分錄表GL_JE_CATEGORIES_TLGL_JE_SOURCES_TLGL_ENCUMBRANCE_TYPES3.3數(shù)據(jù)表明細(xì)數(shù)據(jù)表明細(xì)3.3.1GL_JE_BATCHES批次表外鍵（FK）:主鍵表主鍵列外鍵列FND_CONCURRENT_REQUESTSREQUEST_IDREQUEST_IDGL_JE_BATCHESJE_BATCH_IDPARENT_JE_BATCH_IDGL_PERIODSPERIOD_NAMEDEFAULT_PERIOD_NAMEGL_SETS_OF_BOOKSSET_OF_BOOKS_ID

23、SET_OF_BOOKS_ID快速編碼列(QuickCodes)列快速編碼類型快速編碼表ACTUAL_FLAGBATCH_TYPEABEGL_LOOKUPSABEAPPROVAL_STATUS_CODEJE_BATCH_APPROVAL_STATUSAIJRVZGL_LOOKUPSApprovedInRejectedRequiredValidationN/AAVERAGE_JOURNAL_FLAGAB_JOURNAL_TYPEGL_LOOKUPSNNoYYes列描述名稱類型可為空描述JE_BATCH_IDNUMBER(15)N批次 IDSET_OF_BOOKS_IDNUMBER(15)N帳薄

24、IDNAMEVARCHAR2(100)N12STATUSVARCHAR2(1)NSTATUS_VERIFIEDVARCHAR2(1)NACTUAL_FLAGVARCHAR2(1)NDEFAULT_EFFECTIVE_DATEDATENBUDGETARY_CONTROL_STATUSVARCHAR2(1)NSTATUS_RESET_FLAGVARCHAR2(1)YDEFAULT_PERIOD_NAMEVARCHAR2(15)YUNIQUE_DATEVARCHAR2(30)YEARLIEST_POSTABLE_DATEDATEYPOSTED_DATEDATEYDATE_CREATEDDATEYDE

25、SCRIPTIONVARCHAR2(240)YCONTROL_TOTALNUMBERYRUNNING_TOTAL_DRNUMBERYRUNNING_TOTAL_CRNUMBERYRUNNING_TOTAL_ACCOUNTED_DRNUMBERYRUNNING_TOTAL_ACCOUNTED_CRNUMBERYATTRIBUTE1VARCHAR2(150)Y。PACKET_IDNUMBER(15)YUSSGL_TRANSACTION_CODEVARCHAR2(30)YCONTEXT2VARCHAR2(150)YPOSTING_RUN_IDNUMBER(15)YREQUEST_IDNUMBER(1

26、5)YUNRESERVATION_PACKET_IDNUMBER(15)YAVERAGE_JOURNAL_FLAGVARCHAR2(1)NORG_IDNUMBER(15)YAPPROVAL_STATUS_CODEVARCHAR2(1)NPARENT_JE_BATCH_IDNUMBER(15)Y3.3.2GL_JE_HEADERS 憑證頭表名稱類型可為空描述JE_HEADER_IDNUMBER(15)憑證頭 IDSET_OF_BOOKS_IDNUMBER(15)帳薄 IDJE_CATEGORYVARCHAR2(25)JE_SOURCEVARCHAR2(25)PERIOD_NAMEVARCHAR2

27、(15)區(qū)間NAMEVARCHAR2(100)CURRENCY_CODEVARCHAR2(15)STATUSVARCHAR2(1)過(guò)帳標(biāo)記：P 已過(guò)帳U 未過(guò)帳13DATE_CREATEDDATEDATE_CREATEDDATEACCRUAL_REV_FLAGVARCHAR2(1)MULTI_BAL_SEG_FLAGVARCHAR2(1)ACTUAL_FLAGVARCHAR2(1)憑證類別標(biāo)記：A 實(shí)際款，B預(yù)算款DEFAULT_EFFECTIVE_DATEDATETAX_STATUS_CODEVARCHAR2(1)CONVERSION_FLAGVARCHAR2(1)YCREATION_DAT

28、EDATEYCREATED_BYNUMBER(15)YLAST_UPDATE_LOGINNUMBER(15)YENCUMBRANCE_TYPE_IDNUMBER(15)YBUDGET_VERSION_IDNUMBER(15)YBALANCED_JE_FLAGVARCHAR2(1)YBALANCING_SEGMENT_VALUEVARCHAR2(25)YJE_BATCH_IDNUMBER(15)YFROM_RECURRING_HEADER_IDNUMBER(15)YUNIQUE_DATEVARCHAR2(30)YEARLIEST_POSTABLE_DATEDATEYPOSTED_DATEDATE

29、YACCRUAL_REV_EFFECTIVE_DATEDATEYACCRUAL_REV_PERIOD_NAMEVARCHAR2(15)YACCRUAL_REV_STATUSVARCHAR2(1)YACCRUAL_REV_JE_HEADER_IDNUMBER(15)YACCRUAL_REV_CHANGE_SIGN_FLAGVARCHAR2(1)DESCRIPTIONVARCHAR2(240)YCONTROL_TOTALNUMBERYRUNNING_TOTAL_DRNUMBERYRUNNING_TOTAL_CRNUMBERYRUNNING_TOTAL_ACCOUNTED_DRNUMBERYRUNN

30、ING_TOTAL_ACCOUNTED_CRNUMBERYCURRENCY_CONVERSION_RATENUMBERYCURRENCY_CONVERSION_TYPEVARCHAR2(30)YCURRENCY_CONVERSION_DATEDATEYEXTERNAL_REFERENCEVARCHAR2(80)YPARENT_JE_HEADER_IDNUMBER(15)YREVERSED_JE_HEADER_IDNUMBER(15)YORIGINATING_BAL_SEG_VALUEVARCHAR2(25)YINTERCOMPANY_MODENUMBER(15)YDR_BAL_SEG_VALU

31、EVARCHAR2(25)Y14CR_BAL_SEG_VALUEVARCHAR2(25)YUSSGL_TRANSACTION_CODEVARCHAR2(30)YCONTEXT2VARCHAR2(150)YDOC_SEQUENCE_IDNUMBERYDOC_SEQUENCE_VALUENUMBERYJGZZ_RECON_CONTEXTVARCHAR2(30)YJGZZ_RECON_REFVARCHAR2(240)Y3.3.3GL_JE_LINES憑證分錄表名稱類型可為空描述JE_HEADER_IDNUMBER(15)憑證頭 IDJE_LINE_NUMNUMBER(15)SET_OF_BOOKS_

32、IDNUMBER(15)帳薄 IDCODE_COMBINATION_IDNUMBER(15)帳戶 IDPERIOD_NAMEVARCHAR2(15)EFFECTIVE_DATEDATESTATUSVARCHAR2(1)ENTERED_DRNUMBERY錄入借方ENTERED_CRNUMBERY錄入貸方ACCOUNTED_DRNUMBERY本位幣借方ACCOUNTED_CRNUMBERY本位幣貸方DESCRIPTIONVARCHAR2(240)YLINE_TYPE_CODEVARCHAR2(20)YINVOICE_DATEDATEYTAX_CODEVARCHAR2(15)YINVOICE_IDE

33、NTIFIERVARCHAR2(20)YINVOICE_AMOUNTNUMBERYNO1VARCHAR2(150)YSTAT_AMOUNTNUMBERYIGNORE_RATE_FLAGVARCHAR2(1)YUSSGL_TRANSACTION_CODEVARCHAR2(30)YSUBLEDGER_DOC_SEQUENCE_IDNUMBERYSUBLEDGER_DOC_SEQUENCE_VALUENUMBERYGL_SL_LINK_IDNUMBERYGL_SL_LINK_TABLEVARCHAR2(30)YJGZZ_RECON_STATUSVARCHAR2(1)YJGZZ_RECON_DATEDATEYJGZZ_RECON_IDNUMBERYJGZZ_RECON_REFVARCHAR2(240)YJGZZ_RECON_CONTEXTVARCHAR2(30)Y15TAXABLE_LINE_FLAGVARCHAR2(1)YTAX_TYPE_CODEVARCHAR2(1)YTAX_CODE_IDNUMBER(15)YTAX_ROUNDING_RULE_CODEVARCHAR2(1)YAMOUNT_INCLUDES_TAX_FLAGVARC