VIEW: GL.GL_JE_HEADERS#

Source

View Text - Preformatted

select JE_HEADER_ID JE_HEADER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LEDGER_ID LEDGER_ID, JE_CATEGORY JE_CATEGORY, JE_SOURCE JE_SOURCE, PERIOD_NAME PERIOD_NAME, NAME NAME, CURRENCY_CODE CURRENCY_CODE, STATUS STATUS, DATE_CREATED DATE_CREATED, ACCRUAL_REV_FLAG ACCRUAL_REV_FLAG, MULTI_BAL_SEG_FLAG MULTI_BAL_SEG_FLAG, ACTUAL_FLAG ACTUAL_FLAG, DEFAULT_EFFECTIVE_DATE DEFAULT_EFFECTIVE_DATE, TAX_STATUS_CODE TAX_STATUS_CODE, CONVERSION_FLAG CONVERSION_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, BALANCED_JE_FLAG BALANCED_JE_FLAG, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE, JE_BATCH_ID JE_BATCH_ID, FROM_RECURRING_HEADER_ID FROM_RECURRING_HEADER_ID, UNIQUE_DATE UNIQUE_DATE, EARLIEST_POSTABLE_DATE EARLIEST_POSTABLE_DATE, POSTED_DATE POSTED_DATE, ACCRUAL_REV_EFFECTIVE_DATE ACCRUAL_REV_EFFECTIVE_DATE, ACCRUAL_REV_PERIOD_NAME ACCRUAL_REV_PERIOD_NAME, ACCRUAL_REV_STATUS ACCRUAL_REV_STATUS, ACCRUAL_REV_JE_HEADER_ID ACCRUAL_REV_JE_HEADER_ID, ACCRUAL_REV_CHANGE_SIGN_FLAG ACCRUAL_REV_CHANGE_SIGN_FLAG, DESCRIPTION DESCRIPTION, CONTROL_TOTAL CONTROL_TOTAL, RUNNING_TOTAL_DR RUNNING_TOTAL_DR, RUNNING_TOTAL_CR RUNNING_TOTAL_CR, RUNNING_TOTAL_ACCOUNTED_DR RUNNING_TOTAL_ACCOUNTED_DR, RUNNING_TOTAL_ACCOUNTED_CR RUNNING_TOTAL_ACCOUNTED_CR, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, EXTERNAL_REFERENCE EXTERNAL_REFERENCE, PARENT_JE_HEADER_ID PARENT_JE_HEADER_ID, REVERSED_JE_HEADER_ID REVERSED_JE_HEADER_ID, ORIGINATING_BAL_SEG_VALUE ORIGINATING_BAL_SEG_VALUE, INTERCOMPANY_MODE INTERCOMPANY_MODE, DR_BAL_SEG_VALUE DR_BAL_SEG_VALUE, CR_BAL_SEG_VALUE CR_BAL_SEG_VALUE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, CONTEXT CONTEXT, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, CONTEXT2 CONTEXT2, DOC_SEQUENCE_ID DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE, JGZZ_RECON_CONTEXT JGZZ_RECON_CONTEXT, JGZZ_RECON_REF JGZZ_RECON_REF, REFERENCE_DATE REFERENCE_DATE, LOCAL_DOC_SEQUENCE_ID LOCAL_DOC_SEQUENCE_ID, LOCAL_DOC_SEQUENCE_VALUE LOCAL_DOC_SEQUENCE_VALUE, DISPLAY_ALC_JOURNAL_FLAG DISPLAY_ALC_JOURNAL_FLAG, JE_FROM_SLA_FLAG JE_FROM_SLA_FLAG, POSTING_ACCT_SEQ_VERSION_ID POSTING_ACCT_SEQ_VERSION_ID, POSTING_ACCT_SEQ_ASSIGN_ID POSTING_ACCT_SEQ_ASSIGN_ID, POSTING_ACCT_SEQ_VALUE POSTING_ACCT_SEQ_VALUE, CLOSE_ACCT_SEQ_VERSION_ID CLOSE_ACCT_SEQ_VERSION_ID, CLOSE_ACCT_SEQ_ASSIGN_ID CLOSE_ACCT_SEQ_ASSIGN_ID, CLOSE_ACCT_SEQ_VALUE CLOSE_ACCT_SEQ_VALUE from "GL"."GL_JE_HEADERS"

