VIEW: FA.FA_BALANCES_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, COMPANY COMPANY, COST_CENTER COST_CENTER, ACCOUNT ACCOUNT, ASSET_NUMBER ASSET_NUMBER, TAG_NUMBER TAG_NUMBER, DESCRIPTION DESCRIPTION, BEGIN_BALANCE BEGIN_BALANCE, ADDITIONS ADDITIONS, ADJUSTMENTS ADJUSTMENTS, RETIREMENTS RETIREMENTS, REVALUATIONS REVALUATIONS, RECLASSES RECLASSES, CAPITALIZATIONS CAPITALIZATIONS, TRANSFERS TRANSFERS, DEPRECIATION DEPRECIATION, AMORTIZATION AMORTIZATION, END_BALANCE END_BALANCE, OUT_OF_BALANCE_FLAG OUT_OF_BALANCE_FLAG, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, SERIAL_NUMBER SERIAL_NUMBER, ASSET_KEY ASSET_KEY, INVENTORIAL INVENTORIAL, BOOK_TYPE_CODE BOOK_TYPE_CODE, COST_ACCOUNT COST_ACCOUNT, COST_BEGIN_BALANCE COST_BEGIN_BALANCE, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, LIFE_IN_MONTHS LIFE_IN_MONTHS, STL_DEPRECIATION_RATE STL_DEPRECIATION_RATE, DEPRN_METHOD DEPRN_METHOD, CATEGORY CATEGORY, CONCAT_LOCATION CONCAT_LOCATION, CONCAT_VENDOR_NAME CONCAT_VENDOR_NAME, CONCAT_INVOICE_NUMBER CONCAT_INVOICE_NUMBER, CONCAT_INVOICE_DESCRIPTION CONCAT_INVOICE_DESCRIPTION, CONCAT_RETIREMENT_TYPE CONCAT_RETIREMENT_TYPE, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER from "FA"."FA_BALANCES_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, COMPANY COMPANY
, COST_CENTER COST_CENTER
, ACCOUNT ACCOUNT
, ASSET_NUMBER ASSET_NUMBER
, TAG_NUMBER TAG_NUMBER
, DESCRIPTION DESCRIPTION
, BEGIN_BALANCE BEGIN_BALANCE
, ADDITIONS ADDITIONS
, ADJUSTMENTS ADJUSTMENTS
, RETIREMENTS RETIREMENTS
, REVALUATIONS REVALUATIONS
, RECLASSES RECLASSES
, CAPITALIZATIONS CAPITALIZATIONS
, TRANSFERS TRANSFERS
, DEPRECIATION DEPRECIATION
, AMORTIZATION AMORTIZATION
, END_BALANCE END_BALANCE
, OUT_OF_BALANCE_FLAG OUT_OF_BALANCE_FLAG
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, SERIAL_NUMBER SERIAL_NUMBER
, ASSET_KEY ASSET_KEY
, INVENTORIAL INVENTORIAL
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, COST_ACCOUNT COST_ACCOUNT
, COST_BEGIN_BALANCE COST_BEGIN_BALANCE
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, STL_DEPRECIATION_RATE STL_DEPRECIATION_RATE
, DEPRN_METHOD DEPRN_METHOD
, CATEGORY CATEGORY
, CONCAT_LOCATION CONCAT_LOCATION
, CONCAT_VENDOR_NAME CONCAT_VENDOR_NAME
, CONCAT_INVOICE_NUMBER CONCAT_INVOICE_NUMBER
, CONCAT_INVOICE_DESCRIPTION CONCAT_INVOICE_DESCRIPTION
, CONCAT_RETIREMENT_TYPE CONCAT_RETIREMENT_TYPE
, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER
FROM "FA"."FA_BALANCES_REP_ITF"