GL_JE_BATCHES
GL_JE_BATCHES contains 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.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_JE_BATCHES_PK |
JE_BATCH_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| JE_BATCH_ID | NUMBER | 18 | Yes | Journal entry batch defining column. | ||
| APPROVER_EMPLOYEE_ID | NUMBER | 18 | Defining column of the employee who submitted the journal batch for approval. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| NAME | VARCHAR2 | 100 | Yes | User entered journal batch name. | ||
| STATUS | VARCHAR2 | 1 | Yes | Journal entry batch status. Valid values from lookup MJE_BATCH_STATUS. | ||
| STATUS_VERIFIED | VARCHAR2 | 1 | Yes | Batch status verified by posting process. | ||
| ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Balance type (Actual, Budget, or Encumbrance). | ||
| DEFAULT_EFFECTIVE_DATE | DATE | Yes | Date within default accounting period. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| DEFAULT_PERIOD_NAME | VARCHAR2 | 15 | Default accounting period for journal batch. | |||
| EARLIEST_POSTABLE_DATE | DATE | Earliest date batch can be posted. | ||||
| POSTED_DATE | DATE | Date on which journal batch was posted. | ||||
| DATE_CREATED | DATE | Date on which journal batch was created. | ||||
| DESCRIPTION | VARCHAR2 | 240 | Journal entry batch description. | |||
| CONTROL_TOTAL | NUMBER | Journal batch control total column. | ||||
| RUNNING_TOTAL_DR | NUMBER | Batch running total debit in entered currency. | ||||
| RUNNING_TOTAL_CR | NUMBER | Batch running total credit in entered currency. | ||||
| RUNNING_TOTAL_ACCOUNTED_DR | NUMBER | Batch running total debit in base currency. | ||||
| RUNNING_TOTAL_ACCOUNTED_CR | NUMBER | Batch running total credit in base currency. | ||||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Journal Batches (GL_JE_BATCHES) | ||
| FUNDS_STATUS_CODE | VARCHAR2 | 30 | Journal entry batch funds check status. | |||
| BUDGETARY_CONTROL_STATUS | VARCHAR2 | 1 | Not currently used. | |||
| PACKET_ID | NUMBER | 18 | Not currently used. | |||
| ATTRIBUTE_CATEGORY2 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| POSTING_RUN_ID | NUMBER | 18 | Unique posting run sequence number. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| UNRESERVATION_PACKET_ID | NUMBER | 18 | Journal batch packet identifier for cancellation of funds reservation. | |||
| AVERAGE_JOURNAL_FLAG | VARCHAR2 | 1 | Yes | Whether or not the journal is an average balance journal. | ||
| APPROVAL_STATUS_CODE | VARCHAR2 | 1 | Yes | Journal entry batch approval status. | ||
| PARENT_JE_BATCH_ID | NUMBER | 18 | Identifier of the parent batch in the source reporting currency ledger. | |||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Key flexfield structure identifier. | ||
| PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Accounting calendar name of the accounting period. | ||
| ACCOUNTED_PERIOD_TYPE | VARCHAR2 | 15 | Yes | Accounting period type. Foreign key to GL_CALENDARS.PERIOD_TYPE. | ||
| GROUP_ID | NUMBER | Interface group identifier. | ||||
| JE_SOURCE | VARCHAR2 | 25 | Yes | Journal source. Foreign key to GL_JE_SOURCES_B. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| ERROR_MESSAGE | VARCHAR2 | 1000 | Detailed description for single validation error or a summary description of multiple validation errors. | |||
| HAS_WARNINGS_FLAG | VARCHAR2 | 1 | Indicates whether this journal batch has any associated warnings. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| AUTORUN_REQUEST_ID | NUMBER | 18 | Automate Accounting process identifier that last attempted to process an approval on this batch. | |||
| ACCOUNTING_BATCH_ID | NUMBER | 18 | Data set identifier for which this batch was created. Multiple group identifiers may be associated with the same data set identifier. Used for batches that were not created by the Journal Import process. For example, an identifier for the set of data created by a particular Create Accounting process. | |||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which when combined with the period, determines the database partition in which this journal batch will be stored. | |||
| POSTING_ELIGIBILITY_CODE | VARCHAR2 | 30 | Journal batch posting eligibility code. Possible values are ELIGIBLE, NOT_ELIGIBLE, and OVERRIDDEN. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_JE_BATCHES | gl_je_batches | PARENT_JE_BATCH_ID |
| gl_je_headers | gl_je_batches | JE_BATCH_ID |
| gl_interface | gl_je_batches | JE_BATCH_ID |
| gl_je_error_codes | gl_je_batches | JE_BATCH_ID |
| gl_je_batches | gl_je_batches | PARENT_JE_BATCH_ID |
| gl_je_action_log | gl_je_batches | JE_BATCH_ID |
| gl_import_references | gl_je_batches | JE_BATCH_ID |
| gl_interface_history | gl_je_batches | JE_BATCH_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_JE_BATCHES_N1 | Non Unique | Default | STATUS, APPROVAL_STATUS_CODE |
| GL_JE_BATCHES_N2 | Non Unique | Default | CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME, ACCOUNTED_PERIOD_TYPE, DEFAULT_PERIOD_NAME |
| GL_JE_BATCHES_N3 | Non Unique | Default | UPPER("NAME") |
| GL_JE_BATCHES_U1 | Unique | Default | JE_BATCH_ID |
| GL_JE_BATCHES_U2 | Unique | Default | NAME, DEFAULT_PERIOD_NAME, CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME, ACCOUNTED_PERIOD_TYPE |