数据字典GL.docx

1、数据字典GLOracle ERP数据字典内容索引1总概1.1数据关系图1.2数据表简述表名描述相关视图备注GL_BALANCES余额表1.3数据表明细1.3.1GL_BALANCES名称类型可为空描述SET_OF_BOOKS_IDNUMBER(15)帐薄IdCODE_COMBINATION_IDNUMBER(15)帐户IDCURRENCY_CODEVARCHAR2(15)币种PERIOD_NAMEVARCHAR2(15)区间ACTUAL_FLAGVARCHAR2(1) 标记(A 实际款，B预算款，E保留款)TRANSLATED_FLAGVARCHAR2(1)YREVALUATION_STATU

2、SVARCHAR2(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_TO_DATE_ADBNUMBERYYEAR_TO_DATE_ADBNUMBERYPROJECT_TO_DATE_DRNUMBERY期初借方余

3、额(原币)PROJECT_TO_DATE_CRNUMBERY期初贷方余额(原币)PROJECT_TO_DATE_ADBNUMBERYBEGIN_BALANCE_DRNUMBERY期初借方余额(原币)BEGIN_BALANCE_CRNUMBERY期初贷方余额(原币)PERIOD_NET_DR_BEQNUMBERY本期借方余额(本位币)PERIOD_NET_CR_BEQNUMBERY本期贷方余额(本位币)BEGIN_BALANCE_DR_BEQNUMBERY期初借方余额(本位币)BEGIN_BALANCE_CR_BEQNUMBERY期初贷方余额(本位币)TEMPLATE_IDNUMBER(15)Y

4、ENCUMBRANCE_DOC_IDNUMBER(15)YENCUMBRANCE_LINE_NUMNUMBER(15)Y2基础信息2.1数据关系图2.2数据表简述表名描述相关视图备注GL_SETS_OF_BOOKS帐簿表GL_PERIOD_SETS总帐日历表GL_PERIODS总帐日历明细表GL_PERIODS_VGL_CODE_COMBINATIONS帐户表2.3数据表明细2.3.1GL_SETS_OF_BOOKS帐簿表外键（FK）:主键表主键列外键列FND_CURRENCIESCURRENCY_CODECURRENCY_CODEFND_ID_FLEX_STRUCTURESID_FLEX_N

5、UMCHART_OF_ACCOUNTS_IDGL_CODE_COMBINATIONSCODE_COMBINATION_IDCUM_TRANS_CODE_COMBINATION_IDGL_CODE_COMBINATIONSCODE_COMBINATION_IDRET_EARN_CODE_COMBINATION_IDGL_CODE_COMBINATIONSCODE_COMBINATION_IDRES_ENCUMB_CODE_COMBINATION_IDGL_CODE_COMBINATIONSCODE_COMBINATION_IDNET_INCOME_CODE_COMBINATION_IDGL_CO

6、DE_COMBINATIONSCODE_COMBINATION_IDROUNDING_CODE_COMBINATION_IDGL_DAILY_CONVERSION_TYPESCONVERSION_TYPEDAILY_TRANSLATION_RATE_TYPEGL_PERIOD_SETSPERIOD_SET_NAMEPERIOD_SET_NAMEGL_PERIOD_TYPESPERIOD_TYPEACCOUNTED_PERIOD_TYPEGL_TRANSACTION_CALENDARTRANSACTION_CALENDAR_IDTRANSACTION_CALENDAR_ID快速编码列(Quick

7、Codes)列快速编码类型快速编码表ALLOW_INTERCOMPANY_POST_FLAGYES/NONYGL_LOOKUPSNoYesCONSOLIDATION_SOB_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_AUTOMATIC_TAX_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_AVERAGE_BALANCES_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_BUDGETARY_CONTROL_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_JE_APPROVAL_FLAGYES/NONYGL_L

8、OOKUPSNoYesREQUIRE_BUDGET_JOURNALS_FLAGYES/NONYGL_LOOKUPSNoYesSUSPENSE_ALLOWED_FLAGYES/NONYGL_LOOKUPSNoYesTRACK_ROUNDING_IMBALANCE_FLAGYES/NONYGL_LOOKUPSNoYesTRANSLATE_EOD_FLAGYES/NONYGL_LOOKUPSNoYesTRANSLATE_QATD_FLAGYES/NONYGL_LOOKUPSNoYesTRANSLATE_YATD_FLAGYES/NONYGL_LOOKUPSNoYes列描述名称类型可为空描述SET_O

9、F_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_FLAGVARCHAR2(1)NALLOW_POSTING_WARNING_FLAGVARCHAR2(1)NACCOUNTED_PERIOD_TYPEVARCHAR2(15)NSHORT_NAMEVARCHAR2(20)N帐簿简程REQUIRE_BUDG

10、ET_JOURNALS_FLAGVARCHAR2(1)NENABLE_BUDGETARY_CONTROL_FLAGVARCHAR2(1)NALLOW_INTERCOMPANY_POST_FLAGVARCHAR2(1)NLATEST_ENCUMBRANCE_YEARNUMBER(15)YEARLIEST_UNTRANS_PERIOD_NAMEVARCHAR2(15)YCUM_TRANS_CODE_COMBINATION_IDNUMBER(15)YFUTURE_ENTERABLE_PERIODS_LIMITNUMBER(15)YLATEST_OPENED_PERIOD_NAMEVARCHAR2(1

11、5)YRET_EARN_CODE_COMBINATION_IDNUMBER(15)YRES_ENCUMB_CODE_COMBINATION_IDNUMBER(15)YDESCRIPTIONVARCHAR2(240)YENABLE_AVERAGE_BALANCES_FLAGVARCHAR2(1)NCONSOLIDATION_SOB_FLAGVARCHAR2(1)NTRANSLATE_EOD_FLAGVARCHAR2(1)NTRANSLATE_QATD_FLAGVARCHAR2(1)NTRANSLATE_YATD_FLAGVARCHAR2(1)NTRANSACTION_CALENDAR_IDNUM

12、BER(15)YDAILY_TRANSLATION_RATE_TYPEVARCHAR2(30)YNET_INCOME_CODE_COMBINATION_IDNUMBER(15)YGLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(30)YGLOBAL_ATTRIBUTE1VARCHAR2(150)YGLOBAL_ATTRIBUTE2VARCHAR2(150)YGLOBAL_ATTRIBUTE3VARCHAR2(150)YGLOBAL_ATTRIBUTE4VARCHAR2(150)YGLOBAL_ATTRIBUTE5VARCHAR2(150)YGLOBAL_ATTRIBUTE6V

13、ARCHAR2(150)YGLOBAL_ATTRIBUTE7VARCHAR2(150)YGLOBAL_ATTRIBUTE8VARCHAR2(150)YGLOBAL_ATTRIBUTE9VARCHAR2(150)YGLOBAL_ATTRIBUTE10VARCHAR2(150)YENABLE_AUTOMATIC_TAX_FLAGVARCHAR2(1)NENABLE_JE_APPROVAL_FLAGVARCHAR2(1)NMRC_SOB_TYPE_CODEVARCHAR2(1)NTRACK_ROUNDING_IMBALANCE_FLAGVARCHAR2(1)NROUNDING_CODE_COMBIN

14、ATION_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)N区间（日历）名PERIOD_NAME (PK)VARCHAR2(15)N区间（日历）明细名START_DATEDATEN起始日期END_DATEDATEN截至日期PERIOD_TYPEVARCHAR2(15)N区间类型PERIOD_Y