View Text - HTML Formatted

SELECT JE_HEADER_ID JE_HEADER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LEDGER_ID LEDGER_ID
, JE_CATEGORY JE_CATEGORY
, JE_SOURCE JE_SOURCE
, PERIOD_NAME PERIOD_NAME
, NAME NAME
, CURRENCY_CODE CURRENCY_CODE
, STATUS STATUS
, DATE_CREATED DATE_CREATED
, ACCRUAL_REV_FLAG ACCRUAL_REV_FLAG
, MULTI_BAL_SEG_FLAG MULTI_BAL_SEG_FLAG
, ACTUAL_FLAG ACTUAL_FLAG
, DEFAULT_EFFECTIVE_DATE DEFAULT_EFFECTIVE_DATE
, TAX_STATUS_CODE TAX_STATUS_CODE
, CONVERSION_FLAG CONVERSION_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, BALANCED_JE_FLAG BALANCED_JE_FLAG
, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, JE_BATCH_ID JE_BATCH_ID
, FROM_RECURRING_HEADER_ID FROM_RECURRING_HEADER_ID
, UNIQUE_DATE UNIQUE_DATE
, EARLIEST_POSTABLE_DATE EARLIEST_POSTABLE_DATE
, POSTED_DATE POSTED_DATE
, ACCRUAL_REV_EFFECTIVE_DATE ACCRUAL_REV_EFFECTIVE_DATE
, ACCRUAL_REV_PERIOD_NAME ACCRUAL_REV_PERIOD_NAME
, ACCRUAL_REV_STATUS ACCRUAL_REV_STATUS
, ACCRUAL_REV_JE_HEADER_ID ACCRUAL_REV_JE_HEADER_ID
, ACCRUAL_REV_CHANGE_SIGN_FLAG ACCRUAL_REV_CHANGE_SIGN_FLAG
, DESCRIPTION DESCRIPTION
, CONTROL_TOTAL CONTROL_TOTAL
, RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, RUNNING_TOTAL_ACCOUNTED_DR RUNNING_TOTAL_ACCOUNTED_DR
, RUNNING_TOTAL_ACCOUNTED_CR RUNNING_TOTAL_ACCOUNTED_CR
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, PARENT_JE_HEADER_ID PARENT_JE_HEADER_ID
, REVERSED_JE_HEADER_ID REVERSED_JE_HEADER_ID
, ORIGINATING_BAL_SEG_VALUE ORIGINATING_BAL_SEG_VALUE
, INTERCOMPANY_MODE INTERCOMPANY_MODE
, DR_BAL_SEG_VALUE DR_BAL_SEG_VALUE
, CR_BAL_SEG_VALUE CR_BAL_SEG_VALUE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, CONTEXT CONTEXT
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, CONTEXT2 CONTEXT2
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, JGZZ_RECON_CONTEXT JGZZ_RECON_CONTEXT
, JGZZ_RECON_REF JGZZ_RECON_REF
, REFERENCE_DATE REFERENCE_DATE
, LOCAL_DOC_SEQUENCE_ID LOCAL_DOC_SEQUENCE_ID
, LOCAL_DOC_SEQUENCE_VALUE LOCAL_DOC_SEQUENCE_VALUE
, DISPLAY_ALC_JOURNAL_FLAG DISPLAY_ALC_JOURNAL_FLAG
, JE_FROM_SLA_FLAG JE_FROM_SLA_FLAG
, POSTING_ACCT_SEQ_VERSION_ID POSTING_ACCT_SEQ_VERSION_ID
, POSTING_ACCT_SEQ_ASSIGN_ID POSTING_ACCT_SEQ_ASSIGN_ID
, POSTING_ACCT_SEQ_VALUE POSTING_ACCT_SEQ_VALUE
, CLOSE_ACCT_SEQ_VERSION_ID CLOSE_ACCT_SEQ_VERSION_ID
, CLOSE_ACCT_SEQ_ASSIGN_ID CLOSE_ACCT_SEQ_ASSIGN_ID
, CLOSE_ACCT_SEQ_VALUE CLOSE_ACCT_SEQ_VALUE
FROM "GL"."GL_JE_HEADERS"