OracleEBS中文数据字典

1、OracleOracle ERPERP 数据字典数据字典i内容索引内容索引内容索引内容索引1总概总概.11.1数据关系图.12基础信息基础信息.22.1数据关系图.22.2数据表简述.32.3数据表明细.32.3.1GL_SETS_OF_BOOKS.32.3.2GL_PERIOD_SETS .52.3.3GL_PERIODS.52.3.4GL_CODE_COMBINATIONS.63日记帐日记帐.83.1数据关系图.83.2数据表简述.83.3数据表明细.93.3.1GL_JE_BATCHES.93.3.2GL_JE_HEADERS.103.3.3GL_JE_LINES.124日记帐导入日记帐

2、导入.144.1数据关系图.144.2数据表简述.144.3数据表明细.144.3.1gl_interface.1411 1 1总概总概总概总概1.11.1数据关系图数据关系图21.21.2数据表简述数据表简述表名描述相关视图备注GL_BALANCES余额表1.31.3数据表明细数据表明细1.3.1GL_BALANCES名称类型可为空描述SET_OF_BOOKS_IDNUMBER(15)帐薄 IdCODE_COMBINATION_IDNUMBER(15)帐户 IDCURRENCY_CODEVARCHAR2(15)币种PERIOD_NAMEVARCHAR2(15)区间ACTUAL_FLAGVAR

3、CHAR2(1) 标记(A 实际款，B预算款，E保留款)TRANSLATED_FLAGVARCHAR2(1)YREVALUATION_STATUSVARCHAR2(1)YPERIOD_TYPEVARCHAR2(15)YPERIOD_YEARNUMBER(15)Y区间年（四位数字）PERIOD_NUMNUMBER(15)Y区间月PERIOD_NET_DRNUMBERY本期借方发生额PERIOD_NET_CRNUMBERY本期贷方发生额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基础信息基础信息基础信息基础信息2.12.1数据关系图数据关系图42.22.2数据表简述数据表简述表名描述相关视图备注5GL_SETS_OF_BOOKS帐簿表GL_PERIOD_SETS总帐日历表GL_PERIODS总帐日历明细表GL_PERIODS_VGL_CODE_COMBINATIONS帐户表2.32.3数据表明细数

6、据表明细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弹性域结构 IDNAMEVARCHAR2(30)N帐簿名称PERIOD_SET_NAMEVARCHAR2(15)N帐簿区间（日历）名SUSPENSE_ALLOWED_FLAGVARCH

11、AR2(1)NALLOW_POSTING_WARNING_FLAGVARCHAR2(1)NACCOUNTED_PERIOD_TYPEVARCHAR2(15)NSHORT_NAMEVARCHAR2(20)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区间（日历）名DESCRIPTIONVARCHAR2(240)Y备注2.3.3GL_PERIODS总帐日历明细表名称类型可为空描述PERIOD_SET_NAME (PK)VARCHAR2(15

16、)N区间（日历）名PERIOD_NAME (PK)VARCHAR2(15)N区间（日历）明细名START_DATEDATEN起始日期END_DATEDATEN截至日期PERIOD_TYPEVARCHAR2(15)N区间类型PERIOD_YEARNUMBER(15)N区间年份PERIOD_NUMNUMBER(15)N区间序号QUARTER_NUMNUMBER(15)N区间季节号ENTERED_PERIOD_NAMEVARCHAR2(15)N手工输入区间明细名ADJUSTMENT_PERIOD_FLAGVARCHAR2(1)NDESCRIPTIONVARCHAR2(240)Y备注YEAR_STAR

17、T_DATEDATEY年度起始日期QUARTER_START_DATEDATEY季度起始日期82.3.4GL_CODE_COMBINATIONS帐户表，用于存放已选择的弹性域段值。累计型帐号，SUMMARY_FLAG = Y 且TEMPLATE_ID not NULL；明细型帐号，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弹性域结构 ID(=FND_ID_FLEX_STRUCTURES.ID_FLEX_NUM)DETAIL_POSTING_ALLOWED_FLAGVARCHAR2(1)NDETAIL_BUDGETING_ALLOWED_FLAGVARCHAR2(1)NACCOUNT_TYPEVARCHAR2(1)N帐号类型ENABLED_FLAGVARCHAR2(1)N启用标志，Y 是，N 非SUMMARY_FLAGVARCHAR2(1)N标识是否是父；累计组标记 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数据关系图数据关系图3.2数据表简述数据表简述表名描述相关视图备注GL_JE_BATCHE

22、S批次表GL_JE_HEADERS凭证头表11GL_JE_LINES凭证分录表GL_JE_CATEGORIES_TLGL_JE_SOURCES_TLGL_ENCUMBRANCE_TYPES3.3数据表明细数据表明细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)区间NAMEVARCHAR2(100)CURRENCY_CODEVARCHAR2(15)STATUSVARCHAR2(1)过帐标记：P 已过帐U 未过帐13DATE_CREATEDDATEDATE_CREATEDDATEACCRUAL_REV_FLAGVARCHAR2(1)MULTI_BAL_SEG_FLAGVARCHAR2(1)ACTUAL_FLAGVARCHAR2(1)凭证类别标记：A 实际款，B预算款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