Composite View Source: FFBMAST

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: FFBMAST Finance

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
FFBMAST_ACON_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	CONDITION
FFBMAST_ACQD_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	ACQUISITION_DATE
FFBMAST_ACQM_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	METHOD_OF_ACQUISITION
FFBMAST_ADJ_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	LAST_ADJUSTMENT_DATE
FFBMAST_ASSET_DESC	FFAMAST	AF_FIXED_ASSET_ITEM	ASSET_DESC
FFBMAST_ASTY_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	ASSET_TYPE
FFBMAST_BARCODE_NUM	FFAMAST	AF_FIXED_ASSET_ITEM	BARCODE_NUMBER
FFBMAST_BOOK_AMT	FFAMAST	AF_FIXED_ASSET_ITEM	BOOK_VALUE_AMOUNT
FFBMAST_CAP_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	CAPITALIZATION_DATE
FFBMAST_COAS_CODE_RESP	FFAMAST	AF_FIXED_ASSET_ITEM	CHART_OF_ACCOUNTS
FFBMAST_COMM_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	COMMODITY
FFBMAST_CUSTODIAN_PIDM	NA	AF_FIXED_ASSET_ITEM	PERSON_UID
FFBMAST_DEPR_CODE	FFADEPR	AF_FIXED_ASSET_ITEM	DEPRECIATION_METHOD
FFBMAST_DEPR_FREQ	FFADEPR	AF_FIXED_ASSET_ITEM	DEPRECIATION_FREQUENCY
FFBMAST_DEPR_START_DATE	FFADEPR	AF_FIXED_ASSET_ITEM	DEPRECIATION_START_DATE
FFBMAST_DISP_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	METHOD_OF_DISPOSAL
FFBMAST_DISP_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	DISPOSAL_DATE
FFBMAST_DTAG_ACTIVITY_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	SOURCE_DOCUMENT_DATE
FFBMAST_EQUIP_MGR_PIDM	NA	AF_FIXED_ASSET_ITEM	PERSON_MANAGER_UID
FFBMAST_EST_LIFE_YEARS	FFADEPR	AF_FIXED_ASSET_ITEM	ACTUAL_USEFUL_LIFE_YEARS
FFBMAST_EXT_REF_NUM	FFAMAST	AF_FIXED_ASSET_ITEM	EXTERNAL_REFERENCE_NUMBER
FFBMAST_GIFT_IND	FFAMAST	AF_FIXED_ASSET_ITEM	ASSET_GIFT_IND
FFBMAST_GRNT_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	GRANT_ID
FFBMAST_INS_AMT	FFAMAST	AF_FIXED_ASSET_ITEM	INSURANCE_AMOUNT
FFBMAST_INVC_ITEM	FFAMAST	AF_FIXED_ASSET_ITEM	INVOICE_ITEM
FFBMAST_INVH_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	INVOICE
FFBMAST_INVH_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	INVOICE_DATE
FFBMAST_IN_SERV_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	IN_SERVICE_DATE
FFBMAST_LAST_DEPR_DATE	FFADEPR	AF_FIXED_ASSET_ITEM	LAST_DEPRECIATION_DATE
FFBMAST_LAST_INVENTORY_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	LAST_INVENTORY_DATE
FFBMAST_LOCN_CODE_RESP	FFAMAST	AF_FIXED_ASSET_ITEM	LOCATION
FFBMAST_MAKE	FFAMAST	AF_FIXED_ASSET_ITEM	MAKE
FFBMAST_MANUFACTURER	FFAMAST	AF_FIXED_ASSET_ITEM	MANUFACTURER
FFBMAST_MARKET_AMT	FFAMAST	AF_FIXED_ASSET_ITEM	MARKET_VALUE_AMOUNT
FFBMAST_MODEL	FFAMAST	AF_FIXED_ASSET_ITEM	MODEL
FFBMAST_OLD_LAST_DEPR_DATE	NA	AF_FIXED_ASSET_ITEM	PRIOR_LAST_DEPRECIATION_DATE
FFBMAST_ORGN_CODE_RESP	FFAMAST	AF_FIXED_ASSET_ITEM	ORGANIZATION_CODE
FFBMAST_OTAG_CANCEL_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	ORIGINATION_TAG_CANCEL_DATE
FFBMAST_OTAG_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	ORIGINATION_TAG_NUMBER
FFBMAST_OTAG_CODE_OLD	FFAMAST	AF_FIXED_ASSET_ITEM	ORIGINATION_TAG_NUMBER_OLD
FFBMAST_OTAG_CODE_PRIMARY	FFAMAST	AF_FIXED_ASSET_ITEM	ORIGINATION_TAG_NUMBER_PRIMARY
FFBMAST_OTAG_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	ORIGINATION_TAG_NUMBER_DATE
FFBMAST_OTHER_SRC_DOC_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	SOURCE_DOCUMENT
FFBMAST_OTHER_SRC_DTYP_NUM	FFAMAST	AF_FIXED_ASSET_ITEM	SOURCE_DOCUMENT_TYPE
FFBMAST_OTHER_SRC_SEQ_NUM	FFAMAST	AF_FIXED_ASSET_ITEM	SOURCE_DOCUMENT_SEQ_NUMBER
FFBMAST_OTHER_SRC_SUB_NUM	FFAMAST	AF_FIXED_ASSET_ITEM	SOURCE_DOCUMENT_SUB_NUMBER
FFBMAST_PART_NUM_VEHICLE_TAG	FFAMAST	AF_FIXED_ASSET_ITEM	ADDITIONAL_SERIAL_NUMBER
FFBMAST_PODT_ITEM	FFAMAST	AF_FIXED_ASSET_ITEM	PURCHASE_ORDER_ITEM
FFBMAST_POHD_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	PURCHASE_ORDER
FFBMAST_PTAG_CODE	FFAADJF	AF_FIXED_ASSET_ITEM	PERMANENT_TAG_NUMBER
FFBMAST_PTAG_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	PERMANENT_TAG_NUMBER_DATE
FFBMAST_RCHD_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	RECEIVER
FFBMAST_RCHD_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	RECEIVED_DATE
FFBMAST_REPL_AMT	FFAMAST	AF_FIXED_ASSET_ITEM	REPLACEMENT_VALUE_AMOUNT
FFBMAST_SALVAGE_AMT	FFADEPR	AF_FIXED_ASSET_ITEM	SALVAGE_AMOUNT
FFBMAST_SERIAL_NUM_VIN	FFAMAST	AF_FIXED_ASSET_ITEM	SERIAL_NUMBER
FFBMAST_SUBORDINATE_TYPE	FFAMAST	AF_FIXED_ASSET_ITEM	SUBORDINATE_TYPE
FFBMAST_SYSTEM_STATUS_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	ASSET_STATUS
FFBMAST_TRANSFER_DATE	FFAMAST	AF_FIXED_ASSET_ITEM	TRANSFER_DATE
FFBMAST_TTST_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	TITLED_TO
FFBMAST_USER_STATUS_CODE	FFAMAST	AF_FIXED_ASSET_ITEM	USER_STATUS
FFBMAST_VEND_PIDM	NA	AF_FIXED_ASSET_ITEM	VENDOR_UID
FFBMAST_WORK_IN_PROG_IND	FFAMAST	AF_FIXED_ASSET_ITEM	WORK_IN_PROGRESS_IND

Ver: 8.3