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]

Table: FA_ADDITIONS_B

Product:	OFA - Assets
Description:	Descriptive information about assets (base MLS table)
Implementation/DBA Data:	FA.FA_ADDITIONS_B

Primary Key: FA_ADDITIONS_B_PK

ASSET_ID

Primary Key: FA_ADDITIONS_B_UK1

ASSET_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_ADDITIONS_B	FA_CATEGORIES_B	FA_ADDITIONS_B.ASSET_CATEGORY_ID
FA_ADDITIONS_B	FA_ADDITIONS_B	FA_ADDITIONS_B.PARENT_ASSET_ID
FA_ADDITIONS_B	FA_LEASES	FA_ADDITIONS_B.LEASE_ID
FA_ADDITIONS_B	FA_ASSET_KEYWORDS	FA_ADDITIONS_B.ASSET_KEY_CCID
CSI_I_ASSETS	FA_ADDITIONS_B	CSI_I_ASSETS.FA_ASSET_ID
FA_ACE_BOOKS	FA_ADDITIONS_B	FA_ACE_BOOKS.ASSET_ID
FA_MASSADD_REP_ITF	FA_ADDITIONS_B	FA_MASSADD_REP_ITF.GROUP_ASSET_NUMBER
FA_ADDITIONS_B	FA_ADDITIONS_B	FA_ADDITIONS_B.PARENT_ASSET_ID
FA_ADDITION_REP_ITF	FA_ADDITIONS_B	FA_ADDITION_REP_ITF.GROUP_ASSET_NUMBER
FA_ADD_WARRANTIES	FA_ADDITIONS_B	FA_ADD_WARRANTIES.ASSET_ID
FA_ADJUSTMENTS	FA_ADDITIONS_B	FA_ADJUSTMENTS.ASSET_ID
FA_ADJUST_REP_ITF	FA_ADDITIONS_B	FA_ADJUST_REP_ITF.GROUP_ASSET_NUMBER
FA_ASSET_HISTORY	FA_ADDITIONS_B	FA_ASSET_HISTORY.ASSET_ID
FA_ASSET_INVOICES	FA_ADDITIONS_B	FA_ASSET_INVOICES.ASSET_ID
FA_BALANCES_REP_ITF	FA_ADDITIONS_B	FA_BALANCES_REP_ITF.GROUP_ASSET_NUMBER
FA_BOOKS	FA_ADDITIONS_B	FA_BOOKS.ASSET_ID
FA_BOOKS_SUMMARY	FA_ADDITIONS_B	FA_BOOKS_SUMMARY.ASSET_ID
FA_BOOKS_SUMMARY	FA_ADDITIONS_B	FA_BOOKS_SUMMARY.GROUP_ASSET_ID
FA_CAPITAL_BUDGET	FA_ADDITIONS_B	FA_CAPITAL_BUDGET.ASSET_ID
FA_CATEGORY_BOOK_DEFAULTS	FA_ADDITIONS_B	FA_CATEGORY_BOOK_DEFAULTS.GROUP_ASSET_ID
FA_DEFERRED_DEPRN	FA_ADDITIONS_B	FA_DEFERRED_DEPRN.ASSET_ID
FA_DEPRN_DETAIL	FA_ADDITIONS_B	FA_DEPRN_DETAIL.ASSET_ID
FA_DEPRN_OVERRIDE	FA_ADDITIONS_B	FA_DEPRN_OVERRIDE.ASSET_ID
FA_DEPRN_REP_ITF	FA_ADDITIONS_B	FA_DEPRN_REP_ITF.GROUP_ASSET_NUMBER
FA_DEPRN_SUMMARY	FA_ADDITIONS_B	FA_DEPRN_SUMMARY.ASSET_ID
FA_DISTRIBUTION_HISTORY	FA_ADDITIONS_B	FA_DISTRIBUTION_HISTORY.ASSET_ID
FA_INS_LINES	FA_ADDITIONS_B	FA_INS_LINES.ASSET_ID
FA_INS_POLICIES	FA_ADDITIONS_B	FA_INS_POLICIES.ASSET_ID
FA_INS_VALUES	FA_ADDITIONS_B	FA_INS_VALUES.ASSET_ID
FA_MAINT_EVENTS	FA_ADDITIONS_B	FA_MAINT_EVENTS.ASSET_ID
FA_MAINT_SCHEDULE_HDR	FA_ADDITIONS_B	FA_MAINT_SCHEDULE_HDR.FROM_ASSET_NUMBER
FA_MAINT_SCHEDULE_HDR	FA_ADDITIONS_B	FA_MAINT_SCHEDULE_HDR.TO_ASSET_NUMBER
%	FA_ADDITIONS_B
FA_MASS_ADDITIONS	FA_ADDITIONS_B	FA_MASS_ADDITIONS.ADD_TO_ASSET_ID
%	FA_ADDITIONS_B
FA_MASS_ADDITIONS	FA_ADDITIONS_B	FA_MASS_ADDITIONS.ASSET_NUMBER
%	FA_ADDITIONS_B
FA_MASS_ADDITIONS	FA_ADDITIONS_B	FA_MASS_ADDITIONS.PARENT_ASSET_ID
FA_MASS_CHANGES	FA_ADDITIONS_B	FA_MASS_CHANGES.FROM_GROUP_ASSET_ID
FA_MASS_CHANGES	FA_ADDITIONS_B	FA_MASS_CHANGES.TO_GROUP_ASSET_ID
FA_MASS_CHANGES	FA_ADDITIONS_B	FA_MASS_CHANGES.FROM_ASSET_NUMBER
FA_MASS_CHANGES	FA_ADDITIONS_B	FA_MASS_CHANGES.TO_ASSET_NUMBER
FA_MASS_CHANGES_ITF	FA_ADDITIONS_B	FA_MASS_CHANGES_ITF.FROM_GROUP_ASSET_NUMBER
FA_MASS_CHANGES_ITF	FA_ADDITIONS_B	FA_MASS_CHANGES_ITF.TO_GROUP_ASSET_NUMBER
FA_MASS_CHANGES_ITF	FA_ADDITIONS_B	FA_MASS_CHANGES_ITF.ASSET_ID
FA_MASS_CHANGES_ITF	FA_ADDITIONS_B	FA_MASS_CHANGES_ITF.ASSET_NUMBER
FA_MASS_RECLASS	FA_ADDITIONS_B	FA_MASS_RECLASS.FROM_ASSET_NUMBER
FA_MASS_RECLASS	FA_ADDITIONS_B	FA_MASS_RECLASS.TO_ASSET_NUMBER
FA_MASS_RECLASS_ITF	FA_ADDITIONS_B	FA_MASS_RECLASS_ITF.ASSET_ID
FA_MASS_RECLASS_ITF	FA_ADDITIONS_B	FA_MASS_RECLASS_ITF.ASSET_NUMBER
FA_MASS_RETIREMENTS	FA_ADDITIONS_B	FA_MASS_RETIREMENTS.FROM_ASSET_NUMBER
FA_MASS_RETIREMENTS	FA_ADDITIONS_B	FA_MASS_RETIREMENTS.TO_ASSET_NUMBER
FA_MASS_REVALUATION_RULES	FA_ADDITIONS_B	FA_MASS_REVALUATION_RULES.ASSET_ID
FA_MASS_REVAL_REP_ITF	FA_ADDITIONS_B	FA_MASS_REVAL_REP_ITF.ASSET_ID
FA_MASS_REVAL_REP_ITF	FA_ADDITIONS_B	FA_MASS_REVAL_REP_ITF.ASSET_NUMBER
FA_MASS_TAX_ADJ_REP_T	FA_ADDITIONS_B	FA_MASS_TAX_ADJ_REP_T.ASSET_ID
FA_MASS_TAX_ADJ_REP_T	FA_ADDITIONS_B	FA_MASS_TAX_ADJ_REP_T.ASSET_NUMBER
FA_MC_ADJUSTMENTS	FA_ADDITIONS_B	FA_MC_ADJUSTMENTS.ASSET_ID
FA_MC_ASSET_INVOICES	FA_ADDITIONS_B	FA_MC_ASSET_INVOICES.ASSET_ID
FA_MC_BOOKS	FA_ADDITIONS_B	FA_MC_BOOKS.ASSET_ID
FA_MC_BOOKS_RATES	FA_ADDITIONS_B	FA_MC_BOOKS_RATES.ASSET_ID
FA_MC_CONVERSION_RATES	FA_ADDITIONS_B	FA_MC_CONVERSION_RATES.ASSET_ID
FA_MC_DEFERRED_DEPRN	FA_ADDITIONS_B	FA_MC_DEFERRED_DEPRN.ASSET_ID
FA_MC_DEPRN_DETAIL	FA_ADDITIONS_B	FA_MC_DEPRN_DETAIL.ASSET_ID
FA_MC_DEPRN_SUMMARY	FA_ADDITIONS_B	FA_MC_DEPRN_SUMMARY.ASSET_ID
FA_MC_RETIREMENTS	FA_ADDITIONS_B	FA_MC_RETIREMENTS.ASSET_ID
FA_MC_RETIREMENTS	FA_ADDITIONS_B	FA_MC_RETIREMENTS.TRADE_IN_ASSET_ID
FA_PARALLEL_WORKERS	FA_ADDITIONS_B	FA_PARALLEL_WORKERS.ASSET_ID
FA_PARALLEL_WORKERS	FA_ADDITIONS_B	FA_PARALLEL_WORKERS.PARENT_ASSET_ID
FA_PARALLEL_WORKERS	FA_ADDITIONS_B	FA_PARALLEL_WORKERS.OLD_GROUP_ASSET_ID
FA_PARALLEL_WORKERS	FA_ADDITIONS_B	FA_PARALLEL_WORKERS.NEW_GROUP_ASSET_ID
FA_PERIODIC_PRODUCTION	FA_ADDITIONS_B	FA_PERIODIC_PRODUCTION.ASSET_ID
FA_RESERVE_LEDGER	FA_ADDITIONS_B	FA_RESERVE_LEDGER.ASSET_ID
FA_RETIREMENTS	FA_ADDITIONS_B	FA_RETIREMENTS.ASSET_ID
FA_RETIREMENTS	FA_ADDITIONS_B	FA_RETIREMENTS.TRADE_IN_ASSET_ID
FA_RETIRE_REP_ITF	FA_ADDITIONS_B	FA_RETIRE_REP_ITF.GROUP_ASSET_NUMBER
FA_SHORT_TAX_RESERVES	FA_ADDITIONS_B	FA_SHORT_TAX_RESERVES.ASSET_NUMBER
FA_TAX_INTERFACE	FA_ADDITIONS_B	FA_TAX_INTERFACE.ASSET_NUMBER
FA_TAX_INTERFACE	FA_ADDITIONS_B	FA_TAX_INTERFACE.GROUP_ASSET_ID
FA_TRANSACTION_HEADERS	FA_ADDITIONS_B	FA_TRANSACTION_HEADERS.ASSET_ID
FA_TRX_REFERENCES	FA_ADDITIONS_B	FA_TRX_REFERENCES.SRC_ASSET_ID
FA_TRX_REFERENCES	FA_ADDITIONS_B	FA_TRX_REFERENCES.DEST_ASSET_ID
FA_TRX_REFERENCES	FA_ADDITIONS_B	FA_TRX_REFERENCES.MEMBER_ASSET_ID
IA_REQUEST_DETAILS	FA_ADDITIONS_B	IA_REQUEST_DETAILS.ASSET_ID
JAI_FA_AST_BLOCK_DTLS	FA_ADDITIONS_B	JAI_FA_AST_BLOCK_DTLS.ASSET_ID
JAI_FA_DEP_BLOCKS_T	FA_ADDITIONS_B	JAI_FA_DEP_BLOCKS_T.ASSET_ID
JA_AU_BAL_CHG_APPLIED	FA_ADDITIONS_B	JA_AU_BAL_CHG_APPLIED.ASSET_ID
JA_AU_BAL_CHG_SOURCE	FA_ADDITIONS_B	JA_AU_BAL_CHG_SOURCE.ASSET_ID
JA_AU_CAPITAL_VALUE	FA_ADDITIONS_B	JA_AU_CAPITAL_VALUE.ASSET_ID
JA_AU_SRW_TAX_DEPRN_TMP	FA_ADDITIONS_B	JA_AU_SRW_TAX_DEPRN_TMP.ASSET_ID
JL_CO_FA_ADJUSTMENTS	FA_ADDITIONS_B	JL_CO_FA_ADJUSTMENTS.ASSET_ID
JL_MX_FA_ISR_IMPAC	FA_ADDITIONS_B	JL_MX_FA_ISR_IMPAC.ASSET_ID
OKL_EXT_FA_LINE_SOURCES_B	FA_ADDITIONS_B	OKL_EXT_FA_LINE_SOURCES_B.ASSET_ID
PA_PROJECT_ASSETS_ALL	FA_ADDITIONS_B	PA_PROJECT_ASSETS_ALL.PARENT_ASSET_ID
PA_PROJECT_ASSETS_ALL	FA_ADDITIONS_B	PA_PROJECT_ASSETS_ALL.RET_TARGET_ASSET_ID
PA_PROJECT_ASSETS_ALL	FA_ADDITIONS_B	PA_PROJECT_ASSETS_ALL.FA_ASSET_ID