GL_JE_HEADERS stores journal entries. There is a oneâ€“toâ€“many relationship between journal entry batches and journal entries. Each row in this table includes the associated batch ID, the journal entry name and description, and other information about the journal entry. This table corresponds to the Journals window of the Enter Journals form.
STATUS is â€™Uâ€™ for unposted, â€™Pâ€™ for posted. Other statuses indicate that an error condition was found.
CONVERSION_FLAG equal to â€™Nâ€™ indicates that you manually changed a converted amount in the Journal Entry Lines zone of a foreign currency journal entry. In this case, the posting program does not reâ€“convert your foreign amounts. This can happen only if your user profile option MULTIPLE_RATES_PER_JE is â€™Yesâ€™. BALANCING_SEGMENT_VALUE is null if there is only one balancing segment value in your journal entry. If there is more than one, BALANCING_SEGMENT_VALUE is the greatest balancing segment
value in your journal entry.
GL_JE_BATCHES stores journal entry batches. Each row includes the batch name, description, status, running total debits and credits, and other information. This table corresponds to the Batch window of the Enter Journals form. STATUS is â€™Uâ€™ for unposted, â€™Pâ€™ for posted, â€™Sâ€™ for selected, â€™Iâ€™ for in the process of being posted. Other values of status indicate an error condition. STATUS_VERIFIED is â€™Nâ€™ when you create or modify an unposted journal entry batch.
The posting program changes STATUS_VERIFIED to â€™Iâ€™ when posting is in process and â€™Yâ€™ after posting is complete.