DBA Data[Home] [Help] [Dependency Information]

TABLE: GL.GL_JE_BATCHES

Object Details
Object Name: GL_JE_BATCHES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_JE_BATCHES
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_JE_BATCHES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnJE_BATCH_ID
GL_JE_BATCHES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnDEFAULT_PERIOD_NAME
ColumnCHART_OF_ACCOUNTS_ID
ColumnPERIOD_SET_NAME
ColumnACCOUNTED_PERIOD_TYPE
GL_JE_BATCHES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
JE_BATCH_ID NUMBER (15) Yes Journal entry batch defining column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
SET_OF_BOOKS_ID_11I NUMBER (15)
No Longer Used in R12
NAME VARCHAR2 (100) Yes Name of journal entry batch
STATUS VARCHAR2 (1) Yes Journal entry 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
AVERAGE_JOURNAL_FLAG VARCHAR2 (1) Yes Average journal flag
BUDGETARY_CONTROL_STATUS VARCHAR2 (1) Yes Journal entry batch funds check status
APPROVAL_STATUS_CODE VARCHAR2 (1) Yes Journal entry batch approval status
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
STATUS_RESET_FLAG VARCHAR2 (1)
No longer used
DEFAULT_PERIOD_NAME VARCHAR2 (15)
Accounting period for batch
UNIQUE_DATE VARCHAR2 (30)
No longer used
EARLIEST_POSTABLE_DATE DATE

Earliest date batch can be posted
POSTED_DATE DATE

Date batch was posted
DATE_CREATED DATE

Date batch was created
DESCRIPTION VARCHAR2 (240)
Journal entry batch description
CONTROL_TOTAL NUMBER

Control total column
RUNNING_TOTAL_DR NUMBER

Batch running total debit, entered currency
RUNNING_TOTAL_CR NUMBER

Batch running total credit, entered currency
RUNNING_TOTAL_ACCOUNTED_DR NUMBER

Batch running total debit, base currency
RUNNING_TOTAL_ACCOUNTED_CR NUMBER

Batch running total credit, base currency
PARENT_JE_BATCH_ID NUMBER (15)
Defining column of the parent batch in the source reporting currency ledger
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
CONTEXT VARCHAR2 (150)
Descriptive flexfield context column
UNRESERVATION_PACKET_ID NUMBER (15)
Packet defining column for last funds unreservation of batch
PACKET_ID NUMBER (15)
Packet defining column for last funds check of the batch
USSGL_TRANSACTION_CODE VARCHAR2 (30)
Government transaction code
CONTEXT2 VARCHAR2 (150)
Descriptive flexfield structure defining column
POSTING_RUN_ID NUMBER (15)
Posting sequence number
REQUEST_ID NUMBER (15)
Posting concurrent request id
ORG_ID NUMBER (15)
Organization defining column
POSTED_BY NUMBER (15)
User who posted the journal batch
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes Key flexfield structure defining column
PERIOD_SET_NAME VARCHAR2 (15) Yes Accounting calendar name
ACCOUNTED_PERIOD_TYPE VARCHAR2 (15) Yes Accounting period type
GROUP_ID NUMBER

Interface group identifying column
APPROVER_EMPLOYEE_ID NUMBER (15)
Defining column of the employee who submitted the journal batch for approval
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT JE_BATCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SET_OF_BOOKS_ID_11I
,      NAME
,      STATUS
,      STATUS_VERIFIED
,      ACTUAL_FLAG
,      DEFAULT_EFFECTIVE_DATE
,      AVERAGE_JOURNAL_FLAG
,      BUDGETARY_CONTROL_STATUS
,      APPROVAL_STATUS_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STATUS_RESET_FLAG
,      DEFAULT_PERIOD_NAME
,      UNIQUE_DATE
,      EARLIEST_POSTABLE_DATE
,      POSTED_DATE
,      DATE_CREATED
,      DESCRIPTION
,      CONTROL_TOTAL
,      RUNNING_TOTAL_DR
,      RUNNING_TOTAL_CR
,      RUNNING_TOTAL_ACCOUNTED_DR
,      RUNNING_TOTAL_ACCOUNTED_CR
,      PARENT_JE_BATCH_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      UNRESERVATION_PACKET_ID
,      PACKET_ID
,      USSGL_TRANSACTION_CODE
,      CONTEXT2
,      POSTING_RUN_ID
,      REQUEST_ID
,      ORG_ID
,      POSTED_BY
,      CHART_OF_ACCOUNTS_ID
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      GROUP_ID
,      APPROVER_EMPLOYEE_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
FROM GL.GL_JE_BATCHES;

Dependencies

[top of page]

GL.GL_JE_BATCHES does not reference any database object

GL.GL_JE_BATCHES is referenced by following:

SchemaAPPS
SynonymGL_JE_BATCHES