eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: IGI.IGI_MPP_SUBLEDGER#

Source

View Text - Preformatted


select INVOICE_ID INVOICE_ID, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SUBLEDGER_ENTRY_ID SUBLEDGER_ENTRY_ID, CURRENCY_CODE CURRENCY_CODE, ACTUAL_FLAG ACTUAL_FLAG, JE_SOURCE_NAME JE_SOURCE_NAME, JE_CATEGORY_NAME JE_CATEGORY_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, GL_DATE GL_DATE, EXPENSE_RECOGNIZED_FLAG EXPENSE_RECOGNIZED_FLAG, GL_POSTED_FLAG GL_POSTED_FLAG, CODE_COMBINATION_ID CODE_COMBINATION_ID, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, USER_CURRENCY_CONVERSION_TYPE USER_CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, PERIOD_NAME PERIOD_NAME, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, DATE_CREATED_IN_GL DATE_CREATED_IN_GL, JE_BATCH_NAME JE_BATCH_NAME, JE_BATCH_DESCRIPTION JE_BATCH_DESCRIPTION, JE_HEADER_NAME JE_HEADER_NAME, JE_LINE_DESCRIPTION JE_LINE_DESCRIPTION, REVERSE_JOURNAL_FLAG REVERSE_JOURNAL_FLAG, REVERSAL_PERIOD_NAME REVERSAL_PERIOD_NAME, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3 from "IGI"."IGI_MPP_SUBLEDGER"

View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUBLEDGER_ENTRY_ID SUBLEDGER_ENTRY_ID
, CURRENCY_CODE CURRENCY_CODE
, ACTUAL_FLAG ACTUAL_FLAG
, JE_SOURCE_NAME JE_SOURCE_NAME
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GL_DATE GL_DATE
, EXPENSE_RECOGNIZED_FLAG EXPENSE_RECOGNIZED_FLAG
, GL_POSTED_FLAG GL_POSTED_FLAG
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, USER_CURRENCY_CONVERSION_TYPE USER_CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, PERIOD_NAME PERIOD_NAME
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, DATE_CREATED_IN_GL DATE_CREATED_IN_GL
, JE_BATCH_NAME JE_BATCH_NAME
, JE_BATCH_DESCRIPTION JE_BATCH_DESCRIPTION
, JE_HEADER_NAME JE_HEADER_NAME
, JE_LINE_DESCRIPTION JE_LINE_DESCRIPTION
, REVERSE_JOURNAL_FLAG REVERSE_JOURNAL_FLAG
, REVERSAL_PERIOD_NAME REVERSAL_PERIOD_NAME
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
FROM "IGI"."IGI_MPP_SUBLEDGER"