Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACQUISITION_DATE
|
Acquisition Date
|
Date the asset was purchased within or outside of purchasing.
|
DATE
|
FFBMAST
|
FFBMAST_ACQD_DATE
|
ADDITIONAL_SERIAL_NUMBER
|
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 Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
ASSET_DESC
|
Asset Description
|
Fixed asset description.
|
VARCHAR2(255)
|
FFBMAST
|
FFBMAST_ASSET_DESC
|
ASSET_GIFT_IND
|
Asset Gift Indicator
|
Indicates whether this asset was acquired as a gift.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_GIFT_IND
|
ASSET_STATUS
|
Asset Status
|
Indicates the current system maintained status for the fixed asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_SYSTEM_STATUS_CODE
|
ASSET_STATUS_DESC
|
Asset Status Description
|
Retrieved description for asset system status.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
ASSET_TYPE
|
Asset Type
|
Describes an asset category for depreciation purposes.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_ASTY_CODE
|
ASSET_TYPE_DESC
|
Asset Type Description
|
Asset type description.
|
VARCHAR2(255)
|
FTVASTY
|
FTVASTY_TITLE
|
BARCODE_NUMBER
|
Barcode Number
|
Barcode number for the fixed asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_BARCODE_NUM
|
BOOK_VALUE_AMOUNT
|
Book Value Amount
|
User entered book value amount for this fixed asset.
|
NUMBER
|
FFBMAST
|
FFBMAST_BOOK_AMT
|
CAPITALIZATION_DATE
|
Capitalization Date
|
Date the asset was declared for capitalization value.
|
DATE
|
FFBMAST
|
FFBMAST_CAP_DATE
|
CHART_OF_ACCOUNTS
|
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 Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
CHART_OF_ACCOUNTS_STATUS
|
Chart Of Accounts Status
|
Status of the chart of accounts.
|
VARCHAR2(63)
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
COMMODITY
|
Commodity
|
User-defined code associated with this commodity.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_COMM_CODE
|
COMMODITY_DESC
|
Commodity Description
|
Commodity description or title.
|
VARCHAR2(255)
|
FTVCOMM
|
FTVCOMM_DESC
|
CONDITION
|
Condition
|
Code used to define the asset condition.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_ACON_CODE
|
CONDITION_DESC
|
Condition Description
|
Condition description for the asset.
|
VARCHAR2(255)
|
FFVACON
|
FFVACON_DESC
|
DISPOSAL_DATE
|
Disposal Date
|
Date on which this asset was disposed.
|
DATE
|
FFBMAST
|
FFBMAST_DISP_DATE
|
EXTERNAL_REFERENCE_NUMBER
|
External Reference Number
|
Externally assigned reference number for the fixed asset when available.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_EXT_REF_NUM
|
FULL_NAME_FMIL
|
Full Name First, Middle Initial, Last
|
Combination of the person's first, middle initial, and last name into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MSKFUNC.F_FORMAT_NAME
|
FULL_NAME_LFMI
|
Full Name Last, First, Middle Initial
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MSKFUNC.F_FORMAT_NAME
|
GRANT_ID
|
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
|
Grant long title or description.
|
VARCHAR2(256)
|
FRBGRNT
|
FRBGRNT_LONG_TITLE
|
GRANT_TITLE
|
Grant Title
|
Shortened name or title for the grant.
|
VARCHAR2(255)
|
FRBGRNT
|
FRBGRNT_TITLE
|
ID
|
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
|
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
|
Invoice document number on which this fixed asset was paid.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_INVH_CODE
|
INVOICE_DATE
|
Invoice Date
|
Date of the invoice.
|
DATE
|
FFBMAST
|
FFBMAST_INVH_DATE
|
INVOICE_ITEM
|
Invoice Item
|
Invoice item number on which this fixed asset was ordered.
|
NUMBER
|
FFBMAST
|
FFBMAST_INVC_ITEM
|
IN_SERVICE_DATE
|
IN Service Date
|
Date on which this asset was placed in service.
|
DATE
|
FFBMAST
|
FFBMAST_IN_SERV_DATE
|
LAST_ADJUSTMENT_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
|
Last Inventory Date
|
Date on which this asset was last inventoried.
|
DATE
|
FFBMAST
|
FFBMAST_LAST_INVENTORY_DATE
|
LOCATION
|
Location
|
Identification code of the physical location for the asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_LOCN_CODE_RESP
|
LOCATION_DESC
|
Location Description
|
Extracted description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
LOCATION_STATUS
|
Location Status
|
Status of the Location.
|
VARCHAR2(63)
|
FTVLOCN
|
FTVLOCN_STATUS_IND
|
MAKE
|
Make
|
Make for the fixed asset usually associated with a car.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_MAKE
|
MANUFACTURER
|
Manufacturer
|
Name of the manufacturer for the fixed asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_MANUFACTURER
|
MARKET_VALUE_AMOUNT
|
Market Value Amount
|
Market value amount for this fixed asset.
|
NUMBER
|
FFBMAST
|
FFBMAST_MARKET_AMT
|
METHOD_OF_ACQUISITION
|
Method Of Acquisition
|
Code used to indicate the method used to acquire the asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_ACQM_CODE
|
METHOD_OF_ACQUISITION_DESC
|
Method Of Acquisition Description
|
Description of the method used to acquire the asset.
|
VARCHAR2(255)
|
FFVACQM
|
FFVACQM_DESC
|
METHOD_OF_DISPOSAL
|
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
|
Method Of Disposal Description
|
Disposal method description.
|
VARCHAR2(255)
|
FFVDISP
|
FFVDISP_DESC
|
MODEL
|
Model
|
Model number for the fixed asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_MODEL
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NET_BOOK_VALUE_AMOUNT
|
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 Useful Life
|
Normal usable life expected for the asset.
|
NUMBER
|
FTVASTY
|
FTVASTY_STD_LIFE
|
ORGANIZATION_CODE
|
Organization Code
|
Identification accounting code used for the responsible department.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_ORGN_CODE_RESP
|
ORGANIZATION_DESC
|
Organization Description
|
Extracted description or title associated with the organization code.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
ORGANIZATION_STATUS
|
Organization Status
|
Status of the organization.
|
VARCHAR2(63)
|
FTVORGN
|
FTVORGN_STATUS_IND
|
ORIGINAL_CAPITALIZED_AMOUNT
|
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
|
Original Cost Amount
|
Calculated as the original cost of the asset excluding attachment costs.
|
NUMBER
|
FUNCTION
|
FOKODSF.F_COST_AMT
|
ORIGINATION_TAG_CANCEL_DATE
|
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
|
Origination Tag Number
|
System generated tag number assigned when the asset is acquired.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_OTAG_CODE
|
ORIGINATION_TAG_NUMBER_DATE
|
Origination Tag Number Date
|
Date the system tag number is assigned.
|
DATE
|
FFBMAST
|
FFBMAST_OTAG_DATE
|
ORIGINATION_TAG_NUMBER_OLD
|
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
|
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
|
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
|
Permanent Tag Number Date
|
Date the permanent tag number is assigned to the fixed asset.
|
DATE
|
FFBMAST
|
FFBMAST_PTAG_DATE
|
PERSON_UID
|
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 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
|
Purchase order number on which this fixed asset was ordered.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_POHD_CODE
|
PURCHASE_ORDER_ITEM
|
Purchase Order Item
|
Purchase order item number on which this fixed asset was ordered.
|
NUMBER
|
FFBMAST
|
FFBMAST_PODT_ITEM
|
RECEIVED_DATE
|
Received Date
|
Date the purchase order item was received.
|
DATE
|
FFBMAST
|
FFBMAST_RCHD_DATE
|
RECEIVER
|
Receiver
|
Unique number for the receiving document associated with this asset created in receiving.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_RCHD_CODE
|
REPLACEMENT_VALUE_AMOUNT
|
Replacement Value Amount
|
User-defined replacement value amount for this fixed asset.
|
NUMBER
|
FFBMAST
|
FFBMAST_REPL_AMT
|
SERIAL_NUMBER
|
Serial Number
|
Serial number or vehicle identification number (VIN) for the fixed asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_SERIAL_NUM_VIN
|
SOURCE_DOCUMENT
|
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
|
Source Document Date
|
Date that the source document was created.
|
DATE
|
FFBMAST
|
FFBMAST_DTAG_ACTIVITY_DATE
|
SOURCE_DOCUMENT_SEQ_NUMBER
|
Source Document Sequence 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
|
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
|
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
|
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
|
Subordinate Type Description
|
Deciphers asset subordinate type as a component or attachment relating to the primary tag.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(FFBMAST_SUBORDINATE_TYPE)
|
TITLED_TO
|
Titled To
|
Represents the title-to designation at the institution.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_TTST_CODE
|
TITLED_TO_DESC
|
Titled To Description
|
Name from the titled-to designation.
|
VARCHAR2(255)
|
FFVTTST
|
FFVTTST_DESC
|
TOTAL_NET_BOOK_VALUE_AMOUNT
|
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
|
Total Original Cost Amount
|
Sum of original cost of the asset and attachment costs.
|
NUMBER
|
FUNCTION
|
FOKODSF.F_TOTAL_COST_AMT
|
TRANSFER_DATE
|
Transfer Date
|
Date on which the asset was last transferred.
|
DATE
|
FFBMAST
|
FFBMAST_TRANSFER_DATE
|
USER_STATUS
|
User Status
|
Indicates the current user assigned status for the fixed asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_USER_STATUS_CODE
|
USER_STATUS_DESC
|
User Status Description
|
Retrieves description for asset user status.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
VENDOR_ID
|
Vendor ID
|
User-defined or system generated one-up number of the vendor.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
VENDOR_NAME
|
Vendor Name
|
Extracted name of the vendor that supplied the asset.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
VENDOR_UID
|
Vendor UID
|
System generated unique internal identification number used to access the vendor.
|
NUMBER
|
FFBMAST
|
FFBMAST_VEND_PIDM
|
WORK_IN_PROGRESS_IND
|
Work IN Progress Indicator
|
For assets such as buildings, defines if work is in progress.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_WORK_IN_PROG_IND
|