请问gl_code_combinations这个表在总帐管理系统的几个表中的作用。

Levin

做个报表开发一个多月啦，每次对着那几个熟翻的表觉得熟悉却又陌生。还是不清楚gl_code_combinations在这几个表中的关键作用是什么。只知道他起到一个连接充当桥梁的作用吧。例如GL_BALANCES呀，GL_JE_BATCH之类都有一个code_combination_id.请大家详细介绍一下COA里面的这些表的结构与连接关系，以及整个操作的实质流程是怎样。谢谢你的回复~~~~！

纵横四海

会计科目弹性域的值存放在表gl_code_combinations中，在总帐和其他子模块只要和科目有关系的表都会有类似于code_combination_id的字段。

gl_code_combinations表中的键弹性域列包括三十个 SEGMENTn 列、CODE_COMBINATION_ID 列及 CHART_OF_ACCOUNTS_ID 列（结构列）。DETAIL_POSTING_ALLOWED_FLAG、DETAIL_BUDGETING_ALLOWED_FLAG 及 ACCOUNT_TYPE 是弹性域的段限定词列。弹性域也使用 ENABLED_FLAG、SUMMARY_FLAG、START_DATE_ACTIVE 及 END_DATE_ACTIVE 来确定组合状态。
请注意，GL_CODE_COMBINATIONS 表包含键弹性域列，但也包含许多其它的列。LAST_UPDATE_DATE 和 LAST_UPDATED_BY 列提供 Who 功能的信息。ATTRIBUTEn 和 CONTEXT 列属于描述性弹性域，并且 SEGMENT_ATTRIBUTEn 列属于 Oracle 公共部门财务产品使用的特殊弹性域。由于其它列不是会计弹性域直接使用的列，因此它们全部在弹性域视图中显示。


GL_CODE_COMBINATIONS stores valid account combinations for each Accounting Flexfield structure within your Oracle General Ledger application. Associated with each account are certain codes and flags, including whether the account is enabled, whether detail posting or detail budgeting is allowed, and others.
Segment values are stored in the SEGMENT columns. Note that each Accounting Flexfield structure may use different SEGMENT columns within the table to store the flexfield value combination. Moreover, the SEGMENT columns that are used are not guaranteed to be in any order.

The above is a quote of the standard table introduction.

In short, a GL code combination is used in a transaction like an invoice (invoice lines), a payment, a receipt, etc. (all these are transactions in sub entities, like AP, AR, FA, etc.). When you post such transactions into GL, the code combination will tell GL how to distribute/store the information into different account.

Another point related to this is the GL code combination is closely related to a concept called Key Flexfield in Oracle Applications, which again is related to how to set up your COA (chart of account). Key Flexfield is the way to implement the chart of account, and the chart of account the structure to store the accounting information.

sunweijie22

哦！了解了