General Ledger
- General Ledger is a central repository of all your financial transactions.
- All sub-ledger data (AR, AP, INV, WIP, etc.) eventually flows into General Ledger.
- At the end of each month, quarter, year one has to close your current period and open the next period on your transaction calendar.
- Financial reporting occurs out of your General Ledger.
- All financial statements are generated out of General Ledger.
- “Journal Import” is a “one stop” interface for any data that comes into GL from external sources (e.g: Sub Ledgers, external accounting systems, legacy data, etc.)
- You can recognize revenue in several currencies in a single installation of General Ledger.
- All the data from other modules will flow to GL. This data will be stored in XLA tables (subledger Accounting).
- Journal Import is the concurrent program which will send the data from XLA tables to GL base tables.
GL Tables in Oracle Apps
gl_je_headers
gl_je_lines
gl_je_batches
gl_set_of_books
gl_import_references
gl_code_combinations_kfv
gl_periods
gl_daily_rates
gl_ledgers
Subledger Tables
xla_ae_headers
xla_ae_lines
xla_distribution_links
xla_transaction_entities
Joins for GL Tables
GL_JE_HEADERS
|
JE_HEADER_ID
|
JE_BATCH_ID
|
|
EVENT_ID
|
|
GL_JE_LINES
|
JE_HEADER_ID
|
JE_LINE_ID
|
|
GL_JE_BATCHES
|
JE_BATCH_ID
|
GL_IMPORT_REFERENCES
|
JE_HEADER_ID
|
JE_LINE_ID
|
|
JE_LINE_NUM
|
|
GL_SL_LINK_TABLE
|
|
GL_SL_LINK_ID
|
|
XLA_AE_HEADERS
|
GL_SL_LINK_TABLE
|
GL_SL_LINK_ID
|
|
XLA_AE_LINES
|
GL_SL_LINK_TABLE
|
GL_SL_LINK_ID
|
|
XLA_EVENTS
|
EVENT_ID
|
ENTITY_ID
|
|
XLA_TRANSACTION_ENTITIES
|
ENTITY_ID
|
No comments:
Post a Comment