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

Source

View Text - Preformatted


select ADJUSTMENT_ID ADJUSTMENT_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, CODE_COMBINATION_ID CODE_COMBINATION_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, DR_CR_FLAG DR_CR_FLAG, AMOUNT AMOUNT, ADJUSTMENT_TYPE ADJUSTMENT_TYPE, TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG, UNITS_ASSIGNED UNITS_ASSIGNED, ASSET_ID ASSET_ID, DISTRIBUTION_ID DISTRIBUTION_ID, PERIOD_COUNTER PERIOD_COUNTER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, ADJUSTMENT_OFFSET_TYPE ADJUSTMENT_OFFSET_TYPE, REPORT_CCID REPORT_CCID, EVENT_ID EVENT_ID from "IGI"."IGI_IAC_ADJUSTMENTS"

View Text - HTML Formatted

SELECT ADJUSTMENT_ID ADJUSTMENT_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, DR_CR_FLAG DR_CR_FLAG
, AMOUNT AMOUNT
, ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG
, UNITS_ASSIGNED UNITS_ASSIGNED
, ASSET_ID ASSET_ID
, DISTRIBUTION_ID DISTRIBUTION_ID
, PERIOD_COUNTER PERIOD_COUNTER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ADJUSTMENT_OFFSET_TYPE ADJUSTMENT_OFFSET_TYPE
, REPORT_CCID REPORT_CCID
, EVENT_ID EVENT_ID
FROM "IGI"."IGI_IAC_ADJUSTMENTS"