1. Tables and Views for Financials
  2. FA_ASSET_RETIREMENTS_V

FA_ASSET_RETIREMENTS_V

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: VIEW

Columns

Name

TRANSACTION_HEADER_ID

BOOK_TYPE_CODE

ASSET_ID

TRANSACTION_TYPE_CODE

TRANSACTION_DATE_ENTERED

AMORTIZATION_START_DATE

DATE_EFFECTIVE

TRANSACTION_NAME

INVOICE_TRANSACTION_ID

SOURCE_TRANSACTION_HEADER_ID

MASS_REFERENCE_ID

MASS_TRANSACTION_ID

TRANSACTION_SUBTYPE

TRANSACTION_KEY

MEMBER_TRANSACTION_HEADER_ID

TRX_REFERENCE_ID

CALLING_INTERFACE

EVENT_ID

RETIREMENT_ID

DATE_RETIRED

STATUS

RETIREMENT_CONVENTION_TYPE_ID

TRANSACTION_HEADER_ID_IN

TRANSACTION_HEADER_ID_OUT

UNITS

COST_RETIRED

COST_OF_REMOVAL

NBV_RETIRED

GAIN_LOSS_AMOUNT

PROCEEDS_OF_SALE

GAIN_LOSS_TYPE_CODE

RETIREMENT_TYPE_CODE

REFERENCE_NUM

SOLD_TO

TRADE_IN_ASSET_ID

STL_METHOD_ID

STL_DEPRN_AMOUNT

REVAL_RESERVE_RETIRED

UNREVALUED_COST_RETIRED

BONUS_RESERVE_RETIRED

RECOGNIZE_GAIN_LOSS

REDUCTION_RATE

RECAPTURE_RESERVE_FLAG

LIMIT_PROCEEDS_FLAG

TERMINAL_GAIN_LOSS

RESERVE_RETIRED

RECAPTURE_AMOUNT

EOFY_RESERVE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY_CODE

IMPAIR_RESERVE_RETIRED

ITC_RECAPTURED

ITC_RECAPTURE_ID

Query

SQL_Statement

SELECT

TrxHeader.TRANSACTION_HEADER_ID,

TrxHeader.BOOK_TYPE_CODE,

TrxHeader.ASSET_ID,

TrxHeader.TRANSACTION_TYPE_CODE,

TrxHeader.TRANSACTION_DATE_ENTERED,

TrxHeader.AMORTIZATION_START_DATE,

TrxHeader.DATE_EFFECTIVE,

TrxHeader.TRANSACTION_NAME,

TrxHeader.INVOICE_TRANSACTION_ID,

TrxHeader.SOURCE_TRANSACTION_HEADER_ID,

TrxHeader.MASS_REFERENCE_ID,

TrxHeader.MASS_TRANSACTION_ID,

TrxHeader.TRANSACTION_SUBTYPE,

TrxHeader.TRANSACTION_KEY,

TrxHeader.MEMBER_TRANSACTION_HEADER_ID,

TrxHeader.TRX_REFERENCE_ID,

TrxHeader.CALLING_INTERFACE,

TrxHeader.EVENT_ID,

Retirement.RETIREMENT_ID,

Retirement.DATE_RETIRED,

Retirement.STATUS,

Retirement.RETIREMENT_CONVENTION_TYPE_ID,

Retirement.TRANSACTION_HEADER_ID_IN,

Retirement.TRANSACTION_HEADER_ID_OUT,

Retirement.UNITS,

Retirement.COST_RETIRED,

Retirement.COST_OF_REMOVAL,

Retirement.NBV_RETIRED,

Retirement.GAIN_LOSS_AMOUNT,

Retirement.PROCEEDS_OF_SALE,

Retirement.GAIN_LOSS_TYPE_CODE,

Retirement.RETIREMENT_TYPE_CODE,

Retirement.REFERENCE_NUM,

Retirement.SOLD_TO,

Retirement.TRADE_IN_ASSET_ID,

Retirement.STL_METHOD_ID,

Retirement.STL_DEPRN_AMOUNT,

Retirement.REVAL_RESERVE_RETIRED,

Retirement.UNREVALUED_COST_RETIRED,

Retirement.BONUS_RESERVE_RETIRED,

Retirement.RECOGNIZE_GAIN_LOSS,

Retirement.REDUCTION_RATE,

Retirement.RECAPTURE_RESERVE_FLAG,

Retirement.LIMIT_PROCEEDS_FLAG,

Retirement.TERMINAL_GAIN_LOSS,

Retirement.RESERVE_RETIRED,

Retirement.RECAPTURE_AMOUNT,

Retirement.EOFY_RESERVE,

Retirement.CREATION_DATE,

Retirement.CREATED_BY,

Retirement.LAST_UPDATE_DATE,

Retirement.LAST_UPDATED_BY,

Retirement.LAST_UPDATE_LOGIN,

Retirement.OBJECT_VERSION_NUMBER,

Retirement.ATTRIBUTE1,

Retirement.ATTRIBUTE2,

Retirement.ATTRIBUTE3,

Retirement.ATTRIBUTE4,

Retirement.ATTRIBUTE5,

Retirement.ATTRIBUTE6,

Retirement.ATTRIBUTE7,

Retirement.ATTRIBUTE8,

Retirement.ATTRIBUTE9,

Retirement.ATTRIBUTE10,

Retirement.ATTRIBUTE11,

Retirement.ATTRIBUTE12,

Retirement.ATTRIBUTE13,

Retirement.ATTRIBUTE14,

Retirement.ATTRIBUTE15,

Retirement.ATTRIBUTE_CATEGORY_CODE,

Retirement.IMPAIR_RESERVE_RETIRED,

Retirement.ITC_RECAPTURED,

Retirement.ITC_RECAPTURE_ID

FROM

FA_TRANSACTION_HEADERS TrxHeader,

FA_RETIREMENTS Retirement

WHERE

(TrxHeader.TRANSACTION_HEADER_ID = Retirement.TRANSACTION_HEADER_ID_IN

OR TrxHeader.TRANSACTION_HEADER_ID = Retirement.TRANSACTION_HEADER_ID_OUT)