Search Results gl_je_lines




Here's a comprehensive description of the GL_JE_LINES table in Oracle E-Business Suite:

GL_JE_LINES Table Overview:
------------------------------
Purpose: Stores detailed journal entry line information in the General Ledger module

Key Columns:
------------
1. JE_LINE_NUM: Unique line number within a journal entry
2. JE_HEADER_ID: Foreign key referencing GL_JE_HEADERS table
3. LEDGER_ID: Identifies the specific ledger
4. CODE_COMBINATION_ID: Accounting segment combination
5. ENTERED_DR: Entered currency debit amount
6. ENTERED_CR: Entered currency credit amount
7. ACCOUNTED_DR: Accounting currency debit amount
8. ACCOUNTED_CR: Accounting currency credit amount
9. CURRENCY_CODE: Transaction currency
10. DESCRIPTION: Line description/explanation

Important Attributes:
--------------------
- Tracks individual accounting entries
- Supports multi-currency transactions
- Maintains detailed financial posting information
- Crucial for financial reporting and reconciliation

Typical Use Cases:
------------------
- Recording journal entry details
- Tracking financial transactions
- Supporting accounting and reporting processes

Recommended Analysis:
---------------------
- Performance joins with GL_JE_HEADERS
- Validate accounting entries
- Currency translation verification