15、EARNUMBER(15)N区间年份PERIOD_NUMNUMBER(15)N区间序号QUARTER_NUMNUMBER(15)N区间季节号ENTERED_PERIOD_NAMEVARCHAR2(15)N手工输入区间明细名ADJUSTMENT_PERIOD_FLAGVARCHAR2(1)NDESCRIPTIONVARCHAR2(240)Y备注YEAR_START_DATEDATEY年度起始日期QUARTER_START_DATEDATEY季度起始日期2.3.4GL_CODE_COMBINATIONS帐户表，用于存放已选择的弹性域段值。累计型帐号，SUMMARY_FLAG = Y 且TEMPLA

16、TE_ID not NULL；明细型帐号，SUMMARY_FLAG =N 且 TEMPLATE_ID NULL。外键（FK）:主键表主键列外键列FND_ID_FLEX_STRUCTURESID_FLEX_NUMCHART_OF_ACCOUNTS_IDGL_SUMMARY_TEMPLATESTEMPLATE_IDTEMPLATE_ID快速编码列(QuickCodes)列快速编码类型快速编码表ACCOUNT_TYPEACCOUNT TYPEAELORGL_LOOKUPSAELORDETAIL_BUDGETING_ALLOWED_FLAGYES/NONYGL_LOOKUPSNoYesDETAIL_P

17、OSTING_ALLOWED_FLAGYES/NONYGL_LOOKUPSNoYesPRESERVE_FLAGYES/NONYGL_LOOKUPSNoYesREFRESH_FLAGYES/NONYGL_LOOKUPSNoYesSUMMARY_FLAGYES/NONYGL_LOOKUPSNoYes列描述名称类型可为空描述CODE_COMBINATION_IDNUMBER(15)N帐户IDCHART_OF_ACCOUNTS_IDNUMBER(15)N弹性域结构ID(=FND_ID_FLEX_STRUCTURES.ID_FLEX_NUM)DETAIL_POSTING_ALLOWED_FLAGVARC

