Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACQUISITION_DATE	Date the asset was purchased within or outside of purchasing.	DATE	FFBMAST	FFBMAST_ACQD_DATE
ADDITIONAL_SERIAL_NUMBER	Additional part serial number or vehicle identification number (VIN) for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_PART_NUM_VEHICLE_TAG
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ASSET_DESC	Fixed asset description.	VARCHAR2(255)	FFBMAST	FFBMAST_ASSET_DESC
ASSET_GIFT_IND	Indicates whether this asset was acquired as a gift.	VARCHAR2(63)	FFBMAST	FFBMAST_GIFT_IND
ASSET_STATUS	Indicates the current system maintained status for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_SYSTEM_STATUS_CODE
ASSET_STATUS_DESC	Retrieved description for asset system status.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
ASSET_TYPE	Describes an asset category for depreciation purposes.	VARCHAR2(63)	FFBMAST	FFBMAST_ASTY_CODE
ASSET_TYPE_DESC	Asset type description.	VARCHAR2(255)	FTVASTY	FTVASTY_TITLE
BARCODE_NUMBER	Barcode number for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_BARCODE_NUM
BOOK_VALUE_AMOUNT	User entered book value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_BOOK_AMT
CAPITALIZATION_DATE	Date the asset was declared for capitalization value.	DATE	FFBMAST	FFBMAST_CAP_DATE
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FFBMAST	FFBMAST_COAS_CODE_RESP
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(63)	FFBMAST	FFBMAST_COMM_CODE
COMMODITY_DESC	Commodity description or title.	VARCHAR2(255)	FTVCOMM	FTVCOMM_DESC
CONDITION	Code used to define the asset condition.	VARCHAR2(63)	FFBMAST	FFBMAST_ACON_CODE
CONDITION_DESC	Condition description for the asset.	VARCHAR2(255)	FFVACON	FFVACON_DESC
DISPOSAL_DATE	Date on which this asset was disposed.	DATE	FFBMAST	FFBMAST_DISP_DATE
EXTERNAL_REFERENCE_NUMBER	Externally assigned reference number for the fixed asset when available.	VARCHAR2(63)	FFBMAST	FFBMAST_EXT_REF_NUM
FULL_NAME_FMIL	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MSKFUNC.F_FORMAT_NAME
FULL_NAME_LFMI	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MSKFUNC.F_FORMAT_NAME
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	FFBMAST	FFBMAST_GRNT_CODE
GRANT_LONG_TITLE	Grant long title or description.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE
GRANT_TITLE	Shortened name or title for the grant.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
INSURANCE_AMOUNT	User defined amount that is reported to the insurance company in the event of total loss.	NUMBER	FFBMAST	FFBMAST_INS_AMT
INVOICE	Invoice document number on which this fixed asset was paid.	VARCHAR2(63)	FFBMAST	FFBMAST_INVH_CODE
INVOICE_DATE	Date of the invoice.	DATE	FFBMAST	FFBMAST_INVH_DATE
INVOICE_ITEM	Invoice item number on which this fixed asset was ordered.	NUMBER	FFBMAST	FFBMAST_INVC_ITEM
IN_SERVICE_DATE	Date on which this asset was placed in service.	DATE	FFBMAST	FFBMAST_IN_SERV_DATE
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
LAST_INVENTORY_DATE	Date on which this asset was last inventoried.	DATE	FFBMAST	FFBMAST_LAST_INVENTORY_DATE
LOCATION	Identification code of the physical location for the asset.	VARCHAR2(63)	FFBMAST	FFBMAST_LOCN_CODE_RESP
LOCATION_DESC	Extracted description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
LOCATION_STATUS	Status of the Location.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND
MAKE	Make for the fixed asset usually associated with a car.	VARCHAR2(63)	FFBMAST	FFBMAST_MAKE
MANUFACTURER	Name of the manufacturer for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_MANUFACTURER
MARKET_VALUE_AMOUNT	Market value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_MARKET_AMT
METHOD_OF_ACQUISITION	Code used to indicate the method used to acquire the asset.	VARCHAR2(63)	FFBMAST	FFBMAST_ACQM_CODE
METHOD_OF_ACQUISITION_DESC	Description of the method used to acquire the asset.	VARCHAR2(255)	FFVACQM	FFVACQM_DESC
METHOD_OF_DISPOSAL	Code used to define method of disposal associated with this fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_DISP_CODE
METHOD_OF_DISPOSAL_DESC	Disposal method description.	VARCHAR2(255)	FFVDISP	FFVDISP_DESC
MODEL	Model number for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_MODEL
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
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
NORMAL_USEFUL_LIFE	Normal usable life expected for the asset.	NUMBER	FTVASTY	FTVASTY_STD_LIFE
ORGANIZATION_CODE	Identification accounting code used for the responsible department.	VARCHAR2(63)	FFBMAST	FFBMAST_ORGN_CODE_RESP
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_STATUS	Status of the organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
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
ORIGINAL_COST_AMOUNT	Calculated as the original cost of the asset excluding attachment costs.	NUMBER	FUNCTION	FOKODSF.F_COST_AMT
ORIGINATION_TAG_CANCEL_DATE	Date the new system tag number is assigned and the old tag number retired.	DATE	FFBMAST	FFBMAST_OTAG_CANCEL_DATE
ORIGINATION_TAG_NUMBER	System generated tag number assigned when the asset is acquired.	VARCHAR2(63)	FFBMAST	FFBMAST_OTAG_CODE
ORIGINATION_TAG_NUMBER_DATE	Date the system tag number is assigned.	DATE	FFBMAST	FFBMAST_OTAG_DATE
ORIGINATION_TAG_NUMBER_OLD	Old tag number when a new system tag number is assigned.	VARCHAR2(63)	FFBMAST	FFBMAST_OTAG_CODE_OLD
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
PERMANENT_TAG_NUMBER	Unique user defined or system generated one-up number for this asset.	VARCHAR2(63)	FFBMAST	FFBMAST_PTAG_CODE
PERMANENT_TAG_NUMBER_DATE	Date the permanent tag number is assigned to the fixed asset.	DATE	FFBMAST	FFBMAST_PTAG_DATE
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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PURCHASE_ORDER	Purchase order number on which this fixed asset was ordered.	VARCHAR2(63)	FFBMAST	FFBMAST_POHD_CODE
PURCHASE_ORDER_ITEM	Purchase order item number on which this fixed asset was ordered.	NUMBER	FFBMAST	FFBMAST_PODT_ITEM
RECEIVED_DATE	Date the purchase order item was received.	DATE	FFBMAST	FFBMAST_RCHD_DATE
RECEIVER	Unique number for the receiving document associated with this asset created in receiving.	VARCHAR2(63)	FFBMAST	FFBMAST_RCHD_CODE
REPLACEMENT_VALUE_AMOUNT	User-defined replacement value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_REPL_AMT
SERIAL_NUMBER	Serial number or vehicle identification number (VIN) for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_SERIAL_NUM_VIN
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
SOURCE_DOCUMENT_DATE	Date that the source document was created.	DATE	FFBMAST	FFBMAST_DTAG_ACTIVITY_DATE
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
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
SOURCE_DOCUMENT_TYPE	Document type sequence number for the source document used for the fixed asset.	NUMBER	FFBMAST	FFBMAST_OTHER_SRC_DTYP_NUM
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
SUBORDINATE_TYPE_DESC	Deciphers asset subordinate type as a component or attachment relating to the primary tag.	VARCHAR2(255)	CALCULATION	DECODE(FFBMAST_SUBORDINATE_TYPE)
TITLED_TO	Represents the title-to designation at the institution.	VARCHAR2(63)	FFBMAST	FFBMAST_TTST_CODE
TITLED_TO_DESC	Name from the titled-to designation.	VARCHAR2(255)	FFVTTST	FFVTTST_DESC
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
TOTAL_ORIGINAL_COST_AMOUNT	Sum of original cost of the asset and attachment costs.	NUMBER	FUNCTION	FOKODSF.F_TOTAL_COST_AMT
TRANSFER_DATE	Date on which the asset was last transferred.	DATE	FFBMAST	FFBMAST_TRANSFER_DATE
USER_STATUS	Indicates the current user assigned status for the fixed asset.	VARCHAR2(63)	FFBMAST	FFBMAST_USER_STATUS_CODE
USER_STATUS_DESC	Retrieves description for asset user status.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
VENDOR_ID	User-defined or system generated one-up number of the vendor.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
VENDOR_NAME	Extracted name of the vendor that supplied the asset.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FFBMAST	FFBMAST_VEND_PIDM
WORK_IN_PROGRESS_IND	For assets such as buildings, defines if work is in progress.	VARCHAR2(63)	FFBMAST	FFBMAST_WORK_IN_PROG_IND

Ver: 9.1