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
ADDITIONAL_SERIAL_NUMBER	Additional part serial number or vehicle identification number (VIN) for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_PART_NUM_VEHICLE_TAG	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_DESC	Fixed asset description.	VARCHAR2(255)	FFBMAST	FFBMAST_ASSET_DESC	NO	NO
ASSET_GIFT_IND	Indicates whether this asset was acquired as a gift.	VARCHAR2(63)	FFBMAST	FFBMAST_GIFT_IND	NO	NO
ASSET_STATUS	Indicates the current system maintained status for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_SYSTEM_STATUS_CODE	NO	NO
ASSET_STATUS_DESC	Retrieved description for asset system status.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
ASSET_TYPE	Describes an asset category for depreciation purposes.	VARCHAR2(63)	FFBMAST	FFBMAST_ASTY_CODE	NO	NO
ASSET_TYPE_DESC	Asset type description.	VARCHAR2(255)	FTVASTY	FTVASTY_TITLE	NO	NO
BARCODE_NUMBER	Barcode number for the fixed asset.	VARCHAR2(63)	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(63)	FFBMAST	FFBMAST_COAS_CODE_RESP	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_STATUS	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND	NO	NO
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(63)	FFBMAST	FFBMAST_COMM_CODE	NO	NO
COMMODITY_DESC	Commodity description or title.	VARCHAR2(255)	FTVCOMM	FTVCOMM_DESC	NO	NO
CONDITION	Code used to define the asset condition.	VARCHAR2(63)	FFBMAST	FFBMAST_ACON_CODE	NO	NO
CONDITION_DESC	Condition description for the asset.	VARCHAR2(255)	FFVACON	FFVACON_DESC	NO	NO
DISPOSAL_DATE	Date on which this asset was disposed.	DATE	FFBMAST	FFBMAST_DISP_DATE	NO	NO
EXTERNAL_REFERENCE_NUMBER	Externally assigned reference number for the fixed asset when available.	VARCHAR2(63)	FFBMAST	FFBMAST_EXT_REF_NUM	NO	NO
FULL_NAME_FMIL	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MSKFUNC.F_FORMAT_NAME	NO	NO
FULL_NAME_LFMI	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MSKFUNC.F_FORMAT_NAME	NO	NO
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	FFBMAST	FFBMAST_GRNT_CODE	NO	NO
GRANT_LONG_TITLE	Grant long title or description.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE	NO	NO
GRANT_TITLE	Shortened name or title for the grant.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	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(63)	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_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(63)	FFBMAST	FFBMAST_LOCN_CODE_RESP	NO	NO
LOCATION_DESC	Extracted description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
LOCATION_STATUS	Status of the Location.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND	NO	NO
MAKE	Make for the fixed asset usually associated with a car.	VARCHAR2(63)	FFBMAST	FFBMAST_MAKE	NO	NO
MANUFACTURER	Name of the manufacturer for the fixed asset.	VARCHAR2(63)	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(63)	FFBMAST	FFBMAST_ACQM_CODE	NO	NO
METHOD_OF_ACQUISITION_DESC	Description of the method used to acquire the asset.	VARCHAR2(255)	FFVACQM	FFVACQM_DESC	NO	NO
METHOD_OF_DISPOSAL	Code used to define method of disposal associated with this fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_DISP_CODE	NO	NO
METHOD_OF_DISPOSAL_DESC	Disposal method description.	VARCHAR2(255)	FFVDISP	FFVDISP_DESC	NO	NO
MODEL	Model number for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_MODEL	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
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(63)	FFBMAST	FFBMAST_ORGN_CODE_RESP	NO	NO
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
ORGANIZATION_STATUS	Status of the organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND	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(63)	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(63)	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(63)	FFBMAST	FFBMAST_OTAG_CODE_PRIMARY	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
PERMANENT_TAG_NUMBER_DATE	Date the permanent tag number is assigned to the fixed asset.	DATE	FFBMAST	FFBMAST_PTAG_DATE	NO	NO
PERSON_UID	System generated unique internal identification number assigned to the equipment manager for this asset.	NUMBER	FFBMAST FFBMAST	FFBMAST_CUSTODIAN_PIDM FFBMAST_EQUIP_MGR_PIDM	NO 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
PURCHASE_ORDER	Purchase order number on which this fixed asset was ordered.	VARCHAR2(63)	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 this asset created in receiving.	VARCHAR2(63)	FFBMAST	FFBMAST_RCHD_CODE	NO	NO
REPLACEMENT_VALUE_AMOUNT	User-defined replacement value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_REPL_AMT	NO	NO
SERIAL_NUMBER	Serial number or vehicle identification number (VIN) for the fixed asset.	VARCHAR2(63)	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(63)	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(63)	FFBMAST	FFBMAST_SUBORDINATE_TYPE	NO	NO
SUBORDINATE_TYPE_DESC	Deciphers asset subordinate type as a component or attachment relating to the primary tag.	VARCHAR2(255)	CALCULATION	DECODE(FFBMAST_SUBORDINATE_TYPE)	NO	NO
TITLED_TO	Represents the title-to designation at the institution.	VARCHAR2(63)	FFBMAST	FFBMAST_TTST_CODE	NO	NO
TITLED_TO_DESC	Name from the titled-to designation.	VARCHAR2(255)	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 for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_USER_STATUS_CODE	NO	NO
USER_STATUS_DESC	Retrieves description for asset user status.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
VENDOR_ID	User-defined or system generated one-up number of the vendor.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
VENDOR_NAME	Extracted name of the vendor that supplied the asset.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	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(63)	FFBMAST	FFBMAST_WORK_IN_PROG_IND	NO	NO

Ver: 9.2