《oracle GL模块介绍》由会员分享，可在线阅读，更多相关《oracle GL模块介绍（2页珍藏版）》请在金锄头文库上搜索。
1、GL_SETS_OF_BOOKSGL_SETS_OF_BOOKS stores information about the sets of books you define in your Oracle General Ledger application. Each row includes the set of books name, description, functional currency, and other information. This table corresponds to the Set of Books form.GL_IMPORT_REFERENCESGL_I
2、MPORT_REFERENCES stores individual transactions from subledgers that have been summarized into Oracle General Ledger journal entry lines through the Journal Import process. You can specify the journal entry sources for which you want to maintain your transactions origin by entering Yes in the Import
3、 Journal References field of the Journal Sources form.For each source that has Import Journal References set to Yes, Oracle General Ledger will populate GL_IMPORT_REFERENCES with one record for each transaction in your feeder system.GL_DAILY_RATESGL_DAILY_RATES stores the daily conversion rates for
4、foreign currency transactions. It replaces the GL_DAILY_CONVERSION_RATES table.It stores the rate to use when converting between two currencies for a given conversion date and conversion type. Each row in this table has a corresponding inverse row in which the from and to currencies are switched.For
5、 example, if this table contains a row with a from_currency of YEN, a to_currency of CND, a conversion_type of Spot, and a conversion_date of January 1, 1997, it will also contain a row with a from_currency of CND, a to_currency of YEN, a conversion_type of Spot, and a conversion_date of January 1,
6、1997.In general, this row will contain a rate that is the inverse of the matching row. One should never insert directly into this table. They should instead insert into the DAILY_RATES_INTERFACE table. Data inserted into the GL_DAILY_RATES_INTERFACE table will be automatically copied into this table
7、GL_PERIODSGL_PERIODS stores information about the accounting periods you define using the Accounting Calendar form. Each row includes the start date and end date of the period, the period type, the fiscal year, the period number, and other information. There is a onetomany relationship between a row
8、 in the GL_PERIOD_SETS table and rows in this table.GL_JE_HEADERSGL_JE_HEADERS stores journal entries. There is a onetomany relationship between journal entry batches and journal entries. Each row in this table includes the associated batch ID, the journal entry name and description, and other infor
9、mation about the journal entry. This table corresponds to the Journals window of the Enter Journals form. STATUS is U for unposted, P for posted. Other statuses indicate that an error condition was found. CONVERSION_FLAG equal to N indicates that you manually changed a converted amount in the Journa
10、l Entry Lines zone of a foreign currency journal entry. In this case, the posting program does not reconvert your foreign amounts. This can happen only if your user profile option MULTIPLE_RATES_PER_JE is Yes. BALANCING_SEGMENT_VALUE is null if there is only one balancing segment value in your journ
11、al entry. If there is more than one, BALANCING_SEGMENT_VALUE is the greatest balancing segment value in your journal entry.GL_JE_LINESGL_JE_LINES stores the journal entry lines that you enter in the Enter Journals form. There is a onetomany relationship between journal entries and journal entry line
12、s. Each row in this table stores the associated journal entry header ID, the line number, the associated code combination ID, and the debits or credits associated with the journal line. STATUS is U for unposted or P for posted.GL_JE_BATCHESGL_JE_BATCHES stores journal entry batches. Each row include
13、s the batch name, description, status, running total debits and credits, and other information. This table corresponds to the Batch window of the Enter Journals form. STATUS is U for unposted, P for posted, S for selected, I for in the process of being posted. Other values of status indicate an erro
14、r condition. STATUS_VERIFIED is N when you create or modify an unposted journal entry batch.The posting program changes STATUS_VERIFIED to I when posting is in process and Y after posting is complete.GL_BALANCESGL_BALANCES stores actual, budget, and encumbrance balances for detail and summary accoun
15、ts. This table stores functional currency, foreign currency, and statistical balances for each accounting period that has ever been opened.ACTUAL_FLAG is either A, B, or E for actual, budget, or encumbrance balances, respectively. If ACTUAL_FLAG is B, then BUDGET_VERSION_ID is required. If ACTUAL_FL
16、AG is E, then ENCUMBRANCE_TYPE_ID is required.GL_BALANCES stores period activity for an account in the PERIOD_NET_DR and PERIOD_NET_CR columns. The table stores the period beginning balances in BEGIN_BALANCE_DR and BEGIN_BALANCE_CR.An accounts yeartodate balance is calculated as BEGIN_BALANCE_DR BEGIN_BALANCE_CR + PERIOD_NET_DR PERIOD_NET_CR. Detail and summary foreign currency balances that are the result of posted foreign currency jou
