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: FA.FA_ADJUSTMENTS#

Source

View Text - Preformatted


select TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, ADJUSTMENT_TYPE ADJUSTMENT_TYPE, DEBIT_CREDIT_FLAG DEBIT_CREDIT_FLAG, CODE_COMBINATION_ID CODE_COMBINATION_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT, DISTRIBUTION_ID DISTRIBUTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ANNUALIZED_ADJUSTMENT ANNUALIZED_ADJUSTMENT, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, PERIOD_COUNTER_ADJUSTED PERIOD_COUNTER_ADJUSTED, PERIOD_COUNTER_CREATED PERIOD_COUNTER_CREATED, ASSET_INVOICE_ID ASSET_INVOICE_ID, 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, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, DEPRN_OVERRIDE_FLAG DEPRN_OVERRIDE_FLAG, TRACK_MEMBER_FLAG TRACK_MEMBER_FLAG, ADJUSTMENT_LINE_ID ADJUSTMENT_LINE_ID, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_DEST_CODE SOURCE_DEST_CODE, INSERTION_ORDER INSERTION_ORDER from "FA"."FA_ADJUSTMENTS"

View Text - HTML Formatted

SELECT TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, DEBIT_CREDIT_FLAG DEBIT_CREDIT_FLAG
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT
, DISTRIBUTION_ID DISTRIBUTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ANNUALIZED_ADJUSTMENT ANNUALIZED_ADJUSTMENT
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, PERIOD_COUNTER_ADJUSTED PERIOD_COUNTER_ADJUSTED
, PERIOD_COUNTER_CREATED PERIOD_COUNTER_CREATED
, ASSET_INVOICE_ID ASSET_INVOICE_ID
, 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
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, DEPRN_OVERRIDE_FLAG DEPRN_OVERRIDE_FLAG
, TRACK_MEMBER_FLAG TRACK_MEMBER_FLAG
, ADJUSTMENT_LINE_ID ADJUSTMENT_LINE_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_DEST_CODE SOURCE_DEST_CODE
, INSERTION_ORDER INSERTION_ORDER
FROM "FA"."FA_ADJUSTMENTS"