Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTUAL_USEFUL_LIFE_YEARS	Estimated actual life of the asset used for depreciation.	NUMBER	FFBMAST	FFBMAST_EST_LIFE_YEARS	NO	NO
ADJUSTED_AMOUNT	Summarized amount for all accounting adjustments to the original value of the fixed asset. Uses the most current change sequence number. Represents the gain or loss amount when the asset is sold or written off or adjusted for any other reason.	NUMBER	FFRMASA	FFRMASA_ADJ_AMT	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ASSET_AMOUNT	Current summarized original cost of asset including accounting adjustments.	NUMBER	FFRMASA	FFRMASA_AMT	NO	NO
DEPRECIATION_FREQUENCY	Defined frequency (monthly, annually, semi-annually, quarterly) for the calculation of depreciation for this asset.	VARCHAR2(63)	FFBMAST	FFBMAST_DEPR_FREQ	NO	NO
DEPRECIATION_METHOD	Method of depreciation to be used for this fixed asset. Might include values like First Half All/Second Year None, Full Year, Take Half and Proportional.	VARCHAR2(63)	FFBMAST	FFBMAST_DEPR_CODE	NO	NO
DEPRECIATION_METHOD_DESC	Instructions as to how to handle the depreciation for an asset.	VARCHAR2(255)	FTVDEPR	FTVDEPR_TITLE	NO	NO
DEPRECIATION_START_DATE	Date on which the asset starts to depreciate.	DATE	FFBMAST	FFBMAST_DEPR_START_DATE	NO	NO
LAST_DEPRECIATION_DATE	Date on which the depreciation calculation was last performed.	DATE	FFBMAST	FFBMAST_LAST_DEPR_DATE	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NET_BOOK_VALUE_AMOUNT	Net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset not including attachment costs.	NUMBER	FUNCTION	FOKODSF.F_NET_BOOK_AMT	NO	NO
NET_DEPRECIATION_AMOUNT	Summarization of all current depreciation amounts used for depreciation. Uses the most current change sequence number.	NUMBER	FFRMASA	FFRMASA_NEW_NET_DEPR_AMT	NO	NO
OLD_DEPRECIATION_AMOUNT	Summarization of all the depreciation amounts used last time for depreciation. Uses the most current change sequence number.	NUMBER	FFRMASA	FFRMASA_OLD_NET_DEPR_AMT	NO	NO
ORIGINATION_TAG_NUMBER	System generated tag number assigned when the asset is acquired.	VARCHAR2(63)	FFRMASA	FFRMASA_OTAG_CODE	NO	NO
PERMANENT_TAG_NUMBER	Unique user defined or system generated one-up number for this asset.	VARCHAR2(63)	FFBMAST	FFBMAST_PTAG_CODE	NO	NO
PRIOR_LAST_DEPRECIATION_DATE	Next to last date on which the depreciation calculation was last performed.	DATE	FFBMAST	FFBMAST_OLD_LAST_DEPR_DATE	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REMAINING_LIFE_MONTHS	Calculated as months as the depreciation frequency being used is defined as monthly for remaining life of the asset. This is null if the depreciation frequency is not monthly.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE	NO	NO
REMAINING_LIFE_QUARTERS	Calculated as quarters as the depreciation frequency being used is defined as quarterly for the remaining life of the asset. This is null if the depreciation frequency is not quarterly.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE	NO	NO
REMAINING_LIFE_SEMI_ANNUAL	Calculated as number of half years as the depreciation frequency being used is defined as semi-annual for the remaining life of the asset. This is null if the depreciation frequency is not semi-annual.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE	NO	NO
REMAINING_LIFE_YEARS	Calculated as years as the depreciation frequency being used is defined as annual for remaining life of the asset. This is null if the depreciation frequency is not annual.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE	NO	NO
SALVAGE_AMOUNT	Amount below which this fixed asset cannot be depreciated.	NUMBER	FFBMAST	FFBMAST_SALVAGE_AMT	NO	NO
TOTAL_DEPRECIATION_AMOUNT	Summarization of all accounting depreciation amounts taken during the life to date for this asset. Uses the most current change sequence number.	NUMBER	FFRMASA	FFRMASA_DEPR_ACCUM_AMT	NO	NO
TOTAL_NET_BOOK_VALUE_AMOUNT	Total net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset including attachment costs.	NUMBER	FUNCTION	FOKODSF.F_TOTAL_BOOK_AMT	NO	NO

Ver: 9.2