Search Results gl_je_headers




Here's a comprehensive description of the GL_JE_HEADERS table in Oracle E-Business Suite's General Ledger module:

Table Name: GL_JE_HEADERS
Purpose: Stores header-level information for journal entries in the General Ledger

Key Columns:
1. JE_HEADER_ID (Primary Key)
- Unique identifier for each journal entry
- Automatically generated sequence number
- Used to link with GL_JE_LINES table

2. LEDGER_ID
- Identifies the specific ledger associated with the journal entry
- Links to GL_LEDGERS table

3. STATUS
- Indicates current processing status of journal entry
- Common values: 'U' (Unposted), 'P' (Posted), 'R' (Reversed)

4. PERIOD_NAME
- Accounting period when journal entry is recorded
- Links to GL_PERIODS table

5. CREATED_BY
- User ID of journal entry creator
- Links to FND_USER table

6. CREATION_DATE
- Timestamp when journal entry was created

7. CURRENCY_CODE
- Transaction currency of journal entry
- Typically links to FND_CURRENCIES table

8. ACTUAL_FLAG
- Indicates whether entry is actual/budgetary
- 'A' for actual transactions

9. SOURCE_CATEGORY
- Identifies journal entry's origin (manual, imported, etc.)

10. REFERENCE_DATE
- Date of original transaction or reference document

Typical Use Cases:
- Recording financial transactions
- Supporting accounting entries
- Tracking journal entry lifecycle
- Enabling financial reporting and analysis

Key Relationships:
- GL_JE_LINES (Detail lines)
- GL_LEDGERS (Ledger information)
- GL_PERIODS (Accounting periods)