VIEW: FA.FA_PROPTAX_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, LOCATION LOCATION, STATE STATE, COMPANY COMPANY, ASSET_COST_ACCT ASSET_COST_ACCT, YEAR YEAR, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, ASSET_NUMBER ASSET_NUMBER, DESCRIPTION DESCRIPTION, UNITS UNITS, ORIGINAL_COST ORIGINAL_COST, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORIAL INVENTORIAL, TAG_NUMBER TAG_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, ASSET_KEY ASSET_KEY, COST_CENTER COST_CENTER, ASSET_CATEGORY ASSET_CATEGORY, PROPERTY_TYPE PROPERTY_TYPE, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7 from "FA"."FA_PROPTAX_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, LOCATION LOCATION
, STATE STATE
, COMPANY COMPANY
, ASSET_COST_ACCT ASSET_COST_ACCT
, YEAR YEAR
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, ASSET_NUMBER ASSET_NUMBER
, DESCRIPTION DESCRIPTION
, UNITS UNITS
, ORIGINAL_COST ORIGINAL_COST
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORIAL INVENTORIAL
, TAG_NUMBER TAG_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, ASSET_KEY ASSET_KEY
, COST_CENTER COST_CENTER
, ASSET_CATEGORY ASSET_CATEGORY
, PROPERTY_TYPE PROPERTY_TYPE
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
FROM "FA"."FA_PROPTAX_REP_ITF"