Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_FIXED_ASSET_ADJUSTMENT

Description Source composite view contains detailed information on the adjustments of fixed assets.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACCOUNTING_SEQUENCE_NUMBER System-generated one-up number associated with an asset accounting record. NUMBER

FFRADJA

FFRADJA_MASA_SEQ_NUM

NO

NO
ACCOUNT_ITEM System-generated one-up number associated with an asset being adjusted in the document. NUMBER

FFRADJA

FFRADJA_ITEM

NO

NO
APPROVAL_IND Indicates the document has met final approval. VARCHAR2(1)

FFBADJH

FFBADJH_APPR_IND

NO

NO
ASSET_AMOUNT Amount entered by the user to determine the sale price of an asset or an adjustment. NUMBER

FFRADJD

FFRADJD_AMT

NO

NO
COMPLETED_IND Indicates the fixed asset adjustment document is complete. VARCHAR2(1)

FFBADJH

FFBADJH_COMPLETE_IND

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DEPRECIATION_ADJUSTMENT_DATE Depreciation adjustment date defaults from the adjustment transaction date for every function processed. DATE

FFBADJH

FFBADJH_DEPR_ADJ_DATE

NO

NO
DISPOSAL Code used to define method of disposal of an asset. VARCHAR2(2)

FFRADJD

FFRADJD_DISP_CODE

NO

NO
DISPOSAL_DESC Disposal method description. VARCHAR2(35)

FFVDISP

FFVDISP_DESC

NO

NO
DISTRIBUTION_PERCENT Percentage of the of the transaction total amount assigned to this accounting distribution. NUMBER

FFRADJA

FFRADJA_PCT

NO

NO
DOCUMENT User-defined or system generated document number. VARCHAR2(8)

FFRADJA

FFRADJA_ADJH_CODE

NO

NO
DOCUMENT_REFERENCE_NUMBER User-defined identification number further identifying this document and linking it to an external reference number. VARCHAR2(15)

FFBADJH

FFBADJH_DOC_REF_NUM

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
EQUITY_ACCOUNT Account code to record asset equity. VARCHAR2(6)

FFRADJA

FFRADJA_ACCT_CODE_CAP_EQUITY

NO

NO
EQUITY_ACCOUNT_DESC Extracted description or title of the associated account. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
EQUITY_ACCOUNT_STATUS Extracted current status of the associated account. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
FISCAL_PERIOD Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14. VARCHAR2(2)

FFRADJA

FFRADJA_PERIOD

NO

NO
FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(4)

FUNCTION

FOFYCNV

NO

NO
FUNCTION_TYPE Function code of the adjustment action used on the asset in the document. VARCHAR2(4)

FFBADJH

FFBADJH_FUNCTION_CODE

NO

NO
METHOD_OF_ACQUISITION Code used to indicate the method used to acquire the asset. VARCHAR2(2)

FFRADJD

FFRADJD_ACQM_CODE

NO

NO
METHOD_OF_ACQUISITION_DESC Description of the method used to acquire the asset. VARCHAR2(35)

FFVACQM

FFVACQM_DESC

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
NET_BOOK_VALUE_AMOUNT Net book value of the asset calculated by the system as asset cost, less depreciation, plus or minus any asset adjustments. NUMBER

FFRADJD

FFRADJD_NET_BOOK_VALUE_AMT

NO

NO
ORIGINATION_TAG_NUMBER System generated tag number assigned when the asset is acquired. VARCHAR2(9)

FFRADJD

FFRADJD_OTAG_CODE

NO

NO
SEQUENCE_NUMBER System-generated one-up number to support split accounting within a document. NUMBER

FFRADJA

FFRADJA_SEQ_NUM

NO

NO
TRANSACTION_AMOUNT Amount of the transaction associated with this particular account distribution. NUMBER

FFRADJA

FFRADJA_AMT

NO

NO
TRANSACTION_AMOUNT_ADJUSTED Actual adjustment amount used with functions for Write-Offs and Sales of Assets. NUMBER

FFRADJA

FFRADJA_ADJ_AMT

NO

NO
TRANSACTION_DATE Date used by the finance system to control posting to the ledgers. DATE

FFBADJH

FFBADJH_TRANS_DATE

NO

NO
TRANSACTION_DESC Accounting transaction description. VARCHAR2(35)

FFBADJH

FFBADJH_DESC

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: