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: CSI.CSI_FA_TRANSACTIONS#

Source

View Text - Preformatted


select INTERFACE_HEADER_ID INTERFACE_HEADER_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, TRANSACTION_SOURCE_TYPE TRANSACTION_SOURCE_TYPE, DISTRIBUTION_ID DISTRIBUTION_ID, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_UNITS TRANSACTION_UNITS, TRANSACTION_COST TRANSACTION_COST, PARENT_MASS_ADDITION_ID PARENT_MASS_ADDITION_ID, PA_ASSET_LINE_ID PA_ASSET_LINE_ID, TRANSFER_DISTRIBUTION_ID TRANSFER_DISTRIBUTION_ID, RETIREMENT_ID RETIREMENT_ID, STATUS_CODE STATUS_CODE, DATE_PROCESSED DATE_PROCESSED, DATE_NOTIFIED DATE_NOTIFIED, ERROR_FLAG ERROR_FLAG, ERROR_TEXT ERROR_TEXT, 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 from "CSI"."CSI_FA_TRANSACTIONS"

View Text - HTML Formatted

SELECT INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, TRANSACTION_SOURCE_TYPE TRANSACTION_SOURCE_TYPE
, DISTRIBUTION_ID DISTRIBUTION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_UNITS TRANSACTION_UNITS
, TRANSACTION_COST TRANSACTION_COST
, PARENT_MASS_ADDITION_ID PARENT_MASS_ADDITION_ID
, PA_ASSET_LINE_ID PA_ASSET_LINE_ID
, TRANSFER_DISTRIBUTION_ID TRANSFER_DISTRIBUTION_ID
, RETIREMENT_ID RETIREMENT_ID
, STATUS_CODE STATUS_CODE
, DATE_PROCESSED DATE_PROCESSED
, DATE_NOTIFIED DATE_NOTIFIED
, ERROR_FLAG ERROR_FLAG
, ERROR_TEXT ERROR_TEXT
, 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
FROM "CSI"."CSI_FA_TRANSACTIONS"