VIEW: GL.GL_INTERFACE#

Source

View Text - Preformatted

select STATUS STATUS, LEDGER_ID LEDGER_ID, ACCOUNTING_DATE ACCOUNTING_DATE, CURRENCY_CODE CURRENCY_CODE, DATE_CREATED DATE_CREATED, CREATED_BY CREATED_BY, ACTUAL_FLAG ACTUAL_FLAG, USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME, USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, USER_CURRENCY_CONVERSION_TYPE USER_CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG, ORIGINATING_BAL_SEG_VALUE ORIGINATING_BAL_SEG_VALUE, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, TRANSACTION_DATE TRANSACTION_DATE, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, REFERENCE4 REFERENCE4, REFERENCE5 REFERENCE5, REFERENCE6 REFERENCE6, REFERENCE7 REFERENCE7, REFERENCE8 REFERENCE8, REFERENCE9 REFERENCE9, REFERENCE10 REFERENCE10, REFERENCE11 REFERENCE11, REFERENCE12 REFERENCE12, REFERENCE13 REFERENCE13, REFERENCE14 REFERENCE14, REFERENCE15 REFERENCE15, REFERENCE16 REFERENCE16, REFERENCE17 REFERENCE17, REFERENCE18 REFERENCE18, REFERENCE19 REFERENCE19, REFERENCE20 REFERENCE20, REFERENCE21 REFERENCE21, REFERENCE22 REFERENCE22, REFERENCE23 REFERENCE23, REFERENCE24 REFERENCE24, REFERENCE25 REFERENCE25, REFERENCE26 REFERENCE26, REFERENCE27 REFERENCE27, REFERENCE28 REFERENCE28, REFERENCE29 REFERENCE29, REFERENCE30 REFERENCE30, JE_BATCH_ID JE_BATCH_ID, PERIOD_NAME PERIOD_NAME, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, CODE_COMBINATION_ID CODE_COMBINATION_ID, DATE_CREATED_IN_GL DATE_CREATED_IN_GL, WARNING_CODE WARNING_CODE, STATUS_DESCRIPTION STATUS_DESCRIPTION, STAT_AMOUNT STAT_AMOUNT, GROUP_ID GROUP_ID, REQUEST_ID REQUEST_ID, SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID, SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, GL_SL_LINK_ID GL_SL_LINK_ID, GL_SL_LINK_TABLE GL_SL_LINK_TABLE, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, CONTEXT CONTEXT, CONTEXT2 CONTEXT2, INVOICE_DATE INVOICE_DATE, TAX_CODE TAX_CODE, INVOICE_IDENTIFIER INVOICE_IDENTIFIER, INVOICE_AMOUNT INVOICE_AMOUNT, CONTEXT3 CONTEXT3, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, DESCR_FLEX_ERROR_MESSAGE DESCR_FLEX_ERROR_MESSAGE, JGZZ_RECON_REF JGZZ_RECON_REF, REFERENCE_DATE REFERENCE_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE, MANAGEMENT_SEGMENT_VALUE MANAGEMENT_SEGMENT_VALUE, FUNDS_RESERVED_FLAG FUNDS_RESERVED_FLAG from "GL"."GL_INTERFACE"

View Text - HTML Formatted

SELECT STATUS STATUS
, LEDGER_ID LEDGER_ID
, ACCOUNTING_DATE ACCOUNTING_DATE
, CURRENCY_CODE CURRENCY_CODE
, DATE_CREATED DATE_CREATED
, CREATED_BY CREATED_BY
, ACTUAL_FLAG ACTUAL_FLAG
, USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, USER_CURRENCY_CONVERSION_TYPE USER_CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG
, ORIGINATING_BAL_SEG_VALUE ORIGINATING_BAL_SEG_VALUE
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, TRANSACTION_DATE TRANSACTION_DATE
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, REFERENCE4 REFERENCE4
, REFERENCE5 REFERENCE5
, REFERENCE6 REFERENCE6
, REFERENCE7 REFERENCE7
, REFERENCE8 REFERENCE8
, REFERENCE9 REFERENCE9
, REFERENCE10 REFERENCE10
, REFERENCE11 REFERENCE11
, REFERENCE12 REFERENCE12
, REFERENCE13 REFERENCE13
, REFERENCE14 REFERENCE14
, REFERENCE15 REFERENCE15
, REFERENCE16 REFERENCE16
, REFERENCE17 REFERENCE17
, REFERENCE18 REFERENCE18
, REFERENCE19 REFERENCE19
, REFERENCE20 REFERENCE20
, REFERENCE21 REFERENCE21
, REFERENCE22 REFERENCE22
, REFERENCE23 REFERENCE23
, REFERENCE24 REFERENCE24
, REFERENCE25 REFERENCE25
, REFERENCE26 REFERENCE26
, REFERENCE27 REFERENCE27
, REFERENCE28 REFERENCE28
, REFERENCE29 REFERENCE29
, REFERENCE30 REFERENCE30
, JE_BATCH_ID JE_BATCH_ID
, PERIOD_NAME PERIOD_NAME
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, DATE_CREATED_IN_GL DATE_CREATED_IN_GL
, WARNING_CODE WARNING_CODE
, STATUS_DESCRIPTION STATUS_DESCRIPTION
, STAT_AMOUNT STAT_AMOUNT
, GROUP_ID GROUP_ID
, REQUEST_ID REQUEST_ID
, SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, GL_SL_LINK_ID GL_SL_LINK_ID
, GL_SL_LINK_TABLE GL_SL_LINK_TABLE
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, CONTEXT CONTEXT
, CONTEXT2 CONTEXT2
, INVOICE_DATE INVOICE_DATE
, TAX_CODE TAX_CODE
, INVOICE_IDENTIFIER INVOICE_IDENTIFIER
, INVOICE_AMOUNT INVOICE_AMOUNT
, CONTEXT3 CONTEXT3
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, DESCR_FLEX_ERROR_MESSAGE DESCR_FLEX_ERROR_MESSAGE
, JGZZ_RECON_REF JGZZ_RECON_REF
, REFERENCE_DATE REFERENCE_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, MANAGEMENT_SEGMENT_VALUE MANAGEMENT_SEGMENT_VALUE
, FUNDS_RESERVED_FLAG FUNDS_RESERVED_FLAG
FROM "GL"."GL_INTERFACE"