18、HAR2(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弹性域段值。VARCHAR2(25)YDESCRIPTIONVARCHAR2(240)Y备注TEMPLATE_IDNUMBER(15)YALLOCATION_CREATE_FLAGVARCHAR2(1)YSTART_DATE_ACTIVEDATEY生效起

19、始日期END_DATE_ACTIVEDATEY生效截止日期ATTRIBUTE1VARCHAR2(150)Y。VARCHAR2(150)YSEGMENT_ATTRIBUTE1VARCHAR2(60)Y。VARCHAR2(60)YJGZZ_RECON_FLAGVARCHAR2(1)YJGZZ_RECON_CONTEXTVARCHAR2(30)YREFERENCE1VARCHAR2(1)YREFERENCE2VARCHAR2(1)YREFERENCE3VARCHAR2(1)YREFERENCE4VARCHAR2(1)YREFERENCE5VARCHAR2(1)YPRESERVE_FLAGVARCHA

20、R2(1)YREFRESH_FLAGVARCHAR2(1)YIGI_BALANCED_BUDGET_FLAGVARCHAR2(1)YCOMPANY_COST_CENTER_ORG_IDNUMBER(15)Y3日记帐3.1数据关系图3.2数据表简述表名描述相关视图备注GL_JE_BATCHES批次表GL_JE_HEADERS凭证头表GL_JE_LINES凭证分录表GL_JE_CATEGORIES_TLGL_JE_SOURCES_TLGL_ENCUMBRANCE_TYPES3.3数据表明细3.3.1GL_JE_BATCHES批次表外键（FK）:主键表主键列外键列FND_CONCURRENT_REQ

21、UESTSREQUEST_IDREQUEST_IDGL_JE_BATCHESJE_BATCH_IDPARENT_JE_BATCH_IDGL_PERIODSPERIOD_NAMEDEFAULT_PERIOD_NAMEGL_SETS_OF_BOOKSSET_OF_BOOKS_IDSET_OF_BOOKS_ID快速编码列(QuickCodes)列快速编码类型快速编码表ACTUAL_FLAGBATCH_TYPEABEGL_LOOKUPSABEAPPROVAL_STATUS_CODEJE_BATCH_APPROVAL_STATUSAIJRVZGL_LOOKUPSApprovedInRejectedReq

22、uiredValidationN/AAVERAGE_JOURNAL_FLAGAB_JOURNAL_TYPEGL_LOOKUPSNNoYYes列描述名称类型可为空描述JE_BATCH_IDNUMBER(15)N批次IDSET_OF_BOOKS_IDNUMBER(15)N帐薄IDNAMEVARCHAR2(100)NSTATUSVARCHAR2(1)NSTATUS_VERIFIEDVARCHAR2(1)NACTUAL_FLAGVARCHAR2(1)NDEFAULT_EFFECTIVE_DATEDATENBUDGETARY_CONTROL_STATUSVARCHAR2(1)NSTATUS_RESET_

23、FLAGVARCHAR2(1)YDEFAULT_PERIOD_NAMEVARCHAR2(15)YUNIQUE_DATEVARCHAR2(30)YEARLIEST_POSTABLE_DATEDATEYPOSTED_DATEDATEYDATE_CREATEDDATEYDESCRIPTIONVARCHAR2(240)YCONTROL_TOTALNUMBERYRUNNING_TOTAL_DRNUMBERYRUNNING_TOTAL_CRNUMBERYRUNNING_TOTAL_ACCOUNTED_DRNUMBERYRUNNING_TOTAL_ACCOUNTED_CRNUMBERYATTRIBUTE1V

24、ARCHAR2(150)Y。PACKET_IDNUMBER(15)YUSSGL_TRANSACTION_CODEVARCHAR2(30)YCONTEXT2VARCHAR2(150)YPOSTING_RUN_IDNUMBER(15)YREQUEST_IDNUMBER(15)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

25、凭证头表名称类型可为空描述JE_HEADER_IDNUMBER(15)凭证头IDSET_OF_BOOKS_IDNUMBER(15)帐薄IDJE_CATEGORYVARCHAR2(25)JE_SOURCEVARCHAR2(25)PERIOD_NAMEVARCHAR2(15)区间NAMEVARCHAR2(100)CURRENCY_CODEVARCHAR2(15)STATUSVARCHAR2(1)过帐标记：P 已过帐U未过帐DATE_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_DATEDATEYCREATED_BYNUMBER(15)YLAST_UPDATE_LOGINNUMBER(15)YENCUMBRANCE_TYPE_IDNUM