OracleEBS中文数据字典.doc

《OracleEBS中文数据字典.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、OracleERP数据字典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、2数据表简述144.3数据表明细144.3.1gl_interface14i1总概1.1数据关系图171.1数据表简述表名描述相关视图备注GL_BALANCES余额表1.2数据表明细1.2.1GL_BALANCES名称类型可为空描述SET_OF_BOOKS_IDNUMBER(15)帐薄IdCODE_COMBINATION_IDNUMBER(15)帐户IDCURRENCY_CODEVARCHAR2(15)币种PERIOD_NAMEVARCHAR2(15)区间ACTUAL_FLAGVARCHAR2(1)标记(‘A

3、’实际款，‘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_DRNUMBE

4、RYQUARTER_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_BEQNU

5、MBERY本期借方余额(本位币)PERIOD_NET_CR_BEQNUMBERY本期贷方余额(本位币)BEGIN_BALANCE_DR_BEQNUMBERY期初借方余额(本位币)BEGIN_BALANCE_CR_BEQNUMBERY期初贷方余额(本位币)TEMPLATE_IDNUMBER(15)YENCUMBRANCE_DOC_IDNUMBER(15)YENCUMBRANCE_LINE_NUMNUMBER(15)Y171基础信息1.1数据关系图171.1数据表简述表名描述相关视图备注17GL_SETS_OF_

6、BOOKS帐簿表GL_PERIOD_SETS总帐日历表GL_PERIODS总帐日历明细表GL_PERIODS_VGL_CODE_COMBINATIONS帐户表1.1数据表明细1.1.1GL_SETS_OF_BOOKS帐簿表外键（FK）:主键表主键列外键列FND_CURRENCIESCURRENCY_CODECURRENCY_CODEFND_ID_FLEX_STRUCTURESID_FLEX_NUMCHART_OF_ACCOUNTS_IDGL_CODE_COMBINATIONSCODE_COMBINATION_

7、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_COMBINATIONSC

8、ODE_COMBINATION_IDROUNDING_CODE_COMBINATION_IDGL_DAILY_CONVERSION_TYPESCONVERSION_TYPEDAILY_TRANSLATION_RATE_TYPEGL_PERIOD_SETSPERIOD_SET_NAMEPERIOD_SET_NAMEGL_PERIOD_TYPESPERIOD_TYPEACCOUNTED_PERIOD_T