The list of GL Table are:

1. GL_LEDGER
2. GL_JE_HEADERS
3. GL_JE_LINES
4. GL_CODE_COMBINATIONS
5. GL_BALANCES
6. GL_JE_BATCHES
7. GL_IMPORT_REFERENCES
8. GL_PERIODS
9. GL_CURRENCIES
10. GL_DAILY_RATES

Queries and Description of each GL Table:

• gl_ledgers stores all ledger pieces of information.

SELECT * FROM gl_ledgers; 

• gl_je_headers stores GL Journals Header Information.

SELECT * FROM gl_je_headers;

• gl_je_lines stores GL Journals Lines Information.

SELECT * FROM gl_je_lines;

• gl_ledgers stores GL code combination pieces of information.

SELECT * FROM gl_code_combinations;

• gl_balances Stores actual, budget, and encumbrance balances for detail and summary accounts.

SELECT * FROM gl_balances;

• gl_je_batches stores GL Journal Batches Informations.

SELECT * FROM gl_je_batches;

• gl_import_references is holding the reference keys between journals and sub-ledger transactions like AP&AR.

SELECT * FROM gl_import_references;

• gl_periods stores all GL period pieces of information like name, start date, and end date.

SELECT * FROM gl_periods;

• gl_currencies stores all GL the GL currencies pieces of information.

SELECT * FROM gl_currencies;

• gl_daily_rates stores all GL currencies’ Daily rates in the system.

SELECT * FROM gl_daily_rates;