GL Tables in oracle apps r12
GL is the General Ledger modules in Oracle Apps r12. All the AP , AR and FA modules transactions move to the GL modules in oracle apps at the end as an journals. These GL data stores in the GL tables in oracle apps r12. In this post , I will explain all the GL tables and what information's these GL tables stores in Oracle apps r12.
Oracle apps GL tables in List.
Here above is the Complete list of the GL tables in oracle apps r12.
gl_ledgers
select * from apps.gl_ledgers where ledger_id=25004
'This Table Stores the GL Ledger detail in Oracle
apps r12'
gl_je_headers
select * from apps.gl_je_headers
'This Table stores GL Journals Header Information.
Important Columns of this Table is NAME,JE_SOURCE,PERIOD_NAME,CURRENCY_CODE,STATUS’
gl_je_lines
select * from apps.gl_je_lines
'This Table stores GL Journals Lines Information.Important
Columns of this table 'ACCOUNTED_DR,ACCOUNTED_CR,ENTERED_DR,ENTERED_CR,CODE_COMBINATION_ID
GL_code_combinations
‘This table stores GL code combinations
informations.Important columns of this table is ‘CODE_COMBINATION_ID’ AND
CHART_OF_ACCOUNT_ID’
SELECT * FROM apps.GL_code_combinations
gl_je_batches
‘This table stores GL Journal Batches Informations. Important
Columns of the Table is ‘BATCH_NAME’, total Batch CR and Dr amount.
select * from apps.gl_je_batches
GL_IMPORT_REFERENCES
'Table uses to join the GL journals with the
Subledger Transactions’. Columns 'GL_SL_LINK_ID' link with the 'GL_SL_LINK_ID'
column of 'apps.xla_ae_lines' table.
Select * from apps.GL_IMPORT_REFERENCES
gl_periods
‘This table Stores GL periods name and the Start and
End of the Period.
select * from apps.gl_periods
gl_currencies
This table stores all the GL currencies Information
or we can say 'Master of the Currencies uses in the General Ledger'.
gl_daily_rates
Select * from apps.gl_daily_rates
This table stores the GL currencies Daily rates in
the system.
0 comments:
Post a Comment