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_MHC_LEDGER#

Source

View Text - Preformatted


select LEDGER_ENTRY_ID LEDGER_ENTRY_ID, CURRENT_PERIOD_COUNTER CURRENT_PERIOD_COUNTER, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, DISTRIBUTION_ID DISTRIBUTION_ID, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_SUB_TYPE TRANSACTION_SUB_TYPE, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, TRANSFER_STATUS TRANSFER_STATUS, TRANSFER_PERIOD_COUNTER TRANSFER_PERIOD_COUNTER, PROCESS_ID PROCESS_ID, PROCESS_MODE PROCESS_MODE, JOURNAL_DESCRIPTION JOURNAL_DESCRIPTION, JOURNAL_SOURCE JOURNAL_SOURCE, JOURNAL_DATE JOURNAL_DATE, ENTERED_DEBIT ENTERED_DEBIT, ENTERED_CREDIT ENTERED_CREDIT, AMOUNT AMOUNT, DR_CR_FLAG DR_CR_FLAG, CODE_COMBINATION_ID CODE_COMBINATION_ID, REVERSAL_LEDGER_ENTRY_ID REVERSAL_LEDGER_ENTRY_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, REFERENCE4 REFERENCE4, REFERENCE5 REFERENCE5, CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS, ACCOUNT_TYPE ACCOUNT_TYPE, FA_ADJUSTMENTS_ROWID FA_ADJUSTMENTS_ROWID, GL_JE_LINES_ROWID GL_JE_LINES_ROWID, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER from "IGI"."IGI_MHC_LEDGER"

View Text - HTML Formatted

SELECT LEDGER_ENTRY_ID LEDGER_ENTRY_ID
, CURRENT_PERIOD_COUNTER CURRENT_PERIOD_COUNTER
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, DISTRIBUTION_ID DISTRIBUTION_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_SUB_TYPE TRANSACTION_SUB_TYPE
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, TRANSFER_STATUS TRANSFER_STATUS
, TRANSFER_PERIOD_COUNTER TRANSFER_PERIOD_COUNTER
, PROCESS_ID PROCESS_ID
, PROCESS_MODE PROCESS_MODE
, JOURNAL_DESCRIPTION JOURNAL_DESCRIPTION
, JOURNAL_SOURCE JOURNAL_SOURCE
, JOURNAL_DATE JOURNAL_DATE
, ENTERED_DEBIT ENTERED_DEBIT
, ENTERED_CREDIT ENTERED_CREDIT
, AMOUNT AMOUNT
, DR_CR_FLAG DR_CR_FLAG
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, REVERSAL_LEDGER_ENTRY_ID REVERSAL_LEDGER_ENTRY_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, REFERENCE4 REFERENCE4
, REFERENCE5 REFERENCE5
, CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, ACCOUNT_TYPE ACCOUNT_TYPE
, FA_ADJUSTMENTS_ROWID FA_ADJUSTMENTS_ROWID
, GL_JE_LINES_ROWID GL_JE_LINES_ROWID
, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER
FROM "IGI"."IGI_MHC_LEDGER"