Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACQUISITION_DATE	Date the asset was purchased within or outside of purchasing.	DATE	FFBMAST	FFBMAST_ACQD_DATE	NO	NO
ACTUAL_USEFUL_LIFE_YEARS	Estimated actual life of the asset used for depreciation.	NUMBER	FFBMAST	FFBMAST_EST_LIFE_YEARS	NO	NO
ADDITIONAL_SERIAL_NUMBER	Additional part serial number or vehicle identification number (VIN) for the fixed asset.	VARCHAR2(40)	FFBMAST	FFBMAST_PART_NUM_VEHICLE_TAG	NO	NO
ASSET_DESC	Fixed asset description.	VARCHAR2(60)	FFBMAST	FFBMAST_ASSET_DESC	NO	NO
ASSET_GIFT_IND	Indicates whether this asset was acquired as a gift.	VARCHAR2(1)	FFBMAST	FFBMAST_GIFT_IND	NO	NO
ASSET_STATUS	Indicates the current system maintained status for the fixed asset.	VARCHAR2(1)	FFBMAST	FFBMAST_SYSTEM_STATUS_CODE	NO	NO
ASSET_STATUS_DESC	Retrieved description for asset system status.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
ASSET_TYPE	Describes an asset category for depreciation purposes.	VARCHAR2(2)	FFBMAST	FFBMAST_ASTY_CODE	NO	NO
ASSET_TYPE_DESC	Asset type description.	VARCHAR2(35)	FTVASTY	FTVASTY_TITLE	NO	NO
BARCODE_NUMBER	Barcode number for the fixed asset.	VARCHAR2(12)	FFBMAST	FFBMAST_BARCODE_NUM	NO	NO
BOOK_VALUE_AMOUNT	User entered book value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_BOOK_AMT	NO	NO
CAPITALIZATION_DATE	Date the asset was declared for capitalization value.	DATE	FFBMAST	FFBMAST_CAP_DATE	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FFBMAST	FFBMAST_COAS_CODE_RESP	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(10)	FFBMAST	FFBMAST_COMM_CODE	NO	NO
COMMODITY_DESC	Commodity description or title.	VARCHAR2(50)	FTVCOMM	FTVCOMM_DESC	NO	NO
CONDITION	Code used to define the asset condition.	VARCHAR2(3)	FFBMAST	FFBMAST_ACON_CODE	NO	NO
CONDITION_DESC	Condition description for the asset.	VARCHAR2(35)	FFVACON	FFVACON_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DEPRECIATION_FREQUENCY	Defined frequency (monthly, annually, semi-annually, quarterly) for the calculation of depreciation for this asset.	VARCHAR2(1)	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(2)	FFBMAST	FFBMAST_DEPR_CODE	NO	NO
DEPRECIATION_METHOD_DESC	Instructions as to how to handle the depreciation for an asset.	VARCHAR2(35)	FTVDEPR	FTVDEPR_TITLE	NO	NO
DEPRECIATION_START_DATE	Date on which the asset starts to depreciate.	DATE	FFBMAST	FFBMAST_DEPR_START_DATE	NO	NO
DISPOSAL_DATE	Date on which this asset was disposed.	DATE	FFBMAST	FFBMAST_DISP_DATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EXTERNAL_REFERENCE_NUMBER	Externally assigned reference number for the fixed asset when available.	VARCHAR2(35)	FFBMAST	FFBMAST_EXT_REF_NUM	NO	NO
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(9)	FFBMAST	FFBMAST_GRNT_CODE	NO	NO
GRANT_LONG_TITLE	Grant description or title.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE	NO	NO
GRANT_TITLE	Shortened name or title for the grant.	VARCHAR2(35)	FRBGRNT	FRBGRNT_TITLE	NO	NO
INSURANCE_AMOUNT	User defined amount that is reported to the insurance company in the event of total loss.	NUMBER	FFBMAST	FFBMAST_INS_AMT	NO	NO
INVOICE	Invoice document number on which this fixed asset was paid.	VARCHAR2(8)	FFBMAST	FFBMAST_INVH_CODE	NO	NO
INVOICE_DATE	Date of the invoice.	DATE	FFBMAST	FFBMAST_INVH_DATE	NO	NO
INVOICE_ITEM	Invoice item number on which this fixed asset was ordered.	NUMBER	FFBMAST	FFBMAST_INVC_ITEM	NO	NO
IN_SERVICE_DATE	Date on which this asset was placed in service.	DATE	FFBMAST	FFBMAST_IN_SERV_DATE	NO	NO
LAST_ADJUSTMENT_DATE	Date the fixed asset value was last adjusted for any reason (capitalization, depreciation or any other adjustment).	DATE	FFBMAST	FFBMAST_ADJ_DATE	NO	NO
LAST_DEPRECIATION_DATE	Date on which the depreciation calculation was last performed.	DATE	FFBMAST	FFBMAST_LAST_DEPR_DATE	NO	NO
LAST_INVENTORY_DATE	Date on which this asset was last inventoried.	DATE	FFBMAST	FFBMAST_LAST_INVENTORY_DATE	NO	NO
LOCATION	Identification code of the physical location for the asset.	VARCHAR2(6)	FFBMAST	FFBMAST_LOCN_CODE_RESP	NO	NO
LOCATION_DESC	Extracted description or title of the associated location.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
MAKE	Make for the fixed asset usually associated with a car.	VARCHAR2(35)	FFBMAST	FFBMAST_MAKE	NO	NO
MANUFACTURER	Name of the manufacturer for the fixed asset.	VARCHAR2(35)	FFBMAST	FFBMAST_MANUFACTURER	NO	NO
MARKET_VALUE_AMOUNT	Market value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_MARKET_AMT	NO	NO
METHOD_OF_ACQUISITION	Code used to indicate the method used to acquire the asset.	VARCHAR2(2)	FFBMAST	FFBMAST_ACQM_CODE	NO	NO
METHOD_OF_ACQUISITION_DESC	Description of the method used to acquire the asset.	VARCHAR2(35)	FFVACQM	FFVACQM_DESC	NO	NO
METHOD_OF_DISPOSAL	Code used to define method of disposal associated with this fixed asset.	VARCHAR2(2)	FFBMAST	FFBMAST_DISP_CODE	NO	NO
METHOD_OF_DISPOSAL_DESC	Disposal method description.	VARCHAR2(35)	FFVDISP	FFVDISP_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MODEL	Model number for the fixed asset.	VARCHAR2(30)	FFBMAST	FFBMAST_MODEL	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
NORMAL_USEFUL_LIFE	Normal usable life expected for the asset.	NUMBER	FTVASTY	FTVASTY_STD_LIFE	NO	NO
ORGANIZATION_CODE	Identification accounting code used for the responsible department.	VARCHAR2(6)	FFBMAST	FFBMAST_ORGN_CODE_RESP	NO	NO
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
ORIGINAL_CAPITALIZED_AMOUNT	Calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset including attachment costs.	NUMBER	FUNCTION	FOKODSF.F_CAPITALIZED_AMT	NO	NO
ORIGINAL_COST_AMOUNT	Calculated as the original cost of the asset excluding attachment costs.	NUMBER	FUNCTION	FOKODSF.F_COST_AMT	NO	NO
ORIGINATION_TAG_CANCEL_DATE	Date the new system tag number is assigned and the old tag number retired.	DATE	FFBMAST	FFBMAST_OTAG_CANCEL_DATE	NO	NO
ORIGINATION_TAG_NUMBER	System generated tag number assigned when the asset is acquired.	VARCHAR2(9)	FFBMAST	FFBMAST_OTAG_CODE	NO	NO
ORIGINATION_TAG_NUMBER_DATE	Date the system tag number is assigned.	DATE	FFBMAST	FFBMAST_OTAG_DATE	NO	NO
ORIGINATION_TAG_NUMBER_OLD	Old tag number when a new system tag number is assigned.	VARCHAR2(9)	FFBMAST	FFBMAST_OTAG_CODE_OLD	NO	NO
ORIGINATION_TAG_NUMBER_PRIMARY	System tag number for the primary fixed asset when multiple assets are linked together.	VARCHAR2(9)	FFBMAST	FFBMAST_OTAG_CODE_PRIMARY	NO	NO
PERMANENT_TAG_NUMBER	Unique user defined or system generated one-up number for this asset.	VARCHAR2(9)	FFBMAST	FFBMAST_PTAG_CODE	NO	NO
PERMANENT_TAG_NUMBER_DATE	Date the permanent tag number is assigned to the fixed asset.	DATE	FFBMAST	FFBMAST_PTAG_DATE	NO	NO
PERSON_MANAGER_UID	System internally generated identification number to uniquely identify the equipment manager responsible for this fixed asset.	NUMBER	FFBMAST	FFBMAST_EQUIP_MGR_PIDM	NO	NO
PERSON_UID	System generated unique internal identification number assigned to custodian assigned to this asset.	NUMBER	FFBMAST	FFBMAST_CUSTODIAN_PIDM	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
PURCHASE_ORDER	Purchase order number on which this fixed asset was ordered.	VARCHAR2(8)	FFBMAST	FFBMAST_POHD_CODE	NO	NO
PURCHASE_ORDER_ITEM	Purchase order item number on which this fixed asset was ordered.	NUMBER	FFBMAST	FFBMAST_PODT_ITEM	NO	NO
RECEIVED_DATE	Date the purchase order item was received.	DATE	FFBMAST	FFBMAST_RCHD_DATE	NO	NO
RECEIVER	Unique number for the receiving document associated with the asset created in receiving.	VARCHAR2(8)	FFBMAST	FFBMAST_RCHD_CODE	NO	NO
REMAINING_LIFE_MONTHS	Calculated as months as the depreciation frequency being used is defined as monthly for the 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
REPLACEMENT_VALUE_AMOUNT	User-defined replacement value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_REPL_AMT	NO	NO
SALVAGE_AMOUNT	Amount below which this fixed asset cannot be depreciated.	NUMBER	FFBMAST	FFBMAST_SALVAGE_AMT	NO	NO
SERIAL_NUMBER	Serial number or vehicle identification number (VIN) for the fixed asset.	VARCHAR2(40)	FFBMAST	FFBMAST_SERIAL_NUM_VIN	NO	NO
SOURCE_DOCUMENT	Document number for the source document outside of fixed assets used to track the asset when the origination tag number was created.	VARCHAR2(8)	FFBMAST	FFBMAST_OTHER_SRC_DOC_CODE	NO	NO
SOURCE_DOCUMENT_DATE	Date that the source document was created.	DATE	FFBMAST	FFBMAST_DTAG_ACTIVITY_DATE	NO	NO
SOURCE_DOCUMENT_SEQ_NUMBER	Document system assigned sequence number to the accounting line for the source document used for the fixed asset.	NUMBER	FFBMAST	FFBMAST_OTHER_SRC_SEQ_NUM	NO	NO
SOURCE_DOCUMENT_SUB_NUMBER	Document submission number for the source document used for fixed assets. Like an auto submission for a journal voucher.	NUMBER	FFBMAST	FFBMAST_OTHER_SRC_SUB_NUM	NO	NO
SOURCE_DOCUMENT_TYPE	Document type sequence number for the source document used for the fixed asset.	NUMBER	FFBMAST	FFBMAST_OTHER_SRC_DTYP_NUM	NO	NO
SUBORDINATE_TYPE	When the fixed asset is not the primary, indicates how the subordinate fixed asset is linked. It can either be linked to depreciate with the primary as an asset or linked and depreciated separately as a component.	VARCHAR2(1)	FFBMAST	FFBMAST_SUBORDINATE_TYPE	NO	NO
SUBORDINATE_TYPE_DESC	Subordinate type will indicated whether this is a component of or attached to when this is not the origination tag number that is primary.	VARCHAR2(30)	CALCULATION	DECODE(FFBMAST_SUBORDINATE_TYPE)	NO	NO
TITLED_TO	Represents the title-to designation at the institution.	VARCHAR2(2)	FFBMAST	FFBMAST_TTST_CODE	NO	NO
TITLED_TO_DESC	Name from the titled-to designation.	VARCHAR2(35)	FFVTTST	FFVTTST_DESC	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
TOTAL_ORIGINAL_COST_AMOUNT	Sum of original cost of the asset and attachment costs.	NUMBER	FUNCTION	FOKODSF.F_TOTAL_COST_AMT	NO	NO
TRANSFER_DATE	Date on which the asset was last transferred.	DATE	FFBMAST	FFBMAST_TRANSFER_DATE	NO	NO
USER_STATUS	Indicates the current user assigned status of the fixed asset.	VARCHAR2(1)	FFBMAST	FFBMAST_USER_STATUS_CODE	NO	NO
USER_STATUS_DESC	Retrieves description for asset user status.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FFBMAST	FFBMAST_VEND_PIDM	NO	NO
WORK_IN_PROGRESS_IND	For assets such as buildings, defines if work is in progress.	VARCHAR2(1)	FFBMAST	FFBMAST_WORK_IN_PROG_IND	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: