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