RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FFBMAST Finance Composite View Reports
SGHE Operational Data Store Composite View Source: FFBMAST

Source Column Source Form Target Type Target Target Column Calculation Formula
FFBMAST_ACON_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

CONDITION

NA
FFBMAST_ACQD_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ACQUISITION_DATE

NA
FFBMAST_ACQM_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

METHOD_OF_ACQUISITION

NA
FFBMAST_ADJ_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

LAST_ADJUSTMENT_DATE

NA
FFBMAST_ASSET_DESC FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ASSET_DESC

NA
FFBMAST_ASTY_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ASSET_TYPE

NA
FFBMAST_BARCODE_NUM FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

BARCODE_NUMBER

NA
FFBMAST_BOOK_AMT FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

BOOK_VALUE_AMOUNT

NA
FFBMAST_CAP_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

CAPITALIZATION_DATE

NA
FFBMAST_COAS_CODE_RESP FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

CHART_OF_ACCOUNTS

NA
FFBMAST_COMM_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

COMMODITY

NA
FFBMAST_CUSTODIAN_PIDM NA COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

PERSON_UID

NA
FFBMAST_DEPR_CODE FFADEPR COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

DEPRECIATION_METHOD

NA
FFBMAST_DEPR_FREQ FFADEPR COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

DEPRECIATION_FREQUENCY

NA
FFBMAST_DEPR_START_DATE FFADEPR COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

DEPRECIATION_START_DATE

NA
FFBMAST_DISP_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

METHOD_OF_DISPOSAL

NA
FFBMAST_DISP_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

DISPOSAL_DATE

NA
FFBMAST_DTAG_ACTIVITY_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SOURCE_DOCUMENT_DATE

NA
FFBMAST_EQUIP_MGR_PIDM NA COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

PERSON_MANAGER_UID

NA
FFBMAST_EST_LIFE_YEARS FFADEPR COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ACTUAL_USEFUL_LIFE_YEARS

NA
FFBMAST_EXT_REF_NUM FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

EXTERNAL_REFERENCE_NUMBER

NA
FFBMAST_GIFT_IND FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ASSET_GIFT_IND

NA
FFBMAST_GRNT_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

GRANT_ID

NA
FFBMAST_INS_AMT FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

INSURANCE_AMOUNT

NA
FFBMAST_INVC_ITEM FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

INVOICE_ITEM

NA
FFBMAST_INVH_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

INVOICE

NA
FFBMAST_INVH_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

INVOICE_DATE

NA
FFBMAST_IN_SERV_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

IN_SERVICE_DATE

NA
FFBMAST_LAST_DEPR_DATE FFADEPR COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

LAST_DEPRECIATION_DATE

NA
FFBMAST_LAST_INVENTORY_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

LAST_INVENTORY_DATE

NA
FFBMAST_LOCN_CODE_RESP FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

LOCATION

NA
FFBMAST_MAKE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

MAKE

NA
FFBMAST_MANUFACTURER FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

MANUFACTURER

NA
FFBMAST_MARKET_AMT FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

MARKET_VALUE_AMOUNT

NA
FFBMAST_MODEL FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

MODEL

NA
FFBMAST_OLD_LAST_DEPR_DATE NA COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

PRIOR_LAST_DEPRECIATION_DATE

NA
FFBMAST_ORGN_CODE_RESP FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ORGANIZATION_CODE

NA
FFBMAST_OTAG_CANCEL_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ORIGINATION_TAG_CANCEL_DATE

NA
FFBMAST_OTAG_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ORIGINATION_TAG_NUMBER

NA
FFBMAST_OTAG_CODE_OLD FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ORIGINATION_TAG_NUMBER_OLD

NA
FFBMAST_OTAG_CODE_PRIMARY FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ORIGINATION_TAG_NUMBER_PRIMARY

NA
FFBMAST_OTAG_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ORIGINATION_TAG_NUMBER_DATE

NA
FFBMAST_OTHER_SRC_DOC_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SOURCE_DOCUMENT

NA
FFBMAST_OTHER_SRC_DTYP_NUM FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SOURCE_DOCUMENT_TYPE

NA
FFBMAST_OTHER_SRC_SEQ_NUM FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SOURCE_DOCUMENT_SEQ_NUMBER

NA
FFBMAST_OTHER_SRC_SUB_NUM FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SOURCE_DOCUMENT_SUB_NUMBER

NA
FFBMAST_PART_NUM_VEHICLE_TAG FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ADDITIONAL_SERIAL_NUMBER

NA
FFBMAST_PODT_ITEM FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

PURCHASE_ORDER_ITEM

NA
FFBMAST_POHD_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

PURCHASE_ORDER

NA
FFBMAST_PTAG_CODE FFAADJF COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

PERMANENT_TAG_NUMBER

NA
FFBMAST_PTAG_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

PERMANENT_TAG_NUMBER_DATE

NA
FFBMAST_RCHD_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

RECEIVER

NA
FFBMAST_RCHD_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

RECEIVED_DATE

NA
FFBMAST_REPL_AMT FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

REPLACEMENT_VALUE_AMOUNT

NA
FFBMAST_SALVAGE_AMT FFADEPR COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SALVAGE_AMOUNT

NA
FFBMAST_SERIAL_NUM_VIN FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SERIAL_NUMBER

NA
FFBMAST_SUBORDINATE_TYPE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

SUBORDINATE_TYPE

NA
FFBMAST_SYSTEM_STATUS_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

ASSET_STATUS

NA
FFBMAST_TRANSFER_DATE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

TRANSFER_DATE

NA
FFBMAST_TTST_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

TITLED_TO

NA
FFBMAST_USER_STATUS_CODE FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

USER_STATUS

NA
FFBMAST_VEND_PIDM NA COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

VENDOR_UID

NA
FFBMAST_WORK_IN_PROG_IND FFAMAST COMPOSITE VIEW

AF_FIXED_ASSET_ITEM

WORK_IN_PROGRESS_IND

NA


Ver: 3.1