VIEW: JG.JG_ZZ_FA_REG_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, ORGANIZATION_NAME ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, MAJOR_CATEGORY MAJOR_CATEGORY, MINOR_CATEGORY MINOR_CATEGORY, DEPRN_RATE DEPRN_RATE, STARTING_DEPRN_YEAR STARTING_DEPRN_YEAR, ASSET_HEADING ASSET_HEADING, ASSET_NUMBER ASSET_NUMBER, DESCRIPTION DESCRIPTION, PARENT_ASSET_ID PARENT_ASSET_ID, PARENT_ASSET_NUMBER PARENT_ASSET_NUMBER, ASSET_COST_ORIG ASSET_COST_ORIG, BONUS_RATE BONUS_RATE, INVOICE_NUMBER INVOICE_NUMBER, SUPPLIER_NAME SUPPLIER_NAME, COST_ACCOUNT COST_ACCOUNT, EXPENSE_ACCOUNT EXPENSE_ACCOUNT, RESERVE_ACCOUNT RESERVE_ACCOUNT, BONUS_DEPRN_ACCOUNT BONUS_DEPRN_ACCOUNT, BONUS_RESERVE_ACCOUNT BONUS_RESERVE_ACCOUNT, ASSET_COST_INITIAL ASSET_COST_INITIAL, ASSET_COST_INCREASE ASSET_COST_INCREASE, ASSET_COST_DECREASE ASSET_COST_DECREASE, ASSET_COST_FINAL ASSET_COST_FINAL, REVALUATION_INITIAL REVALUATION_INITIAL, REVALUATION_INCREASE REVALUATION_INCREASE, REVALUATION_DECREASE REVALUATION_DECREASE, REVALUATION_FINAL REVALUATION_FINAL, DEPRN_RESERVE_INITIAL DEPRN_RESERVE_INITIAL, DEPRN_RESERVE_INCREASE DEPRN_RESERVE_INCREASE, DEPRN_RESERVE_DECREASE DEPRN_RESERVE_DECREASE, DEPRN_RESERVE_FINAL DEPRN_RESERVE_FINAL, BONUS_RESERVE_INITIAL BONUS_RESERVE_INITIAL, BONUS_RESERVE_INCREASE BONUS_RESERVE_INCREASE, BONUS_RESERVE_DECREASE BONUS_RESERVE_DECREASE, BONUS_RESERVE_FINAL BONUS_RESERVE_FINAL, NET_BOOK_VALUE_INITIAL NET_BOOK_VALUE_INITIAL, NET_BOOK_VALUE_INCREASE NET_BOOK_VALUE_INCREASE, NET_BOOK_VALUE_DECREASE NET_BOOK_VALUE_DECREASE, NET_BOOK_VALUE_FINAL NET_BOOK_VALUE_FINAL, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_NUMBER TRANSACTION_NUMBER, TRANSACTION_CODE TRANSACTION_CODE, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, SALES_AMOUNT SALES_AMOUNT, COST_RETIRED COST_RETIRED, DATE_RETIRED DATE_RETIRED, DEPRN_RESERVE DEPRN_RESERVE, BONUS_RESERVE BONUS_RESERVE, NET_BOOK_VALUE NET_BOOK_VALUE, GAIN_LOSS GAIN_LOSS, HEADER HEADER, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, INITIAL_HEADING INITIAL_HEADING, VARIATION_HEADING VARIATION_HEADING, FINAL_HEADING FINAL_HEADING, ASSET_VARIATION ASSET_VARIATION, REVAL_VARIATION REVAL_VARIATION, DEPRN_VARIATION DEPRN_VARIATION, BONUS_VARIATION BONUS_VARIATION, NETBO_VARIATION NETBO_VARIATION, REVALUATION_TOTAL REVALUATION_TOTAL, DEPRECIATION_METHOD DEPRECIATION_METHOD, LIFE_IN_MONTHS LIFE_IN_MONTHS, LIFE_IN_YEARS LIFE_IN_YEARS, PRORATE_CONVENTION PRORATE_CONVENTION, TAG_NUMBER TAG_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, ASSET_KEY_FLEXFIELD ASSET_KEY_FLEXFIELD, YTD_DEPRN YTD_DEPRN from "JG"."JG_ZZ_FA_REG_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, ORGANIZATION_NAME ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, MAJOR_CATEGORY MAJOR_CATEGORY
, MINOR_CATEGORY MINOR_CATEGORY
, DEPRN_RATE DEPRN_RATE
, STARTING_DEPRN_YEAR STARTING_DEPRN_YEAR
, ASSET_HEADING ASSET_HEADING
, ASSET_NUMBER ASSET_NUMBER
, DESCRIPTION DESCRIPTION
, PARENT_ASSET_ID PARENT_ASSET_ID
, PARENT_ASSET_NUMBER PARENT_ASSET_NUMBER
, ASSET_COST_ORIG ASSET_COST_ORIG
, BONUS_RATE BONUS_RATE
, INVOICE_NUMBER INVOICE_NUMBER
, SUPPLIER_NAME SUPPLIER_NAME
, COST_ACCOUNT COST_ACCOUNT
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, RESERVE_ACCOUNT RESERVE_ACCOUNT
, BONUS_DEPRN_ACCOUNT BONUS_DEPRN_ACCOUNT
, BONUS_RESERVE_ACCOUNT BONUS_RESERVE_ACCOUNT
, ASSET_COST_INITIAL ASSET_COST_INITIAL
, ASSET_COST_INCREASE ASSET_COST_INCREASE
, ASSET_COST_DECREASE ASSET_COST_DECREASE
, ASSET_COST_FINAL ASSET_COST_FINAL
, REVALUATION_INITIAL REVALUATION_INITIAL
, REVALUATION_INCREASE REVALUATION_INCREASE
, REVALUATION_DECREASE REVALUATION_DECREASE
, REVALUATION_FINAL REVALUATION_FINAL
, DEPRN_RESERVE_INITIAL DEPRN_RESERVE_INITIAL
, DEPRN_RESERVE_INCREASE DEPRN_RESERVE_INCREASE
, DEPRN_RESERVE_DECREASE DEPRN_RESERVE_DECREASE
, DEPRN_RESERVE_FINAL DEPRN_RESERVE_FINAL
, BONUS_RESERVE_INITIAL BONUS_RESERVE_INITIAL
, BONUS_RESERVE_INCREASE BONUS_RESERVE_INCREASE
, BONUS_RESERVE_DECREASE BONUS_RESERVE_DECREASE
, BONUS_RESERVE_FINAL BONUS_RESERVE_FINAL
, NET_BOOK_VALUE_INITIAL NET_BOOK_VALUE_INITIAL
, NET_BOOK_VALUE_INCREASE NET_BOOK_VALUE_INCREASE
, NET_BOOK_VALUE_DECREASE NET_BOOK_VALUE_DECREASE
, NET_BOOK_VALUE_FINAL NET_BOOK_VALUE_FINAL
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, TRANSACTION_CODE TRANSACTION_CODE
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, SALES_AMOUNT SALES_AMOUNT
, COST_RETIRED COST_RETIRED
, DATE_RETIRED DATE_RETIRED
, DEPRN_RESERVE DEPRN_RESERVE
, BONUS_RESERVE BONUS_RESERVE
, NET_BOOK_VALUE NET_BOOK_VALUE
, GAIN_LOSS GAIN_LOSS
, HEADER HEADER
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, INITIAL_HEADING INITIAL_HEADING
, VARIATION_HEADING VARIATION_HEADING
, FINAL_HEADING FINAL_HEADING
, ASSET_VARIATION ASSET_VARIATION
, REVAL_VARIATION REVAL_VARIATION
, DEPRN_VARIATION DEPRN_VARIATION
, BONUS_VARIATION BONUS_VARIATION
, NETBO_VARIATION NETBO_VARIATION
, REVALUATION_TOTAL REVALUATION_TOTAL
, DEPRECIATION_METHOD DEPRECIATION_METHOD
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, LIFE_IN_YEARS LIFE_IN_YEARS
, PRORATE_CONVENTION PRORATE_CONVENTION
, TAG_NUMBER TAG_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, ASSET_KEY_FLEXFIELD ASSET_KEY_FLEXFIELD
, YTD_DEPRN YTD_DEPRN
FROM "JG"."JG_ZZ_FA_REG_ITF"