GL Je Tables
GL Je Tables
GL Je Tables
GL_JE_HEADER 1 JE_HEADER_ID NUMBER 15 NOT NULL Journal entry header defining column
GL_JE_HEADER 2 LAST_UPDATE_DATE DATE NOT NULL Standard Who column
GL_JE_HEADER 3 LAST_UPDATED_BY NUMBER 15 NOT NULL Standard Who column
GL_JE_HEADER 4 SET_OF_BOOKS_ID NUMBER 15 NOT NULL Accounting books defining column
GL_JE_HEADER 5 JE_CATEGORY VARCHAR2 25 NOT NULL Journal entry category
GL_JE_HEADER 6 JE_SOURCE VARCHAR2 25 NOT NULL Journal entry source
GL_JE_HEADER 7 PERIOD_NAME VARCHAR2 15 NOT NULL Accounting period
GL_JE_HEADER 8 NAME VARCHAR2 100 NOT NULL Journal entry header name
GL_JE_HEADER 9 CURRENCY_CODE VARCHAR2 15 NOT NULL Currency
GL_JE_HEADER 10 STATUS VARCHAR2 1 NOT NULL Journal entry header status lookup code
GL_JE_HEADER 11 DATE_CREATED DATE NOT NULL Date header created in GL
GL_JE_HEADER 12 ACCRUAL_REV_FLAG VARCHAR2 1 NOT NULL Reversed journal entry flag
GL_JE_HEADER 13 MULTI_BAL_SEG_FLAG VARCHAR2 1 NOT NULL Multiple balancing segment flag
GL_JE_HEADER 14 ACTUAL_FLAG VARCHAR2 1 NOT NULL Balance type (Actual, Budget, or Encumbrance)
GL_JE_HEADER 15 DEFAULT_EFFECTIVE_DATE DATE NOT NULL Journal entry effective date
GL_JE_HEADER 16 TAX_STATUS_CODE VARCHAR2 1 NOT NULL Journal entry tax status
GL_JE_HEADER 17 CONVERSION_FLAG VARCHAR2 1 NULL Currency conversion flag
GL_JE_HEADER 18 CREATION_DATE DATE NULL Standard Who column
GL_JE_HEADER 19 CREATED_BY NUMBER 15 NULL Standard Who column
GL_JE_HEADER 20 LAST_UPDATE_LOGIN NUMBER 15 NULL Standard Who column
GL_JE_HEADER 21 ENCUMBRANCE_TYPE_ID NUMBER 15 NULL Encumbrance type defining column
GL_JE_HEADER 22 BUDGET_VERSION_ID NUMBER 15 NULL Budget version defining column
GL_JE_HEADER 23 BALANCED_JE_FLAG VARCHAR2 1 NULL Balanced journal entry flag
GL_JE_HEADER 24 BALANCING_SEGMENT_VALUE VARCHAR2 25 NULL Key flexfield structure balancing segment value
GL_JE_HEADER 25 JE_BATCH_ID NUMBER 15 NULL Journal entry batch defining column
GL_JE_HEADER 26 FROM_RECURRING_HEADER_ID NUMBER 15 NULL Recurring batch header defining column
GL_JE_HEADER 27 UNIQUE_DATE VARCHAR2 30 NULL No longer used
GL_JE_HEADER 28 EARLIEST_POSTABLE_DATE DATE NULL Earliest date journal entry header can be posted
GL_JE_HEADER 29 POSTED_DATE DATE NULL Date journal entry header was posted
GL_JE_HEADER 30 ACCRUAL_REV_EFFECTIVE_DATE DATE NULL Reversed journal entry effective date
GL_JE_HEADER 31 ACCRUAL_REV_PERIOD_NAME VARCHAR2 15 NULL Reversed journal entry reversal period
GL_JE_HEADER 32 ACCRUAL_REV_STATUS VARCHAR2 1 NULL Reversed journal entry status
GL_JE_HEADER 33 ACCRUAL_REV_JE_HEADER_ID NUMBER 15 NULL Reversed journal entry defining column
GL_JE_HEADER 34 ACCRUAL_REV_CHANGE_SIGN_FLAG
VARCHAR2 1 NOT NULL Type of reversal (Change Sign or Switch Dr/Cr)
GL_JE_HEADER 35 DESCRIPTION VARCHAR2 240 NULL Journal entry description
GL_JE_HEADER 36 CONTROL_TOTAL NUMBER NULL Control total column
GL_JE_HEADER 37 RUNNING_TOTAL_DR NUMBER NULL Journal entry running total debits, entered currency
GL_JE_HEADER 38 RUNNING_TOTAL_CR NUMBER NULL Journal entry running total credits, entered currency
GL_JE_HEADER 39 RUNNING_TOTAL_ACCOUNTED_DR NUMBER NULL Journal entry running total debits, base currency
GL_JE_HEADER 40 RUNNING_TOTAL_ACCOUNTED_CR NUMBER NULL Journal entry running total credits, base currency
GL_JE_HEADER 41 CURRENCY_CONVERSION_RATE NUMBER NULL Currency exchange rate
GL_JE_HEADER 42 CURRENCY_CONVERSION_TYPE VARCHAR2 30 NULL Type of currency exchange rate
GL_JE_HEADER 43 CURRENCY_CONVERSION_DATE DATE NULL Currency conversion date
GL_JE_HEADER 44 EXTERNAL_REFERENCE VARCHAR2 80 NULL Extra reference column
GL_JE_HEADER 45 PARENT_JE_HEADER_ID NUMBER 15 NULL Defining column of the parent journal entry in the primary MRC book
GL_JE_HEADER 46 REVERSED_JE_HEADER_ID NUMBER 15 NULL Defining column of the journal entry that is reversed by this journal entr
GL_JE_HEADER 47 ORIGINATING_BAL_SEG_VALUE VARCHAR2 25 NULL Originating balancing segment value
GL_JE_HEADER 48 INTERCOMPANY_MODE NUMBER 15 NULL Intercompany mode for the journal. Valid values are 1 through 4.
GL_JE_HEADER 49 DR_BAL_SEG_VALUE VARCHAR2 25 NULL Balancing segment value used on the debit side of an intercompany jou
GL_JE_HEADER 50 CR_BAL_SEG_VALUE VARCHAR2 25 NULL Balancing segment value used on the credit side of an intercompany jo
GL_JE_HEADER 51 ATTRIBUTE1 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 52 ATTRIBUTE2 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 53 ATTRIBUTE3 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 54 ATTRIBUTE4 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 55 ATTRIBUTE5 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 56 ATTRIBUTE6 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 57 ATTRIBUTE7 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 58 ATTRIBUTE8 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 59 ATTRIBUTE9 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 60 ATTRIBUTE10 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_HEADER 61 CONTEXT VARCHAR2 150 NULL Descriptive flexfield context column
GL_JE_HEADER 62 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 NULL Reserved for country-specific functionality
GL_JE_HEADER 63 GLOBAL_ATTRIBUTE1 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 64 GLOBAL_ATTRIBUTE2 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 65 GLOBAL_ATTRIBUTE3 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 66 GLOBAL_ATTRIBUTE4 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 67 GLOBAL_ATTRIBUTE5 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 68 GLOBAL_ATTRIBUTE6 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 69 GLOBAL_ATTRIBUTE7 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 70 GLOBAL_ATTRIBUTE8 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 71 GLOBAL_ATTRIBUTE9 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 72 GLOBAL_ATTRIBUTE10 VARCHAR2 150 NULL Reserved for country-specific functionality
GL_JE_HEADER 73 USSGL_TRANSACTION_CODE VARCHAR2 30 NULL Government transaction code
GL_JE_HEADER 74 CONTEXT2 VARCHAR2 150 NULL Descriptive flexfield structure defining column
GL_JE_HEADER 75 DOC_SEQUENCE_ID NUMBER NULL Sequential numbering sequence defining column
GL_JE_HEADER 76 DOC_SEQUENCE_VALUE NUMBER NULL Sequential numbering sequence value
GL_JE_HEADER 77 JGZZ_RECON_CONTEXT VARCHAR2 30 NULL Context column for Global Reconciliation Descriptive Flexfield
GL_JE_HEADER 78 JGZZ_RECON_REF VARCHAR2 240 NULL Global Reconciliation Descriptive Flexfield segment
GL_JE_HEADER 79 REFERENCE_DATE DATE NULL Reference Date
GL_JE_HEADER 80 LOCAL_DOC_SEQUENCE_ID NUMBER NULL Sequential numbering sequence defining column for local requirement
GL_JE_HEADER 81 LOCAL_DOC_SEQUENCE_VALUE NUMBER NULL Sequential numbering sequence value for local requirement purposes
GL_JE_BATCH 1 JE_BATCH_ID NUMBER 15 NOT NULL Journal entry batch defining column
GL_JE_BATCH 2 LAST_UPDATE_DATE DATE NOT NULL Standard Who column
GL_JE_BATCH 3 LAST_UPDATED_BY NUMBER 15 NOT NULL Standard Who column
GL_JE_BATCH 4 SET_OF_BOOKS_ID NUMBER 15 NOT NULL Accounting books defining column
GL_JE_BATCH 5 NAME VARCHAR2 100 NOT NULL Name of journal entry batch
GL_JE_BATCH 6 STATUS VARCHAR2 1 NOT NULL Journal entry batch status
GL_JE_BATCH 7 STATUS_VERIFIED VARCHAR2 1 NOT NULL Batch status verified by posting process
GL_JE_BATCH 8 ACTUAL_FLAG VARCHAR2 1 NOT NULL Balance type (Actual, Budget, or Encumbrance)
GL_JE_BATCH 9 DEFAULT_EFFECTIVE_DATE DATE NOT NULL Date within default accounting period
GL_JE_BATCH 10 AVERAGE_JOURNAL_FLAG VARCHAR2 1 NOT NULL Average journal flag
GL_JE_BATCH 11 BUDGETARY_CONTROL_STATUS VARCHAR2 1 NOT NULL Journal entry batch funds check status
GL_JE_BATCH 12 APPROVAL_STATUS_CODE VARCHAR2 1 NOT NULL Journal entry batch approval status
GL_JE_BATCH 13 CREATION_DATE DATE NULL Standard Who column
GL_JE_BATCH 14 CREATED_BY NUMBER 15 NULL Standard Who column
GL_JE_BATCH 15 LAST_UPDATE_LOGIN NUMBER 15 NULL Standard Who column
GL_JE_BATCH 16 STATUS_RESET_FLAG VARCHAR2 1 NULL No longer used
GL_JE_BATCH 17 DEFAULT_PERIOD_NAME VARCHAR2 15 NULL Accounting period for batch
GL_JE_BATCH 18 UNIQUE_DATE VARCHAR2 30 NULL No longer used
GL_JE_BATCH 19 EARLIEST_POSTABLE_DATE DATE NULL Earliest date batch can be posted
GL_JE_BATCH 20 POSTED_DATE DATE NULL Date batch was posted
GL_JE_BATCH 21 DATE_CREATED DATE NULL Date batch was created
GL_JE_BATCH 22 DESCRIPTION VARCHAR2 240 NULL Journal entry batch description
GL_JE_BATCH 23 CONTROL_TOTAL NUMBER NULL Control total column
GL_JE_BATCH 24 RUNNING_TOTAL_DR NUMBER NULL Batch running total debit, entered currency
GL_JE_BATCH 25 RUNNING_TOTAL_CR NUMBER NULL Batch running total credit, entered currency
GL_JE_BATCH 26 RUNNING_TOTAL_ACCOUNTED_DR NUMBER NULL Batch running total debit, base currency
GL_JE_BATCH 27 RUNNING_TOTAL_ACCOUNTED_CR NUMBER NULL Batch running total credit, base currency
GL_JE_BATCH 28 PARENT_JE_BATCH_ID NUMBER 15 NULL Defining column of the parent batch in the primary MRC book
GL_JE_BATCH 29 ATTRIBUTE1 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 30 ATTRIBUTE2 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 31 ATTRIBUTE3 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 32 ATTRIBUTE4 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 33 ATTRIBUTE5 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 34 ATTRIBUTE6 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 35 ATTRIBUTE7 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 36 ATTRIBUTE8 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 37 ATTRIBUTE9 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 38 ATTRIBUTE10 VARCHAR2 150 NULL Descriptive flexfield segment
GL_JE_BATCH 39 CONTEXT VARCHAR2 150 NULL Descriptive flexfield context column
GL_JE_BATCH 40 UNRESERVATION_PACKET_ID NUMBER 15 NULL Packet defining column for last funds unreservation of batch
GL_JE_BATCH 41 PACKET_ID NUMBER 15 NULL Packet defining column for last funds check of the batch
GL_JE_BATCH 42 USSGL_TRANSACTION_CODE VARCHAR2 30 NULL Government transaction code
GL_JE_BATCH 43 CONTEXT2 VARCHAR2 150 NULL Descriptive flexfield structure defining column
GL_JE_BATCH 44 POSTING_RUN_ID NUMBER 15 NULL Posting sequence number
GL_JE_BATCH 45 REQUEST_ID NUMBER 15 NULL Posting concurrent request id
GL_JE_BATCH 46 ORG_ID NUMBER 15 NULL Organization defining column
primary MRC book
ed by this journal entry
are 1 through 4.
of an intercompany journal. This column is meaningful only for intercompany modes 1 and 2.
of an intercompany journal. This column is meaningful only for intercompany modes 1 and 3.
tive Flexfield
on of batch