OracleEBS中文数据字典.doc

(word完整版)OracleEBS中文数据字典Oracle ERP数据字典i内容索引1总概11。1数据关系图12基础信息22。1数据关系图22.2数据表简述32。3数据表明细32.3。1GL_SETS_OF_BOOKS32.3.2GL_PERIOD_SETS52.3。3GL_PERIODS52。3。4GL_CODE_COMBINATIONS63日记帐83。1数据关系图83.2数据表简述83.3数据表明细93。3。1GL_JE_BATCHES93.3.2GL_JE_HEADERS103。3。3GL_JE_LINES124日记帐导入144。1数据关系图144。2数据表简述144。3数据表明细144.3.1gl_interface14i1 总概1.1 数据关系图1.2 数据表简述表名描述相关视图备注GL_BALANCES余额表1.3 数据表明细1.3.1 GL_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_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_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_BEQNUMBERY期初借方余额（本位币）BEGIN_BALANCE_CR_BEQNUMBERY期初贷方余额(本位币)TEMPLATE_IDNUMBER（15）YENCUMBRANCE_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.1 GL_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_COMBINATION_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_TYPESPERIOD_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_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_BUDGETARY_CONTROL_FLAGYES/NONYGL_LOOKUPSNoYesENABLE_JE_APPROVAL_FLAGYES/NONYGL_LOOKUPSNoYesREQUIRE_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_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_FLAGVARCHAR2(1)NALLOW_POSTING_WARNING_FLAGVARCHAR2（1)N是否允许过账警告ACCOUNTED_PERIOD_TYPEVARCHAR2(15)N账户期间类型SHORT_NAMEVARCHAR2(20)N帐簿简程REQUIRE_BUDGET_JOURNALS_FLAGVARCHAR2(1)N必须预算日记账ENABLE_BUDGETARY_CONTROL_FLAGVARCHAR2（1）N是否开启预算控制ALLOW_INTERCOMPANY_POST_FLAGVARCHAR2（1)N允许公司间过账LATEST_ENCUMBRANCE_YEARNUMBER(15）Y最近产权年度EARLIEST_UNTRANS_PERIOD_NAMEVARCHAR2(15)Y早期期间名CUM_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)N开启均摊期末余额CONSOLIDATION_SOB_FLAGVARCHAR2（1)NTRANSLATE_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）YGLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(30)Y全局属性类别GLOBAL_ATTRIBUTE1VARCHAR2(150）YGLOBAL_ATTRIBUTE2VARCHAR2（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)N开启自动计税ENABLE_JE_APPROVAL_FLAGVARCHAR2(1)N开启金额批准MRC_SOB_TYPE_CODEVARCHAR2(1）NTRACK_ROUNDING_IMBALANCE_FLAGVARCHAR2（1）NROUNDING_CODE_COMBINATION_IDNUMBER（15）Y2.3.2 GL_PERIOD_SETS总帐日历表名称类型可为空描述PERIOD_SET_NAME （PK)VARCHAR2(15)N区间（日历）名DESCRIPTIONVARCHAR2(240）Y备注2.3.3 GL_PERIODS总帐日历明细表名称类型可为空描述PERIOD_SET_NAME (PK）VARCHAR2(15）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_START_DATEDATEY年度起始日期QUARTER_START_DATEDATEY季度起始日期2.3.4 GL_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快速编码列（QuickCodes）列快速编码类型快速编码表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_IDNUMBER(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弹性域段值。VARCHAR2(25）YDESCRIPTIONVARCHAR2（240）Y备注TEMPLATE_IDNUMBER（15）YALLOCATION_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)YREFERENCE1VARCHAR2(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）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.1 GL_JE_BATCHES批次表外键（FK):主键表主键列外键列FND_CONCURRENT_REQUESTSREQUEST_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_LOOKUPSApprovedInRejectedRequiredValidationN/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_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_CRNUMBERYATTRIBUTE1VARCHAR2(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.2 GL_JE_HEADERS 凭证头表名称类型可为空描述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_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_DATEDATEYACCRUAL_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_DRNUMBERYRUNNING_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_VALUEVARCHAR2（25)YCR_BAL_SEG_VALUEVARCHAR2（25)YUSSGL_TRANSACTION_CODEVARCHAR2（30）YCONTEXT2VARCHAR2(150）YDOC_SEQUENCE_IDNUMBERYDOC_SEQUENCE_VALUENUMBERYJGZZ_RECON_CONTEXTVARCHAR2（30）YJGZZ_RECON_REFVARCHAR2（240)Y3.3.3 GL_JE_LINES凭证分录表名称类型可为空描述JE_HEADER_IDNUMBER（15)凭证头IDJE_LINE_NUMNUMBER(15）SET_OF_BOOKS_IDNUMBER（15)帐薄IDCODE_COMBINATION_IDNUMBER（15)帐户IDPERIOD_NAMEVARCHAR2（15）期间EFFECTIVE_DATEDATE生效日期STATUSVARCHAR2(1）状态ENTERED_DRNUMBERY录入借方ENTERED_CRNUMBERY录入贷方ACCOUNTED_DRNUMBERY本位币借方ACCOUNTED_CRNUMBERY本位币贷方DESCRIPTIONVARCHAR2(240）Y描述LINE_TYPE_CODEVARCHAR2（20）Y辅录类型编码INVOICE_DATEDATEY发票日期TAX_CODEVARCHAR2(15）Y税码INVOICE_IDENTIFIERVARCHAR2（20)Y发票标识INVOICE_AMOUNTNUMBERY发票金额NO1VARCHAR2(150）YSTAT_AMOUNTNUMBERYIGNORE_RATE_FLAGVARCHAR2（1)Y是否忽略汇率USSGL_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）YTAXABLE_LINE_FLAGVARCHAR2（1）YTAX_TYPE_CODEVARCHAR2(1)YTAX_CODE_IDNUMBER(15)YTAX_ROUNDING_RULE_CODEVARCHAR2(1)YAMOUNT_INCLUDES_TAX_FLAGVARCHAR2（1）YTAX_DOCUMENT_IDENTIFIERVARCHAR2（50)YTAX_DOCUMENT_DATEDATEYTAX_CUSTOMER_NAMEVARCHAR2(240）YTAX_CUSTOMER_REFERENCEVARCHAR2（240）YTAX_REGISTRATION_NUMBERVARCHAR2(50）YTAX_LINE_FLAGVARCHAR2(1）YTAX_GROUP_IDNUMBER(15）Y4 日记帐导入4.1 数据关系图4.2 数据表简述表名描述相关视图备注GL_INTERFACE接口表4.3 数据表明细4.3.1 GL_INTERFACE名称类型可为空无需维护描述 STATUS VARCHAR2(50） 状态：CORRECTED SET_OF_BOOKS_IDNUMBER（15）帐薄:ACCOUNTING_DATEDATE日期：sysdateCURRENCY_CODEVARCHAR2（15）币种：cnyDATE_CREATEDDATE创建日期:sysdateCREATED_BYNUMBER（15)创建人：当前useridACTUAL_FLAGVARCHAR2（1）帐务标志：A实际帐，E保留款,B预算款,默认为AUSER_JE_CATEGORY_NAMEVARCHAR2(25)类别 USER_JE_SOURCE_NAMEVARCHAR2（25)来源ENTERED_DRNUMBERY录入借方金额，根据汇率自动转化为account_drENTERED_CRNUMBERY录入贷方金额,根据汇率自动转化为account_crREFERENCE21VARCHAR2（100)Y参考字段对应gl_je_lines。reference_1，存放cc_gl_lines。lines_id分录号。以TO_CHAR作转化.Number=varcharPERIOD_NAMEVARCHAR2（15)Y区间名称CODE_COMBINATION_IDNUMBER（15)Y帐户ID.帐户ID：段组合到导入时生成ID和先组合生成ID再导入），我们先组合生成IDGROUP_IDNUMBER(15)Y分组号:同一个GROUP_ID的接口表数据进入同一个凭证.cc_gl_seq序列生成，同一个付款通知单对应同一个值CURRENCY_CONVERSION_DATEDATEYYACCOUNTED_DRNUMBERYYACCOUNTED_CRNUMBERYYTRANSACTION_DATEDATEYY 18