ERP_GL模块数据字典文档

ORACLE APPLICATION 应用产品 GL模块数据字典

作 者:

王新红

创建日期: January 21,2008 更新日期: January 25,2008 控制编码: 版 本: 1.0 审核人:

CCB项目负责人Oracle项目负责人

复印份数 _____

文档控制

更改记录

文档审核

文档分发

日期 作者 版本 参考文档 2008-1-21 王新红 1．0 2008-1-25 林磊

姓名 职位

编号 人员 位置 1 2 3

目录

文档控制............................................................................................................................2

更改记录......................................................................................................................2 文档审核......................................................................................................................2 文档分发......................................................................................................................2 简 介.............................................................................................................................5

文档说明......................................................................................................................5 GL模块应用实体对应的表清单.......................................................................................6

对象表清单..................................................................................................................6 GL模块应用实体表E-R模型图.........................................................................................8

会计科目值集E-R模型图...........................................................................................8 会计科目结构E-R模型图...........................................................................................8 总帐 SOB E-R模型图.................................................................................................9 日记账 E-R模型图......................................................................................................9 财务报表生成器 E-R模型图....................................................................................10 GL模块启用的描述性弹性域定义.................................................................................11

预算录入界面............................................................................................................11 汇总模板定义界面....................................................................................................11 日记账来源定义界面................................................................................................11 日记账类别定义界面................................................................................................11 事务处理日期录入界面............................................................................................11 日记账录入界面........................................................................................................12 帐套定义界面............................................................................................................12 重估界面....................................................................................................................12 自动过账集定义界面................................................................................................12 GL模块应用实体表详细描述.........................................................................................13

详细描述表清单........................................................................................................13

FND_FLEX_VALUE_SETS...........................................................................................................18 FND_FLEX_VALUES...................................................................................................................19 FND_FLEX_VALUES_TL.............................................................................................................21 FND_FLEX_VALUE_HIERARCHIES.............................................................................................21 FND_ID_FLEXS.........................................................................................................................22 FND_ID_FLEX_STRUCTURES.....................................................................................................22 FND_ID_FLEX_SEGMENTS.........................................................................................................23 GL_PERIOD_TYPES...................................................................................................................24 GL_PERIOD_SETS.....................................................................................................................25 GL_PERIODS.............................................................................................................................26

GL_TRANSACTION_CALENDAR...................................................................................................27 GL_TRANSACTION_DATES.........................................................................................................28 GL_SETS_OF_BOOKS.................................................................................................................29 FND_CURRENCIES.....................................................................................................................31 GL_CODE_COMBINATIONS.........................................................................................................33 GL_JE_SOURCES_TL.................................................. …… 此处隐藏：11613字，全部文档内容请下载后查看。喜欢就下载吧 ……